OsCommerce Data Importer - Errors

[silkvixen]

just adding that i can view my backup .sql file in notepad++

[skipwater]

Just create a new DB and restore your osc sql file to it. You do not need to have osc installed and running.

Skip

[silkvixen]

Just create a new DB and restore your osc sql file to it. You do not need to have osc installed and running.

Skip

i would but for whatever reason i cant create a 2nd database

[silkvixen]

ok i emailed my provider and they have let me have a 2nd database for a week or so :))

installing now :)

[silkvixen]

ok ive installed it and changed all the files with the info

get to the transfer page and click ok and get a page not found?

[silkvixen]

just adding it comes up with Notice: Undefined index: action in /clientdata/n5200-2-dynamic/s/i/silkycreations.com.au/www/import_osc_customers.php on line 228

sorry about all the posts i just really need to get this done and i really have no idea lol i dont even know if my tables have prefix or not

[skipwater]

Do you get the same error when you try and run import_osc_orders.php or import_osc_products.php?

To see if you are using prefixes open the DB and look at the table names.
If the customer table is listed as:
customers = NO PREFIX
zen_customers = YES PREFIX of zen_

Normally a prefix has a under score at the end of the prefix.

Skip

[silkvixen]

does zen normally use a prefix?

when i look at the list of tables in both databases they are both jsut listed as 'customers' orders' etc

i do get the same error when i try and run all of them

[skipwater]

OK lets see if it is what I think is wrong.

In file import_osc_customers.php find about line 32

// WHEN DONE REMOVE THIS FILE FROM YOUR SERVER !!!!!
// ---------------------------------------------------

And now add these two lines

// WHEN DONE REMOVE THIS FILE FROM YOUR SERVER !!!!!
// ---------------------------------------------------
// Suppress Notice warnings
error_reporting (E_ALL ^ E_NOTICE);

If that works you will need to add it to orders and products also.

Skip

[silkvixen]

ok did that and the error msg went away.... and i got this

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'myzen1096'@'ws-shared-6.private.netregistry.net' (using password: YES) in /clientdata/n5200-2-dynamic/s/i/silkycreations.com.au/www/import_osc_customers.php on line 235
Could not connect: Access denied for user 'myzen1096'@'ws-shared-6.private.netregistry.net' (using password: YES)

ive checked and double checked all the details passwords etc