Hi
I recently updated a store to v6.7 and all seemed OK, but now my client cannot see product details in the control panel and an error message "Table 'xxx.manufacturer' doesn't exist Unknown column 'pSearchCriteria' in 'field list'" - and when I look in phpMyAdmin it is indeed missing.
The panel says that it is v6.7.0 and the server is running PHP 5.6.17. Is that adequate? I'm sure that it was working previously.
Any ideas?
Thanks
Eric Lewis

Hi Eric

I would run the updatestore file again and that will create any missing tables.

Andy

Please feel free to review / rate our software

Hi Andy
I've done that and it's exactly the same. This isn't making any sense. I must be missing something?
Eric Lewis

Also when I choose 'modify', I get to the adminprods.php page and it says You are modifying the product "". The only fields that are filled are the image fields.
Eric Lewis

Do you get a success message after running updatestore.php?

Andy

Please feel free to review / rate our software

Hi Andy
Yes I did - all seemed OK.
But as far as I can see the store doesn't use a table called manufacturer, so I can't see where the error message "Table 'xxx.manufacturer' doesn't exist.." comes from.
Eric

Could it be no all files were copied over and a page is trying to reference the manufacturer table that no longer exists?

Andy

Please feel free to review / rate our software

Hi Andy
Yes that's possible. It's a 3rd party hosted site and I am having problems with FTP - some files just won't upload and it may be that the new vsadmin files didn't upload correctly and failed to notify me. I'll try and check it out.
Eric

Looking at it again, I'm pretty sure that is the problem as the manufacturer table was removed around version 6.7 or just before and there appear to be files still trying to reference it.

Andy

Please feel free to review / rate our software