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

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

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

Started by kanuharis, September 18, 2010, 11:02:33 PM

Previous topic - Next topic

0 Members and 3 Guests are viewing this topic.

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.


Αndré

You can manually add that group by performing that query in phpMyAdmin:
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é

Quote from: diedhert on October 25, 2010, 09:02:57 PM
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:
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:
QuoteCoppermine critical error:
The group table does not contain the Anonymous group!

index.php:
QuoteWhile 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:
QuoteFile fails CRC check: "C:\Users\da kool skool\Downloads\coppermine-cpg1.5.x\coppermine-cpg1.5.x.tar"

Αndré

Quote from: kapler on November 15, 2010, 06:59:01 PM
Does that mean the tarball is available immediately?
Yes. See here.


Quote from: kapler on November 15, 2010, 06:59:01 PM
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:
QuoteCoppermine critical error:
The group table does not contain the Anonymous group !

Whereas index.php is now with:

QuoteWhile 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
Quote$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.

Quote
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:
Quote from: Αndré on November 03, 2010, 12:13:29 PM
Try:
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

QuoteI 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