collapse collapse
* User Info
 
 
Welcome, Guest. Please login or register.
* Search

* Board Stats
  • stats Total Members: 989
  • stats Total Posts: 18363
  • stats Total Topics: 2500
  • stats Total Categories: 7
  • stats Total Boards: 35
  • stats Most Online: 1144

Author Topic: SQL error on startup  (Read 1563 times)

0 Members and 1 Guest are viewing this topic.

Offline Foodor

  • BeBot Rookie
  • *
  • Posts: 6
  • Karma: +0/-0
SQL error on startup
« on: March 04, 2008, 06: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

Offline Alreadythere

  • BeBot Maintainer
  • BeBot Hero
  • ******
  • Posts: 1288
  • Karma: +0/-0
Re: SQL error on startup
« Reply #1 on: March 04, 2008, 08: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.

Offline Temar

  • Contributor
  • *******
  • Posts: 1140
  • Karma: +0/-0
    • AoFiles
Re: SQL error on startup
« Reply #2 on: March 04, 2008, 08:56:27 pm »
yes its under 0.4 unofficial modules
Go down the topic and find my verion its the latest.

http://bebot.link/index.php/topic,974.msg8161.html#msg8161
« Last Edit: March 05, 2008, 12:33:33 am by Temar »

 

* Recent Posts
[AoC] special char for items module by bitnykk
[February 09, 2024, 09:41:18 pm]


0.8.x updates for AoC by bitnykk
[January 30, 2024, 11:16:08 pm]


0.8.x updates for AO by bitnykk
[January 30, 2024, 11:15:37 pm]


BeBot still alive & kicking ! by bitnykk
[December 17, 2023, 12:58:44 am]


Bebot and Rasberry by bitnykk
[November 29, 2023, 11:04:14 pm]

* Who's Online
  • Dot Guests: 667
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.
* Forum Staff
bitnykk admin bitnykk
Administrator
Khalem admin Khalem
Administrator
WeZoN gmod WeZoN
Global Moderator
SimplePortal 2.3.7 © 2008-2024, SimplePortal