Advertisement

how to fix error 1146

General questions relating to Joomla! 3.x.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting.
Forum Post Assistant - If you are serious about wanting help, you should use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
Locked
linghun
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 237
Joined: Sun Nov 03, 2013 2:28 pm

how to fix error 1146

Post by linghun » Thu Jun 01, 2017 10:42 am

Code: Select all

An error has occurred.
1146 Table 'joomlable_com.#__fields' doesn't exist SQL=SELECT id, default_value FROM #__fields WHERE type = "integer" AND state = 1 AND language IN ("*", "en-GB")
it's said the error is from joomla core ,how to fix that?

Advertisement
User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 31844
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: how to fix error 1146

Post by Per Yngve Berg » Thu Jun 01, 2017 12:42 pm

The error is coming from the database. The table is missing in your database. Did you do an upgrade from 3.6 to 3.7?
The upgrade did not complete and the database changes have not been done.
Extensions->Manage->Database-Fix should take care of it.

linghun
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 237
Joined: Sun Nov 03, 2013 2:28 pm

Re: how to fix error 1146

Post by linghun » Thu Jun 01, 2017 1:49 pm

hi, my joomla is 3.6.5, i think i didn't update!,i have ever changed database from latin to unicode,maybe this is the cause,now how to fix that? i have used Extensions->Manage->Database-Fix, but still the same!

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 31844
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: how to fix error 1146

Post by Per Yngve Berg » Thu Jun 01, 2017 2:23 pm

Fields is a new feature in 3.7. You must have 3.7 files and a 3.6 database. Did you get a message, Database Schema 3.6.5 does not match CMS version 3.7.2?

linghun
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 237
Joined: Sun Nov 03, 2013 2:28 pm

Re: how to fix error 1146

Post by linghun » Thu Jun 01, 2017 9:58 pm

in my website backend,system information,my joomla version is 3.6.5。where can i see the message?

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 31844
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: how to fix error 1146

Post by Per Yngve Berg » Fri Jun 02, 2017 2:57 am

Extensions->Manage->Database->Fix

linghun
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 237
Joined: Sun Nov 03, 2013 2:28 pm

Re: how to fix error 1146

Post by linghun » Fri Jun 02, 2017 4:37 am

i have done this fix,not working!

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 31844
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: how to fix error 1146

Post by Per Yngve Berg » Fri Jun 02, 2017 5:23 am

What version of CMS/Database did it report? Where they equal?

linghun
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 237
Joined: Sun Nov 03, 2013 2:28 pm

Re: how to fix error 1146

Post by linghun » Fri Jun 02, 2017 9:34 am

hi , i have recorded a video,so you can see clear.
https://www.dropbox.com/s/gw96wzlw9vzz5 ... r.mp4?dl=0
you can download and see it, online is blurry.

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 31844
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: how to fix error 1146

Post by Per Yngve Berg » Fri Jun 02, 2017 10:08 am

What component did you enter (Ja Filters)?

Custom Fields is a new feature in J3.7.0, so it's natural that is does not exist in 3.6.5
An update to J3.7.2 should take care of it.

linghun
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 237
Joined: Sun Nov 03, 2013 2:28 pm

Re: how to fix error 1146

Post by linghun » Fri Jun 02, 2017 1:52 pm

hi,i updated to joomla3.7.2, created Custom Fields, then in ja mega filter, i created a filter and save, then come this error:

Code: Select all

 1054 Unknown column 'f.alias' in 'field list'

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 31844
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: how to fix error 1146

Post by Per Yngve Berg » Fri Jun 02, 2017 2:16 pm

Contact the developer and ask if there is an update to JA mega filter.

Advertisement

Locked

Return to “General Questions/New to Joomla! 3.x”