Command and Conquer: Renegade Official Forums: Other Products » DBD::SQLite::ST execute failed: near "=": syntax e

Home » Tiberian Technologies / Blackhand Studios » Other Products » DBD::SQLite::ST execute failed: near "=": syntax e

Show: Today's Messages :: Polls :: Message Navigator

DBD::SQLite::ST execute failed: near "=": syntax e [message #62508]

Sun, 18 January 2004 13:56

aca20031
Messages: 8
Registered: January 2004

Karma: 0

Recruit

like the topic...it runs in irc and we can see game (at least public) and no !msg work...we've redone the remote admin and everthing..it just says DBD::SQLite::ST execute failed: near "=": syntax error at modules.pm line 753

http://www.clanuc.org --- ren+ clan

Report message to a moderator

DBD::SQLite::ST execute failed: near "=": syntax e [message #62510]

Sun, 18 January 2004 13:57

aca20031
Messages: 8
Registered: January 2004

Karma: 0

Recruit

it also isnt detecting any players but we can see thier chat...

http://www.clanuc.org --- ren+ clan

Report message to a moderator

DBD::SQLite::ST execute failed: near "=": syntax e [message #62546]

Sun, 18 January 2004 20:40

Blazer
Messages: 3322
Registered: February 2003
Location: Phoenix, AZ

Karma: 0

General (3 Stars)
Administrator/General

if !msg doesnt work and it says "No players" when you do a !pl then it means that remote admin is not working. Doublecheck the following:

1. Your remote admin password is exactly 8 characters.
2. Your remote admin password in brenbot.cfg is the same as in server.ini
3. Your remote admin port in brenbot.cfg is the same as in server.ini
4. Your remote admin IP in brenbot.cfg is the same as in server.ini (usually 127.0.0.1 works)
5. You have botmode set to WIN32.

Report message to a moderator

DBD::SQLite::ST execute failed: near "=": syntax e [message #62776]

Tue, 20 January 2004 11:41

Alkaline
Messages: 1132
Registered: November 2003

Karma: 0

General (1 Star)
Deleted

i get that error sometimes but it usually doens't affect anything...ofcourse I have brenbot running ok, so I dunno what it means if you haven't even gotten it to work yet...

http://www.UNRules.com

Report message to a moderator

DBD::SQLite::ST execute failed: near "=": syntax e [message #62828]

Tue, 20 January 2004 16:27

TnTaTTacK
Messages: 15
Registered: January 2004
Location: denhaag.nl

Karma: 0

Recruit

i have the same message
first i had brenbot running oke, but then i let br1.3 run also,with irc]
@first seemd oke but now i got the same message
then when i came home it was
out off mirc
msg b4 was bot -o -q
bot wasn't in mirc anymore
dunno what happend
btw the !msg didn't show up in mirc ,but on br1.3&fds
!pi same result

Report message to a moderator

DBD::SQLite::ST execute failed: near "=": syntax e [message #62833]

Tue, 20 January 2004 16:55

zunnie
Messages: 2959
Registered: September 2003
Location: Netherlands

Karma: 0

General (2 Stars)

The bot gets de-opped possibly, check the IRC settings in brenbot.cfg and double check if you set the right auth options like Q or NickServ.

For NickServ it should be:

Nickservauth = 1
Nickservname = Nickserv
Nickservauth = identify password

Check the if the bot is using the right IP, port and password

RenRemLinuxHost = 127.0.0.1      #this IP should work if the Bot is on same pc as the FDS is. In the Server.ini you must leave the RemoteAdmin IP line BLANK!
RenRemLinuxPort = 4848              #this is Remote Admin Port, check if it matches the port set in your Server.ini
RenRemLinuxPassword = remopass    #this is the remote password obviously, make sure it matches the one in Server.ini and it [b]MUST[/b] be EXACTLY 8 chars long.

Check the paths to fds-cfg file and fds-logpath, if you installed in C:\RenFDS, then you should enter this: (if you used other dir, use that obviously)

FDSConfigFile = C:\RenFDS\Server\Data\FanMaps.ini
FDSLogFilePath = C:\RenFDS\Server\

If that all matches and is set correct, then there should be no problems. If there are, then check if your firewall gives BRenBot permission to access internet and allow the ports to be used.

[zunnie]

https://multiplayerforums.com/uploads/monthly_2018_03/TCW2_Signature.png.6236a0dbc6e1e53472a18fe8cd15e47b.png

Report message to a moderator

DBD::SQLite::ST execute failed: near "=": syntax e [message #62837]

Tue, 20 January 2004 17:53

TnTaTTacK
Messages: 15
Registered: January 2004
Location: denhaag.nl

Karma: 0

Recruit

it matches but the prob begin when i started brenbot & br 1.3with (name bot+1)irc!
then some how it gets mixed up prob because ports probs
in mirc nothing in br1.3 & fds i could see everything even the commands

the !seen i typed in mirc and it showed up in br.1.3&fds(lol they came in pairs...)
but nothing in mirc
then brenbot starts saying something like ren_log not found
blabla in 120 secs
so they asumely cant work 2gether
btw if i start brenbot ,and then br.1.3 without irc , br.1.3 hangs Sad

Report message to a moderator

DBD::SQLite::ST execute failed: near "=": syntax e [message #62963]

Wed, 21 January 2004 13:09

zunnie
Messages: 2959
Registered: September 2003
Location: Netherlands

Karma: 0

General (2 Stars)

I had that too once. It just occured the day after for some unknown reason, it was 'searching' for renlog and didnt find nothing or it just crashed on the renewing wheel thing.

I uninstalled the FDS and installed it into an other directory and re-extracted BRenBot there and re-configured it. It did work then. Try that yourself.

Or better - just thought of this- if the server hasnt run yet, then there is also no Renlog file in the Server-dir. Run a game, and close the server so at least the renlog file exists. Then retry running the bot and before doing so check its config Wink

Also, the for the bot to identify itself, you must have registered that nick on your network. (obviously Wink

)

[zunnie]

Report message to a moderator

DBD::SQLite::ST execute failed: near "=": syntax e [message #63014]

Wed, 21 January 2004 17:36

TnTaTTacK
Messages: 15
Registered: January 2004
Location: denhaag.nl

Karma: 0

Recruit

its registerd Very Happy

duh... j/k
no what i meand was ..
everything was alreight,but when i run brenbot&&&&blaze.net (1.3)@the same time,it diddn't work anymore:S
seems that blaze.net somehow get rit of the file(renlog)prob in its own log files
then brenbot can't find it anymore,if u do a restart fds&brenbot then close brenbot it i'll update the renlog &all seems 2be oke
been running brenbot 2day just fine

btw
some times (after renstat updating) when running blazer.net it crashes on start up(meaning !rules wont show up in server events,etc)
the fix (4me)was putting results0,1,2,3,4 back in the fds/server dir.with no results on it
Team Score
0 GDI 0
0 Nod 0

Player Kills Deaths K/D Credits Score Ladder Rank

,then restart blaze.net&fds &all the command work again :S
grtz aTTacK AkA Engeltjes;-)

Report message to a moderator

DBD::SQLite::ST execute failed: near "=": syntax e [message #63067]

Wed, 21 January 2004 19:52

zunnie
Messages: 2959
Registered: September 2003
Location: Netherlands

Karma: 0

General (2 Stars)

that makes sense lol, there can be set only ONE remote admin port.
If BR. 1.3 uses it BEFORE BRenBot 1.31 then BRenBot cant use it becaus its 'in-use' and vice versa. You cannot run BR 1.3 and BRenBot 1.31 simultaniously.

<FanMapsBot> Error: could not find game results logfile :(

Thats all i get when i just ran RenStat and restart BRenBot, it doesnt crash for me, oly this tiny error. But it still functional and working the way it should after this.

[zunnie]

Report message to a moderator

DBD::SQLite::ST execute failed: near "=": syntax e [message #63117]

Thu, 22 January 2004 04:08

TnTaTTacK
Messages: 15
Registered: January 2004
Location: denhaag.nl

Karma: 0

Recruit

lol,@first it dit work>>some commands show up ingame as pairs
(!msg ello ppls)
host:(TnTaTTacK@irc)ello ppls
host:(TnTaTTacK@irc)elo ppls
but eventually it crashes the bot Laughing

brenbot is running nice again now Cool

grtz aTTacK

Report message to a moderator

Previous Topic:	noob list
Next Topic:	Me again Need more help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Nov 27 12:59:32 MST 2024

Total time taken to generate the page: 0.00840 seconds