cBB Chat 1.2.0 with MySQL 5.7+


User avatar

Leinad4Mind
 
Posts: 99
Joined: Thu Oct 15, 2015 10:10 pm

cBB Chat 1.2.0 with MySQL 5.7+

Postby Leinad4Mind » Thu Mar 14, 2019 8:56 pm • via Web
You need to fix one SQL Query (Remove the group by or fixing the Select):

Code: Select all
SQL ERROR [ mysqli ]

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'database.phpbb_smilies.smiley_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [1055]

SQL

SELECT * FROM phpbb_smilies GROUP BY smiley_url ORDER BY smiley_order LIMIT 200

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/mysql_base.php
LINE: 45
CALL: phpbbdbdrivermysqli->sql_query()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 270
CALL: phpbbdbdrivermysql_base->_sql_query_limit()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 321
CALL: phpbbdbdriverdriver->sql_query_limit()

FILE: [ROOT]/ext/canidev/chat/libraries/chat.php
LINE: 412
CALL: phpbbdbdriverfactory->sql_query_limit()

FILE: [ROOT]/ext/canidev/chat/libraries/chat.php
LINE: 275
CALL: canidevchatlibrarieschat->generate_smilies()

FILE: [ROOT]/ext/canidev/chat/event/listener.php
LINE: 99
CALL: canidevchatlibrarieschat->display()

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

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/functions.php
LINE: 4673
CALL: phpbbeventdispatcher->trigger_event()

FILE: [ROOT]/index.php
LINE: 246
CALL: page_footer()


PS: Great job with this update! Love the view more ajax thing! Keep up the great work!
User avatar

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

Re: cBB Chat 1.2.0 with MySQL 5.7+

Postby IvanPF » Fri Mar 15, 2019 12:53 pm • via Web
Thanks for report.
I will check it
User avatar

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

Re: cBB Chat 1.2.0 with MySQL 5.7+

Postby IvanPF » Fri Mar 15, 2019 3:09 pm • via Web
To solve this problem do this:
1. Open /ext/canidev/chat/libraries/chat.php
2. Find:
Code: Select all
      $sql = 'SELECT *
         FROM ' . SMILIES_TABLE . '
         GROUP BY smiley_url
         ORDER BY smiley_order';

3. Replace with:
Code: Select all
      $sql = 'SELECT smiley_url, MIN(emotion) as emotion, MIN(code) AS code, smiley_width, smiley_height, MIN(smiley_order) AS min_smiley_order
         FROM ' . SMILIES_TABLE . '
         GROUP BY smiley_url, smiley_width, smiley_height
         ORDER BY min_smiley_order';


BitRooT
 
Posts: 6
Joined: Wed Mar 13, 2019 10:25 pm

Re: cBB Chat 1.2.0 with MySQL 5.7+

Postby BitRooT » Fri Mar 15, 2019 3:37 pm • via iPhone
Nice - I had the same problem. Thanks for the answer.
User avatar

Leinad4Mind
 
Posts: 99
Joined: Thu Oct 15, 2015 10:10 pm

Re: cBB Chat 1.2.0 with MySQL 5.7+

Postby Leinad4Mind » Sun Mar 17, 2019 8:00 pm • via Web
Thanks, btw I've found another little error:

[phpBB Debug] PHP Notice: in file [ROOT]/ext/canidev/chat/libraries/action_manager.php on line 95: Undefined variable: container
User avatar

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

Re: cBB Chat 1.2.0 with MySQL 5.7+

Postby IvanPF » Sun Mar 17, 2019 8:06 pm • via Web
This problem is solved in the package.
Please, do this steps (similar to the update proccess):

1. download the extension again.
2. disable extension in ACP
3. Upload the new files
4. Enable the extension in ACP

Sorry for this problems
User avatar

Leinad4Mind
 
Posts: 99
Joined: Thu Oct 15, 2015 10:10 pm

Re: cBB Chat 1.2.0 with MySQL 5.7+

Postby Leinad4Mind » Sun Mar 17, 2019 8:55 pm • via Web
No problem. Thanks!
User avatar

Leinad4Mind
 
Posts: 99
Joined: Thu Oct 15, 2015 10:10 pm

Re: cBB Chat 1.2.0 with MySQL 5.7+

Postby Leinad4Mind » Sun Mar 17, 2019 9:02 pm • via Web
Sorry to bother again lol Its just a warning... nothing big deal but I'll let you know.

With debug enabled I get this on console since it comes from a js file:

Code: Select all
Uncaught Error: [phpBB Debug] PHP Notice: in file [ROOT]/ext/canidev/chat/libraries/action_manager.php on line 1915: Undefined index: bbcode_bitfield

[phpBB Debug] PHP Notice: in file [ROOT]/ext/canidev/chat/libraries/action_manager.php on line 1915: Undefined index: bbcode_bitfield

[phpBB Debug] PHP Notice: in file [ROOT]/ext/canidev/chat/libraries/action_manager.php on line 1915: Undefined index: bbcode_bitfield

[phpBB Debug] PHP Notice: in file [ROOT]/ext/canidev/chat/libraries/action_manager.php on line 1915: Undefined index: bbcode_bitfield

[phpBB Debug] PHP Notice: in file [ROOT]/ext/canidev/chat/libraries/action_manager.php on line 1915: Undefined index: bbcode_bitfield

[phpBB Debug] PHP Notice: in file [ROOT]/ext/canidev/chat/libraries/action_manager.php on line 1915: Undefined index: bbcode_bitfield

[phpBBDebug] PHP Notice: in file [ROOT]/ext/canidev/chat/libraries/action_manager.php on line 1915: Undefined index: bbcode_bitfield

[phpBB Debug] PHP Notice: in file [ROOT]/ext/canidev/chat/libraries/action_manager.php on line 1915: Undefined index: bbcode_bitfield
User avatar

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

Re: cBB Chat 1.2.0 with MySQL 5.7+

Postby IvanPF » Mon Mar 18, 2019 11:26 am • via Web
You're right. What I do not understand is because in my test forum this is not shown :shock:
To fix it, do this

1. open /ext/canidev/chat/libraries/action_manager.php
2. Find:
Code: Select all
            $timestamp       = 0;
            $parse_flags   = ($row['bbcode_bitfield'] ? OPTION_FLAG_BBCODE : 0) | OPTION_FLAG_SMILIES;

3. Replace with:
Code: Select all
            $timestamp       = 0;
            $parse_flags   = (!empty($row['bbcode_bitfield']) ? OPTION_FLAG_BBCODE : 0) | OPTION_FLAG_SMILIES;


PD: The package is updated with this fix.
User avatar

Leinad4Mind
 
Posts: 99
Joined: Thu Oct 15, 2015 10:10 pm

Re: cBB Chat 1.2.0 with MySQL 5.7+

Postby Leinad4Mind » Mon Mar 18, 2019 12:24 pm • via Web
Thanks again!

(offtopic: all last canidev mail links are pointing to vi%0Dewtopic.php?uid=xxx&f=xx&t=xxx&unwatch=topic and there is a typo on the viewtopic word, go figure why.)
Next

Who is online

Users browsing this forum: No registered users and 1 guest

cron