I did the conversion, but seems that the boards imported have the smileys disabled by default for some reason.
If I create a new board, the smileys work fine.
Am I missing something somewhere?
Thanks :)
did you have the option that disable smileys in this post or something ticked ?
Go into phpMyAdmin
Click on your database. Then click smf_messages. Click the Structure tab.
In that table there should be under field column a row with the name "smileysEnabled".
If you look over to the right under the Default column and that is in the same row as the above field. Is the default set to 1?
Quote from: SleePy on September 26, 2008, 12:03:52 PM
If you look over to the right under the Default column and that is in the same row as the above field. Is the default set to 1?
Yes it is set to 1. Just set it to 0 and seems to have solved the issue.
Well I wasn't suggesting to change the default. Just wanted to know if it was some how different than a default install of SMF.
If you check through some of the messages, do the older ones have this set to 1 or 0?
You can run the following query which will enable smileys on all messages:
UPDATE smf_messages
SET smileysEnabled = 1;
Gotcha, that was my fault sorry.
Did the query and that fixed it. But did just notice that all the view counts for all messages were set to 0.
Well unless there is data in the mark read tables I don't think we can get this information back without converting again. Even that may not have total 100% data but may be better than nothing.
What version of yabb where you using btw? Just so I know which converter I am looking at.
Quote from: SleePy on September 28, 2008, 05:28:25 PM
What version of yabb where you using btw? Just so I know which converter I am looking at.
Currently v2.2.2 - I have no plans to upgrade it any further at this point.
Ahh so you where using the yabb 2.2 beta converter :)
Ok, I will look at that and see what is going wrong then. As it should of worked.
Anymore luck on this at all? Thanks :)
I think it was caused by a incorrect casting of a variable.
Do you need to convert again though? Unless we need to convert again I didn't want to make you break things to test the fix :P (I planned on testing it with a local yabb install I have of a big board and finding smiley posts to see if I fixed it.
I am fine with testing it.
I am keeping yabb active until it looks like I am good to go with SMF, then I start the joomla 1.5 integration to allow for single joomla and forum logins. :o Hope it can be done.
Try the attached file. I believe this fixed it.
If not I will need to see an example post of with and without smiles (just to compare them).
Will try this and let ya know in a bit. Thanks :)
Well no luck on the counts and the smilies are still disabled by default as well.
Asides from that, the last version you posted here ran without a hitch.
Do you have a sample post with and without smiles? The files themselves from yabb?
I have a feeling my logic was off but only seeing some other posts can I confirm that.
Quote from: SleePy on October 05, 2008, 01:17:08 PM
Do you have a sample post with and without smiles? The files themselves from yabb?
I have a feeling my logic was off but only seeing some other posts can I confirm that.
Mean like after the conversion? And also the source files for the conversion?
For before the conversion. I am wanting to see the Yabb message files.
I wanted to compare the message files with my logic I was using to attempt to find out if we where using smilies or not.
How would you like the files?
You can email them to me or pm me their contents. Which ever works.
I have some yabb posts but after looking at them myself I didn't see a difference in logic. So hopefully these will point out what Yabb is now doing to identify a smiley.
Quote from: SleePy on October 09, 2008, 03:34:24 PM
You can email them to me or pm me their contents. Which ever works.
I have some yabb posts but after looking at them myself I didn't see a difference in logic. So hopefully these will point out what Yabb is now doing to identify a smiley.
Tried sending an email got an error back and then pm'd you the stuff. Get any of it?
I didn't see a difference in the logic of those posts.. I think I fixed it though, I just reversed the logic check.
That seems to have fixed the smiley issues now. Thanks :)
Now some of the message counts are showing there are all 0 (zero).
Check it out Here (http://www.arizonatrailriders.org/smf/index.php) and you will see what I mean.
Thanks for all the help Sleepy! :)
If you go to forum maintenance in the admin panel, does clicking and running find and repair errors help fix this?
Tried that as well. No joy. Seems like reply counts are showing now it seems, but not the viewed counts. Weird.
Quote from: AzJose on October 19, 2008, 11:18:14 PM
Tried that as well. No joy. Seems like reply counts are showing now it seems, but not the viewed counts. Weird.
Bump. Any thoughts on this?
How many posts do you have on your forum? As well as topics?
I could make a script quickly to accomplish this. Knowing this will help me know if We can try and get away with running it without any timeout protection.
Quote from: SleePy on October 23, 2008, 12:37:24 AM
How many posts do you have on your forum? As well as topics?
I could make a script quickly to accomplish this. Knowing this will help me know if We can try and get away with running it without any timeout protection.
14290 Posts in 1742 Topics by 159 Members from the last recent conversion I did.
This script should fix all the replies.
It does no timeouts. I think we can get away without having timeouts. If we can't I can rewrite it to do this differently.
Goes in your SMF folder where SSI.php and Settings.php is. Run it from either your browser or command line.
No luck with that. Loads to a blank screen and no counts change.
Well I didn't give it any output. If it finishes loading then it should of finished.
What do you get if you run this in phpMyAdmin?
SELECT COUNT(ID_MSG) - 1 AS num_replies, ID_TOPIC
FROM smf_messages
GROUP BY ID_TOPIC
I ran this on a small test site and it worked fine for me to get the topic replies.
That shows all the topic replies.
But the view counts of the topics are not coming across.
So like 1 Topic for example on the yabb2 site has like 101 replies, and like 1117 views.. On the SMF site is has 101 replies and 19 views.
This seems to be the last issue I have before I can do a full swap to SMF :)
I may be using the wrong index.
Does,
replacing:
$views = !empty($views[2]) && $views[2] > 1 ? $views[2] - 1 : 0;
with
$views = !empty($views[3]) && $views[3] > 1 ? $views[3] - 1 : 0;
Fix this in the converter file?
looks like the file that contains the views data also contains the replied data. So I could make the converter get it from this as well during the conversion.
No luck with that change. Still get all zeros in the views.
and you ran the converter again?
Although looking at the file, I may have to alter how it works I think :| I think yabb changed the format of that file on us.
Quote from: SleePy on October 24, 2008, 11:40:29 AM
and you ran the converter again?
Although looking at the file, I may have to alter how it works I think :| I think yabb changed the format of that file on us.
Yep, ran the whole convert process again after changing that line of code you gave me.
Anymore thoughts on this?
Sorry, it has been very busy for me for a while now.
The following file I changed it so the .ctb file that exists in the messages folder is now used and it does a regex check to try and find the views entry.
No prob. I will try it and let ya know.
Thanks :)
No luck with that.
Here is the content of a ctb file for ya.
### ThreadID: 1084076403, LastModified: Thu, 19 Jun 2008 12:50:12 -0700 ###
'board',"news"
'replies',"8"
'views',"93"
'lastposter',"Joe_Plumber"
'lastpostdate',"1086312452"
'threadstatus',""
'repliers',""
I tested this one and it was able to pull the number out. it should work.
Sleepy you rock! That last version got it all done.
Thanks for all your help with this. If ya drink beer, consider your evening covered if ya ever come to Phoenix! 8)
Thanks Again!
Not a problem, thank you really. I know have those all debugged out and committed to svn. So for the next SMF release they will be fixed on our downloads page :)