Post by gila » Thu Feb 05, 2009 12:33 am

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

New member

Posts

Joined
Fri Jan 25, 2008 4:33 am

Post by Qphoria » Thu Feb 05, 2009 12:55 am

v1.0 is very new and could probably use some additional testing. It looks like there might be a sql error in the installer.

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by fido-x » Thu Feb 05, 2009 7:49 pm

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`

Image
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!


User avatar
Expert Member

Posts

Joined
Sat Jun 28, 2008 1:09 am
Location - Tasmania, Australia

Post by Daniel » Mon Feb 09, 2009 8:15 am

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.

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm
Who is online

Users browsing this forum: No registered users and 6 guests