[Plugin] [REL] MySQL Plugin (Google Project)

[Richie©]

Is it possible to fix in the debug messages?

Im trying to debug my GM, but the mysql_log is 400kb and contains mostly of this and its useless.

[19:21:22] [DEBUG] >> cache_get_field_content_float(Connection handle: 1)
[19:21:22] [DEBUG] >> cache_get_field_content_float(Connection handle: 1)
[19:21:22] [DEBUG] >> cache_get_field_content_float(Connection handle: 1)
[19:21:22] [DEBUG] >> cache_get_field_content_float(Connection handle: 1)
[19:21:22] [DEBUG] >> cache_get_field_content_int(Connection handle: 1)

[Pooh7]

Since R18 you can control what will be written in log.

- added function 'mysql_log':
this function replaces 'mysql_debug' (alltough it's still available for
backwards compability). Now you can control which things get logged, i.e. you
can call 'mysql_log(LOG_ERROR | LOG_DEBUG)' to log only errors and debug
informations. The default log setting is 'LOG_ERROR | LOG_WARNING', thus will
log only errors and warnings. Available log types are 'LOG_ERROR',
'LOG_WARNING', 'LOG_DEBUG' and 'LOG_NONE'.

https://code.google.com/p/sa-mp-mysq...ce/detail?r=18

[Richie©]

Yeah, i was using LOG_DEBUG and the log file became a huge mess.
I solved my debug situation with print().
But tbh, printing 'cache_get_field_content_int(Connection handle: 1)' to mysql_log is pretty much useless..

[Lorenc_]

[20:08:05] [WARNING] CMySQLHandler::StoreResult() - No data to store.
[20:08:06] [WARNING] CMySQLHandler::StoreResult() - No data to store.
[20:08:06] [WARNING] CMySQLHandler::StoreResult() - No data to store.
[20:08:07] [WARNING] CMySQLHandler::StoreResult() - No data to store.
[20:08:11] [WARNING] CMySQLHandler::StoreResult() - No data to store.
[20:08:15] [WARNING] CMySQLHandler::StoreResult() - No data to store.
[20:08:17] [WARNING] CMySQLHandler::StoreResult() - No data to store.
[20:08:20] [WARNING] CMySQLHandler::StoreResult() - No data to store.
[20:08:23] [WARNING] CMySQLHandler::StoreResult() - No data to store.
[20:08:24] [WARNING] CMySQLHandler::StoreResult() - No data to store.

What code/query do I need to have this emit?

[RealCop228]

Originally Posted by Lorenc_

[20:08:05] [WARNING] CMySQLHandler::StoreResult() - No data to store.
[20:08:06] [WARNING] CMySQLHandler::StoreResult() - No data to store.
[20:08:06] [WARNING] CMySQLHandler::StoreResult() - No data to store.
[20:08:07] [WARNING] CMySQLHandler::StoreResult() - No data to store.
[20:08:11] [WARNING] CMySQLHandler::StoreResult() - No data to store.
[20:08:15] [WARNING] CMySQLHandler::StoreResult() - No data to store.
[20:08:17] [WARNING] CMySQLHandler::StoreResult() - No data to store.
[20:08:20] [WARNING] CMySQLHandler::StoreResult() - No data to store.
[20:08:23] [WARNING] CMySQLHandler::StoreResult() - No data to store.
[20:08:24] [WARNING] CMySQLHandler::StoreResult() - No data to store.

What code/query do I need to have this emit?

Are you asking for an example of when those warnings may appear?

If so, you're looking for things like an UPDATE or an INSERT query. Those don't return anything for mysql_store_result().