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

Quote:
Originally Posted by Dan..
Посмотреть сообщение
You are the idiots here. I just said he claims something (which is wrong too) without any proof. I was expecting ass-kissers, but not so many. You are free to use my plugin, suck my dick or whatever you want. I don't give a crap about you. It is needless to say that Pain123 used my plugin as a resource, seeing that how much our changelogs are alike.
You didn't just said that. You insulted BlueG's and my coding experience and said how much issues the plugin has. You show no respect against BlueG's and my work, and even against the users. Do you have any reason for this? No, maybe you just envy me or are mad because BlueG stated his plugin as the best MySQL plugin. If you really would think your plugin is the best, you wouldn't even bother about this. You are the scum of this community, destroying the sense of having fun participating in it.
I didn't used your plugin as resource. Seriously, no. I don't bother about your progress, I just sometimes compare the speed between our two plugins, just out of fun and interest. And even then, I don't release the results to tell everyone how good this plugin is and dontknowwhat. Yes, R33 uses now a similar threading model as your plugin, but I don't really looked at your plugin's source on how to implement it. I just did it like this: "the old threading system used a thread-pool, the new one shall use one thread per connection" and then implemented it right away, without using your plugin as reference.
Reply

If you want to use MySQL functions(for example : DISTINCT, Date Add,Date Sub,etc.) can not be used in ORM?


There are three simple operation can only be used ORM?
Reply

Guuuuuys, don't fight there, please. Both plugins are great.
Reply

Quote:
Originally Posted by d711728
View Post
hi Pain123!

If you want to use MySQL functions(for example : DISTINCT, Date Add,Date Sub,etc.) can not be used in ORM?


There are three simple operation can only be used ORM?
You can still use normal queries along with the ORM system. That's why orm_apply_cache is made.
Reply

Quote:
Originally Posted by Dan..
Посмотреть сообщение
I don't want to start a flame war here.
Funny you say that, if you aren't looking for one, then don't post.

You should have known better to refrain posting something which would get people annoyed (as you did call their coding "shit" if you were to put it in such terms).
Reply

I get this:
pawn Code:
[23:01:33]  Loading plugin: mysql.so
[23:01:33]   Failed (plugins/mysql.so: symbol __cxa_pure_virtual, version libmysqlclient_16 not defined in file libmysqlclient_r.so.16 with link time reference)

[23:05:56] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Reply

Quote:
Originally Posted by Richie©
View Post
I get this:
pawn Code:
[23:01:33]  Loading plugin: mysql.so
[23:01:33]   Failed (plugins/mysql.so: symbol __cxa_pure_virtual, version libmysqlclient_16 not defined in file libmysqlclient_r.so.16 with link time reference)

[23:05:56] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
What Linux plugin edition did you used? MySQL 5.1 or MySQL 5.5? What OS do you use (detailed information please)?
Reply

Im using MYSQL 5.1.49-3 on Debian 6.0 32bit. I downloaded the 5.1 (default) version of the plugin.
Reply

Using MySQL 5.5.32 on Centos6 I'm having the following problem:

It loads the plugin on the logs, but in mysql_log.txt file it says: "[ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)"

I check that path and doesn't exist, so I edited my.cnf with "socket=/var/lib/mysql/mysql.sock' and still showing the same error, how could I change the default path of the plugin to check the socket?

Edit: Worked using the static version
Reply

Quote:
Originally Posted by Xabi
View Post
Using MySQL 5.5.32 on Centos6 I'm having the following problem:

It loads the plugin on the logs, but in mysql_log.txt file it says: "[ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)"

I check that path and doesn't exist, so I edited my.cnf with "socket=/var/lib/mysql/mysql.sock' and still showing the same error, how could I change the default path of the plugin to check the socket?

Edit: Worked using the static version
error #2002 occurs when mysql-server is not running or offline.

Issue the following command and then try again.

Code:
service mysqld start
Reply

No problem using r33. Thank's for release.
Reply

How durable ORM?
Because if I build a complete ways of playing it for a while do not want to vary it.
Reply

Quote:

- added native "mysql_query" for unthreaded queries

I thought that unthreaded queries were removed... So now it is possible to use the plugin as in R6?
Reply

Quote:
Originally Posted by d711728
Посмотреть сообщение
Can you please send someone an example orm_apply_cache (ORM id, row) use.

MySQL function you want to use ORM in.

I would set an example in which I need to use mysql functions (such as DISTINCT.) Is presented using the ORM.

I'm still very new to this so he asks.
There is one example in the ORM tutorial in the vehicle script.
Reply

Look at Pain123's signature.. There's a tutorial link.
Reply

I tried the static version now, i get no errors ongamemodeinit, but still getting this:
pawn Код:
[ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Reply

Why does 'mysql_connect' always returns a positive handle with a failed connection? Even 'mysql_errno' doesn't seem to be working.

pawn Код:
//Testing code
printf("%d", mysql_connect(SQL_HOST, SQL_USER, "db1", SQL_PWD)); //Correct db
printf("%d", mysql_errno());
printf("%d", mysql_connect(SQL_HOST, SQL_USER, "123456", SQL_PWD)); //Invalid db
printf("%d", mysql_errno());
printf("%d", mysql_connect(SQL_HOST, SQL_USER, "db2", SQL_PWD)); //Correct db
printf("%d", mysql_errno());
Код:
//Output
1
0
2
0
3
0
Reply

Quote:
Originally Posted by DarkSlyder
Посмотреть сообщение
Why does 'mysql_connect' always returns a positive handle with a failed connection? Even 'mysql_errno' doesn't seem to be working.

pawn Код:
//Testing code
printf("%d", mysql_connect(SQL_HOST, SQL_USER, "db1", SQL_PWD)); //Correct db
printf("%d", mysql_errno());
printf("%d", mysql_connect(SQL_HOST, SQL_USER, "123456", SQL_PWD)); //Invalid db
printf("%d", mysql_errno());
printf("%d", mysql_connect(SQL_HOST, SQL_USER, "db2", SQL_PWD)); //Correct db
printf("%d", mysql_errno());
Код:
//Output
1
0
2
0
3
0
mysql_connect returns the handle id, even if it fails to connect (which would be handled by OnQueryError) the connect function still passes the handle to it. If you put a print in OnQueryError I bet it would pass the proper error number for an invalid DB.
Reply

Where I can get libmysqlclient.so.18?
Reply

Officially R33 is the best revision/release of your all revisions/releases Pain123. Awesome work!
Reply


Forum Jump:


Users browsing this thread: 20 Guest(s)