[CDB] Ajax Chat

Komanche · Post by **Komanche** » Thu Feb 19, 2015 7:16 pm

When I switch to not see on index, I cannot see it anymore anywhere...
I would like to have chat on separate window, not showing all topics... Possible?

spaceace · Post by **spaceace** » Thu Feb 19, 2015 8:49 pm

Komanche wrote:When I switch to not see on index, I cannot see it anymore anywhere...
I would like to have chat on separate window, not showing all topics... Possible?

because that is a switch that turns the users view off. from within the chat is how you get to the popup.

are you asking to turn it off on the index but still have a button to show chat in a popup(new window)?

badnews52 · Post by **badnews52** » Fri Feb 20, 2015 11:40 am

very nice

spaceace · Post by **spaceace** » Sun Feb 22, 2015 8:21 pm

first post updated with a download

dsaf · Post by **dsaf** » Sun Feb 22, 2015 9:08 pm

Installed:

Code: Select all

General Error
SQL ERROR [ mysqli ]

Table 'phpbb312test.phpbb_ajax_chat' doesn't exist [1146]

SQL

SELECT c.*, u.user_avatar, u.user_avatar_type FROM phpbb_ajax_chat as c LEFT JOIN egcn_users as u ON c.user_id = u.user_id ORDER BY message_id DESC LIMIT 36

BACKTRACE

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

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

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

FILE: [ROOT]/phpbb/db/driver/mysql_base.php
LINE: 45
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 261
CALL: phpbb\db\driver\mysql_base->_sql_query_limit()

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

FILE: [ROOT]/ext/spaceace/ajaxchat/controller/shout.php
LINE: 145
CALL: phpbb\db\driver\factory->sql_query_limit()

FILE: [ROOT]/ext/spaceace/ajaxchat/event/listener.php
LINE: 113
CALL: spaceace\ajaxchat\controller\shout->index()

FILE: (not given by php)
LINE: (not given by php)
CALL: spaceace\ajaxchat\event\listener->index()

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

FILE: [ROOT]/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/EventDispatcher.php
LINE: 53
CALL: Symfony\Component\EventDispatcher\EventDispatcher->doDispatch()

FILE: [ROOT]/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/ContainerAwareEventDispatcher.php
LINE: 167
CALL: Symfony\Component\EventDispatcher\EventDispatcher->dispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 60
CALL: Symfony\Component\EventDispatcher\ContainerAwareEventDispatcher->dispatch()

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

FILE: [ROOT]/index.php
LINE: 198
CALL: phpbb\event\dispatcher->trigger_event()

spaceace · Post by **spaceace** » Sun Feb 22, 2015 9:37 pm

dsaf wrote:Installed:

Code: Select all

General Error
SQL ERROR [ mysqli ]

Table 'phpbb312test.phpbb_ajax_chat' doesn't exist [1146]

SQL

SELECT c.*, u.user_avatar, u.user_avatar_type FROM phpbb_ajax_chat as c LEFT JOIN egcn_users as u ON c.user_id = u.user_id ORDER BY message_id DESC LIMIT 36

BACKTRACE

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

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

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

FILE: [ROOT]/phpbb/db/driver/mysql_base.php
LINE: 45
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 261
CALL: phpbb\db\driver\mysql_base->_sql_query_limit()

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

FILE: [ROOT]/ext/spaceace/ajaxchat/controller/shout.php
LINE: 145
CALL: phpbb\db\driver\factory->sql_query_limit()

FILE: [ROOT]/ext/spaceace/ajaxchat/event/listener.php
LINE: 113
CALL: spaceace\ajaxchat\controller\shout->index()

FILE: (not given by php)
LINE: (not given by php)
CALL: spaceace\ajaxchat\event\listener->index()

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

FILE: [ROOT]/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/EventDispatcher.php
LINE: 53
CALL: Symfony\Component\EventDispatcher\EventDispatcher->doDispatch()

FILE: [ROOT]/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/ContainerAwareEventDispatcher.php
LINE: 167
CALL: Symfony\Component\EventDispatcher\EventDispatcher->dispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 60
CALL: Symfony\Component\EventDispatcher\ContainerAwareEventDispatcher->dispatch()

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

FILE: [ROOT]/index.php
LINE: 198
CALL: phpbb\event\dispatcher->trigger_event()

can you check in your database tool(phpmyadmin) if the table is being installed with a different prefix? also, does the ext install successfully?

dsaf · Post by **dsaf** » Sun Feb 22, 2015 9:43 pm

The extension was enabled successfully

Return to the extension list

Tables are there,

Code: Select all

SELECT * 
FROM  `egcn_ajax_chat` 
LIMIT 0 , 30

Code: Select all

SELECT * 
FROM  `egcn_ajax_chat_sessions` 
LIMIT 0 , 30

Appears because I use EGCN as a prefix, thats causing the conflict.

spaceace · Post by **spaceace** » Sun Feb 22, 2015 9:50 pm

dsaf wrote:
The extension was enabled successfully

Return to the extension list

Tables are there,
Code: Select all
SELECT * 
FROM  `egcn_ajax_chat` 
LIMIT 0 , 30
Code: Select all
SELECT * 
FROM  `egcn_ajax_chat_sessions` 
LIMIT 0 , 30
Appears because I use EGCN as a prefix, thats causing the conflict.

it's in the controller chat.php. seems i have a hard coded table prefix

for now
open ext/spaceace/ajaxchat/controller/chat.php
find

Code: Select all

        define('CHAT_TABLE', 'phpbb_ajax_chat');
        define('CHAT_SESSIONS_TABLE', 'phpbb_ajax_chat_sessions');

in your case
replace with

Code: Select all

        define('CHAT_TABLE', egcn_ajax_chat');
        define('CHAT_SESSIONS_TABLE', 'egcn_ajax_chat_sessions');

i will work on a fix for github

dsaf · Post by **dsaf** » Sun Feb 22, 2015 10:04 pm

Thanks, Have changed it, but same error still occurs??

Code: Select all

        ];
        define('CHAT_TABLE', 'egcn_ajax_chat');
        define('CHAT_SESSIONS_TABLE', 'egcn_ajax_chat_sessions');
        include $this->root_path . 'includes/functions_posting.' . $this->php_ext;

spaceace · Post by **spaceace** » Sun Feb 22, 2015 11:24 pm

dsaf wrote:Thanks, Have changed it, but same error still occurs??

Code: Select all

        ];
        define('CHAT_TABLE', 'egcn_ajax_chat');
        define('CHAT_SESSIONS_TABLE', 'egcn_ajax_chat_sessions');
        include $this->root_path . 'includes/functions_posting.' . $this->php_ext;

similar edits need to be made to popup.php and shout.php and that will get rid of the error. still working on a solution. next issue for you might be that the chat might not post messages

dsaf · Post by **dsaf** » Sun Feb 22, 2015 11:26 pm

Ok I'll wait for the next revision. Cheers.

spaceace · Post by **spaceace** » Sun Feb 22, 2015 11:35 pm

dsaf wrote:Ok I'll wait for the next revision. Cheers.

that is why it's in Alpha

i also found some other issues as it seems that some old files got mixed in with the new ones

Majkell · Post by **Majkell** » Sun Feb 22, 2015 11:53 pm

I can't turn it on in acp, because there is a error

There is no this module:USER_AJAXCHAT_SETTINGS

spaceace · Post by **spaceace** » Mon Feb 23, 2015 12:29 am

Majkell wrote:I can't turn it on in acp, because there is a error
There is no this module:USER_AJAXCHAT_SETTINGS

some of my files got mixed up when i was setting everything up on github... i'm new to github and currently don't like it very much

anyway, i'm about to upload a new working set as an Alpha 2 version... keep your fingers crossed

Majkell · Post by **Majkell** » Mon Feb 23, 2015 12:42 am

spaceace wrote:
Majkell wrote:I can't turn it on in acp, because there is a error
There is no this module:USER_AJAXCHAT_SETTINGS
some of my files got mixed up when i was setting everything up on github... i'm new to github and currently don't like it very much

anyway, i'm about to upload a new working set as an Alpha 2 version... keep your fingers crossed

Ok, no problem

When can I download new one

?

advertisements