Advertisement

No upgrade due to "bad db structure" Topic is solved

Need help upgrading your Joomla! website or converting to Joomla! 5.x?

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Post Reply
rnervi
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Thu May 19, 2011 4:20 pm

No upgrade due to "bad db structure"

Post by rnervi » Fri Mar 29, 2024 2:37 pm

j5.0.3 prefight says

Database Table Structure Up to Date
Go to 'System - Maintenance - Database' and use the 'Update Structure' button.

then in there I found:

Joomla CMS
Joomla! 3 Content Management System
Sito File One Problem 4.4.0-2023-09-13 ‎4.4.3

if select and "fix" ---> this don't change and "web links" moves to "one problem" too..

sounds like the old 3.x site updated to 4.4.3 left some messed tables.

some workaround ?
Last edited by toivo on Sun Mar 31, 2024 9:56 pm, edited 1 time in total.
Reason: mod note: typo in subject

Advertisement
rnervi
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Thu May 19, 2011 4:20 pm

Re: no upgrdad due to "bad db structure"

Post by rnervi » Fri Mar 29, 2024 2:45 pm

just found that moving mouse over the "one problem" red button a popup appears with the problems
but cannot be saved or copied to analyze them (bad)
joomla logs dont helps

rnervi
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Thu May 19, 2011 4:20 pm

Re: no upgrdad due to "bad db structure"

Post by rnervi » Sun Mar 31, 2024 3:21 pm

been able to capture errors:
jch_weblinks column alias wrong types --> removed the plugin

jch_categories
column access with type int unsigned

on another joomla same table same field states
int(10) unsigned
in this bad db it states
int unsigned

changed but does not change

other errors are:

ch_contact_details
column access with type int unsigned
jch_extensions
column access with type int unsigned
jch_menu
column access with type int unsigned
jch_modules
column access with type int unsigned
jch_newsfeers
column access with type int unsigned
jch_content
title_alias type varchar(255)
jch_content
title_alias type varchar(255)

rnervi
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Thu May 19, 2011 4:20 pm

Re: No upgrade due to "bad db structure"

Post by rnervi » Sat Jun 15, 2024 2:19 pm

removed files from
1.7.1-2011-09-20.sql
1.7.3-2011-10-15.sql
1.7.4-2011-11-23.sql

/administrator/components/com_admin/sql/updates/mysql

errors disappeared...

Advertisement

Post Reply

Return to “Migrating and Upgrading to Joomla! 5.x”