Author Topic: Virtuemart does not save any product changes  (Read 7224 times)

beachy

  • Jr. Member
  • **
  • Posts: 277
  • VirtueMart Version: 2.0.22
Virtuemart does not save any product changes
« on: April 18, 2010, 10:06:36 am »
Hi Guys,

I have got a really strange problem with my site in that I cant change any product information or prices. I can load all the product details go through changing prices weights images etc but when I click save or apply the usual Info: The product price has been updated. Info: Product was successfully updated appears but if you go back into the same product none of the changes made have been saved.

I have checked my products table in phpmyadmin and nothing seems to be wrong with it. I have not changed anything on my site recently.

I have taken a backup of the main site and emulated it locally to try to find the solution but I have not managed to come up with anything at the moment.

I am running Joomla 1.5.15 Virtuemart 1.1.14

Any help is much appreciated
_______
Joomla 2.5.11 Virtuemart 2.0.22
Apache 2.2.24 PHP 5.4.13
Hosted By RochenHost.com - MVS

rb

  • Advanced
  • Full Member
  • *****
  • Posts: 1503
Re: Virtuemart does not save any product changes
« Reply #1 on: April 19, 2010, 02:55:46 am »
One cause of odd behavior such as this is having other than just the one  default Vendor in the database (VirtueMart only supports having one Vendor, the default Vendor).  I'm not saying this is definitively the cause of your problem, I'm just saying it's a possibility.

beachy

  • Jr. Member
  • **
  • Posts: 277
  • VirtueMart Version: 2.0.22
Re: Virtuemart does not save any product changes
« Reply #2 on: April 24, 2010, 16:50:42 pm »
Yeah I have actually setup up my site with no vendor at all. Could this be causing the problem?
_______
Joomla 2.5.11 Virtuemart 2.0.22
Apache 2.2.24 PHP 5.4.13
Hosted By RochenHost.com - MVS

rb

  • Advanced
  • Full Member
  • *****
  • Posts: 1503
Re: Virtuemart does not save any product changes
« Reply #3 on: April 24, 2010, 17:51:13 pm »
In phpMyAdmin, if the jos_vm_vendor table is empty, then yes that could be your problem.  But if phpMyAdmin shows that jos_vm_vendor has one row with an id of 1, then your problem is something else.

beachy

  • Jr. Member
  • **
  • Posts: 277
  • VirtueMart Version: 2.0.22
Re: Virtuemart does not save any product changes
« Reply #4 on: April 24, 2010, 18:19:32 pm »
Yeah I have got one row with an id of 1

I have attached a xls file in case you can see something wrong with the entry!

Thanks for help rb!

[attachment cleanup by admin]
_______
Joomla 2.5.11 Virtuemart 2.0.22
Apache 2.2.24 PHP 5.4.13
Hosted By RochenHost.com - MVS

rb

  • Advanced
  • Full Member
  • *****
  • Posts: 1503
Re: Virtuemart does not save any product changes
« Reply #5 on: April 24, 2010, 18:35:23 pm »
So your problem is not related to your Vendor table as it seems fine.

I would try this: turn on debug and turn on logging, then try your Product updates and see if you have any errors or warnings from either the debug output or in the log file.

beachy

  • Jr. Member
  • **
  • Posts: 277
  • VirtueMart Version: 2.0.22
Re: Virtuemart does not save any product changes
« Reply #6 on: April 24, 2010, 18:40:13 pm »
rb,

Your suggestion looks like it has found the problem!

I am getting the following error when editting a product. It obviously relates to the additional fields I added to my database. After updating my site I must have overwritten some code adjustments!

JDatabaseMySQL::query: 1054 - Unknown column 'product_product_pricesqm' in 'field list' SQL=UPDATE `jos_vm_product` SET `vendor_id` = '1', `product_sku` = 'WSPR500', `product_product_pricesqm` = '', `product_product_packsize` = '(Inc VAT)', `product_name` = 'Woodentops Worktop Spray Oil - 500ml', `product_desc` = '

Hopefully this will sort my problems out! I will let you know!

Cheers
_______
Joomla 2.5.11 Virtuemart 2.0.22
Apache 2.2.24 PHP 5.4.13
Hosted By RochenHost.com - MVS

beachy

  • Jr. Member
  • **
  • Posts: 277
  • VirtueMart Version: 2.0.22
Re: Virtuemart does not save any product changes
« Reply #7 on: April 24, 2010, 18:55:46 pm »
Thanks rb!

The problem was in ps_product.php!

I owe you a pint!
_______
Joomla 2.5.11 Virtuemart 2.0.22
Apache 2.2.24 PHP 5.4.13
Hosted By RochenHost.com - MVS

shv_rk

  • Jr. Member
  • **
  • Posts: 68
Re: Virtuemart does not save any product changes
« Reply #8 on: April 26, 2010, 11:36:06 am »
@beachy

Would please describe more how did you solve your problem?
I don't have access to my log file, so i cant really see what is causing the problem!

sometimes when I save product I get following error:
Warning: number_format() expects parameter 1 to be double, string given in C:\xampp\htdocs\Joomla\administrator\components\com_virtuemart\classes\currency\class_currency_display.php  on line 107
£

shv_rk

  • Jr. Member
  • **
  • Posts: 68
Re: Virtuemart does not save any product changes
« Reply #9 on: April 26, 2010, 13:05:15 pm »
Code: [Select]
@$price["product_price"]in product.product_form.php is always empty!
Code: [Select]
<input type="text" value="<?php echo @$price["product_price"]; ?>" class="inputbox" name="product_price" onkeyup="updateGross();" size="10" maxlength="10" />

beachy

  • Jr. Member
  • **
  • Posts: 277
  • VirtueMart Version: 2.0.22
Re: Virtuemart does not save any product changes
« Reply #10 on: April 26, 2010, 20:36:59 pm »
Hi shv_rk,

I solved mine by enabling debug mode. I then went in to save a product change. As I clicked save it displayed an error. I then looked at the code and worked out which one was causing the problem!

Let me know if you need more help!
_______
Joomla 2.5.11 Virtuemart 2.0.22
Apache 2.2.24 PHP 5.4.13
Hosted By RochenHost.com - MVS

rhand-vm

  • Jr. Member
  • **
  • Posts: 76
Re: Virtuemart does not save any product changes
« Reply #11 on: April 28, 2010, 09:23:16 am »
@ Beachy Well, what was causing the problem? Did you edit a certain file or a database table? Thanks in advance for providing us with more details.

beachy

  • Jr. Member
  • **
  • Posts: 277
  • VirtueMart Version: 2.0.22
Re: Virtuemart does not save any product changes
« Reply #12 on: April 28, 2010, 19:28:41 pm »
When I was following this thread:

http://forum.virtuemart.net/index.php?topic=67123.msg223524#msg223524

I entered a value incorrectly in the shop_browse_queries.php!

Hope this helps
_______
Joomla 2.5.11 Virtuemart 2.0.22
Apache 2.2.24 PHP 5.4.13
Hosted By RochenHost.com - MVS