Joomla! 3.6.5 Unknown column 'c.version' in 'field list' Topic is solved

Need help upgrading your Joomla! website or converting to Joomla! 3.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.
Locked
Bisectriz
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Tue Apr 20, 2021 5:39 pm

Joomla! 3.6.5 Unknown column 'c.version' in 'field list'

Post by Bisectriz » Wed Apr 21, 2021 9:40 am

I was given the a copy of the folder "httpdocs" and a .sql the joomla database from a fully operational site on plesk, and was asked to mount the website locally. The version of Joomla is 3.6.5, I checked it on the en-GB.xml. The PHP version in the original server is 5.4.45, and I am using Xampp 1.8.2 with PHP 5.4.31, after changing the configuration.php to connect to the database, and then accessing the site I get this error:

1054 - Unknown column 'c.version' in 'field list' SQL=SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems FROM #__categories as c LEFT JOIN (SELECT cat.id as id FROM #__categories AS cat JOIN #__categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id LEFT JOIN #__categories AS s ON (s.lft < c.lft AND s.rgt > c.rgt AND c.language in ('en-GB','*')) OR (s.lft >= c.lft AND s.rgt <= c.rgt) LEFT JOIN `#__content` AS i ON i.`catid` = c.id AND i.state = 1 AND (i.language = '*' OR i.language = 'en-GB') WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND badcats.id is null AND s.id=10 GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft

From what I have seen, this error is common in websites that are being updated from Joomla! 2.5 to 3.x, this one is not.
I am not very familliar whit Joomla! but I will update on any info that is necessary and I left out accidentally.

User avatar
Rondeb
Joomla! Guru
Joomla! Guru
Posts: 623
Joined: Mon Dec 02, 2013 12:14 pm
Location: Meschede - Germany
Contact:

Re: Joomla! 3.6.5 Unknown column 'c.version' in 'field list'

Post by Rondeb » Wed Apr 21, 2021 11:12 am

Hello,

make a copy of your site with akeeba ;)

Works much easier and faster!

Greetings Ron

Bisectriz
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Tue Apr 20, 2021 5:39 pm

Re: Joomla! 3.6.5 Unknown column 'c.version' in 'field list'

Post by Bisectriz » Mon May 03, 2021 2:52 pm

Hello Ron, sorry for the delays. Aparently I was given a database for Joomla! 2.5 instead of the current version, now it works fine


Locked

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