server running error

[bidowhab]

i am trying to run LVP server for testing it and such things , anyway i get this error while trying to run the server , so any ideas ? 

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

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


Server Plugins
--------------
 Loading plugin: echo-plugin
  Failed.
 Loading plugin: json-plugin
  Failed.
 Loading plugin: mysql-plugin
  Failed.
 Loading plugin: playgroundjs-plugin
  Failed.
 Loading plugin: zone-manager-plugin
  Failed.
 Loading plugin: streamer
  Failed.
 Loading plugin: sscanf
  Failed.
 Loaded 0 plugins.


Started server on port: 1337, with maxplayers: 50 lanmode is OFF.


Filterscripts
---------------
  Loading filterscript 'cameditor.amx'...

--------------------------------------
 CamEditor by Drebin
--------------------------------------

  Loading filterscript 'textdraweditor.amx'...

--------------------------------------
 Text Draw Editor 1.0RC2 by Zamaroht for SA-MP 0.3 Loaded.
--------------------------------------

  Loaded 2 filterscripts.

Script[gamemodes/lvp.amx]: Run time error 19: "File or function is not found"
Number of vehicle models: 0

[Winnie]

Seems like your plugins are not loaded properly, which is causing this problem. make sure you have all the plugins in the plugins folder, and then make sure to check server.cfg and check weather the plugins are mentioned in the server.cfg or not. if you are running the server on windows make sure to remove .so from each plugin mentioned in .cfg, since .so works for linux not for windows.

I hope it works.

[Yassine]

Hello,

I experienced this bug from 4 month ago

to fix you should download plugin one by one not from here https://github.com/LVPlayground/server-s...er/plugins
not from package and same as v8.dll and log-core.dll

exemple: 

open one plugin it will show u page like that https://github.com/LVPlayground/server-s...plugin.dll
then download and its fine


Yassine

[bidowhab]

your answer helped alot Yassine , but anyway those two plugins still have an issue
"" Loading plugin: mysql-plugin
Failed.
Loading plugin: playgroundjs-plugin
Failed. ""
and can't find this log-core.dll

[Yassine]

your answer helped alot Yassine , but anyway those two plugins still have an issue
"" Loading plugin: mysql-plugin
 Failed.
Loading plugin: playgroundjs-plugin
 Failed. ""
and can't find this log-core.dll

Hello

You need to downlaod those files like you did with plugins

https://github.com/LVPlayground/server-s...bmysql.dll
https://github.com/LVPlayground/server-s...lclient.so
https://github.com/LVPlayground/server-s...ver/v8.dll
https://github.com/LVPlayground/server-s...ibbase.dll
https://github.com/LVPlayground/server-s...atform.dll

and you need to install this too https://www.microsoft.com/en-gb/download...x?id=48145

make sure that you have Windows 8+ else the JS Playground plugin will not load correctly (java functions will not work)

Yassine

[bidowhab]

all plugins are working now , but there is an sql error , sorry for taking so much of your time and thx for helping me so far

[13:19:43] |------------------------------------------------------------------------|
[13:19:43] |      LAS VENTURAS PLAYGROUND - version 33.0.27912 - revision 5154      |
[13:19:43] |------------------------------------------------------------------------|
[13:19:43] 

[13:19:43] Number of vehicle models: 0
[13:19:43] [connection] 127.0.0.1:62805 requests connection cookie.
[13:19:44] [connection] incoming connection: 127.0.0.1:62805 id: 0
[13:19:45] [npc:join] Gunther has joined the server (0:127.0.0.1)
[13:19:47] [INFO][mysql_module.cc4] Connection to 82.192.76.193:43891 succeeded.
[13:19:47] [Database] The connection with the database has been established.
[13:19:48] [MySQL] The connection with the database has been (re-)established.
[13:19:49] [ERROR][mysql_module.cc:191] MySQL (#1142): INSERT, UPDATE command denied to user 'lvp_public'@'45.245.31.116' for table 'settings'
[13:19:49] [INFO][mysql_module.cc:202] MySQL:idQueryFail(4) - rejecting promise
[13:19:49] =========================
[13:19:49] Uncaught promise rejection: Error: MySQL error (1142): INSERT, UPDATE command denied to user 'lvp_public'@'45.245.31.116' for table 'settings'
[13:19:49] =========================
[13:19:49] [ERROR][mysql_module.cc:191] MySQL (#1142): INSERT, UPDATE command denied to user 'lvp_public'@'45.245.31.116' for table 'settings'
[13:19:49] [INFO][mysql_module.cc:202] MySQL:idQueryFail(5) - rejecting promise
[13:19:49] =========================
[13:19:49] Uncaught promise rejection: Error: MySQL error (1142): INSERT, UPDATE command denied to user 'lvp_public'@'45.245.31.116' for table 'settings'
[13:19:49] =========================
[13:19:49] [ERROR][mysql_module.cc:191] MySQL (#1142): INSERT, UPDATE command denied to user 'lvp_public'@'45.245.31.116' for table 'settings'
[13:19:49] [INFO][mysql_module.cc:202] MySQL:idQueryFail(6) - rejecting promise
[13:19:49] =========================
[13:19:49] Uncaught promise rejection: Error: MySQL error (1142): INSERT, UPDATE command denied to user 'lvp_public'@'45.245.31.116' for table 'settings'
[13:19:49] =========================
[13:19:49] [ERROR][mysql_module.cc:191] MySQL (#1142): INSERT, UPDATE command denied to user 'lvp_public'@'45.245.31.116' for table 'settings'
[13:19:49] [INFO][mysql_module.cc:202] MySQL:idQueryFail(7) - rejecting promise
[13:19:49] =========================
[13:19:49] Uncaught promise rejection: Error: MySQL error (1142): INSERT, UPDATE command denied to user 'lvp_public'@'45.245.31.116' for table 'settings'
[13:19:49] =========================
[13:19:49] [ERROR][mysql_module.cc:191] MySQL (#1142): INSERT, UPDATE command denied to user 'lvp_public'@'45.245.31.116' for table 'settings'
[13:19:49] [INFO][mysql_module.cc:202] MySQL:idQueryFail( - rejecting promise
[13:19:49] =========================
[13:19:49] Uncaught promise rejection: Error: MySQL error (1142): INSERT, UPDATE command denied to user 'lvp_public'@'45.245.31.116' for table 'settings'
[13:19:49] =========================
[13:19:54] --- Server Shutting Down.
[13:19:54] [npc:part] Gunther has left the server (0:0)
[13:19:54] Plugin echo.dll got unloaded.
[13:19:54]   [LVP] JSON Reader plugin unloaded.
[13:19:54]   [LVP] MySQL plugin unloaded.

---

or how to make my own sql connection ?

[Yassine]

Hello 

You can create your own database for free using an website db4free.net using 3306 or mysql.db4free.net using port 3307
but i don't think LVP open source their MySQL Map (Dump), so hosting a new database will not change anything.

LVP Public Account is limited due to some guys abuse it i think so you need to pm an management or Developer that can give you MySQL map (.sql) file to host it by uself

Yassine

[Winnie]

Try WAMP for local MySQL database.

[bidowhab]

Try WAMP for local MySQL database.

I am already using xampp , but i just want to know what tables and columns should i make

[George]

[13:19:49] =========================
[13:19:49] Uncaught promise rejection: Error: MySQL error (1142): INSERT, UPDATE command denied to user 'lvp_public'@'45.245.31.116' for table 'settings'
[13:19:49] =========================

When creating MySQL database users, you will have the ability to define their privileges. For example, if you were working with cPanel, when setting privileges, you would this:



As such, based on the provided server log you provided, you need to give your database user access to use the INSERT and UPDATE privileges.

The process to do this depends on how your server is configured. If you have a GUI, you can use it to add the privileges for you. If you're working via CLI, you should look at this: https://www.digitalocean.com/community/t...s-in-mysql