vb.org Archive
Page 8 of 11 « First 67 8 910 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Chat Modifications - Digital Point Chat (https://vborg.vbsupport.ru/showthread.php?t=254433)

Winter Sonata 10-26-2011 01:02 AM
Quote:
Originally Posted by digitalpoint (Post 2261559)
Did you try at chat.php?
Sorry, what should I try at chat.php ?

Dave Hybrid 10-26-2011 01:57 PM
Hi Shawn,

Can you help me with the install please.

---

Chat messages do not display

Getting this DB error:

Any ideas?

Code:
Database error in vBulletin 4.1.7:

Invalid SQL:

                        SELECT chat.*, user.username, user.usergroupid, user.displaygroupid, user.infractiongroupid, user.membergroupids, IF(LENGTH(customavatar.filedata) AND customavatar.width AND customavatar.height, 1, 0) AS has_avatar, customavatar.dateline AS avatar_dateline
                        FROM tfdigitalpoint_chat AS chat
                                LEFT JOIN tfuser AS user ON (user.userid = chat.userid)
                                LEFT JOIN tfcustomavatar ON(customavatar.userid = user.userid)
                       
                        ORDER BY chatid DESC
                        LIMIT 50;

MySQL Error  : Unknown column 'customavatar.filedata' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, October 26th 2011 @ 02:55:01 PM
Error Date    : Wednesday, October 26th 2011 @ 02:55:01 PM
Script        : http://www.travel-fans.com/chat.php?do=ajax
Referrer      : http://www.travel-fans.com/chat.php
IP Address    : 62.255.192.162
Username      : Hybrid
Classname    : vB_Database
MySQL Version : 5.5.17-cll

jchaffin 10-26-2011 05:29 PM
Having the same issue as some others. Submitted chat does not show up. Running 4.1.2.

***Nevermind it is working now. Great mod. Thanks.

digitalpoint 10-27-2011 02:04 AM
Quote:
Originally Posted by Dave Hybrid (Post 2261703)
Hi Shawn,

Can you help me with the install please.

---

Chat messages do not display

Getting this DB error:

Any ideas?

Code:
Database error in vBulletin 4.1.7:

Invalid SQL:

                        SELECT chat.*, user.username, user.usergroupid, user.displaygroupid, user.infractiongroupid, user.membergroupids, IF(LENGTH(customavatar.filedata) AND customavatar.width AND customavatar.height, 1, 0) AS has_avatar, customavatar.dateline AS avatar_dateline
                        FROM tfdigitalpoint_chat AS chat
                                LEFT JOIN tfuser AS user ON (user.userid = chat.userid)
                                LEFT JOIN tfcustomavatar ON(customavatar.userid = user.userid)
                       
                        ORDER BY chatid DESC
                        LIMIT 50;

MySQL Error  : Unknown column 'customavatar.filedata' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, October 26th 2011 @ 02:55:01 PM
Error Date    : Wednesday, October 26th 2011 @ 02:55:01 PM
Script        : http://www.travel-fans.com/chat.php?do=ajax
Referrer      : http://www.travel-fans.com/chat.php
IP Address    : 62.255.192.162
Username      : Hybrid
Classname    : vB_Database
MySQL Version : 5.5.17-cll
In chat.php, change this:
PHP Code:
LEFT JOIN " . TABLE_PREFIX . "customavatar ON (customavatar.userid = user.userid) 
to this:
PHP Code:
LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON (customavatar.userid = user.userid) 

Dave Hybrid 10-27-2011 09:40 AM
Sorted, thanks!

On another note are you releasing your best answer mod here at all?

That one looks sweet too.

Dave.

digitalpoint 10-27-2011 05:25 PM
No sorry... have to keep some stuff or else my site wouldn't be unique. :)

I think there is an addon here at vb.org that does something similar though.

Winter Sonata 11-04-2011 10:05 PM
Thanks Shawn .....

I ave a custome style and the chat doesn't show up anywhere, any ideas ?

Dave Hybrid 11-04-2011 10:13 PM
Hey Shawn,

Is it possible to include avatars like on DP?

Also is it possible to stop the 'entering' and 'leaving' messages, they clog the window up on my forum.

digitalpoint 11-04-2011 11:09 PM
I thought avatars were included? Hmmm... can you give me a link to where you have it installed?

Dave Hybrid 11-05-2011 01:24 PM
Sure here two :)

http://www.travel-fans.com/chat.php

http://www.computer-juice.com/forums/chat.php

Thanks!


All times are GMT. The time now is 10:46 AM.
Page 8 of 11 « First 67 8 910 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01275 seconds
  • Memory Usage 1,748KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (2)bbcode_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete