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:
- Check what database prefix using your "broken" Joomla.
- Download this file >> tags_1054_Unknown_column_error.zip
- Unzip and using simple html editor replace all "XXXXX_" tags with your current prefix for example "jos3_". Save changes.
- Now login into PHPMyAdmin or use Adminer script - using database login and password.
- 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.
What can I do to fix this particular issue as I'm not able to make any changes on my website!
What can I do to fix this particular issue as I'm not able to make any changes on my website!
Reply Report #2965