Icy Phoenix

     
 

Home » Forum » Icy Phoenix Support » Older Versions Archive » Old Support Topics

The time now is Fri 30 May, 2025 23:55 • All times are UTC + 1 Hour [DST enabled]
View previous topic Recent Topics Enable KB mode Download Topic Printable Version Email to a Friend View next topic

SQL ERROR


Post new topic  Reply to topic  		Page 1 of 1
 
 
Offline aliks0905 
 
avatar
Joined: April 2007
Posts: 16

 
 
Reply with quote Download Post 
Post SQL ERROR 
 
I get this error when I try to update a mods forum permissions. please help:

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

INSERT INTO phpbb_auth_access (forum_id, group_id, auth_read, auth_post, auth_reply, auth_news, auth_pollcreate, auth_mod) VALUES (33, , 0, 0, 0, 0, 0, 1)

Line : 417
File : admin_ug_auth.php"
 



 
#1  Tue 16 Oct, 2007 06:00
aliks0905Send private message  
Back to topPage bottom
Sponsors
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
Offline novice programmer Male
 
avatar
Joined: June 2007
Posts: 1030
Location: spain.png
 
 
Reply with quote Download Post 
Post Re: SQL ERROR 
 
Try to repair and optimize the tables (with an sql manager if possible).
 



 
#2  Tue 16 Oct, 2007 16:22
novice programmerSend private message  
Back to topPage bottom
Offline aliks0905 
 
avatar
Joined: April 2007
Posts: 16

 
 
Reply with quote Download Post 
Post Re: SQL ERROR 
 
i repaired them and now i have 5 extra mods that appeared out of no where... and changing their permissions doesnt do anything. what do i do now?
 



 
#3  Tue 16 Oct, 2007 17:33
aliks0905Send private message  
Back to topPage bottom
Offline novice programmer Male
 
avatar
Joined: June 2007
Posts: 1030
Location: spain.png
 
 
Reply with quote Download Post 
Post Re: SQL ERROR 
 
What mods have you installed at your site?
 



 
#4  Tue 16 Oct, 2007 18:55
novice programmerSend private message  
Back to topPage bottom
Offline aliks0905 
 
avatar
Joined: April 2007
Posts: 16

 
 
Reply with quote Download Post 
Post Re: SQL ERROR 
 
I mean 5 extra mods appeared as in 5 new moderators
 



 
#5  Sat 20 Oct, 2007 06:00
aliks0905Send private message  
Back to topPage bottom
Offline novice programmer Male
 
avatar
Joined: June 2007
Posts: 1030
Location: spain.png
 
 
Reply with quote Download Post 
Post Re: SQL ERROR 
 
What version you use?
What where the settings before the change of authorisations?
 



 
#6  Sat 20 Oct, 2007 12:24
novice programmerSend private message  
Back to topPage bottom
Post new topic  Reply to topic  Page 1 of 1
 


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML

Home » Forum » Icy Phoenix Support » Older Versions Archive » Old Support Topics

The time now is Fri 30 May, 2025 23:55 • All times are UTC + 1 Hour [DST enabled]
View previous topic Recent Topics Enable KB mode Download Topic Printable Version Email to a Friend View next topic




 
Permissions List
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events

  

 
 Powered by Icy Phoenix based on phpBB
Lo-Fi Version - Privacy Policy - Cookie Policy
Generation Time: 0.4378s (PHP: 4% SQL: 96%)
SQL queries: 29 - Debug Off - GZIP Enabled
Design by Luca Libralato 
  cron