PHPbb Acces Problem

strato · **PHPbb Acces Problem -** 07-16-2003, 12:06 AM

Hey guys, Im Using Php Nuke V6.5, and im having problems with my phpbb forums, Every time i go to user Permission i get this whe i submit the button

Quote:

Couldn't delete auth access info

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near 'AND auth_mod = 0' at line 3

DELETE FROM nuke_bbauth_access WHERE group_id = AND auth_mod = 0

Line : 175
File : /home/virtual/site14/fst/var/www/html/modules/Forums/admin/admin_ug_auth.php

thats with some user, but when i do it to other users, it all goes normal, but the changes never save, so no Permission is granted, see if anyone here can help me in this situation 8O

strato · 07-16-2003, 12:07 AM

O yeah and by the way, the nuke site location is at www.clanbss.com

strato · 07-16-2003, 09:37 PM

Anyone ? 8O ......can anyone help me on this

IACOJ · 07-16-2003, 10:20 PM

What changes were made prior to the error showing up?

strato · 07-17-2003, 12:15 AM

I dont believe anything was done 8O, other than me modify the overall_header

IACOJ · 07-17-2003, 12:37 AM

Well I wouldn't think that would do it. Were you adding a hack or something when you modified it?

Have you checked to make sure all your files and folders are in the correct place, that you didn't accidently move something to somewhere it wasn't supposed to be?

All of your files related to the theme are in themes? You didn't try to change the default subsilver theme for the forum admin cp or anything like that?

strato · 07-17-2003, 11:18 AM

Yes well that i did, I changed the theme from the Forum CP, it was a php not ported Theme i guess. 8O, i tried putting it with my Theme but another error pressisted so i installed it in the forums themes....

Maybe that could be the problem..... never knew that if you changed that could cause problems... ill check it out

IACOJ · 07-17-2003, 12:42 PM

No maybe that is the problem. The ONLY one that should be there is subSilver. Themes are selected differently in 6.5 then they were in 6.0. All themes are selected from your account, and the default theme is set in admin/preferences.

strato · 07-17-2003, 07:59 PM

I had to reinstall Nuke Again......... 8O

but i still get some errors with my user Groups....... sometimes i log into admin i only see the log out button....... and lots of Errors........ 8O

most recent one is the one for groups

Quote:

Error getting user list for group

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near 'ORDER BY u.username' at line 7

SELECT u.username, u.user_id, u.user_viewemail, u.user_posts, u.user_regdate, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_msnm, ug.user_pending FROM nuke_users u, nuke_bbuser_group ug WHERE ug.group_id = 3 AND u.user_id = ug.user_id AND ug.user_pending = 0 AND ug.user_id <> ORDER BY u.username

Line : 849
File : /home/virtual/site14/fst/var/www/html/modules/Forums/groupcp.php

I have no idea what it is

IACOJ · 07-17-2003, 08:46 PM

Have you installed all secfix 3 and 4?