Hi. Moved my J4 Joomla site from PHP 7.4 (no issues) to PHP 8.2

On calling a page that uses Ari Data Table, i see this message and no data is displayed:

"0 Non-static method AriADODBLite::isAllowedDbType() cannot be called statically"

Any ideas on how to correct this and display my data tables?

Thank you.

Hello,

Update the extension to v. 2.0.3 please.

Regards,
ARI Soft

Ok. I installed 2.0.3 Thank your for having the extension show up in the Update : Extensions panel. Nice addition.

So after the update, any Ari Data Table that I access results in this message:

0 mysqli_fetch_array(): Argument #1 ($result) must be of type mysqli_result, null given

No data content is shown.

Interestingly. I have this site available on PHP 7.4 and 8.2 Only having these problems on PHP 8.2. 7.4 is not throwing this error.

Thanks.

Could you send screenshot with configuration of "SQL" parameters section? You can send it by email (DB user/password can be removed).

Regards,
ARI Soft

Responded with an email and screen capture to the info@ email address to the left.
Thank you.

Some additional information:

Since the same site/ same datatables work on PHP 7.4 but not on PHP 8.2, and I can easily switch between 7.4 and 8.2, I wanted to make sure php module config is identical between the two versions. It is.

MySQLi and MySQLnd modules are both loaded according to phpinfo(). The only difference that I could see is that JSON seems to be built into the PHP core of 8.2 and is not a separate module.

I searched for "mysqli_fetch_array(): Argument #1 ($result) must be of type mysqli_result, null given"

Got this from Stack Overflow. Not sure if it is relevant:

"You have to add the result type to mysqli_fetch_array.

See the syntax: mysqli_fetch_array(result,resulttype);

while($row = mysqli_fetch_array($run,MYSQLI_ASSOC))"

Really am scratching my head on this one.