Database problems after move and upgrade

[RodG]

Rod - I appreciate the response. It may be dangerous, but I currently have a site that's not working. I don't know what to do, and I don't know if that will fix the problem. All of the data (good and bad) is backed up, so it's at least something that might be worth trying to see if that works.

The *safe* thing to do would be to drop the entire database and replace it with the most current backup of the original site.

Yes, I realise that it is from a different version of ZenCart, but all being well the new zencart version will detect that it's an old version DB and give you the option to update it.

This would certainly be the approach I'd be taking rather than run the risk of getting a mish mash of table data.

Cheers
RodG

[TKPope]

I emptied all of the orders tables and imported good data for those tables. When I tried placing an order, the following debug file was created:

[13-Mar-2015 03:48:15 UTC] PHP Fatal error: 2013:Lost connection to MySQL server during query :: select p.products_id, p.products_image
from zen_orders_products opa, zen_orders_products opb, zen_orders o, zen_products p
where opa.products_id = '2133'
and opa.orders_id = opb.orders_id
and opb.products_id != '2133'
and opb.products_id = p.products_id
and opb.orders_id = o.orders_id
and p.products_status = 1
group by p.products_id
order by o.date_purchased desc
limit 6 ==> (as called by) /store/includes/modules/also_purchased_products.php on line 16 <== in /store/includes/classes/db/mysql/query_factory.php on line 155

Still having the same problem with incrementing the orders_id. Even though I asked for the next number to be 12000, it still came in as 0 (zero). I have a feeling this is due to some other coding issue and not a database problem after all. I just don't know where to look and fix.

[TKPope]

In fact, orders_id has no record of this order at all. It is not recorded in the database. So, whatever is going on, orders_id is not being incremented nor is it being recorded.

[RodG]

Still having the same problem with incrementing the orders_id. Even though I asked for the next number to be 12000, it still came in as 0 (zero). I have a feeling this is due to some other coding issue and not a database problem after all. I just don't know where to look and fix.

I really wish I could help more, but since you choose to try to keep doing it your way rather than the way I suggested (and would do if I were in your position) there really isn't much more than I can say, other than you probably missed one of the needed tables.

Cheers
RodG