WordPress.org

Forums

[resolved] Many database errors on local install, Win7/Apache2 (8 posts)

  1. rhecker
    Member
    Posted 4 years ago #

    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']
    and
    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.

  2. dominick41
    Member
    Posted 4 years ago #

    Dito!

    Same exact issue............

  3. rhecker
    Member
    Posted 4 years ago #

    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.

  4. rhecker
    Member
    Posted 4 years ago #

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

  5. Kailash
    Member
    Posted 4 years ago #

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

  6. rhecker
    Member
    Posted 4 years ago #

    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.

  7. Samuel B
    moderator
    Posted 4 years ago #

    what do you use?
    I use this and it works every time
    http://tamba2.org.uk/wordpress/xampp/

  8. rhecker
    Member
    Posted 4 years ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Topic