Many database errors on local install, Win7/Apache2

  • Resolved rhecker

    (@rhecker)


    14 years, 2 months 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.

Viewing 7 replies - 1 through 7 (of 7 total)

  • Dito!

    Same exact issue…………

    Thread Starter rhecker

    (@rhecker)

    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.

    Thread Starter rhecker

    (@rhecker)

    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.

    Thread Starter rhecker

    (@rhecker)

    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
    https://tamba2.org.uk/wordpress/xampp/

    Thread Starter rhecker

    (@rhecker)

    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.