Advanced search  

News:

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

Pages: [1]   Go Down

Author Topic: The group table does not contain the Anonymous group. Please help!!  (Read 13123 times)

0 Members and 1 Guest are viewing this topic.

kanuharis

  • Coppermine newbie
  • Offline Offline
  • Posts: 9

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.
Logged

kanuharis

  • Coppermine newbie
  • Offline Offline
  • Posts: 9
Re: The group table does not contain the Anonymous group. Please help!!
« Reply #1 on: September 20, 2010, 01:03:34 PM »

np body here for help???????????????? >:(
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15244
Re: The group table does not contain the Anonymous group. Please help!!
« Reply #2 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_'.
Logged

diedhert

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 35
Re: The group table does not contain the Anonymous group. Please help!!
« Reply #3 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
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15244
Re: The group table does not contain the Anonymous group. Please help!!
« Reply #4 on: November 03, 2010, 01: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);
Logged

kapler

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 23
Re: The group table does not contain the Anonymous group. Please help!!
« Reply #5 on: November 15, 2010, 12:19:27 AM »

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.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15244
Re: The group table does not contain the Anonymous group. Please help!!
« Reply #6 on: November 15, 2010, 02:42:24 PM »

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.
Logged

kapler

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 23
Re: The group table does not contain the Anonymous group. Please help!!
« Reply #7 on: November 15, 2010, 07: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"
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15244
Re: The group table does not contain the Anonymous group. Please help!!
« Reply #8 on: November 15, 2010, 08:16:35 PM »

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.
Logged

kapler

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 23
Re: The group table does not contain the Anonymous group. Please help!!
« Reply #9 on: November 16, 2010, 07: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'] = '';
Logged

kapler

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 23
Re: The group table does not contain the Anonymous group. Please help!!
« Reply #10 on: November 17, 2010, 09: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
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15244
Re: The group table does not contain the Anonymous group. Please help!!
« Reply #11 on: November 18, 2010, 04: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.
Logged

kapler

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 23
Re: The group table does not contain the Anonymous group. Please help!!
« Reply #12 on: November 18, 2010, 07: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.
Logged

nika2000

  • Coppermine newbie
  • Offline Offline
  • Posts: 10
Re: The group table does not contain the Anonymous group. Please help!!
« Reply #13 on: January 02, 2011, 10: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?
Logged

nika2000

  • Coppermine newbie
  • Offline Offline
  • Posts: 10
Re: The group table does not contain the Anonymous group. Please help!!
« Reply #14 on: January 02, 2011, 11: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..........
Logged

tobia71

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: The group table does not contain the Anonymous group. Please help!!
« Reply #15 on: January 19, 2011, 10: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
Logged
Pages: [1]   Go Up
 

Page created in 0.087 seconds with 20 queries.