Php 8.5, Site crashed, Deprecated File

This isn't a Wappler issue I don't think, but on my local Wappler server when I go to any page with a db connection I get this error ... it's a PHP/MySQL project.

{"code":0,"file":"\/Users\/bradlawryk\/Documents\/Kopar\/Dashboards\/2022 Vacation Portal\/dmxConnectLib\/lib\/db\/Connection.php","line":87,"message":"Constant PDO::MYSQL_ATTR_INIT_COMMAND is deprecated since 8.5, use Pdo\\Mysql::ATTR_INIT_COMMAND instead","trace":"#0 \/Users\/bradlawryk\/Documents\/Kopar\/Dashboards\/2022 Vacation Portal\/dmxConnectLib\/lib\/db\/Connection.php(87): exception_error_handler(8192, 'Constant PDO::M...', '\/Users\/bradlawr...', 87)\n#1 \/Users\/bradlawryk\/Documents\/Kopar\/Dashboards\/2022 Vacation Portal\/dmxConnectLib\/modules\/dbconnector.php(12): lib\\db\\Connection->__construct(Object(lib\\App), Object(stdClass), 'Administration')\n#2 \/Users\/bradlawryk\/Documents\/Kopar\/Dashboards\/2022 Vacation Portal\/dmxConnectLib\/lib\/App.php(224): modules\\dbconnector->connect(Object(stdClass), 'Administration', NULL)\n#3 \/Users\/bradlawryk\/Documents\/Kopar\/Dashboards\/2022 Vacation Portal\/dmxConnectLib\/lib\/App.php(164): lib\\App->execSteps(Object(stdClass))\n#4 \/Users\/bradlawryk\/Documents\/Kopar\/Dashboards\/2022 Vacation Portal\/dmxConnectLib\/lib\/App.php(190): lib\\App->exec(Object(stdClass), true)\n#5 \/Users\/bradlawryk\/Documents\/Kopar\/Dashboards\/2022 Vacation Portal\/dmxConnectLib\/lib\/App.php(196): lib\\App->execSteps(Object(stdClass))\n#6 \/Users\/bradlawryk\/Documents\/Kopar\/Dashboards\/2022 Vacation Portal\/dmxConnectLib\/lib\/App.php(164): lib\\App->execSteps(Array)\n#7 \/Users\/bradlawryk\/Documents\/Kopar\/Dashboards\/2022 Vacation Portal\/index.php(6): lib\\App->exec(Object(stdClass), true)\n#8 \/Applications\/Wappler.app\/Contents\/Resources\/app\/Shared\/DMXzone\/dmxAppCreator\/UI\/lib\/htaccess_router.php(205): require_once('\/Users\/bradlawr...')\n#9 {main}"}

Here is the lines in the code that it says are deprecated ....

How do I fix this? What has been deprecated?

Guard it with a constant check:

php

if (defined('PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT')) {
    $pdo_options[PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT] = $sslverify;
}

This issues has been solved some time ago - but you probably don't have the extension files updated.

So you need to force reinstall the extensions - just open the Project Assets Updater from the title bar icon - and choose "Change Channel" - just to force reinstall of the extensions.

we also cleaned up our php database extensions update process so you will get the newest files always next time

Thanks I am back up and running again. :beers:

1 Like

Fixed n Wappler 7.7.9