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

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.

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

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

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"))); ?>

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

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.

Aagh

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

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