CBB Reactions won't Enable


no_avatar
Malaki86
 
Posts: 6
Joined: Thu Jun 30, 2022 8:06 pm
 Mon Jul 04, 2022 11:26 pm • via Web
PHPBB v3.3.8

When I attempt to Enable the Reactions extension, I get the following error.

Code: Select all
SQL ERROR [ mysqli ]

Unknown column 'reaction_title' in 'field list' [1054]

SQL

INSERT INTO bb_reactions (reaction_title, reaction_color, reaction_image, reaction_order, reaction_score, reaction_enabled) VALUES ('REACTION_LIKE', '#0472f9', './reaction/like.svg', 1, 1, 1), ('REACTION_LOVE', '#fb003d', './reaction/love.svg', 2, 1, 1), ('REACTION_MATTER', '#fb003d', './reaction/matter.svg', 3, 1, 1), ('REACTION_ENJOY', '#fcad04', './reaction/enjoy.svg', 4, 0, 1), ('REACTION_SURPRISE', '#fcad04', './reaction/surprise.svg', 5, 0, 1), ('REACTION_SAD', '#006b9c', './reaction/sad.svg', 6, 0, 1), ('REACTION_ANGRY', '#fc0e00', './reaction/angry.svg', 7, -1, 1)

BACKTRACE

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

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

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

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

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 393
CALL: phpbb\db\driver\driver->sql_multi_insert()

FILE: [ROOT]/ext/canidev/reactions/migrations/v100.php
LINE: 177
CALL: phpbb\db\driver\factory->sql_multi_insert()

FILE: (not given by php)
LINE: (not given by php)
CALL: canidev\reactions\migrations\v100->add_basic_reactions()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 715
CALL: call_user_func_array()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 662
CALL: phpbb\db\migrator->run_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 437
CALL: phpbb\db\migrator->process_data_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 288
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 241
CALL: phpbb\db\migrator->update_do()

FILE: [ROOT]/phpbb/extension/base.php
LINE: 78
CALL: phpbb\db\migrator->update()

FILE: [ROOT]/ext/canidev/reactions/ext.php
LINE: 69
CALL: phpbb\extension\base->enable_step()

FILE: [ROOT]/phpbb/extension/manager.php
LINE: 231
CALL: canidev\reactions\ext->enable_step()

FILE: [ROOT]/includes/acp/acp_extensions.php
LINE: 209
CALL: phpbb\extension\manager->enable_step()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: acp_extensions->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()
User avatar
IvanPF
Administrator
 
Posts: 2010
Joined: Fri Jun 17, 2011 12:15 am
Location: España (Spain)
 Tue Jul 05, 2022 10:22 pm • via Web
Hi,

It seems that something has gone wrong with your installation
Have you tried completely deleting the extension and installing it again?
no_avatar
Malaki86
 
Posts: 6
Joined: Thu Jun 30, 2022 8:06 pm
 Tue Jul 05, 2022 10:52 pm • via Web
I just deleted the reactions folder locally & on the board, unzipped again and re-uploaded.

Exact same issue.
User avatar
IvanPF
Administrator
 
Posts: 2010
Joined: Fri Jun 17, 2011 12:15 am
Location: España (Spain)
 Wed Jul 06, 2022 8:52 am • via Web
I just tested on 3.3.8 and haven't had that problem.
From the error you mention, it seems that the phpBB extension installer on your forum is not working properly. This can be due to many factors.
After trying to install it, can you go into your database manager (like phpbbmyadmin) and take a screenshot of the phpbb_reactions table structure?
no_avatar
Malaki86
 
Posts: 6
Joined: Thu Jun 30, 2022 8:06 pm
 Wed Jul 06, 2022 9:31 pm • via Web
These are the 3 tables I found for the reactions

Screenshot 2022-07-06 172844.jpg

Screenshot 2022-07-06 172812.jpg

Screenshot 2022-07-06 172718.jpg
User avatar
IvanPF
Administrator
 
Posts: 2010
Joined: Fri Jun 17, 2011 12:15 am
Location: España (Spain)
 Sat Jul 09, 2022 8:51 am • via Web
These tables do not have the correct structure. Do you have another reactions extension installed?
no_avatar
Malaki86
 
Posts: 6
Joined: Thu Jun 30, 2022 8:06 pm
 Sat Jul 09, 2022 9:42 am • via Android
No
User avatar
IvanPF
Administrator
 
Posts: 2010
Joined: Fri Jun 17, 2011 12:15 am
Location: España (Spain)
 Sat Jul 09, 2022 11:41 am • via Web
I have been searching and found that those tables belong to the extension "phpBB Topic/Post Reactions, Thanks, Like"
https://www.phpbb.com/community/viewtop ... &t=2615851

If you have already uninstalled it, its installer did not remove its tables and they are causing conflicts.
You should remove them manually before installing cBB Reactions
no_avatar
Malaki86
 
Posts: 6
Joined: Thu Jun 30, 2022 8:06 pm
 Sat Jul 09, 2022 2:07 pm • via Android
Ok. I'll try this evening.

Who is online

Users browsing this forum: No registered users and 0 guests