cBB editor and BBOOTS Theme, M E S S E D!


User avatar

PhilDiscuss
 
Posts: 53
Joined: Wed Nov 09, 2016 4:53 am
Location: Manila - Philippines

cBB editor and BBOOTS Theme, M E S S E D!

Postby PhilDiscuss » Sat Mar 16, 2019 1:41 pm • via Web
Using latest phpBB3.2.5 and latest version of BBOOTS Theme

cBB editor disabled:
https://prnt.sc/myorw8

Enabled:
Font family change
http://prntscr.com/myouku
http://prntscr.com/myow0d
http://prntscr.com/myovi1
http://prntscr.com/myowso
http://prntscr.com/myoxbi
https://prnt.sc/myoxwl
https://prnt.sc/myow0d

Other observation:
After disabling this extension BBcode editor:
Forum crashed! Need to restore my backup.Only index is accesible. :oops:
and /posting.php?mode=post&f=459
has this:
Code: Select all
General Error
SQL ERROR [ mysqli ]

Unknown column 'b.bbcode_icon' in 'field list' [1054]

SQL

SELECT b.bbcode_id, b.bbcode_tag, b.bbcode_helpline, b.bbcode_order, b.bbcode_icon, b.bbcode_group, FALSE as bbcode_default FROM (phpbb_bbcodes b) WHERE b.display_on_posting = 1 UNION ALL SELECT db.bbcode_id, db.bbcode_tag, "" as bbcode_helpline, db.bbcode_order, db.bbcode_icon, "" as bbcode_group, TRUE as bbcode_default FROM phpbb_default_bbcodes dbWHERE display_on_posting = 1 ORDER BY bbcode_order, bbcode_id

BACKTRACE

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

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

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

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbbdbdrivermysqli->sql_query()

FILE: [ROOT]/includes/functions_display.php
LINE: 1103
CALL: phpbbdbdriverfactory->sql_query()

FILE: [ROOT]/posting.php
LINE: 1853
CALL: display_custom_bbcodes()
User avatar

IvanPF
Site Admin
 
Posts: 1556
Joined: Fri Jun 17, 2011 12:15 am
Location: España (Spain)

Re: cBB editor and BBOOTS Theme, M E S S E D!

Postby IvanPF » Sat Mar 16, 2019 2:05 pm • via Web
Please, Put here the list of extensions installed in the forum
I think that one is giving problems with the editor and cause the debug error.
The same must happen in terms of style, since the extension has been tested in bboots and, in my test forum, it looks correctly.
Attachments
cap01.png
cap01.png (26.9 KB) Viewed 32 times
User avatar

PhilDiscuss
 
Posts: 53
Joined: Wed Nov 09, 2016 4:53 am
Location: Manila - Philippines

Re: cBB editor and BBOOTS Theme, M E S S E D!

Postby PhilDiscuss » Sat Mar 16, 2019 11:21 pm • via Web
    2-Step Authentication 1.0.4
    Add user 3.1.1
    Advanced Profile Fields Pack 1.0.3
    Antispam by CleanTalk 5.1
    Auto Groups 2.0.0
    Automatic Topic Subscription 1.1.0
    Avatars+ 2.0.0
    BB@mention 1.6.0
    BBAvatarResize 1.0.0
    BBAvatars 1.2.6
    BBAwards 1.4.1
    BBAwards Autogroups 1.1.0
    BBAwards Premium Rules 1.1.0
    BBbreadcrumbs 1.0.1
    BBClassifieds (2of4) 1.0.1
    BBClassifieds Addon (3of4) 1.0.1
    BBClassifieds Ads (4of4) 1.0.3
    BBCodeOrder+ 1.0.4
    BBDonations 1.0.4
    BBDownloads (1of4) 1.0.5
    BBembed 1.1.1
    BBemoji 2.0.1
    BBlightBox 1.0.0
    BBmembership 1.4.1
    BBNewsletter 1.0.3
    BBOAuth 1.0.1
    BBOOTS Mini CMS 1.0.7
    BBopenGraph 1.0.2
    BBpoints 1.2.1
    BBprefix 1.0.7
    BBpreview 1.0.8
    BBreaction 1.2.0
    BBsidebar 1.4.1
    BBtags 1.1.1
    Board Announcements 1.0.5
    Board Rules 2.1.0
    BookmarkPost 1.0.2
    Categorize Announcements and Stickies 1.0.1
    cBB Chat 1.2.0
    cBB QuickMod 1.1.0
    cBB QuickQuote 1.0.1
    Clipboard Image 1.0.0
    Codebox Plus 2.0.0
    Collapsible Forum Categories 1.0.3
    Delete My Account 1.0.0
    Error pages 3.1.2
    Export emails and subscribers 1.0.3
    Faulty Logins 3.1.3
    Forumhulp Helper 3.1.10
    Group Rules 1.1.0
    HTML email 3.1.7
    IMGUR - Forum Images Uploader 1.0.8
    Joined date format 1.0.0
    Knowledge Base 1.0.2
    LikeBB 2.3.1
    Live topic update 1.0.2
    LMDI Delete Re: 1.0.7
    Login Required 1.1.0
    Mass Notification 1.0.0
    MathJax 1.0.0
    Minecraft Avatar Extension - mcapi.ca API 2.0.1
    National Flags 2.1.1
    Nightstalker 1.0.5
    No Notice Delete PM 1.0.0
    Notification manager for phpBB 3.2.0
    OneAll Social Login 2.5
    Pages 2.0.2
    Pages: TinyMCE WYSIWYG Add-on 3.1.0
    Personal Notes 3.1.1
    PhilDiscuss Tracker 1.0.0
    phpBB 3.2 Auto Ban 1.0.1
    PM Notifications 1.0.2
    PM Spy 3.1.1
    PM Welcome 1.0.1
    Precise Similar Topics 1.4.3
    Profile Wall 1.2.1
    Registration email subscription 1.0.0
    SiteSplat BBCore 3.2.6
    Smart Subjects 1.0.0
    Snappy Smart Reply 1.1.13
    Subject Check 1.0.4
    Symbols 1.0.1TimeAgo 1.4.1
    Top Five 1.1.0
    Topic Solved 3.2.0
    User Feedback for phpBB 1.1.0
    User Statistics 2.0.1
User avatar

IvanPF
Site Admin
 
Posts: 1556
Joined: Fri Jun 17, 2011 12:15 am
Location: España (Spain)

Re: cBB editor and BBOOTS Theme, M E S S E D!

Postby IvanPF » Sun Mar 17, 2019 12:30 am • via Web
Seeing the list of extensions, I think the problem may come from the BBCodeOrder + extension, since, like the editor, it assigns icons to the bbcodes.

To be sure I need to know one thing:

After disabling this extension BBcode editor:
Forum crashed! Need to restore my backup.Only index is accesible. :oops:

In this point, you only disable the ext or you clicked on "deleted data" too?
User avatar

PhilDiscuss
 
Posts: 53
Joined: Wed Nov 09, 2016 4:53 am
Location: Manila - Philippines

Re: cBB editor and BBOOTS Theme, M E S S E D!

Postby PhilDiscuss » Sun Mar 17, 2019 12:48 am • via Web
Hello Ivan,

I disabled "BBCodeOrder + extension"
You are right!

After disabling this extension BBcode editor:
Forum crashed! Need to restore my backup.Only index is accesible.

In this point, you only disable the ext or you clicked on "deleted data" too?
Yes, /posting.php has general error. It's not totally crush, only the posting.php after disabling and delete data.
User avatar

PhilDiscuss
 
Posts: 53
Joined: Wed Nov 09, 2016 4:53 am
Location: Manila - Philippines

Re: cBB editor and BBOOTS Theme, M E S S E D!

Postby PhilDiscuss » Sun Mar 17, 2019 2:25 am • via Web
Ivan, still I cannot see any content of editor in the acp.
http://prntscr.com/myx3sz


This is the console error:
https://prnt.sc/myx3fs
http://prntscr.com/myx3qn


Solution:
To add button, I have to switch to prosilver theme. after switching to prosilver I can see now all button in editor.
User avatar

PhilDiscuss
 
Posts: 53
Joined: Wed Nov 09, 2016 4:53 am
Location: Manila - Philippines

Re: cBB editor and BBOOTS Theme, M E S S E D!

Postby PhilDiscuss » Sun Mar 17, 2019 3:22 am • via Web
Add more:

Ivan, now, I can't edit my bbcodes,

http://prntscr.com/myxkmh
http://prntscr.com/myxkvq

Code: Select all
General Error
SQL ERROR [ mysqli ]

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

SQL

SELECT bbcode_icon FROM phpbb_bbcodes WHERE bbcode_id = 147

BACKTRACE

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

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

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

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbbdbdrivermysqli->sql_query()

FILE: [ROOT]/ext/canidev/editor/event/listener.php
LINE: 148
CALL: phpbbdbdriverfactory->sql_query()

FILE: (not given by php)
LINE: (not given by php)
CALL: canideveditoreventlistener->acp_bbcodes_edit_pre()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 184
CALL: call_user_func()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 46
CALL: SymfonyComponentEventDispatcherEventDispatcher->doDispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 62
CALL: SymfonyComponentEventDispatcherEventDispatcher->dispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 46
CALL: phpbbeventdispatcher->dispatch()

FILE: [ROOT]/includes/acp/acp_bbcodes.php
LINE: 132
CALL: phpbbeventdispatcher->trigger_event()

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

FILE: [ROOT]/adm/index.php
LINE: 82
CALL: p_master->load_active()
User avatar

IvanPF
Site Admin
 
Posts: 1556
Joined: Fri Jun 17, 2011 12:15 am
Location: España (Spain)

Re: cBB editor and BBOOTS Theme, M E S S E D!

Postby IvanPF » Sun Mar 17, 2019 12:01 pm • via Web
BBCodeOrder + and cBB Editor used the same column "bbcode_icon" in the bbcodes table so, when you delete one of these extensions, the phpbb installer remove all data related to extension (this column included) and the other extension shows an error.

To solve this, you have two options:
1. Uninstall and reinstall one of the extensions (editor or BBCodeOrder)
2. Do this query through phpmyadmin:
Code: Select all
ALTER TABLE `phpbb_bbcodes` ADD `bbcode_icon` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL AFTER `second_pass_replace`;


I'll review it, but I do not think you can have these two extensions installed at the same time, since both have the same function of putting icons to the bbcodes

PD: I will check the problem with the style on the ACP

Who is online

Users browsing this forum: No registered users and 1 guest

cron