Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Database Conversion from ZenCart to osCommerce


RKB

Recommended Posts

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

Cheers

 

Ron

 

The Crew rowing the boat, don't rock it !

Link to comment
Share on other sites

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

Cheers

 

Ron

 

The Crew rowing the boat, don't rock it !

Link to comment
Share on other sites

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

Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Link to comment
Share on other sites

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.

Cheers

 

Ron

 

The Crew rowing the boat, don't rock it !

Link to comment
Share on other sites

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.

Cheers

 

Ron

 

The Crew rowing the boat, don't rock it !

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...