Database Conversion from ZenCart to osCommerce

[RKB]

Hi,

I am in the final stages of converting my database from Zencart to osCommerce and I have two issues that I can not 'see the wood for the tree's', so if you can point me in the right direction I would be gratful.

 

1) When you register and go to login this error appears.

< 1054 - Unknown column 's.public_flag' in 'where clause'

select count(*) as total from orders o, orders_status s where o.customers_id = '164' and o.orders_status = s.orders_status_id and s.language_id = '1' and s.public_flag = '1'

[TEP STOP] >

 

I can not see a s.public_flag in the database.

 

2) In admin / customers this error is sitting on top of the customer list;

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /home/pcu49797/public_html/admin/customers.php on line 733

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/pcu49797/public_html/admin/customers.php on line 735

Warning: reset() [function.reset]: Passed variable is not an array or object in /home/pcu49797/public_html/admin/includes/classes/object_info.php on line 17

Warning: Variable passed to each() is not an array or object in /home/pcu49797/public_html/admin/includes/classes/object_info.php on line 18

 

Then all of the customer details are displayed

[RKB]

Hi,

I am in the final stages of converting my database from Zencart to osCommerce and I have two issues that I can not 'see the wood for the tree's', so if you can point me in the right direction I would be gratful.

 

1) When you register and go to login this error appears.

< 1054 - Unknown column 's.public_flag' in 'where clause'

select count(*) as total from orders o, orders_status s where o.customers_id = '164' and o.orders_status = s.orders_status_id and s.language_id = '1' and s.public_flag = '1'

[TEP STOP] >

 

I can not see a s.public_flag in the database.

 

2) In admin / customers this error is sitting on top of the customer list;

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /home/pcu49797/public_html/admin/customers.php on line 733

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/pcu49797/public_html/admin/customers.php on line 735

Warning: reset() [function.reset]: Passed variable is not an array or object in /home/pcu49797/public_html/admin/includes/classes/object_info.php on line 17

Warning: Variable passed to each() is not an array or object in /home/pcu49797/public_html/admin/includes/classes/object_info.php on line 18

 

Then all of the customer details are displayed

 

 

Hi,

I have resolved all issues with the Database conversion, except one;

In admin / customers this error is sitting on top of the customer list;

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /home/pcu49797/public_html/admin/customers.php on line 733

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/pcu49797/public_html/admin/customers.php on line 735

Warning: reset() [function.reset]: Passed variable is not an array or object in /home/pcu49797/public_html/admin/includes/classes/object_info.php on line 17

Warning: Variable passed to each() is not an array or object in /home/pcu49797/public_html/admin/includes/classes/object_info.php on line 18

 

When I login to Admin and select a Customer from the first screen, all is OK, when I go to Admin / Customers the above error appears. The error does not seem to have any affect on the operation of the site, but it's there.

 

I have confirmed the error is in the database, by swapping Databases between http://www.bwf.com.au and http://www.pcupgrades.net.au

 

If anyone can point me in the right direction I would be thankful

[spooks]

element one is $country which is read just before so is your country table intact? Or have you stopped the read?

[RKB]

element one is $country which is read just before so is your country table intact? Or have you stopped the read?

 

Well I have to say Yes, I have checked and rechecked it, then deleted it and imported the Countries tables from http://www.bwf.com.au which works fine.

[RKB]

Well I have to say Yes, I have checked and rechecked it, then deleted it and imported the Countries tables from http://www.bwf.com.au which works fine.

 

I didn't make it clear that the problem has not gone away.

[♥FWR Media]

I didn't make it clear that the problem has not gone away.

 

Run a print_r() after every tep_db_fetch_array

 

$country = tep_db_fetch_array($country_query); = tep_db_fetch_array($country_query);
die(print_r($country));

 

When you find the sql that is not returning you can then look at the query and run it manually in phpmyadmin to find out where the problem is.

 

e.g. above ..

		$country_query = tep_db_query("select countries_name from " . TABLE_COUNTRIES . " where countries_id = '" . (int)$customers['entry_country_id'] . "'");

 

You might want to put ..

 

die("select countries_name from " . TABLE_COUNTRIES . " where countries_id = '" . (int)$customers['entry_country_id'] . "'");

 

Perhaps you are missing the table defines in admin/includes/database tables or maybe $customers['entry_country_id'] is not set.

 

Good luck