L* R*
HOME FORUM DOWNLOADS
Content
  Links
     Browse SVN
     SVN Commit log
     Documentation (Wiki)
  Developers
     Taskmanager
User
Welcome, Guest. Please login or register.
Did you miss your activation email?
December 02, 2008, 11:03:42 PM

Login with username, password and session length
Search



Advanced search
Support GoPHP5.org
BeBot - An Anarchy Online/Age Of Conan chat automaton > Forum > Support > BeBot 0.5 support > Topic: SQL error on startup
Pages: [1]   Go Down
« previous next »
Print
Author Topic: SQL error on startup  (Read 200 times)
0 Members and 1 Guest are viewing this topic.
Foodor
Freshman
*
Offline Offline

Posts: 2


SQL error on startup
« on: March 04, 2008, 12:50:31 PM »

I was wondering why I get this error after I install nano plugin

MySQL error (# 0) on query: SELECT value FROM settings WHERE setting = 'nano icon'
Table 'bebot.settings' doesn't exist MySQL error (# 1) on query: NSERT INTO settings (setting, value) VALUES ('nano icon', '1')
Table 'bebot.settings' doesn't exist

Foo
Logged
Alreadythere
BeBot Maintainer
Administrator
Grandmaster
********
Offline Offline

Posts: 1085


Re: SQL error on startup
« Reply #1 on: March 04, 2008, 02:09:38 PM »

That must be an old module, bebot 0.4 and newer bring a settings framework as core module, which doesn't support those inserts anymore - it got a different table structure. Besides, the table most likely now is called botname_settings, as bebot on default is using the botname as table prefix for all the bot-specific tables, only some tables which should be global among all hosted bots are without prefix.

I believe there is a 0.4 version of the nano module around.
Logged
Temar
BeBot Developer
Grandmaster
********
Offline Offline

Gender: Male
Posts: 877



WWW
Re: SQL error on startup
« Reply #2 on: March 04, 2008, 02:56:27 PM »

yes its under 0.4 unofficial modules
Go down the topic and find my verion its the latest.

http://bebot.shadow-realm.org/index.php/topic,974.msg8161.html#msg8161
« Last Edit: March 04, 2008, 06:33:33 PM by Temar » Logged

MSN messenger: chris_smith96 at hotmain dot com
Xfire: chriss96
Pages: [1]   Go Up
Print
BeBot - An Anarchy Online/Age Of Conan chat automaton > Forum > Support > BeBot 0.5 support > Topic: SQL error on startup
« previous next »
 
Jump to:  

Recent
!items database
by Zeephonz
[Today at 08:05:21 PM]

Log playtime from buddys ...
by IKShadow
[Today at 06:48:12 AM]

[request] Raid timers
by Elesar1
[December 01, 2008, 04:41:09 PM]

Shared DB online list
by Temar
[December 01, 2008, 01:55:47 AM]

relay colors
by Temar
[December 01, 2008, 01:54:56 AM]

BeBot v0.6.0 released
by Alreadythere
[November 30, 2008, 05:32:00 PM]

Change to Bid.php
by Temar
[November 30, 2008, 11:41:44 AM]

OnlineOrg
by Jiheld
[November 29, 2008, 12:44:27 PM]

Silly Newbie Question.
by Temar
[November 29, 2008, 12:00:02 PM]

massive_pvp_time_table 1
by gerborg
[November 29, 2008, 06:55:35 AM]
Stats
Members
Total Members: 1244
Latest: Armonkens
Stats
Total Posts: 11146
Total Topics: 1505
Online Today: 25
Online Ever: 168
(July 01, 2007, 09:30:02 PM)
Users Online
Users: 1
Guests: 15
Total: 16
Vain

Powered by SMF 1.1.7 | SMF © 2006-2008, Simple Machines LLC
TinyPortal v0.9.8 © Bloc | NewDef design by Bloc
Page created in 0.317 seconds with 28 queries. (Pretty URLs adds 0.025s, 4q)
Loading...