By ShortCurl on

My web host just moved me to a new server, leaving me with several issues. The following is the last remaining issue:

Fatal error: Table 'chrisnb_drpl1.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, hostname, timestamp) VALUES (1, 'php', 'Table \'chrisnb_drpl1.watchdog\' doesn\'t exist query: SELECT DISTINCT(type) FROM watchdog ORDER BY type in /home/chrisnb/public_html/includes/database.mysql.inc on line 66.', 2, '', '/admin', '131.150.171.121', 1152550768) in /home/chrisnb/public_html/includes/database.mysql.inc on line 66

I haven't been able to sort this one out as of yet. If anyone can offer a bit of assistance or wisdom on this one I would be forever greatful.

I am trying to get this fixed so that I can upgrade to 4.7.

Thanks
~C

⋅ Categories: Drupal 4.6.x

Comments

ericatkins’s picture

ericatkins commented

Can you provide more details?

What does your SQL database look like? Are all of your tables there? What does the watchdog table look like? Does it look the same as your old table?

nomad411’s picture

nomad411 commented

Is your database called chrisnb_drpl1 ?

bryansd’s picture

bryansd commented

I'm not the biggest expert on SQL here, but assuming that you have access to your database (chrisnb_drupl1) and other tables are accessible for Drupal...I would say that your watchdog table doesn't exist. The table may have been corrupted on the old server and didn't transfer properly to the new server.

Do you have access to phpMyAdmin (usually provided in one shape or another by your host provider)? If so, load up your database in it and take a look at the watchdog table. If the table doesn't exist then under the SQL tab try the following:

CREATE TABLE watchdog (
  wid int(5) NOT NULL auto_increment,
  uid int(10) 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 varchar(128) NOT NULL default '',
  hostname varchar(128) NOT NULL default '',
  timestamp int(11) NOT NULL default '0',
  PRIMARY KEY (wid)
) TYPE=MyISAM;

If the table does exist, you may try doing a "repair" or "empty". If that doesn't work then you may need to "drop" the table and retry the SQL commands above.

My Drupal Site:
CMSReport

ShortCurl’s picture

ShortCurl commented

BryanSD, you were right. My watchdog table didn't exist. Seems as if my webhost 'left' it on the older server?? I just added it back into my SQL db and all is well again! Thanks!

:)
~Stina

bryansd’s picture

bryansd commented

Glad I could help. I've moved my sites enough to know that there is no such thing as a perfect move. As I mentioned before, I suspect that your original watchdog table had problems and couldn't be exported out of the old database. Luckily, the watchdog table contains only logs and not your site's content.

My Drupal Site:
CMSReport