Add prefix to the whole forum?

[kbilly]

Yes, you are right.

Those two threads have been created yesterday and they got the prefix after i ran the command yesterday.

But the problem is if all lines have got a prefix, then why is it now showing?

   

I ran

SELECT * FROM `mybbmm_threads` WHERE `prefix` = "0" ORDER BY `fid` 

It isn't showing me the threads which are not having prefix in the forum (fid 10).

[kbilly]

Anyone?

[Crazycat]

I did a try: update mybb_threads set prefix=1 WHERE prefix=0 and fid=2
All threads in forum 2 without prefix setted are now with my prefix #1.

[kbilly]

The command is correct, i re-ran it and it added the Prefix but only to the threads created in the last few days when i created the new prefix as before i didn't have this prefix on my forum.

So, the problem remains that it is adding the prefix to the newly created threads but not to all threads which are already there and created since the forum is created.

   

[Crazycat]

That's weird.
What gives select prefix, count(DISTINCT(tid)) as nb from mybbmm_threads where fid=10 group by prefix ?

[kbilly]

This:


   

EDIT: Problem solved.

So,let me explain what happened, i ran the wrong command here

That means while using the command

UPDATE mybbmm_threads SET `prefix` = "12" WHERE `prefix` = "0" AND `fid` = "10";

I should have used prefix = 14 instead of prefix = 0.

By using the command you suggested, i understood the problem and solved the problem.

I would like to thankyou and thanks to ExiTus too for helping me out.

Both + repped.

Regards.