- Estás aquí:
- Inicio › Foro › Application Support › cBB Chat
cBB Chat 1.2.0 with MySQL 5.7+
15 mensajes
• Página 1 de 2 • 1, 2
- 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):
PS: Great job with this update! Love the view more ajax thing! Keep up the great work!
- 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!
- 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
I will check it
- 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:
3. Replace with:
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';
-
- 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.
- 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
[phpBB Debug] PHP Notice: in file [ROOT]/ext/canidev/chat/libraries/action_manager.php on line 95: Undefined variable: container
- 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
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
- 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!
- 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:
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
- 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:
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:
- 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.
- 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.)
(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 mensajes
• Página 1 de 2 • 1, 2
¿Quién está conectado?
Usuarios navegando por este Foro: No hay usuarios registrados visitando el Foro y 0 invitados
- Contenido
- Descargas
- En desarrollo
- Comunidad y Soporte
- Rss
- Enlaces de Interés
- phpBB Oficial
- phpBB Oficial (Español)
- Raul Arroyo Monzo
- PasionReef
- Sobre CaniDev
- Condiciones de uso
- Política de Privacidad
- Sobre nosotros
- Contacto
- © 2011-2024 CaniDev