1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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