OsCommerce Data Importer - Errors

[kaddie]

If you have a Shared Hosting account you need, if you don't have already, a 'php.ini' file which is put in your DOCUMENT ROOT dir.

In it, add the following statement:

memory_limit = 16M

Try the above setting and keep doubling till the error msg. goes away.

Skip

Thank you Skip that worked. However It completes exporting but when importing customers I get an sql error noted below.

Importing Customers ...
................................................................................ ................................................................................ .......................................200 -|
................................................................................ ................................................................................ .................................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 '[email protected]', customers_default_address_id = '507', customers_teleph' at line 7

What can I do to dismiss this problem?

Help is appreciated,
Kaddie

[skipwater]

Importing Customers ...
................................................................................ ................................................................................ .......................................200 -|
................................................................................ ................................................................................ .................................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 '[email protected]', customers_default_address_id = '507', customers_teleph' at line 7

What can I do to dismiss this problem?

Do you have Magic Quotes ON?
My guess is that you have magic quotes off.

If this is unknown to you below these two lines about line 320

	// Test access and connect to source data base
	$connected = mysql_connect(
	$dataopened = mysql_select_db(

add this code it will test and set magic quotes

	// Test Magic Quotes
	    if(get_magic_quotes_gpc()) {
	    	echo 'Magic Quotes = ON'; 
        } else {
	    	echo 'Magic Quotes = OFF';
	    	echo '<br />I will turn Magic Quotes ON';
	        set_magic_quotes_runtime(true);
			if(get_magic_quotes_gpc()) {
				echo 'Magic Quotes NOW ON';
			} else {
				echo 'Magic Quotes FAILED';
			}
        }

You should also place the code above this line about 530.

echo 'Starting Importation of osCommerce Data Into <b>'.$target_db.'</b> Zen Cart Data Base<br />';

[kaddie]

Thank you Skip that worked. However It completes exporting but when importing customers I get an sql error noted below.

Importing Customers ...
................................................................................ ................................................................................ .......................................200 -|
................................................................................ ................................................................................ .................................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 '[email protected]', customers_default_address_id = '507', customers_teleph' at line 7

What can I do to dismiss this problem?

Help is appreciated,
Kaddie

My own server stats:

PHP Version: 5.2.8
Database: MySQL 5.0.67

[kaddie]

do you have magic quotes on?
My guess is that you have magic quotes off.

If this is unknown to you below these two lines about line 320

	// test access and connect to source data base
	$connected = mysql_connect(
	$dataopened = mysql_select_db(

add this code it will test and set magic quotes

	// test magic quotes
	    if(get_magic_quotes_gpc()) {
	    	echo 'magic quotes = on'; 
        } else {
	    	echo 'magic quotes = off';
	    	echo '<br />i will turn magic quotes on';
	        set_magic_quotes_runtime(true);
			if(get_magic_quotes_gpc()) {
				echo 'magic quotes now on';
			} else {
				echo 'magic quotes failed';
			}
        }

you should also place the code above this line about 530.

echo 'starting importation of oscommerce data into <b>'.$target_db.'</b> zen cart data base<br />';

the page already has some magic quote info already in it.

[skipwater]

Are the magic quotes on?

You could pm me a couple customer records around the customers_default_address_id = '507' to see what is in the record that the script dislikes.

Skip

[kaddie]

Are the magic quotes on?

You could pm me a couple customer records around the customers_default_address_id = '507' to see what is in the record that the script dislikes.

Skip

I just got thru with installing the orders, products and metatags. All went fine. I am just stuck on the customers. The page I should look at is the admin/customers.php for line 507 correct or maybe not?

Kaddie

[kaddie]

Are the magic quotes on?

You could pm me a couple customer records around the customers_default_address_id = '507' to see what is in the record that the script dislikes.

Skip

Magic quotes are on. I finally got it. Now all info is in zc. There was an apostrophe in that customers email address. I removed it and walla!

Thanks for helping me research the issue.

kaddie

[skipwater]

Glad that it worked out for you.

Skip

[igrossiter]

hi, i'm having the folliwng problem, when i use the import_osc_produtcs.php, i got everything done, but the products don't show on my site, i can see them on the database records, an on the sidebox of my site, but when i click on them, says that the product can't be found. what can i do?
Thank you for the help and sorry about my poor english.

http://casasnossasenhoradosprazeres.com/loja is my zencart store

[skipwater]

hi, i'm having the folliwng problem, when i use the import_osc_produtcs.php, i got everything done, but the products don't show on my site, i can see them on the database records, an on the sidebox of my site, but when i click on them, says that the product can't be found. what can i do?
Thank you for the help and sorry about my poor english.

http://casasnossasenhoradosprazeres.com/loja is my zencart store

The site link you supplied is no good. Could you resubmit the link.

Skip