forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 upgrading => Topic started by: kanuharis on September 18, 2010, 11:02:33 pm

Title: The group table does not contain the Anonymous group. Please help!!
Post by: kanuharis on September 18, 2010, 11:02:33 pm
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.
Title: Re: The group table does not contain the Anonymous group. Please help!!
Post by: kanuharis on September 20, 2010, 01:03:34 pm
np body here for help???????????????? >:(
Title: Re: The group table does not contain the Anonymous group. Please help!!
Post by: Αndré on September 27, 2010, 12:25:10 pm
You can manually add that group by performing that query in phpMyAdmin:
Code: [Select]
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_'.
Title: Re: The group table does not contain the Anonymous group. Please help!!
Post by: 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
Title: Re: The group table does not contain the Anonymous group. Please help!!
Post by: Αndré on November 03, 2010, 12:13:29 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:
Code: [Select]
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);
Title: Re: The group table does not contain the Anonymous group. Please help!!
Post by: kapler on November 14, 2010, 11:19:27 pm
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:
Quote
Coppermine critical error:
The group table does not contain the Anonymous group!

index.php:
Quote
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.
Title: Re: The group table does not contain the Anonymous group. Please help!!
Post by: Αndré on November 15, 2010, 01:42:24 pm
Cannot confirm on my testbed, but added an appropriate entry to the update.sql file in r8042 (http://coppermine.svn.sourceforge.net/viewvc/coppermine?revision=8042&view=revision) 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.
Title: Re: The group table does not contain the Anonymous group. Please help!!
Post by: kapler on November 15, 2010, 06:59:01 pm
Does that mean the tarball is available immediately?

The current file gives an extraction error:
Quote
File fails CRC check: "C:\Users\da kool skool\Downloads\coppermine-cpg1.5.x\coppermine-cpg1.5.x.tar"
Title: Re: The group table does not contain the Anonymous group. Please help!!
Post by: Αndré on November 15, 2010, 07:16:35 pm
Does that mean the tarball is available immediately?
Yes. See here (http://documentation.coppermine-gallery.net/en/dev_subversion.htm#dev_subversion_download_tarball).


The current file gives an extraction error:
Cannot confirm. I just downloaded the tarball and it works as expected. Please try again.
Title: Re: The group table does not contain the Anonymous group. Please help!!
Post by: kapler on November 16, 2010, 06:41:14 pm
It worked the third time, thanks.
I methodically replaced the tarball.

update.php gives the same error:
Quote
Coppermine critical error:
The group table does not contain the Anonymous group !

Whereas index.php is now with:

Quote
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
Quote
$CONFIG['TABLE_PREFIX'] = '';
Title: Re: The group table does not contain the Anonymous group. Please help!!
Post by: kapler on November 17, 2010, 08:14:57 pm
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
Title: Re: The group table does not contain the Anonymous group. Please help!!
Post by: Αndré on November 18, 2010, 03:56:06 pm
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]
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.
Title: Re: The group table does not contain the Anonymous group. Please help!!
Post by: kapler on November 18, 2010, 06:42:17 pm
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.
Title: Re: The group table does not contain the Anonymous group. Please help!!
Post by: nika2000 on January 02, 2011, 09:32:09 pm
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?
Title: Re: The group table does not contain the Anonymous group. Please help!!
Post by: nika2000 on January 02, 2011, 10:00:07 pm
Quote
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..........
Title: Re: The group table does not contain the Anonymous group. Please help!!
Post by: tobia71 on January 19, 2011, 09:16:24 am
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