MySQL Error - Printable Version

MySQL Error - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL Error (/showthread.php?tid=616733)

MySQL Error - Immortal99 - 09.09.2016

I am getting this error when i launch my server on windows:

PHP код:



[debug] Run time error 19: "File or function is not found"

[debug]  mysql_real_escape_string

[debug]  mysql_query

[debug]  mysql_store_result

[debug]  mysql_num_rows

[debug]  mysql_fetch_field

[debug]  mysql_free_result

[debug]  mysql_insert_id

[debug]  mysql_fetch_row

[debug]  mysql_init

[debug]  mysql_connect

  Loaded 6 filterscripts.


[debug] Run time error 19: "File or function is not found"

[debug]  mysql_real_escape_string

[debug]  mysql_query

[debug]  mysql_store_result

[debug]  mysql_num_rows

[debug]  mysql_fetch_field

[debug]  mysql_free_result

[debug]  mysql_insert_id

[debug]  mysql_fetch_row

[debug]  mysql_init

[debug]  mysql_connect

Help me fix this

Re: MySQL Error - SickAttack - 09.09.2016

File or function is not found means that you are trying to use a nonexistent function in a plugin. Getting the correct include and plugin version will fix it.

Re: MySQL Error - Immortal99 - 09.09.2016

I have all the correct plugins and includes but whenever i try the original plugin of MySQL.dll it says Windows not compatible with this version etc.

But i am Running Windows 10, Quad Core -_-

Re: MySQL Error - SickAttack - 09.09.2016

If you had the correct version, it wouldn't give you those errors.

https://github.com/pBlueG/SA-MP-MySQL/releases

Download the version your script uses again, and replace the files you got. Remember to add libmysql.dll to your server's root directory.

Re: MySQL Error - Immortal99 - 09.09.2016

How do i check what version does the script uses?

Код:

Sorry For My Stupidness

Re: MySQL Error - SickAttack - 09.09.2016

Based of the functions it uses, or open the include file (pawno/include/a_mysql.inc) and see what version it is. If the gamemode compiles with the include you're using, then it's most likely the correct include. Hence, correct MySQL version.

Re: MySQL Error - Immortal99 - 09.09.2016

It compiles with any version of MySQL but when i run it, just doesn't work

Re: MySQL Error - Immortal99 - 09.09.2016

Now I get this error:
[MySQL] Error (0): Failed to connect. Access denied for user 'root'@'localhost' (using password: YES).
Failed to connect. Access denied for user 'root'@'localhost' (using password: YES).

And Another:
[MySQL] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).

Re: MySQL Error - Younes44 - 09.09.2016

Make sure you type the right DB Detalis :C
try to use this instead of localhost
172.0.0.1

Re: MySQL Error - JordanZaundd - 09.09.2016

If you're using BlueG's MySQL R40, the update switched the database and password parameters around, so you may be using your database as your password by accident.

PHP код:



mysql_connect("127.0.0.1", "root", "mydatabase", "mypass");

is now

PHP код:



mysql_connect("127.0.0.1", "root", "mypass", "mydatabase");