5.03 to 5.1 database structure errors

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
ccgr
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 104
Joined: Thu May 15, 2008 2:58 pm

5.03 to 5.1 database structure errors

Post by ccgr » Sun Apr 21, 2024 5:24 pm

I see these errors but the update structure button isn't fixing them.
sqlerrors.jpg
You do not have the required permissions to view the files attached to this post.

User avatar
ceford
Joomla! Hero
Joomla! Hero
Posts: 2723
Joined: Mon Feb 24, 2014 10:38 pm
Location: Edinburgh, Scotland
Contact:

Re: 5.03 to 5.1 database structure errors

Post by ceford » Sun Apr 21, 2024 6:11 pm

These are the updates that should have been executed in J3. You could run them now using phpMyAdmin. Best take a database backup first (remember to replace #_ with your own database prefix):

3.7.0-2017-01-0.sql

Code: Select all

-- Normalize ucm_content_table default values.
ALTER TABLE `#__ucm_content` MODIFY `core_title` varchar(400) NOT NULL DEFAULT '';
ALTER TABLE `#__ucm_content` MODIFY `core_alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin  NOT NULL DEFAULT '';
ALTER TABLE `#__ucm_content` MODIFY `core_body` mediumtext;
ALTER TABLE `#__ucm_content` MODIFY `core_checked_out_time` varchar(255) NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `#__ucm_content` MODIFY `core_params` text;
ALTER TABLE `#__ucm_content` MODIFY `core_metadata` varchar(2048) NOT NULL DEFAULT '' COMMENT 'JSON encoded metadata properties.';
ALTER TABLE `#__ucm_content` MODIFY `core_language` char(7) NOT NULL DEFAULT '';
ALTER TABLE `#__ucm_content` MODIFY `core_publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `#__ucm_content` MODIFY `core_publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `#__ucm_content` MODIFY `core_content_item_id` int unsigned NOT NULL DEFAULT 0 COMMENT 'ID from the individual type table';
ALTER TABLE `#__ucm_content` MODIFY `asset_id` int unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.';
ALTER TABLE `#__ucm_content` MODIFY `core_images` text;
ALTER TABLE `#__ucm_content` MODIFY `core_urls` text;
ALTER TABLE `#__ucm_content` MODIFY `core_metakey` text;
ALTER TABLE `#__ucm_content` MODIFY `core_metadesc` text;
ALTER TABLE `#__ucm_content` MODIFY `core_xreference` varchar(50) NOT NULL DEFAULT '' COMMENT 'A reference to enable linkages to external data sets.';
ALTER TABLE `#__ucm_content` MODIFY `core_type_id` int unsigned NOT NULL DEFAULT 0;
3.7.0-2017-02-17.sql

Code: Select all

-- Normalize contact_details table default values.
ALTER TABLE `#__contact_details` MODIFY `name` varchar(255) NOT NULL;
ALTER TABLE `#__contact_details` MODIFY `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE `#__contact_details` MODIFY `sortname1` varchar(255) NOT NULL DEFAULT '';
ALTER TABLE `#__contact_details` MODIFY `sortname2` varchar(255) NOT NULL DEFAULT '';
ALTER TABLE `#__contact_details` MODIFY `sortname3` varchar(255) NOT NULL DEFAULT '';
ALTER TABLE `#__contact_details` MODIFY `language` varchar(7) NOT NULL;
ALTER TABLE `#__contact_details` MODIFY `xreference` varchar(50) NOT NULL DEFAULT '' COMMENT 'A reference to enable linkages to external data sets.';
3.7.0-2017-03-03.sql

Code: Select all

ALTER TABLE `#__languages` MODIFY `asset_id` int unsigned NOT NULL DEFAULT 0;
ALTER TABLE `#__menu_types` MODIFY `asset_id` int unsigned NOT NULL DEFAULT 0;

ALTER TABLE  `#__content` MODIFY `xreference` varchar(50) NOT NULL DEFAULT '';
ALTER TABLE  `#__newsfeeds` MODIFY `xreference` varchar(50) NOT NULL DEFAULT '';
3.7.3-2017-06-03.sql

Code: Select all

ALTER TABLE `#__menu` MODIFY `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'The time the menu item was checked out.';

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 31000
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: 5.03 to 5.1 database structure errors

Post by Per Yngve Berg » Sun Apr 21, 2024 6:34 pm

Delete the files. They belong to 3.7

Running them may cause problems as they may make changes that are changed again in a later version.

User avatar
ceford
Joomla! Hero
Joomla! Hero
Posts: 2723
Joined: Mon Feb 24, 2014 10:38 pm
Location: Edinburgh, Scotland
Contact:

Re: 5.03 to 5.1 database structure errors

Post by ceford » Sun Apr 21, 2024 10:15 pm

I think Per is probably right. I don't think there should be any references to 3.7.0 in a J5 installation. It might be a good idea to run the Forum Post Assistant and post the public results here.

And tell us more about the history of the site. Was it updated from 3 to 4 and then to 5?

ccgr
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 104
Joined: Thu May 15, 2008 2:58 pm

Re: 5.03 to 5.1 database structure errors

Post by ccgr » Mon Apr 22, 2024 2:53 am

We've been running Joomla since 1.0....

Forum Post Assistant (v1.6.6) : 21-Apr-2024 wrote:
Basic Environment :: wrote:Joomla! Instance :: Joomla! 5.0.3-Stable (Kuboresha) 20-February-2024
Joomla! Platform :: Joomla Platform 13.1.0-Stable (Curiosity) 24-Apr-2013
Joomla! Configured :: Yes | Read-Only (444) |
Configuration Options :: Offline: false | SEF: true | SEF Suffix: false | SEF ReWrite: true | .htaccess/web.config: Yes | GZip: false | Cache: true | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: false | FTP Layer: N/A | Proxy: false | LiveSite: | Session lifetime: 15 | Session handler: filesystem | Shared sessions: false | SSL: 0 | Error Reporting: default | Site Debug: false | Language Debug: false | Default Access: Public | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 5.0.3: Yes | Database Supports J! 5.0.3: Yes | Database Credentials Present: Yes |

Host Configuration :: OS: Linux | OS Version: 5.15.0-102-generic | Technology: x86_64 | Web Server: Apache/2.4.52 (Ubuntu) | Encoding: gzip, deflate, br, zstd | System TMP Writable: Yes | Free Disk Space : 19.29 GiB |

PHP Configuration :: Version: 8.1.2-1ubuntu2.15 | PHP API: fpm-fcgi | Session Path Writable: Yes | Display Errors: 0 | Error Reporting: 22527 | Log Errors To: | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 25M | Max. POST Size: 8M | Max. Input Time: 60 | Max. Execution Time: 30 | Memory Limit: 256M

Database Configuration :: Version: 8.0.36-0ubuntu0.22.04.1 (Client:mysqlnd 8.1.2-1ubuntu2.15) | Database Size: 535.68 MiB | #of Tables with config prefix:  173 | #of other Tables:  0 | User Privileges : GRANT SELECTUser Privileges : INSERTUser Privileges : UPDATEUser Privileges : DELETEUser Privileges : CREATEUser Privileges : DROPUser Privileges : INDEXUser Privileges : ALTERUser Privileges : CREATE TEMPORARY TABLESUser Privileges : EXECUTEUser Privileges : CREATE VIEWUser Privileges : SHOW VIEWUser Privileges : CREATE ROUTINEUser Privileges : ALTER ROUTINEUser Privileges : EVENTUser Privileges : TRIGGER
Detailed Environment :: wrote:PHP Extensions :: Core (8.1.2-1ubuntu2.15) | date (8.1.2-1ubuntu2.15) | libxml (8.1.2-1ubuntu2.15) | openssl (8.1.2-1ubuntu2.15) | pcre (8.1.2-1ubuntu2.15) | zlib (8.1.2-1ubuntu2.15) | filter (8.1.2-1ubuntu2.15) | hash (8.1.2-1ubuntu2.15) | json (8.1.2-1ubuntu2.15) | Reflection (8.1.2-1ubuntu2.15) | SPL (8.1.2-1ubuntu2.15) | session (8.1.2-1ubuntu2.15) | standard (8.1.2-1ubuntu2.15) | sodium (8.1.2-1ubuntu2.15) | cgi-fcgi (8.1.2-1ubuntu2.15) | mysqlnd (mysqlnd 8.1.2-1ubuntu2.15) | PDO (8.1.2-1ubuntu2.15) | xml (8.1.2-1ubuntu2.15) | bz2 (8.1.2-1ubuntu2.15) | calendar (8.1.2-1ubuntu2.15) | ctype (8.1.2-1ubuntu2.15) | curl (8.1.2-1ubuntu2.15) | dom (20031129) | enchant (8.1.2-1ubuntu2.15) | mbstring (8.1.2-1ubuntu2.15) | FFI (8.1.2-1ubuntu2.15) | fileinfo (8.1.2-1ubuntu2.15) | ftp (8.1.2-1ubuntu2.15) | gd (8.1.2-1ubuntu2.15) | gettext (8.1.2-1ubuntu2.15) | iconv (8.1.2-1ubuntu2.15) | intl (8.1.2-1ubuntu2.15) | exif (8.1.2-1ubuntu2.15) | mysqli (8.1.2-1ubuntu2.15) | pdo_mysql (8.1.2-1ubuntu2.15) | Phar (8.1.2-1ubuntu2.15) | posix (8.1.2-1ubuntu2.15) | readline (8.1.2-1ubuntu2.15) | shmop (8.1.2-1ubuntu2.15) | SimpleXML (8.1.2-1ubuntu2.15) | sockets (8.1.2-1ubuntu2.15) | sysvmsg (8.1.2-1ubuntu2.15) | sysvsem (8.1.2-1ubuntu2.15) | sysvshm (8.1.2-1ubuntu2.15) | tokenizer (8.1.2-1ubuntu2.15) | xmlreader (8.1.2-1ubuntu2.15) | xmlwriter (8.1.2-1ubuntu2.15) | xsl (8.1.2-1ubuntu2.15) | zip (1.19.5) | Zend OPcache (8.1.2-1ubuntu2.15) | Zend Engine (4.1.2) |
Potential Missing Extensions ::

Switch User Environment :: PHP CGI: Yes | Server SU: No | PHP SU: Yes | Potential Ownership Issues: Maybe
Folder Permissions :: wrote:Core Folders :: images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (755) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) | administrator/logs/ (755) | api/ (755) |

Elevated Permissions (First 10) :: images/apico/ (775) | images/civ2gold/ (775) | images/clickclack/ (775) | images/comanche/ (775) | images/fishing/ (775) | images/gobar/ (775) | images/gravitar/ (775) | images/pockyrocky/ (775) | images/reyee/ (775) | images/sushi/ (775) |
Database Information :: wrote:Database statistics :: Uptime: 196490 | Threads: 8 | Questions: 30244428 | Slow queries: 96016 | Opens: 9770 | Flush tables: 3 | Open tables: 4000 | Queries per second avg: 153.923 |
Extensions Discovered :: wrote:Components :: Site ::
Core :: com_mailto (3.0.0) ? | com_wrapper (3.0.0) 1 |
3rd Party:: Bluedream (4.0) ? | Bubbles (4.0) ? | Carbon (4.0) ? | Nomad (4.0) ? | Origami (4.0) ? | Plain (4.0) ? | Vintage (4.0) ? | Wireframe (4.0) ? | Bluedream (4.0) ? | Bubbles (4.0) ? | Carbon (4.0) ? | Elegant (4.0) ? | Hako (4.0) ? | Nickel (4.0) ? | Nomad (4.0) ? | Origami (4.0) ? | Pastel (3.5) ? | Plain (4.0) ? | Simplistic (4.0) ? | Timeless (4.0) ? | UIkit (4.0) ? | Vintage (4.0) ? | Wireframe (4.0) ? | Helix (4.0) ? | Bluedream (4.0) ? | Bubbles (4.0) ? | Carbon (4.0) ? | Elegant (4.0) ? | Hako (4.0) ? | Helix (4.0) ? | Nickel (4.0) ? | Nomad (4.0) ? | Origami (4.0) ? | Pastel (3.5) ? | Plain (4.0) ? | Simplistic (4.0) ? | Timeless (4.0) ? | UIkit (4.0) ? | Vintage (4.0) ? | Wireframe (4.0) ? | Bluedream (4.0) ? | Bubbles (4.0) ? | Carbon (4.0) ? | Elegant (4.0) ? | Hako (4.0) ? | Helix (4.0) ? | Nickel (4.0) ? | Nomad (4.0) ? | Origami (4.0) ? | Pastel (3.5) ? | Plain (4.0) ? | Simplistic (4.0) ? | Timeless (4.0) ? | UIkit (4.0) ? | Vintage (4.0) ? | Wireframe (4.0) ? | joomla_int (2.1.0-0) ? | phpbb31 (2.1.0-2) ? |

Components :: Admin ::
Core :: com_actionlogs (3.9.0) 1 | com_admin (4.0.0) 1 | com_ajax (4.0.0) 1 | com_associations (4.0.0) 1 | com_banners (4.0.0) 1 | com_cache (4.0.0) 1 | com_categories (4.0.0) 1 | com_checkin (4.0.0) 1 | com_config (4.0.0) 1 | com_content (4.0.0) 1 | com_contenthistory (4.0.0) 1 | com_cpanel (4.0.0) 1 | com_fields (4.0.0) 1 | com_finder (4.0.0) 1 | com_installer (4.0.0) 1 | com_joomlaupdate (4.0.3) 1 | com_languages (4.0.0) 1 | com_login (4.0.0) 1 | com_media (3.0.0) 1 | com_menus (4.0.0) 1 | com_messages (4.0.0) 1 | com_modules (4.0.0) 1 | com_newsfeeds (4.0.0) 1 | com_plugins (4.0.0) 1 | com_postinstall (4.0.0) 1 | com_privacy (3.9.0) 1 | com_redirect (4.0.0) 1 | com_search (3.0.0) ? | com_tags (4.0.0) 1 | com_templates (4.0.0) 1 | com_users (4.0.0) 1 | com_weblinks (3.9.0) ? | com_mails (4.0.0) 1 | com_scheduler (4.1.0) 1 | com_workflow (4.0.0) 1 | com_wrapper (4.0.0) 1 | com_guidedtours (4.3.0) 1 |
3rd Party:: Advanced OpenPortal (1) ? | System - AltaUserPoints (1.9.0) ? | altauserpointsicon (1.9.0) ? | AltaUserPoints - Example Plugin for (1.9.0) ? | AltaUserPoints - Notification on up (1.9.0) ? | Editor Button - AltaUserPoints Raff (1.6.0) ? | Content - AltaUserPoints - Standard (2.0.0) ? | User - AltaUserPoints - New user (1.0.0) ? | User - AltaUserPoints - New user (1.0.0) ? | Content - AltaUserPoints - Raffle (1.9.1) ? | Content - AltaUserPoints - Reader t (1.9.0) ? | AltaUserPoints (1.1.14) ? | COM_AUTHORLIST (1.3.8) ? | com_bfstop (1.4.4) ? | COM_CMC (4.1.2) ? | com_easyblog (6.0.10) 1 | com_jfusion (2.1.0-0) ? | COM_MIJOFTP (1.1.4) ? | mobilejoomla (2.1.51) ? | Remository (3.58) ? | COM_SITEMAP (1.0) ? | JoomRSS (1.2.5) ? | Maximenu CK (10.1.5) 1 | com_maximenuck (10.1.5) 1 | com_p8pbb (4.1.7) ? | Content - imagerecycle (2.0.16) ? | ImageRecycle Statistics (2.0.16) ? | ImageRecycle (2.0.20) ? | JCH Optimize (6.5.0) ? | com_jDownloads (3.9.8.3.2) ? | COM_JCHOPTIMIZE (7.2.1) ? | WATCHFULLI (2.2.9) ? | com_jaextmanager (2.5.3) 1 | com_jaextmanager (2.7.6) 1 | COM_QUANTUMMANAGER (3.0.1) 0 | COM_JLSITEMAP (1.12.0) 1 |

Modules :: Site ::
Core :: mod_articles_archive (3.0.0) 1 | mod_articles_categories (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_articles_news (3.0.0) 1 | mod_articles_popular (3.0.0) 1 | mod_banners (3.0.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_finder (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_languages (3.5.0) 1 | mod_login (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_random_image (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_search (3.0.0) ? | mod_stats (3.0.0) 1 | mod_syndicate (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_tags_similar (3.1.0) 1 | mod_users_latest (3.0.0) 1 | mod_weblinks (3.9.0) ? | mod_whosonline (3.0.0) 1 | mod_wrapper (3.0.0) 1 |
3rd Party:: AltaUserPoints - Actual Points (1.0.1) ? | AltaUserPoints - Coupon Code (1.0.0) ? | AltaUserPoints - Last points earned (1.0.0) ? | AltaUserPoints - Lastest activity (1.0.0) ? | AltaUserPoints - Monthly statistics (1.0.0) ? | AltaUserPoints - Most Active Users (1.0.0) ? | AltaUserPoints - Most Referral User (1.0.0) ? | AltaUserPoints - Online Users (1.0.0) ? | AltaUserPoints - Points from Start (1.0.1) ? | Recently Hit (1.1.1) ? | mod_cmc (4.1.2) ? | EasyBlog - Archive Module (6.0.10) ? | EasyBlog - Biography Module (6.0.10) ? | EasyBlog - Calendar Module (6.0.10) ? | Easyblog - Categories Module (6.0.10) ? | EasyBlog - Custom Field Search Modu (6.0.10) ? | EasyBlog - Image Wall Module (6.0.10) ? | EasyBlog - Latest Bloggers Module (6.0.10) ? | EasyBlog - Latest Blogs Module (6.0.10) 1 | EasyBlog - Latest Comments Module (6.0.10) ? | EasyBlog - Posts List (6.0.10) ? | EasyBlog - Most Commented Post Modu (6.0.10) ? | EasyBlog - Most Popular Post Module (6.0.10) ? | EasyBlog - Post Map Module (6.0.10) ? | EasyBlog - Post Meta Module (6.0.10) ? | EasyBlog - Quick Post Module (6.0.10) ? | EasyBlog - Random Post Module (6.0.10) ? | EasyBlog - Related Posts Module (6.0.10) ? | EasyBlog - Search Blogs Module (6.0.10) ? | EasyBlog - Showcase Module (6.0.10) ? | EasyBlog - Subscribe Module (6.0.10) ? | EasyBlog - Subscribers Listing Modu (6.0.10) ? | EasyBlog - Tag Cloud Module (6.0.10) ? | EasyBlog - Team Blogs Module (6.0.10) ? | EasyBlog - Ticker Module (6.0.10) ? | EasyBlog - Toolbar (5.4.13) ? | EasyBlog - Top Blogs Module (6.0.10) ? | EasyBlog - Welcome Module (6.0.10) ? | GTranslate (4.0.3) 1 | Infolinks In Text Ads (1.7.1) ? | JFusion Activity Module (2.1.0-0) ? | JFusion Login Module (2.1.0-0) ? | JFusion User Activity Module (2.1.0-0) ? | JFusion Whos Online Module (2.1.0-0) ? | MOD_JPAYDAY (1.0.1) ? | Maximenu CK (10.1.5) 1 | Mobile - Proxy Module (2.1.51) ? | Mobile - Proxy Position (2.1.51) ? | Mobile - Mobile Switcher (2.1.51) ? | MOD_OSDONATE (2.0.0) ? | JW Player Module (3.12.1) ? | Perfect Facebook Like Box Sidebar (1.0.10) ? | Random Article (1.4.1.78) ? | Remository Newest (3.56J3) ? | Most Downloaded in last X days (3.56J3) ? | S5 Accordion Menu (2.1.0) ? | S5 Box (5.0.0) ? | S5 Image and Content Fader v3 (3.2.0) ? | S5 Register (3.2.0) ? | S5 Tab Show (2.0.0) ? | Sticky Top / Bottom Banners (1.2.0) ? | WDS Twitter Widget (1.2.1) ? | WTAdblocker Detector (1.0.3) ? | EasyBlog - Navigation Button (6.0.10) ? | JoomRSS (1.0) ? | MOD_P8PBBATTACHMENTS (4.0.0) ? | MOD_P8PBBLATEST (4.0.0) ? | MOD_P8PBBLOGIN (4.0.0) ? | MOD_P8PBBSTATS (4.0.0) ? | MOD_P8PBBTAGS (4.0.0) ? | EasyBlog - Blogger Cloud Module (6.0.10) ? | AJAX Search (1.0.1) ? | jDownloads Featured (3.9.8.2) ? | jDownloads Last Updated (3.9.8.2) ? | jDownloads Latest (3.9.8.2) ? | jDownloads Most Recently Downloaded (3.9.8.3) ? | jDownloads Rated (3.9.8.2) ? | jDownloads Related (3.9.8.2) ? | jDownloads Stats (3.9.3) ? | jDownloads Top (3.9.8.3) ? | jDownloads Tree (3.9.3) ? | jDownloads View Limits (3.9.0) ? | StackIdeas Toolbar (1.0.20) 1 | EB Dark Mode (1.7) 1 | Image Show GK4 (1.8.1) 1 | mod_jdsimplecontactform (1.9) 1 | JMG Live Search (1.1.8) 1 | JMZ Widget Twitter (1.2) 1 | Articles Good Search (1.2.2) 0 | CG Scroll (4.3.5) 1 | Fade in fade out rss feed (4.0) 1 | JMP Search (1.1.0) ? |

Modules :: Admin ::
Core :: mod_custom (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_latest (3.0.0) 1 | mod_latestactions (3.9.0) 1 | mod_logged (3.0.0) 1 | mod_login (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_multilangstatus (3.0.0) 1 | mod_popular (3.0.0) 1 | mod_privacy_dashboard (3.9.0) 1 | mod_quickicon (3.0.0) 1 | mod_sampledata (3.8.0) 1 | mod_stats_admin (3.0.0) 1 | mod_status (3.0.0) ? | mod_submenu (3.0.0) 1 | mod_title (3.0.0) 1 | mod_toolbar (3.0.0) 1 | mod_version (3.0.0) 1 | mod_frontend (4.0.0) 1 | mod_loginsupport (4.0.0) 1 | mod_messages (4.0.0) 1 | mod_post_installation_messages (4.0.0) 1 | mod_privacy_status (4.0.0) 1 | mod_user (4.0.0) 1 | mod_guidedtours (4.3.0) 1 |
3rd Party:: ImageRecycle Statistics (2.0.16) ? | mod_jdownloads_admin_monitoring (3.9.0) ? | mod_jdownloads_admin_stats (3.9.6) ? | Import Content (1.0) 1 |

Libraries ::
Core ::
3rd Party:: Library - compojoom (5.2.3) ? | Regular Labs Library (24.3.3300) 1 | file_fof40 (4.0.8) ? | GeoIP (5.1.1) ? | Library - Foundry by Stackideas (1.1.17) 1 |

Last edited by toivo on Mon Apr 22, 2024 2:57 am, edited 1 time in total.
Reason: mod note: disabled smilies in post Options for readability

ccgr
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 104
Joined: Thu May 15, 2008 2:58 pm

Re: 5.03 to 5.1 database structure errors

Post by ccgr » Mon Apr 22, 2024 2:57 am

Plugins ::
Core :: plg_actionlog_joomla (3.9.0) 1 | plg_authentication_cookie (3.0.0) 1 | plg_authentication_gmail (3.0.0) ? | plg_authentication_joomla (3.0.0) 1 | plg_authentication_ldap (3.0.0) 0 | plg_captcha_recaptcha (3.4.0) ? | plg_captcha_recaptcha_invisible (3.8) 0 | plg_content_confirmconsent (3.9.0) 0 | plg_content_emailcloak (3.0.0) 1 | plg_content_fields (3.7.0) 1 | plg_content_finder (3.0.0) 1 | plg_content_geshi (2.5.0) ? | plg_content_joomla (3.0.0) 1 | plg_content_loadmodule (3.0.0) 1 | plg_content_pagebreak (3.0.0) 1 | plg_content_pagenavigation (3.0.0) 1 | plg_content_vote (3.0.0) 0 | plg_editors-xtd_article (3.0.0) 1 | plg_editors-xtd_fields (3.7.0) 1 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_menu (3.7.0) 1 | plg_editors-xtd_module (3.5.0) 1 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_editors-xtd_readmore (3.0.0) 1 | plg_editors-xtd_weblink (3.9.0) ? | plg_extension_joomla (3.0.0) 1 | plg_extension_finder (4.0.0) 1 | plg_extension_namespacemap (4.0.0) 1 | plg_fields_calendar (3.7.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_color (3.7.0) 1 | plg_fields_editor (3.7.0) 1 | plg_fields_imagelist (3.7.0) 1 | plg_fields_integer (3.7.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_repeatable (3.9.0) ? | plg_fields_sql (3.7.0) 1 | plg_fields_text (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_fields_url (3.7.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_usergrouplist (3.7.0) 1 | plg_fields_subform (4.0.0) 1 | plg_finder_categories (3.0.0) 1 | plg_finder_contacts (3.0.0) 1 | plg_finder_content (3.0.0) 1 | plg_finder_newsfeeds (3.0.0) 1 | plg_finder_tags (3.0.0) 1 | plg_finder_weblinks (3.9.0) ? | plg_installer_folderinstaller (3.6.0) 1 | plg_installer_packageinstaller (3.6.0) 1 | plg_installer_urlinstaller (3.6.0) 1 | plg_installer_webinstaller (4.0.0) 1 | plg_installer_override (4.0.0) 1 | plg_privacy_actionlogs (3.9.0) 1 | plg_privacy_consents (3.9.0) 1 | plg_privacy_content (3.9.0) 1 | plg_privacy_message (3.9.0) 1 | plg_privacy_user (3.9.0) 1 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_quickicon_phpversioncheck (3.7.0) 1 | plg_quickicon_privacycheck (3.9.0) 1 | plg_quickicon_eos310 (3.10.0) ? | plg_quickicon_downloadkey (4.0.0) 1 | plg_quickicon_overridecheck (4.0.0) 1 | plg_quickicon_eos (4.4.0) 1 | plg_sampledata_multilang (4.0.0) 1 | plg_search_categories (3.0.0) ? | plg_search_contacts (3.0.0) ? | plg_search_content (3.0.0) ? | plg_search_newsfeeds (3.0.0) ? | plg_search_tags (3.0.0) ? | plg_search_weblinks (3.9.0) ? | plg_system_actionlogs (3.9.0) 1 | plg_system_cache (3.0.0) 0 | plg_system_debug (3.0.0) 1 | plg_system_fields (3.7.0) 1 | plg_system_highlight (3.0.0) 1 | plg_system_languagecode (3.0.0) 0 | plg_system_languagefilter (3.0.0) 0 | plg_system_log (3.0.0) 1 | plg_system_logout (3.0.0) 1 | plg_system_logrotation (3.9.0) ? | plg_system_p3p (3.0.0) ? | plg_system_privacyconsent (3.9.0) 0 | plg_system_redirect (3.0.0) 0 | plg_system_remember (3.0.0) 1 | plg_system_sef (3.0.0) 1 | plg_system_sessiongc (3.8.6) ? | plg_system_stats (3.5.0) 1 | plg_system_updatenotification (3.5.0) ? | plg_system_weblinks (3.9.0) ? | plg_system_accessibility (4.0.0) 0 | plg_system_httpheaders (4.0.0) 1 | plg_system_jooa11y (4.2.0) 1 | plg_system_schedulerunner (4.1) 1 | plg_system_skipto (4.0.0) 1 | plg_system_task_notification (4.1) 1 | plg_system_webauthn (4.0.0) 1 | plg_system_shortcut (4.2.0) 1 | plg_system_guidedtours (4.3.0) 1 | plg_system_schemaorg (5.0.0) 1 | plg_twofactorauth_totp (3.2.0) ? | plg_twofactorauth_yubikey (3.2.0) ? | plg_user_contactcreator (3.0.0) 0 | plg_user_joomla (3.0.0) 1 | plg_user_profile (3.0.0) 0 | plg_user_terms (3.9.0) 0 | plg_user_token (3.9.0) 1 | plg_api-authentication_basic (4.0.0) 0 | plg_api-authentication_token (4.0.0) 1 | plg_behaviour_taggable (4.0.0) 1 | plg_behaviour_versionable (4.0.0) 1 | plg_behaviour_compat (5.0.0) 1 | plg_filesystem_local (4.0.0) 1 | plg_media-action_crop (4.0.0) 1 | plg_media-action_resize (4.0.0) 1 | plg_media-action_rotate (4.0.0) 1 | plg_task_check_files (4.1) 1 | plg_task_demo_tasks (4.1) ? | plg_task_requests (4.1) 1 | plg_task_site_status (4.1) 1 | plg_task_deleteactionlogs (5.0.0) 1 | plg_task_globalcheckin (5.0.0) 1 | plg_task_privacyconsent (5.0.0) 1 | plg_task_rotatelogs (5.0.0) 1 | plg_task_sessiongc (5.0.0) 1 | plg_task_updatenotification (5.0.0) 1 | plg_webservices_banners (4.0.0) 1 | plg_webservices_config (4.0.0) 1 | plg_webservices_content (4.0.0) 1 | plg_webservices_installer (4.0.0) 1 | plg_webservices_languages (4.0.0) 1 | plg_webservices_media (4.1.0) 1 | plg_webservices_menus (4.0.0) 1 | plg_webservices_messages (4.0.0) 1 | plg_webservices_modules (4.0.0) 1 | plg_webservices_newsfeeds (4.0.0) 1 | plg_webservices_plugins (4.0.0) 1 | plg_webservices_privacy (4.0.0) 1 | plg_webservices_redirect (4.0.0) 1 | plg_webservices_tags (4.0.0) 1 | plg_webservices_templates (4.0.0) 1 | plg_webservices_users (4.0.0) 1 | plg_workflow_featuring (4.0.0) 1 | plg_workflow_notification (4.0.0) 1 | plg_workflow_publishing (4.0.0) 1 | plg_multifactorauth_email (4.2.0) 0 | plg_multifactorauth_fixed (4.2.0) 0 | plg_multifactorauth_totp (3.2.0) 1 | plg_multifactorauth_webauthn (4.2.0) 0 | plg_multifactorauth_yubikey (3.2.0) 0 | plg_schemaorg_blogposting (5.0.0) 1 | plg_schemaorg_book (5.0.0) 1 | plg_schemaorg_event (5.0.0) 1 | plg_schemaorg_jobposting (5.0.0) 1 | plg_schemaorg_organization (5.0.0) 1 | plg_schemaorg_person (5.0.0) 1 | plg_schemaorg_recipe (5.0.0) 1 |
3rd Party:: Ajax - JA Content Type (1.2.0) 1 | AlphaUserPoints - Example Plugin fo (1.9.0) ? | AltaUserPoints - Example Plugin for (1.9.0) ? | AltaUserPoints - Notification on up (1.9.0) ? | Authentication - JFusion (2.1.0-0) ? | PLG_AUTHENTICATION_P8PBB (4.0.0) ? | Captcha - Aimy Captcha-Less Form Gu (11.3) ? | plg_captcha_recaptcha_v3 (1.1.1) 1 | Community - CMC Registration plugin (4.1.2) ? | PLG_COMMUNITY_P8PBB (4.0.0) ? | PLG_CONTENT_AUTHORLIST (1.2.3) ? | Content - JFusion Discussion Bot (2.1.0-0) ? | AllVideos (by JoomlaWorks) (6.1.0) ? | AllVideos (by JoomlaWorks) (6.1.0) ? | Simple Image Gallery (by JoomlaWork (4.2) ? | Simple Image Gallery (by JoomlaWork (4.2) ? | Spoiler Alert (0.2) ? | PLG_CONTENT_RECENTLYHIT (1.0.0) ? | Content - Simple Disqus Comments (1.7.1) ? | Content - SocButtons (1.6.0) ? | Content - AltaUserPoints - Standard (2.0.0) ? | Content - AltaUserPoints - Raffle (1.9.1) ? | Content - AltaUserPoints - Reader t (1.9.0) ? | Content - Load JoomRSS (1.0) ? | Content - imagerecycle (2.0.16) ? | PLG_CONTENT_CONTENTSPOILER (1.4) ? | plg_content_jdownloads (3.9.8.2) ? | plg_content_jdownloads_tags_fix (3.9.0) ? | PLG_CONTENT_[youtube] (4.0.3) 1 | Content - Social 2s (4.3.53) 1 | PLG_CONTENT_TTMENUSTYLE (1.0.0) 1 | PLG_CONTENT_QUANTUMMANAGERCONTENT (1.4) 0 | Content - Aimy IndexNow (5.0) 1 | EasyBlog - Auto Article (5.1.0) 0 | EasyBlog - Pagebreak (5.1.0) 1 | Spoiler Alert Editor Button (0.2) ? | Editor Button - AltaUserPoints Raff (1.6.0) ? | PLG_EDITORS-XTD_SOURCERER (10.1.1) 1 | plg_editors-xtd_jdownloads (3.9.0) ? | Button - EasyBlog Google Import (1.0.0) 1 | Button - EasyBlog Polls (1.0.0) 1 | PLG_BUTTON_QUANTUMMANAGERBUTTON (1.4) 0 | plg_editors_codemirror (6.0.0) 1 | plg_editors_tinymce (6.7.3) 1 | Smart Search - EasyBlog Posts (5.1.0) 0 | plg_finder_folder (3.9.6) ? | plg_finder_jdownloads (3.9.6) ? | Installer - EasyBlog (5.2.0) 1 | Installer - StackIdeas (1.0.1) 0 | Mobile - Forever (2.1.51) ? | Mobile - AMDD (2.1.51) ? | Mobile - Domains (2.1.51) ? | Mobile - Simple (2.1.51) ? | QMap - Categories (1.0) ? | QMap - Content (1.0) ? | QMap - Menu (1.0) ? | altauserpointsicon (1.9.0) ? | Quickicon - Mobile CPanel Icon (2.1.51) ? | PLG_QUANTUMMANAGERICON (1.3.2) 1 | Search - Content Advanced (2.2.0) ? | Search - Easy Blog (5.1.0) 0 | Search - JFusion (2.1.0-0) ? | PLG_SEARCH_P8PBBSEARCH (4.0.0) ? | plg_search_content_improved (1.0.0) ? | plg_search_jdownloads (3.9.0) ? | System - S5 Flex Menu (1.0) ? | System - AltaUserPoints (1.9.0) ? | plg_system_bfstop (1.4.4) ? | System - EasyBlog Composer (5.1.0) ? | System - CMC Mailchimp ecommerce360 (4.1.2) ? | System - CMC Ecom360 Akeebasubs (4.1.2) ? | CMC - Ecom360 Hika (4.1.2) ? | System - CMC ecom360 Matukio (4.1.2) ? | System - CMC Ecom360 Payplans (4.1.2) ? | System - CMC Ecom360 Redshop (4.1.2) ? | System - CMC Ecom360 Virtuemart (4.1.2) ? | System - Fail2Ban (1.0.5) ? | PLG_SYSTEM_GEOIP (5.1.1) ? | System - JFusion (2.1.0-0) ? | System - JTouch Mobile 3 Controller (3.3.1-stable) ? | System - Mobile Core (2.1.51) ? | System - Mobile Page Optimizer (2.1.51) ? | plg_system_ossystem (1.3.1) ? | PLG_SYSTEM_REGULARLABS (24.3.3300) 1 | PLG_SYSTEM_SOURCERER (10.1.1) 1 | System - JoomRSS (1.0) ? | PLG_SYSTEM_P8PBBAUP (4.0.0) ? | PLG_SYSTEM_P8PBBESACTIVITY (4.0.0) ? | PLG_SYSTEM_P8PBBJSACTIVITY (4.0.0) ? | PLG_SYS_EXPIRESHEADERS (3.1.1) ? | PLG_SYSTEM_JCH_OPTIMIZE (6.5.0) ? | PLG_SYSTEM_HEADERTAGS (3.2.1) ? | plg_system_jdownloads (3.9.8.2) ? | PLG_SYSTEM_JCHOPTIMIZE (7.2.1) ? | plg_system_osmylicensesmanager (2.0.17) 1 | System - Foundry by Stackideas (1.1.17) 1 | PLG_SYSTEM_JCHOPTIMIZEPAGECACHE (7.2.1) ? | System - JA Content Type (1.2.2) 1 | System - JA Tabs (2.6.5) 1 | System - JA Tabs (2.7.0) 1 | PLG_QUANTUMMANAGERCONFIG (1.1) 1 | PLG_QUANTUMMANAGERMEDIA (1.8) 1 | PLG_QUANTUMMENUS (1.0) 0 | PLG_QUANTUMSPBUILDER (1.5) 0 | PLG_QUANTUMYOOTHEMEPRO (1.7.1) 0 | System - Ruxin Font Resizer (1.1.3) 1 | T3 Framework (3.2.0) 1 | PLG_SYSTEM_JLSITEMAP_CRON (1.12.0) 1 | System - Articles Good Search J4 (1.2.2) 0 | ASM No Admin (1.0.0) 1 | User - CMC Registration plugin (-) ? | User - EasyBlog Users (5.1.0) 1 | User - JFusion (2.1.0-0) ? | User - AltaUserPoints - New user (1.0.0) ? | PLG_USER_P8PBB (4.0.0) ? | JoomRSS - Cobalt CCK (1.0) ? | JoomRSS - Community Builder (1.0) ? | JoomRSS - Content (1.2.0) ? | JoomRSS - DJ-Classifieds (1.0) ? | JoomRSS - Docman (1.2.1) ? | JoomRSS - DT Register (1.0) ? | JoomRSS - FLEXIcontent (1.0) ? | JoomRSS - HikaShop (1.0) ? | JoomRSS - JCal Pro (1.0) ? | JoomRSS - JComments (1.0) ? | JoomRSS - JEvents (1.0) ? | JoomRSS - JoomMedia (1.1.0) ? | JoomRSS - JoomProject (1.0) ? | JoomRSS - JReviews (1.0) ? | JoomRSS - K2 (1.2.0) ? | JoomRSS - Kunena (1.0) ? | JoomRSS - Mosets Tree (1.0) ? | JoomRSS - PhocaDownload (1.0) ? | JoomRSS - RSEvents! Pro (1.0) ? | JoomRSS - RSS Merge (2.3) ? | JoomRSS - Sobi Pro (1.0) ? | JoomRSS - VirtueMart (1.0) ? | JoomRSS - Zoo (1.0) ? | PLG_JCOMMENTS_P8PBBAVATARS (4.0.0) ? | PLG_OSMAP_COM_P8PBB (4.0.0) ? | PLG_OSMAP_P8PBB (4.0.0) ? | plg_jdownloads_example (3.9.0) ? | PLG_JLSITEMAP_CONTENT (1.12.0) 1 | PLG_JLSITEMAP_K2 (1.12.0) 0 | PLG_JLSITEMAP_KUNENA (1.12.0) 0 | PLG_JLSITEMAP_TAGS (1.12.0) 0 | PLG_JLSITEMAP_VIRTUEMART (1.12.0) 0 | [/size][/quote]
Templates Discovered :: wrote:Templates :: Site :: atomic (2.5.0) ? | beez3 (3.1.0) ? | beez5 (2.5.0) ? | beez_20 (2.5.0) ? | gamers (1.0) 0 | gamers (1.0) 0 | jtouch3 (3.3.1-stable) ? | Mobile_Basic (2.1.48) ? | protostar (1.0) ? | mod_search (1.7.0) ? | cardelar-j4 (1.0) ? | cassiopeia (1.0) 1 | gk_rockwall (4.0) ? | ja_focus (2.0.1) 1 |
Templates :: Admin :: bluestork (2.5.0) ? | hathor (3.0.0) ? | isis (1.0) ? | atum (1.0) 1 |
Last edited by toivo on Mon Apr 22, 2024 2:58 am, edited 1 time in total.
Reason: mod note: disabled smilies in post Options for readability

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 31000
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: 5.03 to 5.1 database structure errors

Post by Per Yngve Berg » Mon Apr 22, 2024 3:34 am

Max. Upload Size: 25M | Max. POST Size: 8M

To small. Post size must be larger than upload.

Recommend 64M and 128M

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 44127
Joined: Sat Apr 05, 2008 9:58 pm

Re: 5.03 to 5.1 database structure errors

Post by Webdongle » Mon Apr 22, 2024 3:38 am

Your fpa report is incomplete
You have j3 templates front and back
You have a virtumart plugin ... vm for j5 is a paid for product. If you have the free vm it is incompatible with j5

Your site was probably broken during an update from j3
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

User avatar
ceford
Joomla! Hero
Joomla! Hero
Posts: 2723
Joined: Mon Feb 24, 2014 10:38 pm
Location: Edinburgh, Scotland
Contact:

Re: 5.03 to 5.1 database structure errors

Post by ceford » Mon Apr 22, 2024 5:52 am

Have a look for a file named administrator/logs/joomla_update.php and other files with a similar name. Open with a text editor and scan down through the update report looking for execution of sql files. Yo may find error messages or other evidence of failure to complete an update.

ccgr
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 104
Joined: Thu May 15, 2008 2:58 pm

Re: 5.03 to 5.1 database structure errors

Post by ccgr » Tue Apr 23, 2024 1:35 am

I wound up doing a fresh 5.1 install and imported the data back in.


Post Reply

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