vb.org Archive - [AJAX] vBShout v2.0

Hey guys,
Im getting this problem:

Tonight got a an e-mail from my forum:
Database error in vBulletin :

mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/rvracing/public_html/pitbikeclub/vb/includes/class_core.php on line 279

MySQL Error :
Error Number :
Date : Thursday, February 2nd 2006 @ 12:28:01 PM
Script : http://www.pitbikeclub.co.uk/vb/vbshout.php
Referrer : http://www.pitbikeclub.co.uk/vb/index.php
IP Address : 213.249.236.98
Username :
Classname : vb_database

Now when you go to:
www.pitbikeclub.co.uk/vb/vbshout.php

It looks ll wierd and has lost everything.

Can anyone help?

S@NL - BlackBik

02-02-2006 08:10 PM

Offcourse that looks weird. It's out of the template, just raw data :)
The shoutbox looks good on your forumhome though ;)

Reece^B

02-02-2006 08:23 PM

lol thank you. However, what caused this to happen? How can it be fixed?

S@NL - BlackBik

02-02-2006 08:29 PM

I can't see anything wrong with it.
Just don't open vbshout.php in your browser, but use shoutbox from your forumhome as it's supposed to. :)

As what could have caused the sql error, i don't have a clue. I'm not an expert on that.

Tulsa

02-02-2006 10:42 PM

Quote:

Originally Posted by thisgeek

Disabling auto refresh and adding a 'refresh' button

Go to style manager, and edit (or customize) the template forumhome_vbshout

Find text:

HTML Code:

<input type="submit" value="Shout" class="button" />

And add immediately BELOW it:

HTML Code:

<input type='button' class='button' value='Refresh' onclick='requestShouts()' />

The code must go above the 'if condition' code.
This line occurs twice - add the new button to both.

THEN

Find the text:

Code:

setTimeout('requestShouts()', 10000)

And comment it out by enclosing it with /* and */ like so:

Code:

/* setTimeout('requestShouts()', 10000) */

You can also delete the line entirely.

The shoutbox will now only refresh if you a) Submit a shout, or b) hit the 'refresh' button.

This works very well, thank you.

Big_Ern

02-03-2006 12:02 AM

any idea how to change the Banned usergroups to a Include usergroups?

Dark Dragon

02-04-2006 02:47 AM

On the homepage, the shoutbox just says "Loading..." the whole time, but when I actually look at vbshout.php I can see the shouts and stuff. Anybody know what's wrong?

GamerJunk.net

02-04-2006 03:39 AM

Nobody knows how to make this only show in the right sidebar on a page?

For example my site... www.gsnforce.com/forum

redundanthost

02-04-2006 03:40 AM

please check http://www.myspaceshack.com/forums

anyone know why the blank area under the shoutbox does that? and it grows?

SnappedAgain

02-04-2006 08:14 PM

Im not sure if this has been covered yet but I keep getting a db error email ALL THE TIME and it's killing my INBOX LOL :speechless:

Any ideas??
Im using vb3.5.3 with mysql 5.0.11 and php 5.1
thanks in advance

Code:

Database error in vBulletin 3.5.3:



Invalid SQL:



                        select s.*, u.username, u.usergroupid from shout s

                        left join user u on (u.userid = s.s_by)

                        order by s.sid desc limit;



MySQL Error  : 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 '' at

line 3

Error Number : 1064

Date         : Saturday, February 4th 2006 @ 02:50:23 PM

Script       : http://www.nastyss.com/forums/vbshout.php

Referrer     : http://www.nastyss.com/forums/index.php?

IP Address   : 67.186.239.155

Username     : 91gsx_turbo

Classname    : vB_Database

All times are GMT. The time now is 07:56 AM.

Page 125 of 334

125

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.07612 seconds Memory Usage 1,747KB 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 (3)bbcode_code_printable (2)bbcode_html_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (6)pagenav_pagelinkrel (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
Messages: