WordPress.org

Forums

WordPress database error (4 posts)

  1. senlow
    Member
    Posted 10 years ago #

    Has anyone seen this before?

    WordPress database error: [You have an error in your SQL syntax near '; ' at line 9]
    CREATE TABLE wp_stats (id int(11) unsigned NOT NULL auto_increment,username varchar(100) NOT NULL default '',ip varchar(15) NOT NULL default '127.0.0.1', time datetime NOT NULL default '0000-00-00 00:00:00',referrer varchar(255) default NULL, keyword varchar(255) default NULL,location varchar(100) NOT NULL default '', url varchar(100) NOT NULL default '',page int(11) unsigned NOT NULL default '0', version double default '0',browser varchar(255) NOT NULL default '', referrercomplete text NOT NULL,country varchar(100) NOT NULL default '', OS varchar(255) NOT NULL default 'Unknown', PRIMARY KEY (id) ) TYPE=MyISAM;

    I'm running WP 1.5, Http://saeblog.com
    I change the theme I was using and that's when I got the error message.
    Anyone know what I broke?
    Thanks,
    Steve

  2. senlow
    Member
    Posted 10 years ago #

    I found some more info on this:
    In the file wp_db.php
    h1>Error establishing a database connection</h1>
    This either means that the username and password information in your wp-config.php file is incorrect or we can't contact the database server at $dbhost.

    • Are you sure you have the correct username and password?
    • Are you sure that you have typed the correct hostname?
    • Are you sure that the database server is running?
    • I checked my wp_config.php file and the db name, username and password are correct. The db server is running, I can go into my sql and check it.
      I'm stumped.
      Thanks,
      Steve

  3. NuclearMoose
    Member
    Posted 10 years ago #

    Have you recently install a plugin? If so, try deactivating it and see what happens.

  4. senlow
    Member
    Posted 10 years ago #

    Hi Nuclear Moose,

    It was a plugin. wp-advanced-stats. Too bad it didn't work, looks like a good plugin for tracking site info.
    Thanks for your help,
    Steve

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.