Huge Problem! Need A Quick Fix!

lygren · December 29th, 2004, 02:56 AM

When updating my usergroups (from my phpBB forum software) in the CC-classifieds admin panel, the database crashed! Now there are no usergroup info at all, including the admin part, so I have no access. The same goes for all the users.

WHAT TO DO? This is a SERIOUS bug!! I have a lot of users on my site, and currently nothing works...

Chuck S · December 29th, 2004, 07:52 AM

You will need to add one with a groupid of 2 for you to get in as admin in phpmyadmin

In your phpbb2.php file replace lines 433-436 with these

$query[] = "INSERT INTO {$pp_db_prefix}usergroups VALUES ('1','Anonymous','','','','','',0,0,0,0,0,0)";
$query[] = "INSERT INTO {$pp_db_prefix}usergroups VALUES ('2','Admin',1,1,1,'','',1,1,1,1,0,0)";
$query[] = "INSERT INTO {$pp_db_prefix}usergroups VALUES ('3','Regular Users','',1,1,'','',1,1,0,1,0,0)";

lygren · December 29th, 2004, 10:43 AM

That didn't help much... Do I have to create these values in the database itself?

lygren · December 29th, 2004, 11:01 AM

Okey, I inserted the values manually into the database and ran a new "usergroup" update, but again I got the same error and all the content of this table was erased:

MySQL error reported!

Script: adm-userg

Query: REPLACE INTO pp_usergroups (groupid,groupname,modaccess,cpaccess,uploads,comments,diskspace,uploadsize,editpho,editposts) VALUES(910,'FFAK (Foren. For Alkohol. Kinosjefer)','0','0','0','0','0','0','1','1')

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

Database handle: Resource id #7

I "fixed" it by adding the diskspace, but then I had to manually insert the "admin" user again... This is kinda "non-user-friendly" I would say....?

Chuck S · December 29th, 2004, 12:23 PM

Lets make sure you follow here with the right code

copy over this entire import_usergroup and init_user group functions over the old ones.

Code:

Content visible to verified customers only.

lygren · December 29th, 2004, 12:36 PM

Updated, same error. Have you taken into consideration the "diskspace" field, which is not included in my (or anyone elses I would believe) database, but nevertheless is still being "copied"?

lygren · December 29th, 2004, 12:38 PM

My database table-structure is currently:

Felt Type Attributter Null Standard Ekstra Handling
groupid int(5) Nei auto_increment
groupname varchar(50) Nei
cpaccess smallint(3) Nei 0
uploads smallint(3) Nei 1
comments smallint(3) Nei 1
uploadsize int(10) Ja NULL
editpho int(3) Nei 1
editposts int(3) Nei 1
modaccess smallint(3) Nei 0
reqmod int(3) Nei 0
highlight int(3) Nei 0
bold int(3) Nei 0
italic int(3) Nei 0
diskspace varchar(13) Nei 0
Merk alle / Fjern merking Med avkrysset:

Chuck S · December 29th, 2004, 01:25 PM

There is no diskspace in the classifieds program.

If you have diskspace in your usergroups table it does not belong there.

Thats a photopost feature

lygren · December 29th, 2004, 01:40 PM

If I remove it, I get the above error-message. I have never installed photopost, only Photopost classified

Chuck S · December 29th, 2004, 02:14 PM

Upload the Classifieds 2.01 distribution and make the noted changes here in this thread

lygren · December 30th, 2004, 12:13 PM

Now I'm getting real tired of this!

I have upgradet to the 2.01, removed the "diskspace" row and emptied the table. I have also edited to phpbb2.php file as instructed. I have to add "Admin" as to get access at all. When I update, the samme error appears;

MySQL error reported!

Script: adm-userg

Query: REPLACE INTO pp_usergroups (groupid,groupname,modaccess,cpaccess,uploads,comments,diskspace,uploadsize,editpho,editposts) VALUES(910,'FFAK (Foren. For Alkohol. Kinosjefer)','0','0','0','0','0','0','1','1')

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

Database handle: Resource id #7

Why does this "diskspace" appear?? Something has to be wrong here? I have never downloaded the Photopost....

Now I have to manually add the "diskspace", manually add "Admin" as to get access at all, and when the usergroups are updated, I have to add "Admin", "Anonymous" and the last one manually, as they are deleted when updating...

Chuck S · January 1st, 2005, 10:03 AM

Your adm-userg.php file called the import_usergroups function and I posted a proper one for you to fix your phpbb2.php file with

I have modified the one above to totally drop the usergroups table and recreate things so this should work as somehow you have an incorrect usergroups table.

I beleive I found your issue you have not ran the proper upgrade scripts as diskspace was dropped when you run the upgrade18.php upgrade script.

I suggest if this was indeed an upgrade you follow the upgrade instructions