Author Topic: 1054 - Unknown column 'Array' in 'where clause'  (Read 1398 times)

godsgracetech

  • Beginner
  • *
  • Posts: 9
  • A beginner
  • Skype Name: godsgracetech
1054 - Unknown column 'Array' in 'where clause'
« on: August 22, 2017, 05:03:29 am »
Hi,
We are getting an issue when we try to add any product "Add To Cart" in any category, then we are getting the following error.

1054 - Unknown column 'Array' in 'where clause'

I'm using Joomla 3.7.2 and VirtueMart 3.2.3, we don't have any issues when we migrated to the versions. Very recently i think on Friday onwards it was started to giving this error. I tried alot by looking into many forums and posts, but no solution.

Could you please help me to fix this issue..?

If i install fresh Joomla and VM, how can i export/import all the products we uploaded into the current website ?

Please visit my website at http://www.trinusmart.com and click on any menu or category then try to add any product to cart then you get that error. Really we appreciate your help and thanks alot in advance.

Kindly help me to fix this issue.
Thanks

jjk

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3414
  • using Matomo instead of Google Analytics
Re: 1054 - Unknown column 'Array' in 'where clause'
« Reply #1 on: August 22, 2017, 20:36:03 pm »
If i install fresh Joomla and VM, how can i export/import all the products we uploaded into the current website ?

I suppose that is the best solution for all the problems with your shop. I would suggest to install a copy of your current website on your local PC using xampp:
https://www.apachefriends.org/index.html
and then do a fresh installation of Joomla and VirtueMart in new subfolder within xampp's htdocs folder. Afterwards you can try to export/import the VirtueMart tables into the fresh system with phpmyadmin, which is available in your hoster's site administration as well as in xampp. Once you get everything working, you could transfer your local website to the live server.

Please also read these old posts:
http://forum.virtuemart.net/index.php?topic=131058.msg451784#msg451784
http://forum.virtuemart.net/index.php?topic=132345.msg457799#msg457799
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9770
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: 1054 - Unknown column 'Array' in 'where clause'
« Reply #2 on: August 23, 2017, 09:56:32 am »
I dont think that this is necessary. Please update to the last vm3.2.3.

When I go on your page, I get a lot js errors

/index.php/en/components/com_virtuemart/assets/js/jquery.noconflict.js Failed to load resource: the server responded with a status of 404 (Not Found)
buttons.js Failed to load resource: net::ERR_CONNECTION_REFUSED
eureka-forbes-super-clean-handheld-vacuum-cleaner-detail:2700 Uncaught ReferenceError: stLight is not defined
    at eureka-forbes-super-clean-handheld-vacuum-cleaner-detail:2700
VM396:1 carouFredSel: No element found for "#slider".

So add to cart does not work in my case
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

godsgracetech

  • Beginner
  • *
  • Posts: 9
  • A beginner
  • Skype Name: godsgracetech
Re: 1054 - Unknown column 'Array' in 'where clause'
« Reply #3 on: August 23, 2017, 13:19:50 pm »
Hi Milbo,
Thank you for your reply. As explained you Yesterday, we are able to fix that issue by disabling few VM modules like Filter and Cloud Tags. After disabled these two modules we are not getting error. But the issue is, Add to Cart is not working properly, when clicked on Add to CArt then it is displaying Cart Empty on shopping cart page.

Could you please check again and suggest something to fix this issue. ?
Website: http://www.trinusmart.com

Thank you

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9770
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: 1054 - Unknown column 'Array' in 'where clause'
« Reply #4 on: August 23, 2017, 13:26:22 pm »
I cant see that you explained that yesterday and my check is from today, so....

As always, when there is a problem, follow the standard procedure http://forum.virtuemart.net/index.php?topic=78322.0
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

jjk

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3414
  • using Matomo instead of Google Analytics
Re: 1054 - Unknown column 'Array' in 'where clause'
« Reply #5 on: August 24, 2017, 00:34:45 am »
Just a note - the reason for my reply above was, that the supplier of the Reviver template in the past supplied his templates with way too many unnecessary extensions which produced lots of conflicts including many heavily hacked VM files, which made it virtually impossible to update a shop with original VM files.
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations

godsgracetech

  • Beginner
  • *
  • Posts: 9
  • A beginner
  • Skype Name: godsgracetech
Re: 1054 - Unknown column 'Array' in 'where clause'
« Reply #6 on: August 24, 2017, 18:17:30 pm »
Thank you everyone for your suggestions. We are able to fix this issue by replacing two js files which are vmprice.js and vmprice2.js  We have replaced these files with backup files.

Thanks & Regards
Gods Grace Technologies