Database error?

[Yellow Cherry]

I am receiving the following error when trying to access 'shoppers' or 'shop' areas of Virtuemart - 1054 Unknown column 'u.company' in 'field list'

Also when I try and make a change in 'Configuration' I am directed the to Virtuemart dashboard when I press 'Save and Close' - none of the changes are saved. The error log throws up lots of instances of this - munros-nurseries.co.uk [Tue Jul 10 01:02:40 2018] [error] [client 66.249.64.84:55542] PHP Warning: A non-numeric value encountered in /home/sites/3a/c/ca2fb474ac/public_html/administrator/components/com_virtuemart/plugins/vmpsplugin.php on line 1098

Regards,

[Jörgen]

Maybe this could be related:
https://forum.virtuemart.net/index.php?topic=136097.msg474886#msg474886

Jörgen @ Kreativ Fotografi

[GJC Web Design]

Try using the VM admin table updater -> config->tools

[Yellow Cherry]

Thanks for suggestions. I am being told I need to do the following -  "To use these tools fully, you must check 'Enable database Update tools' in the Configuration panel." Although when I check the 'Enable database Update tools' and press 'Save' I am just directed to the dashboard and the checkbox remains unchecked when I go back and check.

Any ideas on this?

[Jörgen]

Silly question, but Do You have Super Admin rights ?

regards

Jörgen @ Kreativ Fotografi

[Yellow Cherry]

Just checked to confirm, and yes I do.

Its not that I cant complete the actions, its that there is a glitch whenever I press Save I am directed back to the dashboard

Regards,

[Jörgen]

What PHP version do You use ?

Jörgen @ Kreativ Fotografi

[Yellow Cherry]

Currently on 7.1.

Thanks

[Jörgen]

7.2 is ti iffy right now, 7.1 should work, but I have decided to continue with 7.0.

next silly question what VM version and Joomla version, have You updated recently ?

Jörgen @ Kreativ Fotografi

[Yellow Cherry]

Joomla is running on 3.8.8. I cannot update to latest version - when I do I get the following error message.

Akeeba\Engine\Dump\Base :: Database Error: Table 'JOOMLA58e10424.JOOMLA58e10424.w3vj6_virtuemart_adminmenuentries' doesn't exist SQL=SHOW CREATE TABLE `JOOMLA58e10424.w3vj6_virtuemart_adminmenuentries`

This happens when Akeeba automatically backs up before update. This gets to around 25% and fails - I am redirected to the dashobard.

Virtuemart is at 3.2.14.

Thanks for your patience and help

[jenkinhill]

It sounds to me like there is a VirtueMart installation issue. I would suggest you try re-installing VM3.2.12 - don't delete any data or uninstall anything, just reinstall the VM and aio components over the top of the existing installation using Joomla's install manager.   http://forum.virtuemart.net/index.php?topic=123808.0

I assume you have an earlier site backup just in case.....

[jjk]

Perhaps also try if clicking the button 'Install or if necessary update tables' on the VM Tools & Migration view and in the Joomla admin menu 'Menus' > 'Manage' > the  'Rebuild' button cures the problem.

[Jörgen]

Theres a hole in the bucket, dear Eliza...
He can not update the toolaccess  ...

Jörgen @ Kreativ Fotografi

[GJC Web Design]

Just as a note...   sometimes but  rarely updates fail...

I just did a Joomla to 3.8.10 via the updater on a very clean site i know well. After the update the admin was completely mis-rendered - basically lacking any styling with a stupid 500 server error on calling the admin Isis template.css

the file was there, looked fine and replacing it changed nothing.

In the end re-uploading the whole Isis template fixed it so it can only have been file corruption during the update

So I concur with Jenks ...  backup or clone and either update again or replace all the VM files

[jjk]

He can not update the toolaccess  ...

Perhaps alter the 'dangeroustools=0 to 'dangeroustools=1' in ...\administrator\components\com_virtuemart\virtuemart.cfg or directly in the database virtuemart_configs table would solve that.