Page 1 of 1

Rebuilding or Refreshing

PostPosted: Thu Mar 22, 2012 9:49 am
by Sutekh
Hello,

I am one student of a three person group doing a community service project where we are building a client database. The issue we are currently having is that we need a means to rebuild our database front-end or refresh it to show changes made to the database through phpmyadmin but have been unable to get Xataface to show any of the changes made. I have tried searching and doing research but have been unable to find any guide on how to rebuild the front-end to show the changes. Any help would be greatly appreciated.

Thank you

Re: Rebuilding or Refreshing

PostPosted: Thu Mar 22, 2012 10:03 am
by shannah
Do you mean that when you add columns, Xataface isn't picking it up?
Are you using custom __sql__ queries in the fields.ini files?
Do you have APC installed on the server?

Sometimes APC can prevent database changes from being picked up because it is used for caching some of this information. You can force it to refresh this cache by adding --refresh-apc=1 to the query string of the request. E.g.
index.php?-action=foo&table=bar&--refresh-apc=1

-Steve

Re: Rebuilding or Refreshing

PostPosted: Thu Mar 22, 2012 12:16 pm
by Sutekh
I'll double check the APC issue the next time I get to talk to one of my group members. The issue is adding a new column though. We are trying to add new tables to the database using phpmyadmin but can not get the new tables to appear in the current Xataface build and are not sure why.