Support » Installing WordPress » Many database errors on local install, Win7/Apache2

  • Resolved rhecker


    I am installing WordPress 3.0.1 for the first time on Window7/Apache2/PHP5.3.2/MySQL5.1.47. Although the Install ends with “Success!” there is a long list of WordPress database errors, such as:
    WordPress database error: [Invalid default value for ‘comment_date’]
    WordPress database error: [Table ‘wordpress.wp_users’ doesn’t exist]

    I can thereafter not log-in using the username and password I provided during installation.

    I see that seven tables were created in the database.

    Thanks for any help anyone can offer.

Viewing 7 replies - 1 through 7 (of 7 total)
  • Dito!

    Same exact issue…………

    Well it’s a drag that we can’t get a solution here. Has anyone here gotten WP to work on a local install? It’s important to be able to work with code, themes, etc. on a local install first. I’m starting to wish someone hadn’t talked me into trying WordPress. It’s a lot easier to just work with my own code.

    Apparently WordPress doesn’t run on local window/apache2 servers, which makes it a relatively worthless tool.

    The errors state that database all tables were not created. You should check why it failed to create tables during installation.

    However seven tables were created. wp_commentmeta, wp_options, wp_mostmeta, wp_terms, wp_term_relationships, wp_term_taxonomy, and wp_usermeta. There is also data in each table.

    what do you use?
    I use this and it works every time

    Samuel, thanks for the link. I use ZEND server instead of XAMPP because I use ZEND Studio and Zend Framework, but the instructions in that tutorial still pretty much apply.

    The solution, however, turned out to be that WordPress didn’t like it that I had MySQL mode set to Traditional. By simply not setting the MySQL mode in my.ini, WordPress installed without errors.

    So for me this issue is resolved. Thanks to everyone who followed along.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Many database errors on local install, Win7/Apache2’ is closed to new replies.