Previous Thread
Next Thread
Print Thread
Hop To
Error on Insert into POSTS
#263913 06/07/2020 8:09 PM
Joined: Dec 2004
Posts: 46
Likes: 2
jjjjj Offline OP
Newbie
OP Offline
Newbie
Joined: Dec 2004
Posts: 46
Likes: 2
I am not sure if this is a bug, or possibly configuration issue.

I am seeing errors when the users are inserting records into POSTS that have an apostrophe in them, ex, the work "can't" would fail. In the logs, this is what I see I am seeing <92> replacing an apostrophe, and then seeing an incorrect string value below. Is there a configuration in php, or mysql that I don't have correct? or is this a bug?

INSERT INTO
ubbt_POSTS
(POST_PARENT_ID, TOPIC_ID, POST_IS_TOPIC, POST_POSTED_TIME, POST_POSTER_IP, POST_SUBJECT, POST_BODY, POST_DEFAULT_BODY, POST_IS_APPROVED, POST_ICON, POST_HAS_POLL, POST_HAS_FILE, POST_MARKUP_TYPE, USER_ID, POST_PARENT_USER_ID, POST_ADD_SIGNATURE, POST_LAST_EDITED_TIME, POST_POSTER_NAME, POST_MD5)
VALUES
(153023, 17905, 0, 1591546837, '208.90.218.178', 'Posts title', 'as I can<92>t talk about this it ', 'as I can<92>t talk about this it', 1, 'book.gif', '0', '0', 'none', 8, 104, 1, 0, 'mrb', '')
- Incorrect string value: '\x92t tal...' for column 'POST_BODY' at row 1

Doing some looking around, it may have to do with the character set. Could someone check to see if I need to change the character_set_database to utf8mb4?


Database changed
mysql> SHOW VARIABLES
-> WHERE Variable_name LIKE 'character\_set\_%'
-> OR Variable_name LIKE 'collation%';
+--------------------------+--------------------+
| Variable_name | Value |
+--------------------------+--------------------+
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8mb4 |
| character_set_server | utf8mb4 |
| character_set_system | utf8 |
| collation_connection | utf8mb4_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8mb4_general_ci |
+--------------------------+--------------------+
10 rows in set (0.01 sec)

Re: Error on Insert into POSTS
jjjjj #263914 06/08/2020 2:20 PM
Joined: Dec 2003
Posts: 6,183
Likes: 28
Offline
Joined: Dec 2003
Posts: 6,183
Likes: 28
Well not sure what you did to convert to utf8mb4.
If you tried outside of the tool included with UBB. or what.
But what are the tables collations?
If it was set correctly then a simple test for 4 byte characters is try the windows emoji shortcut in a post
Which is hold down the win key then press the period key
Then click on the images you want to post
😊💋😁🐱‍🚀
It should post the image.
If not then it is not setup for 4 byte characters correctly

Last edited by Ruben; 06/08/2020 2:21 PM.

Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: Error on Insert into POSTS
jjjjj #263915 06/08/2020 3:17 PM
Joined: Dec 2003
Posts: 6,183
Likes: 28
Offline
Joined: Dec 2003
Posts: 6,183
Likes: 28
Just as a guide all the tables should be utf8mb4_general_ci
The database should be utf8mb4_general_ci
Here is your query from a site that is working:
character_set_client utf8mb4
character_set_connection utf8mb4
character_set_database utf8mb4
character_set_filesystem binary
character_set_results utf8mb4
character_set_server latin1
character_set_system utf8
collation_connection utf8mb4_general_ci
collation_database utf8mb4_general_ci
collation_server latin1_swedish_ci


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: Error on Insert into POSTS
Ruben #263917 06/10/2020 10:22 PM
Joined: Dec 2004
Posts: 46
Likes: 2
jjjjj Offline OP
Newbie
OP Offline
Newbie
Joined: Dec 2004
Posts: 46
Likes: 2
Thanks Ruben, I updated the tables, and everything seems to be working. I am not seeing the insert errors anymore.

Re: Error on Insert into POSTS
jjjjj #263952 06/28/2020 3:12 PM
Joined: Dec 2004
Posts: 46
Likes: 2
jjjjj Offline OP
Newbie
OP Offline
Newbie
Joined: Dec 2004
Posts: 46
Likes: 2
I thought this was resolved, but I am still seeing errors in the mysql log when people use an asterisks.
INSERT INTO ubbt_POSTS...
Script: /home/dbs/ubbthreads/frame/scripts/addpost.inc.php - Line: 491
Incorrect string value: '\x92

UPDATE ubbt_FORUMS...
Script: /home/dbs/ubbthreads/frame/libs/content_rebuild.inc.php - Line: 418
Incorrect string value: '\x92

Here are my database char settings
SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_n
ame LIKE 'collation%';
+--------------------------+--------------------+
| Variable_name | Value |
+--------------------------+--------------------+
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | utf8mb4 |
| character_set_server | utf8mb4 |
| character_set_system | utf8 |
| collation_connection | utf8mb4_general_ci |
| collation_database | utf8mb4_general_ci |
| collation_server | utf8mb4_general_ci |
+--------------------------+--------------------+
10 rows in set (0.00 sec)

In my php.info I am seeing default_charset UTF-8 UTF-8
Does this need to be updated?

Any ideas?

Re: Error on Insert into POSTS
jjjjj #263953 06/29/2020 12:23 PM
Joined: Dec 2003
Posts: 6,183
Likes: 28
Offline
Joined: Dec 2003
Posts: 6,183
Likes: 28
This is the second time I ask this.
Did you use the built in tool with UBB7.7.4 to convert to utf8mb4?
I ran it and it was plug and play.

Prior to the release of the tool I tried two manual attempts and made errors.
It is very easy to miss a step or apply a step in the wrong location.

I don't know if it is to late to run or not now for your case..

Last edited by Ruben; 06/29/2020 12:26 PM. Reason: Added Comment

Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: Error on Insert into POSTS
jjjjj #263954 06/29/2020 12:26 PM
Joined: Dec 2004
Posts: 46
Likes: 2
jjjjj Offline OP
Newbie
OP Offline
Newbie
Joined: Dec 2004
Posts: 46
Likes: 2
Yes, I used the built in tool, and the option now is not selectable in the GUI, assuming it has detected this. Is this possible a platform issue? I can enter posts with asterisks, but some of the forum users are running into this? Is there a per user/group setting that might cause this?

Last edited by jjjjj; 06/29/2020 12:28 PM.
Re: Error on Insert into POSTS
jjjjj #263955 06/29/2020 12:36 PM
Joined: Dec 2003
Posts: 6,183
Likes: 28
Offline
Joined: Dec 2003
Posts: 6,183
Likes: 28
Then why did you need to go back in and change it again?
To solve the first problem
.
The directions are clear in Control Panel > Paths & Database..

Quote
MySQL Full Unicode Support (utf8mb4)
Sets the character set when sending data from and to the database server to utf8mb4 (full unicode support). Confirm that your table collations are utf8mb4 (eg. utf8mb4_general_ci) before enabling.

MySQL by default only uses a three byte encoding and so values in the four byte range (eg. Asian characters and Emojis) can not be stored. Any attempt to enter a text that contains four byte characters will result in those characters being returned as errors. MySQL does provide full four byte UTF-8 support, but it requires certain database settings to be configured. Converting to utf8mb4_unicode_ci is preferred. 4-Byte UTF-8 Unicode requires MySQL 5.5.3 or above.

Before you do anything again I would suggest you wait for a response from the programmers.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
1 member likes this: isaac
Re: Error on Insert into POSTS
Ruben #263956 06/29/2020 12:45 PM
Joined: Dec 2004
Posts: 46
Likes: 2
jjjjj Offline OP
Newbie
OP Offline
Newbie
Joined: Dec 2004
Posts: 46
Likes: 2
Thanks, I will wait to hear from the programmers. This is not a 4 byte issue, it is asterisks, eg I'm causing problems, and it seems to be either platform or user specific. I can enter asterisks in my posts, I am thinking that something that masks the ticks in the sql statements is broke.

Re: Error on Insert into POSTS
jjjjj #263957 06/29/2020 2:05 PM
Joined: Dec 2003
Posts: 6,183
Likes: 28
Offline
Joined: Dec 2003
Posts: 6,183
Likes: 28
The only forum setting I am aware of that may be different from a admin and users may be , allow ubbcode and allow html for posts.
It is not recommended to allow html posts for anyone.
But usually everyone allows users UBB Code posts.

While waiting what I would do is first goto phpmyadmin and make sure every table is set to utf8mb4_general_ci and the database is set to utf8mb4_general_ci.

And report back if at least any of that was incorrect.
But don't change anything yet.

To make the tool run again it is just a couple of simple clicks on UBB cp but I refrain from saying so till you hear from the experts.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: Error on Insert into POSTS
jjjjj #263958 06/29/2020 2:10 PM
Joined: Jun 2006
Posts: 15,956
Likes: 31
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,956
Likes: 31
Could you please supply the data you're attempting to post? You say it's erroring out on an asterix (*) however the last error that you posted is showing \x92 which is an apostrophe.

There isn't any filtering that happens server side for some users that don't for others, unless you're allowing HTML postring.

Additionally, could you open the offending table and take a screenshot of the table structure so we can validate that the cells are indeed utf8mb4_general_ci

Do you have SQL logging enabled?


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!
Re: Error on Insert into POSTS
jjjjj #263959 06/29/2020 2:27 PM
Joined: Dec 2004
Posts: 46
Likes: 2
jjjjj Offline OP
Newbie
OP Offline
Newbie
Joined: Dec 2004
Posts: 46
Likes: 2
I have logging turned on, and you are correct, the * is not the problem it is the apostrophe.
From the logs

Script: /home/dbs/ubbthreads/frame/scripts/addpost.inc.php - Line: 491
INSERT INTO
ubbt_POSTS
(POST_PARENT_ID, TOPIC_ID, POST_IS_TOPIC, POST_POSTED_TIME, POST_POSTER_IP, POST_SUBJECT, POST_BODY, POST_DEFAULT_BODY, POST_IS_APPROVED, POST_ICON, POST_HAS_POLL, POST_HAS_FILE, POST_MARKUP_TYPE, USER_ID, POST_PARENT_USER_ID, POST_ADD_SIGNATURE, POST_LAST_EDITED_TIME, POST_POSTER_NAME, POST_MD5)
VALUES
(0, 17928, 1, 1593347421, '50.89.134.149', 'PC 6/27 otherside', 'Left the dock @4:30, saw the weedline in 150� and kept running east. Saw the first pack of birds 6 miles from the corner and got a double knockdown the lines got wrapped so we only got one of the two fish. Gave the pack a few more passes w/ no luck before turning NE to run to the buoy. We get about 25 miles from the buoy and find a nice pack of birds and catch two bigger fish. It�s now 2pm and we have to turn for the 3hr ride home.

Awesome day. First time catching 3 YFT on my boat and certainly didn�t expect it the last wk of June. Any one else make it out?', 'Left the dock @4:30, saw the weedline in 150� and kept running east. Saw the first pack of birds 6 miles from the corner and got a double knockdown the lines got wrapped so we only got one of the two fish. Gave the pack a few more passes w/ no luck before turning NE to run to the buoy. We get about 25 miles from the buoy and find a nice pack of birds and catch two bigger fish. It�s now 2pm and we have to turn for the 3hr ride home.\r\n\r\nAwesome day. First time catching 3 YFT on my boat and certainly didn�t expect it the last wk of June. Any one else make it out?', 1, 'book.gif', '0', '0', 'markup', 218, 0, '0', 0, 'DaVapors', 'a0b80cd339387bb74628ea914ffbae6c')
- Incorrect string value: '\x92 and ...' for column 'POST_BODY' at row 1

Re: Error on Insert into POSTS
jjjjj #263960 06/29/2020 2:31 PM
Joined: Jun 2006
Posts: 15,956
Likes: 31
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,956
Likes: 31
Looks like something in your database schema isn't utf8mb4, your system should have no problem posting an apostrophe if EVERYTHING was utf8mb4.

Originally Posted by Gizmo
Additionally, could you open the offending table and take a screenshot of the table structure so we can validate that the cells are indeed utf8mb4_general_ci
Please take screenshots of PHPMyAdmin of your listing of tables and within the ubbt_POSTS table's schema to validate everything is utf8mb4.

Reading:
https://www.google.com/search?client=firefox-b-1-d&q=why+mysql+errors+%5Cx92
https://forums.mysql.com/read.php?132,365097,365097
https://stackoverflow.com/questions...avoid-mysql-incorrect-string-value-error


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
Re: Error on Insert into POSTS
jjjjj #263961 06/29/2020 2:55 PM
Joined: Jun 2006
Posts: 15,956
Likes: 31
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,956
Likes: 31
Originally Posted by jjjjj
mysql> SHOW VARIABLES
-> WHERE Variable_name LIKE 'character\_set\_%'
-> OR Variable_name LIKE 'collation%';
+--------------------------+--------------------+
| Variable_name | Value |
+--------------------------+--------------------+
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8mb4 |
| character_set_server | utf8mb4 |
| character_set_system | utf8 |
| collation_connection | utf8mb4_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8mb4_general_ci |
+--------------------------+--------------------+
10 rows in set (0.01 sec)

The database character_set_database and collation_database affect inserting data into the database; as you stated above your character_set_database value is utf8 and not utf8mb4. You're attempting to insert 4 bytes of data into a field that doesn't allow it, hence the error.


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
Re: Error on Insert into POSTS
jjjjj #263962 06/29/2020 3:47 PM
Joined: Dec 2004
Posts: 46
Likes: 2
jjjjj Offline OP
Newbie
OP Offline
Newbie
Joined: Dec 2004
Posts: 46
Likes: 2
Here are my database settings, what do I need to change?

SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_
name LIKE 'collation%';
+--------------------------+--------------------+
| Variable_name | Value |
+--------------------------+--------------------+
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | utf8mb4 |
| character_set_server | utf8mb4 |
| character_set_system | utf8 |
| collation_connection | utf8mb4_general_ci |
| collation_database | utf8mb4_general_ci |
| collation_server | utf8mb4_general_ci |
+--------------------------+--------------------+
10 rows in set (0.01 sec)

Re: Error on Insert into POSTS
Gizmo #263963 06/29/2020 3:51 PM
Joined: Jun 2006
Posts: 15,956
Likes: 31
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,956
Likes: 31
Originally Posted by Gizmo
Originally Posted by Gizmo
Additionally, could you open the offending table and take a screenshot of the table structure so we can validate that the cells are indeed utf8mb4_general_ci
Please take screenshots of PHPMyAdmin of your listing of tables and within the ubbt_POSTS table's schema to validate everything is utf8mb4.

I'm still waiting on the above screenshots.

Can you reproduce the error here or at UBBDev, with the exact same post data? If not, it's a server configuration issue, and there is little we can do to diagnose and fix problems with server configurations; we're a script provider and we assume that your server configuration is compatible.

You may just need to toggle the "MySQL Full Unicode Support (utf8mb4)" setting to see if your system will operate without errors.

You could try creating a fresh install of UBB.threads 7.7.4 from a fresh download from the member area in an empty database and see if it works as expected (creating utf8mb4 posts, actually creating and not previewing so it is written to the database) and compare.

A properly working utf8mb4 setup will allolw you to post emojis (as a test): 😎✌👌


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!
Re: Error on Insert into POSTS
jjjjj #263964 06/29/2020 4:53 PM
Joined: Dec 2004
Posts: 46
Likes: 2
jjjjj Offline OP
Newbie
OP Offline
Newbie
Joined: Dec 2004
Posts: 46
Likes: 2
Here is the database information
+--------------------+---------+--------------------+
| database | charset | collation |
+--------------------+---------+--------------------+
| information_schema | utf8 | utf8_general_ci |
| mysql | utf8mb4 | utf8mb4_general_ci |
| performance_schema | utf8 | utf8_general_ci |
| sys | utf8 | utf8_general_ci |
| ubb756 | utf8mb4 | utf8mb4_general_ci |
+--------------------+---------+--------------------+
5 rows in set (0.00 sec)

and the table information
SHOW FULL COLUMNS FROM ubbt_POSTS;
+-----------------------+------------------+--------------------+------+-----+---------+----------------+----------
| Field | Type | Collation | Null | Key | Default | Extra | Privilege
+-----------------------+------------------+--------------------+------+-----+---------+----------------+----------
| POST_ID | int(11) unsigned | NULL | NO | PRI | NULL | auto_increment | select,in
| POST_PARENT_ID | int(11) unsigned | NULL | NO | MUL | NULL | | select,in
| TOPIC_ID | int(11) unsigned | NULL | NO | MUL | NULL | | select,in
| POST_IS_TOPIC | tinyint(1) | NULL | NO | | 0 | | select,in
| POST_POSTED_TIME | int(11) unsigned | NULL | NO | MUL | NULL | | select,in
| POST_POSTER_IP | varchar(60) | utf8mb4_general_ci | YES | | NULL | | select,in
| POST_SUBJECT | text | utf8mb4_general_ci | YES | MUL | NULL | | select,in
| POST_BODY | text | utf8mb4_general_ci | YES | | NULL | | select,in
| POST_DEFAULT_BODY | text | utf8mb4_general_ci | YES | | NULL | | select,in
| POST_IS_APPROVED | tinyint(1) | NULL | NO | MUL | 1 | | select,in
| POST_ICON | varchar(30) | utf8mb4_general_ci | YES | | NULL | | select,in
| POST_IS_MEMBER_POST | tinyint(1) | NULL | YES | | 1 | | select,in
| POST_HAS_POLL | tinyint(1) | NULL | YES | | NULL | | select,in
| POST_HAS_FILE | tinyint(1) | NULL | YES | | NULL | | select,in
| POST_MARKUP_TYPE | varchar(10) | utf8mb4_general_ci | YES | | markup | | select,in
| POST_LAST_EDITED_TIME | int(11) | NULL | YES | | NULL | | select,in
| POST_LAST_EDITED_BY | varchar(64) | utf8mb4_general_ci | YES | | NULL | | select,in
| POST_LAST_EDIT_REASON | varchar(255) | utf8mb4_general_ci | YES | | NULL | | select,in
| USER_ID | int(9) unsigned | NULL | NO | MUL | NULL | | select,in
| POST_PARENT_USER_ID | int(9) unsigned | NULL | NO | | 0 | | select,in
| POST_ADD_SIGNATURE | int(1) | NULL | NO | | 0 | | select,in
| POST_POSTER_NAME | varchar(50) | utf8mb4_general_ci | YES | | NULL | | select,in
| POST_MD5 | varchar(32) | utf8mb4_general_ci | YES | MUL | NULL | | select,in
+-----------------------+------------------+--------------------+------+-----+---------+----------------+----------
23 rows in set (0.00 sec)

Re: Error on Insert into POSTS
jjjjj #263965 06/29/2020 5:08 PM
Joined: Jun 2006
Posts: 15,956
Likes: 31
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,956
Likes: 31
I'm really not sure, the schema looks correct; I'm assuming your MySQL logs show new entries after you updated your schemas before right? (don't just take users at their word, a log will be written when an error occurs).

Do you have the attached function enabled in UBB.threads (its in db settings)?

Attached Files
testme.png

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
Re: Error on Insert into POSTS
jjjjj #263966 06/29/2020 7:00 PM
Joined: Dec 2004
Posts: 46
Likes: 2
jjjjj Offline OP
Newbie
OP Offline
Newbie
Joined: Dec 2004
Posts: 46
Likes: 2
I have character-set-server=utf8mb4 set in the my.cnf file

Re: Error on Insert into POSTS
jjjjj #263967 06/29/2020 8:23 PM
Joined: Apr 2004
Posts: 1,718
Likes: 63
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,718
Likes: 63
Originally Posted by jjjjj
I have character-set-server=utf8mb4 set in the my.cnf file

note that changes to the variables in config file (my.cnf) often require a mysql server restart. server variable changes take effect after a server restart since that's when they are read.


Current developer of UBB.threads PHP Forum Software // 7.7.4 released!
isaac @ id242.com // my forum @ CelicaHobby.com
Re: Error on Insert into POSTS
jjjjj #263968 06/29/2020 8:29 PM
Joined: Dec 2004
Posts: 46
Likes: 2
jjjjj Offline OP
Newbie
OP Offline
Newbie
Joined: Dec 2004
Posts: 46
Likes: 2
I rebooted the server after making changes just to make sure. Is there a possibility of a cache issue?

Re: Error on Insert into POSTS
jjjjj #263969 06/29/2020 8:40 PM
Joined: Apr 2004
Posts: 1,718
Likes: 63
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,718
Likes: 63
What is your setting as Ruben advised above?
https://www.ubbcentral.com/forums/u.../re-error-on-inert-into-posts#Post263955

checked or unchecked?

[Linked Image]


Did you know that you can uncheck that box, then go to Control Panel > Content Rebuilder
and have the UBB.threads software convert your tables for you:

[Linked Image]

When you click that link, the utf8mb4 conversion process will begin.
That process looks like this example:

[Linked Image]
[Linked Image]
(the conversion screenshots above were from my WIP/development server. For release/public code, "Tables not converted" instead will show the number of actual tables converted on your forum install.)


Then follow the "Enable "MySQL Full Unicode Support" from the Database Settings page" directions given once the tool finishes it's job.

Which will bring you back to the checkbox that Ruben, Gizmo and myself have asked you about earlier in this thread:

[Linked Image]

All that the checkbox does is tell the MySQLi connector to use the utf8mb4 character set for communication with the database server. Also when the box is checked, the hyperlink from "Update All Tables to UTF8mb4" within Content Rebuilder/Transition Actions will be disabled. That is all it does.


CODE:
The checkbox sets the default character set to be used when sending data from and to the database server.

[Linked Image]

Last edited by isaac; 06/30/2020 5:45 PM. Reason: added screenshots

Current developer of UBB.threads PHP Forum Software // 7.7.4 released!
isaac @ id242.com // my forum @ CelicaHobby.com
Re: Error on Insert into POSTS
jjjjj #263970 06/30/2020 4:33 PM
Joined: Dec 2004
Posts: 46
Likes: 2
jjjjj Offline OP
Newbie
OP Offline
Newbie
Joined: Dec 2004
Posts: 46
Likes: 2
I reran the table char set update. I am not sure if I had selected the "MySQL Full Unicode Support (utf8mb4)" check box when I did this the first time. I rebooted the system afterward. I will watch the log and see if I get any more error messages and report back.
Thanks for the help.

Re: Error on Insert into POSTS
jjjjj #263971 06/30/2020 5:13 PM
Joined: Apr 2004
Posts: 1,718
Likes: 63
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,718
Likes: 63
I've updated my previous post to include walk-through screenshots of the process for you, and anyone else who may find this thread helpful.
https://www.ubbcentral.com/forums/u.../re-error-on-inert-into-posts#Post263969


Current developer of UBB.threads PHP Forum Software // 7.7.4 released!
isaac @ id242.com // my forum @ CelicaHobby.com
Re: Error on Insert into POSTS
jjjjj #263985 07/11/2020 7:34 PM
Joined: Dec 2004
Posts: 46
Likes: 2
jjjjj Offline OP
Newbie
OP Offline
Newbie
Joined: Dec 2004
Posts: 46
Likes: 2
I created a new test forum, and did not get any errors on the same instance. I cleared the test database, and imported from production, and it worked fine. I can only assume this had something to do with the migrations. I have promoted the test to production, and am having no problems with character formatting in insert. Not sure there is a root cause, if the developers want any of the config files, I have them from both the working, and non-working instances.


Link Copied to Clipboard
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Disaster!!! Files became empty.. Please advise.
by Morgan - 07/27/2020 2:38 PM
Unable to Update Censor List
by BOTCuser - 07/22/2020 9:15 AM
7.7.4 error on rebuilders
by Ruben - 07/21/2020 3:06 PM
[STOCK] UBB.threads Group Image Pack
by isaac - 07/19/2020 9:03 PM
Who's Online Now
2 members (Yarp, driv), 68 guests, and 43 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.5
(Snapshot build 20200804)