Error in database from Joomla 2.5 to Joomla 3

Need help upgrading your Joomla! website or converting to Joomla! 3.x?
Post Reply
User avatar
cspgsl
Joomla! Explorer
Joomla! Explorer
Posts: 326
Joined: Thu Nov 09, 2006 11:35 am

Error in database from Joomla 2.5 to Joomla 3

Post by cspgsl » Mon Dec 07, 2020 12:56 pm

I have done this successfully many times in the past, but it has been a few years since the last time.

I created a new, empty Joomla 3.9.23 site and transferred the content and categories from an old 2.5.25 site. I then created new menu items and connected all of my articles. All works fine. There was a DB error but I was able to resolve it through Admin>Manage>Database.

I then installed the Weblinks component and transferred the weblinks table over from the 2.5 to 3 site. I can see all weblinks and categories but I am getting this error when trying to save a weblink.
Save failed with the following error: Unknown column 'version' in 'field list'
I have searched for the issue and have found several similar results, but nothing that I have been able to figure out and use in my case. My database skills are somewhat limited to what I have done thus far, and maybe a little more, thus the cry for help.

Can anyone point to what I need to change/fix?

Thanks

User avatar
cspgsl
Joomla! Explorer
Joomla! Explorer
Posts: 326
Joined: Thu Nov 09, 2006 11:35 am

Re: Error in database from Joomla 2.5 to Joomla 3

Post by cspgsl » Mon Dec 07, 2020 1:01 pm

Forum Post Assistant (v1.6.2) : 7-Dec-2020 wrote:
Basic Environment :: wrote:Joomla! Instance :: Joomla! 3.9.23-Stable (Amani) 24-November-2020
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: false | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: false | FTP Layer: false | Proxy: false | LiveSite: | Session lifetime: 60 | Session handler: database | Shared sessions: false | SSL: 2 | Error Reporting: default | Site Debug: false | Language Debug: false | Default Access: 1 | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 3.9.23: Yes | Database Supports J! 3.9.23: Yes | Database Credentials Present: Yes |

Host Configuration :: OS: Linux | OS Version: 3.10.0-962.3.2.lve1.5.26.7.el7.x86_64 | Technology: x86_64 | Web Server: Apache | Encoding: gzip, deflate, br | System TMP Writable: Yes | Free Disk Space : 1589.10 GiB |

PHP Configuration :: Version: 7.3.24 | PHP API: cgi-fcgi | Session Path Writable: Yes | Display Errors: | Error Reporting: 22519 | Log Errors To: error_log | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 32M | Max. POST Size: 32M | Max. Input Time: -1 | Max. Execution Time: 90 | Memory Limit: 512M

Database Configuration :: Version: 5.5.5-10.2.34-MariaDB-log-cll-lve (Client:mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $) | Database Size: 5.65 MiB | #of Tables with config prefix:  79 | #of other Tables:  0 | User Privileges : GRANT ALL
Detailed Environment :: wrote:PHP Extensions :: Core (7.3.24) | date (7.3.24) | libxml (7.3.24) | openssl (7.3.24) | pcre (7.3.24) | sqlite3 (7.3.24) | zlib (7.3.24) | bz2 (7.3.24) | calendar (7.3.24) | ctype (7.3.24) | curl (7.3.24) | hash (7.3.24) | filter (7.3.24) | ftp (7.3.24) | gettext (7.3.24) | gmp (7.3.24) | SPL (7.3.24) | iconv (7.3.24) | pcntl (7.3.24) | readline (7.3.24) | Reflection (7.3.24) | session (7.3.24) | standard (7.3.24) | shmop (7.3.24) | SimpleXML (7.3.24) | mbstring (7.3.24) | tokenizer (7.3.24) | xml (7.3.24) | cgi-fcgi () | bcmath (7.3.24) | dom (20031129) | fileinfo (7.3.24) | gd (7.3.24) | imap (7.3.24) | intl (7.3.24) | json (1.7.0) | exif (7.3.24) | mysqlnd (mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $) | mysqli (7.3.24) | PDO (7.3.24) | pdo_mysql (7.3.24) | pdo_sqlite (7.3.24) | Phar (7.3.24) | posix (7.3.24) | soap (7.3.24) | sockets (7.3.24) | tidy (7.3.24) | uploadprogress (1.0.3.1) | xmlreader (7.3.24) | xmlwriter (7.3.24) | xsl (7.3.24) | zip (1.15.4) | ionCube Loader (10.4.3) | Zend OPcache (7.3.24) | Zend Engine (3.3.24) |
Potential Missing Extensions ::

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

Elevated Permissions (First 10) ::
Database Information :: wrote:Database statistics :: Uptime: 1753786 | Threads: 40 | Questions: 121661415 | Slow queries: 548 | Opens: 4141701 | Flush tables: 1 | Open tables: 3000 | Queries per second avg: 69.370 |
Extensions Discovered :: wrote:Components :: Site ::
Core :: com_mailto (3.0.0) 1 | com_wrapper (3.0.0) 1 |
3rd Party::

Components :: Admin ::
Core :: com_newsfeeds (3.0.0) 1 | com_weblinks (3.7.0) 1 | com_search (3.0.0) 1 | com_redirect (3.0.0) 1 | com_admin (3.0.0) 1 | com_templates (3.0.0) 1 | com_contenthistory (3.2.0) 1 | com_login (3.0.0) 1 | com_checkin (3.0.0) 1 | com_ajax (3.2.0) 1 | com_messages (3.0.0) 1 | com_cpanel (3.0.0) 1 | com_plugins (3.0.0) 1 | com_finder (3.0.0) 1 | com_users (3.0.0) 1 | com_config (3.0.0) 1 | com_content (3.0.0) 1 | com_media (3.0.0) 1 | com_privacy (3.9.0) 1 | com_languages (3.0.0) 1 | com_banners (3.0.0) 1 | com_tags (3.1.0) 1 | com_fields (3.7.0) 1 | com_categories (3.0.0) 1 | com_menus (3.0.0) 1 | com_installer (3.0.0) 1 | com_cache (3.0.0) 1 | com_postinstall (3.2.0) 1 | com_actionlogs (3.9.0) 1 | com_joomlaupdate (3.6.2) 1 | com_associations (3.7.0) 1 | com_modules (3.0.0) 1 |
3rd Party::

Modules :: Site ::
Core :: mod_weblinks (3.7.0) 1 | mod_menu (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_articles_popular (3.0.0) 1 | mod_articles_categories (3.0.0) 1 | mod_search (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_login (3.0.0) 1 | mod_users_latest (3.0.0) 1 | mod_articles_news (3.0.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_languages (3.5.0) 1 | mod_tags_similar (3.1.0) 1 | mod_wrapper (3.0.0) 1 | mod_banners (3.0.0) 1 | mod_stats (3.0.0) 1 | mod_articles_archive (3.0.0) 1 | mod_finder (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_whosonline (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_syndicate (3.0.0) 1 | mod_random_image (3.0.0) 1 |
3rd Party::

Modules :: Admin ::
Core :: mod_submenu (3.0.0) 1 | mod_title (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_version (3.0.0) 1 | mod_login (3.0.0) 1 | mod_logged (3.0.0) 1 | mod_stats_admin (3.0.0) 1 | mod_latestactions (3.9.0) 1 | mod_status (3.0.0) 1 | mod_latest (3.0.0) 1 | mod_quickicon (3.0.0) 1 | mod_sampledata (3.8.0) 1 | mod_popular (3.0.0) 1 | mod_multilangstatus (3.0.0) 1 | mod_privacy_dashboard (3.9.0) 1 | mod_custom (3.0.0) 1 | mod_toolbar (3.0.0) 1 |
3rd Party::

Libraries ::
Core ::
3rd Party::

Plugins ::
Core :: plg_captcha_recaptcha (3.4.0) 0 | plg_captcha_recaptcha_invisible (3.8) 0 | plg_privacy_message (3.9.0) 1 | plg_privacy_user (3.9.0) 1 | plg_privacy_actionlogs (3.9.0) 1 | plg_privacy_content (3.9.0) 1 | plg_privacy_consents (3.9.0) 1 | plg_search_weblinks (3.7.0) 0 | plg_search_contacts (3.0.0) 1 | plg_search_categories (3.0.0) 1 | plg_search_newsfeeds (3.0.0) 1 | plg_search_content (3.0.0) 1 | plg_search_tags (3.0.0) 1 | plg_quickicon_privacycheck (3.9.0) 1 | plg_quickicon_phpversioncheck (3.7.0) 1 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_extension_joomla (3.0.0) 1 | plg_system_weblinks (3.7.0) 0 | plg_system_log (3.0.0) 1 | plg_system_redirect (3.0.0) 0 | plg_system_stats (3.5.0) 1 | plg_system_privacyconsent (3.9.0) 0 | plg_system_logrotation (3.9.0) 1 | plg_system_debug (3.0.0) 1 | plg_system_languagefilter (3.0.0) 0 | plg_system_p3p (3.0.0) 0 | plg_system_remember (3.0.0) 1 | plg_system_updatenotification (3.5.0) 1 | plg_system_languagecode (3.0.0) 0 | plg_system_cache (3.0.0) 0 | plg_system_sef (3.0.0) 1 | PLG_SYSTEM_ACTIONLOGS (3.9.0) 1 | plg_system_fields (3.7.0) 1 | plg_system_logout (3.0.0) 1 | plg_system_sessiongc (3.8.6) 1 | plg_system_highlight (3.0.0) 1 | plg_finder_weblinks (3.7.0) 0 | plg_finder_contacts (3.0.0) 1 | plg_finder_categories (3.0.0) 1 | plg_finder_newsfeeds (3.0.0) 1 | plg_finder_content (3.0.0) 1 | plg_finder_tags (3.0.0) 1 | plg_user_contactcreator (3.0.0) 0 | plg_user_joomla (3.0.0) 1 | plg_user_terms (3.9.0) 0 | plg_user_profile (3.0.0) 0 | plg_editors-xtd_readmore (3.0.0) 1 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_weblink (3.7.0) 0 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_editors-xtd_menu (3.7.0) 1 | plg_editors-xtd_fields (3.7.0) 1 | plg_editors-xtd_module (3.5.0) 1 | plg_editors-xtd_article (3.0.0) 1 | plg_twofactorauth_totp (3.2.0) 0 | plg_twofactorauth_yubikey (3.2.0) 0 | plg_authentication_gmail (3.0.0) 0 | plg_authentication_joomla (3.0.0) 1 | plg_authentication_ldap (3.0.0) 0 | plg_authentication_cookie (3.0.0) 1 | PLG_ACTIONLOG_JOOMLA (3.9.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_integer (3.7.0) 1 | plg_fields_sql (3.7.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_color (3.7.0) 1 | plg_fields_usergrouplist (3.7.0) 1 | plg_fields_calendar (3.7.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_repeatable (3.9.0) 1 | plg_fields_imagelist (3.7.0) 1 | plg_fields_text (3.7.0) 1 | plg_fields_editor (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_url (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_content_pagenavigation (3.0.0) 1 | plg_content_vote (3.0.0) 0 | plg_content_emailcloak (3.0.0) 1 | plg_content_confirmconsent (3.9.0) 0 | plg_content_finder (3.0.0) 0 | plg_content_pagebreak (3.0.0) 1 | plg_content_joomla (3.0.0) 1 | plg_content_fields (3.7.0) 1 | plg_content_loadmodule (3.0.0) 1 | PLG_INSTALLER_FOLDERINSTALLER (3.6.0) 1 | PLG_INSTALLER_URLINSTALLER (3.6.0) 1 | plg_installer_packageinstaller (3.6.0) 1 |
3rd Party:: plg_editors_tinymce (4.5.12) 1 | plg_editors_codemirror (5.56.0) 1 |
Templates Discovered :: wrote:Templates :: Site :: protostar (1.0) 1 |
Templates :: Admin :: isis (1.0) 1 | hathor (3.0.0) 0 |


Post Reply

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