Resolved CSVI 7.4.1 Installing Errors

Hello,
Can you send me a private message of your site database and administrator access details? I will check and fix the database issues with CSVI.

Sorry, can't do that. It would be a violation of our security policies.

Hello,
In that case, can you run the CSVI package install again and see if errors gets solved? Looks like your update did not go good and the CSVI database tables seems messed up. You can use the above first post with queries to solve any database errors you see in the update.

Same issue after install and reinstall. If you can't resolve this issue. I would like my money back please. I already had enough problems just trying to access your website through the broken Captcha.

×
Error
Table 'joomla.#__csvi_settings' doesn't exist
Unknown column 'id' in '#__csvi_availablefields'


Folder Status Options
/srv/users/serverpilot/apps/joomla/public/tmp Writable
/srv/users/serverpilot/apps/joomla/public/tmp/com_csvi Writable
/srv/users/serverpilot/apps/joomla/public/tmp/com_csvi/export Writable
/srv/users/serverpilot/apps/joomla/public/administrator/logs Writable
Setting Value
Display errors Yes
Magic quotes runtime No
Magic quotes gpc No
PHP version 5.6.34
Joomla! version 3.8.6
Database schema version 7.4.1
Warning: Database is not up to date!
Table 'haml_csvi_availablefields' does not have column 'id' with type `csvi_availablefield_id`. (From file 6.0.sql.)
Table 'haml_csvi_availabletables' should not have index 'type_name'. (From file 6.0.sql.)
Table 'haml_csvi_availabletables' does not have column 'id' with type `csvi_availabletable_id`. (From file 6.0.sql.)
Table 'haml_csvi_availabletables' does not have column 'template_type_name' with type `task_name`. (From file 6.0.sql.)
Table 'haml_csvi_logdetails' does not have column 'id' with type `csvi_logdetail_id`. (From file 6.0.sql.)
Table 'haml_csvi_logdetails' does not have column 'log_id' with type `csvi_log_id`. (From file 6.0.sql.)
Table 'haml_csvi_logs' does not have column 'id' with type `csvi_log_id`. (From file 6.0.sql.)
Table 'haml_csvi_maps' does not have column 'id' with type `csvi_map_id`. (From file 6.0.sql.)
Table 'haml_csvi_maps' does not have column 'name' with type `title`. (From file 6.0.sql.)
Table 'haml_csvi_maps' does not have column 'checked_out' with type `locked_by`. (From file 6.0.sql.)
Table 'haml_csvi_maps' does not have column 'checked_out_time' with type `locked_on`. (From file 6.0.sql.)
Table 'haml_csvi_settings' does not have column 'id' with type `csvi_setting_id`. (From file 6.0.sql.)
Table 'haml_csvi_templatefields' does not have column 'id' with type `csvi_templatefield_id`. (From file 6.0.sql.)
Table 'haml_csvi_templatefields' does not have column 'template_id' with type `csvi_template_id`. (From file 6.0.sql.)
Table 'haml_csvi_templatefields' does not have column 'file_field_name' with type `xml_node`. (From file 6.0.sql.)
Table 'haml_csvi_templatefields' does not have column 'sort' with type `sort`. (From file 6.0.sql.)
Table 'haml_csvi_templatefields' does not have column 'cdata' with type `cdata`. (From file 6.0.sql.)
Table 'haml_csvi_templatefields' does not have column 'plugin'. (From file 6.0.sql.)
Table 'haml_csvi_templates' does not have column 'id' with type `csvi_template_id`. (From file 6.0.sql.)
Table 'haml_csvi_templates' does not have column 'name' with type `template_name`. (From file 6.0.sql.)
Table 'haml_csvi_templates' does not have column 'process' with type `action`. (From file 6.0.sql.)

Hello,

Same issue after install and reinstall. If you can't resolve this issue. I would like my money back please.

We never said we cannot resolve this issue. We are ready to help and so asked for the access details to take a look at your site and fix it.

Told you you can't have access to it. Either figure it out and let me know how to fix it and get a decent review or give me a refund and get not review or do not give me a refund and get a negative review and I will have my card take my money back anyways. I had to help you troubleshoot your captcha error anyways you had with your server company.

Seems like this would be a simple thing to do.

Hello David,

I had to help you troubleshoot your captcha error anyways you had with your server company.

You seem to have a special gift In the 5 years with this hosting company you are the first and only one so far to encounter this. However this issue still isn't solved but I managed to get it disabled.

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.

Either figure it out and let me know how to fix it

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.

Same error after your suggested resolution..

Luckily I see I am not the only one having this error. I will follow that person's post. If you kindly post the solution there or or here as I said you will get a glowing review.

Hello David,

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.

Thanks for troubleshooting. I have left positive feedback on the Joomla Extensions directory for you.