Database import from oscommerce to oscmax --- Error

[tcshadow]

Maybe if you post that same post one more time.

[chowhan]

Sorry but i can not explain how i have been waiting that someone can help me solve , i know everyone is in hurry , i also have my website down and now i will get it back working soon with oscmax magic. i will wait but hope that someone can really fix my problem so that i can have atleast the shop running.

michael was online and i thought that he will solve this problem but i think he is too busy.

Originally Posted by tcshadow

Maybe if you post that same post one more time.

[tcshadow]

you are having a database problem... for an alternate path I would seuggest trying the folks over at MySQL :: The world's most popular open source database or another database forum dealing with SQL they may be able to help you much faster.

[rkah]

ok if thats where the statment is stopping and thats all that is in that statement, the column exists already! so cut and past everything AFTER that statement and try to run that code. If you keep running the same DDL statement over and over it will always error out. Im afraid to speak any further on your situation if you are unable to atleast grasp some basic knowledge of SQL. You could really foul the whole deal up if you are not careful and watch which database you are toying with.
DDL -Data Definition LANGUAGE.
That statement is good for running 1 time and only once, because after it alters the table it wont work any more without DELETING the field in the table first. If it has created the field in the table then delete that block out of your DDL statement script. Are you running this inside PHP Admin, or through a command prompt?

[chowhan]

Originally Posted by rkah

ok if thats where the statment is stopping and thats all that is in that statement, the column exists already! so cut and past everything AFTER that statement and try to run that code. If you keep running the same DDL statement over and over it will always error out. Im afraid to speak any further on your situation if you are unable to atleast grasp some basic knowledge of SQL. You could really foul the whole deal up if you are not careful and watch which database you are toying with.
DDL -Data Definition LANGUAGE.
That statement is good for running 1 time and only once, because after it alters the table it wont work any more without DELETING the field in the table first. If it has created the field in the table then delete that block out of your DDL statement script. Are you running this inside PHP Admin, or through a command prompt?

i am Runing the script with phpmyadmin

ok i will recreate 2 new databases , oscold and oscmax and then run this script there , after if i get the error you want me to just run the rest part without the error part Right ?

[rkah]

if you recreate the 2 databases, make 2 copies of the oscommerce one call oscold, oscnew. DO NOT recreate the oscnew from the OSCMAX script in the install folder....I bet dollars to donuts thats where you've gone wrong.. The SQLDIFF app creates the updates needed to make the database into OSCMAX.

[JohnW]

I got your PM asking for help and I read through this thread. I have a few suggestions for you. First, pay someone to do your database conversion so you can put your time into other areas and not be so stressed over this as it's not productive. Also, you don't want to find some problem in your database down the road after its grown. I suggest contacting Michael to see what he would charge you because he's very familiar with this. You'll be better off long term and you can put your effort into other aspects of your site.

Second, you're going to encounter problems down the road so don't just burn up all your questions at once like you are doing on this thread. Searching and reading takes a lot of time but it's the only way you'll make it over time and look for other sources for info besides these forums.

Just my two cents but you asked me for help.

[chowhan]

Ok everyone After 3 days and paying $30 to convert the database i am one step ahead. But still with some error in catalog and admin.

Error 1. I get the Categorias in the infobox but when i click on any link it give me this error ...

1054 - Unknown column 'cd.categories_heading_title' in 'field list'

select cd.categories_name, cd.categories_heading_title, cd.categories_description, c.categories_image from categories c, categories_description cd where c.categories_id = '30' and cd.categories_id = '30' and cd.language_id = '3'

[TEP STOP]


Error 2. In ADMIN , Clicking On Some Links i get this error

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 'limit 0, 10' at line 1


In admin/Catalog/Manufacturers it says

Manufacturers 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 'limit 0, 10' at line 1

select manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified from manufacturers order by manufacturers_name limit 0, 10 limit 0, 10

[TEP STOP]



AND
******************************

Reviews 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 'limit 0, 10' at line 1

select reviews_id, products_id, date_added, last_modified, reviews_rating from reviews order by date_added DESC limit 0, 10 limit 0, 10

[TEP STOP]



and this one also


1146 - Table 'DB381514.customers_groups' doesn't exist

select customers_group_name, customers_group_id from customers_groups order by customers_group_id

[TEP STOP]


********************

Cross-Sell (X-Sell) Admin 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 'limit 0, 10' at line 1

select p.products_id, p.products_model, pd.products_name, p.products_id from products p, products_description pd where p.products_id = pd.products_id and pd.language_id = "1" order by p.products_id asc limit 0, 10 limit 0, 10

[TEP STOP]



***********************


Customers Search: 1146 - Table 'DB381514.customers_groups' doesn't exist

select count(*) as total from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id left join customers_groups cg on c.customers_group_id = cg.customers_group_id

[TEP STOP]
*****************************


Countries 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 'limit 0, 10' at line 1

select countries_id, countries_name, countries_iso_code_2, countries_iso_code_3, address_format_id from countries order by countries_name limit 0, 10 limit 0, 10

[TEP STOP]






And a lot more similar error with different link.


Can someone Please explain me why is this happening, and what is the solve os this problem , please i am not an expert so please try to explain.

Thanks
Regards
Chowhan