renaming users table causes fatal error

Forum for support on the Internet Media Manager Application

renaming users table causes fatal error

Postby 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
Martin Pruss
 
Posts: 61
Joined: Tue Oct 23, 2007 2:22 pm
Location: Berlin

Postby 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.
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm

Postby 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
Martin Pruss
 
Posts: 61
Joined: Tue Oct 23, 2007 2:22 pm
Location: Berlin


Return to Internet Media Manager Discussion

Who is online

Users browsing this forum: No registered users and 1 guest

Powered by Dataface
© 2005-2007 Steve Hannah All rights reserved