MyBB Community Forums

Full Version: Recount of message isn't working
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2
Hi guys !

I didn't know where to put this topic (here or in the merge forum)..

My problem is the following :

I was on phpbb3 before (shame on me) and i wanted to go on mybb. I used the merge system, all the message and members have been copied BUT in their profile is displayed 0 messages.

I did many times "Recount User Thread Counts" and "Recount User Post Counts" but it change nothing...

Do you know how can I solve it ?

The link of the forum : http://ngm-team.fr/mybb/index.php
(i just installed it)

Thanks !

P.D : I wanted to congratulate you for this CMS who is widely better than phpbb, and do not bug each change (plugins, templates).
Do you have Post Count Enabled in the forums?
No it was on "OFF", i enabled it, recount, purge cache,... But all are always on 0..

UP ! Please help me, i have just this problem..
Have you executed all recount and rebuild tools?
Have you switched the setting above in all forums, including subforums?
Same trouble for me Big Grin (sorry)

I checked this point : just after MERGE SYSTEM only recount was correct in the table 'users' : my count number (postnum) is the only one filled correctly. The others were empty (0).

Where could I - in dashboard - activate / desactivate - the Post count for user ?? (nothing in dashboard / Forum and posts) dashboard / configuration ??
Thanks a lot Jones !

(2014-09-26, 09:26 AM)ArouG Wrote: [ -> ]Same trouble for me Big Grin  (sorry)

I checked this point : just after MERGE SYSTEM only recount was correct in the table 'users' : my count number (postnum) is the only one filled correctly. The others were empty (0).

Where could I - in dashboard - activate / desactivate - the Post count for user ?? (nothing in dashboard / Forum and posts) dashboard / configuration ??

You have to check this line in yours forums settings :

- Yes, posts in this forum should count towards user post counts
- Yes, threads in this forum should count towards user thread counts

Or execute this : UPDATE mybb_forums SET usepostcounts= 1,usethreadcounts= 1 WHERE usepostcounts= 0

And set the default value to 1 Wink

___________________


Just one other thing (I think isn't necessary to create a new topic) :

- I want to use the Mybb Database on my site. But the script i did, worked fine on phpbb, now it selects only some members and some admins... That's really strange... (i changed every field names between phpbb and mybb and checked it 1000 times)

If you want to look : http://ngm-team.fr/members.php
Normally it should be like this (except avatars) : http://ngm-team.fr/members-phpbb.php

Do you have any idea ?

Thanks !
That's likely caused by the gid which has changed during the merge.
Thanks Themiller12 ... I used the update request and all is good ( where can I, canaillou ?, set the defaut value to 1 : on dashboard, direct in database ? )

For your forum, I can't explain but ... I supposed you checked that uid from MyBB table users (mybb_users) are same than your phpbb database ? (as I'm concerned, merge system has deleted one user from my FluxBB table : 'Guest' - old_id=1) so all the members Id have changed. Perhaps it will help you ? )
Quote:That's likely caused by the gid which has changed during the merge.

Sorry but i don't understand... All the files have the same owner, and in the DB my users have the same permissions than phpbb...  And why the query selects only some lines ?

My code if it can help you..


						$year = date(Y);
						
						$group = '4';
						$group2 = '11';
						$group3 = '12';
						$group4 = '25';
						
						$admins = $Database->query("SELECT * FROM mybb_users WHERE (usergroup = '$group' OR usergroup = '$group2' OR usergroup = '$group3' OR usergroup = '$group4') ORDER BY usergroup");
							
						foreach($admins as $admin)
						{

							$id_user = $admin->uid;
							$infos = $Database->query("SELECT * FROM mybb_userfields WHERE ufid = '$id_user'");
							
							foreach($infos as $info)
							{

						?>
							<a href="http://ngm-team.fr/forum/member.php?action=profile&uid=<?php echo $admin->uid; ?>" style="color:#030303;text-decoration: none;">
							<div class="<?php if ($admin->usergroup == 4) { echo 'perso'; } else { echo 'perso2'; } ?>">
								<div class="<?php if ($admin->usergroup == 4) { echo 'bulle'; } else { echo 'bulle2'; } ?>" >
									<img src="<?php echo getavatar($admin->avatar); ?>" />
								</div>
								
								<div class="<?php if ($admin->usergroup == 4) { echo 'bio'; } else { echo 'bio2'; } ?>">
									<div style="position:absolute;right:10px;">
									<b>Pseudo :</b> <?php echo $admin->username; ?><br> 
									<b>Prénom :</b> <?php if(!empty($info->fid6)) { echo $info->fid6; } else { echo "N.C"; }  ?><br>
									<b>Age :</b> <?php if(age($admin->birthday) == $year) { echo '-'; } else { echo age($admin->birthday); } ?><br>
									<b>Skype :</b> <?php if(!empty($admin->skype)) { echo $admin->skype; } else { echo "N.C"; } ?><br>
									<b>Login TM :</b> <?php if(!empty($info->fid4)) { echo $info->fid4; } else { echo "N.C"; } ?><br> 
									<b>Login TM2 :</b> <?php if(!empty($info->fid5)) { echo $info->fid5; } else { echo "N.C"; } ?><br> 	
									</div>					
								</div>
							</div>
							</a>	
	
							<?php } } ?>
							
					<div class="clear"></div>
					</div>
				</div>

The phpbb table had innoDB engine, is it change something ? (but i changed to Myisam before to merge)

Thanks a lot for helping me !

________________________________________________________________________

@ArouG :

Go into the forum table, check this (sorry it's in French)

[Image: 1411828011-dsfsdf.jpg]

If the value are 0, so click on "Edit" and then put 1 as bellow :

[Image: 1411828011-fghfhfg.jpg]

For my forum, in the query i select everything from this table not only the uid ^^
Auncun souci pour le français Themiller12 : j'en suis un aussi Big Grin Big Grin

Sorry ... I was expected an option to chek / uncheck in the dashboard ... If someone create a new forum, I don't want to make a request in the table mybb_user to enable counter post each time Wink

... at last, Themiller12 : I've an SQLITE3 database Toungue
Pages: 1 2