Error Looking Up Archived Products

Author	« Topic »
RJB Ecommerce Template Expert United Kingdom 794 Posts	Posted - 04/06/2025 : 08:33:05 I'm using v7.7.8 and I'm getting the following error message when looking up archived products in adminprods.php... Unknown column 'pCustom4' in 'SELECT' Warning: Attempt to read property "num_rows" on bool in... A while ago I added some custom product fields to the database. These are working as intended, but I suspect they may be causing this issue. Regards, Richard.
Vince Administrator 42937 Posts	Posted - 04/06/2025 : 22:02:09 Hi Richard Do you have access to phpMyAdmin and could you manually add that column? Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
RJB Ecommerce Template Expert United Kingdom 794 Posts	Posted - 04/07/2025 : 11:46:20 Hi Vince, I didn't realise the custom fields would need to be added separately for the archived products, but I've now done this using phpMyAdmin and it's working. Thanks, Richard.
Vince Administrator 42937 Posts	Posted - 04/08/2025 : 02:36:16 Hi Richard It shouldn't and this has been changed in the latest v7.8 version but this seemed like the easiest workaround. Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
	« Topic »