Categories
View Replies (27)

Resolved Product Export throwing database table error

  1. batetim
    batetim
  2. RO CSVI
  3. Wednesday, 11 March 2015
  4.  Subscribe via email
Hi Roland

Running csvi 5.2 on Joomla 3.4.0, VM 3.0.6.2

Have created product export template which we use for google shopping xml feed. (set up as attached)

Export is failing and throwing up error message as below:

1146 Table 'ondirect-g.hal3m_virtuemart_products_' doesn't exist SQL=SELECT `hal3m_virtuemart_products`.* ,`hal3m_virtuemart_products_`.* FROM `hal3m_virtuemart_products` INNER JOIN `hal3m_virtuemart_products_` using (`virtuemart_product_id`) WHERE `hal3m_virtuemart_products`.`virtuemart_product_id` = "1200"

Kind regards

Tim
0
Responses (27)
batetim
batetim
Accepted Answer Pending Moderation
... not sure it helps, but this is the error message from our server log

officeneedsdirect.co.uk [Wed Mar 11 14:45:18 2015] [error] [client 109.146.169.10:55513] Invalid status line from script 'index.php': 0 SQL=
  1. more than a month ago
  2. RO CSVI
  3. # 21
batetim
batetim
Accepted Answer Pending Moderation
Hi Roland, throws same error message although it may have updated anyway?? (see attached)
Attachments (1)
Doc3.docx
  1. more than a month ago
  2. RO CSVI
  3. # 22
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Tim,

Don't know where that comes from as I didn't get that here on an update. What you can do is close the screen and go to Components -> CSVI Pro -> Available Fields -> Update. That is enough to update the fields. You can import/export after 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. # 23
batetim
batetim
Accepted Answer Pending Moderation
Hi Roland

Just uploaded and has thrown attached sql error message on csvi installation

Kind regards

Tim
Attachments (1)
Doc2.docx
  1. more than a month ago
  2. RO CSVI
  3. # 24
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Tim,

I jumped the gun a little on that, I see now that it is not a CSVI query giving the error but a VirtueMart one. This has been posted before and turned out something changed in VirtueMart causing that error.

I just released CSVI 5.21 that includes a fix for that. Can you give it a try and let me know?
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. # 25
batetim
batetim
Accepted Answer Pending Moderation
Hi Roland

We just have the one option on options>primary language which is currently set at English (en-GB).

Just selected and saved again, but same error message i am afraid

Kind regards

Tim
  1. more than a month ago
  2. RO CSVI
  3. # 26
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Tim,

Table 'ondirect-g.hal3m_virtuemart_products_'
This indicates you have not chosen a language on the Options tab. Select the appropriate language and save the template, run your export again after 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. # 27
  • Page :
  • 1
  • 2


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