1. monovarsalud
  2. RO CSVI
  3. Thursday, 30 July 2015
  4.  Subscribe via email
we are using

Joomla 3.4.3
CSVI Pro 6.0.1
Virtuemart 3.0.9

We are trying to export and I get this error

Error
Unknown column 'skip' in 'field list' SQL = SELECT FROM `` skip` w47fa_virtuemart_product_prices` w47fa_virtuemart_products` ON ​​LEFT JOIN `` `w47fa_virtuemart_products`.`virtuemart_product_id` w47fa_virtuemart_product_prices`.`virtuemart_product_id` = w47fa_virtuemart_shoppergroups` ON ​​LEFT JOIN` `w47fa_virtuemart_product_prices` .`virtuemart_shoppergroup_id` = LEFT JOIN `` w47fa_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` w47fa_virtuemart_currencies` ON ​​= `` w47fa_virtuemart_product_prices`.`product_currency` w47fa_virtuemart_currencies`.`virtuemart_currency_id`

when I enter CSVI - About
I see that appears:

Error
Table 'czwlasoz_pcfarm3.w47fa_csvi_replacements' does not exist SQL = SHOW COLUMNS IN w47fa_csvi_replacements` `WHERE field = 'multivalue'

Table 'czwlasoz_pcfarm3.w47fa_csvi_template_settings' does not exist SQL = SHOW COLUMNS IN w47fa_csvi_template_settings` `WHERE field = 'process'

Dashboard
Import
Export
Templates
Maintenance
Logs
Settings
About
Status Folder Options
Writable /home/czwlasoz/public_html/http://monovarsalud.net/tmp
Writable /home/czwlasoz/public_html/http://monovarsalud.net/tmp/com_csvi
Writable /home/czwlasoz/public_html/http://monovarsalud.net/log
Setting Value
Yes Display errors
Magic quotes runtime No
No magic quotes gpc
PHP version 5.4.27
Joomla! Version 3.4.3
Database schema version 6.0
COM_CSVI_MSG_DATABASE_ERRORS
COM_CSVI_MSG_DATABASE_ADD_COLUMN
COM_CSVI_MSG_DATABASE_CREATE_TABLE
COM_CSVI_MSG_DATABASE_CREATE_TABLE
COM_CSVI_MSG_DATABASE_CREATE_TABLE
COM_CSVI_MSG_DATABASE_CREATE_TABLE
COM_CSVI_MSG_DATABASE_ADD_COLUMN


I have seen that there is a patch that is installed from maintenance
but we get this

Error
No Has Been Chosen operation, so I do not know what you like me to do. Select an extension first and then a select the operation you want to perform.


pray tell us we can do
a greeting
Accepted Answer Pending Moderation
Hello,

You are posting a few problems in one, so let me go over them.

First the error
Unknown column 'skip'
There is a column in your export template that is not available. Go to Available Fields and click Update. After that go to Template fields and verify that all the fields for your template are correct. If you export the template and you still get the error, delete all the fields from the template and add them again.

when I enter CSVI - About
I see that appears:
This means your database is not up-to-date. Click the Fix database button and check if the messages are gone.

I have seen that there is a patch that is installed from maintenance
You don't need a patch for this.
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
  • Page :
  • 1


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