Farcry 7.2.12 on lucee 5 on windows 10 won't install

#1

I tried installing farcry and I go loads of SQL errors. This is the first series of errors I got under chelsea boots:
Deployed DEPLOY-mysql_ruleXMLFeed.sql
ERROR: INSERT-container-1.sql - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘INSERT INTO container (bShared,displayMethod,mirrorID,objectID,label) VALUES (0,’ at line 2
I got an entir4er page of errors like that.
I’m using XAMPP to run mysql, and i’m running Lucee 5.3.3.46-SNAPSHOT
Any assistance? Thanks

1 Like
#2

When you set up a MySQL datasource you might need to enable the “multiple queries” (checkbox) in the datasource options in the Lucee Admin. The MySQL driver restricts it to single statements otherwise, which causes the DB restore to fail.

1 Like
#3

thank you I’ll check it out tomorrow🐜

#4

Worked like a charm! Thanks

1 Like