We recently purchased PCI Tool Belt and I am trying to run a simple query. Having installed the module and attempted to run the example code, I am getting an odd error that seems to be assuming we are using a MariaDB server – which, of course, we are not. We are using MySQL (which is a requirement of this module). The exact error is:
Runtime error in mm5/5.00/modules/util/ry_toolbelt_miva_9.mvc @ [00000005:000103dc]: .toolslookup.mv: Line 30: MvQUERY: mysql_stmt_prepare: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server versi PCI Net Tool Belt Error: Invalid query: :
mysql_stmt_prepare: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server versi
I can dump out the query on the screen and when I copy and paste it into phpMyAdmin, it works fine. So, there is something up with the module itself. This is the primary reason we purchased this module so this functionality is very important. Can you assist? Is there a configuration file somewhere that erroneously points to a MariaDB as opposed to MySQL?
Runtime error in mm5/5.00/modules/util/ry_toolbelt_miva_9.mvc @ [00000005:000103dc]: .toolslookup.mv: Line 30: MvQUERY: mysql_stmt_prepare: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server versi PCI Net Tool Belt Error: Invalid query: :
mysql_stmt_prepare: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server versi
I can dump out the query on the screen and when I copy and paste it into phpMyAdmin, it works fine. So, there is something up with the module itself. This is the primary reason we purchased this module so this functionality is very important. Can you assist? Is there a configuration file somewhere that erroneously points to a MariaDB as opposed to MySQL?
Comment