An old problem with product search inside the administrator panel

[izig]

Hi,

My store suffer from an issue for long time and many version upgrades.
I'm running the latest Joomla - 3.7.5 and Virtuemart - 3.2.4.

While searching for a product I get the following error:
1054 Unknown column 'p.product_sku' in 'where clause'

Will appreciate any suggestion that may assist solving it.

[Jörgen]

Please check:
http://forum.virtuemart.net/index.php?topic=136097.msg474886#msg474886

regards

Jörgen @ Kreativ Fotografi

[Milbo]

Good idea Jörgen, but I doubt that is the problem here, because the product_sku is very old. Maybe it is some 3rd party plugin.

[Jörgen]

Hell Max
You´re probably right, I was a bit quick on this one. Could it have something to do with the words in the search ?
Do you get this every time or only with certain searches ?

If it is just a certain search, what do You search for ?

regards

Jörgen @ Kreativ Fotografi

[Milbo]

In general it is config depended, you can imho disable the sku field. But as far as I know, the sku field is set as standard search field. Furthermore the p. prefix is correct in that sql, imho.

[izig]

Thank you both for looking into this.

Tried Jörgen's advise with no success. Te web serve is running on a virtual machine with 4GB RAM and 4 cores, PHP has 512M allocated. Did not fix the issue.

I'm searching in the "Search Product" and with any search term, the server reply immediately with the error in the first post. So it's not a timeout as well. (the entire site has ~400 products, very small amount)

Will try to uninstall and reinstall the application, then import the database and post the results.

[Milbo]

uninstall? reinstall? for what? We are not in the 80s. Do NOT uninstall. There is absolutly no reason for that.

And even if, then it is absolutly enough to extract the files, to delete the old files and upload the new ones.

[izig]

Hi again, had the time to have a totally new installation of Joomla and Virtuemart on a test server.
Once done, I restored a recent database backup to a new database and point Joomla to the new database and while trying to search for a product, the issue still there

There is nothing copied from the original store as a pure file beside the database import.

Any idea where to start looking for the root cause of this issue?

Thanks

[Milbo]

I can only debug this with access to your server and disabling the joomla debug handling

[izig]

Thanks Milbo, problem solved.
Probably related to the php7.0-mbstring missing installation.