[Fez-developers] Missing fez_auth_roles table and sql syntax problem

[Peter N. <Pet...@cd...>]

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=20


Peter Newman