renaming users table causes fatal error

[Martin Pruss]

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]

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]

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