View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||
ID | Project | Category | View Status | Date Submitted | Last Update | ||||
---|---|---|---|---|---|---|---|---|---|
0000291 | v1.2 Release (Closed) | [All Projects] General | public | 2009-10-19 01:33 | 2009-12-08 19:08 | ||||
Reporter | avallee | ||||||||
Assigned To | caseydk | ||||||||
Priority | normal | Severity | block | Reproducibility | always | ||||
Status | closed | Resolution | fixed | ||||||
Product Version | |||||||||
Target Version | Fixed in Version | 1.2 | |||||||
Summary | 0000291: SQL error in editing permission | ||||||||
Description | I have change the permission to a user A giving a permission to edit another user's (B) permissions After that change, I can view the permission of user A - SQL error below. | ||||||||
Additional Information | here the SQL error message: ERROR: /home/pollenlpd/www/web2project/classes/query.class.php(1145) : query failed(SELECT FROM ((`users` AS users)) WHERE = '33') - error was: 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 'FROM ((`users` AS users)) WHERE = '33'' at line 1 Backtrace: 0 /home/pollenlpd/www/web2project/classes/query.class.php:1145 dprint('/home/pollenlpd/www/web2project/classes/query.class.php',1145,0,'query failed(SELECT FROM ((`users` AS users)) WHERE = \'33\') - error was: 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 \'FROM ((`users` AS users)) WHERE = \'33\'\' at line 1') 1 /home/pollenlpd/www/web2project/classes/query.class.php:1384 exec(1) 2 /home/pollenlpd/www/web2project/modules/system/acls_view.php:67 loadResult() 3 /home/pollenlpd/www/web2project/index.php:371 require('/home/pollenlpd/www/web2project/modules/system/acls_view.php') ERROR: /home/pollenlpd/www/web2project/classes/query.class.php(1145) : query failed(SELECT FROM ((`users` AS users)) WHERE = '33') - error was: 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 'FROM ((`users` AS users)) WHERE = '33'' at line 1 Backtrace: 0 /home/pollenlpd/www/web2project/classes/query.class.php:1145 dprint('/home/pollenlpd/www/web2project/classes/query.class.php',1145,0,'query failed(SELECT FROM ((`users` AS users)) WHERE = \'33\') - error was: 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 \'FROM ((`users` AS users)) WHERE = \'33\'\' at line 1') 1 /home/pollenlpd/www/web2project/classes/query.class.php:1384 exec(1) 2 /home/pollenlpd/www/web2project/modules/system/acls_view.php:67 loadResult() 3 /home/pollenlpd/www/web2project/index.php:371 require('/home/pollenlpd/www/web2project/modules/system/acls_view.php') ERROR: /home/pollenlpd/www/web2project/classes/query.class.php(1145) : query failed(SELECT FROM ((`users` AS users)) WHERE = '33') - error was: 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 'FROM ((`users` AS users)) WHERE = '33'' at line 1 Backtrace: 0 /home/pollenlpd/www/web2project/classes/query.class.php:1145 dprint('/home/pollenlpd/www/web2project/classes/query.class.php',1145,0,'query failed(SELECT FROM ((`users` AS users)) WHERE = \'33\') - error was: 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 \'FROM ((`users` AS users)) WHERE = \'33\'\' at line 1') 1 /home/pollenlpd/www/web2project/classes/query.class.php:1384 exec(1) 2 /home/pollenlpd/www/web2project/modules/system/acls_view.php:67 loadResult() 3 /home/pollenlpd/www/web2project/index.php:371 require('/home/pollenlpd/www/web2project/modules/system/acls_view.php') ERROR: /home/pollenlpd/www/web2project/classes/query.class.php(1145) : query failed(SELECT FROM ((`users` AS users)) WHERE = '33') - error was: 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 'FROM ((`users` AS users)) WHERE = '33'' at line 1 Backtrace: 0 /home/pollenlpd/www/web2project/classes/query.class.php:1145 dprint('/home/pollenlpd/www/web2project/classes/query.class.php',1145,0,'query failed(SELECT FROM ((`users` AS users)) WHERE = \'33\') - error was: 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 \'FROM ((`users` AS users)) WHERE = \'33\'\' at line 1') 1 /home/pollenlpd/www/web2project/classes/query.class.php:1384 exec(1) 2 /home/pollenlpd/www/web2project/modules/system/acls_view.php:67 loadResult() 3 /home/pollenlpd/www/web2project/index.php:371 require('/home/pollenlpd/www/web2project/modules/system/acls_view.php') | ||||||||
Tags | No tags attached. | ||||||||
Attached Files |
|
![]() |
|
caseydk (administrator) 2009-10-19 10:08 |
Ouch, that's no good. Can you tell me what version of web2project you're using? Are you definitely on the latest (v1.1) release? |
avallee (reporter) 2009-10-21 01:55 |
yes, 1.1 release. Here is the detailed system environment: web2Project 1.1.0 PHP version nr: 5.2.5-pl1-gentoo DB provider and version nr: mysql 5.0.44 (5.0.44-log) DB Table Prefix: "" Web Server: Apache/2.0.59 (Unix) mod_ssl/2.0.59 OpenSSL/0.9.8g Server Protocol | Gateway Interface: HTTP/1.1 | CGI/1.1 Client Browser: Mozilla/5.0 (Windows; U; Windows NT 5.0; fr; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 URL Query: m=help File Version Id: index.php 500 2009-07-09 04:37:42Z caseydk $ $URL: https://web2project.svn.sourceforge.net/svnroot/web2project/trunk/modules/help/index.php Server Time | Timezone: Wed, 21 Oct 2009 13:57:35 | CEST PHP Max. Execution Time: 30 seconds Memory Limit: 64 Mb |
avallee (reporter) 2009-10-22 07:44 |
the worse is that I can't go back and change the permission for that user ... Need to change the permission of its role. |
caseydk (administrator) 2009-11-08 21:11 |
Try running this sql statement: UPDATE `modules` SET `permissions_item_table` = 'users', `permissions_item_field` = 'user_id', `permissions_item_label` = 'user_username' WHERE `mod_directory` = 'admin'; If that works, please let me know and I'll write the formal fix. |
caseydk (administrator) 2009-11-08 21:11 |
(as noted) |
![]() |
|||
Date Modified | Username | Field | Change |
---|---|---|---|
2009-10-19 01:33 | avallee | New Issue | |
2009-10-19 10:07 | caseydk | Project | v1.1 Release (Closed) => v1.2 Release (Closed) |
2009-10-19 10:08 | caseydk | Note Added: 0000554 | |
2009-10-19 10:08 | caseydk | Status | new => feedback |
2009-10-19 10:15 | caseydk | Severity | major => block |
2009-10-21 01:55 | avallee | Note Added: 0000556 | |
2009-10-22 07:44 | avallee | Note Added: 0000558 | |
2009-11-08 21:10 | caseydk | Status | feedback => assigned |
2009-11-08 21:10 | caseydk | Assigned To | => caseydk |
2009-11-08 21:11 | caseydk | Note Added: 0000568 | |
2009-11-08 21:11 | caseydk | Status | assigned => resolved |
2009-11-08 21:11 | caseydk | Resolution | open => fixed |
2009-11-08 21:11 | caseydk | Note Added: 0000569 | |
2009-12-08 19:08 | caseydk | Status | resolved => closed |
2009-12-08 19:08 | caseydk | Fixed in Version | => 1.2 |