Re: [Phpgacl-general] RE: Help with Error in group_admin.php
Brought to you by:
ipso
From: <ja...@am...> - 2005-03-26 22:19:33
|
Hello Mike, I did rerun the setup after changing the prefix. I wanted to make sure I was doing it corrently, so I deleted the tables in the database, reran the setup file, and everything seemed to go smoothly. Looking at the tables, they are created with the prefix, but when running the program, I get the exact same error as before, it's looking for 'xdomain-test.gaclaro_groups' when it should be looking for 'xdomain-test.gacl_aro_groups' Thanks again for the help. Jamie > It says do not use "_" because it causes all kinds of issues with the DB > abstraction layer if I recall. But it shouldn't be transparently adding > any "_" either. > > You did re-run setup after changing the prefix correct? > > > On Sat, 2005-03-26 at 16:24 -0500, ja...@am... wrote: >> Thanls for the response! I did like you ask, and reinstalled it, using >> a >> Table Prefix of gacl >> >> I turned on debugging, and this is the error it is showing. The prefix >> and the table name isn't being separated by the _ When editing the >> two >> config files, I only entered 'gacl' for the prefix, should I have use it >> like this instead? 'gacl_' I thought I remembered seeing in the file >> to >> not include the _ >> >> I looked in the database, and all the tables are there, with the prefix. >> >> Thanks again for the help! >> >> Jamie >> >> >> (mysql): SELECT id, parent_id, name FROM gaclaro_groups ORDER BY >> parent_id, name >> -------------------------------------------------------------------------------- >> 1146: Table 'xdomain-test.gaclaro_groups' doesn't exist >> >> adodb_mysql._execute() % line 833, file: adodb.inc.php >> adodb_mysql.execute() % line 1239, file: gacl_api.class.php >> gacl_admin_api.sort_groups() % line 104, file: edit_group.php >> >> sort_groups (): database error: Table 'xdomain-test.gaclaro_groups' >> doesn't exist (1146) >> >> -------------------------------------------------------------------------------- >> (mysql): select value from gaclphpgacl where name = 'version' LIMIT 1 >> -------------------------------------------------------------------------------- >> 1146: Table 'xdomain-test.gaclphpgacl' doesn't exist >> >> adodb_mysql._execute() % line 833, file: adodb.inc.php >> adodb_mysql.execute() % line 452, file: adodb-mysql.inc.php >> adodb_mysql.selectlimit() % line 158, file: adodb-mysql.inc.php >> adodb_mysql.getone() % line 110, file: gacl_api.class.php >> gacl_admin_api.get_version() % line 114, file: edit_group.php >> >> >> -------------------------------------------------------------------------------- >> (mysql): select value from gaclphpgacl where name = 'schema_version' >> LIMIT 1 >> -------------------------------------------------------------------------------- >> 1146: Table 'xdomain-test.gaclphpgacl' doesn't exist >> >> adodb_mysql._execute() % line 833, file: adodb.inc.php >> adodb_mysql.execute() % line 452, file: adodb-mysql.inc.php >> adodb_mysql.selectlimit() % line 158, file: adodb-mysql.inc.php >> adodb_mysql.getone() % line 124, file: gacl_api.class.php >> gacl_admin_api.get_schema_version() % line 115, file: edit_group.php >> >> >> >> >> >> > Its definitely possible. Re-create the tables with a prefix, and this >> > time enable DEBUG mode in the options array. That should show you >> > everything you need to to figure out whats causing the issue. >> > >> > >> > On Sat, 2005-03-26 at 14:37 -0500, Jamie Jackson wrote: >> >> I messing around with this today, when I got the error I was >> >> attempting to install it with a prefix of gacl. All the tables >> >> worked, and when looking at the database, everything seemed in place. >> >> >> >> To try to figure out what was going wrong, I reinstalled it again, >> but >> >> this time I created it's own database and install it without using a >> >> prefix and now everything seems to work as it should. >> >> >> >> Is there a bug in the Table Prefix? >> >> >> >> Thanks! >> >> Jamie >> >> >> >> -----Original Message----- >> >> From: php...@li... >> >> [mailto:php...@li...] On >> Behalf >> >> Of Jamie Jackson >> >> Sent: Saturday, March 26, 2005 12:42 PM >> >> To: php...@li... >> >> Subject: [Phpgacl-general] Help with Error in group_admin.php >> >> >> >> >> >> >> >> I have just installed phpGACL and the set up went through >> >> fine, and bought me to the Admin screen, however whenever I >> >> try to go to ARO Group Admin tab, and go to Add something, it >> >> doesn't come up with an ID, it's N/A and it doesn't have a >> >> parent to choose from, nor can I create one. >> >> >> >> >> >> >> >> I have looked at my error logs on my server, and this is the >> >> error I am getting. >> >> >> >> [26-Mar-2005 12:35:59] PHP Warning: Invalid argument >> supplied >> >> for foreach() in /www/phpgacl/admin/group_admin.php on line >> >> 54 >> >> >> >> >> >> >> >> Can anyone point me in the right direction to fix this >> >> problem? >> >> >> >> >> >> >> >> Thanks! >> >> Jamie >> >> >> >> >> >> >> > -- >> > Mike Benoit <ip...@sn...> >> > >> > -- > Mike Benoit <ip...@sn...> > |