Support is online

1054 Unknown column #7034

Open Ivano Michelutti opened this topic Thursday, 13 November 2014 ยท 4 replies
Author

Hi,
I am trying to install CSVI PRO but I am getting the following error:
1054 Unknown column 'process' in 'field list' SQL=SELECT name AS text, id AS value, process FROM wjp3i_csvi_template_settings ORDER BY name.

I have tried to apply the patch indicate in the following post in the forum (TOPIC: Error: 1054 Unknown column "customfield_value") but I still get the same error.

When I try to access the "process" page to get the debug data I receive the same error message. I am referring to this page: >>> How to enable debug info? CSVI 4/5 Click on Process

These following are the data I can provide

I am attaching a sample of the import file. Note that I was not able to reach the step where I can start importing it.

Setting Value
Display errors No
Magic quotes runtime No
Magic quotes gpc No
PHP version 5.5.17
Joomla version 3.3.6
Database schema version 5.18
Warning: Database is not up to date!
Table 'repl1_csvi_template_settings' does not have column 'process'. (From file 4.3.sql.)
Table 'repl1_csvi_template_fields' does not have column 'file_field_name'. (From file 5.0.sql.)
Table 'repl1_csvi_template_fields' does not have column 'template_field_name'. (From file 5.0.sql.)
Table 'repl1_csvi_template_fields' does not have column 'cdata'. (From file 5.0.sql.)
Table 'repl1_csvi_replacements' does not have column 'ordering'. (From file 5.1.1.sql.)
Table 'repl1_csvi_template_types' does not have column 'published'. (From file 5.3.sql.)
Table 'repl1_csvi_template_types' does not have column 'ordering'. (From file 5.3.sql.)

About
Name: CSVI Pro
Version: 5.19

Virtuemart Version 2.9.9.3

Support

Hello,

I see you have been on the About page as this shows the Database is not up to date. Have you tried clicking the Fix button in the top right corner?

First the database needs to be correct before you can continue.

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

Dear Roland,
I didn't click on it.
I have clicked on it now, but unfortunately I don't see changes.

In the same page I have noticed the following (see imaage)
Folder Status Options
/web/htdocs/www.MyWebsite.it/home/tmp Writable
/web/htdocs/www.MyWebsite.it/home/tmp/com_csvi Not writable
/web/htdocs/www.MyWebsite.it/home/tmp/com_csvi/debug Not writable

I clicked on the two "Create folder" button but I don't see changes.

Is there something I can do?

about-page.jpg

Support

Hello,

I have clicked on it now, but unfortunately I don't see changes.

Are the database issues gone?

As for the unwritable folders it may be that they are there but not writable. Double check on the server if the folders have the correct permission.

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

Ah... something actually did change!
The error is not there.
Thanks :-)

Log in to reply to this topic.