Categories
View Replies (9)

Resolved Error installing CSVI 7.4.0

  1. bestcons
    bestcons
  2. RO CSVI
  3. Monday, 15 January 2018
  4.  Subscribe via email
Installing 7.4.0 leads to the following error:

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.0_pro.zip
0
Responses (9)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
The error says that there is a missing field text_enclosure in #__csvi_maps table and so update to that table is failing the CSVI update. To solve this, go to your PHPMyAdmin or any software you use to access your database, select your database, look for table #__csvi_maps, drop that one table and run the below query to create it. Install the CSVI 7.4.0 package after that. Make sure that you replace #_ with your database table prefix before running the 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';
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
bestcons
bestcons
Accepted Answer Pending Moderation
Thanks, this solved my problem.

Unfortunately while importing, using an Excel file, a serious problem showed up. The system reports per imported item about the associated image:

Incorrect Failure The file /var/www/vhosts/URL of the website/httpdocs/images/stories/virtuemart/product/BOE%20Zeggerdink%20Almenseweg%2059.jpg has not been found.
However the image has always been in this location and still is.
Please advice.
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Please post your import debug log and sample import file to check. To know on how to get the debug log check Where to get debug information? document.
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
bestcons
bestcons
Accepted Answer Pending Moderation
Hi,
Here are the requested files.
Boerderijnamen Almenseweg.xls com_csvi.log.1215.zip .
Attachments (2)
Boerderijnamen Almenseweg.xls
com_csvi.log.1215.zip
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Can you load the attached patch file and run the import again? See if your images are imported fine.

patch_image_name_2018_01_16.zip
Attachments (1)
patch_image_name_2018_01_16.zip
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
bestcons
bestcons
Accepted Answer Pending Moderation
This leads to a new Error message:
JInstaller: :Installeren: Kan geen XML instellingenbestand vinden (Installing: Can not find XML settings file)
  1. more than a month ago
  2. RO CSVI
  3. # 6
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
You should install the patch file from CSVI maintenance menu as explained in the document linked in my previous post and not by using Joomla Extension manager.
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. # 7
bestcons
bestcons
Accepted Answer Pending Moderation
Yes, this works. Thanks.
I have tested the update on my test-website. May I expect an updated 7.4.0 for the live-website?
  1. more than a month ago
  2. RO CSVI
  3. # 8
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

There is going to be a 7.4.1 release in a few days time, we have a few other things we want to get in.
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. # 9
  • Page :
  • 1


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