Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#265 BUG: double prefix on query for table gacl_axo / gacl_aco

open
nobody
General (114)
5
2012-11-15
2010-11-29
toaste
No

Version 2.1.4
a fresh install gives me the error below. The check for permission fails because the query uses a wrong tablename
bw_dotp.{prefix}_{prefix}_gacl_axo

ERROR: /home/httpd/vhosts/mydomain.lh/httpdocs/dotp/classes/query.class.php(623): query failed(SELECT id, section_value, name, value, order_value, hidden FROM (`xxdotp_xxdotp_gacl_axo`) WHERE section_value='app' AND hidden=0 ORDER BY order_value) - error was: Table 'bw_dotp.xxdotp_xxdotp_gacl_axo' doesn't exist
Backtrace:
0 /home/httpd/vhosts/mydomain.lh/httpdocs/dotp/classes/query.class.php:623 dprint('/home/httpd/vhosts/mydomain.lh/httpdocs/dotp/classes/query.class.php',623,0,'query failed(SELECT id, section_value, name, value, order_value, hidden FROM (`xxdotp_xxdotp_gacl_axo`) WHERE section_value=\'app\' AND hidden=0 ORDER BY order_value) - error was: Table \'bw_dotp.xxdotp_xxdotp_gacl_axo\' doesn\'t exist')
1 /home/httpd/vhosts/mydomain.lh/httpdocs/dotp/classes/permissions.class.php:724 exec()
2 /home/httpd/vhosts/mydomain.lh/httpdocs/dotp/classes/permissions.class.php:562 get_objects_full('app',0,'axo')
3 /home/httpd/vhosts/mydomain.lh/httpdocs/dotp/modules/admin/vw_usr_perms.php:9 getModuleList()
4 /home/httpd/vhosts/mydomain.lh/httpdocs/dotp/style/default/overrides.php:95 require('/home/httpd/vhosts/mydomain.lh/httpdocs/dotp/modules/admin/vw_usr_perms.php')
5 /home/httpd/vhosts/mydomain.lh/httpdocs/dotp/modules/admin/viewuser.php:204 show()
6 /home/httpd/vhosts/mydomain.lh/httpdocs/dotp/index.php:299 require('/home/httpd/vhosts/mydomain.lh/httpdocs/dotp/modules/admin/viewuser.php')
<\pre>

ERROR: /home/httpd/vhosts/mydomain.lh/httpdocs/dotp/classes/query.class.php(623): query failed(SELECT id, section_value, name, value, order_value, hidden FROM (`xxdotp_xxdotp_gacl_aco`) WHERE section_value='application' AND hidden=0 ORDER BY order_value) - error was: Table 'bw_dotp.xxdotp_xxdotp_gacl_aco' doesn't exist
Backtrace:
0 /home/httpd/vhosts/mydomain.lh/httpdocs/dotp/classes/query.class.php:623 dprint('/home/httpd/vhosts/mydomain.lh/httpdocs/dotp/classes/query.class.php',623,0,'query failed(SELECT id, section_value, name, value, order_value, hidden FROM (`xxdotp_xxdotp_gacl_aco`) WHERE section_value=\'application\' AND hidden=0 ORDER BY order_value) - error was: Table \'bw_dotp.xxdotp_xxdotp_gacl_aco\' doesn\'t exist')
1 /home/httpd/vhosts/mydomain.lh/httpdocs/dotp/classes/permissions.class.php:724 exec()
2 /home/httpd/vhosts/mydomain.lh/httpdocs/dotp/classes/permissions.class.php:581 get_objects_full('application',0,'aco')
3 /home/httpd/vhosts/mydomain.lh/httpdocs/dotp/modules/admin/vw_usr_perms.php:46 getPermissionList()
4 /home/httpd/vhosts/mydomain.lh/httpdocs/dotp/style/default/overrides.php:95 require('/home/httpd/vhosts/mydomain.lh/httpdocs/dotp/modules/admin/vw_usr_perms.php')
5 /home/httpd/vhosts/mydomain.lh/httpdocs/dotp/modules/admin/viewuser.php:204 show()
6 /home/httpd/vhosts/mydomain.lh/httpdocs/dotp/index.php:299 require('/home/httpd/vhosts/mydomain.lh/httpdocs/dotp/modules/admin/viewuser.php')

Discussion