close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Deprecated: mysql_pconnect()

Thread began 2/07/2014 8:10 am by Brendan | Last modified 2/11/2014 9:10 am by Jason Byrnes | 7496 views | 7 replies |

Brendan

Deprecated: mysql_pconnect()

Using Xampp v3.2.1 to test, Windows 7, DW CC, most recent version of Data Bridge.

I just ran the SA wizard to create registration, login, logout, update, and forgot password pages, when preview in DW I get this full error message at the top of every page.

Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in H:\Sites\ISRC_14\Connections\Local.php on line 11

here is what is contained in local.php
<?php
# FileName="WADYN_CONN.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_Local = "isrc.local";
$database_Local = "isrc";
$username_Local = "root";
$password_Local = "rugbyc12";
@session_start();

/*Line 11 - */ $Local = mysql_pconnect($hostname_Local, $username_Local, $password_Local) or trigger_error(mysql_error(),E_USER_ERROR);

?>

Sign in to reply to this post

Jason ByrnesWebAssist

make sure the mysql library is enabled in the php.ini file.

you may also want to change the error reporting level to not include deprecated warnings.

we will be upgrading Data Bridge to use the mysqli library instead in the near future.

Sign in to reply to this post

Brendan

It appears as though the mysql library is active

**from php.ini **
;extension=php_mssql.dll
;extension=php_mbstring.dll
;extension=php_exif.dll ; Must be after mbstring as it depends on it
extension=php_mysql.dll
extension=php_mysqli.dll
;extension=php_oci8.dll ; Use with Oracle 10gR2 Instant Client
;extension=php_oci8_11g.dll ; Use with Oracle 11gR2 Instant Client

I am not sure how/where to disable error reporting.

I have tried to test my SA pages, but they are not working.
register.php - enter all info, and i get an error message "Invalid information, please check your entries and try again."

Sign in to reply to this post

Jason ByrnesWebAssist

in the php.ini fiule, there is a setting for error reporting:
http://us3.php.net/manual/en/errorfunc.configuration.php#ini.error-reporting



for the registration page,
I'll need to troubleshoot directly, see the private message section. if you are testing locally, you will need to upload to a live server in order for to troubleshoot.

Sign in to reply to this post

Brendan

I only have this issue on my local server. It seems like the security answers aren't validating locally, but are working on my live server.

Sign in to reply to this post

Jason ByrnesWebAssist

There is probably an issue with saving session information on the local server then.

try running the attached session test file. if the test fails, it is probably a bad session.save_path in the php.ini file.

Attached Files
sessionTest.php.zip
Sign in to reply to this post

Brendan

You are correct, there is an issue on my end, the session shows NULL after clicking the second link. Any suggestions on how to correct my session save path?

Sign in to reply to this post

Jason ByrnesWebAssist

edit the php.ini file and set the session.save path to valid directory:
http://us3.php.net/manual/en/session.configuration.php#ini.session.save-path

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...