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

i deleted all table shout and try installed plugin vbshout
but error data base viwed me
Invalid SQL:
CREATE TABLE `shout` (
`sid` int(15) NOT NULL auto_increment,
`s_by` int(15) NOT NULL default '0',
`s_time` int(15) NOT NULL default '0',
`s_shout` text NOT NULL,
`s_data` text NOT NULL,
`s_me` tinyint(2) NOT NULL default '0',
PRIMARY KEY (`sid`)
) TYPE=MyISAM;;

MySQL Error : Table 'shout' already exists
Error Number : 1050
Date : Tuesday, November 28th 2006 @ 06:21:52 PM
Script : http://www.itsat.org/forum/admincp/p...=productimport
Referrer : http://www.itsat.org/forum/admincp/p...?do=productadd
please help
thx

TheBlackPoet

11-29-2006 08:21 PM

man i have to tell you... imiss this hack.... my members are spoiled over it... but like the man said.. IT IS SERVER INTENSIVE... my host company server crashed my site a couple of times...
is there any way that, this can be remedied....??

Trana

11-29-2006 08:52 PM

Quote:

Originally Posted by TheBlackPoet (Post 1128284)

The v2.1 flat file update is a lot easier on server load.

da420

11-29-2006 08:54 PM

Quote:

Originally Posted by Trana (Post 1128303)

The v2.1 flat file update is a lot easier on server load.

Indeed. Much, Much better. My server load dropped by about 300%...

dina	11-30-2006 01:37 PM

I've just installed the flat file because of problems with the server load, but I was also wondering if it's possible for users to turn the shoutbox on/off in their profile? So that users who don't use the shoutbox won't cause increased server load.
I'd rather not have to split the Registered users user group in half because of the shoutbox.

da420

11-30-2006 03:07 PM

Quote:

Originally Posted by dina (Post 1128729)

No there is no way, the way it stands now, for a user to turn it off.

<MG>CP

11-30-2006 07:21 PM

Tried searching with no luck, similies are not appearing in our vBShout. They are in the right directory. Anyone familiar with this problem. Thanks in advance for any help.

xKillswitchx

11-30-2006 08:07 PM

Thanks for an update. Now, if only upgrading didn't wipe out the Top Shouters and other stats... ;)

Also, I just installed the latest version on 3.6.4 and upon posting the first two shouts, I recieved error emails from my site, but the shouts were posted...

Quote:

Invalid SQL:

select s.*, u.username, u.usergroupid from vb3shout s
left join vb3user 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

Shazz

11-30-2006 08:26 PM

Ive found so much numerous bugs in both versions..
Such as the codes. people can change the font size to 99 and you can't do anything about it.. Unless you fix the vbshout.php which Ive done

Shazz

12-01-2006 12:36 AM

so i was playin around, look at my so COOL shoutbox
:cool:

https://vborg.vbsupport.ru/external/2006/11/1.jpg

All times are GMT. The time now is 01:33 AM.

Page 242 of 334

242

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04666 seconds Memory Usage 1,745KB 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 (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (5)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: