Categories
View Replies (3)

Resolved Error 0 SQL=/* Custom fields */ INSERT IGNORE INTO

  1. jaumepif
    jaumepif
  2. RO CSVI
  3. Thursday, 19 September 2013
  4.  Subscribe via email
When I install CSVI_PRO 5.12 it show this error.

0 SQL=/* Custom fields */ INSERT IGNORE INTO `nhkvg_csvi_available_fields` (csvi_name, component_name, component_table, component) (SELECT TRIM(custom_title), TRIM(custom_title), 'productimport', 'com_virtuemart' FROM `nhkvg_virtuemart_customs` WHERE field_type IN ('S', 'I', 'B', 'D', 'T', 'M', 'Y') );
0
Responses (3)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

I do not see anything wrong with that query. Can you go to Components -> CSVI Pro -> Available Fields and click on Update. This is the same as the 2nd step. Does this complete OK?
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
jaumepif
jaumepif
Accepted Answer Pending Moderation
No.


Capturadepantalla2013-09-20ales07.47.04.png
Attachments (1)
Capturadepantalla2013-09-20ales07.47.04.png Capturadepantalla2013-09-20ales07.47.04.png
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
I just realize you don't have VirtueMart installed because you are on Joomla 3. Hmm, this file should be skipped in your case unless CSVI finds a reference to VirtueMart in your database. That seems to happen.

Easiest way for now is to delete the file administrator/components/com_csvi/install/availablefields/com_virtuemart.sql after that you can run the update.
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
  • Page :
  • 1


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