Quick Login   
 
Register AdminFusion Tutorials
 
Featured Sponsors


One.com Domain and Hosting


Register
Forum of the Month
Australian Webmaster
fotm

A webmaster forum specifically catering for Australian site owners. We discuss site development, marketing and management issues.

Tag Cloud
Latest Threads
Forum Stats
7,899 Members
165,085 Posts
49 Users Online

Please welcome our newest member, jevs!

Affiliates
Go Back AdminFusion » Getting Started » Software » BigDump Error (Please Help)
Welcome to the AdminFusion. AdminFusion is the ultimate resource for forum administrators and moderators. With exclusive articles, interviews with the experts, free downloadable skins, and the revolutionary post exchange system - PostFusion, AdminFusion is the place to go for all of your forum needs.  By joining AdminFusion, you will become part of a thriving admin community and immediately gain access to all of these resources. Registration is fast, simple and absolutely free so please join us today!
Want more than our forums? Try these: Post Fusion Forum Matrix
Old 02-25-2008, 06:37 AM   #1

BlueEew's Avatar

Title: Lurker

Points: 88, Level: 1Points: 88, Level: 1Points: 88, Level: 1
Level up: 2%, 62 Points neededLevel up: 2%, 62 Points neededLevel up: 2%, 62 Points needed
Activity: 0%Activity: 0%Activity: 0%

Join Date: Feb 2008

Posts: 2

BlueEew is on a distinguished road
 
 
BigDump Error (Please Help)

Hello. First off, hello to all the members here. If I have posted in the wrong forum please forgive me. Anyways, I need your help. I have been able to download a backup from my free phpBB forum host.

I have got to the point where I have to run the BigDump, however the following error occures;

Quote:
Error at the line 227602: INSERT INTO pokeproject_search_wordlist (word_text, word_id, word_common) VALUES('pok�mon', '4361', '0');

Query: INSERT INTO pokeproject_search_wordlist (word_text, word_id, word_common) VALUES('pokémon', '4361', '0');

MySQL: Duplicate entry 'pok�mon' for key 1
From what I have found, I am sure I just have to delete the _search_ files. However there are soo many. How would I delete them all so quickly?

Maybe there is another way? Anyways I am moving to phpBB 2. Thats the software the free host is on.

Help me please. It's like 5.37 in the morning here. I have been up all day and night trying to do this.

Thanks,
BlueEew.
Reply With Quote
Old 03-04-2008, 08:47 PM   #2

Oldiesmann's Avatar

Title: Member

Points: 2,136, Level: 12Points: 2,136, Level: 12Points: 2,136, Level: 12
Level up: 13%, 14 Points neededLevel up: 13%, 14 Points neededLevel up: 13%, 14 Points needed
Activity: 0%Activity: 0%Activity: 0%

Join Date: Apr 2006

Posts: 72

Location: Cincinnati, Ohio

Oldiesmann is on a distinguished road
Send a message via AIM to Oldiesmann Send a message via MSN to Oldiesmann Send a message via Yahoo to Oldiesmann  
 
That's not an error with the script itself. That simply means that there's already a row in that table with "pokémon" in the word_text column. Make sure all keys have been created properly (I don't see why the "word_text" column should be a unique key since the same word will likely appear in several topics/posts), and that the table is completely empty before trying to insert things.
__________________
The Oldiesmann
SMF Webmaster
SMF+Gallery2 Integration Project - RC1 now available!
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

 
Posting Rules

AdminFusion

All times are GMT +1. The time now is 10:29 PM. Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.1.0 © 2005-2008 AdminFusion - All Rights Reserved



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72