Icy Phoenix

Old Support Topics - Moderator Problem

sonoangelo [ Thu 08 Mar, 2007 13:15 ]
Post subject: Moderator Problem

hello
i found a problem when i go to do an user moderator: i select the forum where he has to moderate and i do APPLY but IP gives me this SQL Sintax Error:

Code: [Hide] [Select]

Couldn't update private forum permissions

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 ' 0, 1)' at line 2

INSERT INTO phpbb_TMPauth_access (forum_id, group_id, auth_news, auth_mod) VALUES (3, , 0, 1)

Line : 419

File : admin_ug_auth.php

andrea75 [ Thu 08 Mar, 2007 14:39 ]
Post subject: Re: Moderator Problem

Uhmmmm... I don't have this problem. What version of IP do you have? Have try to upload again the admin_ug_auth.php file?

sonoangelo [ Thu 08 Mar, 2007 18:12 ]
Post subject: Re: Moderator Problem

sure i've the 1.0.9.9 updated with the patch files,

for the file i've uploaded ALL the news folder after deleting the exiting one

Zuker [ Thu 08 Mar, 2007 18:35 ]
Post subject: Re: Moderator Problem

on my copy of icy the problem isn't there to...

did you aply all db updates?

andrea75 [ Thu 08 Mar, 2007 18:36 ]
Post subject: Re: Moderator Problem

sonoangelo wrote: [View Post]
sure i've the 1.0.9.9 updated with the patch files,
for the file i've uploaded ALL the news folder after deleting the exiting one

And you have execute the file update_to_ip.php, right? Another question... where do you give the permission to got the error?

sonoangelo [ Thu 08 Mar, 2007 22:23 ]
Post subject: Re: Moderator Problem

only there i think, yes i've done all right

Mighty Gorgon [ Sun 11 Mar, 2007 12:44 ]
Post subject: Re: Moderator Problem

Did you upgrade from some old phpBB or XS version?

sonoangelo [ Sun 11 Mar, 2007 15:31 ]
Post subject: Re: Moderator Problem

from xs, but i did a fresh installation of IP and then restored my DB backup

sonoangelo [ Tue 13 Mar, 2007 12:12 ]
Post subject: Re: Moderator Problem

solved, just go to ACP > DB > DB Maintenace > Verific User and Group Tables