Printing MySQL error message to conversation

[rpgbl]

Hi guys,

Is there any way to print the MYSQL error message when a query is wrong? So far I noticed I can catch the status of the query when SQL_ERROR is returned but I dont know how to catch the error message sent from MySQL.

Any suggestion please? Thank you.

[Gryphyn]

Have a look at my SQLServer plugin.
I've put full error checking (and logging) into it.
MySQL may have some special API, but the process should be the same.

[rpgbl]

Hi Gryphyn,

Thanks for the reply. I've been using NWNX SQL include by Ingmar Stieger and it's beend working perfectly. The only things that I missed here is catching the error message.

Gryphyn, is it possible to combine your logging system with the NWNX SQL include Im using ?


ps:sorry I dont have much technical experience

[ShaDoOoW]

AFAIK database errors are printed into nwnx_odbc logfile...
_________________
Community Patch / NWNX Patch / NWNX Files / NWNX Connect

[rpgbl]

Ah I suppose you're right, ShaDoOoW. The file xp_mysql.txt logged all the transactions. I will try to get the error msg from here then.

Hm, so how to read a text file and put it to the conversation ? ^v^

[Paul R]

Depending on the size use something like FileReadAll() from the system plugin (Linux) or the Windows equivalent, parse it and put it in a custom token.

Better still write a script to extract it and put it in a table, apart from you not being able to read it if there is a larger problem with the DB
_________________
oops

[Gryphyn]