SQL Error (4.0)
 

Hello,

Using version 4.0 i have this sql error:

Query: SELECT groupid,cpaccess,modaccess,uploadsize,uploads,comments,editpho,editposts,reqmod,highlight,bold,italic,payment,uplimit,free,captcha FROM cp_usergroups WHERE groupid=1

Result: Unknown column 'captcha' in 'field list'

Database handle: Resource id #61


How can i fix this?

I think you are not sure what version your running or you have tried placing newer files into an older install. Whichever one would create your problem. You have newer file or files and fields that should exist in newer classifieds the files are looking for are not there.

Captcha usergroup permissions where not added till Classifieds 5.0.

http://www.photopost.com/forum/photo...29-2012-a.html

There where some small maintenance releases as well after 4.0 and even after 5.0. The latest stable release is 5.23 and we even have a pretty darn stable 5.3 beta going on which adds in even more features.

The point I am making here is you can not really be sure what versions your running if you have an older database and mixed in newer files which it looks to me is your case.

Your only recourse would be to download the latest stable code and upload all the files except the 2 config files and run the upgrade and select 4.0 forward.

That should correct your issue.