This topic is locked

copy project

10/11/2006 12:10:43 PM
PHPRunner General questions
W
wilco muns author

I want to install and manage the project i made on differend servers.

Let's say 2 servers.

When i copy the project dir to another (for the other server) ik can't see the Tabel view's creeted in PHPrunner.

Is it possible to copy the project to a differend dir whithout loosing the Tabel views in PHPrunner?

J
Jane 10/12/2006

Hi,
PHPRunner projects copy to another server without any problems.

Please give me more detailed description of what you're doing.

W
wilco muns author 10/12/2006

Hi,

PHPRunner projects copy to another server without any problems.

Please give me more detailed description of what you're doing.


Hi Jane,
I coppied the database and generated php files to another server.

All works fine.

But when i coppy the project dir to another and startup PHPrunner from that dir (and change the server details) i can' t see the Tabel views in PHP runner. It just display's the tabels used in de database.
I want to do this because i made 1 default project, and want to install it on differend servers and than moddify these projects whitout changing the others.

Alexey admin 10/12/2006

Hi,
I see what you saying.

Custom views a deleted when you change the connection info.
To avoid this you can tweak PHPRunner project file manually after copying the project dir.

Open .phpr file with a text editor, find this line there:

<m_strConnectionString>mysql;server;username;password;port;database;;1</m_strConnectionString>



and modify it to connect another server.

W
wilco muns author 10/12/2006

Hi,

I see what you saying.

Custom views a deleted when you change the connection info.
To avoid this you can tweak PHPRunner project file manually after copying the project dir.

Open .phpr file with a text editor, find this line there:
and modify it to connect another server.


Hello,
Done this, but doesn't seems to work. It just display's the tables and not the custom vieuws (step 3 in php runner).

J
Jane 10/13/2006

Hi,
please ensure that there are all tables in your second database which used in the PHPRunner project.

W
wilco muns author 10/14/2006

Hi,

please ensure that there are all tables in your second database which used in the PHPRunner project.


Done that, all tables are in both te projects, but not the same sequense.

When executing phprunner.php on the website i get te following results (note that i left out the <fields>):

Site 1 is the original project.
Site 1:

<?xml version="1.0" standalone="yes" ?>

  • <phprunner phpversion="4.4.2" mysqlversion="4.1.11-standard-log">
  • <tables>
  • <table name="LoginAttempts">
  • <table name="_Evenementen">
  • <table name="_Leden">
  • <table name="_Login">
  • <table name="_Organisaties">
    Site 2:

    <?xml version="1.0" standalone="yes" ?>
  • <phprunner phpversion="5.1.6" mysqlversion="4.0.26-nt">
  • <tables>
  • <table name="_evenementen">
  • <table name="_leden">
  • <table name="_login">
  • <table name="_organisaties">
  • <table name="loginattempts">

T
thesofa 10/14/2006

I think the table references in PHPR are case sensitive, perhaps you need to make the tables and cases in the same order, you could do an SQL dump from one and import it into the other, then migrate the data from one to the other too.

W
wilco muns author 10/14/2006

I think the table references in PHPR are case sensitive, perhaps you need to make the tables and cases in the same order, you could do an SQL dump from one and import it into the other, then migrate the data from one to the other too.


Thanks to you all!
The mysql server was not case sensitive. Our provider changed it, and everything works fine!
Thanks again!!
Wilco