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
Looks more like a typo -- `firstnam` should be `firstname`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
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool
If you're not living on the edge ... you're taking up too much space!
ok i'm assuming this part is causing the errors:
I can not see how it is causing an error though.
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.
OpenCart®
Project Owner & Developer.
Who is online
Users browsing this forum: No registered users and 23 guests
