cBB Chat 1.2.0 with MySQL 5.7+


Avatar de Usuario
Leinad4Mind
 
Mensajes: 213
Registrado: Jue Oct 15, 2015 10:10 pm
 Jue Mar 14, 2019 8:56 pm • a través de Web
You need to fix one SQL Query (Remove the group by or fixing the Select):

Código: Seleccionar todo
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!
Avatar de Usuario
IvanPF
Administrador
 
Mensajes: 2010
Registrado: Vie Jun 17, 2011 12:15 am
Ubicación: España (Spain)
 Vie Mar 15, 2019 12:53 pm • a través de Web
Thanks for report.
I will check it
Avatar de Usuario
IvanPF
Administrador
 
Mensajes: 2010
Registrado: Vie Jun 17, 2011 12:15 am
Ubicación: España (Spain)
 Vie Mar 15, 2019 3:09 pm • a través de Web
To solve this problem do this:
1. Open /ext/canidev/chat/libraries/chat.php
2. Find:
Código: Seleccionar todo
      $sql = 'SELECT *
         FROM ' . SMILIES_TABLE . '
         GROUP BY smiley_url
         ORDER BY smiley_order';

3. Replace with:
Código: Seleccionar todo
      $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';
no_avatar
BitRooT
 
Mensajes: 6
Registrado: Mié Mar 13, 2019 10:25 pm
 Vie Mar 15, 2019 3:37 pm • a través de iPhone
Nice - I had the same problem. Thanks for the answer.
Avatar de Usuario
Leinad4Mind
 
Mensajes: 213
Registrado: Jue Oct 15, 2015 10:10 pm
 Dom Mar 17, 2019 8:00 pm • a través de 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
Avatar de Usuario
IvanPF
Administrador
 
Mensajes: 2010
Registrado: Vie Jun 17, 2011 12:15 am
Ubicación: España (Spain)
 Dom Mar 17, 2019 8:06 pm • a través de 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
Avatar de Usuario
Leinad4Mind
 
Mensajes: 213
Registrado: Jue Oct 15, 2015 10:10 pm
 Dom Mar 17, 2019 8:55 pm • a través de Web
No problem. Thanks!
Avatar de Usuario
Leinad4Mind
 
Mensajes: 213
Registrado: Jue Oct 15, 2015 10:10 pm
 Dom Mar 17, 2019 9:02 pm • a través de 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:

Código: Seleccionar todo
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
Avatar de Usuario
IvanPF
Administrador
 
Mensajes: 2010
Registrado: Vie Jun 17, 2011 12:15 am
Ubicación: España (Spain)
 Lun Mar 18, 2019 11:26 am • a través de 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:
Código: Seleccionar todo
            $timestamp       = 0;
            $parse_flags   = ($row['bbcode_bitfield'] ? OPTION_FLAG_BBCODE : 0) | OPTION_FLAG_SMILIES;

3. Replace with:
Código: Seleccionar todo
            $timestamp       = 0;
            $parse_flags   = (!empty($row['bbcode_bitfield']) ? OPTION_FLAG_BBCODE : 0) | OPTION_FLAG_SMILIES;


PD: The package is updated with this fix.
Avatar de Usuario
Leinad4Mind
 
Mensajes: 213
Registrado: Jue Oct 15, 2015 10:10 pm
 Lun Mar 18, 2019 12:24 pm • a través de 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.)
Siguiente

¿Quién está conectado?

Usuarios navegando por este Foro: No hay usuarios registrados visitando el Foro y 0 invitados