[Plugin] [REL] MySQL Plugin (Now on github!)

Thank you, I understand now.

Sometimes when I close my gamemode ( exit in console ) crashdetect prints me this:
Код:
server_log.txt

[27/09/2013 15:38:42] plugin.mysql: Unloading plugin...
[27/09/2013 15:38:42] [debug] Server crashed due to an unknown error
[27/09/2013 15:38:42] [debug] Native backtrace:
[27/09/2013 15:38:42] [debug] #0 6d99ccb6 in ?? () from C:\Users\UserName\Desktop\Mode\!!Server\plugins\mysql.DLL
[27/09/2013 15:38:42] [debug] #1 6d99d9ff in ?? () from C:\Users\UserName\Desktop\Mode\!!Server\plugins\mysql.DLL
[27/09/2013 15:38:42] [debug] #2 6d9aef39 in ?? () from C:\Users\UserName\Desktop\Mode\!!Server\plugins\mysql.DLL
[27/09/2013 15:38:42] [debug] #3 004690eb in ?? () from C:\Users\UserName\Desktop\Mode\!!Server\samp-server.exe
[27/09/2013 15:38:42] [debug] #4 004888d6 in ?? () from C:\Users\UserName\Desktop\Mode\!!Server\samp-server.exe
Reply

Quote:
Originally Posted by saamp
Посмотреть сообщение
Thank you, I understand now.

Sometimes when I close my gamemode ( exit in console ) crashdetect prints me this:
Код:
server_log.txt

[27/09/2013 15:38:42] plugin.mysql: Unloading plugin...
[27/09/2013 15:38:42] [debug] Server crashed due to an unknown error
[27/09/2013 15:38:42] [debug] Native backtrace:
[27/09/2013 15:38:42] [debug] #0 6d99ccb6 in ?? () from C:\Users\UserName\Desktop\Mode\!!Server\plugins\mysql.DLL
[27/09/2013 15:38:42] [debug] #1 6d99d9ff in ?? () from C:\Users\UserName\Desktop\Mode\!!Server\plugins\mysql.DLL
[27/09/2013 15:38:42] [debug] #2 6d9aef39 in ?? () from C:\Users\UserName\Desktop\Mode\!!Server\plugins\mysql.DLL
[27/09/2013 15:38:42] [debug] #3 004690eb in ?? () from C:\Users\UserName\Desktop\Mode\!!Server\samp-server.exe
[27/09/2013 15:38:42] [debug] #4 004888d6 in ?? () from C:\Users\UserName\Desktop\Mode\!!Server\samp-server.exe
http://www.solidfiles.com/d/d66861dbeb/
You can try this version, it has two bug fixes in it, one bug fix could be related to that crash.
Reply

cache_get_row( row, idx, dest[] [, connectionHandle = 1] ) what is the row? i am making now some of the save system for my gamemode.
I want to save my things to multiple tables and i dont know how. someone can explain to me?
Reply

Anyone help me?
Reply

You never asked for help.
Reply

Quote:
Originally Posted by NSA
Посмотреть сообщение
Hi guys.
How to fix it?

symbol lookup error: plugins/mysql.so: undefined symbol: compress
Quote:
Originally Posted by NSA
Посмотреть сообщение
Anyone help me?
Quote:
Originally Posted by Luis-
Посмотреть сообщение
You never asked for help.
He did

However, I don't give support to versions older than R7. Maybe someone else is willing to help you.
Reply

Ah. My mistake.
Reply

R34 is released.
Changes:
Код:
- fixed bug where orm_update generated wrong queries
- fixed bug where queries sometimes lost connection to a remote database
- added natives "orm_load" and "orm_save" for even easier data management
- added additional (optional) parameter "use_cache" for native "mysql_query" to determine if the cache will be used or not
- added native "mysql_unprocessed_queries" to retrieve the amount of unprocessed queries
- improved backward compatibility a bit
There is also a new wiki page for this plugin available here.

As always, have fun with it and please report bugs and possible suggestions.
Reply

Quote:
Originally Posted by maddinat0r
Посмотреть сообщение
R34 is released.
Changes:
Код:
- fixed bug where orm_update generated wrong queries
- fixed bug where queries sometimes lost connection to a remote database
- added natives "orm_load" and "orm_save" for even easier data management
- added additional (optional) parameter "use_cache" for native "mysql_query" to determine if the cache will be used or not
- added native "mysql_unprocessed_queries" to retrieve the amount of unprocessed queries
- improved backward compatibility a bit
There is also a new wiki page for this plugin available here.

As always, have fun with it and please report bugs and possible suggestions.
Great! Finally, wiki was updated for the latest versions of MySQL.
Reply

Nice release.
Reply

Quote:
Originally Posted by maddinat0r
Посмотреть сообщение
R34 is released.
Changes:
Код:
- fixed bug where orm_update generated wrong queries
- fixed bug where queries sometimes lost connection to a remote database
- added natives "orm_load" and "orm_save" for even easier data management
- added additional (optional) parameter "use_cache" for native "mysql_query" to determine if the cache will be used or not
- added native "mysql_unprocessed_queries" to retrieve the amount of unprocessed queries
- improved backward compatibility a bit
There is also a new wiki page for this plugin available here.

As always, have fun with it and please report bugs and possible suggestions.
I want to marry you so badly!
Reply

Quote:
Originally Posted by Sublime
Посмотреть сообщение
I want to marry you so badly!
what the hell are you talking about lol?


On-topic: Great work as usual !
Reply

New idea: Add support to pass arrays in mysql_tquery(). ("a")
Reply

A little bit unrelated question - what's the diffrence between (cell) and static_cast<cell> typecasting? Is it simply changing syntax to C++, or it has some additional consequences?
Reply

Quote:
Originally Posted by Misiur
Посмотреть сообщение
A little bit unrelated question - what's the diffrence between (cell) and static_cast<cell> typecasting? Is it simply changing syntax to C++, or it has some additional consequences?
http://www.cplusplus.com/doc/tutorial/typecasting/
Reply

On R34 we can use "SELECT" type query without cache? If we can i need to use "mysql_store" and "mysql_free_result" for "SELECT" query?
Reply

Failed (plugins/mysql.so: symbol __cxa_pure_virtual, version libmysqlclient_16 not defined in file libmysqlclient_r.so.16 with link time reference)


Why I get that error?
Reply

Quote:
Originally Posted by Kyra
Посмотреть сообщение
On R34 we can use "SELECT" type query without cache? If we can i need to use "mysql_store" and "mysql_free_result" for "SELECT" query?
Why don't you want to use the cache?

Quote:
Originally Posted by Sp3cter
Посмотреть сообщение
Failed (plugins/mysql.so: symbol __cxa_pure_virtual, version libmysqlclient_16 not defined in file libmysqlclient_r.so.16 with link time reference)


Why I get that error?
What OS do you use? What is your MySQL server version?
Reply

Quote:
Originally Posted by maddinat0r
Посмотреть сообщение
Why don't you want to use the cache?


What OS do you use? What is your MySQL server version?
Ubuntu Linux 12.04.2 / MySQL version 5.5.32
Reply

Quote:
Originally Posted by Sp3cter
Посмотреть сообщение
Ubuntu Linux 12.04.2 / MySQL version 5.5.32
Huh, didn't wanted to ask about the server version, I need the MySQL client version. However, I assume that your MySQL server is running on the same machine as your SA-MP server.
The default mysql.so is for MySQL client version 5.1.x.The Linux download includes two .so's: mysql.so (for 5.1) and mysql_5.5.so (obviously for 5.5).
tl;dr: use the mysql_5.5.so
Reply


Forum Jump:


Users browsing this thread: 15 Guest(s)