[CDB] Ajax Chat

A place for Extension Authors to post and receive feedback on Extensions still in development. No Extensions within this forum should be used within a live environment!
Suggested Hosts
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: Extensions Development rules

IMPORTANT FOR NEEDED EVENTS!!!
If you need an event for your extension please read this for the steps to follow to request the event(s)
Locked
Komanche
Registered User
Posts: 249
Joined: Thu Aug 02, 2007 10:49 am
Location: Czech Republic

Re: [DEV] Ajax Chat

Post by Komanche »

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?
User avatar
spaceace
Registered User
Posts: 1999
Joined: Wed Jan 30, 2008 8:50 pm
Contact:

Re: [DEV] Ajax Chat

Post by spaceace »

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
Registered User
Posts: 6
Joined: Thu Feb 19, 2015 12:10 am

Re: [DEV] Ajax Chat

Post by badnews52 »

very nice
User avatar
spaceace
Registered User
Posts: 1999
Joined: Wed Jan 30, 2008 8:50 pm
Contact:

Re: [ALPHA] Ajax Chat

Post by spaceace »

first post updated with a download ;)
dsaf
Registered User
Posts: 56
Joined: Wed Feb 20, 2013 7:09 pm

Re: [ALPHA] Ajax Chat

Post by dsaf »

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()
User avatar
spaceace
Registered User
Posts: 1999
Joined: Wed Jan 30, 2008 8:50 pm
Contact:

Re: [ALPHA] Ajax Chat

Post by spaceace »

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
Registered User
Posts: 56
Joined: Wed Feb 20, 2013 7:09 pm

Re: [ALPHA] Ajax Chat

Post by dsaf »

The extension was enabled successfully

Return to the extension list
Image

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.
User avatar
spaceace
Registered User
Posts: 1999
Joined: Wed Jan 30, 2008 8:50 pm
Contact:

Re: [ALPHA] Ajax Chat

Post by spaceace »

dsaf wrote:
The extension was enabled successfully

Return to the extension list
Image

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 :roll:

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
Registered User
Posts: 56
Joined: Wed Feb 20, 2013 7:09 pm

Re: [ALPHA] Ajax Chat

Post by dsaf »

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;
User avatar
spaceace
Registered User
Posts: 1999
Joined: Wed Jan 30, 2008 8:50 pm
Contact:

Re: [ALPHA] Ajax Chat

Post by spaceace »

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
Registered User
Posts: 56
Joined: Wed Feb 20, 2013 7:09 pm

Re: [ALPHA] Ajax Chat

Post by dsaf »

Ok I'll wait for the next revision. Cheers.
User avatar
spaceace
Registered User
Posts: 1999
Joined: Wed Jan 30, 2008 8:50 pm
Contact:

Re: [ALPHA] Ajax Chat

Post by spaceace »

dsaf wrote:Ok I'll wait for the next revision. Cheers.
that is why it's in Alpha :D

i also found some other issues as it seems that some old files got mixed in with the new ones :roll:
Majkell
Registered User
Posts: 44
Joined: Tue Jan 13, 2015 1:04 pm

Re: [ALPHA] Ajax Chat

Post by Majkell »

I can't turn it on in acp, because there is a error :mrgreen:
There is no this module:USER_AJAXCHAT_SETTINGS
User avatar
spaceace
Registered User
Posts: 1999
Joined: Wed Jan 30, 2008 8:50 pm
Contact:

Re: [ALPHA] Ajax Chat

Post by spaceace »

Majkell wrote:I can't turn it on in acp, because there is a error :mrgreen:
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 :lol:

anyway, i'm about to upload a new working set as an Alpha 2 version... keep your fingers crossed :lol:
Majkell
Registered User
Posts: 44
Joined: Tue Jan 13, 2015 1:04 pm

Re: [ALPHA] Ajax Chat

Post by Majkell »

spaceace wrote:
Majkell wrote:I can't turn it on in acp, because there is a error :mrgreen:
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 :lol:

anyway, i'm about to upload a new working set as an Alpha 2 version... keep your fingers crossed :lol:
Ok, no problem :)
When can I download new one :) ?
Locked

Return to “Extensions in Development”