backup error

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
Kev_Dawg
Registered User
Posts: 33
Joined: Thu Oct 05, 2006 6:12 am

backup error

Post by Kev_Dawg »

This is the error I am getting when I restore my database, should I be concerned about this? I removed this section of the sql file and tried to restore again, it finally restored correctly, everything worked. What is this phpbb_search_wordlist anyway, should I be worried about it giving me an error?

Code: Select all

Error
SQL query: 

-- 
-- Dumping data for table `phpbb_search_wordlist`
-- 
INSERT INTO `phpbb_search_wordlist` ( `word_text` , `word_id` , `word_common` ) 
VALUES (

0x30, 927, 0
), (
0x3063, 2208, 0
), (
0x31, 98, 0
), (
0x313030, 245, 0
), (
0x3130383069, 928, 0
), (
0x3130383070, 685, 0
), (
0x31313530, 936, 0
), (
0x3132, 400, 0
), (
0x313238307831303234, 929, 0
), (
0x313278, 930, 0
), (
0x31333030, 937, 0
), (
0x313430307831303830, 931, 0
), (
0x31363030, 938, 0
), (
0x313630307831323030, 932, 0
), (
0x313678, 933, 0
), (
0x31377468, 686, 0
), (
0x3139, 836, 0
), (
0x313932307831343430, 934, 0
), (
0x3174, 396, 0
), (
0x32, 96, 0
), (
0x323030, 935, 0
), (
0x32303034, 401, 0
), (
0x32303035, 939, 0
), (
0x32303036, 838, 0
), (
0x3230303632303037, 1371, 0
), (
0x32303037, 375, 0
), (
0x323034387831353336, 940, 0
), (
0x32306762, 687, 0
), (
0x32313432, 1691, 0
), (
0x32323235, 402, 0
), (
0x32333235, 403, 0
), (

and more of the 

0x32313432, 1691, 0
), (
0x32323235, 402, 0
), (
0x32333235, 403, 0
), (

MySQL said:  

#1406 - Data too long for column 'word_text' at row 979 

espicom
Registered User
Posts: 17905
Joined: Wed Dec 22, 2004 1:14 am
Location: Woodstock, IL

Post by espicom »

Edit your backup file, and remove all inserts to tables with "search" in their names, then use the MOD to rebuild search tables, which will get around problems like this. MySQL 5.x enforces rules far more strictly than earlier versions, which would have quietly truncated the too-long data.
Jeff
Fixing 1016/1030/1034 Errors | (obsolete link) | MySQL 4.1/5.x Client Error | phpBBv2 Logo in ACP
Support requests via PM are ignored!
"To be fully alive is to feel that everything is possible." - Eric Hoffer

Locked

Return to “2.0.x Support Forum”