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
- batetim
- RO CSVI
- Wednesday, 11 March 2015
- Subscribe via email
0
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=
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=
Accepted Answer
Pending Moderation
Hi Roland, throws same error message although it may have updated anyway?? (see attached)
Attachments (1)
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.
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
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hi Roland
Just uploaded and has thrown attached sql error message on csvi installation
Kind regards
Tim
Just uploaded and has thrown attached sql error message on csvi installation
Kind regards
Tim
Attachments (1)
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?
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
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
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
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
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- Page :
- 1
- 2
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »