Permissions Error

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
maester
Registered User
Posts: 51
Joined: Mon May 03, 2004 8:26 am
Location: Tennessee
Contact:

Permissions Error

Post by maester » Thu May 26, 2005 3:41 am

got this error that people login and they got admin they are orange and they say they have admin panel access so I go to the admin and look go to permissions and it doesnt show them as admin so I hit save and get this error


Could not obtain moderator status

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND aa.group_id = ug.group_id AND aa.auth_mod = 1

SELECT ug.user_id, COUNT(auth_mod) AS is_auth_mod FROM phpbb_auth_access aa, phpbb_user_group ug WHERE ug.user_id IN () AND aa.group_id = ug.group_id AND aa.auth_mod = 1 GROUP BY ug.user_id

Line : 530
File : admin_ug_auth.php

maester
Registered User
Posts: 51
Joined: Mon May 03, 2004 8:26 am
Location: Tennessee
Contact:

Post by maester » Thu May 26, 2005 5:35 am

and im also getting this error both in the admin panel

Couldn't obtain who is online ranks data

DEBUG MODE

SQL Error : 1146 Table 'sdtf_phpb2.WHOSONLINE_RANKS_TABLE' doesn't exist

SELECT * FROM WHOSONLINE_RANKS_TABLE ORDER BY whosonline_rank_order

Line : 267
File : admin_ranks_whosonline.php

User avatar
nuckfan15
Registered User
Posts: 1849
Joined: Fri Jul 09, 2004 4:46 am
Location: Vancouver, BC
Name: Travis

Post by nuckfan15 » Thu May 26, 2005 5:39 am

Any mods installed?

espicom
Registered User
Posts: 17905
Joined: Wed Dec 22, 2004 1:14 am
Location: Woodstock, IL

Post by espicom » Thu May 26, 2005 2:03 pm

You have at least a couple of problems here, probably MOD related.

The first query that fails is because an "IN" clause can't be empty, and yours is. Whatever was supposed to fill in the list of user_id values within the parens was undefined when the query was constructed.

The one about the table not being found is because the modifications to constants.php were not made to convert the all-upper-case constant "WHOSONLINE_RANKS_TABLE" to its proper value.

Recheck your MOD instructions, and check with the author on their support forum, if you have further questions, since this doesn't relate to "stock" PHPBB.
Jeff
Fixing 1016/1030/1034 Errors | (obsolete link) | MySQL 4.1/5.x Client Error | phpBBv2 Logo in ACP
Support requests via PM are ignored!
"To be fully alive is to feel that everything is possible." - Eric Hoffer

maester
Registered User
Posts: 51
Joined: Mon May 03, 2004 8:26 am
Location: Tennessee
Contact:

Post by maester » Fri May 27, 2005 12:14 am

the 1st mod was stock related the 2nd one probally wasnt I trransferred from phpnuke to phpbb successfully except for that 1st error anyone know how to fix it?

maester
Registered User
Posts: 51
Joined: Mon May 03, 2004 8:26 am
Location: Tennessee
Contact:

Post by maester » Fri May 27, 2005 12:16 am

Now im getting this error clicking on save under the permissions area?

Couldn't delete auth access info

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND auth_mod = 0' at line 3

DELETE FROM phpbb_auth_access WHERE group_id = AND auth_mod = 0

Line : 180
File : admin_ug_auth.php

maester
Registered User
Posts: 51
Joined: Mon May 03, 2004 8:26 am
Location: Tennessee
Contact:

Post by maester » Fri May 27, 2005 12:59 am

also I fixed my 2nd error it was missing out of the constants.php thanx just need help with the other problem

espicom
Registered User
Posts: 17905
Joined: Wed Dec 22, 2004 1:14 am
Location: Woodstock, IL

Post by espicom » Fri May 27, 2005 2:33 am

Jeff
Fixing 1016/1030/1034 Errors | (obsolete link) | MySQL 4.1/5.x Client Error | phpBBv2 Logo in ACP
Support requests via PM are ignored!
"To be fully alive is to feel that everything is possible." - Eric Hoffer

maester
Registered User
Posts: 51
Joined: Mon May 03, 2004 8:26 am
Location: Tennessee
Contact:

Post by maester » Fri May 27, 2005 9:17 am

thank you very much that worked

Locked

Return to “2.0.x Support Forum”