skipwater:

Look at you orders table in the OSC database with phpMyAdmin around records 8410 up and see if there is bad data in one of the records.

Skip

Is there anything I should look for?

Also assuming at record 8400, that would probably be around the same actualy sales order number, right?

Since I do not know exactly what I'm looking for this is what I did in myphpadmin.

in the orders table, it shows 30 records each for each page. So I took 8400 divided by 30 and got 280, which would mean i go to page 280. Just as a precaution I went to page 275 and went through 290 real quick but again, i do not know what to look for.

There are names with ' like O'reilly but that cannot be it since some of the earlier records have names with that symbol.

international addresses but that can't be it.

here is the structure of the orders table that i have

 orders_id  	int(11) 	  	  	No  	  	auto_increment  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 customers_id  	int(11) 	  	  	No  	0  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 customers_name  	varchar(64) 	latin1_swedish_ci 	  	No  	  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 customers_company  	varchar(32) 	latin1_swedish_ci 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 customers_street_address  	varchar(64) 	latin1_swedish_ci 	  	No  	  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 customers_suburb  	varchar(32) 	latin1_swedish_ci 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 customers_city  	varchar(32) 	latin1_swedish_ci 	  	No  	  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 customers_postcode  	varchar(10) 	latin1_swedish_ci 	  	No  	  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 customers_state  	varchar(32) 	latin1_swedish_ci 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 customers_country  	varchar(32) 	latin1_swedish_ci 	  	No  	  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 customers_telephone  	varchar(32) 	latin1_swedish_ci 	  	No  	  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 customers_email_address  	varchar(96) 	latin1_swedish_ci 	  	No  	  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 customers_address_format_id  	int(5) 	  	  	No  	0  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 delivery_name  	varchar(64) 	latin1_swedish_ci 	  	No  	  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 delivery_company  	varchar(32) 	latin1_swedish_ci 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 delivery_street_address  	varchar(64) 	latin1_swedish_ci 	  	No  	  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 delivery_suburb  	varchar(32) 	latin1_swedish_ci 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 delivery_city  	varchar(32) 	latin1_swedish_ci 	  	No  	  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 delivery_postcode  	varchar(10) 	latin1_swedish_ci 	  	No  	  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 delivery_state  	varchar(32) 	latin1_swedish_ci 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 delivery_country  	varchar(32) 	latin1_swedish_ci 	  	No  	  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 delivery_address_format_id  	int(5) 	  	  	No  	0  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 billing_name  	varchar(64) 	latin1_swedish_ci 	  	No  	  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 billing_company  	varchar(32) 	latin1_swedish_ci 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 billing_street_address  	varchar(64) 	latin1_swedish_ci 	  	No  	  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 billing_suburb  	varchar(32) 	latin1_swedish_ci 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 billing_city  	varchar(32) 	latin1_swedish_ci 	  	No  	  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 billing_postcode  	varchar(10) 	latin1_swedish_ci 	  	No  	  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 billing_state  	varchar(32) 	latin1_swedish_ci 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 billing_country  	varchar(32) 	latin1_swedish_ci 	  	No  	  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 billing_address_format_id  	int(5) 	  	  	No  	0  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 payment_method  	varchar(32) 	latin1_swedish_ci 	  	No  	  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 cc_type  	varchar(20) 	latin1_swedish_ci 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 cc_owner  	varchar(64) 	latin1_swedish_ci 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 cc_number  	varchar(32) 	latin1_swedish_ci 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 cc_expires  	varchar(4) 	latin1_swedish_ci 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 ip_order_no  	varchar(30) 	latin1_swedish_ci 	  	No  	  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 ip_requested_by  	varchar(30) 	latin1_swedish_ci 	  	No  	  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 ip_contact_person  	varchar(30) 	latin1_swedish_ci 	  	No  	  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 last_modified  	datetime 	  	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 date_purchased  	datetime 	  	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 orders_status  	int(5) 	  	  	No  	0  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 orders_date_finished  	datetime 	  	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 currency  	char(3) 	latin1_swedish_ci 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 currency_value  	decimal(14,6) 	  	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 ipaddy  	varchar(15) 	latin1_swedish_ci 	  	No  	  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 ipisp  	varchar(15) 	latin1_swedish_ci 	  	No  	  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext
 google_order_id  	varchar(255) 	latin1_swedish_ci 	  	Yes  	NULL  	  	Change 	Drop 	Primary 	Index 	Unique 	Fulltext

The bad data would show as graphic symbols within the data.

If you want export the OSC
Orders
Orders Products
Orders Products Attributes
Orders Products Download
Orders Status
Orders Status History
Orders Total
Currencies
to a sql file and zip it. Then PM me where I can download it from and I will look at it for you and convert it to zc.

Skip

Is there a way to record a log file?

skipwater:

The bad data would show as graphic symbols within the data.

If you want export the OSC
Orders
Orders Products
Orders Products Attributes
Orders Products Download
Orders Status
Orders Status History
Orders Total
Currencies
to a sql file and zip it. Then PM me where I can download it from and I will look at it for you and convert it to zc.

Skip

First thanks for all your help. Secondly i used putty to do a mysqldump and the file is 300megs. I dont know how to do just part of it.
Now in phpmyadim you can back up sections of the database but just the order tables and order history tables are so big myphoadim times out.
I will try it again though

great it is timing out on trying to gzip just the orders table alone, ugh.

I apologize, I know you are trying your best to help but I am not allowed to send you the SQL files as they have customer data in them and the bosses won't let me.

I did find these but I do not think they are weird characters

éöíü

What I did was open each SQL table file in NOTEPAD and worked backwards in finding those non standard characters.

I basically did a REPLACE. i.e. replacing all instances of "a" "b" "c" with a non space so it was basically deleted until all alphanumeric characters were removed and those above were left.

But I don't think they are the problem are they?

I went to our old current production server and did a search for those characters and found them. MySQL 4.XX.

Now I went to the new database that I'm trying to import into ZEN and did a search and for some reason MySQL 5.X.X doesn't find them. I think it disregards the weird characters above the letters hence not finding them?

Either way I think I'm looking way too deep into this.

I think maybe there are just too many records for the script to handle.

If there was only a way to log the ERROR!

ok i checked records starting at 8400 -8429 in each of the tables

in orders table for one of the customers i have a phone number in the format of 971505959543 but it is an internation customer

that;s all thats weird i found in those tables, that's it.

Because you are having a issue with timeout maybe you can change max_execution_time in php.ini file and at the same time increase the memory size for php.

max_execution_time = 120     ; Maximum execution time of each script, in seconds
max_input_time = 120	; Maximum amount of time each script may spend parsing request data
memory_limit = 256M      ; Maximum amount of memory a script may consume (16MB)

Skip

skipwater:

Because you are having a issue with timeout maybe you can change max_execution_time in php.ini file and at the same time increase the memory size for php.

max_execution_time = 120 ; Maximum execution time of each script, in seconds
max_input_time = 120 ; Maximum amount of time each script may spend parsing request data
memory_limit = 256M ; Maximum amount of memory a script may consume (16MB)

> 
> Skip

That did it.

Quick question though.  this was a test run and it was successful but I'll need to do it again as our production server is constantly being updated with new orders, etc. etc. etc. etc.

So if I run this again will it wipe everything out and redo it?  Or do I need to manually wipe out the new database stuff.

Thanks again for a great mod!

Quick question though. this was a test run and it was successful but I'll need to do it again as our production server is constantly being updated with new orders, etc. etc. etc. etc.

So if I run this again will it wipe everything out and redo it? Or do I need to manually wipe out the new database stuff.

Yes the mod will delete what is there and replace it with the new data.

Skip

Again thank you for an awesome mod.

But another question since this is somewhat related.

I had three categories set up to where they show on the side, no problem there.

But the three main categories that should be in the middle of the screen in the main page above "what's new for month of january or whatever it is" is gone.

zen-cart 1.39h
with osCommerce To Zen Cart Customer Data Importer v2.0

When I try to import I get this page, and it spits out those errors. Why? How can I fix this problem . Help please :-)

=======================
osCommerce To Zen Cart Customer Data Importer v2.0
Source osCommerce Database Target ZenCart Database
osC Server/Host Name-- localhost ZenCart Server/Host Name -- localhost
osC Database Name -- metre_aquaspor ZenCart Database Name -- metre_below
osC DB Username -- metre_aquaspor ZenCart DB Username -- metre_10metre
osC DB Password -- GS123XXnUB ZenCart DB Password -- ben123XX10
osC DB Table Prefix -- NO Table Prefix ZenCart DB Table Prefix -- NO Table Prefix

Exporting Customers ...

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/metre/public_html/tmp/import_osc_customers.php on line 330

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/metre/public_html/tmp/import_osc_customers.php on line 354
0 -|

Records Exported 0

Importing Customers ...
0 -|

Records Imported 0

Exporting Address Book ...

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/metre/public_html/tmp/import_osc_customers.php on line 416

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/metre/public_html/tmp/import_osc_customers.php on line 440
0 -|

Records Exported 0

Importing Address Book ...
0 -|

Records Imported 0

Exporting Customers Info ...

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/metre/public_html/tmp/import_osc_customers.php on line 502

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/metre/public_html/tmp/import_osc_customers.php on line 523
0 -|

Records Exported 0

Importing Customers Info ...
0 -|

Records Imported 0

Exporting Zones ...
0 -|

Records Exported 0

Importing Zones ...
0 -|

Done 0 Records Imported

Records Imported 0

Exporting Zones to GEO Zones ...
0 -|

Records Exported 0

Importing Zones to GEO Zones ...
0 -|

Done 0 Records Imported

Records Imported 0

willie bee:

Again thank you for an awesome mod.

But another question since this is somewhat related.

I had three categories set up to where they show on the side, no problem there.

But the three main categories that should be in the middle of the screen in the main page above "what's new for month of january or whatever it is" is gone.

Check this out https://www.zen-cart.com/tutorials/index.php?article=4
Skip

oavs:

zen-cart 1.39h
with osCommerce To Zen Cart Customer Data Importer v2.0

When I try to import I get this page, and it spits out those errors. Why? How can I fix this problem . Help please :-)

That warning is due to one or more of these:

* Failed to connect to database server.
* Failed to select database.

Double Check your database information.

Skip

skipwater:

Check this out https://www.zen-cart.com/tutorials/index.php?article=4
Skip

Thanks but I don't see a selection for that.

I have MAINCAT1, MAINCAT2, MAINCAT3 ON THE SIDE CATEGORIES BOX. BUT ABOVE NEW PRODUCTS FOR MARCH, THEY ARE NOT THERE.

sorry for the off topic. it was there before the database transfer and that is how it was set up on the old site so i figured something got fubared during.

Also I THINK this is related

Under Admin > Categories > Categories/Products I get this in red at the bottom

WARNING: You have Products in the Top Level Category. This will cause pricing to not work properly in the Catalog. Products found: 1

I don't see any products

willie bee:

Also I THINK this is related

Under Admin > Categories > Categories/Products I get this in red at the bottom

WARNING: You have Products in the Top Level Category. This will cause pricing to not work properly in the Catalog. Products found: 1

I don't see any products

Look at this post and see if it helps http://www.zen-cart.com/forum/showthread.php?t=84752

Also if you use google to search the forum it works better.
example: NEW PRODUCTS FOR MARCH

Skip

skipwater:

Look at this post and see if it helps http://www.zen-cart.com/forum/showthread.php?t=84752

Also if you use google to search the forum it works better.
example: NEW PRODUCTS FOR MARCH

Skip

Oh I understand what you're saying but that is not what I'm talking about. I dont' care about the New products .

The MAIN categories that show on the categories box on the left, they should show up on the middle of the screen and under that shows the new products for whatever month.

the main products categories are not showing up. that is what i'm talking about. it happened after the database transfer.