MySQL problem with Drupal Upgrade

I'm not sure where the problem came from but upon upgrading to Drupal 4.5 my site kept throwing errors here and there. It was trying to do an insert into the Menu table to create the custom menus. But the table wasn't configured properly.

  pid int(10) unsigned NOT NULL default '0',<br />
  path varchar(255) NOT NULL default '',<br />
  title varchar(255) NOT NULL default '',<br />

These three fields were missing from the menu table. After they were added it seems very happy and all is well.

No votes yet

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Link to Amazon products with: [amazon product_id inline|full|thumbnail|datadescriptor]. Example: [amazon 1590597559 thumbnail] or [amazon 1590597559 author]. Details are on the Amazon module handbook page.
  • Twitter-style @usersnames are linked to their Twitter account pages.
  • Twitter-style #hashtags are linked to search.twitter.com.
  • Allowed HTML tags: <a> <b> <dd> <dl> <dt> <i> <li> <ol> <u> <ul><p> <img> <table> <tr> <td><strong><em><sup><div><fn><h1><h2><h3><h4><blockquote><img style="">
  • Use [fn]...[/fn] (or <fn>...</fn>) to insert automatically numbered footnotes.
  • You may insert videos with [video:URL]
  • Lines and paragraphs break automatically.
  • Web page addresses and e-mail addresses turn into links automatically. (Better URL filter.)
  • You may post code using <code>...</code> (generic) or <?php ... ?> (highlighted PHP) tags.

More information about formatting options