Categories
View Replies (9)

Resolved Error exporting prices after VM update

  1. roderic
    roderic
  2. RO CSVI
  3. Monday, 16 February 2015
  4.  Subscribe via email
* VM 3.0.4
* CSVI 5.20

After updating, the export of the prices is not working anymore. This is because they moved the prices to another database table. Can I fix this myself or do I have to wait for a CSVI update that supports the new prices table?

When I depublish the price tables in the export settings, the export is working as it should. I really do need the prices though.
0
Accepted Answer
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

I believe I have traced down the problem and have attached a patch file. You can load the patch file and after that run your export.

Let me know how it goes.
Attachments (1)
patch_priceexport_20150218.zip
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # Permalink
Responses (9)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

This is because they moved the prices to another database table.
Who moved which prices to what database table?

Even in VirtueMart 3.0.6 the prices are in virtuemart_product_prices table.

I am investigating an issue where the retrieval of at least the salesprice field is giving problems. Perhaps you mean that?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
roderic
roderic
Accepted Answer Pending Moderation
Hello,

This is because they moved the prices to another database table.
Who moved which prices to what database table?

Even in VirtueMart 3.0.6 the prices are in virtuemart_product_prices table.

I am investigating an issue where the retrieval of at least the salesprice field is giving problems. Perhaps you mean that?


I thought the VM team moved the prices. Maybe I'm wrong. What do you mean by VirtueMart 3.0.6 btw? Latest version is 3.0.4?

Anyway, after updating to 3.0.4 the export stopped working because it doesn't seem to find the prices anymore. So as soon as I add one of the price fields to the export, I get an error message. Otherwise it works fine.
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
What do you mean by VirtueMart 3.0.6 btw? Latest version is 3.0.4?
VirtueMart 3.0.6 is what I have is a test version and was checking that as well as 3.0.4. The database layout is all the same.

From what I read from your post is that we are talking about the same thing. So when I figured out what has changed I will get back to you. The plan is that it will be today.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
roderic
roderic
Accepted Answer Pending Moderation
That seemed to have done the trick, thanks!
  1. more than a month ago
  2. RO CSVI
  3. # 4
rolandd
rolandd
Accepted Answer Pending Moderation
Thank you for reporting back.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
mehmesen
mehmesen
Accepted Answer Pending Moderation
Hi Roland.

I did not get the export including tax.

I installed the patch.

Patch attached 2867 product exports (including tax).

Unpatched 3328 product exports (tax-free).

The number of exported product reduced,

How can I fix.

Best regards...

Joomla 3.4 Vm 3.0.6 Csvi 5.20
  1. more than a month ago
  2. RO CSVI
  3. # 6
mehmesen
mehmesen
Accepted Answer Pending Moderation
Hello Roland.

Problem solved. Server memory limit has been set (256M)

Best regards.
  1. more than a month ago
  2. RO CSVI
  3. # 7
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Thank you for reporting your solution.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 8
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!