Unknown column 'published' in 'where clause' (1054)
Posted 2 years 7 months ago
Edit:I imported over all the Jomsocial tables to the database from ourlive site and now it shows new error
1054 Unknown column 'a.pages' in 'field list'
page shows a white blank page
I turned on debug and I see this error
Twig \ Error \ RuntimeError
An exception has been thrown during the rendering of a template ("Unknown column 'published' in 'where clause'").
Previous exceptions
Unknown column 'published' in 'where clause' (1054)
Re: Unknown column 'published' in 'where clause' (1054)
Posted 2 years 7 months ago
You can't just copy mysql tables between installations. Especially if they are not same PHP version, joomla version, gantry version, template version and joomla version.
The only thing I can suggest is that you try in joomla extensions manager > database > fix.
Regards, Mark.
Please search forums before posting. Please make sure your post includes the version of the CMS you are using and a link to the problem. Annotations on screenshots can also be helpful to explain problems/goals. Please use the "secure" tab for confidential information.