SQL Error


Due to a lack of free time, both support on this forum and extension development are currently limited.
All bugs are noted and saved for fixes, even if there are no replies to the posts.
Normal activity will resume as soon as possible.
no_avatar
ravedeath
 
Posts: 1
Joined: Wed Jun 18, 2025 7:06 pm
 Wed Jun 18, 2025 7:57 pm • via Web
EN: I have a lot of forums (or rather, subforums) and after I selected them all and clicked Submit, I got the following error:

ES: Tengo muchos foros (o más bien, subforos) y después de seleccionarlos todos y de enviar la configuración, me sale este error:

Code: Select all
General Error

SQL ERROR [ mysqli ]

Data too long for column 'config_value' at row 1 [1406]

SQL

UPDATE phpbb_config SET config_value = '2,81,4,5,50,44,70,121,54,140,122,20,7,79,144,88,96,65,62,6,29,107,181,77,176,66,150,80,37,146,110,136,114,109,154,69,86,111,72,139,21,19,129,125,168,100,137,25,108,180,147,135,18,39,17,36,16,155,71,173,10,179,159,46,84,169,163,56,97,119,32,138,24,49,63,117,99,162,157,60,172,141,30,89,134,58,132,126,87,23,145,151,174,153,34,178,26,95,14,38,98,47,33,92,167,91,31,42,83,142,82,61,128,166,15,152,158,68,90,85,177,22,35,165,161,94,102,115,40,118,143,104,78,130,133,113,116,57,175,148,112,127,149,103,93,124,51,11,131,75,64,67,53,120,55,76,171,160,170,28,27,41,105,43,182,9,59,73,13' WHERE config_name = 'reactions_forums'

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 1031
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 216
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 353
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/config/db.php
LINE: 163
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/phpbb/config/db.php
LINE: 137
CALL: phpbb\config\db->set_atomic()

FILE: [ROOT]/ext/canidev/reactions/controller/admin_config.php
LINE: 128
CALL: phpbb\config\db->set()

FILE: [ROOT]/ext/canidev/reactions/acp/main_module.php
LINE: 27
CALL: canidev\reactions\controller\admin_config->display()

FILE: [ROOT]/includes/functions_module.php
LINE: 684
CALL: canidev\reactions\acp\main_module->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()
User avatar
IvanPF
Administrator
 
Posts: 2251
Joined: Fri Jun 17, 2011 12:15 am
Location: España (Spain)
 Wed Jun 18, 2025 8:51 pm • via Web
Hi,

This issue will be fixed in the next release.

Who is online

Users browsing this forum: No registered users and 0 guests