[MODM] AjaxChat integration for XenForo

[MODM] AjaxChat integration for XenForo beta 2a

No permission to download
i am getting this error: Query: DROP TABLE IF EXISTS ajax_chat_online; Error-Report: Error-Code:

I am having the same problem and I am on Xenforo 1.4.
Also I cannot see any blocks as addons, despite the user groups all being enabled. I might add that the xml files in Block cannot be used as addon files.

If I go /forum/chat another error comes up;

Query: SELECT userID, userName, userRole, channel, UNIX_TIMESTAMP(dateTime) AS timeStamp, ip FROM `ajax_chat`.ajax_chat_online ORDER BY userName; Error-Report: Error-Code:

Any help regarding this is appreciated and this engages 1.4.
Thanks TonyB
 
Last edited:
I can now see the chat installed in the forum but when clicking 'Log in' I get this error message. No Blocks can yet be seen


Server Error
mysqli::mysqli(): (28000/1045): Access denied for user 'root'@'localhost' (using password: YES)
  1. XenForo_Application::handlePhpError()
  2. mysqli->mysqli() in /var/www/vhosts/cosmosdawn.net/httpdocs/forum/chat/lib/class/AJAXChatMySQLiDataBase.php at line 29
  3. AJAXChatDataBaseMySQLi->connect() in /var/www/vhosts/cosmosdawn.net/httpdocs/forum/chat/lib/class/AJAXChatDataBase.php at line 35
  4. AJAXChatDataBase->connect() in /var/www/vhosts/cosmosdawn.net/httpdocs/forum/chat/lib/class/AJAXChat.php at line 107
  5. AJAXChat->initDataBaseConnection() in /var/www/vhosts/cosmosdawn.net/httpdocs/forum/chat/lib/class/CustomAJAXChatInterface.php at line 17
  6. CustomAJAXChatInterface->initialize() in /var/www/vhosts/cosmosdawn.net/httpdocs/forum/chat/lib/class/AJAXChat.php at line 28
  7. AJAXChat->AJAXChat() in MODM/AJAXChat/Model/Chat.php at line 33
  8. MODM_AjaxChat_Model_Chat->__construct() in XenForo/Model.php at line 195
  9. XenForo_Model::create() in XenForo/Controller.php at line 101
  10. XenForo_Controller->getModelFromCache() in MODM/AJAXChat/ControllerPublic/Chat.php at line 421
  11. MODM_AJAXChat_ControllerPublic_Chat->_getChatModel() in MODM/AJAXChat/ControllerPublic/Chat.php at line 111
  12. MODM_AJAXChat_ControllerPublic_Chat->actionShoutbox() in XenForo/FrontController.php at line 347
  13. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  14. XenForo_FrontController->run() in /var/www/vhosts/cosmosdawn.net/httpdocs/forum/index.php at line 13
 
I can now see the chat installed in the forum but when clicking 'Log in' I get this error message. No Blocks can yet be seen


Server Error
mysqli::mysqli(): (28000/1045): Access denied for user 'root'@'localhost' (using password: YES)
That's a permission error on your part. You have either not defined a user for that DB or not given the user permission to use it.
Further, you should NOT be using a user of ROOT to access the DB, rather have a specific user set up for that.
 
That's a permission error on your part. You have either not defined a user for that DB or not given the user permission to use it.
Further, you should NOT be using a user of ROOT to access the DB, rather have a specific user set up for that.

Thanks for this advice, but how do I do this correctly? I have followed all instructions as outlined by MODM and I don't see blocks. Has the latter something to do with this? I have ticked all permission boxes to use chat in the admin panel of the permissions for all user groups.

Merci TB
 
Thanks for this advice, but how do I do this correctly? I have followed all instructions as outlined by MODM and I don't see blocks. Has the latter something to do with this? I have ticked all permission boxes to use chat in the admin panel of the permissions for all user groups.

Merci TB
I'm assuming you are referring to the "blocks" as the who is online sidebar? The only one that I know of that ships is for XenPorta - and I kicked that hunk of junk add-on to the curb many many moons ago. If you are talking about XenPorta, then you have to add it using the XML for it then add the block to XenPorta's setup.

I use BD Widgets, and it's listed in there - but I don't remember if I had to add it or not because that was a while ago.
 
Ok thanks, so I don't require any blocks perhaps.

I reinstalled ajax into httpdocs/forum/chat+config.php+styles+js+library... with the same error. So it is not in the root httpdocs. Can you advise please?
TonyB
 
Ok thanks, so I don't require any blocks perhaps.

I reinstalled ajax into httpdocs/forum/chat+config.php+styles+js+library... with the same error. So it is not in the root httpdocs. Can you advise please?
TonyB

I had this issue at first.
Go into the ACP > Options > Ajaxetcetc
You need to make SURE that the information there is correct.
It could be something as simple as putting a space you don't recognize in the DB password.
 
For some reason it's not showing a member online whose name I changed to remove an underscore and add a space. On the chat face it shows her name still with the underscore.

I'd really like to know how to change it from being titled as shoutbox to chat. :p I'm sure that's simple but I'm new to this.

It's also randomly kicking some people but not others, my details all seem good and permissions.

I've already added quite a bit but I also have All Rich Usernames which doesn't seem to go through on there, still trying to find exactly where I can edit the name colours on the actual chat window.

Hope this helps for future updates, if anyone has some advice that'd also be very welcome.
 
Last edited:
Does it work with 1.4? I can't join the chat. Just came to the Login form, but when I put in my user and passwort I'm not redirected to the chat, just to the form.

But another question: What does the integration on the Project Website mean if you'll download the testing-branch?
 
Does it work with 1.4? I can't join the chat. Just came to the Login form, but when I put in my user and passwort I'm not redirected to the chat, just to the form.
You've got something else going with it then. It works fine on my 1.4.3 site
Screen Shot 2014-12-10 at 7.03.08 PM.webp
 
You've got something else going with it then. It works fine on my 1.4.3 site
View attachment 91458

Hm. Tested it again. Did I do it right?

  • Uploaded the files
  • changed /chat/lib/config.php.sample to /chat/lib/config.php
  • installed the xf-chat-addon
  • edited the db options in the ACP
  • opened the install.php in chat-directory and deleted it after installation
Then, when i opened the chat-directory this page is shown (which says that the username is wrong)

Unbenannt-1.webp

But if I put my data into it, nothing changes.

What did I wrong?
 
Then, when i opened the chat-directory this page is shown (which says that the username is wrong)
What do you mean when you say you "opened the chat-directory"? Do you mean clicking on the link on the navbar?
When you click on the link in the nav bar you should see something similar to
Screen Shot 2014-12-11 at 7.21.38 PM.webp

and then when you click on the "Log into chat" it should log you directly to the chat box.

But if I put my data into it, nothing changes.
What did I wrong?
it looks like you are trying to directly call the php file itself from the browser?
 
What do you mean when you say you "opened the chat-directory"? Do you mean clicking on the link on the navbar?
When you click on the link in the nav bar you should see something similar to


No, in the nav bar there is nothing like that. Just the normal thing:

FireShot Capture - Modellbahn-Community Forum - http___dev.modellbahn-community.net_index.php.webp

it looks like you are trying to directly call the php file itself from the browser?

Yes, I opened it directly in the nav bar of the browser via the /chat/ behind the XF-path.

Edit: Now it works! I've checked the error logs in the ACP. There was a conflict with the Self Delete by Waindigo-addon.
 
Last edited:
Do you encounter issues while using the addon with XF 1.4 ?

Yeah, I have 1.4.1 :)

I should have updated my post. The only issues that seems to have continued would be the underscore issue and when we log in sometimes we're logged right back out and have to log in again. And when people log out sometimes there's a lot of spam listed with logging in and out.

Other than that it works great.
 
Top Bottom