Page 1 of 1
Error during installation
Posted: Thu Feb 05, 2009 12:33 am
by gila
hi everybody i'm tryng to install the 1.0 version and i have this error after the section where i put the database data:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0'', `company` varchar(32) collate utf8_unicode_ci default NULL, `firstnam' at line 3
i use wamp with php 5.2.5 mysql 5.0.45.
what can i do?
thx
Re: Error during installation
Posted: Thu Feb 05, 2009 12:55 am
by Qphoria
v1.0 is very new and could probably use some additional testing. It looks like there might be a sql error in the installer.
Re: Error during installation
Posted: Thu Feb 05, 2009 7:49 pm
by fido-x
gila wrote:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0'', `company` varchar(32) collate utf8_unicode_ci default NULL, `firstnam' at line 3
Looks more like a typo --
`firstnam` should be
`firstname`
Re: Error during installation
Posted: Mon Feb 09, 2009 8:15 am
by Daniel
ok i'm assuming this part is causing the errors:
Code: Select all
DROP TABLE IF EXISTS `address`;
CREATE TABLE `address` (
`address_id` int(11) NOT NULL auto_increment,
`customer_id` int(11) NOT NULL default '0',
`company` varchar(32) collate utf8_unicode_ci default NULL,
`firstname` varchar(32) collate utf8_unicode_ci NOT NULL default '',
`lastname` varchar(32) collate utf8_unicode_ci NOT NULL default '',
`address_1` varchar(64) collate utf8_unicode_ci NOT NULL default '',
`address_2` varchar(64) collate utf8_unicode_ci default NULL,
`postcode` varchar(10) collate utf8_unicode_ci NOT NULL default '',
`city` varchar(32) collate utf8_unicode_ci NOT NULL default '',
`country_id` int(11) NOT NULL default '0',
`zone_id` int(11) NOT NULL default '0',
PRIMARY KEY (`address_id`),
KEY `customer_id` (`customer_id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
I can not see how it is causing an error though.