some errors after upgrading to vb5

[webmsg]

Hi..

1- I'm getting lots of errors by email regarding bbcode, maybe need to be corrected after upgrading from vb3 to vb5 ?!

the emails are long, but part of it is:

------------------------------
Database error in vBulletin 5.7.5 Release Candidate 1: Invalid SQL: INSERT INTO `bbcode_data` (`id`, `nodeid`, `bbcode_type`, `hash`, `data`, `expires`) VALUES (24730, 20245, 'Url', '4bfc464f922976283d7e8dc32192424a', '{"title":"Nurturing the Love of Learning: Montessori Education for the Preschool Years","meta":"This DVD originally produced by the American Montessori Society has now been upgraded to an all new high definition version which can be found on YouTube by ...","images":["https:\\/\\/i.ytimg.com\\/vi\\/OM1Gu9KXVkk\\/hqdefault.jpg"],"url":"http:\\/\\/www.youtube.com\\/watch?v=OM1Gu9KXVkk","lastfetch":1687292204}', 1687292804), (24727, 20245, 'Url', 'a6f2a1d831813b26dbf718872f31e3a1', '{"title":"Montessori","meta":"Montessori" ,"images":["https:\\/\\/i.ytimg.com\\/vi\\/l12Lcw1Mt_Q\\/hqdefault.jpg"],"url":"http:\\/\\/www.youtube.com\\/watch?v=l12Lcw1Mt_Q&feature=player_embedded", "lastfetch":1687292212}', 1687292812), (24729, 20245, 'Url', 'b27f93a46cc80543032389dd31036dea', '{"title":"Metodo Montessori","meta":"Escuela Asemos","images":["https:\\/\\/i.ytimg.com\\/vi\\/7ZEvJZFzYFM\\/hqdefault.jpg"],"url":"http:\\/\\/www.youtube.com\\/watch?v=7ZEvJZFzYFM&feature=player_embedded", "lastfetch":1687292221}', 1687292821),
------------------------------

2- some of the signatures are showing "[color] [/color]..[font] [/font]", how can I fix that? or what to replace in the database if I'm going to do that and not the replacement variables?

TIA.

[glennrocksvb]

1. Please post the exact SQL error message included in the email. It is labeled "MySQL Error:"
2. Upgrading to a Release Candidate is not recommended. It's good to wait for the final release.
3. What vB3 version did you upgrade from?

[webmsg]

Thanks Glenn.. I upgraded from 3.8.11

-----------------------------------------------------
Database error in vBulletin 5.7.5 Release Candidate 1: Invalid SQL: INSERT INTO `bbcode_data` (`id`, `nodeid`, `bbcode_type`, `hash`, `data`, `expires`) VALUES (24730, 20245, 'Url', '4bfc464f922976283d7e8dc32192424a', '{"title":"Nurturing the Love of Learning: Montessori Education for the Preschool Years","meta":"This DVD originally produced by the American Montessori Society has now been upgraded to an all new high definition version which can be found on YouTube by ...","images":["https:\\/\\/i.ytimg.com\\/vi\\/OM1Gu9KXVkk\\/hqdefault.jpg"],"url":"http:\\/\\/www.youtube.com\\/watch?v=OM1Gu9KXVkk","lastfetch":1687292204}', 1687292804), (24727, 20245, 'Url', 'a6f2a1d831813b26dbf718872f31e3a1', '{"title":"Montessori","meta":"Montessori","images ":["https:\\/\\/i.ytimg.com\\/vi\\/l12Lcw1Mt_Q\\/hqdefault.jpg"],"url":"http:\\/\\/www.youtube.com\\/watch?v=l12Lcw1Mt_Q&feature=player_embedded"," lastfetch":1687292212}', 1687292812), (24729, 20245, 'Url', 'b27f93a46cc80543032389dd31036dea', '{"title":"Metodo ................................
truncated.. exceeded max number of characters.
................................
\\/hqdefault.jpg"],"url":"http:\\/\\/www.youtube.com\\/watch?v=G4BmsFtFZHM&feature=player_embedded"," lastfetch":1687292330}', 1687292930), (24746, 435740, 'Url', '1dc7ff212fffb5d1bcf5289cac277f27', '{"title":" - YouTube","meta":"Profitez des vid\\u00e9os et de la musique que vous aimez, mettez en ligne des contenus originaux, et partagez-les avec vos amis, vos proches et le monde entier.","images":[],"url":"http:\\/\\/www.youtube.com\\/watch?v=IpSA5igPd2U&feature=player_embedded"," lastfetch":1687292339}', 1687292939), (24747, 435740, 'Url', '40e8e517acd4103c97af11937a167b0a', '{"title":" - YouTube","meta":"Profitez des vid\\u00e9os et de la musique que vous aimez, mettez en ligne des contenus originaux, et partagez-les avec vos amis, vos proches et le monde entier.","images":[],"url":"http:\\/\\/www.youtube.com\\/watch?v=5K-y1Gxsirc&feature=player_embedded","lastfetch": 1687292347}', 1687292947), (24749, 435740, 'Url', 'c913959366f8742d341389ced3ce69be', '{"title":" - YouTube","meta":"Profitez des vid\\u00e9os et de la musique que vous aimez, mettez en ligne des contenus originaux, et partagez-les avec vos amis, vos proches et le monde entier.","images":[],"url":"http:\\/\\/www.youtube.com\\/watch?v=7ty_d9CCJGo&feature=player_embedded"," lastfetch":1687292355}', 1687292955), (24750, 435740, 'Url', 'f9fdb6b09226a5198236fd23670c9cde', '{"title":"Preschool Language Activities in Montessori : Matching Objects in Montessori","meta":"Teach your preschooler to identify objects and sounds with this simple activity. Learn how to play the matching game in this free educational video clip from...","images":["https:\\/\\/i.ytimg.com\\/vi\\/OUiDPQJ-Fac\\/hqdefault.jpg"],"url":"http:\\/\\/www.youtube.com\\/watch?v=OUiDPQJ-Fac&feature=player_embedded","lastfetch":16872 92364}', 1687292964), (24751, 435740, 'Url', 'fb80259f9eb20b8662324fd06e9cc010', '{"title":" - YouTube","meta":"Profitez des vid\\u00e9os et de la musique que vous aimez, mettez en ligne des contenus originaux, et partagez-les avec vos amis, vos proches et le monde entier.","images":[],"url":"http:\\/\\/www.youtube.com\\/watch?v=TFIrMo_cSwU&feature=player_embedded"," lastfetch":1687292372}', 1687292972), (24748, 435740, 'Url', 'ff045fb57cd7edc62966bcab7ccca204', '{"title":" - YouTube","meta":"Profitez des vid\\u00e9os et de la musique que vous aimez, mettez en ligne des contenus originaux, et partagez-les avec vos amis, vos proches et le monde entier.","images":[],"url":"http:\\/\\/www.youtube.com\\/watch?v=w2PeRHmATaM&feature=player_embedded"," lastfetch":1687292380}', 1687292980), (24754, 435874, 'Url', '6c3d359c2f3d06ff3e1b08ed625c88aa', '{"title":"Preschool Language Activities in Montessori : Matching Games for Preschoolers","meta":"Matching games improve language, concentration, and memory. Learn how to play matching games with your young kids in this free educational video clip from a ...","images":["https:\\/\\/i.ytimg.com\\/vi\\/HXJTkTrtfd4\\/hqdefault.jpg"],"url":"http:\\/\\/www.youtube.com\\/watch?v=HXJTkTrtfd4","lastfetch":1687292389}', 1687292989), (24753, 435874, 'Url', 'bcd954f24be3671ea6bf97bdb702a532', '{"title":" - YouTube","meta":"Profitez des vid\\u00e9os et de la musique que vous aimez, mettez en ligne des contenus originaux, et partagez-les avec vos amis, vos proches et le monde entier.","images":[],"url":"http:\\/\\/www.youtube.com\\/watch?v=BV8o63RGLII","lastfetch":1687292397}', 1687292997), (24752, 435874, 'Url', 'fb8b779e638da435fdfa071f3334aa3a', '{"title":"Preschool Language Activities in Montessori : Letter Basket Montessori Activity","meta":"Teaching preschoolers to identify objects is the foundation for language skills. Learn a letter basket Montessori activity for preschoolers in this free educ...","images":["https:\\/\\/i.ytimg.com\\/vi\\/Dit04WT8TWc\\/hqdefault.jpg"],"url":"http:\\/\\/www.youtube.com\\/watch?v=Dit04WT8TWc","lastfetch":1687292405}', 1687293005), (24755, 435876, 'Url', '68096098cbf35cafafb4df57d1f24399', '{"title":"Montessori Language Activities : Montessori Matching Objects Activity","meta":"Help build your child\'s vocabulary with matching objects to pictures. Learn how to do the matching objects activity in this free educational video about lang...","images":["https:\\/\\/i.ytimg.com\\/vi\\/ubYW-M53y64\\/hqdefault.jpg"],"url":"http:\\/\\/www.youtube.com\\/watch?v=ubYW-M53y64","lastfetch":1687292406}', 1687293006), (24756, 435878, 'Url', 'cccadaf86ecd78c6863444cf33daec43', '{"title":" - YouTube","meta":"Profitez des vid\\u00e9os et de la musique que vous aimez, mettez en ligne des contenus originaux, et partagez-les avec vos amis, vos proches et le monde entier.","images":[],"url":"http:\\/\\/www.youtube.com\\/watch?v=bTYOxffqC9k","lastfetch":1687292406}', 1687293006), (24757, 435880, 'Url', '61f67e4b8c1067445ca1cff17947fdf7', '{"title":" - YouTube","meta":"Profitez des vid\\u00e9os et de la musique que vous aimez, mettez en ligne des contenus originaux, et partagez-les avec vos amis, vos proches et le monde entier.","images":[],"url":"http:\\/\\/www.youtube.com\\/watch?v=vraftY2taNc","lastfetch":1687292406}', 1687293006), (24758, 436133, 'Url', '4e6789e31baefed7a38028ba17778602', '{"title":"Montessori Counting Methods : Montessori Counting with Unifix Cubes","meta":"Unifix cubes in Montessori counting are another way to show quantity. Learn how to use unifix cubes to count in this free educational video about Montessori ...","images":["https:\\/\\/i.ytimg.com\\/vi\\/eHc7SsSwHT4\\/hqdefault.jpg"],"url":"http:\\/\\/www.youtube.com\\/watch?v=eHc7SsSwHT4","lastfetch":1687292407}', 1687293007) ON DUPLICATE KEY UPDATE `hash` = VALUES(`hash`), `data` = VALUES(`data`), `expires` = VALUES(`expires`) /** bulkUpsertBbCodeData**/; MySQL Error : MySQL server has gone away Error Number : 2006 Request Date : Tuesday, June 20th 2023 @ 08:16:35 PM Error Date : Tuesday, June 20th 2023 @ 08:20:07 PM Script : https://mysite.net/node/20245?mode=linear Referrer : IP Address : 185.191.171.2 Username : ضيف Classname : vB_Database_MySQLi MySQL Version : Stack Trace: #0 vB_Database->getErrorData() called in phar://[path]/vb/vb.phar/database.php on line 1 #1 vB_Database->halt() called in phar://[path]/vb/vb.phar/database/mysqli.php on line 1 #2 vB_Database_MySQLi->execute_query() called in phar://[path]/vb/vb.phar/database.php on line 1 #3 vB_Database->query_write() called in phar://[path]/vb/vb.phar/db/querydefs.php on line 1 #4 vB_dB_QueryDefs->executeWriteQuery() called in phar://[path]/vb/vb.phar/db/mysql/querydefs.php on line 1251 #5 vB_dB_MYSQL_QueryDefs->bulkUpsertBbCodeData() called in phar://[path]/vb/vb.phar/db/query/method.php on line 1 #6 vB_dB_Query_Method->execSQL() called in phar://[path]/vb/vb.phar/db/assertor.php on line 1 #7 vB_dB_Assertor->assertQuery() called in phar://[path]/vb/vb.phar/bbcodedatacache.php on line 2 #8 vB_BbCodeDataCache->saveChanges() called in /home/almysite./public_html/includes/vb5/template/nodetext.php on line 725 #9 vB5_Template_NodeText->fetchNodeText() called in /home/almysite./public_html/includes/vb5/template/nodetext.php on line 532 #10 vB5_Template_NodeText->replacePlaceholders() called in /home/almysite./public_html/includes/vb5/template.php on line 520 #11 vB5_Template->renderDelayed() called in /home/almysite./public_html/includes/vb5/template.php on line 430 #12 vB5_Template->render() called in /home/almysite./public_html/includes/vb5/frontend/controller/page.php on line 277 #13 vB5_Frontend_Controller_Page->index() called in /home/almysite./public_html/index.php on line 65
-----------------------------------------------------

Regards.

[glennrocksvb]

The SQL error is "MySQL server has gone away" which is a common error. Here are some posts from vB support forum that may help to resolve the issue.

https://www.vbulletin.com/docs/html/troubleshoot_mysql_goneaway

https://forum.vbulletin.com/forum/vbulletin-5-connect/vbulletin-5-installations/4479003-mysql-server-has-gone-away-queries-that-take-too-long

https://forum.vbulletin.com/forum/vbulletin-5-connect/support-issues-questions/4408927-mysql-error-mysql-server-has-gone-away-error-number-2006

[webmsg]

Thank you..

but how about the second issue? do you think I need to do style variable replacement?

[glennrocksvb]

Go to Usergroup Manager in AdminCP. Edit the desired usergroup, locate the "Signature Permissions" section and check if "Allow BB Code" and the other "Allow XXXX BB Code" options are set to Yes.

[webmsg]

Thanks so much Glenn, I completely forgot about that!!

Regards.