[resolved] SQL fixup fail (5 posts)

  1. mippie32
    Posted 2 years ago #

    I noticed the fix/workaround included in the latest version probably doesnt work as this message keeps coming back. Not a real issue for me (as everything works now ;-)) But FYI

    Diag keeps giving this everytime

    Post Deletion 2013-02-09 11:31:33 SQL Fixup : Alter table wp_wordbooker_fb_friends ADD FULLTEXT INDEX name_idx (name); -
    Post Deletion 2013-02-09 11:31:33 SQL Fixup Fail : The used table type doesn't support FULLTEXT indexes -


  2. Steve
    Plugin Author

    Posted 2 years ago #

    You've got your default DB table type set to INNODB at a guess and INNODB doesn't support fulltext indexes.

  3. mippie32
    Posted 2 years ago #

    OK. And yes, thats correct.
    I altered the wordbooker tables.

    ALTER TABLE wp_wordbooker_errorlogs ENGINE=MyISAM;
    ALTER TABLE wp_wordbooker_fb_friends ENGINE=MyISAM;
    ALTER TABLE wp_wordbooker_fb_friend_lists ENGINE=MyISAM;
    ALTER TABLE wp_wordbooker_postcomments ENGINE=MyISAM;
    ALTER TABLE wp_wordbooker_postlogs ENGINE=MyISAM;
    ALTER TABLE wp_wordbooker_process_queue ENGINE=MyISAM;
    ALTER TABLE wp_wordbooker_userdata ENGINE=MyISAM;
    ALTER TABLE wp_wordbooker_userstatus ENGINE=MyISAM;

    But it is a little funny I think, isnt it common to use the innodb as engine for WP tables? ( http://www.dev4press.com/2011/tutorials/wordpress/practical/choosing-mysql-database-engine-myisam-or-innodb/ ) ==> When I google around I only see people switching to innodb as engine?

    Anyway, it worked out, thanks.

  4. Steve
    Plugin Author

    Posted 2 years ago #

    The only table that needs to be MyISAM is the friends list. The rest of them can be InnoDB so I've changed the table create script to specifically state it for that table and the fix up code now checks for storage on tables and will usually leave them alone.

    I suspect most people on single blogs wont notice the differences between the two normally.

  5. mippie32
    Posted 2 years ago #

    Great :)

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic


No tags yet.