Error 1054

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
zefilhojornal
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Thu Apr 28, 2016 8:42 pm

Error 1054

Post by zefilhojornal » Thu Apr 28, 2016 9:02 pm

I'm in trouble since I updated the Joomla 3.0.1 to 3.5.1

1054 Unknown column 'type_alias' in 'where clause' SQL=SELECT * FROM `#__content_types` WHERE `type_alias` IN ('com_content.category')

i tried Extensions > Menage > Database > Fix

But the problem persists

zefilhojornal
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Thu Apr 28, 2016 8:42 pm

Re: Error 1054

Post by zefilhojornal » Thu Apr 28, 2016 9:22 pm

I can not create other categories

sovainfo
Joomla! Exemplar
Joomla! Exemplar
Posts: 8808
Joined: Sat Oct 01, 2011 7:06 pm

Re: Error 1054

Post by sovainfo » Thu Apr 28, 2016 10:02 pm

What does logs/joomla_update.php say?
Extensions->Manage->Database->Fix won't help here! J3.1.0 introduces #__content_types with a type_alias through a CREATE TABLE statement. Obviously the table exists, which is why Fix won't add the missing type_alias.
Issue with migrating? Include logs/joomla_update.php in your report!
Blank screen? Verify pagesource for HTML code (javascript error)
Installation failing on populating database? Install with set_time_limit(0)
Document your customizations!


Locked

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