Support Online : Mon - Fri / 10am - 6pm (GMT +6)

Your Time: Our Time:

Error Unknown column 'a.published' in 'where clause'

Featured Lock Resolved Issue
hi guys,
I got this on SP simple portfolio

Unknown column 'a.published' in 'where clause'
Unknown column 'a.published' in 'where clause'

how can I fix it??

2 Answers

Paul Frankowski - Staff

More than a month ago #Permalink
In most cases:
1) Make site/database backup
2) Uninstall SP Simple Portfolio
3) Install again (new version)


More than a month ago #Permalink
Done already but now it shows
You Have An Error In Your SQL Syntax; Check The Manual That Corresponds To Your MySQL Server Version For The Right Syntax To Use Near ') ORDER BY Id ASC' At Line 3

There are no replies made for this post yet.
Be one of the first to reply to this post!

Leaderboard (30 days)

Paul Frankowski

Paul Frankowski

Total Accepted Answers: 118


Total Accepted Answers: 112
Mehtaz Afsana Borsha

Mehtaz Afsana Borsha

Total Accepted Answers: 58
Ofi Khan

Ofi Khan

Total Accepted Answers: 56
Rashida Rahman

Rashida Rahman

Total Accepted Answers: 34




Community Users


Don’t miss any updates of our new templates and extensions and all the astonishing offers we bring for you.
We never spam

Joomla! ® name is used under a limited license from Open Source Matters in the United States and other countries. is not affiliated with or endorsed by Open Source Matters or the Joomla! Project.

Connect Us