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,
Maybe this could be related:
https://forum.virtuemart.net/index.php?topic=136097.msg474886#msg474886 (https://forum.virtuemart.net/index.php?topic=136097.msg474886#msg474886)
Jörgen @ Kreativ Fotografi
Try using the VM admin table updater -> config->tools
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?
Silly question, but Do You have Super Admin rights ?
regards
Jörgen @ Kreativ Fotografi
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,
What PHP version do You use ?
Jörgen @ Kreativ Fotografi
Currently on 7.1.
Thanks
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
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
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.....
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.
Theres a hole in the bucket, dear Eliza...
He can not update the toolaccess ...
Jörgen @ Kreativ Fotografi
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
Quote from: Jörgen on July 13, 2018, 15:42:59 PM
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.
Have backdated to VM 3.2.12 as per instructions, tried changing the 'dangeroustools=0 to 'dangeroustools=1. Both unsuccessful.
Should I spend the time reinstalling Joomla 3.8.8 over FTP or is this not a Joomla problem.
Still unable to backup site, update site, change anything in the VM config etc. When I load the Tools and Migrations page in Virtuemart I get the following messages:
Warning
JFolder::create: Could not create folder.Path: /services
Error
vmError: COM_VIRTUEMART_CANNOT_STORE_CONFIG
JFolder::create: Could not create folder. and failure to store config suggests a server permissions issue.
Go to joomla back end > Site > System information > Folder permissions (tab)
Look at the last line. it should say writeable in green against all folders/files except for configuration.php
Quote from: Jörgen on July 13, 2018, 15:42:59 PM
Theres a hole in the bucket, dear Eliza...
He can not update the toolaccess ...
Jörgen @ Kreativ Fotografi
The update tables process DO NOT NEED the extra check in the config.
I see that now, but neither he nor I knew that :)
Jörgen @ Kreativ Fotografi