Possible relating to this:
http://drupal.org/node/132753#comment-535833

New installation of Drupal 5.3, no other modules activated. (I had other modules activated, including API module mentioned in the link, but deactivated it before I took the snapshot, as I wanted to rest to a "clean" install)

When I reset the site, I get .....watchdog' doesn't exist query: INSERT INTO watchdog.... error.
When I go look in db, the table is missing.

I create the table (SQL from another site), test it with a manual cron to make sure it works (cron writes to Watchdog).
I delete and create new Snapshot. Check again that Watchdog table is still there.
Reset the site. Boom, Watchdog missing.

Comments

Max_Headroom’s picture

Max_Headroom commented

Just checking if this is a bug or is the problem with me?
I've tested it on another site (same server) and I get the same problem.
I first thought it was an index problem when a snapshot is taken: the last table (watchdog) is not included, but I've made a dummy table that sits at the end and in the new snapshot I saw the watchdog table is still missing.

Work around for now:
After you've created the snapshot open the sql file in /files/demo/default and add the following. Just add your prefix to the table name (ie: mydb_watchdog).

CREATE TABLE `watchdog` (
  `wid` int(11) NOT NULL auto_increment,
  `uid` int(11) NOT NULL default '0',
  `type` varchar(16) NOT NULL default '',
  `message` longtext NOT NULL,
  `severity` tinyint(3) unsigned NOT NULL default '0',
  `link` varchar(255) NOT NULL default '',
  `location` text NOT NULL,
  `referer` varchar(128) NOT NULL default '',
  `hostname` varchar(128) NOT NULL default '',
  `timestamp` int(11) NOT NULL default '0',
  PRIMARY KEY  (`wid`),
  KEY `type` (`type`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
sun’s picture

sun
Primary language German
Location Karlsruhe
commented
Category: support » bug
Priority: Normal » Critical
Status: Active » Fixed

Sorry, there has been a mistake in tagging the 5.x-1.1 release of demo. Please download the new 5.x-1.2 release of demo which should include all changes and bug fixes related to the watchdog table.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.