Vice City: Multiplayer

VC:MP Discussion => Bugs and Crashes => Support => Closed Bug Reports => Topic started by: jayant on Apr 12, 2015, 03:18 PM

Title: SQLite functions unavailable in RC2
Post by: jayant on Apr 12, 2015, 03:18 PM
After the update my working scripts arent't working..Like ConnectSQL does not exist etc..Everything was working previously before the RC2 update.
Title: Re: SQLite functions unavailable in RC2
Post by: Mariu22S on Apr 12, 2015, 03:20 PM
jayant you have this error ?

AN ERROR HAS OCCURED [the index 'ConnectSQL' does not exist]

Also I have such a thing
 
Title: Re: SQLite functions unavailable in RC2
Post by: jayant on Apr 12, 2015, 03:24 PM
@Mariu22S  - Yes many people have this error I think..Let us wait for Stormeus to reply on this.
Title: Re: SQLite functions unavailable in RC2
Post by: Miracle on Apr 12, 2015, 03:36 PM
Quote from: jayant on Apr 12, 2015, 03:24 PM@Mariu22S  - Yes many people have this error I think..Let us wait for Stormeus to reply on this.
Please Update Server RC2. :)
Title: Re: SQLite functions unavailable in RC2
Post by: Honey on Apr 12, 2015, 03:48 PM
Quote from: jayant on Apr 12, 2015, 03:18 PMAfter the update my working scripts arent't working..Like ConnectSQL does not exist etc..Everything was working previously before the RC2 update.
Quote from: Mariu22S on Apr 12, 2015, 03:20 PMjayant you have this error ?

AN ERROR HAS OCCURED [the index 'ConnectSQL' does not exist]

Also I have such a thing

Umm, Just download the server plugin packages, Modules / Plugins in that package are working for me ! in Windows
Title: Re: SQLite functions unavailable in RC2
Post by: Mariu22S on Apr 12, 2015, 03:55 PM
Does not work on Linux ;/
Title: Re: SQLite functions unavailable in RC2
Post by: DizzasTeR on Apr 12, 2015, 04:06 PM
Quote from: jayant on Apr 12, 2015, 03:24 PM@Mariu22S  - Yes many people have this error I think..Let us wait for Stormeus to reply on this.

If you have read my first post on this topic you will notice i had the same issue, it can be fixed by downloading the new updated server.exe or linux version, according to your OS.
Title: Re: SQLite functions unavailable in RC2
Post by: Mariu22S on Apr 12, 2015, 04:20 PM
It's still gives an error

Stromeus cen you fix it  , i can;t run my server. Error on screen.Can connect to detabase.

(https://forum.vc-mp.org/proxy.php?request=http%3A%2F%2Fi.imgur.com%2F8sgGxa5.png&hash=2275c4a8b218da8e292be4bdb70d6d9aa5285633)
Title: Sqlite Plugin Problem
Post by: Mariu22S on Apr 12, 2015, 07:59 PM
Hello.

Stromeus cen you fix it  , i can;t run my server. Error on screen.Can connect to detabase.

Error is only on Linux

(https://forum.vc-mp.org/proxy.php?request=http%3A%2F%2Fi.imgur.com%2F8sgGxa5.png&hash=2275c4a8b218da8e292be4bdb70d6d9aa5285633)
Title: Re: Sqlite Plugin Problem
Post by: . on Apr 12, 2015, 09:03 PM
The plugin seems to register (https://bitbucket.org/stormeus/0.4-sqlite/src/a4305328c110fbfb06aa933d91b45510064a4f09/04SQLite/Functions.c?at=master#cl-337) this function :-\ Try prefixing that with :: so that should be ::ConnectSQL(...); And see if that does anything. (I don't know how you're using that function so I'm just guessing a common mistake)
Title: Re: Sqlite Plugin Problem
Post by: Stormeus on Apr 12, 2015, 09:07 PM
What's your distribution (including version)? Is it up to date?
Title: Re: SQLite functions unavailable in RC2
Post by: rObInX on Apr 12, 2015, 10:23 PM
Do you even load the module?
Title: Re: SQLite functions unavailable in RC2
Post by: Stormeus on Apr 13, 2015, 12:28 AM
Quote from: rObInX on Apr 12, 2015, 10:23 PMDo you even load the module?

Yeah, it shows up there. I'll look into it ASAP.
Title: Re: SQLite functions unavailable in RC2
Post by: Drake on Apr 13, 2015, 05:03 AM
Well I didnt got any problem like this after updating the modules and the server.
Title: Re: Sqlite Plugin Problem
Post by: Thijn on Apr 13, 2015, 05:38 AM
Open up your server.cfg in notepad++, go to Edit -> EOL Conversion and select Linux. Save the file ad re-upload to your server.
Title: Re: Sqlite Plugin Problem
Post by: Mariu22S on Apr 13, 2015, 07:47 AM
@Thijn Did not help

This script worked perfectly before the update so it is the fault of the SQLite Plugin

The error occurs even after a short script

Test script

function onServerStart()
{
SetServerName( "[0.4] Polska Scena VC-MP ~VCMP.TK~" );
SetGameModeName( "PSSv4 DM " );
}
function onScriptLoad()
{
dofile( "scripts/test.nut" );
NewTimer( "sqlite" 1000, 1 );
}
function sqlite()
{
statsDB <- ConnectSQL( "Server.sqlite" );
}
Screen:
(https://forum.vc-mp.org/proxy.php?request=http%3A%2F%2Fi.imgur.com%2FAcblVFn.jpg&hash=f964a1b000311ebdb5791f22b94d94558dc2f102)
Title: Re: SQLite functions unavailable in RC2
Post by: Mariu22S on Apr 13, 2015, 11:17 AM
Also I have a problem with sqlite on Linux.

http://forum.vc-mp.org/?topic=463.0
Title: Re: Sqlite Plugin Problem
Post by: Thijn on Apr 13, 2015, 05:05 PM
The downloaded file returns the same behavior, but a recompile seems to work for me:
Quote32bit:
http://thijn.ovh/vcmp/builds/sqlite04rel32.so

64bit:
http://thijn.ovh/vcmp/builds/sqlite04rel64.so
Title: Re: Sqlite Plugin Problem
Post by: Mariu22S on Apr 13, 2015, 05:13 PM
Thanks, works properly. :)
Title: Re: SQLite functions unavailable in RC2
Post by: SoFahim on Jul 14, 2015, 02:51 PM
Quote from: Mariu22S on Apr 13, 2015, 11:17 AMAlso I have a problem with sqlite on Linux.

http://forum.vc-mp.org/?topic=463.0
I need this too. But Where i can download? the lonk not working
Title: Re: SQLite functions unavailable in RC2
Post by: Thijn on Jul 14, 2015, 04:42 PM
I wasn't aware people still used that link. I reuploaded them.