install problems

[lgdhosting]

hey every time i try to install WHMCS I get error messages when it tries to setup the database. It a new database and every thing some please help me. i sent a tic and they didnt help me they asked if was a new install and will i told them it was.

[nitro]

Hi - do you know what mysql version you have?

 

can you run a query manually with phpmyadmin or mysql command line? something like:

 

CREATE TABLE `tblaccounts` (
 `id` int( 1 ) unsigned zerofill NOT NULL AUTO_INCREMENT ,
 `userid` int( 10 ) unsigned zerofill NOT NULL default "0000000000",
 `gateway` text NOT NULL ,
 `date` datetime default NULL ,
 `description` text NOT NULL ,
 `amountin` decimal( 10, 2 ) NOT NULL default "0.00",
 `fees` decimal( 10, 2 ) NOT NULL default "0.00",
 `amountout` decimal( 10, 2 ) NOT NULL default "0.00",
 `transid` text NOT NULL ,
 `invoiceid` int( 1 ) NOT NULL ,
 PRIMARY KEY ( `id` )
) TYPE = MYISAM;

[nitro]

PS. You might want to trim some of that error text out of your post - it's a little over the top and I think we would get the same idea from the first 10 lines or so!

[lgdhosting]

then what about the admin thing and that

[nitro]

the admin thing and that? I'm confused!

 

did you notice my first response to your question? It seems to be a database problem - all of the error messages you posted were DB related.

 

I'd be checking database server version, as well as database setup / permissions & WHMCS config for the database... although I think you'd be seeing a different error message if it was an incorrect user name / password to access the DB.

[lgdhosting]

it says every thing passes at the start of install

[nitro]

ok - so back to my first question, if you access the database with phpmyadmin using the user name and password you used for whmcs db setup, can you run the query I posted successfully?