News:

Support for jDownloads 3 has been ended
Since 17 August 2023 Joomla.org has discontinued support for Joomla 3.x. Therefore, we will no longer offer official support for our Joomla 3 jDownloads version 3.9.x from January 2024.
Please update your website to the latest Joomla version (Joomla 4 or Joomla 5) as soon as possible. Afterwards, please update jDownloads to the latest published version. The longer you delay, the more difficult the upgrade process for your website is likely to be.

Main Menu
Support-Forum

Handling with incorrect jDownloads DB table structures

Started by Arno, 17.01.2023 14:57:46

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Arno

Since the beginning of the pre-beta phase, beta testers have reported database error messages after the update. I could not reproduce many of them in my case.
My testing then found that there were users working with jDownloads database tables whose definitions were incorrect.

As a result, I have already slightly adapted the update script and at least taken into account the most frequently occurring variant and cleaned it up during the update.
Now the tables are checked before the update and are aborted depending on the error finding. As far as we know, the number of users affected by this is very small.

For another possible error variant, which has to be cleaned manually by the user until further notice, I have created a short PDF instruction (see attachment).

The error message in this case is something like:

A check of the jDownloads database tables revealed differences from the expected data structure. Therefore, the update was cancelled.

Check the tables for correctness. Use the documentation and/or the jDownloads support forum to solve the problem.

The Table: #__jdownloads_files has an incorrect number of data fields. This means that an update can probably not be carried out without errors.
The data fields listed below are not in the correct position within the table. Therefore, the update was cancelled.

Check the tables for correctness. Use the documentation and/or the jDownloads support forum to solve the problem.

#__jdownloads_files: tags
#__jdownloads_files: metakey
#__jdownloads_files: metadesc
#__jdownloads_files: robots
#__jdownloads_files: update_active
#__jdownloads_files: access
#__jdownloads_files: user_access
#__jdownloads_files: language
#__jdownloads_files: ordering
#__jdownloads_files: featured
#__jdownloads_files: published
#__jdownloads_files: checked_out
#__jdownloads_files: checked_out_time
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!
  •