AjaxChat Integration (latest version 3.2.1)

[Jiveturkey]

Do you have Pretty URL's installed?

[Nemesis_D]

i have tried over and over to install this mod via the package manager but it just doesn't work
after i clicked it to install all it does is refresh the page

this is using smf 1.1.8 and the mod is the 3.0

i would really like to use this mod so is there any thing i can do?

[EclecticHoobajoo]

In all these pages I still haven't found a way to install this.  I'm trying on Step 1 - installing the Ajax Chat program itself.  I upload all the files to my smf/chat folder, and make sure all folders are set as 755 and files 666 for permissions.  Then I run chat/install.php and get this error:

Query: CREATE TABLE ajax_chat_online ( userID INT(11) NOT NULL, userName VARCHAR(64) NOT NULL, userRole INT(1) NOT NULL, channel INT(11) NOT NULL, dateTime DATETIME NOT NULL, ip VARBINARY(16) NOT NULL ) DEFAULT CHARSET=utf8 COLLATE=utf8_bin; Error-Report: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8 COLLATE=utf8_bin' at line 8 Error-Code: 1064

Someone had a similar problem earlier, but I never saw a fix for it posted. 
My default language is just English, not English-utf8, so I also tried to put English in the chat.sql file and run install again, but got the same error with English in place of utf8.


I'm running SMF 1.1.8, classic theme.

@ EclecticHoobajoo

All you have to do is install the AJAX Chat Intergration Mod itself. It now installs the chat as well.

I don't know what's what any more for this.    Is someone going to post new install instructions?
I downloaded the new version of the chat integration from the smf site (version 3).  I uploaded the zip file and tried to "Apply Mod" in the package manager, and all it did was take me back to the package manager screen, no messages or anything. 
So I tried uploading the chat folder to smf/chat and shoutbox to smf/shoutbox, and root files in the zip to smf/.  The Readme in the zip file (in the chat folder) said to run install.php, but that file does not exist in the new zip file!  So I tried to create the tables by running smf/Tables_1.1.X.php, but it said "Hacking attempt".  So I went into smf/chat just to see if anything at all showed up, and I got this error:

Query: SELECT userID, userName, userRole, channel, UNIX_TIMESTAMP(dateTime) AS timeStamp, ip FROM `user_525799`.ajax_chat_online WHERE NOW() <= DATE_ADD(dateTime, interval 2 MINUTE) ORDER BY userName; Error-Report: Table 'user_525799.ajax_chat_online' doesn't exist Error-Code: 1146

So I still can't get tables created.  And  I looked into that tables file and saw that DEFAULT CHARSET=utf8 is in there, and I'm afraid I'll just end up with my original problem if by some miracle I can get the tables created.  My default forum language is English, not English utf8.


Is this chat program even worth bothering with?  56 pages of support and no updated install instructions are making me think not.
Are there any better chat programs out there, besides FlashChat, I've never liked that one.

[Gul Ducat]

I have also given up on this.  It's garbage.

While I do not want to sound unappreciative, it fries me when I DL a mod that is posted as recently updated, yet it has ZERO details on what to do with it, or how to make it work.  Granted, they are free, then again, so is Herpes and I don't really want it.

I would conservatively estimate that over 60% of the downloadable mods listed are in the Garbage category either due to being grossly outdated, useless, buggy, undocumented, wrong language, or all of the above.

Sorry to rant, but it was a piece of $$IT mod that I blew up my 1.18 installation and had to resort to RC1.  Then of course there's the infamous shameless plugs and copyright notices that get placed at the bottom of your SMF index page by crappy mod writers who leave the notices installed even after removal of the offending non-working mod.

[getandshare]

mrtrc266
Yes you'll have to edit the files manually in yourforum/Themes/airy_midnight20rc .You didn't get any errors cuz it ALL Mods only install on the default theme, if you switch to the default theme it should be working.

Thats also the same reason you don't see all the Top Stats.

Attatch your yourforumsmf2/Themes/airy_midnight20rc/index.template.php and style.css files if you can't get it going.

Here are they...
I checked the default theme btw, shoutbox seems working ok in it....
But Top Stats is not displaying latest post in the default theme as well....
(you can take a look at www.getandshare.co.nr    username:-demo , password:-demo)

I have one more problem... chatbox is always saying error in connection in ajax chat.. also... i want to increase the inactivity time after which chat room kicks anyone out...

[mrtrc266]

I have also given up on this.  It's garbage.

While I do not want to sound unappreciative, it fries me when I DL a mod that is posted as recently updated, yet it has ZERO details on what to do with it, or how to make it work.  Granted, they are free, then again, so is Herpes and I don't really want it.

I would conservatively estimate that over 60% of the downloadable mods listed are in the Garbage category either due to being grossly outdated, useless, buggy, undocumented, wrong language, or all of the above.

Sorry to rant, but it was a piece of $$IT mod that I blew up my 1.18 installation and had to resort to RC1.  Then of course there's the infamous shameless plugs and copyright notices that get placed at the bottom of your SMF index page by crappy mod writers who leave the notices installed even after removal of the offending non-working mod.

Dang you give up so easily Instead of bashing a Mod that's working great for thousands of people why not try posting a comment explaining what the problem is on the support thread?

Also how can any Mod blow up your forum if you backed up, you did back up didn't you? 

Anyway if you want help getting this going try posting a comment with what the problem/error is and we will do our best help you get it going.

[Jiveturkey]

mrtc226,

Any thoughts on my IP issue?  I don't like that regular members can see it on another members profile.  I don't even need to see it as the admin.  I'd really like to have it removed from member list options.

[mrtrc266]

In all these pages I still haven't found a way to install this.  I'm trying on Step 1 - installing the Ajax Chat program itself.  I upload all the files to my smf/chat folder, and make sure all folders are set as 755 and files 666 for permissions.  Then I run chat/install.php and get this error:

Query: CREATE TABLE ajax_chat_online ( userID INT(11) NOT NULL, userName VARCHAR(64) NOT NULL, userRole INT(1) NOT NULL, channel INT(11) NOT NULL, dateTime DATETIME NOT NULL, ip VARBINARY(16) NOT NULL ) DEFAULT CHARSET=utf8 COLLATE=utf8_bin; Error-Report: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8 COLLATE=utf8_bin' at line 8 Error-Code: 1064

Someone had a similar problem earlier, but I never saw a fix for it posted. 
My default language is just English, not English-utf8, so I also tried to put English in the chat.sql file and run install again, but got the same error with English in place of utf8.

I'm running SMF 1.1.8, classic theme.

I don't know what's what any more for this.    Is someone going to post new install instructions?
I downloaded the new version of the chat integration from the smf site (version 3).  I uploaded the zip file and tried to "Apply Mod" in the package manager, and all it did was take me back to the package manager screen, no messages or anything. 
So I tried uploading the chat folder to smf/chat and shoutbox to smf/shoutbox, and root files in the zip to smf/.  The Readme in the zip file (in the chat folder) said to run install.php, but that file does not exist in the new zip file!  So I tried to create the tables by running smf/Tables_1.1.X.php, but it said "Hacking attempt".  So I went into smf/chat just to see if anything at all showed up, and I got this error:

Query: SELECT userID, userName, userRole, channel, UNIX_TIMESTAMP(dateTime) AS timeStamp, ip FROM `user_525799`.ajax_chat_online WHERE NOW() <= DATE_ADD(dateTime, interval 2 MINUTE) ORDER BY userName; Error-Report: Table 'user_525799.ajax_chat_online' doesn't exist Error-Code: 1146

So I still can't get tables created.  And  I looked into that tables file and saw that DEFAULT CHARSET=utf8 is in there, and I'm afraid I'll just end up with my original problem if by some miracle I can get the tables created.  My default forum language is English, not English utf8.


Is this chat program even worth bothering with?  56 pages of support and no updated install instructions are making me think not.
Are there any better chat programs out there, besides FlashChat, I've never liked that one.

The Install is usually as easy as uploading it via your package manager and clicking install. The install instructions that you see in the readme file is the readme file that comes with AJAX Chat if you want to install it stand alone, but then it has to be intergrated which is what this Mod does....and it does it well for thousands of people.

Undo everything you did and upload the package, if you can't upload it via the package manager for some reason upload it to your packages directory via FTP. Then hit "Install" and then hit "Apply Mod"

It should be that easy.

[mrtrc266]

mrtc226,

Any thoughts on my IP issue?  I don't like that regular members can see it on another members profile.  I don't even need to see it as the admin.  I'd really like to have it removed from member list options.

It seem that this happens if you allow your users to add events to your calendar, that's kinda a small moderator right so it thinks they are mods LOL.

Try this though....
http://www.simplemachines.org/community/index.php?topic=257973.msg1979606#msg1979606

[Jiveturkey]

Problem solved.  I'm lovin' this mod.

Thanks for all of your help.

[mrtrc266]

i have tried over and over to install this mod via the package manager but it just doesn't work
after i clicked it to install all it does is refresh the page

this is using smf 1.1.8 and the mod is the 3.0

i would really like to use this mod so is there any thing i can do?

Try uploading it to your packages directory via FTP

[mrtrc266]

Problem solved.  I'm lovin' this mod.

Thanks for all of your help.

NP glad you got it sorted out and thanks for the find and fix for Pretty URLs. Enjoy

[Josh555]

I'm having problems installing this on endless_mc by crip, ill attach the files here maybe someone can help.

SMF 1.1.8

[mrtrc266]

@ getandshare 

Here you go...

For the Top Stats Mod make sure you go to Admin/Current Theme and set "Number of recent posts to display on board index:" to 23

[mrtrc266]

I'm having problems installing this on endless_mc by crip, ill attach the files here maybe someone can help.

SMF 1.1.8

Give this a shot Josh

[dextrous]

@dextrous

You installed this via the package manager?

Yes, found it under SMF mods! I did something wrong, I'm guessing

any help? i can't find a useful readme in the package...and cannot possibly read through 56 pages to get the answer!

[Josh555]

EDIT: Nvm.

[getandshare]

@ getandshare 

Here you go...

For the Top Stats Mod make sure you go to Admin/Current Theme and set "Number of recent posts to display on board index:" to 23

Top stats is okay now...
But there is a problem with my display am attaching the thumbnails..

After_before_logout.JPG  shows the view of login screen...ie... starting screen.... Mark the top right corner...

After_1_login.JPG  shows the view of screen after user has loged in...(it is still showing the login window + the ad,  top right corner).....(this view is after modification...)....(ad is needed only for first page and since my forum is loged it was getting displayed only on first page)

Before_1_login.JPG  shows the view of screen after user has loged in....( it is not showing the ad)..... (this view is before modification)...

can you fix it please

[EZ1]

help please i was uploading this mod then got this --


The server encountered an unexpected condition which prevented it from fulfilling the request.
The script had an error or it did not produce any output. If there was an error, you should be able to see it in the error log.

my link is --
http://frc4u.org/phpbb/


got it fixed just made the mirror the primary forums

[mrtrc266]

EDIT: Nvm.

Did that work for you? Not sure was Nvm is LOL