Page 1 of 1

How to "reset" after database change

PostPosted: Mon Nov 01, 2010 3:12 pm
by JonP
I just made a change to a column name and could not get xataface to work with the new name - it just kept blowing up on an SQL statement that referenced the old name. Got the main app running by reverting to the old name but now seem to have some different baggage hanging around.

How are you supposed to reset after this kind of change to avoid this kind of problem?

Re: How to "reset" after database change

PostPosted: Tue Nov 02, 2010 7:26 am
by cantlep
Not sure on Windows system but if you're using a *NIX server. I'd look into this:

Code: Select all
cd /var/lib/mysql/<DB name>

and then rm the "dataface__view_table_blahblahblah.frm file

and see if that works.

Paul

Re: How to "reset" after database change

PostPosted: Tue Nov 02, 2010 2:18 pm
by JonP
Thanks Paul - I didn't have to worry about the location (I'm actually using an IBM i Server and using the DB2 storage engine for MySQL) and was able to simply use Adminer to drop those tables.

The application now works again but I seem to have lost some functionality in the latest version. For example there are no export options on the main full list and the individual entries are no longer directly selectable for display (only via the click box). Also have a bug when trying to add a row from the main list. It only works from within the display of individual rows. One step forward - two steps back it seems. I'll do some more checking and open a bug report if need be.

Thanks again.