2. PHPRunner General questions
  3. Edit problems
This topic is locked

Edit problems

 		10/27/2006 17:56:53
PHPRunner General questions
C
 Chris Patterson author

Hope someone can help, I have a database with 4 tables I have set the permissions so users can only view and edit their own data and an administrator (me) who can view and edit all data.

Problem everything works perfectly except the administrator cannot edit any data, I get an error message
<<< Record was NOT updated >>>
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 ')' at line 1
If i log on as a user I can edit data o.k, if I logon as administrator I can add records and view everyones records o.k I just cannot edit them.
Any clues ??
C
 		Chris Patterson author 10/28/2006

I have been experimenting with the admin side and it all works unless I enable someone to have the ability to view and edit all users data, is this a limitation in the trial version or is there something wrong ??
J
 		Jane 10/30/2006

answered in your personal email.
H
 		hippobill 10/30/2006

answered in your personal email.


Any chance of showing the fix, since I am having the same problem. The SQL script giving the error is ends with "...where id = '1' and ()".
TIA

Bill
C
 		Chris Patterson author 10/30/2006

answered in your personal email.


Jane personal email ??

nothing in my inbox ??
Alexey admin 10/30/2006

Hi,
I'm sorry for this inconvenience.

The fix will be available tomorrow.
Here is what you can do to get your pages working now.

Open edit.php file in C:\Program Files\PHPRunner3.1\source folder and find this line there:

$strSQL .= " and (".SecuritySQL("Edit").")";

and replace it with:

if(SecuritySQL("Edit"))

$strSQL .= " and (".SecuritySQL("Edit").")";


Then rebuild your project.