how to fix error 1146

[linghun]

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?

[Per Yngve Berg]

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]

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!

[Per Yngve Berg]

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]

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

[Per Yngve Berg]

Extensions->Manage->Database->Fix

[linghun]

i have done this fix,not working!

[Per Yngve Berg]

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

[linghun]

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.

[Per Yngve Berg]

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]

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'

[Per Yngve Berg]

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