Categories
View Replies (14)

Resolved Errors installing CSVI 7.4.1 pro

  1. EIF
    EIF
  2. RO CSVI
  3. Tuesday, 27 February 2018
  4.  Subscribe via email
When installing CSVI 7.4.1 pro first I ran into the following error:

Waarschuwing

JInstaller: :Installeren: Fout SQL Unknown column 'text_enclosure' in '#__csvi_maps'

Extensie Updaten: SQL fout verwerken zoekopdracht: DB functie is mislukt met het volgende foutnummer 1054 

Unknown column 'text_enclosure' in '#__csvi_maps'

SQL =

ALTER TABLE `#__csvi_maps`

	ADD `im_mac` TINYINT(1) NOT NULL DEFAULT '0' AFTER `text_enclosure`;

Pakket Updaten: Er deed zich een fout voor tijdens het installeren van een extensie: com_csvi_7.4.1_pro.zip

×

Fout

Fout bij het installeren van pakket


On this forum I read I can fix this running the following sql query:

CREATE TABLE IF NOT EXISTS `#__csvi_maps` (

  `csvi_map_id` INT(10) NOT NULL AUTO_INCREMENT,

  `title` VARCHAR(100) NULL DEFAULT NULL,

  `mapfile` VARCHAR(100) NULL DEFAULT NULL,

  `action` VARCHAR(100) NULL DEFAULT NULL,

  `component` VARCHAR(100) NULL DEFAULT NULL,

  `operation` VARCHAR(100) NULL DEFAULT NULL,

  `auto_detect_delimiters` TINYINT(1) UNSIGNED NULL DEFAULT '1',

  `field_delimiter` VARCHAR(1) NULL DEFAULT ',',

  `text_enclosure` VARCHAR(1) NULL DEFAULT '"',

  `locked_by` INT(10) NULL DEFAULT NULL,

  `locked_on` DATETIME NULL DEFAULT NULL,

	PRIMARY KEY (`csvi_map_id`)

) CHARSET=utf8 COMMENT='Holds map configurations';


This solved the error. But when I try to install the extension again, now the following error appears:

Waarschuwing

JInstaller: :Installeren: Fout SQL Duplicate column name 'field_date_format'

Extensie Updaten: SQL fout verwerken zoekopdracht: DB functie is mislukt met het volgende foutnummer 1060 

Duplicate column name 'field_date_format'

SQL =

ALTER TABLE `#__csvi_templatefields`

	ADD COLUMN `field_date_format` VARCHAR(25) NOT NULL COMMENT 'Date format for the export field' AFTER `default_value`;

Pakket Updaten: Er deed zich een fout voor tijdens het installeren van een extensie: com_csvi_7.4.1_pro.zip


How can solve this error?
0
Responses (14)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Instead of trying to install the CSVI package run the below query from PhpMyAdmin and by pasting it on SQL tab. Check if CSVI Pro extension works good after that.

ALTER TABLE `#__csvi_maps`

ADD `im_mac` TINYINT(1) NOT NULL DEFAULT '0' AFTER `text_enclosure`;
Kind regards,

Tharuna

=========================
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
EIF
EIF
Accepted Answer Pending Moderation
I ran that SQl query. But when I try to install CSVI pro, the following error appeared again:

Waarschuwing

JInstaller: :Installeren: Fout SQL Duplicate column name 'field_date_format'

Extensie Updaten: SQL fout verwerken zoekopdracht: DB functie is mislukt met het volgende foutnummer 1060 

Duplicate column name 'field_date_format'

SQL =

ALTER TABLE `#__csvi_templatefields`

	ADD COLUMN `field_date_format` VARCHAR(25) NOT NULL COMMENT 'Date format for the export field' AFTER `default_value`;

Pakket Updaten: Er deed zich een fout voor tijdens het installeren van een extensie: com_csvi_7.4.1_pro.zip;


As I wrote before, the first error I got about the csvi_maps was fixed. But the error about the field_date_format is not.
What should I do now?
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Do not install the CSVI package, after running the query i sent in my previous post, does your CSVI extension work? In your Joomla menu go to Components >> CSVI Pro and check if it works.
Kind regards,

Tharuna

=========================
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
EIF
EIF
Accepted Answer Pending Moderation
Hmm, it seems to work yes.
When I get errors after trying to install, I am worried about if the extensions works correct or not. Are you sure this error is no problem?
And what about future updates? Will there always be an error now?
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
When I get errors after trying to install, I am worried about if the extensions works correct or not. Are you sure this error is no problem?

If you see your error it says "Duplicate column name 'field_date_format'" which says that the field field_date_format is already there in database and by installing CSVI you are trying to create the same field again. This is because Joomla runs all the update SQL files when installing the extension. This error is not a problem as you have the field already in your database table.

And what about future updates? Will there always be an error now?

You will not be seeing any errors if your CSVI update goes with out any problem.
Kind regards,

Tharuna

=========================
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. # 5
EIF
EIF
Accepted Answer Pending Moderation
ok, thank you
  1. more than a month ago
  2. RO CSVI
  3. # 6
EIF
EIF
Accepted Answer Pending Moderation
When I open CSVI Pro, the following message apears:

Fout
De CSVI Addons die zijn geïnstalleerd zijn veropen. De addons moeten bijgewerkt worden zodat ze dezelfde versie zijn als CSV Improved. In Extensie beheerkan je de huidige lijst van addons en het versienummer zien. De addons kunnen bijgewerkt worden op de Update pagina van Extensie Beheer.

I installed:

- CSVI Pro - pkg_csvi_7.4.1_pro.zip
- CSVI Prp - plg_csviaddon_virtuemart_csvi_7.4.1.zip

Version numbers are the same...
  1. more than a month ago
  2. RO CSVI
  3. # 7
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Go to Joomla Extension Manager >> Manage, in the search box type CSVI and click Enter. Post the screenshot of the list of extensions and their versions you see there.
Kind regards,

Tharuna

=========================
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. # 8
EIF
EIF
Accepted Answer Pending Moderation
Attached the screenshot of the versions...
Attachments (1)
Capture.JPG Capture.JPG
  1. more than a month ago
  2. RO CSVI
  3. # 9
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
It looks like you have updated only CSVI component and CSVI VirtueMart addon to 7.4.1 version. All other extensions are of 7.2.3 version. You need to download the complete CSVI Package from CSVI Downloads page and run the update.
Kind regards,

Tharuna

=========================
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. # 10
EIF
EIF
Accepted Answer Pending Moderation
Hmm, as I wrote in a previous post, I first installed the "pkg_csvi_7.4.1_pro.zip". But when installing that, errors apperard... You then wrote something about SQL codes that needs to run, without installing it again. Now it seems to be that in did not installed everything what is needed...
  1. more than a month ago
  2. RO CSVI
  3. # 11
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Can you send me your site login details and database access details? I will fix the update for you. You can send me a Private message on the details.
Kind regards,

Tharuna

=========================
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. # 12
EIF
EIF
Accepted Answer Pending Moderation
It is not on my live website, but at my local website on my local computer. It is not accessible from outside.
Is there a method I can fix this myself maybe, with your instructions?
  1. more than a month ago
  2. RO CSVI
  3. # 13
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
You can run the update of whole package on your local site and in case you run into any database issues you can use this sticky post for instructions.
Kind regards,

Tharuna

=========================
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. # 14
  • Page :
  • 1


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