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

HI all, just did a clean install of 2.0, with bootstrap template. But now every link on the site points to one product! i can't for the life of me think where to look to see why every link sends the clicker to the one item (Skeleton Barbarian)? is this some missed element of the bootstrap template or some other issue? Need to fix it urgently as my shop is useless!

https://heresyminiatures.com/shop

Any ideas appreciated

thanks,
Andy

PS apologies if this is in the wrong section of the forum

Also - had no choice but to do a live install as my previous site was running on 7.4 php and the new site needed 8.0 so just had to install and hope. i swear it was working fine, an hour ago...

Did you previously have Ceon URI Mapping installed? That makes changes to the site's root .htaccess file and *could *explain the unwanted redirects to that single product that you are seeing.

I don't think so - I've only put the Bootstrap template on this one, and then the Big Royal Mail shipping as i'm in the UK - I'll try removing that and see if it changes anything

[11-May-2024 05:32:02 UTC] Request URI: /shop/zcadmin/index.php?cmd=modules&set=shipping&module=rm1stletter, IP address: 81.105.228.234, Language id 1
#1 require(/zcadmin/modules.php) called at [/zcadmin/index.php:11]
--> PHP Warning: Undefined property: rmamteulargeletter::$sort_order in /zcadmin/modules.php on line 224.

[11-May-2024 05:32:02 UTC] Request URI: /shop/zcadmin/index.php?cmd=modules&set=shipping&module=rm1stletter, IP address: 81.105.228.234, Language id 1
#1 require(/zcadmin/modules.php) called at [/zcadmin/index.php:11]
--> PHP Warning: Undefined property: rmamteulargeletter::$sort_order in /zcadmin/modules.php on line 230.

[11-May-2024 05:32:02 UTC] Request URI: /shop/zcadmin/index.php?cmd=modules&set=shipping&module=rm1stletter, IP address: 81.105.228.234, Language id 1
#1 require(/zcadmin/modules.php) called at [/zcadmin/index.php:11]
--> PHP Warning: Undefined property: rmamteuparcel::$sort_order in /zcadmin/modules.php on line 224.

[11-May-2024 05:32:02 UTC] Request URI: /shop/zcadmin/index.php?cmd=modules&set=shipping&module=rm1stletter, IP address: 81.105.228.234, Language id 1
#1 require(/zcadmin/modules.php) called at [/zcadmin/index.php:11]
--> PHP Warning: Undefined property: rmamteuparcel::$sort_order in /zcadmin/modules.php on line 230.

I am seeing a lot fo error logs like this, which mention URI do you think that could be it? Trying to work out how to uninstall Big Royal Mail but I need ti for shipping...

Also seeing this error that mentions URI

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

Could that be the thing causing problems? If so, how do I fix it?

Also this error suggesting a missing table in the database to do with laravel ,

[10-May-2024 14:08:32 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'heresy_shop222.plugin_control' doesn't exist in /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php:414
Stack trace:
#0 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(414): PDO->prepare()
#1 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#2 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#3 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(422): Illuminate\Database\Connection->run()
#4 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#5 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#6 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#7 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#8 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#9 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#10 /home/heresy/public_html/shop222/includes/classes/PluginManager.php(31): Illuminate\Database\Eloquent\Builder->get()
#11 /home/heresy/public_html/shop222/includes/application_top.php(220): Zencart\PluginManager\PluginManager->getInstalledPlugins()
#12 /home/heresy/public_html/shop222/index.php(25): require('/home/heresy/pu...')
#13 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'heresy_shop222.plugin_control' doesn't exist (SQL: select * from `plugin_control` where (`status` = 1)) in /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php:760
Stack trace:
#0 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#1 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(422): Illuminate\Database\Connection->run()
#2 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#3 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#4 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#6 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#7 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#8 /home/heresy/public_html/shop222/includes/classes/PluginManager.php(31): Illuminate\Database\Eloquent\Builder->get()
#9 /home/heresy/public_html/shop222/includes/application_top.php(220): Zencart\PluginManager\PluginManager->getInstalledPlugins()
#10 /home/heresy/public_html/shop222/index.php(25): require('/home/heresy/pu...')
#11 {main}
thrown in /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php on line 760

[10-May-2024 14:08:32 UTC] Request URI: /shop222/, IP address: 92.40.63.100
--> PHP Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'heresy_shop222.plugin_control' doesn't exist in /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php:414
Stack trace:
#0 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(414): PDO->prepare()
#1 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#2 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#3 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(422): Illuminate\Database\Connection->run()
#4 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#5 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#6 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#7 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#8 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#9 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#10 /home/heresy/public_html/shop222/includes/classes/PluginManager.php(31): Illuminate\Database\Eloquent\Builder->get()
#11 /home/heresy/public_html/shop222/includes/application_top.php(220): Zencart\PluginManager\PluginManager->getInstalledPlugins()
#12 /home/heresy/public_html/shop222/index.php(25): require('/home/heresy/pu...')
#13 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'heresy_shop222.plugin_control' doesn't exist (SQL: select * from `plugin_control` where (`status` = 1)) in /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php:760
Stack trace:
#0 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#1 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(422): Illuminate\Database\Connection->run()
#2 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#3 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#4 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#6 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#7 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#8 /home/heresy/public_html/shop222/includes/classes/PluginManager.php(31): Illuminate\Database\Eloquent\Builder->get()
#9 /home/heresy/public_html/shop222/includes/application_top.php(220): Zencart\PluginManager\PluginManager->getInstalledPlugins()
#10 /home/heresy/public_html/shop222/index.php(25): require('/home/heresy/pu...')
#11 {main}
thrown in /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php on line 760.

[10-May-2024 14:08:32 UTC] Request URI: /shop222/, IP address: 92.40.63.100
--> PHP Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'heresy_shop222.plugin_control' doesn't exist in /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php:414
Stack trace:
#0 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(414): PDO->prepare()
#1 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#2 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#3 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(422): Illuminate\Database\Connection->run()
#4 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#5 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#6 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#7 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#8 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#9 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#10 /home/heresy/public_html/shop222/includes/classes/PluginManager.php(31): Illuminate\Database\Eloquent\Builder->get()
#11 /home/heresy/public_html/shop222/includes/application_top.php(220): Zencart\PluginManager\PluginManager->getInstalledPlugins()
#12 /home/heresy/public_html/shop222/index.php(25): require('/home/heresy/pu...')
#13 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'heresy_shop222.plugin_control' doesn't exist (SQL: select * from `plugin_control` where (`status` = 1)) in /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php:760
Stack trace:
#0 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#1 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(422): Illuminate\Database\Connection->run()
#2 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#3 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#4 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#6 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#7 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#8 /home/heresy/public_html/shop222/includes/classes/PluginManager.php(31): Illuminate\Database\Eloquent\Builder->get()
#9 /home/heresy/public_html/shop222/includes/application_top.php(220): Zencart\PluginManager\PluginManager->getInstalledPlugins()
#10 /home/heresy/public_html/shop222/index.php(25): require('/home/heresy/pu...')
#11 {main}
thrown in /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php on line 760.

What parameters do i need to give a new table in the db to fix this? I assume I can't just make a blank table with a name 'plugin_control' and leave it at that?

This one suggests something to do with Laravel - i've reuploaded the laravel files from the install but I assume I have to do something with the database too to add a table called 'plugin_control'?

[10-May-2024 14:08:32 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'heresy_shop222.plugin_control' doesn't exist in /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php:414
Stack trace:
#0 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(414): PDO->prepare()
#1 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#2 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#3 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(422): Illuminate\Database\Connection->run()
#4 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#5 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#6 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#7 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#8 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#9 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#10 /home/heresy/public_html/shop222/includes/classes/PluginManager.php(31): Illuminate\Database\Eloquent\Builder->get()
#11 /home/heresy/public_html/shop222/includes/application_top.php(220): Zencart\PluginManager\PluginManager->getInstalledPlugins()
#12 /home/heresy/public_html/shop222/index.php(25): require('/home/heresy/pu...')
#13 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'heresy_shop222.plugin_control' doesn't exist (SQL: select * from `plugin_control` where (`status` = 1)) in /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php:760
Stack trace:
#0 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#1 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(422): Illuminate\Database\Connection->run()
#2 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#3 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#4 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#6 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#7 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#8 /home/heresy/public_html/shop222/includes/classes/PluginManager.php(31): Illuminate\Database\Eloquent\Builder->get()
#9 /home/heresy/public_html/shop222/includes/application_top.php(220): Zencart\PluginManager\PluginManager->getInstalledPlugins()
#10 /home/heresy/public_html/shop222/index.php(25): require('/home/heresy/pu...')
#11 {main}
thrown in /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php on line 760

[10-May-2024 14:08:32 UTC] Request URI: /shop222/, IP address: 92.40.63.100
--> PHP Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'heresy_shop222.plugin_control' doesn't exist in /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php:414
Stack trace:
#0 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(414): PDO->prepare()
#1 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#2 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#3 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(422): Illuminate\Database\Connection->run()
#4 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#5 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#6 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#7 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#8 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#9 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#10 /home/heresy/public_html/shop222/includes/classes/PluginManager.php(31): Illuminate\Database\Eloquent\Builder->get()
#11 /home/heresy/public_html/shop222/includes/application_top.php(220): Zencart\PluginManager\PluginManager->getInstalledPlugins()
#12 /home/heresy/public_html/shop222/index.php(25): require('/home/heresy/pu...')
#13 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'heresy_shop222.plugin_control' doesn't exist (SQL: select * from `plugin_control` where (`status` = 1)) in /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php:760
Stack trace:
#0 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#1 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(422): Illuminate\Database\Connection->run()
#2 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#3 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#4 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#6 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#7 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#8 /home/heresy/public_html/shop222/includes/classes/PluginManager.php(31): Illuminate\Database\Eloquent\Builder->get()
#9 /home/heresy/public_html/shop222/includes/application_top.php(220): Zencart\PluginManager\PluginManager->getInstalledPlugins()
#10 /home/heresy/public_html/shop222/index.php(25): require('/home/heresy/pu...')
#11 {main}
thrown in /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php on line 760.

[10-May-2024 14:08:32 UTC] Request URI: /shop222/, IP address: 92.40.63.100
--> PHP Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'heresy_shop222.plugin_control' doesn't exist in /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php:414
Stack trace:
#0 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(414): PDO->prepare()
#1 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#2 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#3 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(422): Illuminate\Database\Connection->run()
#4 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#5 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#6 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#7 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#8 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#9 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#10 /home/heresy/public_html/shop222/includes/classes/PluginManager.php(31): Illuminate\Database\Eloquent\Builder->get()
#11 /home/heresy/public_html/shop222/includes/application_top.php(220): Zencart\PluginManager\PluginManager->getInstalledPlugins()
#12 /home/heresy/public_html/shop222/index.php(25): require('/home/heresy/pu...')
#13 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'heresy_shop222.plugin_control' doesn't exist (SQL: select * from `plugin_control` where (`status` = 1)) in /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php:760
Stack trace:
#0 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback()
#1 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php(422): Illuminate\Database\Connection->run()
#2 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2706): Illuminate\Database\Connection->select()
#3 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect()
#4 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns()
#6 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get()
#7 /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels()
#8 /home/heresy/public_html/shop222/includes/classes/PluginManager.php(31): Illuminate\Database\Eloquent\Builder->get()
#9 /home/heresy/public_html/shop222/includes/application_top.php(220): Zencart\PluginManager\PluginManager->getInstalledPlugins()
#10 /home/heresy/public_html/shop222/index.php(25): require('/home/heresy/pu...')
#11 {main}
thrown in /home/heresy/public_html/shop222/laravel/vendor/illuminate/database/Connection.php on line 760.

I have made yet another test site with 2.0 and installed the bootstrap template, and paypal mods, and Big Royal Mail and all links etc are still working. The only essential thing left to install on the test site is Square Webpay; it's taken four hours to do so far and i am dreading it all failing again with this one addition!

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?

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.

--> 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/upgrading/date_standardization/