Does datatables require the PDO mysqli driver to function?

david-giorgi

We have a legacy Opencart project that we are migrating to custom admin. The Opencart mysqli connection string is working all ok (driver: mysqli). However when we try to use datatables we get : "could not find driver" error (The PHP phpinfo() on AWS/EC2 only lists sqlite and no mysql under PDO drivers). Many thanks for any pointers to resolve.

david-giorgi

..my mistake the title of this question should be: "Does datatables require the PDO mysqli driver to function?" (I could not edit from my account)

allan

Yes, our libraries use PDO, so the MySQL PDO driver is required if you want to use the libraries with MySQL.

You can use phpinfo to find out what PDO drivers you have installed (search for pdo on the generated page).

Allan

david-giorgi

Thanks, Allan If possible please amend the typo in my title so others can find your answer.