#17 Update of record, collection and community fails

open
nobody
None
5
2012-10-29
2010-04-21
Abhishek Singh
No

In Fez 2.1RC3, I'm able to create and delete communitiy, collection and records, but modifying any of them simply fails without any error. After digging into the issue I found that when you preview a modified record, it will give you an error:
Array
(
[0] => DB Error: no such table
[1] => SELECT
r1.*
FROM
fez_record_search_key r1 inner join
fez_record_search_key_ m1 on r1.rek_pid = m1.rek__pid AND m1.rek_ = 'SK:34' [nativecode=1146 ** Table 'fez.fez_record_search_key_' doesn't exist]
)

And when you go throuh the "Manage Search Key" page, most of them are listed in red (as not available), though on the database, the tables exist and even the php query in checkIfKeyTableExists() function returns 1, but it is unable to display them as available.

Discussion