Resolved Update on CSVI 7.5.0 fails

Hello,

In addition, when I go to Csv Improved Dashboard I have the following error:

If you know how, can you tell me what the collation of that field is? Usually you can view the database using PhpMyAdmin and go to the table csvi_sefurls. Go to the structure of the table. Take a screenshot of that and post it here and I can see what is going on. If you have no problem with that field, you can leave it as-is.

In addition, when I go to Csv Improved Dashboard I have the following error:

Go to System -> Clear cache. You should see CSVI there, you can delete that entry. That should solve this issue.

Hello,

I am going to look into this and see if I can reproduce the problem. The plainurl is now set to a size of 255. If you do not have any URLs longer than 255 characters, there is nothing you need to do. Do you have any URLs longer than 255 characters?

Hello Guenter,

You can download and install version 7.5.1 and I believe that should fix your installation problem.

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.

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.

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 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".

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

HTTP ERROR 500

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.

Hi Rolandd,

what shall I do, to find the error details. The error log of the webserver shows nothing. I had set the error reporting of joomla to development, but this does not help. I only get the message "internal server error" - thats all.

Best regards Guenter

Hello Guenter,

what shall I do, to find the error details. The error log of the webserver shows nothing.

The only way to find out what the real error is to ask the hosting provider. A server doesn't throw an error without logging it unless the server is not setup correctly.

I had set the error reporting of joomla to development, but this does not help.

Correct, this doesn't help because it is not a Joomla or PHP error but a server error.

I only get the message "internal server error" - thats all.

That is why I really don't like this error. It doesn't tell us anything and the real reason is only in the log file.

Besides all that I think the issue is caused when the database is checked on installation. CSV Improved should still be installed if you go to Components. If you have it there, go to the About page in CSVI and click on the Fix Database button. Do you get the "Internal Server Error" as well?

Hi Roland,

I am working with hosteurope and I think these guys will manage the server in a accurate way. I controlled the error logs again, but without doubt - there are no errors of my working installation.

When I try to fix the database, I only get a blanc page.

Regards Guenter

Hello Guenter,

there are no errors of my working installation.

If your server throws errors without logging them. The question becomes do you have access to the correct error logs? Usually the server error logs are not available to the end-user unless they manage their own server. I have not seen any server yet that throws errors without logging them.

When I try to fix the database, I only get a blanc page.

If you enable the error reporting in Joomla, do you see anything then? If not, you may have the same internal server error.

Hi Roland,
my system is a managed server (by hosteurope), and I have access to all log files, also to the error logs for the different php-versions. And believe me, they show no errors of my working installation.

I set the error reporting of joomla to development and when I try to fix the database, I only get a blanc page.

Best regards - Guenter

Hello Guenter,

I have access to all log files, also to the error logs for the different php-versions.

It is not the PHP errorlog I am talking about but the Apache/Nginx errorlog.

And believe me, they show no errors of my working installation.

I believe you that the logs you are looking at are empty. I just think they are the wrong logs.

I set the error reporting of joomla to development and when I try to fix the database, I only get a blanc page.

Then we are sure it is the same error as you get during installation.

As written in the documentation, the Internal Server Error is just a generic error from the webserver that says something went wrong but I will not tell you what. The real reason is written to the error log.

The only thing I think you can do, as your server won't tell us what went wrong is to unpack the zip file and you install the zip packages individually that are inside the package zip file.

Perhaps the server log from @Elio has some information for us.

Hello Guenter,

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..

Ok, but how can I solve?

In addition, when I go to Csv Improved Dashboard I have the following error:
"CSVI Addons you have installed are outdated. You need to update your addons to the same version as CSVI extension. In the extension manager, you can see the current list of add-ons and their versions. You can update the addons from the Update page in the Joomla Extension Manager."

But if I check the version I see everything at 7.5.0 (see attachment)
How can I fix everything?
Thank you

Thanks for the quick response!
Instead, how can I solve the database problem?

"Errore
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."

Thanks!

I'm not sure but I do not think so,
Thank you for your precious help!

Hi RolandD

All my access log has for the 500 error is :

[23/Mar/2018:20:21:16 +0000] "POST /administrator/index.php?option=com_installer&view=install HTTP/1.1" 500 -

I have full access to everything so let me know if there's something else that could help,

regards
Eliot

Hello Eliot,

The log you posted is indeed the access log but the real error is written to the servers error log. The access log has no details on errors, that is what the error log is for. The access log will only tell us which URL has been accessed and the status of that.

If you can check the error log that would be helpful.