The MU forums have moved to WordPress.org

Receiving database error (10 posts)

  1. duckduckgoose
    Inactive
    Posted 18 years ago #

    Each time I create a new blog, it creates it, but upon visiting the new blog's url for the first time, I receive this error:

    WordPress database error: [You have an error in your SQL syntax near '; ' at line 15]
    CREATE TABLE wp_4_referer_visitLog ( blogID char( 32 ) default NULL , visitID int( 11 ) NOT NULL AUTO_INCREMENT , visitTime timestamp( 14 ) NOT NULL , visitURL char( 250 ) default NULL , referingURL char( 250 ) default NULL , baseDomain char( 250 ) default NULL , refpost int( 11 ) NOT NULL default '0', visitTimes int( 10 ) NOT NULL default '0', dayofmonth smallint( 2 ) NOT NULL default '0', PRIMARY KEY ( visitID ) , KEY blogID ( blogID ) , KEY refpost ( refpost ) , KEY dayofmonth ( dayofmonth ) );

    Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /home/virtual/site6/fst/var/www/html/wpmu/wp-inst/wp-includes/wp-db.php:108) in /home/virtual/site6/fst/var/www/html/wpmu/wp-inst/wp-content/mu-plugins/wp-hashcash.php on line 29

    Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/virtual/site6/fst/var/www/html/wpmu/wp-inst/wp-includes/wp-db.php:108) in /home/virtual/site6/fst/var/www/html/wpmu/wp-inst/wp-content/mu-plugins/wp-hashcash.php on line 29

    If I refresh the page, these error messages disappear and the blog works just fine, but what's going on here? Anyway to fix it?

  2. duckduckgoose
    Inactive
    Posted 18 years ago #

    Hmm, is there no solution to this?

  3. donncha
    Key Master
    Posted 18 years ago #

    does your db user have "CREATE" permission? Can't think why you'd get this as I haven't seen it before. Is this an uptodate install?

  4. duckduckgoose
    Inactive
    Posted 18 years ago #

    I downloaded the nightly build on 9/3/05, so, it's up-to-date. And the user has all privileges.

  5. duckduckgoose
    Inactive
    Posted 18 years ago #

    Is there a way to just do away with the whole referer log thing? Where can I just comment it out?

  6. duckduckgoose
    Inactive
    Posted 18 years ago #

    BTW, there's nothing wrong with the SQL statement... If I paste it as is at the mysql prompt, it creates the database just fine.

  7. andrewbillits
    Member
    Posted 18 years ago #

    this is just me thinking outloud, but maybe it's a chmod problem.

  8. duckduckgoose
    Inactive
    Posted 18 years ago #

    Well, I changed it to 777 just to see, and I'm still having problems. :(

  9. duckduckgoose
    Inactive
    Posted 18 years ago #

    Funny....

    I got it working by removing all the extraneous spaces within the code.

  10. andrewbillits
    Member
    Posted 18 years ago #

    don't ya just love working with php :)

About this Topic

  • Started 18 years ago by duckduckgoose
  • Latest reply from andrewbillits