Categories
View Replies (6)

Resolved Two Errors : database & Fields

  1. extonjaez
    extonjaez
  2. RO CSVI
  3. Sunday, 18 March 2018
  4.  Subscribe via email
Hello,

I have this errors
Error
Table 'db729675744.#__csvi_settings' doesn't exist
Unknown column 'id' in '#__csvi_availablefields'

and this :

Warning: Database is not up to date!
Table 'hdlz7_csvi_availablefields' does not have column 'id' with type `csvi_availablefield_id`. (From file 6.0.sql.)
Table 'hdlz7_csvi_availabletables' should not have index 'type_name'. (From file 6.0.sql.)
Table 'hdlz7_csvi_availabletables' does not have column 'id' with type `csvi_availabletable_id`. (From file 6.0.sql.)
Table 'hdlz7_csvi_availabletables' does not have column 'template_type_name' with type `task_name`. (From file 6.0.sql.)
Table 'hdlz7_csvi_logdetails' does not have column 'id' with type `csvi_logdetail_id`. (From file 6.0.sql.)
Table 'hdlz7_csvi_logdetails' does not have column 'log_id' with type `csvi_log_id`. (From file 6.0.sql.)
Table 'hdlz7_csvi_logs' does not have column 'id' with type `csvi_log_id`. (From file 6.0.sql.)
Table 'hdlz7_csvi_maps' does not have column 'id' with type `csvi_map_id`. (From file 6.0.sql.)
Table 'hdlz7_csvi_maps' does not have column 'name' with type `title`. (From file 6.0.sql.)
Table 'hdlz7_csvi_maps' does not have column 'checked_out' with type `locked_by`. (From file 6.0.sql.)
Table 'hdlz7_csvi_maps' does not have column 'checked_out_time' with type `locked_on`. (From file 6.0.sql.)
Table 'hdlz7_csvi_settings' does not have column 'id' with type `csvi_setting_id`. (From file 6.0.sql.)
Table 'hdlz7_csvi_templatefields' does not have column 'id' with type `csvi_templatefield_id`. (From file 6.0.sql.)
Table 'hdlz7_csvi_templatefields' does not have column 'template_id' with type `csvi_template_id`. (From file 6.0.sql.)
Table 'hdlz7_csvi_templatefields' does not have column 'file_field_name' with type `xml_node`. (From file 6.0.sql.)
Table 'hdlz7_csvi_templatefields' does not have column 'sort' with type `sort`. (From file 6.0.sql.)
Table 'hdlz7_csvi_templatefields' does not have column 'cdata' with type `cdata`. (From file 6.0.sql.)
Table 'hdlz7_csvi_templatefields' does not have column 'plugin'. (From file 6.0.sql.)
Table 'hdlz7_csvi_templates' does not have column 'id' with type `csvi_template_id`. (From file 6.0.sql.)
Table 'hdlz7_csvi_templates' does not have column 'name' with type `template_name`. (From file 6.0.sql.)
Table 'hdlz7_csvi_templates' does not have column 'process' with type `action`. (From file 6.0.sql.)

and fix database change nothing.:unsure:

Many Thanks for your help!
Arnaud

System Information
Database schema version CSVI 7.4.1
PHP Built On Linux info 3.0 #1337 SMP Tue Jan 01 00:00:00 CEST 2000 all GNU/Linux
Database Type mysql
Database Version 5.5.59-0+deb7u1-log
Database Collation latin1_general_ci
Database Connection Collation utf8mb4_general_ci
PHP Version 7.1.15
Web Server Apache
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 3.8.6 Stable [ Amani ] 13-March-2018 14:00 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
User Agent Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.108 Safari/537.36
0
Responses (6)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Arnaud,

The database issue you seems to come from a very broken installation, no idea how this happened though in your installation. It seems to come from a very old installation that was present in the database.

Apparently you have CSVI installed, so if you go to Maintenance and choose CSVI Pro from the first dropdown and then Remove CSVI tables. This will remove all CSVI tables and data. After that you are taken to the Joomla Extension Manager and you can uninstall CSVI. After the uninstallation has completed you can install CSVI again and you should have a clean installation with all tables in place.

Let me know how that goes.
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
extonjaez
extonjaez
Accepted Answer Pending Moderation
Hello,

I have always the same problem after having done the corrections that you have exlained in the last post..
Capture.JPG
Thanks for your help
Best regards
Arnaud
Attachments (1)
Capture.JPG Capture.JPG
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Arnaud,
Can you send a private message of your Joomla administrator and database access details? I will take a look at your site and fix these database issues.
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
extonjaez
extonjaez
Accepted Answer Pending Moderation
PM have been just sended..:)
Thanks for your help.
  1. more than a month ago
  2. RO CSVI
  3. # 4
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Arnaud,

We have been doing a lot of testing here and managed to reproduce the issue you see. First and foremost, there is no database problem. The database issues you are seeing are a false-positive starting with Joomla 3.8.6. Something has changed in the Joomla core between 3.8.5 and 3.8.6 causing these invalid warnings.

So you can continue using CSVI as normal. In the next release this issue will be addressed.
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. # 5
extonjaez
extonjaez
Accepted Answer Pending Moderation
ok. Thanks for the news!!
  1. more than a month ago
  2. RO CSVI
  3. # 6
  • Page :
  • 1


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