Drupal 5.0
Configuration file Protected
Cron maintenance tasks Last run 1 day 1 hour ago
You can run cron manually.
Database schema Up to date
File system Writable (public download method)
GD library bundled (2.0.28 compatible)
MySQL database 5.0.27
PHP 5.2.0
Unicode library Standard PHP
Operations on Unicode strings are emulated on a best-effort basis. Install the PHP mbstring extension for improved Unicode support.
Web server Apache/2.2.3 (Win32) DAV/2 mod_ssl/2.2.3 OpenSSL/0.9.8d mod_autoindex_color PHP/5.2.0

Enabled mod8

Got this error when enabling:
mysql_query() [http://www.mysql.com/doc]: Key column 'mpdid' doesn't exist in table in C:\Web Server\xampp\htdocs\includes\database.mysql.inc on line 148.

I wasn't certain what it was affecting so I surfed around the site until I got another error. I checked the blogs, specifically viewed a blog post with a comment and got this error:

warning: mysql_query() [http://www.mysql.com/doc]: Table 'drupal.modr8_log' doesn't exist in C:\Web Server\xampp\htdocs\includes\database.mysql.inc on line 148.

I went ahead and disabled it for now. Please let me know how to fix it.

CommentFileSizeAuthor
#3 fix_install_key.diff747 bytespwolanin

Comments

bonobo’s picture

I'm seeing the same thing on a clean install of 5.0 -- as this issue points out ( http://drupal.org/node/110653 ), the table never gets created --

I set the other issue to duplicate, as I'm going to go out on a limb and assume that the reason we're getting a "Table doesn't exist" error is because the table wasn't created.

bonobo’s picture

This solved it for me, with props to this guy: http://drupal.org/user/20885

In the .install file, fix the typo in line 22 in KEY nid_time:

replace "mpdid" with "modid"

All works now.

pwolanin’s picture

Status: Active » Fixed
StatusFileSize
new747 bytes

Thanks- a stupid typo. For some reason I didn't see the error when testing- maybe different MySQL reporting? Committing the fix. Look for a version 5.x-2.1 real soon.

pwolanin’s picture

Status: Fixed » Closed (fixed)