Common issues

[thelindat]

Unable to establish a connection

This is an incredibly generic error, but generally speaking you should

• ensure you have configured your mysql_connection_string correctly
• ensure your database exists and is running
• try using an alternate connection string or removing reserved characters ; , / ? : @ & = + $ #

No such export in resource oxmysql

The export you have called does not exist. This could be for a few reasons,

• oxmysql has not yet started when you called the export
• you are attempting to run oxmysql without building the source code or using a release build
• you have simply called an invalid export

Download the latest release and ensure it is the first resource in your resource start order.

DECIMAL types are returned as a string

Enable the decimalNumbers setting to change this behaviour; however this may result in loss of precision.

Multiple statements cannot be executed in a single query

This option is disabled to prevent easy SQL injection (see https://forum.cfx.re/t/database-tables-are-deleted/4764756) due to poor practices (especially string concatenation and lack of sanitisation).

You can enable the option with multipleStatements, but we strongly suggest you don't.