UBB.threads PHP Forum Software Community Forums News and Releases Announcements UBB.threads 6.4 Officially Released to the Member Area

Version 6.4 adds many highly requested features to UBB.threads, including a calendar, a total rewrite of the polling system, a new avatar system, and much more.

For future versions, we will no longer be offering languages other than English in the Member Area. Language files will be found for swap or trade in the UBBCentral.com "Trading Post"(Opening Soon). This will allow more people to get involved and more languages to become available.

</font>

• <font size="" face="">Added a new calendar system that can be used for showing public/private events and birthdays. Along with the calendar we have added finishing touches such as birthday icons next to user's names on their birthday.</font></li>
• <font size="" face="">Added in the ability to delete a group that is no longer needed.</font></li>
• <font size="" face="">Added in an option when viewing a user's profile to ignore this user. Posts from ignored users will still be shown to preserve the flow of a conversation, however the body of ignored user's posts will be set to "You are ignoring this user."</font></li>
• <font size="" face="">Added a new option to allow users to select from a predefined set of avatars for their picture, similar to the way this is done in UBB.classic and UBB.x.</font></li>
• <font size="" face="">Added an option when creating/editing a forum to select an image to be displayed next to the forum on the main page.</font></li>
• <font size="" face="">Moved all thread management tools out of the edit post screen and down to the bottom of showflat/showthreaded to tidy the page and make the controls more centrally located.</font></li>
• <font size="" face="">More work on efficiency. Added a configurable caching system to cache some things that don't change that often. This caching system will be expanded in subsequent versions to further increase efficiency.</font></li>
• <font size="" face="">Polls are entirely rewritten. Polls now can have multiple questions, a start and end time, and other options. Unlike the public beta, in this final release polls are upgraded properly.</font></li>
• <font size="" face="">Added in an option to save database queries that are used frequently from the admin section.</font></li>
• <font size="" face="">Reworked and expanded the search engine, adding many new options including keyword and advance search queries.</font></li>
• <font size="" face="">Further efficiency work done on the queries in showflat, show threaded, and poslist.php.</font></li>
• <font size="" face="">"Mark all read" and "my Cookies" is now in "My Home".</font></li>
• <font size="" face="">Added a new table cell on the postlist page to display the hot topic icons, sticky posts, posts with polls, closed topics, or posts with attachments.</font></li>
• <font size="" face="">Added a new icon on the postlist screen in the new table cell that helps designate topics that are attached to a calendar event. Thanks to Joshpet for the image.</font></li>

<font size="" face="">

Rick's entire changelog for version 6.4 can be found posted here.

Rick, could you give an approximate time when the 6.5 changelog will be posted?

My guess would be in February.

I have my suggestions ready here

We have version 6.2.2 and want to upgrade to 6.4.

After reading posts, searching through the
FAQ and knowledgebase we see that we are to
refer to UPGRADING.html. But that document only
tells us how to upgrade from 6.0.1 to 6.0.2.

Where to we download the upgrades?

The upgrading.html file should have instructions for upgrading from all versions. Basically you should just need to scroll down to version 6.2.2 and then work your way up to the top of the file.

For anyone that has upgraded and noticed their forums are starting to slow down it could be a couple of indexes were not created properly. You can check your database with the following sql command:

SHOW KEYS FROM w3t_last

Your results from that command should look like this:


Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment
w3t_Last 0 PRIMARY 1 L_Uid A
w3t_Last 0 PRIMARY 2 L_Board A 163


If they do not then you'll need to close your board and then run 2 more queries.

DELETE FROM w3t_Last

ALTER TABLE w3t_Last
ADD PRIMARY KEY Last_index(L_Uid,L_Board)

This will make it so every post for every user is unread. But this will create the indexes properly and you should see the speed benefits of 6.4.

After you run those 2 commands you can re-run the SHOW KEYS FROM w3t_Last command again to make sure that they got created properly.

[This message was edited by Rick Baker on December 11, 2003 at 07:55 AM.]

I have a question about this "Trading Post" at UBB Central where the language files will be at. Will the current language files other than English be thrown out completely, forcing everyone to retranslate every language file? Or are you saying that the language files will be moved to UBB Central, but won't be updated any further? Because I would rather translate just what hasn't already been translated in my particular language files than translate all of it. Any clarification on this, Ted, would be appreciated.
Happy Holidays,
don Julio

I also have complaints about the speed.

I have ran:

DELETE FROM w3t_Last

ALTER TABLE w3t_Last
ADD PRIMARY KEY Last_index(L_Uid,L_Board)

But the 2nd set of SQL commands do not work, it doesnt like the 2nd line and I get the error:

SQL ERROR: Unable to do_query: ALTER TABLE w3t_Last ADD PRIMARY KEY Last_index(L_Uid,L_Board)
Multiple primary key defined row(s) affected by your query.

Now the result shows a 0 for the first check..

Is this going to bugger everything up now?

Thanks

The current threads option:
dosearch.php?Cat=&Forum=All_Forums&Words=&Match=Entire+Phrase&Old=1day&Limit=25

Now takes ages, whereas it used to run immediately.. this might be related to the above, but im not so sure as it is still doing it..

Any ideas

Ok, try this:

ALTER TABLE w3t_Last DROP PRIMARY KEY

DELETE FROM w3t_Last

ALTER TABLE w3t_Last
ADD PRIMARY KEY Last_index(L_Uid,L_Board)

If that still doesn't work, submit a trouble ticket so I can take a look at it.

We're also experiencing severe slowdowns on Fredtalk immediately after installing 6.4. I've checked the indexes, and they're fine.
We notice that, at times, UBB has several select queries locked in MySQL. Is it supposed to be locking the tables when it does a select?

Here's the Mysql processlist during a slowdown:
| 3451 | mysql | localhost | ubb | Query | 14 | Copying to tmp table | SELECT t1.B_Number,t1.B_Main,t3.U_Username,t1.B_Subject,t1.B_Posted,t1.B_Board,t3.U_Color,t1.B_Reged |
| 3452 | mysql | localhost | ubb | Query | 13 | Locked | UPDATE w3t_Users
SET U_Laston = 1071250485,
U_TempRead = ' |
| 3453 | mysql | localhost | ubb | Query | 12 | Locked | SELECT U_Display, U_Groups, U_Sort, U_View, U_PostsPer, U_TempRead, U_FlatPosts, U_TimeOffset,U_Acti |
| 3454 | mysql | localhost | ubb | Query | 10 | Locked | SELECT U_Username, U_Password,U_Signature,U_Picture,U_Groups,U_Display,U_Language,U_Totalposts,U_Tit |
| 3455 | mysql | localhost | ubb | Query | 10 | Locked | SELECT U_Display, U_Groups, U_PostsPer, U_PicturePosts, U_FlatPosts, U_TempRead, U_TimeOffset,U_Show |
| 3456 | mysql | localhost | ubb | Query | 7 | Locked | SELECT U_FrontPage, U_Groups, U_TimeOffset,U_Display,U_Favorites,U_WhichForums,U_Categories,U_TimeFo |
| 3457 | mysql | localhost | ubb | Query | 7 | Locked | SELECT U_Display, U_Groups, U_PostsPer, U_PicturePosts, U_FlatPosts, U_TempRead, U_TimeOffset,U_Show |
| 3458 | mysql | localhost | ubb | Query | 6 | Locked | SELECT U_EReplies,U_TextCols,U_TextRows,U_Preview,U_Groups,U_Username,U_Password,U_SessionId, U_Styl |
| 3459 | mysql | localhost | ubb | Query | 5 | Locked | SELECT U_Display, U_Groups, U_Sort, U_View, U_PostsPer, U_TempRead, U_FlatPosts, U_TimeOffset,U_Acti |
| 3460 | mysql | localhost | ubb | Query | 3 | Locked | SELECT U_FrontPage, U_Groups, U_TimeOffset,U_Display,U_Favorites,U_WhichForums,U_Categories,U_TimeFo |
| 3461 | mysql | localhost | ubb | Query | 3 | Locked | SELECT U_TimeOffset,U_Groups,U_TimeFormat,U_Username,U_Password,U_SessionId, U_StyleSheet, U_Status, |

Thanks Rick, those commands worked and ill see if the users are any more happy.

The latest threads issue now takes even longer, and it has just taken 20 seconds before anything happened on that, which is people are moaning about. <img border="0" title="" alt="[Frown]" src="images/icons/frown.gif" />

Chris, those locks definitely shouldn't be tying up the tables like that. The one that I'm wondering about is copying to temp table as that will end up locking the table until it's finished.

Can you add debug=1 to end of a couple of the urls, like the last 50 posts link and see what type of debug info you get.?

And if possible, please start a new thread in the UBB.threads Assistance forum. Too many people posting in one thread and it gets a bit confusing <img border="0" title="" alt="[Wink]" src="images/icons/wink.gif" />

Matt, can you try the same thing. Click on the latest threads link and then add &debug=1 to the end of the address bar and load the page again. Also, can you post this in a new thread in the Assistance forum? <img border="0" title="" alt="[Wink]" src="images/icons/wink.gif" />

I have the same problems.
I tried above queries, but get this error on the last one:

SQL ERROR: Tue, Dec 16 2003 13:35:04 +0100 Unable to do_query: ADD PRIMARY KEY Last_index(L_Uid,L_Board)
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ADD PRIMARY KEY Last_index(L_Uid,L_Board)' at line 1 row(s) affected by your query.

The forums are extremely slow now. Sometimes there fast, but that is mostly when there is only a few visitors.

I have filed a support ticket, but I guess Infopop is very busy on correcting these problems. No answer to this specific problem yet.

Regards,

Ron

[This message was edited by www.Sat4all.com on December 16, 2003 at 06:07 AM.]

It looks like you forgot the ALTER TABLE w3t_Last part. The full query looks like this:

ALTER TABLE w3t_Last
ADD PRIMARY KEY Last_index(L_Uid,L_Board)

I did now (I am quit sure I did before) and get this result:

SQL ERROR: Tue, Dec 16 2003 19:54:29 +0100 Unable to do_query: ALTER TABLE w3t_Last ADD PRIMARY KEY Last_index(L_Uid,L_Board)
Duplicate entry '31355-dreambox' for key 1 row(s) affected by your query.

Brett is probably taking a look at this issue and our savvier performance problems now:-)

Have a nice day,


I have some problems, (sorry my english is not so fine)

6.3.2 -> 6.4
I had new install UBB Thread 6.4 international.
Restore the database.
Run the altertable-6.3-6.4.php .. there is an I Change the error in line 1 - from <_? to <?
and it works fine.

After translate the languagefiles, the forum www.mein-tierforum.de works fine.

But the subscriptions.php doesn´t work. Cronjob works perfect with the 6.3.2 Release.

Error:

Parse error: parse error in /............./cron/php/subscriptions.php on line 164

What can I do?

The new calender:

There is the option: yearly, monthly ... I miss weekly !!!!!!!!! who can I do this?

Thanks a lot and greetings from germany

Stan

</font><blockquote><font size="1" face="">quote:</font><hr /><font size="" face="">Originally posted by stanluga:
But the subscriptions.php doesn´t work. Cronjob works perfect with the 6.3.2 Release.
</font><hr /></blockquote><font size="" face="">The fix is posted here in the bugs forum. <img border="0" title="" alt="[Smile]" src="images/icons/smile.gif" />

Hallo Joshpet,

thank you... I should use my glases.....

Regards

Stan

[]Rick, could you give an approximate time when the 6.5 changelog will be posted?

My guess would be in February.

I have my suggestions ready here [/]

[:"red"] Well, any info on the 6.5 changelog?[/]

<img src="https://www.ubbcentral.com/boards/images/graemlins/grin.gif" alt="" />

Good things come to those who wait. <img src="https://www.ubbcentral.com/boards/images/graemlins/wink.gif" alt="" />

Or.... It will be posted when you see it...... <img src="https://www.ubbcentral.com/boards/images/graemlins/laugh.gif" alt="" />

That too. <img src="https://www.ubbcentral.com/boards/images/graemlins/wink.gif" alt="" />

[:"blue"] BTW, we should open a chit-chat forum here [/]

No - the "Just Conversation" and "Just Conversation II" forums are going to stay at Infopop Community so that everyone can still chat together. <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" />

So what causes teh \ to be inserted in someone's name or user title ? I have seen it happen intermittently and now I see it with Ted O\'Neill What's up with that??

All the infopop community posts were imported here as anonymous users. That was just a bug in thier conversion from one system to another. Moving forward we all have registered usernames so it won't be an issue.
Old posts were just all copied here for reference. <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" />

Hmm Josh, I have an 'orginal' install, with never having been backed up and I have users who just 'show up' all the sudden with / in their names (Much like Ted ONeil did) Which is why I was asking <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" />

Then you'd need to post details here as a bug report. This is an announcment thread and they are not monitoring issues posted as replies here.

Make sure to include all the details... version, link to problem etc...

The slash situation here is unique to infopop given the import from OpenTopic/Eve and not really anything to do with the consumer product.