Menu
▾
▴
Re: [Fez-developers] Missing fez_auth_roles table and sql syntax problem
|
From: Peter N. <Pet...@cd...> - 2007-09-18 05:00:09
|
Hi Christiaan A minor problem with the upgrade script (svn diff upgrade/sql_scripts/upgrade2007090601.sql): Index: upgrade/sql_scripts/upgrade2007090601.sql =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D --- upgrade/sql_scripts/upgrade2007090601.sql (revision 1005) +++ upgrade/sql_scripts/upgrade2007090601.sql (working copy) @@ -351,8 +351,8 @@ REPLACE INTO %TABLE_PREFIX%workflow_state_roles select wfs_id, aro_id from %TABLE_PREFIX%workflow_state -inner join fez_auth_roles on instr(wfs_roles, aro_role) > 0 and aro_id !=3D 0; +inner join %TABLE_PREFIX%auth_roles on instr(wfs_roles, aro_role) > 0 and aro_id !=3D 0; REPLACE INTO %TABLE_PREFIX%workflow_roles select wfL_id, aro_id from %TABLE_PREFIX%workflow -inner join fez_auth_roles on instr(wfL_roles, aro_role) > 0 and aro_id !=3D 0; +inner join %TABLE_PREFIX%auth_roles on instr(wfL_roles, aro_role) > 0 and aro_id !=3D 0; But there is still a problem with this error (but only if you are not logged in): Array ( [0] =3D> DB Error: syntax error [1] =3D> SELECT SQL_CALC_FOUND_ROWS DISTINCT r1.* FROM fez_record_search_key AS r1 INNER JOIN fez_auth_index2_lister ON authi_pid=3Dr1.rek_pid and authi_arg_id in () WHERE r1.rek_status =3D 2 ORDER BY r1.rek_created_date DESC, r1.rek_pid DESC LIMIT 5 OFFSET 0=20 [nativecode=3D1064=20 ** You have an error in your SQL syntax; check the manual that corresponds to your=20 MySQL server version for the right syntax to use near ') WHERE r1.rek_status =3D 2 ORDER BY r1.rek_created_date DESC, r1.rek_pi' = at line 3] ) include/class.record.php 915 I have traced it to the class.collection.php file (line 447) where the function getPublicAuthIndexGroups returns an empty list (you can't have "authi_arg_id in ()" be empty. The sql which returns nothing that logically has to return something! is this: SELECT distinct argr_arg_id FROM testfez_auth_rule_group_rules INNER JOIN testfez_auth_rules ON ar_rule=3D'public_list' AND ar_value=3D'1' AND argr_ar_id=3Dar_id; This is where my understanding of the fez data structures ends although I can say my testfez_auth_rule_group_rules table is empty and prehaps it shouldn't be... Regards Pete -----Original Message----- From: fez...@li... [mailto:fez...@li... <mailto:fez...@li...> ] On Behalf Of Christiaan Kortekaas Sent: Monday, 17 September 2007 7:33 PM To: fez...@li... Subject: Re: [Fez-developers] Missing fez_auth_roles table and sql syntax problem Hi Peter It looks like you are missing some new tables. If you are using the trunk you'll need to run the upgrade scripts, import the latest workflows and xsds. The upgrade scripts can be run by going to http://yourfez/upgrade/ <http://yourfez/upgrade/> and clicked the run upgrade button. Cheers, Christiaan On 17/9/07 5:31 PM, "Peter Newman" <Pet...@cd...> wrote: > > Hi > > I'm currently playing with the fez trunk (current head - 999) with > fedora 2.2.1 (using postgresql 8.1.9-1) on a rhel5 system. The > version of mysql-server is 5.0.22-2.1.0.1 and php is 5.1.6-12. > > After running setup to initialise a database (and check_sanity runs > without errors) I get the following errors (see below). I'll dig > further tomorrow but was wondering if you had any suggestions in the > meantime - thanks... > > There Errors: > > Array > ( > [0] =3D> DB Error: no such table > [1] =3D> SELECT aro_id FROM fez_auth_roles where aro_role =3D 'Lister' > [nativecode=3D1146 ** Table 'fezsvnfedora221.fez_auth_roles' doesn't > exist] > ) > > include/class.auth.php 211 > > > And: > > Array > ( > [0] =3D> DB Error: syntax error > [1] =3D> SELECT SQL_CALC_FOUND_ROWS DISTINCT r1.* FROM > fez_record_search_key AS r1 > > INNER JOIN fez_auth_index2 ai > ON authi_role in () AND ai.authi_pid =3D r1.rek_pid INNER JOIN > fez_auth_rule_group_users ON argu_usr_id=3D0 AND > ai.authi_arg_id=3Dargu_arg_id WHERE r1.rek_status =3D '2' ORDER BY > r1.rek_created_date DESC, r1.rek_pid DESC LIMIT 5 OFFSET 0 > [nativecode=3D1064 ** 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 ') AND ai.authi_pid =3D r1.rek_pid INNER JOIN > fez_auth_rule_grou' at line 4] > ) > > include/class.record.php 915 > > > Peter Newman > > ---------------------------------------------------------------------- > --- This SF.net email is sponsored by: Microsoft Defy all challenges. > Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ <http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/>=20 > _______________________________________________ > Fez-developers mailing list > Fez...@li... > https://lists.sourceforge.net/lists/listinfo/fez-developers <https://lists.sourceforge.net/lists/listinfo/fez-developers>=20 -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Christiaan Kortekaas Senior Library Open Sorcerer Library Technology Service The University of Queensland, Australia QLD 4072 Telephone : (+61) (7) 3346 4337 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ------------------------------------------------------------------------ - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ <http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/>=20 _______________________________________________ Fez-developers mailing list Fez...@li... https://lists.sourceforge.net/lists/listinfo/fez-developers <https://lists.sourceforge.net/lists/listinfo/fez-developers>=20 |