This topic is locked

PHP Runner templates

5/30/2007 6:04:53 PM
PHPRunner General questions
P
PMCrosby author

Hi
I've just tried the templates and pointed the Database to my server where I have several tables already set up using 3.1 version.
My question is it prompts me that it will delete all tables and recreates them for that template. - Does my existing tables not associated to running this template remain, or will I lose tables and data

Sergey Kornilov admin 5/31/2007

Peter,
the wording is incorrect. We'll fix this.
Tables that are not associated with this template will be left intact.

P
PMCrosby author 5/31/2007

Hi
I've just tried a template and it failed to connect to my directory on the MySQL server.
The server has many directories of which mine is called "sbc" under this I have used phprunner to create many applications. each under a separate folder eg sbc/freeads, sbc/property etc.
Using the template it seems to try and create a new root directory similar to "sbc" which I do not have permission to do.
I can however creat folders under sbc.
Am I doing anything wrong or is this haw it is supposed to work

Sergey Kornilov admin 5/31/2007

Peter,
you definitely need to rephrase your question.
How directorires are related to MySQL?

Why template should connect to directory?
Please, explain step-by-step or better yet send me a couple of screenshots.

P
PMCrosby author 5/31/2007

Peter,

you definitely need to rephrase your question.
How directorires are related to MySQL?

Why template should connect to directory?
Please, explain step-by-step or better yet send me a couple of screenshots.


Hi
My ISP that hosts MySql has created a catalogue for me named "sbc" which I have access to create new tables. When using MySQL Administrator I can see other catalogues (databases) that have been created for other companies, but cannot view them since my user and password does not give me access.
When I view my catalogue using the schema view, I can see the tables that I have created in the past. Please note These tables are associated to several different applications. eg Job, car sales, free adds etc.
When using the templates I have found that they all work except "Real Estate" as described in previous note.
However, I am concerned if I run each template to go into the "sbc" catalogue/database, tables may be created/destroyed with similar names in particular the "users" table.
When I have created my applications in the past I called them using the application prefix eg Jobs_users, Carsales_users etc to differentiate between different applications.
I am not sure if others may operate like me/ISP but if they do, tables with data in may be destroyed in particular a table named "users" which I notice seems to be in most templates.
I hope I am making myself clear and you can understand my concerns.
I have just found that what I thought has happened, the table "users", was used by another application which has now lost that information, which does not make me happy!!!!

Sergey Kornilov admin 6/4/2007

Peter,
I see what you saying. Adding a prefix to all tables could a good idea though some things might not work properly (hardcoded table names in events, hardcoded file names etc). That's why I suggest to use a clean database when you create a project using a template.