In the process of updating our site to J4 now we've moved over to Phoca Cart. Using a staging site running J4.0.2 and PhP 8.1.14 and Gantry 5. Everything is fine until the point in checkout when you login - immediately get the error
Exception Type: mysqli_sql_exception
File: /home/rsf96104/rsfstaging.rsf.org.uk/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php
Line: 137
Message: Unknown column 'c.params_shipping' in 'field list'
To test this I've installed the cassiopeia_phocacart_fashion template and set the shop to use that instead but the error persists suggesting a table is missing somewhere
I can use guest checkout with no issue at all, it seems to be tied to the login. If logged in the 'add to cart' button does not function, if not logged in I can add items to the cart as normal.
Bit stuck with this at the moment
Can only use guest checkout
-
- Phoca Newbie
- Posts: 6
- Joined: 19 Nov 2023, 18:26
Re: Can only use guest checkout
Making progress now. Uninstalled Phoca Cart and reinstalled with a set of 'demo' products - works without issue so uninstalled and reinstalled again which gives me a clean (empty) set of tables, again no problems. Copying data only between sets of tables from live to staging databases, currently working and i can add products whether I'm logged in or not and no error logging in in the Phoca checkout.
I'm expecting the error to return at ome point so i should be able to pinpoin the table tha's causing this and fix it.
I'm expecting the error to return at ome point so i should be able to pinpoin the table tha's causing this and fix it.
- Jan
- Phoca Hero
- Posts: 48386
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact: