Resolved Update on CSVI 7.5.0 fails

Hello Guenter,

I uninstalled the new version and went back to version 7.4.1. Now I have other errors, which I can not fix:

In other posts you will see that these are false/positives. It is a change in Joomla 3.8.6 that shows database errors on the About page while there are no errors.

@Guenter and @Elio as mentioned in my previous post with just the message "500 Internal Server Error" there is nothing I can do. As mentioned in my post we need to get the real error from the server log. With that error we can see what is going on.

An error occured running the query ALTER TABLE `lu6jz_csvi_sefurls` MODIFY `plainurl` VARCHAR(512) ;. This generates the error Index column size too large. The maximum column size is 767 bytes.

This is not a problematic error it just means that the data in the table is longer than it can be due to the collation type of the field.

We first need to see what the 500 error is in the server error log.

I also get the error updating. Package installs but not the plugins.

HTTP ERROR 500

I tried a second time to install the new version. And set the Error Reporting on development.
All the database errors disappeared, but the installation of all PlugIns failed.

I only get the error message "internal server error".

when I run fix database I get the following error:
An error occured running the query ALTER TABLE `lu6jz_csvi_sefurls` MODIFY `plainurl` VARCHAR(512) ;. This generates the error Index column size too large. The maximum column size is 767 bytes.

I uninstalled the new version and went back to version 7.4.1. Now I have other errors, which I can not fix:

Fehler

Table 'db10614982-2018.#__csvi_settings' doesn't exist

Unknown column 'id' in '#__csvi_availablefields'

And a lot of warnings:

Warning: Database is not up to date!



    Table 'cp18_csvi_availablefields' does not have column 'id' with type `csvi_availablefield_id`. (From file 6.0.sql.)

    Table 'cp18_csvi_availabletables' should not have index 'type_name'. (From file 6.0.sql.)

    Table 'cp18_csvi_availabletables' does not have column 'id' with type `csvi_availabletable_id`. (From file 6.0.sql.)

    Table 'cp18_csvi_availabletables' does not have column 'template_type_name' with type `task_name`. (From file 6.0.sql.)

    Table 'cp18_csvi_logdetails' does not have column 'id' with type `csvi_logdetail_id`. (From file 6.0.sql.)

    Table 'cp18_csvi_logdetails' does not have column 'log_id' with type `csvi_log_id`. (From file 6.0.sql.)

    Table 'cp18_csvi_logs' does not have column 'id' with type `csvi_log_id`. (From file 6.0.sql.)

    Table 'cp18_csvi_maps' does not have column 'id' with type `csvi_map_id`. (From file 6.0.sql.)

    Table 'cp18_csvi_maps' does not have column 'name' with type `title`. (From file 6.0.sql.)

    Table 'cp18_csvi_maps' does not have column 'checked_out' with type `locked_by`. (From file 6.0.sql.)

    Table 'cp18_csvi_maps' does not have column 'checked_out_time' with type `locked_on`. (From file 6.0.sql.)

    Table 'cp18_csvi_settings' does not have column 'id' with type `csvi_setting_id`. (From file 6.0.sql.)

    Table 'cp18_csvi_templatefields' does not have column 'id' with type `csvi_templatefield_id`. (From file 6.0.sql.)

    Table 'cp18_csvi_templatefields' does not have column 'template_id' with type `csvi_template_id`. (From file 6.0.sql.)

    Table 'cp18_csvi_templatefields' does not have column 'file_field_name' with type `xml_node`. (From file 6.0.sql.)

    Table 'cp18_csvi_templatefields' does not have column 'sort' with type `sort`. (From file 6.0.sql.)

    Table 'cp18_csvi_templatefields' does not have column 'cdata' with type `cdata`. (From file 6.0.sql.)

    Table 'cp18_csvi_templatefields' does not have column 'plugin'. (From file 6.0.sql.)

    Table 'cp18_csvi_templates' does not have column 'id' with type `csvi_template_id`. (From file 6.0.sql.)

    Table 'cp18_csvi_templates' does not have column 'name' with type `template_name`. (From file 6.0.sql.)

    Table 'cp18_csvi_templates' does not have column 'process' with type `action`. (From file 6.0.sql.)

When I choose to fix the database, nothing happened.

Hello Guenter,

With only the message "Internal Server Error" there is not much we can do either. Please have a look at the 500 Internal Server Error and at the bottom section Server Error Log. That would be the place to check for what the real error is. If you install it a second time, you get the same error?

You should be able to install the previous version to continue using it and test the update on a test site.