Ultimate SEO Urls

[BatteryTrader]

Hello

Using Utlimate SEO Urls 3.0.8
pheonix cart 1.1.0.2
PHP8.3
Mysql

Want to use MYSQL for the cache

I get an PHP warning / error

Code: Select all

 Got error 'PHP message: PHP Warning:  Undefined global variable $db in /home/SERVER/domains/DOMAIN.com/public_html/includes/apps/ultimate_seo_urls/cache_system/mysql.php on line 90; PHP message: PHP Fatal error:  Uncaught Error: Call to a member function escape() on null in /home/SERVER/domains/DOMAIN.com/public_html/includes/apps/ultimate_seo_urls/cache_system/mysql.php:90\nStack trace:\n#0 /home/SERVER/domains/DOMAIN.com/public_html/includes/apps/ultimate_seo_urls/main/usu_main.php(61): Mysql_Cache_Module->store()\n#1 [internal function]: usu_Main->__destruct()\n#2 {main}\n  thrown in /home/SERVER/domains/DOMAIN.com/public_html/includes/apps/ultimate_seo_urls/cache_system/mysql.php on line 90'

Line 90 reads

Code: Select all

          $replacements = [ $GLOBALS['db']->escape( self::$cache_name ), $GLOBALS['db']->escape( $rawdata ), date( "Y-m-d H:i:s" ) ];

So I assume I need to define [ $GLOBALS['db'], it does appear to be working, but the site is busy and logs are building.

If anyone can tell me how to go about it, played with it but I am not a coder, just stumbling through.

I have tried File and SQLlite, both work, but I have a lot of products on there and MYSQL will be better I think.

Thank you.

[BrockleyJohn]

Failed to reproduce this with SEO Urls 3.0.8 on 1.1.0.3 on php 8.3.23 and MariaDB 10.6.18

I suspect the issue lies elsewhere