What do this mean: 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 '\"NO_AUTO_VALUE_ON_ZERO\"' at line 1
I cannot get the software to install it keep giving me this error.
I removed that line now I get this error: 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 '\'\', `lastname` varchar(32) collate utf8_unicode_ci NOT NULL default \'\', ' at line 5
there are no bugs in the sql!
it works for everyone else. this is down to how your server is configured!
try installing wamp on your pc and test it from there. then phone your host and find out why the mysql is not configured properly.
it works for everyone else. this is down to how your server is configured!
try installing wamp on your pc and test it from there. then phone your host and find out why the mysql is not configured properly.
OpenCart®
Project Owner & Developer.
this is the information I got from my PHPMYADMIN
MySQL
Server: Localhost via UNIX socket
Server version: 5.1.30
Protocol version: 10
User:@localhost
MySQL charset: UTF-8 Unicode (utf8)
Web server
cpaneld
MySQL client version: 4.1.22
PHP extension: mysql
phpMyAdmin
Version information: 3.2.4
Documentation
Wiki
MySQL
Server: Localhost via UNIX socket
Server version: 5.1.30
Protocol version: 10
User:@localhost
MySQL charset: UTF-8 Unicode (utf8)
Web server
cpaneld
MySQL client version: 4.1.22
PHP extension: mysql
phpMyAdmin
Version information: 3.2.4
Documentation
Wiki
I have been corresponding with the host, by the way is Hostgator, they seem to think its an issue with the install script, and want to know if I want them to attempt to import manually. Quote "If you'd like us to proceed with this, please confirm. Thank you." Can it be import manually?
To make sure I was uploading the files in Binary mode, I delete all the files and folders and uploaded all fresh files in the Binary mode, and I still got this error. 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 '\'\', `lastname` varchar(32) collate utf8_unicode_ci NOT NULL default \'\', ' at line 5. I already import manually, that didn't work either.
Who is online
Users browsing this forum: No registered users and 17 guests
