2.0 Clean install - but all links point to one product!

[Heresy Miniatures]

Seven hours so far this morning.
I have two sites on the go - the main site and the test site.

- The main site /shop/ refuses to work, all links point to the one product.
- The test site /shop2/ seems to work fine, all the links work, BUT if I change the test site intot he main site and update the 2 configure files accordingly, it immediately suffers the same problem - all links point to the one product. if I change it back to /shop2/ all links work as normal.

However, when I try to log in, the site crashes and i get this error log thrown up:

[11-May-2024 11:31:58 UTC] Request URI: /shop2/index.php?main_page=login&action=process, IP address: 81.105.228.234, Language id 1
#0 [internal function]: zen_debug_error_handler()
#1 /includes/classes/db/mysql/query_factory.php(714): trigger_error()
#2 /includes/classes/db/mysql/query_factory.php(659): queryFactory->show_error()
#3 /includes/classes/db/mysql/query_factory.php(299): queryFactory->set_error()
#4 /includes/classes/Customer.php(208): queryFactory->Execute()
#5 /includes/modules/pages/login/header_php.php(104): Customer->login()
#6 /index.php(35): require('/home/heresy/pu...')
--> PHP Fatal error: MySQL error 1054: Unknown column 'last_login_ip' in 'field list' :: UPDATE customers
SET last_login_ip = '81.105.228.234'
WHERE customers_id = 1 ==> (as called by) /includes/classes/Customer.php on line 208 <== in /includes/classes/db/mysql/query_factory.php on line 714.

How do I fix this, please?

[lat9]

You have some kind of re-direct set up somewhere. You could try posting the root (not /shop or /shop2) .htaccess file to see if anybody sees an issue there.

[swguy]

> --> PHP Fatal error: MySQL error 1054: Unknown column 'last_login_ip' in 'field list' :: UPDATE customers

This was an update made in Zen Cart 1.5.8. Sounds like you didn't run zc_install when you did your upgrade... or perhaps you did and got an error that prevented it from completing.

Try re-loading your backup database, running zc_install again and looking for logs, or check this to see if you have this issue:

https://docs.zen-cart.com/user/upgra...andardization/