Error In SQL Code

[g33kcub]

I think the error is in CALL`2 on the CCP. When trying to add a sub file to any +help/+shelp/+news I get the following error.

-==- ERROR: #-1 SQL ERROR: 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 '' at line 1

[FranckKnight]

I'm getting the same error today, or similar.

I'm using a SQLLite3 setup, if that's the problem, since I couldn't get MariaDB to properly install (why are the 'simple' instructions not working, seriously).

During the installation of Core 05 - Database ID Manager, I get this error :
-=<HELP>=- ERROR: #-1 SQL ERROR: near "CALL": syntax error

With Debug on, I can trace it to this :
sql(CALL %0(%2,%3),switch(%1,0,%b,2,|,3,chr(176),%b),switch(%1,0,%b,2,^,3,chr(177),%b)) => #-1 SQL ERROR: near "CALL": syntax error

Both +shelp at the end causes the same error :

&HLP`ID [u(cobj,id)]=Every character in the game has an ID used for SQL database purposes. This is relevant for any Wiki code! To see IDs:%R%R[ansi(h,+id <name>)] - Show the ID of a given character. Defaults to yourself if no name is provided.
+help/add Character/+id=[u(cobj,id)]/HLP`ID

&SHLP`ID [u(cobj,id)]=It is VERY IMPORTANT that any re-created characters be IMMEDIATELY re-assigned their old IDs before they participate in any logged scenes or start to fill out information.%R%R[ansi(hc,ID Management)]%R[align(5 [sub(u(width,%#),6)],,[ansi(h,+id/search <name>)] - Searches for all characters with a name like <name> and displays old database records.%R[ansi(h,+id/merge <character>=<id>)] - Assigns the old <id> to the <character> specified.)]
+shelp/add Character/+id=[u(cobj,id)]/SHLP`ID

[FranckKnight]

Well I figured out that SQLite doesn't work, but now I'm seeing a bunch of other error messages instead. Might not be related to SQL, so going to put that in a new thread.

I fixed my issue by using MariaDB, and making sure I had a libevent installed, which was part of my problem it seems, where PennMush would not detect mysql_config files.