This topic is locked

Synchronizing after database layout changes

3/29/2007 2:00:24 AM
PHPRunner General questions
S
SchiDie author

Hi all.
First of all I have to say that phprunner is a really incredible tool.

Days and weeks of coding are done in hours (sometimes minutes).
But now I have a problem, that may pull me back for hours (maybe days):
I have made a project depending on a give state of databse.

I've added some edit/update procedures and many little things.
Yesterday I had to change the layout of one database table (added a needed field to the table).

If I start PHPRunner now, he asks me, if I want to synchronize the projet to the new database layout.

If I do so, ALL fileds in the "choose fields"-window are gone.

User-defined functions in the visual editor are no longer ther, with other words: the project is unusable.
How can I prevent PHPRunner from noticing that database has changed? I only wantmy old project status back. I can change the SQL-Query manually for the additional field.

Or is ther another solution?

How does PHPRunner notice that database has changed?
I hope, that somebody can help me. I don't want to code the procedures again and click through all the fields in "choose fields" and so on and so on
Thx in advance
Dieter

Alexey admin 3/29/2007

Dieter,
please zip and send to support@xlinesoft.com your PHPRunner project directory contents along with your database creation script.
I'll reproduce the problem on my test box and help you to resolve it.

S
SchiDie author 3/29/2007

Alexey,
I'm afraid I will not be able to send the database creation script, becuase I'm working on an existing databse and I have to ask the database manager first, if I'll be allowed to send that.

Meanwhile I found out that the actual build doesn't "forget" the fields (snchronizsation seems to work better) and maybe I "only" have to rebuild the edit, add and list pages.
I'll be back and tell you, what's going on here and maybe I'll "grep" your offer and send the whole package to you.
Thnx so far
Dieter