Icy Phoenix

     
 


Post new topic  This topic is locked: you cannot edit posts or make replies. 
Page 1 of 1
 
 
Reply with quote Download Post 
Post Permissions Problems 
 
I get this when i want to apply special permissions on user

Quote:

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 sj_auth_access (forum_id, group_id, auth_news, auth_mod) VALUES (13, , 0, 1)

Line : 417
File : admin_ug_auth.php


I have checked the mysql and  sj_auth_access   is totally empty

how do i solve this ???
 



 
rocoSend private message  
Back to topPage bottom
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
Reply with quote Download Post 
Post Re: Permissions Problems 
 
Hi, roco

So do you have sj_auth_access table at all? Is sj_ correct prefix of your Icy tables? First check these two conditions. If you have that table and sj_ IS your correct db prefix, table may be corrupted. In that case you should drop it and create it again.
WARNING: by doing this you will lose user permissions, and you will have to set it up again from scratch.

Run this query on your Icy database, to drop auth_access table:
Code: [Download] [Hide] [Select]
DROP TABLE 'sj_auth_access'


Now run this query to create fresh table:
Code: [Download] [Hide] [Select]
CREATE TABLE `sj_auth_access` (
  `group_id` mediumint(8) NOT NULL default '0',
  `forum_id` smallint(5) unsigned NOT NULL default '0',
  `auth_view` tinyint(1) NOT NULL default '0',
  `auth_read` tinyint(1) NOT NULL default '0',
  `auth_post` tinyint(1) NOT NULL default '0',
  `auth_reply` tinyint(1) NOT NULL default '0',
  `auth_edit` tinyint(1) NOT NULL default '0',
  `auth_delete` tinyint(1) NOT NULL default '0',
  `auth_sticky` tinyint(1) NOT NULL default '0',
  `auth_announce` tinyint(1) NOT NULL default '0',
  `auth_globalannounce` tinyint(1) NOT NULL default '0',
  `auth_news` tinyint(1) NOT NULL default '0',
  `auth_cal` tinyint(1) NOT NULL default '0',
  `auth_vote` tinyint(1) NOT NULL default '0',
  `auth_pollcreate` tinyint(1) NOT NULL default '0',
  `auth_attachments` tinyint(1) NOT NULL default '0',
  `auth_download` tinyint(1) NOT NULL default '0',
  `auth_ban` tinyint(1) NOT NULL default '0',
  `auth_greencard` tinyint(1) NOT NULL default '0',
  `auth_bluecard` tinyint(1) NOT NULL default '0',
  `auth_rate` tinyint(1) NOT NULL default '0',
  `auth_mod` tinyint(1) NOT NULL default '0',
  KEY `group_id` (`group_id`),
  KEY `forum_id` (`forum_id`)
);

This queries will work only if (again ) your db prefix is sj_.

Good luck
 




____________
Omarska online
 
omarskaSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Permissions Problems 
 
My tables are ok, i droped an created again, and still have this problem, everything else works ok on the forum.  HELP PLEASE

When i look it says.

INSERT INTO sj_auth_access (forum_id, group_id, auth_news, auth_mod) VALUES (13, , 0, 1)

A value seems to be missing there.  1 can tryit manually, but this does not suppose to happen ...

My tables are ok

imagetableil5

I only can apply permisions per group, but not for individuals.
 



 
rocoSend private message  
Back to topPage bottom
Post new topic  This topic is locked: you cannot edit posts or make replies.  Page 1 of 1
 


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML




 
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