2. PHPRunner General questions
  3. Error uploading Jobs template
This topic is locked

Error uploading Jobs template

 		4/15/2008 5:21:47 PM
PHPRunner General questions
C
 cglaeser author

I downloaded the PHPRunner trial and tried to use the Jobs template. Creating the template database generates the error message, "You have an error in your SQL syntax near, 'FOREIGN_KEY_CHECKS = 0' near line 1. I searched the forum for "FOREIGN_KEY_CHECKS" but did not get a good hit. Using MYSQL. Any ideas what I did wrong?
Best,

Christopher
Sergey Kornilov admin 4/15/2008

Christopher,
what version of MySQL do you use?
Is that a local database or one that runs on remote server?
C
 		cglaeser author 4/15/2008

Christopher,

what version of MySQL do you use?
Is that a local database or one that runs on remote server?


MySQL Version 3.23.33. It's on a remote server. The ISP is AIT.com. I see the MySQL port number is 4346 and I did not set the port number in PHPRunner. Could that make a difference?
Best,

Christopher
C
 		cglaeser author 4/16/2008

PHPRunner looks to be an ideal product for me. I'm ready to purchase if I can get it to work. I downloaded the trial and tried to create a jobs database using the Jobs template, which generated the error message posted above. I posted the error message here and submitted it to the support email address. No response yet from support, and no useful hints posted yet here. Let me know if there is something else I need to do. I am eager to move forward and send you my money.
Best,

Christopher
Sergey Kornilov admin 4/16/2008

Christopher,
PHPRunner needs MySQL 3.23.6 or higher.

MySQL 4.x or 5.x are highly recommended.
C
 		cglaeser author 4/16/2008

PHPRunner needs MySQL 3.23.6 or higher.

MySQL 4.x or 5.x are highly recommended.


Thanks. My ISP is running 3.23.33. Isn't that higher than 3.23.6?
Best,

Christopher
Sergey Kornilov admin 4/16/2008

It appears you need MySQL 4.x or 5.x to use templates.
C
 		cglaeser author 4/24/2008

It appears you need MySQL 4.x or 5.x to use templates.


Yep, you either neec MySQL 4.x or 5.x, or you can delete the statements that use FOREIGN_KEY_CHECKS from the template db.sql file. I did the latter, and it seems to be working fine.
FWIW, my ISP offered to upgrade my server from Linux and MySQL 3.x to Fedora 3 and MySQL 4.x. Any reason why I should avoid Fedora?
Best,

Christopher