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.
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.
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
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.
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
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.
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).
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.
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
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.
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
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
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
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.
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.
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
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.
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
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) ?
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
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
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
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
... 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.
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/20209:41 PM. Reason: added further clarification
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.
Thanks Gizmo. Your numbers are an good example for this thread
--
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.
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?
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
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
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.
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
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.
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?
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.
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
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.
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
Check your admin log to confirm that your task was completed, and you're not needlessly running the same process over and over.
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.
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...
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.
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.
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
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...
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
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...
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.
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.
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.
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
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 = …
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
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
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:
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?
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.
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. I'm writing a tutorial for them.
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.
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
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;
![[Linked Image]](https://www.ubbcentral.com/forums/ubbthreads.php/ubb/download/Number/3076/filename/0.main.png)
![[Linked Image]](https://www.ubbcentral.com/forums/ubbthreads.php/ubb/download/Number/3197/filename/20200312_16-07-43.PNG)
![[Linked Image]](https://www.ubbcentral.com/forums/ubbthreads.php/ubb/download/Number/3198/filename/20200313_15-36-14.PNG)
![[Linked Image]](https://www.ubbcentral.com/forums/ubbthreads.php/ubb/download/Number/3200/filename/20200313_19-39-40.PNG)
![[Linked Image]](https://www.ubbcentral.com/forums/ubbthreads.php/ubb/download/Number/3216/filename/UBB-UploadBox.jpg)
![[Linked Image]](https://www.ubbcentral.com/forums/ubbthreads.php/ubb/download/Number/3218/filename/UBB-PostIsland.jpg)
![[Linked Image]](https://www.ubbcentral.com/forums/ubbthreads.php/ubb/download/Number/3228/filename/UBB-PostButtons.jpg)
![[Linked Image]](https://www.ubbcentral.com/forums/ubbthreads.php/ubb/download/Number/3230/filename/20200406_15-02-18.PNG)
