Errors during upgrade - Page 2

Chuck S · July 24th, 2006, 10:15 AM

You need to ensure in the usergroups table there is an entry for administrators with groupid set to 6 and cpaccess set to 1

dprice · July 24th, 2006, 12:00 PM

I went into the USERGROUPS table and set the CPACCESS to 1. I don't have an entry for ADMINISTRATORS so I will need to create a field for it.

Could you please give me the entire command to do an SQL query or at least tell me what goes into all of the fields?

Field Type Length/Values* Attributes Null Default** Extra

Chuck S · July 24th, 2006, 12:25 PM

Code:

Content visible to verified customers only.

dprice · July 25th, 2006, 08:10 AM

Quote:

Originally Posted by Chuck S

Code:

Content visible to verified customers only.

Chuck,

Remember I am trying to fix Photopost and not Reviewpost. Do I still need to insert this into the RP_USERGROUPS table?Or should I insert into USERGROUPS without the RP_?

Chuck S · July 25th, 2006, 08:39 AM

Code:

Content visible to verified customers only.

dprice · July 26th, 2006, 09:16 PM

Chuck,

I don't have ANY tables that begin with a "PP". My tables for photopost have been around for several years. My reviewpost tables do start with a "RP" but there is no prefix on my photopost tables. What table do I need to modify? I still cannot get into the admin panel. I am drawing a blank on the usegroups table.

Chuck S · July 27th, 2006, 07:36 AM

Take the pp_ off the query if your photopost tables have no prefix.

dprice · July 31st, 2006, 08:01 PM

That did the trick! Thanks Chuck!