SQL error

Discussion in 'Blogging' started by xxfirexx, Jun 8, 2008.

  1. #1
    My wp blog was working fine until I refreshed and it asked me to upgrade. I said ok and it just messed up.

    Error
    
    SQL query:
    
    --
    -- Database: `phlunet_phlu`
    --
    -- --------------------------------------------------------
    --
    -- Table structure for table `wp_comments`
    --
    CREATE TABLE IF NOT EXISTS `wp_comments` (
    `comment_ID` bigint( 20 ) unsigned NOT NULL AUTO_INCREMENT ,
    `comment_post_ID` int( 11 ) NOT NULL default '0',
    `comment_author` tinytext NOT NULL ,
    `comment_author_email` varchar( 100 ) NOT NULL default '',
    `comment_author_url` varchar( 200 ) NOT NULL default '',
    `comment_author_IP` varchar( 100 ) NOT NULL default '',
    `comment_date` datetime NOT NULL default '0000-00-00 00:00:00',
    `comment_date_gmt` datetime NOT NULL default '0000-00-00 00:00:00',
    `comment_content` text NOT NULL ,
    `comment_karma` int( 11 ) NOT NULL default '0',
    `comment_approved` varchar( 20 ) NOT NULL default '1',
    `comment_agent` varchar( 255 ) NOT NULL default '',
    `comment_type` varchar( 20 ) NOT NULL default '',
    `comment_parent` bigint( 20 ) NOT NULL default '0',
    `user_id` bigint( 20 ) NOT NULL default '0',
    PRIMARY KEY ( `comment_ID` ) ,
    KEY `comment_approved` ( `comment_approved` ) ,
    KEY `comment_post_ID` ( `comment_post_ID` ) ,
    KEY `comment_approved_date_gmt` ( `comment_approved` , `comment_date_gmt` ) ,
    KEY `comment_date_gmt` ( `comment_date_gmt` )
    ) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =3;
    
    MySQL said: Documentation
    #1005 - Can't create table 'wp_comments' (errno: 13) 
    Code (markup):
    Plz help me. I tried all the old sql files and none are working and giving the same error. It worked yesterday when I imported the sql
     
    xxfirexx, Jun 8, 2008 IP
  2. xxfirexx

    xxfirexx Banned

    Messages:
    327
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Ok, just tried it on my other host and it works fine. I guess it has something to do with the server?
     
    xxfirexx, Jun 8, 2008 IP
  3. godsofchaos

    godsofchaos Peon

    Messages:
    2,595
    Likes Received:
    124
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Yeah its most probably a php 4 versus 5 issue, mixed with two teaspoon full of wp cache lol.
     
    godsofchaos, Jun 8, 2008 IP