renaming users table causes fatal error

Archived from the Internet Media Manager Discussion forum.

Martin Pruss — Tue Aug 04, 2009 1:41 am

hi Steve…

I am using Xataface now in every flavour and version, but mostly in one database.

thats why i have to rename the users table for the media manager.(fresh clean install… i also had to comment out the “else branch” to make it work.. see third posting in this forum)

Unfortunately this causes the following error:

Code: Select all

Notice: Valuelist query 'select user_id,username from users order by username' failed. On line 1138 of file /data/myserver/roadshow.de/www/html/xmm/dataface/Dataface/Table.php in function printStackTrace() On line 3004 of file /data/myserver/roadshow.de/www/html/xmm/dataface/Dataface/Table.php in function _loadValuelistsIniFile() On line 628 of file /data/myserver/roadshow.de/www/html/xmm/dataface/Dataface/Table.php in function valuelists() On line 2207 of file /data/myserver/roadshow.de/www/html/xmm/dataface/Dataface/Table.php in function Dataface_Table(roadshow_users,Resource id #12,) On line 29 of file /data/myserver/roadshow.de/www/html/xmm/dataface/Dataface/Serializer.php in function loadTable(roadshow_users) On line 135 of file /data/myserver/roadshow.de/www/html/xmm/dataface/Dataface/AuthenticationTool.php in function Dataface_Serializer(roadshow_users) On line 210 of file /data/myserver/roadshow.de/www/html/xmm/dataface/Dataface/AuthenticationT in /data/myserver/roadshow.de/www/html/xmm/dataface/Dataface/Table.php on line 1138

I thougt it might be clever to ask you, before i start following all the error reports and making everythig worse by trying to fix it…

cheers

Martin

---

shannah — Wed Aug 05, 2009 1:08 pm

Hmm.. you may want to do a grep of all of the files in media manager to find all of the places where “users” is mentioned. In particular this looks like it is complaining about a valuelist that is defined to return a list of users in the app.

But there may be more places where the users table name is hardcoded. Hopefully only a handful.

---

Martin Pruss — Thu Aug 06, 2009 12:46 am

hi Steve..

It was just one occurance in valuelists ini in the root folder of the app.

Code: Select all

[groups]    __sql__ = "select group_id,group_name from groups order by group_name"     [users]    __sql__ = "select user_id,username from users order by username"     [categories]    __sql__ = "select category_id,category_name from categories order by category_name"

cheers

Martin