- You are here:
- Main › Forum › Application Support › cBB Chat
cBB Chat 1.2.0 with MySQL 5.7+
15 posts
• Page 1 of 2 • 1, 2
- Leinad4Mind
- Posts: 213
- Joined: Thu Oct 15, 2015 10:10 pm
Thu Mar 14, 2019 8:56 pm • via Web
You need to fix one SQL Query (Remove the group by or fixing the Select):
PS: Great job with this update! Love the view more ajax thing! Keep up the great work!
- 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!
- IvanPF
- Administrator
- Posts: 2029
- Joined: Fri Jun 17, 2011 12:15 am
- Location: España (Spain)
Fri Mar 15, 2019 12:53 pm • via Web
Thanks for report.
I will check it
I will check it
- IvanPF
- Administrator
- Posts: 2029
- Joined: Fri Jun 17, 2011 12:15 am
- Location: España (Spain)
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:
3. Replace with:
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
Fri Mar 15, 2019 3:37 pm • via iPhone
Nice - I had the same problem. Thanks for the answer.
- Leinad4Mind
- Posts: 213
- Joined: Thu Oct 15, 2015 10:10 pm
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
[phpBB Debug] PHP Notice: in file [ROOT]/ext/canidev/chat/libraries/action_manager.php on line 95: Undefined variable: container
- IvanPF
- Administrator
- Posts: 2029
- Joined: Fri Jun 17, 2011 12:15 am
- Location: España (Spain)
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
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
- Leinad4Mind
- Posts: 213
- Joined: Thu Oct 15, 2015 10:10 pm
Sun Mar 17, 2019 8:55 pm • via Web
No problem. Thanks!
- Leinad4Mind
- Posts: 213
- Joined: Thu Oct 15, 2015 10:10 pm
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:
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
- IvanPF
- Administrator
- Posts: 2029
- Joined: Fri Jun 17, 2011 12:15 am
- Location: España (Spain)
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
To fix it, do this
1. open /ext/canidev/chat/libraries/action_manager.php
2. Find:
3. Replace with:
PD: The package is updated with this fix.
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.
- Leinad4Mind
- Posts: 213
- Joined: Thu Oct 15, 2015 10:10 pm
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.)
(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.)
15 posts
• Page 1 of 2 • 1, 2
Who is online
Users browsing this forum: No registered users and 0 guests
- External Links
- phpBB Official
- phpBB Official (Spanish)
- Raul Arroyo Monzo
- PasionReef
- About CaniDev
- Terms of use
- Privacy Policy
- About Us
- Contact
- © 2011-2024 CaniDev