2. PHPRunner General questions
  3. Deprecated - Ver 5.3 to Ver 8.1
This topic is locked

Deprecated - Ver 5.3 to Ver 8.1

 		5/10/2016 12:17:41 AM
PHPRunner General questions
bbarker author

UPDATED: I have a project that might have been created with PHPRunner in (2012). (VER 6.0)

Now I'm trying to make some changes to it using Version 8.1.
Naturally I get this error message:

"Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in ...\include\dbconnection.php on line 8."
I have read the different posts about the MySQL upgrade instructions on changing from mysql to mysqli. Unfortunately, I don't understand this enough to make the necessary changes.
Is there someone who could explain this in a step-by-step format, or is there someone who could perform the upgrade for a reasonable fee?
Sergey Kornilov admin 5/10/2016

You should not change anything in PHPRunner apps. It will use mysqli instead of mysql functions automatically if mysqli extension is available in PHP.
bbarker author 5/10/2016

This error occurs when I click on "View in Browser" on the OUTPUT screen. I thought that used a PHPR provided Apache server? Something that I didn't install nor have to configure myself.
NEW

Now I'm getting the same ERROR 32 as was described in this old posting:

(where BUILD is trying to write files to itself)

http://www.asprunner.com/forums/topic/19035-error-on-build/

But the "solution" wasn't posted so I don't know what to look for.
I guess that I'll have to cave-in and upload to DEMO. Sorry.

I R-E-A-L-L-Y try to save your time by solving these things myself. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=79327&image=1&table=forumreplies' class='bbc_emoticon' alt=':P' />
Sergey Kornilov admin 5/10/2016

The solution is to choose output folder is different from your project folder.
bbarker author 5/10/2016

Good job Sergey! That solved one of my problems!!!
Now I need to get back to the original one. Ha!!
I'll post again if I can't figure it out.
bbarker author 5/11/2016

Still getting "deprecated" error messages.
One of them is pointing to this line in one of my EVENTs:

$result = mysql_query($query) or die("Query failed with error: ".mysql_error());


I thought I'd post this while I continue to try to "fix" the PHP issue.

Uncommenting the "mysqli" remark in the INI file didn't seem to make any difference. I"m going to reboot it again.
Sergey Kornilov admin 5/11/2016

You are not building it in PHPRunner 8.1. This code doesn't even exist in PHPRunner 8.1.
bbarker author 5/11/2016

Yes... you're partially right. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=79343&image=1&table=forumreplies' class='bbc_emoticon' alt=':P' /> I am using 8.1, but.....
I opened an OLDER project that I built with PHPR 6.
This is why I'm having the problems.

I just installed WAMPP so I might be able to start with a stable baseline shortly.
What is the new way that I should replace this line with?

$result = mysql_query($query) or die("Query failed with error: ".mysql_error());
Sergey Kornilov admin 5/11/2016

You just need to rebuild this project with version 8.1 and this is it. Do not change anything manually.
bbarker author 5/12/2016

After installing WAMPP, most of the application now works.
But one of my Custom pages still returns:

"Access denied for user 'apache'@'localhost' (using password: NO)"
I think most of my issues were due to code in the EVENTS.
I will re-install and REBUILD the original project after lunch.
bbarker author 5/13/2016



You just need to rebuild this project with version 8.1 and this is it. Do not change anything manually.



Sergey,

Would it make a difference if my Version was 5.3? When I look inside the PHPR file, it shows that Version, not 6.0.
Sergey Kornilov admin 5/13/2016

I wish I understand what difference you trying to find. All you need to do is to rebuild the project using the latest version of PHPRunner. It doesn't matter what the version were in old project.