Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Moving site to new host, cannot upload DB?


Guest

Recommended Posts

Posted

I've tried the bug fix, split_page_results.php, to no avail as I am still getting this error when i try to upload the db:

 

MySQL said: Documentation

#1064 - 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 'address_book`

--

 

CREATE TABLE `address_book` (

`address_book_id` int(11) NOT ' at line 1

 

It is also asking for a "SQL compatibility mode" before I upload, which I have no idea. It's PHP Version: 4.3.2 if that helps?

 

I followed the installation instructions and everything worked great, except for the products being uploaded:

 

http://eastern2.u219.otnweb.com/catalog/index.php

 

is supposed to be this:

 

http://www.easternwatchla.com

 

Thanks!

Posted

different versions of mysql can cause the problem, the easy solution is use the phpmyadmin or similar utility.

Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here!

8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself.

Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues.

Any issues with oscommerce, I am here to help you.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...