2. PHPRunner General questions
  3. Database Sync Option not found
This topic is locked

Database Sync Option not found

 		6/14/2011 23:38:56
PHPRunner General questions
I
 imthebest author

I have made some changes in the Database using phpmysql. Also created a new table using phprunner. Now I want to sync the database in phprunner. For that I right click on the project name on the left pane on the Datasource tables, but there is no option for database sync. In fact, no option appears when I right click on Project name on datasource table.

If I right click on "Tables" then I get only one option i.e "create new table".
I am unable to find out where is the option for database synchronisation?
I am using phprunner 4.2.
Please help.
Thanks is advance.
Sergey Kornilov admin 6/15/2011

In version 4.2 database is synchronized automatically.
I
 		imthebest author 6/15/2011



In version 4.2 database is synchronized automatically.


Hi Admin,
Thanks for the prompt reply.
However, I am facing the issue. I followed following steps and encountered the problem -

  1. I deleted one field from phpmysql. Came back to phprunner, but found that the field was still there. I Reset the SQL query. Created Build and tested the application using Browser. I got run time error stating Invalid field name, which SQL "Select" statement was trying to select. This was the same field that I deleted from phpmysql.
  2. I then closed the phprunner and opened again. I now got a message, stating that "Following Tables have been changed since you last updated the database. Do you want to sync the database?". I chose OK. Then created build again. Then tested the application again. But unfortunately I again got the same run time error message.
    I repeated the step 2. Getting same message again, stating that "Following Tables have been changed since you last updated the database. Do you want to sync the database?". This is getting repeated, and my database is not getting sychronised.
    Am I missing something?
Sergey Kornilov admin 6/15/2011

Hard to tell what might be wrong without seeing your project file and database. I recommend to contact support directly sending your project file along with your database for investigation.