I've had a few of people ask why they are getting database errors during the first run of their new drupal system, so I thought I'd post this just in case it helps.
[b]Please make sure that you populate the Drupal database[/b]. This is described in Part 3 or 4, Page 10, Listing 5. Most of the database errors I've been sent are caused by folk missing out this critical step or somehow ending up with a partially build database. If your database is partially built, clear it out (drop all the tables in the database using phpmyadmin or the MySQL admin/query browser tools) and initialize the database again.
If you get an error like, "error 1364 (hy000) line 803: field 'page' doesn't have a default value", when you build the database then use the solution described at http://drupal.org/node/43316.
Another issue to be aware of is the PHP version, as described at http://drupal.org/node/92802.
These last two bugs may have been fixed in the new version of 4.7.
In case you didn't know, Drupal 5.0 has a new installation process that builds the database for you.
Hope this helps.