close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Fatal error: Call to undefined function mysql_pconnect() ....

Thread began 4/04/2020 9:36 pm by yogastudents362523 | Last modified 4/13/2020 10:46 pm by Ray Borduin | 80 views | 12 replies |

yogastudents362523

Fatal error: Call to undefined function mysql_pconnect() ....

I refer you to http://www.webassist.com/forums/posts.php?id=38086, where you finished by saying:
"You can use the MySQLi server behaviors. You would just have to create a MySQLi connection and then start using those server behaviors on your pages. DataBridge v2 includes functionality to update existing MySQL pages to MySQLi as well."

I was eventually forced to upgrade PHP to 7.1, and immediately started getting 500 errors from all my other pages, which depend upon queries and recordsets for varied kinds of information on those pages.
.
When it eventually occurred to me to examine the site log files, I traced the likely difficulty down to a call to a "MySQL_pconnect" function.

I have used DataAssist to create a new MySQLi connection.

I am now wondering on a best practices method for how to proceed.

Your above suggestion seems to imply that there is a way in which DataAssist would automatically correct all relevant recordsets and the like for me, but I am undertain how to invoke this. That would of course be easiest for me by way of preventing further errors.

Failing that, is it better to delete a recordset befor creating a new recordset of the desired type, which of course requires that I use the old MySQL format as a model for the data I require, whilst being uncertain of the desired result and etc.

Thank you for your assistance in determining a best way forwards.
KB

Sign in to reply to this post

Ray BorduinWebAssist

Keep the old recordset and connection in place. Then create the new MySQLi recordset. At that point you can open the old server behaviors that use the old recordset and switch the connection to the new MySQLi version. When you click OK the associated code will be updated to MySQLi as well.

Let me know if you need help and I can do one or two pages in a screen sharing session so you can see how it is done.

Sign in to reply to this post
Did this help? Tips are appreciated...

yogastudents362523

Hi,

Thank you. You as ever make it sound simple.
I will attempt everything It can myself first, so we can both be assured I have reached the limits of my expertise before calling on you.

Thank you for your kindness,
KB

Sign in to reply to this post

yogastudents362523

Thanks for your assistance, my efforts continue apace and are gradually being rewarded.
KB

Sign in to reply to this post

Ray BorduinWebAssist

Please attach the page in context so I can see what would be the easiest way to fix this issue.

If you have already updated the recordset, then it might be:
<?php echo date('l F j', strtotime($events->getColumnVal("startdate"))) . " to " . date('l F j', strtotime($events->getColumnVal("enddate"))); ?>

Sign in to reply to this post
Did this help? Tips are appreciated...

yogastudents362523

I have tried a couple of things already, and am now wondering about two issues. A. 32-bit versus 64-bit which i doupt is the issue, and B. the format for storage in the database, which is ”date” type, rather than either ”datetime” or ”timestamp”.

Sign in to reply to this post

Ray BorduinWebAssist

32 vs 64 bit doesn't matter.

Any datatype can be used as well.

I've cleaned up your page and manually updated all of the old mysql code to mysqli. Please download for your reference.

Sign in to reply to this post
Did this help? Tips are appreciated...

yogastudents362523

Aagh

Sign in to reply to this post

Ray BorduinWebAssist

I re-uploaded the file as workshops_ray.php so it won't be overwritten by accident.

Sign in to reply to this post
Did this help? Tips are appreciated...

yogastudents362523

Than k you.
I will study it closely and learn.
Many things.

Sign in to reply to this post
loading

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...