SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Plugin Development

Reply
 
Thread Tools Display Modes
Old 19/02/2017, 11:16 AM   #6061
Kar
Banned
 
Join Date: May 2010
Location: Black Asylum
Posts: 2,938
Reputation: 538
Default Re: [REL] MySQL Plugin (Now on github!)

I have a new laptop, it's pretty new.. (kaby lake).

I installed the required packages. MySQL still fails to load on windows. R41-2.

I installed the C connector, and OpenSSL 1.0.2k 32 and 64 bit side to side (since the latest C connector uses 1.0.2 by default now ).

Still not loading
Kar is offline   Reply With Quote
Old 19/02/2017, 03:38 PM   #6062
Jeroen52
Gangsta
 
Jeroen52's Avatar
 
Join Date: Oct 2008
Location: The Netherlands
Posts: 882
Reputation: 74
Default Re: [REL] MySQL Plugin (Now on github!)

Quote:
Originally Posted by Kar View Post
I have a new laptop, it's pretty new.. (kaby lake).

I installed the required packages. MySQL still fails to load on windows. R41-2.

I installed the C connector, and OpenSSL 1.0.2k 32 and 64 bit side to side (since the latest C connector uses 1.0.2 by default now ).

Still not loading
Could you give more information if you are building the plugin from source? And which operating system (and if Linux, which distro and architecture) you are using?
__________________
Jeroen52 is offline   Reply With Quote
Old 19/02/2017, 10:46 PM   #6063
Kar
Banned
 
Join Date: May 2010
Location: Black Asylum
Posts: 2,938
Reputation: 538
Default

Windows 10 x64, I haven't tried building yet. My Visual Studio is still getting ready. I'm going to try when it's done.

log-core.so and mysql.so (32 bit) (dynamically linked) compiled on Ubuntu Trusty 14.04.

https://www.mediafire.com/?6pizjdu8n...movhmp7x17i60l

Last edited by Kar; 22/02/2017 at 12:18 PM.
Kar is offline   Reply With Quote
Old 21/02/2017, 05:15 PM   #6064
vasyok28
Little Clucker
 
Join Date: Jan 2016
Posts: 14
Reputation: 0
Default Re: [REL] MySQL Plugin (Now on github!)

Hello! After omission of MySQL is disconnected from the server, and restores the connection is not re-encoding.
What solution ?
vasyok28 is offline   Reply With Quote
Old 22/02/2017, 12:55 PM   #6065
Wahyu33
Big Clucker
 
Join Date: Dec 2016
Location: Indonesia, Bogor, Jawabarat
Posts: 50
Reputation: 1
Default Re: [REL] MySQL Plugin (Now on github!)

mysql_escape_string why? how to fix?
Wahyu33 is offline   Reply With Quote
Old 26/02/2017, 10:02 PM   #6066
vannesenn
Gangsta
 
vannesenn's Avatar
 
Join Date: Feb 2011
Posts: 607
Reputation: 15
Default Re: [REL] MySQL Plugin (Now on github!)

Quote:
Originally Posted by Wahyu33 View Post
mysql_escape_string why? how to fix?
mysql_format and operator %e
vannesenn is offline   Reply With Quote
Old 07/03/2017, 06:12 PM   #6067
Kar
Banned
 
Join Date: May 2010
Location: Black Asylum
Posts: 2,938
Reputation: 538
Default Re: [REL] MySQL Plugin (Now on github!)

I feel like the next version should be tested with 5.6 and 5.7
Kar is offline   Reply With Quote
Old 07/03/2017, 09:44 PM   #6068
ISmokezU
Gangsta
 
Join Date: Aug 2016
Posts: 542
Reputation: 75
Default Re: [REL] MySQL Plugin (Now on github!)

Quote:
Originally Posted by vasyok28 View Post
Hello! After omission of MySQL is disconnected from the server, and restores the connection is not re-encoding.
What solution ?
It provides a good logging system (IMO) Check it, and post it.
ISmokezU is offline   Reply With Quote
Old 16/03/2017, 11:20 AM   #6069
Cypress
Gangsta
 
Cypress's Avatar
 
Join Date: Dec 2009
Location: Germany
Posts: 937
Reputation: 127
Default Re: [REL] MySQL Plugin (Now on github!)



pawn Code:
"SELECT `password`, `password_salt`, UNIX_TIMESTAMP(`last_active`) FROM `players` WHERE `username` = '%e' LIMIT 1"

pawn Code:
[12:10:16] [plugins/mysql] cache_get_value_name: field 'last_active' not found

Don't know what's the issue here. Also how would I fetch this data into a variable?

Edit: fixed it.
__________________

Welcome stranger. I like your attitude.

Last edited by Cypress; 16/03/2017 at 01:50 PM.
Cypress is offline   Reply With Quote
Old 25/03/2017, 12:04 PM   #6070
f0Re3t
Little Clucker
 
Join Date: Aug 2015
Posts: 44
Reputation: 7
Default Re: [REL] MySQL Plugin (Now on github!)

hi
I would like more information on working with ORM scenarios
for example, I have a table with the accounts of the players and need to do so you can't register with the same email address
for usual queries it is easy to do, but what about ORM ?
f0Re3t is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
****** Project: Glass int3s0 Everything and Nothing 99 26/02/2013 04:22 PM
MySQL Plugin R5 plugin problem dud Scripting Help 12 05/12/2011 06:28 PM
Strikens Mysql vs BlueG's Mysql plugin PrawkC Scripting Help 4 30/09/2011 10:30 AM
[help][plugin] Can't load mysql plugin mariomako Help Archive 8 16/07/2011 02:37 PM
mysql plugin. loading plugin failed ikkentim Help Archive 2 10/02/2011 02:32 PM


All times are GMT. The time now is 10:23 AM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.