Codezwiz >> Forums >> Request a Script >> Need help with mySQL Statement error?

Hello telli.

I didnt know where to post this so I thought I would try here. I seem to have a problem with a script I am trying to make into a module however this SQL statement wont work in phpMyAdmin

This is the mySQL table

/*Begin Create Clients*/
$query = "CREATE TABLE `".DB_PREFIX."clients` (
`client_id` int(11) NOT NULL auto_increment,
`username` varchar(100) NOT NULL default '',
`password` varchar(100) NOT NULL default '',
`company` varchar(255) default NULL,
`email` varchar(255) NOT NULL default '',
`first_name` varchar(100) default '',
`last_name` varchar(100) default '',
`address` varchar(255) default NULL,
`address_2` varchar(100) default '',
`city` varchar(100) default '',
`state` varchar(100) default '',
`zip` varchar(100) default '',
`client_number` int(11) default '',
`phone_number` varchar(100) default '',
`fax_number` varchar(100) default '',
`ptax` double(10,4) NOT NULL default '0.0725',
`p2tax` double(10,4) NOT NULL default '0.1900',
`gtax` double(10,4) NOT NULL default '0.0725',
PRIMARY KEY (`client_id`),
UNIQUE KEY `username` (`username`)
) TYPE=MyISAM;";
mysql_query ($query);

However mySQL is complaining about the following line

MySQL said:

#1067 - Invalid default value for 'client_number'

If anyone could help me it would be appreciated....

xtrax

Change this line from:

`client_number` int(11) default '',

Thank you once again teli,

How much do you charge to make some changes to a piece of software we bought, we would need it to be compatable for php 4 & php 5, plus make it a little more automated with client accounts, such as adding a cron to check when clients should be auto sent a new invoice etc...

xtrax

Send me the details by PM and I will take a look and send you a quote.