Page 1 of 1

renaming users table causes fatal error

PostPosted: Tue Aug 04, 2009 1:41 am
by 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

PostPosted: Wed Aug 05, 2009 1:08 pm
by 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.

PostPosted: Thu Aug 06, 2009 12:46 am
by 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