Error importing Database

  • thegrrraue

    (@thegrrraue)


    8 years ago

    I moved my site to a new host, and I can’t seem to make it work. I exported the database, exported the XML file from wordpress’ tools section, and moved over all the files.

    I can see that some of my edits to my theme have made it over, where I went into the file editor and made some custom changes, but it shows all of the default sample data in my theme (wp-simple). In trying to trace down the problem, I noticed that much of the data in my tables appears incomplete or incorrect.

    I don’t know much about sql, so forgive me, but I tried re-importing the database, then also deleting the database and trying again (which apparently doesn’t work until you install wordpress again, oops).

    Perhaps my hint should have been the errors I get every time I try to import the database. Does anyone have any ideas?

    Warning in ./libraries/DisplayResults.php#869
 A non-numeric value encountered

Backtrace

./libraries/DisplayResults.php#4932: PMA\libraries\DisplayResults->_getTableNavigation(
integer 0,
integer 0,
boolean false,
string '<form action="sql.php" method="post" class="print_ignore"> <input type="hidden" name="db" value="the131ers_com_1" /><input type="hidden" name="table" value="wp_uuacwb_options" /><input type="hidden" name="token" value="ed602edb73e5108d9c99d5dd08e74ac8" /><input type="hidden" name="sort_by_key" value="1" />Sort by key: <select name="sql_query" class="autosubmit"> <option value="SELECT * FROM <code>wp_uuacwb_options</code> ORDER BY <code>option_id</code> ASC">PRIMARY (ASC)</option><option value="SELECT * FROM <code>wp_uuacwb_options</code> ORDER BY <code>option_id</code> DESC">PRIMARY (DESC)</option><option value="SELECT * FROM <code>wp_uuacwb_options</code> ORDER BY <code>option_name</code> ASC">option_name (ASC)</option><option value="SELECT * FROM <code>wp_uuacwb_options</code> ORDER BY <code>option_name</code> DESC">option_name (DESC)</option><option value="SELECT * FROM <code>wp_uuacwb_options</code> " selected="selected">None</option></select> </form> ',
)
./libraries/DisplayResults.php#4377: PMA\libraries\DisplayResults->_getPlacedTableNavigations(
integer 0,
integer 0,
string 'top_direction_dropdown',
boolean false,
string '<form action="sql.php" method="post" class="print_ignore"> <input type="hidden" name="db" value="the131ers_com_1" /><input type="hidden" name="table" value="wp_uuacwb_options" /><input type="hidden" name="token" value="ed602edb73e5108d9c99d5dd08e74ac8" /><input type="hidden" name="sort_by_key" value="1" />Sort by key: <select name="sql_query" class="autosubmit"> <option value="SELECT * FROM <code>wp_uuacwb_options</code> ORDER BY <code>option_id</code> ASC">PRIMARY (ASC)</option><option value="SELECT * FROM <code>wp_uuacwb_options</code> ORDER BY <code>option_id</code> DESC">PRIMARY (DESC)</option><option value="SELECT * FROM <code>wp_uuacwb_options</code> ORDER BY <code>option_name</code> ASC">option_name (ASC)</option><option value="SELECT * FROM <code>wp_uuacwb_options</code> ORDER BY <code>option_name</code> DESC">option_name (DESC)</option><option value="SELECT * FROM <code>wp_uuacwb_options</code> " selected="selected">None</option></select> </form> ',
)
./libraries/sql.lib.php#1680: PMA\libraries\DisplayResults->getTable(
,
array,
array,
boolean false,
)
./libraries/sql.lib.php#1963: PMA_getHtmlForSqlQueryResultsTable(
,
string './themes/pmahomme/img/',
NULL,
array,
boolean true,
integer 136,
integer 136,
NULL,
,
array,
)
./libraries/sql.lib.php#2186: PMA_getQueryResponseForResultsReturned(
,
array,
string 'the131ers_com_1',
string 'wp_uuacwb_options',
NULL,
NULL,
,
string './themes/pmahomme/img/',
integer 136,
integer 136,
NULL,
NULL,
NULL,
NULL,
NULL,
string 'SELECT * FROM <code>wp_uuacwb_options</code>',
NULL,
)
./libraries/sql.lib.php#2048: PMA_executeQueryAndGetQueryResponse(
array,
boolean true,
string 'the131ers_com_1',
string 'wp_uuacwb_options',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM <code>wp_uuacwb_options</code>',
NULL,
NULL,
)
./sql.php#221: PMA_executeQueryAndSendQueryResponse(
array,
boolean true,
string 'the131ers_com_1',
string 'wp_uuacwb_options',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM <code>wp_uuacwb_options</code>',
NULL,
NULL,
)
Warning in ./libraries/DisplayResults.php#869
 A non-numeric value encountered

Backtrace

./libraries/DisplayResults.php#4932: PMA\libraries\DisplayResults->_getTableNavigation(
integer 0,
integer 0,
boolean false,
string '<form action="sql.php" method="post" class="print_ignore"> <input type="hidden" name="db" value="the131ers_com_1" /><input type="hidden" name="table" value="wp_uuacwb_options" /><input type="hidden" name="token" value="ed602edb73e5108d9c99d5dd08e74ac8" /><input type="hidden" name="sort_by_key" value="1" />Sort by key: <select name="sql_query" class="autosubmit"> <option value="SELECT * FROM <code>wp_uuacwb_options</code> ORDER BY <code>option_id</code> ASC">PRIMARY (ASC)</option><option value="SELECT * FROM <code>wp_uuacwb_options</code> ORDER BY <code>option_id</code> DESC">PRIMARY (DESC)</option><option value="SELECT * FROM <code>wp_uuacwb_options</code> ORDER BY <code>option_name</code> ASC">option_name (ASC)</option><option value="SELECT * FROM <code>wp_uuacwb_options</code> ORDER BY <code>option_name</code> DESC">option_name (DESC)</option><option value="SELECT * FROM <code>wp_uuacwb_options</code> " selected="selected">None</option></select> </form> ',
)
./libraries/DisplayResults.php#4460: PMA\libraries\DisplayResults->_getPlacedTableNavigations(
integer 0,
integer 0,
string 'bottom_direction_dropdown',
boolean false,
string '<form action="sql.php" method="post" class="print_ignore"> <input type="hidden" name="db" value="the131ers_com_1" /><input type="hidden" name="table" value="wp_uuacwb_options" /><input type="hidden" name="token" value="ed602edb73e5108d9c99d5dd08e74ac8" /><input type="hidden" name="sort_by_key" value="1" />Sort by key: <select name="sql_query" class="autosubmit"> <option value="SELECT * FROM <code>wp_uuacwb_options</code> ORDER BY <code>option_id</code> ASC">PRIMARY (ASC)</option><option value="SELECT * FROM <code>wp_uuacwb_options</code> ORDER BY <code>option_id</code> DESC">PRIMARY (DESC)</option><option value="SELECT * FROM <code>wp_uuacwb_options</code> ORDER BY <code>option_name</code> ASC">option_name (ASC)</option><option value="SELECT * FROM <code>wp_uuacwb_options</code> ORDER BY <code>option_name</code> DESC">option_name (DESC)</option><option value="SELECT * FROM <code>wp_uuacwb_options</code> " selected="selected">None</option></select> </form> ',
)
./libraries/sql.lib.php#1680: PMA\libraries\DisplayResults->getTable(
,
array,
array,
boolean false,
)
./libraries/sql.lib.php#1963: PMA_getHtmlForSqlQueryResultsTable(
,
string './themes/pmahomme/img/',
NULL,
array,
boolean true,
integer 136,
integer 136,
NULL,
,
array,
)
./libraries/sql.lib.php#2186: PMA_getQueryResponseForResultsReturned(
,
array,
string 'the131ers_com_1',
string 'wp_uuacwb_options',
NULL,
NULL,
,
string './themes/pmahomme/img/',
integer 136,
integer 136,
NULL,
NULL,
NULL,
NULL,
NULL,
string 'SELECT * FROM <code>wp_uuacwb_options</code>',
NULL,
)
./libraries/sql.lib.php#2048: PMA_executeQueryAndGetQueryResponse(
array,
boolean true,
string 'the131ers_com_1',
string 'wp_uuacwb_options',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM <code>wp_uuacwb_options</code>',
NULL,
NULL,
)
./sql.php#221: PMA_executeQueryAndSendQueryResponse(
array,
boolean true,
string 'the131ers_com_1',
string 'wp_uuacwb_options',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM <code>wp_uuacwb_options</code>',
NULL,
NULL,
)
Viewing 3 replies - 1 through 3 (of 3 total)
  • ProjectArmy

    (@supporthero)

    Where are you importing database? Is it phpMyAdmin? or somewhere else?

    ^V

    Thread Starter thegrrraue

    (@thegrrraue)

    Yes, into phpMyAdmin.

    I’ve just gone through and rebuilt the site from scratch anyway, but I would be curious to know what the issue is in case I have to do this again someday.

    Also, did I totally just post my private key in those codeblocks? Should I edit that?

    ProjectArmy

    (@supporthero)

    It’s hard to say what went wrong. It’s possible, based on what you mentioned, that your table prefix was different if you installed a new WP first. Changing prefix in wp-config.php will make WP think it’s a new database. So even after import, if prefix was different WP would’ve shown you default database.

    ^V

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Error importing Database’ is closed to new replies.