HELP Please server cant run with Mysql - 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: HELP Please server cant run with Mysql (/showthread.php?tid=632902)

---

HELP Please server cant run with Mysql - Winners2005 - 21.04.2017

----------------------------------------------------------

Server Log :
----------------------



----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, ©2005-2015 SA-MP Team

[19:03:00] password = "" (string)
[19:03:00]
[19:03:00] Server Plugins
[19:03:00] --------------
[19:03:00] Loading plugin: crashdetect.so
[19:03:00] CrashDetect v4.13.1 is OK.
[19:03:00] Loaded.
[19:03:00] Loading plugin: streamer.so
[19:03:00]

*** Streamer Plugin v2.6.1 by Incognito loaded ***

[19:03:00] Loaded.
[19:03:00] Loading plugin: mysql.so
[19:03:00]

> MySQL plugin R5 successfully loaded.

[19:03:00] Loaded.
[19:03:00] Loading plugin: LIFE-CMD.so
[19:03:00] *================================================= ===*
[19:03:00] * *
[19:03:00] * LIFE:CMD - Loaded *
[19:03:00] * *
[19:03:00] * Version: v2.0 *
[19:03:00] * *
[19:03:00] * ©2013 Kazon *
[19:03:00] * *
[19:03:00] *================================================= ===*

[19:03:00] Loaded.
[19:03:00] Loading plugin: gvar.so
[19:03:00]

*** GVar Plugin v1.3 by Incognito loaded ***

[19:03:00] Loaded.
[19:03:00] Loading plugin: whirlpool.so
[19:03:00]
[19:03:00] ==================
[19:03:00]
[19:03:00] Whirlpool loaded
[19:03:00]
[19:03:00] ==================
[19:03:00]
[19:03:00] Loaded.
[19:03:00] Loading plugin: sscanf.so
[19:03:00]

[19:03:00] ===============================

[19:03:00] sscanf plugin loaded.

[19:03:00] Version: 2.8.1

[19:03:00] © 2012 Alex "******" Cole

[19:03:00] ===============================

[19:03:00] Loaded.
[19:03:00] Loaded 7 plugins.

[19:03:00]
[19:03:00] Filterscripts
[19:03:00] ---------------
[19:03:00] Loading filterscript 'UltraHost.amx'...
[19:03:01] Loading filterscript 'name.amx'...
[19:03:02] Loaded 2 filterscripts.

[19:03:02]
[19:03:02]
[19:03:02]
[19:03:02] =======================================
[19:03:02] | |
[19:03:02] | YSI version 3.09.0684 |
[19:03:02] | By Alex "******" Cole |
[19:03:02] | |
[19:03:02] =======================================
[19:03:02]
[19:03:02]
[19:03:02]
[19:03:03] [MYSQL]:first Connection to `DATABASE` succesful! || 1
[19:03:03] - 32 Forbidden Names Loaded
[19:03:03] - 27 Forbidden Tags Loaded
[19:03:03] - 29 Forbidden Words Loaded
[19:03:03] Loaded 3 vehicles from: vehicles/trains.txt
[19:03:03] Loaded 15 vehicles from: vehicles/lv_law.txt
[19:03:03] Loaded 255 vehicles from: vehicles/lv_gen.txt
[19:03:03] Loaded 38 vehicles from: vehicles/sf_law.txt
[19:03:03] Loaded 346 vehicles from: vehicles/sf_gen.txt
[19:03:03] Loaded 24 vehicles from: vehicles/ls_law.txt
[19:03:03] Loaded 96 vehicles from: vehicles/ls_gen_inner.txt
[19:03:03] Loaded 389 vehicles from: vehicles/ls_gen_outer.txt
[19:03:03] Total vehicles from files: [ 1166 ]
[19:03:03] The server started up at 19:03:03 on 21/04/2017
[19:03:03] The server started up at 1492801383 epoch time
[19:03:03] Number of vehicle models: 169
[19:03:03] errorid: 1146 | error: Table 'port_2528.accounts' doesn't exist | resultid: 22 | extraid: 0 | callback: OnQueryFinish | query: UPDATE `accounts` SET `LoggedIn` = '0' WHERE `LoggedIn` = '1'
[19:03:03] errorid: 1146 | error: Table 'port_2528.houses' doesn't exist | resultid: 2 | extraid: 0 | callback: OnQueryFinish | query: SELECT * FROM `houses`
[19:04:38] [connection] 105.159.231.236:12634 requests connection cookie.
[19:04:39] [connection] incoming connection: 105.159.231.236:12634 id: 0
[19:04:39] [join] The_AGENT has joined the server (0:105.159.231.236)
[19:04:39] errorid: 1146 | error: Table 'port_2528.accounts' doesn't exist | resultid: 9 | extraid: 0 | callback: OnQueryFinish | query: SELECT * FROM `accounts` WHERE `Name` = 'The_AGENT'
[19:04:39] errorid: 1146 | error: Table 'port_2528.achievements' doesn't exist | resultid: 5 | extraid: 0 | callback: OnQueryFinish | query: SELECT * FROM `achievements` WHERE Name = 'The_AGENT' LIMIT 1
[19:04:39] errorid: 1146 | error: Table 'port_2528.personalvehicles' doesn't exist | resultid: 8 | extraid: 0 | callback: OnQueryFinish | query: SELECT * FROM `personalvehicles` WHERE `Owner` = 'The_AGENT'
[19:04:39] errorid: 1146 | error: Table 'port_2528.online' doesn't exist | resultid: 22 | extraid: 0 | callback: OnQueryFinish | query: INSERT INTO `online` SET `Online` = `Online`,`id` = '0'
[19:04:39] errorid: 1146 | error: Table 'port_2528.aka' doesn't exist | resultid: 24 | extraid: 0 | callback: OnQueryFinish | query: SELECT `Names` FROM `aka` WHERE `IP` = '105.159.231.236'
[19:04:39] errorid: 1146 | error: Table 'port_2528.banlist' doesn't exist | resultid: 3 | extraid: 0 | callback: OnQueryFinish | query: SELECT * FROM `banlist` WHERE `IP` = '' OR `Name` = 'The_AGENT'

---

Re: HELP Please server cant run with Mysql - Luis- - 21.04.2017

Here's a tip, don't use xSF's gamemode, it's very un-optimised.

---

Re: HELP Please server cant run with Mysql - Winners2005 - 21.04.2017

So whats the best gamemode Like xSF ?

---

Re: HELP Please server cant run with Mysql - Luis- - 21.04.2017

I couldn't tell you, you're free to use it, I just think it's badly coded.

---

Re: HELP Please server cant run with Mysql - [G]am3r - 21.04.2017

Searching here would be great.

---

Re: HELP Please server cant run with Mysql - Winners2005 - 21.04.2017

Sir i know all section here i want just someone help me and thank you for your notice

---

Re: HELP Please server cant run with Mysql - [G]am3r - 21.04.2017

The scripts are bad, so better find new one. Just wanna tell you that.

---

Re: HELP Please server cant run with Mysql - Winners2005 - 21.04.2017

Like What ? tell me the best Script if you know !

---

Re: HELP Please server cant run with Mysql - Sew_Sumi - 21.04.2017

Grand Larceny is pretty good.




Seriously though, look at some of them. One that I had stick out was https://sampforum.blast.hk/showthread.php?tid=34618

---

Re: HELP Please server cant run with Mysql - Winners2005 - 21.04.2017

Freeroam Not RP if RP/Freeroam nice

---