Usergroups Error

[Steve_C]

I need to drop this table and re-run it with the proper query (I tried one I found in a search result but it did not work). Can you provide me with it? My problem was I could not login as admin. I changed the groupid to 6 (vb3 integration) and checked the rest to make sure everything was set to "1" but still nothing. It would say login successful but no admin. Now I get this:

MySQL error reported!

Script: index

Query: SELECT groupid,cpaccess,modaccess,diskspace,uploadsize,uplimit,uploads,comments,editpho,editposts,useralbums,reqmod,canassign FROM usergroups WHERE groupid='1' LIMIT 1

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

Database handle: Resource id #8

[Steve_C]

Perhaps you guys should institute a premium support line. Our site has been down nearly 24 hours.

[Chuck S]

Steve you need to run the upgrade482.php upgrade script to add that field.

Please remember this is a weekend and a holiday weekend at that. We do try and respond as quick as we can. My response here is within 24 hours on the actual holiday.

[Steve_C]

Thanks. I know and understand. Just sometimes, there are emergencies so a premium support line was just a thought...

[Steve_C]

Ok, I ran it. Fixed that problem but I still cannot login to my admin. I checked the usergroup id, it's set to:

6 Administrator 1 1 1 1 0 0 1 1 1 0 0 0

I made sure table id 41 is set to vb3.

What else can I do?

[Chuck S]

How about cookies you checked these?

cookie domain ?

cookie path /

cookie prefix bb ----by default

Vb license number

I take it by your post above you can login you just dont get a cookie set since if you did get a cookie set you would have admin link.

[Steve_C]

Where is the cookie prefix setting located in 4.8.5?

[Steve_C]

Nevermind.... found it in the db. id 172 in settings.