Database import from oscommerce to oscmax --- Error

[chowhan]

After Runing the script that i got from mysqldiff , i have this new error i think i can never get this working already 2 dayds. please some show me a easy way to fix this.

Error
SQL query:
©2001 -2004, Lippe - Net Online - Service

MySQL said:
#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 '© 2001-2004, Lippe-Net Online-Service' at line 1

[tcshadow]

SQL doesn't like apostrophe(') and maybe some other things... I find 99% of my sql syntax errors is an apostrophe that needs to be preceeded by a \


For example Who's needs to be written as who\'s for it to not cause an SQL error.

It may be another character causing the problem though

[tcshadow]

also you haven't removed the default values from your auto_increment entries... that was something i had to do in mine. Don't just sue find/replace though go through and do it manually

[chowhan]

i got it solved but here is a another one , oohhh i dont know may more are there to come still


please see if you can do something


Error
SQL query:
#
# DDL START
#
ALTER TABLE address_book ADD entry_company_tax_id varchar( 32 ) NULL DEFAULT NULL COMMENT '' COLLATE latin1_german1_ci AFTER entry_company

MySQL said:
#1060 - Duplicate column name 'entry_company_tax_id'

[tcshadow]

Originally Posted by chowhan

i got it solved

post what you did so people can search and troubleshoot in the future without asking questions that have been answered.

Originally Posted by chowhan

but here is a another one , oohhh i dont know may more are there to come still

Probably lots but if you persevere you'll get through it and end up learning so don't give up.

as for your last error i'm afraid I've hit my limits so you need to hope Michael_s or someone else who knows more sql can help you out.

[chowhan]

Originally Posted by chowhan

After Runing the script that i got from mysqldiff , i have this new error i think i can never get this working already 2 dayds. please some show me a easy way to fix this.

Error
SQL query:
©2001 -2004, Lippe - Net Online - Service

MySQL said:
#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 '© 2001-2004, Lippe-Net Online-Service' at line 1

ALTER TABLE `zones` ADD `zone_status` tinyint(1) default '1' not null;

[tcshadow]

I mean I understand that your query is telling the table to add a column that already exists... I just don't know how t fix it. if they are already identical you could just skip that query(by deleting it) but I don't know if it's identical.

DO NOT DO THIS UNLESS YOU ARE SURE IT IS OK TO DO AND ALWAYS BACK UP BEFORE RUNNING ANY QUERIES THAT CHANGE THINGS
What "may" work is to delete entry_company_tax_id column from the address_book table and then run that query BUT that will delete any historical data in that column and could break things so I really wouldn't recommend it until you get the OK from someoen who knows what they're doing. i repeat DO NOT DO THIS UNLESS YOU ARE SURE IT IS OK TO DO AND ALWAYS BACK UP BEFORE RUNNING ANY QUERIES THAT CHANGE THINGS

Just to double check you are running this query on your old database right?? sqldiff can be a bit funny to get your head around...

source database is your old database... target database is your new database and then you run the query on the old database. after that you can export the things you need from your old database and import into your new database.

[tcshadow]

Originally Posted by chowhan

After Runing the script that i got from mysqldiff , i have this new error i think i can never get this working already 2 dayds. please some show me a easy way to fix this.

Just out of curiosity how did you manage to try your query for 2 days, then come back in time to make this post less than 1 hour after you got told mysqldiff exists today and posted your query for the first time?

I really could use time travel technology... would do wonders for my income.

if you're gonna tell lies to get help at least make them believable.

[chowhan]

Hi everyone i am still stuck here with the database please someone take out some time to help me out

here is the error what i get when i run the code which i get from mysqldiff


Error
SQL query:
#
# DDL START
#
ALTER TABLE address_book ADD entry_company_tax_id varchar( 32 ) NULL DEFAULT NULL COMMENT '' COLLATE latin1_german1_ci AFTER entry_company

MySQL said:
#1060 - Duplicate column name 'entry_company_tax_id'


What i did was , use mysqldiff and source database is my old database... target database is my new database and then you i the query on the old database.

Please Michael i think you got to help me out man.

[chowhan]

Hi everyone i am still stuck here with the database please someone take out some time to help me out

here is the error what i get when i run the code which i get from mysqldiff


Error
SQL query:
#
# DDL START
#
ALTER TABLE address_book ADD entry_company_tax_id varchar( 32 ) NULL DEFAULT NULL COMMENT '' COLLATE latin1_german1_ci AFTER entry_company

MySQL said:
#1060 - Duplicate column name 'entry_company_tax_id'


What i did was , use mysqldiff and source database is my old database... target database is my new database and then you i the query on the old database.

Please Michael i think you got to help me out man.