Options Table Failing

  • Resolved gr0undzer084

    (@gr0undzer084)


    11 years ago

    I have built a package and deployed it on my new server. I get all the way to the end but it fails on the wp_options table.

    ********************************************************************************
DUPLICATOR INSTALL-LOG
STEP1 START @ 06:06:01
NOTICE: Do NOT post to public sites or forums
********************************************************************************
VERSION:	0.5.2
PHP:		5.4.24 | SAPI: cgi-fcgi
SERVER:		Microsoft-IIS/7.5
DOC ROOT:	C:/inetpub/wwwroot/wordpress
DOC ROOT 755:	true
LOG FILE 644:	true
BUILD NAME:	Test2_5306842120ecd3305140220223929
REQUEST URL:	https://phl17cdivweb01/installer.php

********************************************************************************
ARCHIVE SETUP
********************************************************************************
NAME:	Test2_5306842120ecd3305140220223929_archive.zip
SIZE:	56.71MB
ZIP:	Enabled (ZipArchive Support)
EXTRACTING
ZipArchive Object
(
    [status] => 0
    [statusSys] => 0
    [numFiles] => 0
    [filename] =>
    [comment] =>
)
COMPLETE: true

WEB SERVER CONFIGURATION FILE RESET:
- Backup of .htaccess/web.config made to .orig
- Reset of .htaccess/web.config files

UPDATED FILES:
- SQL FILE:  'C:/inetpub/wwwroot/wordpress/installer-data.sql'
- WP-CONFIG: 'C:/inetpub/wwwroot/wordpress/wp-config.php'

ARCHIVE RUNTIME: 8.8594 sec.

********************************************************************************
DATABASE-ROUTINES
********************************************************************************
--------------------------------------
SERVER ENVIROMENT
--------------------------------------
MYSQL VERSION:	5.1.72-community
TIMEOUT:	5000
MAXPACK:	1048576
--------------------------------------
DATABASE RESULTS
--------------------------------------
**ERROR** database error write 'The used table type doesn't support FULLTEXT indexes' - [sql=
CREATE TABLE <code>wp_options</code> (
  <code>option_id</code> bigint(20) unsigned NOT NULL AUT...]
**ERROR** database error write 'Table 'wordpress930.wp_options' doesn't exist' - [sql=
/* INSERT TABLE DATA: wp_options */
INSERT INTO <code>wp_options</code> VALUES("1", "...]
**ERROR** database error write 'Table 'wordpress930.wp_options' doesn't exist' - [sql=INSERT INTO <code>wp_options</code> VALUES("2", "blogname", "", "yes")...]
**ERROR** database error write 'Table 'wordpress930.wp_options' doesn't exist' - [sql=INSERT INTO <code>wp_options</code> VALUES("3", "blogdescription", "", "yes")...]
**ERROR** database error write 'Table 'wordpress930.wp_options' doesn't exist' - [sql=INSERT INTO <code>wp_options</code> VALUES("4", "users_can_register", "0", "yes")...]
**ERROR** database error write 'Table 'wordpress930.wp_options' doesn't exist' - [sql=INSERT INTO <code>wp_options</code> VALUES("5", "admin_email", "auto.onboarding@cdicor...]
**ERROR** database error write 'Table 'wordpress930.wp_options' doesn't exist' - [sql=INSERT INTO <code>wp_options</code> VALUES("6", "start_of_week", "1", "yes")...]
**ERROR** database error write 'Table 'wordpress930.wp_options' doesn't exist' - [sql=INSERT INTO <code>wp_options</code> VALUES("7", "use_balanceTags", "0", "yes")...]
**ERROR** database error write 'Table 'wordpress930.wp_options' doesn't exist' - [sql=INSERT INTO <code>wp_options</code> VALUES("8", "use_smilies", "1", "yes")...]
**ERROR** database error write 'Table 'wordpress930.wp_options' doesn't exist' - [sql=INSERT INTO <code>wp_options</code> VALUES("9", "require_name_email", "1", "yes")...]
**ERROR** database error write 'Table 'wordpress930.wp_options' doesn't exist' - [sql=INSERT INTO <code>wp_options</code> VALUES("10", "comments_notify", "1", "yes")...]
**ERROR** database error write 'Table 'wordpress930.wp_options' doesn't exist' - [sql=INSERT INTO <code>wp_options</code> VALUES("11", "posts_per_rss", "10", "yes")...]
**ERROR** database error write 'Table 'wordpress930.wp_options' doesn't exist' - [sql=INSERT INTO <code>wp_options</code> VALUES("12", "rss_use_excerpt", "0", "yes")...]
**ERROR** database error write 'Table 'wordpress930.wp_options' doesn't exist' - [sql=INSERT INTO <code>wp_options</code> VALUES("13", "mailserver_url", "mail.example.com",...]
**ERROR** database error write 'Table 'wordpress930.wp_options' doesn't exist' - [sql=INSERT INTO <code>wp_options</code> VALUES("14", "mailserver_login", "[email protected]...]
**ERROR** database error write 'Table 'wordpress930.wp_options' doesn't exist' - [sql=INSERT INTO <code>wp_options</code> VALUES("15", "mailserver_pass", "password", "yes")...]
**ERROR** database error write 'Table 'wordpress930.wp_options' doesn't exist' - [sql=INSERT INTO <code>wp_options</code> VALUES("16", "mailserver_port", "110", "yes")...]
**ERROR** database error write 'Table 'wordpress930.wp_options' doesn't exist' - [sql=INSERT INTO <code>wp_options</code> VALUES("17", "default_category", "1", "yes")...]
**ERROR** database error write 'Table 'wordpress930.wp_options' doesn't exist' - [sql=INSERT INTO <code>wp_options</code> VALUES("18", "default_comment_status", "closed", "...]
**ERROR** database error write 'Table 'wordpress930.wp_options' doesn't exist' - [sql=INSERT INTO <code>wp_options</code> VALUES("19", "default_ping_status", "open", "yes")...]
STEP 2 COMPLETE @ 06:06:50 - TOTAL RUNTIME: 9.5157 sec.
********************************************************************************

    I had to shorten it, wouldn’t fit everything. I tried doing a manual data transfer with Navicat, but it also gives an error:

    [Msg] [Dtf] DataTransfer started
[Msg] [Dtf] Getting tables
[Msg] [Dtf] Drop table: <code>wp_options</code>
[Msg] [Dtf] Create table: <code>wp_options</code>
[Err] [Dtf] 1214 - The used table type doesn't support FULLTEXT indexes
[Err] [Dtf] Finished - Unsuccessfully

    Anyone know what is going on?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter gr0undzer084

    (@gr0undzer084)

    https://stackoverflow.com/questions/963534/mysql-fulltext-indexes-issue

    Ran the query to change the data to MYISAM. I also ran it again to set it back to InnoDB once it transferred, just in case it messes something up. Please let me know if this is correct, or if there is a better option that you guys would suggest.

    Cory Lamle

    (@corylamleorg)

    Hey Gr0undzer084,

    That looks like an issue specific to mysql. I’m not really a mysql guru, so I’m not sure to be honest… Did some googling and found this…

    Thanks~

    Hello I am having the same problem with tables when i try to install a site from live to locally i get error messages saying that Table doesn’t exist for lots of tables.

    I should also mention that when i packaged up from my live site using duplicator – i had to filter out my wordpress uploads folder as the site was too big to zip up. I am using 123-reg hosting.
    I managed to get another much smaller site to go from local to live and live to local using duplicator no problem but this one was much smaller so i was able to package everything up as normal from the live site using duplicator.

    I have tried a lot of options in the duplicator settings but same issue each time
    any suggestions?

    Hey Mr Tea,

    If you want to submit a support ticket I can look at it when I get some time, at this point it looks like its something possibly happening with MySQL… Be sure to refer to this forum thread when you create your ticket…

    Cheers~

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Options Table Failing’ is closed to new replies.