Author Topic: missing table (Read 3498 times)

Heffalomp · « **on:** August 21, 2006, 11:32:44 pm »

Decided I wanted to see if there was much changed from 0.32 to the current svn so I made a new dir, downloaded the latest SVN of it (213)
when I try to do stuff like !commands and other things that checks if you have rights to do it I get the following error, and the cmd doesn't execute, i get the !help msg instead:

Code: [Select]

MySQL error (# 6) on query: SELECT count(*) FROM _admin_members, _admin_groups WHERE _admin_members.admin_group = _admin_groups.id AND (_admin_groups.name = 'superadmin' OR _admin_groups.name = 'superadmin') AND _admin_members.name = 'xxxx'
Table 'yyyy._admin_members' doesn't exist

and it seems it doesn't create that table if it doesn't find it.
nor does it work if I create the table my self either.
Anny way to fix this?

Khalem · « **Reply #1 on:** August 22, 2006, 05:58:43 am »

Looks like a bug in the table prefix code if no prefix has been set. I'll have a look at it later today.

As a workaround in the meantime you can do the following:
Make sure you have added the mysql table settings to MySQL.conf

Quote

/*
Database table prefix
A good choice here would be the botname in all lowercase characters
If you don't want to use a prefix, leave empty.
*/
$table_prefix = "";

/*
Master prefix table.
This is the table that holds information about which tables to use prefixes for.
A good choice here would be "botname_tablenames"
*/
$master_tablename = "botname_tablenames";

Set table_prefix to your botname, and change master_tablename to match your bot's name aswell.
Rename all tables except whois to botname_tablename.

Khalem · « **Reply #2 on:** August 22, 2006, 12:31:12 pm »

I've committed a fix to SVN for this issue.
Make sure you don't have a table named _tablenames or similiar that contains wrong tablenames before trying latest SVN.

Heffalomp · « **Reply #3 on:** August 22, 2006, 06:23:49 pm »

Still gave me the same errors..

Alltho I think I've gotten a little bit further now
seems it doesn't create the members table either so I copied the table layout from my old 0.32 bot's DB and suddenly I got !commands to work after manually adding myself to the members table.
alltho... more bugs will follow I guess... hehe =)

Khalem · « **Reply #4 on:** August 22, 2006, 07:13:57 pm »

The members table is no longer used in SVN, it has been replaced by the users table.

You can convert your old members table to users by uncommenting the import routine at the top of core/Roster.php.

Keep in mind the transition is not yet complete in SVN and there are loose ends like guests and admin management.