Previous Thread
Next Thread
Print Thread
Hop To
Page 3 of 3 1 2 3
#263542 03/01/2020 7:04 PM
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads 7.7.4 has been released and is now available to download in the Member Area.

TOC / Overview
UBB.threads 7.7.4 Changelog
Upgrading To The Current Version of UBB.threads 7
What To Do Next? / Discussion


UBB.threads 7.7.4 Changelog
Version 7.7.4 includes several minor php 7.1+ and mysql 5.7+ code fixes, and It has been tested to be compatible with php 5.4 - php 7.4.

Primary Changes In This Release
  • Likes system with Likes summary pages for threads and users.
  • Major updates to the UBBT77 and UBBT77-Dark forum styles.
  • Post sharing menu for Facebook, Twitter, Reddit, Email.
  • Quick Search within the navigation-bar.
  • Threaded Mode topic tree updates.
  • Fixed new private message indicator.
  • Updated Member Profile page.
  • Posts can now be unapproved.
  • New user registration issues fixed.
  • RSS feed time and formatting issues fixed.
  • New sticky Control Panel breadcrumbs bar.
  • Control Panel data column sorting and zebra striping.
  • Additional information in the Member Editor.
  • Style Editor updates and fixes.
  • Improved Cache Manager.
  • Improved Database Backup.
  • Content Rebuilder is now faster.
  • Transition tool for unicode support (Asian characters and Emojis).
  • Added more friendly url formatting (SEO) to the urls.
  • Updated several libraries and assets.
  • Cleanup of templates, CSS files, and UBB JavaScript files.
  • More bug squashing and layout updates.


Summary of Changes
[NEW] UBB.threads has been tested to be compatible with php 5.4 - php 7.4.
[NEW] Posts can now be Liked. Settings are available to set how many per 24hr period, if they can like their own posts, display who else has liked the post.
[NEW] Complete Like summary page is available per thread, posts, and for each user.
[NEW] Post Likes are removed when a member account is deleted.
[NEW] Post Share drop-down menu has been added to each post. This menu includes: Copy post link to clipboard, Email Post, Report Post, Facebook, Twitter, and Reddit. It is configurable through the Control Panel > General > Social/Sharing Settings.
[NEW] Posts from Ignored Users will now be completely hidden and replaced with a link to toggle its display, for if the blocking member chooses to view it.
[NEW] The Print Thread output has been completely rewritten.
[NEW] Users can toggle password visibility for login form input.
[NEW] New Member Registration emails now display additional information of stored Member IP addresses. Using the GEO-IP lookup API, the member's country and continent are displayed in addition to the their ISP and its general location, and if their connection type was mobile or broadband.
[NEW] Quick Search within the navigation-bar will now present a drop-down entry box for easier searching.
[NEW] Topic Tree for Threaded Mode display now marks the current post, and highlights any unapproved posted within the thread.
[NEW] Follow List Editor (Forums, Threads, Users) now have "Select All" and "Unselect All" buttons for easier management.
[NEW] Posts can now be Unapproved. This is useful for when moderators want to put a post "on hold" without pausing the entire thread for everyone.
[NEW] Unapproved posts are now preceded with a notice of the post status and a link to the "CP:Approve Posts" list page. A moderator may optionally choose to edit the individual post to approve it from that page also.
[NEW] Custom Islands are now each wrapped in their own custom div ID which is based on their island number in the CP (ex: div id="island2" would target Custom Island #2. They can now easily be targeted through CSS as desired.
[NEW] Upgrader will now recommend that if you are using styles from an older UBB.threads install, you should replace them with their current version. An additional step can automatically add the new style versions to your forum for you. They will be installed but they will not be active until you activate them within the forum Control Panel. You may skip and continue to the next upgrade step, but it is recommended that you update your styles, fixing any display errors which were since corrected.
[NEW] CP: Top/Breadcrumb bar is now sticky to the top.
[NEW] CP: Breadcrumbs presentation has been updated to include a link to your forum and link to your main site.
[NEW] CP: Member Editor now displays additional information of stored Member IP addresses. Using the GEO-IP lookup API, the member's country and continent are displayed in addition to the their ISP and its general location, and if their connection type was mobile or broadband.
[NEW] CP: Approving and Unapproving posts are logged to the Admin Log.
[NEW] CP: Post Likes Settings have been added (Control Panel > General), ie; Enable/Disable, Display Total and Member Names, How Many Names To Display, Allow Self-Likes, Display Only Active Members on Summary, Max Likes Per 24hrs. The defaults for each configuration item are also shown.
[NEW] CP: New Portal Islands are available, "Top Likes" and "Top Likes (30 Days)."
[NEW] CP: New Portal setting, "Total Members To Show In Top Likes."
[NEW] CP: Content Rebuilder now also rebuilds Post Like Counts for when you want all user like counts to reflect their current number of likes, and not how many they have ever liked. This is relevant for when liked posts are deleted/purged.
[NEW] CP: Content Rebuilder can now help transition your forum tables for full unicode support (utf8mb4) which will allow for Asian characters and Emojis to be used. 4-Byte UTF-8 Unicode requires MySQL 5.5.3 or above. It is highly recommend to create a database backup as the process cannot be undone.
[NEW] Added Clipboard library version 2.0.6.

[UPDATE] Member Profile page has been updated to clean up and improve its data presentation.
[UPDATE] Show/Hide Column(s) toggle has been moved to the Navigation Bar.
[UPDATE] Forum Help (FAQ) has been moved to the Footer bar.
[UPDATE] Forum search has been moved to the navigation-bar top-right.
[UPDATE] Show/Hide Columns has been moved to the navigation-bar top-right.
[UPDATE] Post Buttons for "Email Post" and "Report Post" have been moved to the Post Share drop-down menu. This creates addition space for the "Like" button and improves display on thin displays, such as smaller smart phones in portrait layout.
[UPDATE] "Search Engine Agents" is now "Robots (Crawlers)." The updated terminology also helps to cover web robots used for marketing, webpage screenshots, site monitors, feed generators, link checkers, web scrapers, misc tools, page speed tests, and vulnerability/virus checkers, in addition to the expected search engines.
[UPDATE] Mailer has had several language strings updated and corrected.
[UPDATE] RSS feeds for single forums and multi-forum bundles have been updated.
[UPDATE] Gallery Islands now display the gallery title and gallery author with the image thumbnail.
[UPDATE] Moved the left/body/right columns out of HTML tables and in to DIV containers.
[UPDATE] Add more browser window information to debug info in footer.
[UPDATE] Multiple updates to common.css to further correct (reset) and define common display ground rules across the major browsers.
[UPDATE] CP: Columns within the Style List, Member Searches, Subscription Transaction List, Portal Island Column Layout, Referer Log, Admin Log are now zebra-striped, have hover-over row highlighting, and columns are now sortable.
[UPDATE] CP: "Enable Spider-friendly URLs" is now "Enable Friendly URLs" because this function generates URLs that are easy to read and include words that describe the content of the webpage, which is useful to readers beyond web spiders.
[UPDATE] CP: General Settings now displays relevant general forum information together. Items were moved from the Primary Settings page to here.
[UPDATE] CP: Cache Manager will now also: update post view counters, purge pointers to moved topics that have expired, purge inactive users from who's online table, and purge expired bans.
[UPDATE] CP: Database Backup has been updated to utilize MySQL's escape function to pre-epend backslashes where needed. Using the data provider's escape function instead of addslashes() takes into account the character set used by the current connection to the database rather than PHP's.
[UPDATE] CP: Database Backup can now analyze and optimize tables as part of the backup task.
[UPDATE] CP: Database Information and Backup will now only work with tables which use the forum's configured database prefix (ex; ubbt_)
[UPDATE] CP: Content Rebuilder data blob limits have been increased to account for modern web server specifications running PHP 5.4+. This should further reduce the time needed for processing any of the rebuild actions.
[UPDATE] CP: Textarea entries, including Style Editor entries, will now have whitespace, tabs, new lines trimmed from their beginning and ends.
[UPDATE] CP: Member Manager saved queries will now have a default name if none was given to them during their creation.
[UPDATE] CP: The layout of Add New Forum & Edit Forum have been updated and now match each other.
[UPDATE] CP: Adding a new forum will now have default values populated for it.
[UPDATE] CP: Removed "Features > Max Width For Images Used In Posts" because the setting is obsolete. Since version 7.6.0, UBB.threads uses responsive layout based on the user's browser display width.
[UPDATE] CP: The display of more SQL queries (when debugging in enabled) has been added to more pages.
[UPDATE] Updated FontAwesome library from 5.10.0-11 to version 5.12.1.
[UPDATE] Updated Smarty library from 3.1.33 to version 3.1.34
[UPDATE] Updated TinyMCE from 5.0.12 to version 5.2.0.
[UPDATE] Many SQL queries within the PHP script files have been reformatted to be consistent with a modern standard. During this process, several queries were optimized and updated to support new stricter SQL versions and engine settings.
[UPDATE] Cleanup of several language strings, templates, CSS files, and all cache builder scripts.

[FIX] Long user names will now be wrapped if a space is not found within the name to wrap at.
[FIX] Category Titles now display within the breadcrumbs. This is in addition to the Forum Titles which are already displayed.
[FIX] Topic Tree for Threaded Mode display on mobile devices is fixed
[FIX] Creating a moved/merged pointer message when moving/merging threads no longer creates a bad URL pointer to its new location. (Thanks to Baldeagle for reporting this bug.)
[FIX] Custom Island Inserts appearing twice in Gallery Forums is fixed. (Thanks to ECNet for reporting this bug.)
[FIX] New User Registration "ICQ issue" where Twitter was configured as a required field would fail to add the new registration.
[FIX] Time formats used in RSS feeds now use proper ISO-8601 format rather than a timezone abbreviation.
[FIX] User posts/messages and subjects now have whitespaces (spaces, tabs, extra lines) stripped from their beginning and end.
[FIX] Additional (undesirable) trailing line breaks are now removed from post quotes, spoilers, lists, etc. Optionally; rebuild your Posts, Signatures, and Private Messages with the Content Rebuilder, to update your older posts.
[FIX] Many forum generated URLs have been updated to correctly use Friendly URLs, when enabled.
[FIX] CP: Style Editor preview now updates with the CSS from within the Extra Properties section.
[FIX] CP: Style Wrapper Editor is now fixed. You can now add, delete, and edit wrappers. The wrapper preview will also remember the current style being used within the wrapper preview. Creating a new wrapper will pre-populate the editor with default opening/closing HTML.
[FIX] CP: General Display > Maximum Table Width For All Screens issues fixed.
[FIX] CP: Member Manager saved queries which include Member Groups are now fixed. (Thanks to Ruben for reporting this bug.)
[FIX] CP: Subscription Transaction status will now display "NONE" if the item does not have a default status. (Thanks to Ruben for reporting this bug.)
[FIX] CP: Dashboard fixes to correct the display of long server information items.
[FIX] CP: Adding New Forums. New forums will now correctly save selected style you've chosen for them.
[FIX] CP: Approve Posts. Clicking on the post title now takes you directly to the post requiring approval.
[FIX] CP: Fix language string substitutions from within the language files which would get lost when using the language editor. (Thanks to Ruben for reporting this bug.)
[FIX] CP: Fixed the long standing bug of the Whos Online list being empty when an additional new line (blank line) was added to the end of the Robots/Crawlers (Search Engines) list.
[FIX] CP: (PHP 7.1+) Sending an exported result list of member email addresses has been fixed. (Thanks to Ruben for reporting this bug.)
[FIX] Fixed the installer/upgrader to create a proper "extra_css" section.
[FIX] Fixed New Private Message indicator flashing when there were no new private messages to read.
[FIX] Several minor HTML fixes throughout the templates.
[FIX] Several minor php 7.1+ and mysql 5.7+ code fixes.

6 members like this: Morgan, Slaz, Ravenfreak, Ruben, SD, Gizmo
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
Upgrading To The Current Version of UBB.threads 7
The upgrade path from UBB.threads version 7.5.6 continues to be to move to the most recent version of UBB.threads as they become available; such as 7.5.6 -> 7.7.4. There is no need to do an incremental update from 7.5.6 to 7.6.0 to 7.7.0 to 7.7.4...etc. You should update directly, to the most recent version of UBB.threads. This procedure is compatible with any version greater or equal to 7.5.6. For an older version, ask for help on the Community Support Forums.

Please do check UBB.threads current Requirements. Especially if your PHP/MySQL configuration is NOT sufficient, do not go further as the upgrade process will fail.

For routine incremental upgrades, refer to the UBB.threads 7 Upgrade Guide for directions on how to proceed.

[Linked Image]


If you are upgrading from a version older than the last version, review any special instructions listed within the Upgrade Instructions (/install/UPGRADE_INSTRUCTIONS.txt), from each version just above the version you are coming from. Normally there are no special instructions or they may explain a new feature for you to configure.

Special Upgrade Instructions for 7.7.4
No Special Upgrade Instructions for upgrading from 7.7.3 to 7.7.4

Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
What To Do Next?

Now go update your forums.

If you have already updated, leave a comment reply here. Your comments help us know if you found something that needs to be fixed, or what new features you like the most.

Happy UBBTing! grin


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
Isaac, I just upgraded to 7.7.4

I did not upgrade the styles as I had done that a week back when I imported all the update styles UBBT70-77
Hopefully you have not updated UBBT77 the last week.

Everything seems sofar to work fine.
Have one minor question?

We can now like Threads down to the left on the page beside the Tweet and Share buttons
We can also like individual posts

I have found out to use the top likes in portal page and to click on the link to see Like Summary, here is mine
http://www.britbike.com/forums/ubbthreads.php/ubb/like

Now I wonder what happens with the thread "Like" how do I see the result of that?

Quote
If a specific post was interesting or useful to you, we recommend that you Like that post. It tells the post author, and others, that you found the information valuable. Clicking Like is another way to let others know that you enjoy it without leaving a comment.

I found that I clicked on like a post button and then it does not show up cause I probably missed to "confirm" the like by clicking another time on a like button that pops up above the post. To me it seems unnatural to have to confirm a like click.

Last edited by Morgan; 03/09/2020 8:38 AM.

Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
feedback It seems that I can like my own thread but not my own post, the feature in CP is not ticked


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 16,301
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,301
Likes: 116
Originally Posted by Morgan
We can now like Threads down to the left on the page beside the Tweet and Share buttons
We can also like individual posts

I have found out to use the top likes in portal page and to click on the link to see Like Summary, here is mine
http://www.britbike.com/forums/ubbthreads.php/ubb/like

Now I wonder what happens with the thread "Like" how do I see the result of that?
The Like/Share buttons above the Quick Reply box are Facebook buttons; these are not involved at all in the calculation of the likes feature, which is a compilation of data in your ubbt_likes table.

You can "like" your own thread as it is attributing an activity to your Facebook account; whereas an admin must allow users to like their own content as it'll provide local statistics for liked content (and users liking their own content could skew any stats).


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
Thanks Gizmo that explains it.
I have only this feedback now
Quote
I found that I clicked on like a post button and then it does not show up cause I probably missed to "confirm" the like by clicking another time on a like button that pops up above the post. To me it seems unnatural to have to confirm a like click.
otherwise I like it a lot wink

Last edited by Morgan; 03/09/2020 1:15 PM.

Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 16,301
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,301
Likes: 116
The confirmation page is also the unlike this post page.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
I see Gizmo, I liked and unlike your post right now and had to confirm each time, forgive me but I believe it’s one step to much.

You don’t do that on other social media and maybe we could compare it with changing Styles at the bottom
When you change it you simply chose from the menu then it changes by itself you don’t have to confirm it by clicking on a button.

Hope you see my point and I hope I’m explaining correctly.
Cheers


Ps we have lots of older members and they appreciate simplicity. Me being used to computers missed to verify only because I was in a hurry or didn’t notice the confirmation button

Last edited by Morgan; 03/09/2020 1:31 PM.

Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
Not everyone uses Facebook. Especially in an attempt to retain web browsing privacy, some people choose to never deal with Facebook, and will use privacy tools to avoid them.

A short list of examples:
AdBlock, PrivacyBadger/EFF, DuckDuckGo PE, Facebook Container. Blocking third-party cookies, workplace/school networks/or at the OS's hosts level.

Forums which are private will be able to take advantage of the UBB.threads Like system without giving up the their user's browsing history privacy to an untold number of third-parties. Facebook is a company which uses a different privacy policy than your own forums. As a forum owner, you should give thought before enabling third-party Like/Tweet systems.

UBB.threads offers general settings for:
  • Post Like Settings - to configure how you want to enable the UBBT Like System within your forums.
  • Social/Sharing Settings - to configure social networking features which shares your content with third-parties social networking websites.


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
I fully see your point and understand it. I Intended only to give feedback about having to confirm the like by finding and click one extra time.

Thanks for the 7.7.4 I do appreciate all the work you guys put into it
Cheers


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
1 member likes this: isaac
Joined: Dec 2003
Posts: 6,566
Likes: 78
Joined: Dec 2003
Posts: 6,566
Likes: 78
Maybe I don't understand what this new tool was supposed to do.
Prior to upgrading
I am set for utf8 in the language file and https.is complete and the database is set at utf8_general_ci
But emojis don't work.

I upgraded to 7.7.4 today and in re builders I find.
Quote
Update All Tables to UTF8mb4
Configuration settings indicate that you have aleady completed this action.

So I can't run the tool because it is disabled.
And emojis give me most times a
Quote
?
One emoji saved in black and white

Using the win key

One other note when attempting to search the language files for the typo for aleady in the control panel I get:
Quote
Parse error: syntax error, unexpected '<', expecting end of file in /home4/mysite/public_html/ub/languages/english/faq.php on line 46

But I did find it manually in languages/english/admin/rebuildcontent.php


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
Originally Posted by Ruben
Maybe I don't understand what this new tool was supposed to do.
Prior to upgrading
I am set for utf8 in the language file and https.is complete and the database is set at utf8_general_ci
But emojis don't work.

I upgraded to 7.7.4 today and in re builders I find.
Quote
Update All Tables to UTF8mb4
Configuration settings indicate that you have aleady completed this action.

So I can't run the tool because it is disabled.

This feature is based on if you have the following setting enabled or not.
Control Panel > Paths & Database > Database

[Linked Image]

When you have it enabled, you have indicated that you've already transitioned your tables collations to utf8mb4 (eg. utf8mb4_general_ci), and thus, the transitioning tool is no longer needed. The message in the transitioning tool states the same.

Visit: Control Panel > Database Tools > Information
View the Collation column.
If the items within that column are not utf8mb4_general_ci, you need to:
1/ Disable (uncheck) the above setting.
2/ Run the transitioning tool.
3/ Follow the link at the bottom of the tool at completion which tells you to enable the setting you prematurely set.

---

Originally Posted by Ruben
One other note when attempting to search the language files for the typo for aleady in the control panel I get:
Quote
Parse error: syntax error, unexpected '<', expecting end of file in /home4/mysite/public_html/ub/languages/english/faq.php on line 46

But I did find it manually in languages/english/admin/rebuildcontent.php

That looks like it could be related to these from 2018.
https://www.ubbcentral.com/forums/u...-7-6-1-1-changelog-discussion#Post260756
https://www.ubbcentral.com/forums/u.../re-error-messages-what-to-do#Post262864

Originally Posted by isaac
It looks like your languages/english/faq.php file was not created successfully upon upgrade.

The solution is to copy the faq.php file (mentioned above) from your archive, in to the same directory path on your forum install.

example:
ubbthreads-XXX.zip/ubbthreads-XXX/languages/english/faq.php
to
YOURDOMAIN dot com/ ... /languages/english/faq.php


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
1 member likes this: Gizmo
Joined: Dec 2003
Posts: 6,566
Likes: 78
Joined: Dec 2003
Posts: 6,566
Likes: 78
Language file upload eazy peasy and fixed.

I did not know about the the other setting in Paths & Database
I will give that a try

But it was preset from the upgrade.

I went straight to rebuilders after the upgrade.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Dec 2003
Posts: 6,566
Likes: 78
Joined: Dec 2003
Posts: 6,566
Likes: 78
Perfect it worked fine once I knew about the primary setting in the database section.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
1 member likes this: isaac
Joined: Dec 2003
Posts: 6,566
Likes: 78
Joined: Dec 2003
Posts: 6,566
Likes: 78
Purring like a kitty cat.
On to the next site.
Thanks again.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
2 members like this: isaac, Gizmo
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
Originally Posted by Ruben
Purring like a kitty cat.
On to the next site.
Thanks again.

Excellent news! Thanks for your quick followup
Cheers


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
HI

7.7.4 feedback, on my BritBike forum and when clicking "Forum Help" I can't see
http://www.britbike.com/forums/ubbthreads.php/ubb/faq
any ideas?


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
Originally Posted by Morgan
7.7.4 feedback, on my BritBike forum and when clicking "Forum Help" I can't see
http://www.britbike.com/forums/ubbthreads.php/ubb/faq
any ideas?

From the post discussion in this thread, just above your post:

That looks like it could be related to these from 2018.
https://www.ubbcentral.com/forums/u...-7-6-1-1-changelog-discussion#Post260756
https://www.ubbcentral.com/forums/u.../re-error-messages-what-to-do#Post262864

Originally Posted by isaac
It looks like your languages/english/faq.php file was not created successfully upon upgrade.

The solution is to copy the faq.php file (mentioned above) from your archive, in to the same directory path on your forum install.

example:
ubbthreads-XXX.zip/ubbthreads-XXX/languages/english/faq.php
to
YOURDOMAIN dot com/ ... /languages/english/faq.php


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
Uploaded the faq.php and it helped, thanks!


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
1 member likes this: isaac
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
About Update All Tables to UTF8mb4
I have found that my mysql is set to "latin1_swedish_ci"
Have not dared yet to change it to utf8mb4_general_ci


1/ Disable (uncheck) the above setting.>>> it is already disabled
2/ Run the transitioning tool. >>> Have not found out where the transition tool is or how to run it
3/ Follow the link at the bottom of the tool at completion which tells you to enable the setting you prematurely set. >>> Have not found out where the transition tool is or how to run it

When I have more time soon I will look into it. Should I address it here or in a HOW do I topic elswhere.

Thanks

Last edited by Morgan; 03/13/2020 6:02 AM.

Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
Control Panel > Content Rebuilder > Transition Actions

The UTF8mb4 Transitioning Tool is located within the bottom section, just under the HTTP to HTTPS Transition Tool.

Quote
Update All Tables to UTF8mb4
Update database table collations to 4-Byte UTF-8 unicode language encoding (eg. utf8mb4_general_ci). 4-Byte UTF-8 Support requires MySQL 5.5.3 or above. Depending on the size of your forum and tables, this process may take a long time to complete.
Note: It is highly recommend to create a database backup as this process cannot be undone.


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
I found it Isaac,

When I decide to do it would this be the correct procedure?

FYI my database is
MySQL Version: 5.6.45, MySQL Database Size: 1.25 GB about 700.000 posts,
do you see any problems using the transitions tool for a database of this size???

1, Close board
2, Backup database
3, wait for how long so all database table closes?
4, Control Panel > Content Rebuilder > Transition Actions, click on Update All Tables to utf8mb4_general_ci
5, Confirm that table collations are utf8mb4 (eg. utf8mb4_general_ci) before enabling.
6, Go to Control Panel > Paths & Database >database > enable MySQL Full Unicode Support (utf8mb4)
7, open board

Last edited by Morgan; 03/13/2020 9:14 AM.

Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
Following the recommendation in the item's description, make a backup of your database

1/ Run the transitioning tool.
This will close your forum for you while the tool is running.
When it is done, it will re-open your forum.
2/ Upon completion, follow the page link at the bottom of the page which tells you to now enable the "MySQL Full Unicode Support" setting.

The time that the transitioning tool takes for processing is based on many factors that i would have zero way of being able to answer for you. Once it is started, it will display items as it progresses through them. The item which will take the longest is the posts table. you'll know when you get to it because the page will continue working - the display will look paused, but its still working. When done, it will tell you its done. I've run the tool on a 2.5gb DB in under 5 minutes, and then rerun it on a restored backup for a completion time of under 10 minutes. But that was a shared WINNT machine with MariaDB 10.4. The tool changes your table's collation. It does not change your data. But a backup is always advisable when you work on your entire database.


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
Thank you for taking time to explaing how it works.
I'll probably do it tomorrow now I'm heading no to drive a Zamboni Ice resurfer for 8 hours.
Don't ask what your local community can do for you..ask what you can do for them and they might hit you with a Zamboni.
Does it makes a man to look cooler..?
Cheers

Last edited by Morgan; 03/13/2020 9:48 AM.

Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
California is on the eve of lockdown (coronavirus)

Have fun and stay safe outside thumbsup


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
Looks like the virus stroke us too so I'm home again
I closed the forum
backed up database
Content Rebuilder > Transition Actions, click on Update All Tables to utf8mb4_general_ci
collation tables are the new
however the page not green ok's but not the last chunk uf paypal texts andthere is no instruktion below how to proceed
but when I open a new browser window it seems to have open the board

I have not yet dared to enable eg. utf8mb4_general_ci in Control Panel Paths & Database
however when I click on
Confirm that your table collations are utf8mb4 (eg. utf8mb4_general_ci) before enabling.

all tables say utf8mb4_general_ci

so do you think its safe to enable the MySQL Full Unicode Support (utf8mb4) ?


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
it looks like it does not finish the paypal_data table, it does not tic it ok with a green emoji and nothing after that.

however all tables seems to be changed in database tools section I have another window open.

Last edited by Morgan; 03/13/2020 12:34 PM.

Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Dec 2003
Posts: 6,566
Likes: 78
Joined: Dec 2003
Posts: 6,566
Likes: 78
For me here is a test to try:
Create a post or reply.
In the message body add a emoji via:

WINKEY + . Meaning press the windows key and dot at the same time
A popup will appear with windows emoji list

and select some save the post and see if they work.

Last edited by Ruben; 03/13/2020 12:45 PM.

Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
it does not work

see http://www.britbike.com/forums/ubbthreads.php/topics/801057/test#Post801057

first I had not enabled the box for MySQL Full Unicode Support (utf8mb4)

when I did that I only saw three forums and could not enter those


oh I have safari Apple sp windows key... I don't follow sorry


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
I have clicked once again to start the transitioning tool but it appears to stop during the paypal conversion


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
Am I supposed to be worried
Databas was 1,25 GB is now 1,09GB


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Dec 2003
Posts: 6,566
Likes: 78
Joined: Dec 2003
Posts: 6,566
Likes: 78
Originally Posted by Morgan
it does not work

see http://www.britbike.com/forums/ubbthreads.php/topics/801057/test#Post801057

first I had not enabled the box for MySQL Full Unicode Support (utf8mb4)

when I did that I only saw three forums and could not enter those


oh I have safari Apple sp windows key... I don't follow sorry
I think it is done I tried a test post at your site and 4byte emoji's work.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Dec 2003
Posts: 6,566
Likes: 78
Joined: Dec 2003
Posts: 6,566
Likes: 78
Your site works for me.
Originally Posted by Morgan
Am I supposed to be worried
Databas was 1,25 GB is now 1,09GB

I did not look at the screen in that detail.While it updated to utfmb4.
But it probably ran a repair or optimize which would (defrag the database)


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
I cannot enable the utf8mb4_general_ci in Control Panel Paths & Database if I do nothing works..

It was a very long time since I optimized the database 😱

Last edited by Morgan; 03/13/2020 5:28 PM.

Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Dec 2003
Posts: 6,566
Likes: 78
Joined: Dec 2003
Posts: 6,566
Likes: 78
On my 2nd site I had to edit phpini and set the max_execution_time = 120
max_input_time = 120
Because it was so big.
But it still took a while to get a result from the re builder page


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Dec 2003
Posts: 6,566
Likes: 78
Joined: Dec 2003
Posts: 6,566
Likes: 78
BTW isaac
All the email headers and footers seem to be working correctly now.
All footer and header info fully populated.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
1 member likes this: isaac
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
Originally Posted by Ruben
On my 2nd site I had to edit phpini and set the max_execution_time = 120
max_input_time = 120
Because it was so big.
But it still took a while to get a result from the re builder page

My max_input_time is LOCAL 60 and Master Value 120
and same for max_execution_time

Comments?

Last edited by Morgan; 03/13/2020 5:49 PM.

Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Dec 2003
Posts: 6,566
Likes: 78
Joined: Dec 2003
Posts: 6,566
Likes: 78
Originally Posted by Morgan
I cannot enable the utf8mb4_general_ci in Control Panel Paths & Database if I do nothing works..

It was a very long time since I optimized the database 😱
Maybe it is a cookie /cache issue.
I test posted your site and it accepts 4byte unicode emojies now.

We posted on top of each other
when in the re builders screen and you click on utf8mb4 there is no progress bar ,you just need to wait till you get a confirmation screen.
It is a large screen with a lot of scrolling.
To get to the bottom with the clickable links.
If you get a error or no confirmation maybe you need to nudge your php script time up a bit.
Like from 60seconds to 120
I had to do that on my second site which is a slightly large forum

But I would change it back to default afterwards.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
Ruben, I otimized the last posts table in PHPMyAdmin as it timed out here.
I notice that emoji symbols don't work when I enable foull mysql support it looks like this 🎯 🎖🏅🙏 ✌️👀
but when disabled it shows emojis


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
Originally Posted by Morgan
... it appears to stop during the paypal conversion

If there is no error displayed, It does not end the task at the ubbt_PAYPAL group. It completes working on that table, then it processes the next items in a group containing ubbt_POSTS (the next table group, alphabetically) and works on that for what may seem like a long time to you. You did say your tables were within the 1.5GB range. just wait until it completes. If there is an error during the process, a notice will be displayed. If there is no error, the tool is still working.

[Linked Image]

Originally Posted by Morgan
Am I supposed to be worried
Databas was 1,25 GB is now 1,09GB

When it completes, you may notice that they are reduced in size. From latin1_swedish_ci to utf8mb4_general_ci, your previous character-set collation index column value had 255 characters.

In the case of utf8mb4, 1 character = 4 bytes, the limit is around 191 characters. So only 191 characters will be added to index, other characters will be truncated from the index. (255 vs 191 = 64 fewer)

When you change encoding from latin1_swedish_ci (at that time it was 1 character = 3 bytes) the indexed limit was around 255 characters. It means your column value, all 255 characters, will be moved to the index without truncating.

For utf8mb4_general_ci, the characters from the index decreased from 255 characters to 191 characters, so the total index size was also decreased.

Last edited by isaac; 03/13/2020 10:41 PM. Reason: added further clarification

Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Jun 2006
Posts: 16,301
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,301
Likes: 116
Also to note during testing prior to this tool, converting the tables BY HAND for a client took me ~6 hours to process an 8gb posts table... It shouldn't *just stop* it should continue chugging along at that data.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
Thanks Gizmo.
Your numbers are an good example for this thread thumbsup

--

To further expand on my previous post:

Visit Control Panel > Database Tools > Information.
View the totals at the bottom of the listing.
Data + Indexes = Database Size
This is how the database size on this page and on the Control Panel's dashboard is calculated.

example:
[Linked Image]


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
I was confused
The page did not change for hours but
The board was re open and all 66 tables had the new collation.
I tried several times to make new transition.

Ok I understand now that I was supposed to have left it alone. I got the expectation that it should go
Faster after reading isaacs previous example.

Shall I make a new transition with the tool and leave it until it runs through? Even if it takes let say 24 hours or more?


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
I did start the transition tool again 10 min after above post ruffly 4 hours has passed now and still same result as before. I will let it run on an on and keep that browser window open and computer is on all the time.
I see so far in another window that Database table has decreased to 1.08 GB

I'll keep you informed.


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
11 hours now and nothing has happened since last post. tick tack.. 😅


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Dec 2003
Posts: 6,566
Likes: 78
Joined: Dec 2003
Posts: 6,566
Likes: 78
What browser are you using.
To be honest I had always been an advocate of firefox.
But with recent updates it has become problematic at my bank, social security and insurance sites.
In win 10 there is edge which people think is internet explorer but it is not. It works better on some sites for me.
Since you are on apple safari. You may want to try a different browser like chrome or something else and see if it works better.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
I tried Safari yesterday and Firefox today with same result
I have also google which I can try tomorrow’s
After I have given Firefox 24 hours run.


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 16,301
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,301
Likes: 116
Does it still display the icon asif a page is still loading? Has it ever finished processing the posts table?


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
Gozmo,
Yesterday using Safari after a few seconds it shows several sections and after each section a green tic.
Last section read

ALTER TABLE ubbt_PAYPAL_DATA MODIFY `SUBSCR_DATE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `PAYMENT_DATE` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `SUBSCR_EFFECTIVE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `ITEM_NAME` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `BUSINESS` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `ITEM_NUMBER` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `PAYMENT_STATUS` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `MC_GROSS` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `PAYMENT_CURRENCY` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `TXN_ID` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `RECEIVER_EMAIL` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `RECEIVER_ID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `QUANTITY` char(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `NUM_CART_ITEMS` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `FIRST_NAME` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `LAST_NAME` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `PAYMENT_TYPE` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `PAYMENT_GROSS` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `PAYMENT_FEE` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `SETTLE_AMOUNT` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `MEMO` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `PAYER_EMAIL` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `TXN_TYPE` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `PAYER_STATUS` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `ADDRESS_STREET` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `ADDRESS_CITY` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `ADDRESS_STATE` char(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `ADDRESS_ZIP` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `ADDRESS_COUNTRY` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `ADDRESS_STATUS` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `TAX` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `OPTION_NAME1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `OPTION_SELECTION1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `OPTION_NAME2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `OPTION_SELECTION2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `INVOICE` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `CUSTOM_ID` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `NOTIFY_VERSION` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `VERIFY_SIGN` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `PAYER_BUSINESS_NAME` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `PAYER_ID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `MC_CURRENCY` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `MC_FEE` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `EXCHANGE_RATE` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `SETTLE_CURRENCY` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `PARENT_TXN_ID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `PENDING_REASON` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `REASON_CODE` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `SUBSCR_ID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `PERIOD1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `PERIOD2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `PERIOD3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `AMOUNT1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `AMOUNT2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `AMOUNT3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `MC_AMOUNT1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `MC_AMOUNT2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `MC_AMOUNT3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `RECURRING` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `REATTEMPT` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `RETRY_AT` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `RECUR_TIMES` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `USERNAME` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, MODIFY `PASSWORD` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;



There was no green tic and nothing changed over time.


Today I used Firefox and exactly same result even after 13 hours now. In Firrefox I noticed for a few seconds that an icon was working and then it stopped.
Nothing happened after that nothing that indicates that it is working.. nothing.

I have not dared to do anything caused it was mentioned that it is working in the background.
I'm still waiting for the firefox page to change..


Oh forget to mention that when I look in Database tools the collation reads correct for all tables
and if I enable MySQL Full Unicode Support (utf8mb4) I can only see three private forums out of 35 in total but I cannot open any so
the box is disabled.
Attachments
Screen Shot 2020-03-14 at 21.40.44.jpg

Last edited by Morgan; 03/14/2020 4:44 PM.

Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Dec 2003
Posts: 6,566
Likes: 78
Joined: Dec 2003
Posts: 6,566
Likes: 78
If it were me.

If it appears to keep getting stuck on one table.(IE paypal_data)
Why not do a repair and or optimize on that table. Prior to running the tool.
You can do that via phpmyadmin.
At least it will usually provide some info on errors for the table.
But make a backup first of the database.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 16,301
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,301
Likes: 116
What entries does your Admin Log (/admin/admin_log.php?returntab=1) show regarding the conversion? IIRC it should print when the action starts and ends.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
I think over all I have five logs like this

four from yesterday and one today, remember I'm 9 hours a head of you

2020-03-14 08:08:30 Morgan aka Admin xxx.xxx.xxx.xxx DB_COLLATION 66 tables converted.

above must be when I clicked and started the conversion


there is no ends

Last edited by Morgan; 03/14/2020 5:00 PM.

Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 16,301
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,301
Likes: 116
2020-03-14 08:08:30 Morgan aka Admin 217.215.63.166 DB_COLLATION 66 tables converted.

This only displays when the utility has completed.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
OK I have made a new back up now,
Should I test to optimize the paypal table first if so can I do it in CP database tools or should I do it in PHPMyAdmin?


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 16,301
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,301
Likes: 116
Why are you doing it repeatedly? The logs state its already been completed, quoting you now:
Originally Posted by Morgan
2020-03-14 08:08:30 Morgan aka Admin xxx.xxx.xxx.xxx DB_COLLATION 66 tables converted.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
Are you saying its finished despite the transition tool stopped working correctly?


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 16,301
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,301
Likes: 116
The log entry states it has completed; you would only get this message if it finished. Further, if ALL tables report utf8mb4_general_ci its further proof it completed.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
That is good news and it was not easy to understand as the
enable MySQL Full Unicode Support (utf8mb4) does not work which I have said here several times.
Are we not supposed to enable enable MySQL Full Unicode Support (utf8mb4) ?
in Control Panel >> Paths & Database >> MySQL Full Unicode Support (utf8mb4)

If I enable it cripple the forum and show only 3 out of 35 forums which I cannot enter.
Also Emoji's are not shown properly but they do when disabled

Last edited by Morgan; 03/14/2020 5:10 PM.

Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
Gizmo, Ruben,

It appeared to be an "extended character" bug. I got help from a magic wand and voila it works now.
Thank you Isaac I am ever so grateful! 🙏

Last edited by Morgan; 03/14/2020 6:11 PM.

Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Dec 2003
Posts: 6,566
Likes: 78
Joined: Dec 2003
Posts: 6,566
Likes: 78
I hear your pain.
I re-ran the tool on my site to make screen prints.
The DB size is 731.75MB

Also I still have my php max execution time large and it ran faster the second time but
Here it is:
Attachments
Screenshot (3).png Screenshot (4).png Screenshot (5).png Screenshot (6).png Screenshot (7).png Screenshot (8).png Screenshot (9).png


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
1 member likes this: Morgan
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
I took a look at your logs and saw the following

Code
2020-03-13 15:31:36 Morgan ... DB_COLLATION 	66 tables converted.
2020-03-13 16:15:56 Morgan ... DB_COLLATION 	66 tables converted.
2020-03-13 16:23:49 Morgan ... DB_COLLATION 	66 tables converted.
2020-03-13 17:27:20 Morgan ... DB_COLLATION 	66 tables converted.
2020-03-13 18:26:24 Morgan ... DB_COLLATION 	66 tables converted.
2020-03-13 18:32:46 Morgan ... DB_COLLATION 	66 tables converted.
2020-03-13 21:07:47 Morgan ... DB_COLLATION 	66 tables converted.
2020-03-13 21:23:55 Morgan ... DB_COLLATION 	66 tables converted.
2020-03-14 07:08:30 Morgan ... DB_COLLATION 	66 tables converted.

Those 9 lines tell me that the table conversion was run and completed 9 times.

1st time, latin1_swedish_ci to utf8mb4_general_ci
2nd time, utf8mb4_general_ci to utf8mb4_general_ci
3rd time, utf8mb4_general_ci to utf8mb4_general_ci
4th time, utf8mb4_general_ci to utf8mb4_general_ci
...
9th time, utf8mb4_general_ci to utf8mb4_general_ci

I dont see this as being a problem, since its just taking the current data collation and replacing it with itself.

What I do see as a problem is the following:

Originally Posted by Morgan
oh I have safari Apple

Safari failed to keep the communication open between your computer and the webserver. So while your webserver was still running and processing data updates to be sent to your screen, Safari already closed the communication and stopped displaying those updates to you. Safari timed out before the communication was complete.

Your admin log files say the task finished successfully, but Safari prevented the real-time display of that important bit of information from getting to you.

Maybe there is an updated Safari version which resolves that? If not, my advice would be to upgrade to a modern browser.


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
Originally Posted by Ruben
Also I still have my php max execution time large and it ran faster the second time but
Here it is:

Not everyone has access to "max_execution_time", so it has been set right within the script, and only for that single script.

If you need to increase this time for any reason, you can easily do that by updating the values as desired.

Find that setting within forums/admin/convertcollation.php
around line 34
Code
// This process may require more time, so we will extend it here
// 600 seconds = 10 minutes
ini_set('max_execution_time', 600);
set_time_limit(600);
Webhosts normally default this to either 30, 60, or 120 seconds for all scripts. We are setting this to 600 seconds just for this single script.


NOTE: Your webhost may not appreciate you taking more time than what they have set per each script, so do not expect to run this task more than once. In fact, this should only ever be run one time, and then you are through with the tool laugh

Check your admin log to confirm that your task was completed, and you're not needlessly running the same process over and over.


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Dec 2003
Posts: 6,566
Likes: 78
Joined: Dec 2003
Posts: 6,566
Likes: 78
Originally Posted by Morgan
Gizmo, Ruben,

It appeared to be an "extended character" bug. I got help from a magic wand and voila it works now.
Thank you Isaac I am ever so grateful! 🙏
I don't know what that means without some specific information.

But I suspect that Isaac is on track with a browser issue
As I hinted to in a earlier post.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
Originally Posted by Ruben
Originally Posted by Morgan
Gizmo, Ruben,

It appeared to be an "extended character" bug. I got help from a magic wand and voila it works now.
Thank you Isaac I am ever so grateful! 🙏
I don't know what that means without some specific information.

NOTE: This was absolutely unrelated to UBB.threads 7.7.x.

Morgan had an random extended character inserted to his USERS permissions. It has probably been there since a very early version of the software or from an upgrade made from a version of 15+ years ago.

What I did to solve his issue was:
With temporary access granted from Morgan:
1/ I went to his: Control Panel > Groups
2/ Clicked [Site] permission for USERS group
3/ Then I clicked the bottom button, "Update This Group's Permissions".
The forum list started displaying correctly again.
I did this for each one of his groups. I did not changed anything else.

What this did was just rebuild any missing or any using bad (such as spaces or extended characters) user group permission settings.


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
Hi Again,

After yesterdays struggle and the help I received
There was a question in our shoutbox today
Why is some characters corrupt

example the word "Don't " in a topic has become "Don’t"
so above is one question How can I fix the bad characters?

the second thing is after that just now I was browsing the Control Panel >>Content Rebuilder and managed to click accidental on "Rebuild Posts" link
Instinctively I clicked to back page to avoid it to start rebuilding.
However I can see in the logs that REBUILD_POSTS Action Started.
It closed the board for maintenance so now I guess I will have to wait for a long time for it to process or? its 690000 posts.
any comments on this unfortunate click? I cannot see that it runs a process since I closed the page...

Last edited by Morgan; 03/15/2020 11:34 AM.

Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
As written, the transition tool only converts the table collation. The data was not converted. This means that all characters going forward will be stored in the new character set. All prior data containing extended characters are from your previous character collation, and will remain as such.


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
As for your second question -

When you accidentally clicked on another link (unrelated to the transition tool), the "REBUILD_POSTS Action Started" you see in your Admin Log is stored with the time/date/details when that action is started.

The action goes through the entire task of doing what it was instructed to do.

When complete, it is then followed up with another log entry of when the action is finished.

Because you canceled that action in mid-task, there will not be an "Action Finished" log entry.


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
Originally Posted by isaac
As for your second question -

Ok and when complete will the forum open again or will it remain closed? it is still closed.

About the first question. The transition tool is one thing the other was enabling the MySQL Full Unicode Support (utf8mb4) I think that it might have changed the characters. it did for the emojis before the bug was removed.
Is there a way to fix those now?
Thanks

Last edited by Morgan; 03/15/2020 11:55 AM.

Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
When it runs, it will reopen the forum again.

Any action that closes the forum to process, will reopen it is when done processing.

The reason for the two log entries, is to be useful in knowing/logging how long the task took from start to finish.


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
1 member likes this: Morgan
Joined: Jun 2006
Posts: 16,301
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,301
Likes: 116
Note that closing a rebuild once it has begun will usually stop the transaction, it generally will not continue and since it'll never hit the end of the transaction it'll never auto open your forum automatically...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
Hi Gizmo, I clicked on the Rebuild Posts and instantly hit to open previous page (Back page) It has now gone 2 hours and 15 min since then.
The forum is still closed.

The posts table contains 690.000 posts,
What is the recommendation for me to do now.

Wait some more time or hit Rebuild posts again or just open the forum? Or anything else..
You and Isaac seems to have different opinion about it so I'm all ears.
Thanks


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 16,301
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,301
Likes: 116
My advice, open the forum and stay out of that section, it's for advanced maintenance and not all tools are as friendly as allowing you to just back out.

You backed out of the rebuild, and THAT rebuild tool does steps incrementally, so it will not process further as additional redirects aren't instructing your browser to issue additional sets of instructions.

Short answer: Your forums are only closed because the rebuild closed them and can't complete the task and turn them back on as you closed the tool.

These are advanced maintenance tools that should be run to completion, and only when you know what you're doing... It is directly maintaining your database...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
It is now almost 3 hours and still closed so I'll take your advice and re-open the forum.


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
Originally Posted by Morgan
It is now almost 3 hours and still closed so I'll take your advice and re-open the forum.

if it is still processing and the pages are refreshing and the numbers are progressing, then it is working.

if it is not doing any of that, then it is stalled, and it never completed.

these type of database rebuilding tools have no "working in background" options. they close your forums for a reason.

again, if your current page is not refreshing every two to five seconds while displaying indication of progress, then it is not doing anything.


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
Hi Isaac, No it never refreshed cause I hit back page direct before it started to show anything. The logs in CP logged it but the web page never started to refresh or show anything. Forum is open now and I posted a reply so it works.

Thanks


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
About corrupted characters after changing collation and enabling MySQL Full Unicode Support (utf8mb4) in Control Panel >> Paths & Database
Example, Apostrophes becomes "’"

Is there a way to fix this? it seems all older posts then March 14th has "’" and new posts are correct.
I know there are more types of characters that are corrupted also but not how many kinds yet.

Thanks for your advice

Last edited by Morgan; 03/17/2020 5:11 AM.

Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
Originally Posted by Morgan
About corrupted characters after changing collation and enabling MySQL Full Unicode Support (utf8mb4) in Control Panel >> Paths & Database
Example, Apostrophes becomes "’"

Is there a way to fix this? it seems all older posts then March 14th has "’" and new posts are correct.
I know there are more types of characters that are corrupted also but not how many kinds yet.

Two options are:
A) restore your the backup you made and retain your older database collation.

Originally Posted by isaac
As written, the transition tool only converts the table collation. The data was not converted. This means that all characters going forward will be stored in the new character set. All prior data containing extended characters are from your previous character collation, and will remain as such.

or

B) find/replace and/or... continue forward with UTF8, knowing that all of your new posts from the day you choose to convert would be the first day of using modern database encoding standards with your character set.

Defaults in MySQL 8.0
Old Default: latin1
New Default: utf8mb4

Quote
The default value of the character_set_server system variable and command line option –character-set-server changes from latin1 to utf8mb4. This is the server’s default character set. UTF8MB4 is the dominating character encoding for the web, and this change will make life easier for the vast majority of MySQL users. The upgrade from 5.7 to 8.0 will not change any character set for any existing database objects. But unless you specify character_set_server back to your previous default or explicitly set the character set then a new schema/table/column will by default be in utf8mb4. We recommend users to move to utf8mb4 whenever possible.
Source: https://mysqlserverteam.com/new-defaults-in-mysql-8-0/

Further reading:
Debugging Character Set Issues by Example
http://mysqlserverteam.com/debugging-character-set-issues-by-example/


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
Isaac you wrote,
Quote
Two options are:
A) restore your the backup you made and retain your older database collation.
or
B) find/replace and/or... continue forward with UTF8, knowing that all of your new posts from the day you choose to convert would be the first day of using modern database encoding standards with your character set.

Defaults in MySQL 8.0
Old Default: latin1
New Default: utf8mb4

I didn't know that I would get corrupted characters when I converted to utf8mb4. I noticed now when opened the PHPMyAdmin that the General settings is "Server connection collation is utf8mb4_unicode_ci" and of course the britbike database is utf8mb4_general_ci.
About the below options
A, does not seems to be an option to keep the old collation as the future is here right..
B, find/replace and/or... don't understand what you mean however if I cannot change ’ into ' in the database.
My simple not by the book quick fix for this after some thinking was Control Panel >> Features >> Active text.. adding following row
Quote
’|'
and it seems like a short term quick fix.
Now it at least looks right. Is this the only thing I can do do you think?

Hmm I wonder what happen if I ask my host to change MYSQL Version 5.6.45 to 5.7 or greater

Last edited by Morgan; 03/17/2020 8:17 AM.

Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 16,301
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,301
Likes: 116
Simply put, the characters from your old characterset don't "hold the same place" as they do in the new (here is an example showing the placement of different values in the Windows 1252 characterset), hence why you see the artifacts.

You could find the relation of the different artifacts and find/replace in the database OR activetext, or you could just live with it like countless other communities have done after converting.

Depending on your character set and the language used on your forums (Asian languages for example use quite a bit of non-Latin characters) there may be a lot more items than I'm including in the below list; but some common characters are:
Code
“ = left quote = “
” = right quote = ”
‘ = left single quote = ‘
’ = right single quote = ’
— = en dash = –
– = em dash = —
• = hyphen = -
… = ellipsis = …


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
Hi Giz, looks like I need to use activetext
’ = right single quote = ’ I guess this is the most common used.
Thanks for the info I may be back asking more.
cheers
Morgan


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
Hi Isaac,
I do like 7.7.4

I have mentioned it in a previous post and now
I forward the same from our members.
Some like and some don’t like the like feature. That’s just fact as we different.
I like it absolutely!

Quote
Sure is a fuss to click "Like", then you have to "OK" the Like, then you have to wait to get back to the post you liked... Oh well, everything else is just fine.

Above is members feedback.

I would like in the future if possible be able to like with one click.
see above as a luxury request.
Thanks for efforts.
Cheers


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
Thank you for the feedback.

This is the first public release of the UBB.likes system. You can count on adjustments happening to it over some time.

Again, thank you. thumbsup


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
1 member likes this: Morgan
Joined: Feb 2017
Posts: 44
A
Newbie
Newbie
A Offline
Joined: Feb 2017
Posts: 44
How do I make the forum fluid width?

Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
Originally Posted by AstroCat
How do I make the forum fluid width?

The same as it has always been:
Control Panel > General: Maximum Table Width For All Screens

Examples:
100% (for full width)
1200px (for a fixed max-width)


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Feb 2017
Posts: 44
A
Newbie
Newbie
A Offline
Joined: Feb 2017
Posts: 44
I did not know that but I do now thanks.

Joined: Dec 2008
Posts: 42
Likes: 3
D
Newbie
Newbie
D Offline
Joined: Dec 2008
Posts: 42
Likes: 3
After the upgrade today, I noticed the Attachment Manager popup window no longer show little thumbnails for the uploaded images, but much larger versions. See screenshot:

[Linked Image]

The same window on this forum still shows the little icon sized images for uploaded photos.

What do I need to do to get back to the little icon size images?

Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
Originally Posted by Digitalgas
What do I need to do to get back to the little icon size images?

Make sure you have uploaded /styles/common.css to your forum from the UBB.threads 7.7.4 install package
https://www.ubbcentral.com/doc_upgrade7.php#prepare

Then refresh the page/your browser cache.


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Jun 2006
Posts: 16,301
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,301
Likes: 116
Also ensure that if your utilizing a CDN (such as Cloudflare) that you're clearing your full cache with them after an upgrade, as they cache resources.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
1 member likes this: isaac
Joined: Dec 2008
Posts: 42
Likes: 3
D
Newbie
Newbie
D Offline
Joined: Dec 2008
Posts: 42
Likes: 3
Thanks, guys.
I made sure the current /styles/common.css was in there and cleared my cache. Now I'm seeing the normal small image icons in the Attachment Manager box. *Breathing Easier*
I like the embed attachment option. I hope my forum members who are less than tech savvy can figure it out. wink I'm writing a tutorial for them.

Joined: Dec 2008
Posts: 42
Likes: 3
D
Newbie
Newbie
D Offline
Joined: Dec 2008
Posts: 42
Likes: 3
After the upgrade, my Portal page Post Island for Recent Posts will only display 5 recent posts even though I have had it configured for 12 posts. Is there something else I need to do now. Apparently users like to have the 12 posts.

[Linked Image]

Here's my Portal page:
http://www.oldgas.com/forum/ubbthreads.php

Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
Originally Posted by Digitalgas
After the upgrade, my Portal page Post Island for Recent Posts will only display 5 recent posts even though I have had it configured for 12 posts. Is there something else I need to do now. Apparently users like to have the 12 posts.

Thanks for reporting this bug.

It looks like the "if not set, lets set it now" was unintentionally removed. ie; the default became the always-set setting.

The good thing is that there is an easy fix for this.

For post islands in 7.7.4
Around line 32 in /forum/cache_builders/post_island.php
FIND:
Code
// Maximum number of posts to display
$limit = 5;

REPLACE WITH:
Code
// Maximum number of posts to display
$limit = (!$items) ? 5 : $items;

This will be fixed in the next release. Thank you smile


EDIT:
For gallery islands in 7.7.4
Around line 24 in /forum/cache_builders/gallery_island.php
FIND:
Code
// Maximum number of images to display
$limit = 5;

REPLACE WITH:
Code
// Maximum number of images to display
$limit = (!$items) ? 5 : $items;


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
3 members like this: driv, Digitalgas, Gizmo
Joined: Dec 2008
Posts: 42
Likes: 3
D
Newbie
Newbie
D Offline
Joined: Dec 2008
Posts: 42
Likes: 3
Thanks for the help. I'll make the edit.
Got to keep my people happy. smile

1 member likes this: isaac
Joined: Dec 2008
Posts: 42
Likes: 3
D
Newbie
Newbie
D Offline
Joined: Dec 2008
Posts: 42
Likes: 3
One of my users just told me that the "Notify" button is gone from the row of buttons at the bottom right of each post.

[Linked Image]

Is there anything I can do to get it back? My users do click on it to tell me about objectionable posts. Helpful.

Thanks.

Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
Its in the post drop-down menu

[Linked Image]

2 members like this: Digitalgas, Gizmo
Joined: Dec 2008
Posts: 42
Likes: 3
D
Newbie
Newbie
D Offline
Joined: Dec 2008
Posts: 42
Likes: 3
I didn't notice the arrow icon for the drop-down menu. Nice features available there.
Thanks for the quick help!

2 members like this: Gizmo, isaac
Page 3 of 3 1 2 3

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Version 7.7.5 Images suddenly not displaying
by Stovebolt - 05/04/2024 11:19 AM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
Who's Online Now
0 members (), 403 guests, and 121 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20240506)