How to fix 1054 Unknown column t.published - after Joomla migration - JoomShaper

How to fix 1054 Unknown column t.published - after Joomla migration

03 February 2015
Hits 19,918
2 min read
How to fix 1054 Unknown column t.published - after Joomla migration

Joomla 2.5 -> Joomla 3.3.6/3.4 migration process doesn't have to be painful. But in some cases on front-end you would get a blank screen or page filled with strange messages or errors. One of them is "1054 - Unknown column 't.published' in 'where clause' SQL=SELECT `m`.`tag_id`,`t`.* FROM ... WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 297 AND `t`.`published` = 1 AND t.access IN (1,1)" In this tutorial we will show how to fix it.

All data (CMS content) migration can be a time-consuming and difficult process, strange things can happen and warring messages might be shown. Each case is/might be different.

The first step to take when performing any potentially destructive step is to create fresh backup. Just because there shouldn't be a problem doesn't mean that something unexpected isn't going to happen. You don't want to be left in a situation where a upgrade breaks something on your current Joomla website before the replacement is up and running. So this should be always first step before migration (!).

In this guide, we give you ready source file that can fix your site after Joomla! migration/upgrade:

  1. Check what database prefix using your "broken" Joomla.
  2. Download this file >> tags_1054_Unknown_column_error.zip 
  3. Unzip and using simple html editor replace all "XXXXX_"  tags with your current prefix for example "jos3_". Save changes.
  4. Now login into PHPMyAdmin or use Adminer script - using database login and password.
  5. Then please use import option and upload changed file.

Now You should now have a good working website.

BTW Don't forget to check also our others guides, extensions and templates build for Joomla 3.x. Maybe it's time to upgrade also your website appearance using modern layout based on Helix.

C
co88agency
7 years ago
Hi, it returns me an error: #1062 - Duplicate entry '29' for key 'PRIMARY'... what can I do?
J
Jay
7 years ago
Had the same problem, but a "database fix" on the joomla installation helped. Log into your joomla backend, Extensions > Manage > Database tab, click on fix on the top left.
J
Jaabir
6 years ago
I have tried the "database fix" but still having the #1062 - Duplicate entry '29' for key 'PRIMARY' error while uploading the tags file.

What can I do to fix this particular issue as I'm not able to make any changes on my website!
J
Jaabir
6 years ago
I have tried the "database fix" but still having the #1062 - Duplicate entry '29' for key 'PRIMARY' error while uploading the tags file.

What can I do to fix this particular issue as I'm not able to make any changes on my website!

Reply Report #2965
Paul Frankowski
Paul Frankowski
6 years ago
If your error is from Joomla directly (not SPPB) please check official Joomla forum, each case is different.

Sign up for our newsletter

Don’t miss any updates of our new templates and extensions and all the astonishing offers we bring for you.