VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: Yellow Cherry on July 10, 2018, 11:11:13 AM

Title: Database error?
Post by: Yellow Cherry on July 10, 2018, 11:11:13 AM
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,
Title: Re: Database error?
Post by: Jörgen on July 10, 2018, 11:22:40 AM
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
Title: Re: Database error?
Post by: GJC Web Design on July 10, 2018, 23:31:28 PM
Try using the VM admin table updater -> config->tools
Title: Re: Database error?
Post by: Yellow Cherry on July 11, 2018, 10:21:19 AM
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?
Title: Re: Database error?
Post by: Jörgen on July 11, 2018, 10:27:52 AM
Silly question, but Do You have Super Admin rights ?

regards

Jörgen @ Kreativ Fotografi
Title: Re: Database error?
Post by: Yellow Cherry on July 11, 2018, 14:02:51 PM
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,
Title: Re: Database error?
Post by: Jörgen on July 11, 2018, 14:15:01 PM
What PHP version do You use ?

Jörgen @ Kreativ Fotografi
Title: Re: Database error?
Post by: Yellow Cherry on July 11, 2018, 17:03:24 PM
Currently on 7.1.

Thanks
Title: Re: Database error?
Post by: Jörgen on July 11, 2018, 21:56:06 PM
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
Title: Re: Database error?
Post by: Yellow Cherry on July 12, 2018, 15:10:33 PM
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
Title: Re: Database error?
Post by: jenkinhill on July 12, 2018, 15:31:07 PM
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.....
Title: Re: Database error?
Post by: jjk on July 13, 2018, 15:36:11 PM
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.
Title: Re: Database error?
Post by: 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
Title: Re: Database error?
Post by: GJC Web Design on July 13, 2018, 16:09:36 PM
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
Title: Re: Database error?
Post by: jjk on July 13, 2018, 16:15:14 PM
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.
Title: Re: Database error?
Post by: Yellow Cherry on July 13, 2018, 16:44:44 PM
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
Title: Re: Database error?
Post by: jenkinhill on July 13, 2018, 17:12:20 PM
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
Title: Re: Database error?
Post by: Milbo on July 23, 2018, 09:23:57 AM
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.
Title: Re: Database error?
Post by: Jörgen on July 23, 2018, 10:37:35 AM
I see that now, but neither he nor I knew that :)

Jörgen @ Kreativ Fotografi