Author Topic: vmError: Product store TableProducts: :store failed  (Read 3169 times)

wicko

  • Jr. Member
  • **
  • Posts: 73
    • Graphic and web design
vmError: Product store TableProducts: :store failed
« on: July 15, 2013, 11:15:54 am »
I am unable to create new products correctly and am getting the following error on each product page.
Warning: Invalid argument supplied for foreach() in /hsphere/local/home/******/******/administrator/components/com_virtuemart/views/product/view.html.php on line 89

If I make any changes and try to save I get this:
vmError: Product store TableProducts: :store failed
Unknown column 'pordering' in 'field list' SQL=UPDATE `bhe4q_virtuemart_products` SET `virtuemart_vendor_id`='1',`product_parent_id`='0',`product_sku`='5899421367',`product_weight`='0.0000',`product_weight_uom`='KG',`product_length`='83.0000',`product_width`='83.0000',`product_height`='32.0000',`product_lwh_uom`='MM',`product_url`='',`product_in_stock`='99',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='2013-03-03 00:00:00',`product_availability`='2-3d.gif',`product_special`='1',`pordering`=NULL,`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"\"|max_order_level=\"\"|step_order_level=\"\"|product_box=\"\"|',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`created_on`='2013-03-03 16:52:38',`created_by`='982',`modified_on`='2013-07-15 09:15:10',`modified_by`='981' WHERE `virtuemart_product_id`='1'

my site is www.wicksteads.com

How can I fix this?

Wicko

franzpeter

  • 3rd party VirtueMart Developer
  • Jr. Member
  • *
  • Posts: 467
    • 2in1-online | Software, Mac, PC, Netzwerk, Drucker, Pad, Display
  • VirtueMart Version: Virtuemart 3.2.6
Re: vmError: Product store TableProducts: :store failed
« Reply #1 on: July 15, 2013, 11:40:14 am »
Did you change something inside the default VM database tables? If not you can go from the administration panel into Virtuemart -> Tools -> Tools & Migration -> DB Tools and click on install or if necessary update tables. Before doing that you should activate in Configuration: Enable database Update tools.
After finishing deactivate: Enable database Update tools in Configuration.
Maybe while installing the update something was not updated so that VM does not know about the pordering row inside the database table for products.

wicko

  • Jr. Member
  • **
  • Posts: 73
    • Graphic and web design
Re: vmError: Product store TableProducts: :store failed
« Reply #2 on: July 15, 2013, 11:47:10 am »
Thank you for the suggestion. I have not made any changes to VM tables. I have enable database update tools and then pressed necessary update tables as suggested and got this error on a blank screen
Parse error: syntax error, unexpected T_PAAMAYIM_NEKUDOTAYIM in /hsphere/local/home/******/wicksteads.com/administrator/components/com_virtuemart/models/updatesmigration.php on line 303

wicko

  • Jr. Member
  • **
  • Posts: 73
    • Graphic and web design
Re: vmError: Product store TableProducts: :store failed
« Reply #3 on: July 15, 2013, 11:52:06 am »
Site is Joomla 2.5.11 with VM 2.0.18a
Server running PHP 5.2.17
Can not upgrade to latest version as need PHP 5.3
Perhaps this could be to issue

wicko

  • Jr. Member
  • **
  • Posts: 73
    • Graphic and web design
Re: vmError: Product store TableProducts: :store failed
« Reply #4 on: July 15, 2013, 13:09:45 pm »
Have now updated PHP to 5.3 and increased execution and memory in PHP.ini
Updated VM to 2.0.22 and this appears to have fixed the issue

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 28013
  • Always on vacation
    • Jenkin Hill Internet
Re: vmError: Product store TableProducts: :store failed
« Reply #5 on: July 15, 2013, 13:58:20 pm »
Yes, T_PAAMAYIM_NEKUDOTAYIM error is related to using PHP5.2
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Currently using VirtueMart 3.8.7 10374 on Joomla 3.9.24 PHP 7.4.12

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10087
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: vmError: Product store TableProducts: :store failed
« Reply #6 on: July 15, 2013, 21:23:54 pm »
fixed in 2.0.22a, is released, news will come.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

sui_page

  • Beginner
  • *
  • Posts: 33
Re: vmError: Product store TableProducts: :store failed
« Reply #7 on: October 09, 2013, 14:32:30 pm »
I have just received this problem after trying to import all my products from another Joomla/VM install. On the upside I got all my products with all the details in but the now VM is buggy and has the errors mentioned above. Can any point me in the right direction to fix this isse please