By Eagle-i on

The log files show me the following error:

Table 'my_domain_dbase.authmap' doesn't exist query: user_delete DELETE FROM authmap WHERE uid = 395 in /home/my_domain/public_html/includes/database.mysql.inc on line 172.

I've searched drupal but can't find the solution.

It looks like i miss the table authmap. Every time a new user registers or needs to be checked by email verify, the system shows errors.

Can anyone please help me?

⋅ Categories: Drupal 5.x

Comments

mooffie’s picture

mooffie commented

You need to recreate this table.

1. Open the 'system.install' file (it's in the {ROOT}/modules/system folder) in a text editor.
2. Search for "{authmap}".
3. You've found the table SQL definition. It starts with "CRAETE TABLE". Copy this string to notepad.
4. Delete the "{" and "}" chars surrounding the table name.
5. Paste this SQL to phpMyAdmin, or to any other MySQL front-end, and click Enter or Execute or whatever button this front-end provides.

Eagle-i’s picture

Eagle-i commented

Yeap, that did the trick. Thanks for your help!

mgifford’s picture

mgifford
he/him
Primary language English
commented

CREATE TABLE `authmap` (
`aid` int(10) unsigned NOT NULL auto_increment,
`uid` int(11) NOT NULL default '0',
`authname` varchar(128) NOT NULL default '',
`module` varchar(128) NOT NULL default '',
PRIMARY KEY (`aid`),
UNIQUE KEY `authname` (`authname`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

Although I may have run into that problem in the upgrade to D6 from D5.