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.
This topic has been locked.
Pinned topic Database and config issues
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2006-11-27T15:04:42Z at 2006-11-27T15:04:42Z by SystemAdmin