The group table does not contain the Anonymous group. Please help!!

[kanuharis]

my gallery hacked, this is third time. I've cleaned the injected php script from all of my coppermine gallery pages, but after i think notepad ruined those pages, so i though a upgrade will make things good. So downloaded new version and when trying to run update.php  getting the error msg "The group table does not contain the Anonymous group" . When my site hacked before the same thing happened, Shoud i have to reinstall whole gallery? Ohh god im going crazy.. Please someone help!! webaddess is www.cinefun4all.info and coppermine gallery at www.cinefun4all.info/actress/
thanks in advance.

[kanuharis]

np body here for help?

[Αndré]

You can manually add that group by performing that query in phpMyAdmin:

Code Select Expand

INSERT INTO CPG_usergroups VALUES (3, 'Anonymous', 0, 0, 1, 0, 0, 0, 0, 1, 1, 3);

Don't forget to adjust the table prefix 'CPG_'.

[diedhert]

I had this error too.
However, running "INSERT INTO cpg14x_usergroups VALUES (3, 'Anonymous', 0, 0, 1, 0, 0, 0, 0, 1, 1, 3);"
yields following error:

#1136 - Column count doesn't match value count at row 1
INSERT INTO cpg14x_usergroups
VALUES ( 3,  'Anonymous', 0, 0, 1, 0, 0, 0, 0, 1, 1, 3 )

When I look at the table, it has far more columns than numbers in the command above.
The table had following columns: group_id   group_name   group_quota   has_admin_access   can_rate_pictures   can_send_ecards   can_post_comments   can_upload_pictures   can_create_albums   pub_upl_need_approval   priv_upl_need_approval   upload_form_config   custom_user_upload   num_file_upload   num_URI_upload.

Anyone can help ?
The mysql table is on the servage-host.

Thanks in advance,
Diederik

[Αndré]

I had this error too.
However, running "INSERT INTO cpg14x_usergroups VALUES (3, 'Anonymous', 0, 0, 1, 0, 0, 0, 0, 1, 1, 3);"
yields following error:

#1136 - Column count doesn't match value count at row 1
INSERT INTO cpg14x_usergroups
VALUES ( 3,  'Anonymous', 0, 0, 1, 0, 0, 0, 0, 1, 1, 3 )

When I look at the table, it has far more columns than numbers in the command above.
The table had following columns: group_id   group_name   group_quota   has_admin_access   can_rate_pictures   can_send_ecards   can_post_comments   can_upload_pictures   can_create_albums   pub_upl_need_approval   priv_upl_need_approval   upload_form_config   custom_user_upload   num_file_upload   num_URI_upload.

Anyone can help ?
The mysql table is on the servage-host.

Thanks in advance,
Diederik

Try:

Code Select Expand

ALTER TABLE cpg14x_usergroups DROP `upload_form_config`, DROP `custom_user_upload`, DROP `num_file_upload`, DROP `num_URI_upload`;
ALTER TABLE cpg14x_usergroups ADD access_level tinyint(4) NOT NULL default '3';
INSERT INTO cpg14x_usergroups VALUES (3, 'Anonymous', 0, 0, 1, 0, 0, 0, 0, 1, 1, 3);

[kapler]

Hello,

After initially updating to 1.5.8 (all OK), I had the 'browser does not recognize cookies error'.
The gallery listing was shown, but navigation was not functional.

It was advised I upgrade to the newest 1.5.9. 

Now, update.php (from 1.4 to 1.5.9) gives this error:

Coppermine critical error:
The group table does not contain the Anonymous group!

index.php:

While executing query 'SELECT name, value FROM cpg14x_config' in include/init.inc.php on line 181
mySQL error: Table 'earthsys_copp1.cpg14x_config' doesn't exist

Should I perhaps revert back to 1.4.  If so, how.
Thank You.

[Αndré]

Cannot confirm on my testbed, but added an appropriate entry to the update.sql file in r8042 anyway, as some people seems to have trouble with that missing group. So your issue should be fixed with the latest svn tarball respectively with cpg1.5.10. Please confirm.

[kapler]

Does that mean the tarball is available immediately?

The current file gives an extraction error:

File fails CRC check: "C:\Users\da kool skool\Downloads\coppermine-cpg1.5.x\coppermine-cpg1.5.x.tar"

[Αndré]

Does that mean the tarball is available immediately?

Yes. See here.

The current file gives an extraction error:

Cannot confirm. I just downloaded the tarball and it works as expected. Please try again.

[kapler]

It worked the third time, thanks.
I methodically replaced the tarball.

update.php gives the same error:

Coppermine critical error:
The group table does not contain the Anonymous group !

Whereas index.php is now with:

While executing query 'SELECT name, value FROM config' in include/init.inc.php on line 181
mySQL error: Table 'earthsys_copp1.config' doesn't exist

Within the faulting include/config.php.inc

$CONFIG['TABLE_PREFIX'] = '';

[kapler]

I tried to revert back to 1.4
The error continues.

Perhaps this will serve to isolate some bug; I have moved onto re-installing with 1.5.

While executing query "SELECT * FROM cpg14x_config" on 0

mySQL error: Table 'earthsys_copp1.cpg14x_config' doesn't exist

[Αndré]

kapler, it's impossible to help you if you constantly switch between different versions and performing whatever you perform on your gallery. This thread only deals with the 'missing anonymous group' error message. If you want to fix that issue, do as already suggested in this thread:

Try:

Code Select Expand

ALTER TABLE cpg14x_usergroups DROP `upload_form_config`, DROP `custom_user_upload`, DROP `num_file_upload`, DROP `num_URI_upload`;
ALTER TABLE cpg14x_usergroups ADD access_level tinyint(4) NOT NULL default '3';
INSERT INTO cpg14x_usergroups VALUES (3, 'Anonymous', 0, 0, 1, 0, 0, 0, 0, 1, 1, 3);

Don't forget to adjust the table prefix according if needed.

[kapler]

I'm sorry, it is because I can't engage the learning curve before I need a means of presentation for operative purposes.
The previous build, or what has been reverted to 1.4 and continues with Anonymous-group error, I will continue to resolve here.

This is, however, an issue encountered during an upgrade and it no longer makes sense to upgrade,
as there is a bigger job of removing all the (^&#@!)s I operatively developed the file system with.

As I keep repeating, I am super-impressed with Coppermine, only recently considering its Plugins and their 'hooks' and whatnot.
I stopped programming when Pascal was in use, and have never written a .php script.

I do not even know where that code is to be inserted.

In the next year, I would like to learn how Coppermine was developed and refresh my skills that way.

[nika2000]

I have this error too while running the update.php from version 1.4 to 1.5.1
I have already added the group 3 - anonymous, but the error is still there.
Can anyone help?

[nika2000]

I have this error too while running the update.php from version 1.4 to 1.5.1
I have already added the group 3 - anonymous, but the error is still there.
Can anyone help?

Sorry, I meant version 1.5.10..........

[tobia71]

Hello nika2000

you can see my post

http://forum.coppermine-gallery.net/index.php/topic,70068.0.html

That's because you have edit new config.inc.php file with your db informations.
It is not correct!

You must hold old config.inc.php and not delete it re-editing the new one.

The old file contains row

// MySQL TABLE NAMES PREFIX
$CONFIG['TABLE_PREFIX'] =                'cpg14x_';

The new file contains row

// MySQL TABLE NAMES PREFIX
$CONFIG['TABLE_PREFIX'] =                'cpg15x_';

The update not correct this and you can have some fault updating DB...

Frank