impossible to add word to search index

foxmask · 2006-04-04 08:03

foxmask
Senior Member
Offline

Registered: 2005-11-30
Posts: 165

Topic: impossible to add word to search index

Hi,
I recently change of hosting and made a dump of my database to import it on my new website.
I met problem when importing in pn_search_words so i decide remove the table in the exported dump and imported the dump like that.
All went well but now ; sometimes when i post in the forum i meet the following error :

forum/include/search_idx.php
Ligne : 149
PunBB a rapporté : Impossible d'ajouter les mots index de recherche
La base de données a rapporté : Duplicate entry 'passé' for key 1 (Errno: 1062)

so i tried to reindex the searching engine by truncate the pn_search_words once again and rebuild the index but the problem is still there
even with the rebuild index i meet the error Duplicate Entry.

Any suggestion ?

http://www.foxmask.info

elbekko · 2006-04-04 10:57

elbekko
Senior Member
Offline

From: Leuven, Belgium
Registered: 2005-06-14
Posts: 2,653

Re: impossible to add word to search index

See if it's already in?

foxmask · 2006-04-04 11:37

foxmask
Senior Member
Offline

Registered: 2005-11-30
Posts: 165

Re: impossible to add word to search index

elbekko wrote:

See if it's already in?

ho i did not think of it how stupid i am ...

any another suggestion from someone else ?

http://www.foxmask.info

Rickard · 2006-04-04 14:13

Rickard
PunBB Developer
Offline

From: 127.0.0.1
Registered: 2001-11-02
Posts: 9,167

Re: impossible to add word to search index

1. PunBB version?
2. UTF-8?

"Programming is like sex: one mistake and you have to support it for the rest of your life."

foxmask · 2006-04-04 14:17

foxmask
Senior Member
Offline

Registered: 2005-11-30
Posts: 165

Re: impossible to add word to search index

1 . punBB 1.2.11
2 . i dont know the encoding as i'm using mysql4

EDIT >
3 . MySQL 4.0
4. charset : LATIN1.

http://www.foxmask.info

foxmask · 2006-04-05 10:26

foxmask
Senior Member
Offline

Registered: 2005-11-30
Posts: 165

Re: impossible to add word to search index

the exported dump was from a MySQL 5 database in UTF-8 .

http://www.foxmask.info

foxmask · 2006-04-05 18:50

foxmask
Senior Member
Offline

Registered: 2005-11-30
Posts: 165

Re: impossible to add word to search index

as my new hosting use MySQL 4.0 ; i cant change the charset like that :
SET CHARACTER SET utf8
because MySQL 4.0 did not know this chartset yet.
utf8 is known since 4.1...

http://www.foxmask.info

Rickard · 2006-04-06 08:08

Rickard
PunBB Developer
Offline

From: 127.0.0.1
Registered: 2001-11-02
Posts: 9,167

Re: impossible to add word to search index

It's difficult to say really. We've encountered a similar problem before, but it was adressed. I would have to debug the error and see what actually happens.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

foxmask · 2006-04-06 08:18

foxmask
Senior Member
Offline

Registered: 2005-11-30
Posts: 165

Re: impossible to add word to search index

actually i've asked to my hosting provider if its possible that they upgrade from mysql 4.0 to 4.1 and i could change the charset to utf-8.
but now i really dont know how to fix the problem with a specific workarround or something.

http://www.foxmask.info

ImoTh3P · 2006-04-06 11:52

ImoTh3P
New Member
Offline

From: Paris, FR
Registered: 2006-04-06
Posts: 1

Re: impossible to add word to search index

Hi,

I could reply to you in french but as it's an english forum...

Are-you sure that the AUTO_INCREMENT parameter is still present for this table?

foxmask · 2006-04-06 12:03

foxmask
Senior Member
Offline

Registered: 2005-11-30
Posts: 165

Re: impossible to add word to search index

ImoTh3P wrote:

Hi,
I could reply to you in french but as it's an english forum...
Are-you sure that the AUTO_INCREMENT parameters is still present for this table?

yes :

Field        Type                     Null       Key                 Default        Extra
id              mediumint(8) unsigned           MUL                 NULL     auto_increment
word           varchar(20)                       PRI

http://www.foxmask.info

foxmask · 2006-04-06 20:15

foxmask
Senior Member
Offline

Registered: 2005-11-30
Posts: 165

Re: impossible to add word to search index

I think the problem is fixed :
what i did is :
i followed the rules explained on this page admin_maintenance.php and each time the process stopped with the previous message i returned to the admin_maintenance.php page added 1 to the next ID as explain and continued until the process finished correctly.

http://www.foxmask.info

foxmask · 2006-04-07 08:35

foxmask
Senior Member
Offline

Registered: 2005-11-30
Posts: 165

Re: impossible to add word to search index

Finally the problem is still here, i've made a post and got the error ...
as i'm fed up with this error i've dropped the call of the update_search_index of edit.php and post.php
Search engine will not work at all ...

http://www.foxmask.info

foxmask · 2006-04-11 12:17

foxmask
Senior Member
Offline

Registered: 2005-11-30
Posts: 165

Re: impossible to add word to search index

@Rickard : on punbb.fr someone give me the solution.
the column word was not in binary mode.
i've exported the schema with phpmyadmin 2.8 fon a mysql5.x and imported with phpmyadmin 2.8 to mysql 4.
the exported column was always with binary mode but not after the import step.

so what we need to keep in mind is the BINARY on the word column

regards.

http://www.foxmask.info

Rickard · 2006-04-12 20:01

Rickard
PunBB Developer
Offline

From: 127.0.0.1
Registered: 2001-11-02
Posts: 9,167

Re: impossible to add word to search index

Ah, yes. Now I remember. Someone else had a similar problem at one time. However, he used a different tool for migrating.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

impossible to add word to search index

Posts: 15

1 Topic by foxmask 2006-04-04 08:03

Topic: impossible to add word to search index

2 Reply by elbekko 2006-04-04 10:57

Re: impossible to add word to search index

3 Reply by foxmask 2006-04-04 11:37

Re: impossible to add word to search index

4 Reply by Rickard 2006-04-04 14:13

Re: impossible to add word to search index

5 Reply by foxmask 2006-04-04 14:17 (edited by foxmask 2006-04-05 10:26)

Re: impossible to add word to search index

6 Reply by foxmask 2006-04-05 10:26

Re: impossible to add word to search index

7 Reply by foxmask 2006-04-05 18:50

Re: impossible to add word to search index

8 Reply by Rickard 2006-04-06 08:08

Re: impossible to add word to search index

9 Reply by foxmask 2006-04-06 08:18

Re: impossible to add word to search index

10 Reply by ImoTh3P 2006-04-06 11:52 (edited by ImoTh3P 2006-04-06 12:18)

Re: impossible to add word to search index

11 Reply by foxmask 2006-04-06 12:03

Re: impossible to add word to search index

12 Reply by foxmask 2006-04-06 20:15 (edited by foxmask 2006-04-06 20:18)

Re: impossible to add word to search index

13 Reply by foxmask 2006-04-07 08:35 (edited by foxmask 2006-04-07 08:41)

Re: impossible to add word to search index

14 Reply by foxmask 2006-04-11 12:17

Re: impossible to add word to search index

15 Reply by Rickard 2006-04-12 20:01

Re: impossible to add word to search index

Posts: 15