vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   [AJAX] vBShout v2.0 (https://vborg.vbsupport.ru/showthread.php?t=93097)

Neal-UK 07-30-2005 12:22 AM

Quote:

Originally Posted by Boofo
Great! Then this will blow IB's version all to you-know-where! ;)

Got this error when trying to upgrade, but itworked when unistalled and installed fresh:
Database error in vBulletin 3.5.0 Release Candidate 1:

Invalid SQL:
CREATE TABLE `FORUMshout` (
`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,
PRIMARY KEY (`sid`)
) ENGINE=MyISAM;;

MySQL Error : Table 'FORUMshout' already exists
Error Number : 1050
Date : Saturday, July 30th 2005 @ 01:15:05 AM
Script : http://www.burnleyweb.com/community/admincp/plugin.php
Referrer : http://www.burnleyweb.com/community/...?do=productadd
IP Address : 212.***.***.***
Username : ******
Classname : vb_database

Sovereign 07-30-2005 02:53 AM

How 'bout using this with the CMPS? Is this doable?

cclaerhout 07-30-2005 07:58 AM

Quote:

Originally Posted by nealparry
Got this error when trying to upgrade, but itworked when unistalled and installed fresh:
Database error in vBulletin 3.5.0 Release Candidate 1:

Invalid SQL:
CREATE TABLE `FORUMshout` (
`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,
PRIMARY KEY (`sid`)
) ENGINE=MyISAM;;

MySQL Error : Table 'FORUMshout' already exists
Error Number : 1050
Date : Saturday, July 30th 2005 @ 01:15:05 AM
Script : http://www.burnleyweb.com/community/admincp/plugin.php
Referrer : http://www.burnleyweb.com/community/...?do=productadd
IP Address : 212.***.***.***
Username : ******
Classname : vb_database


You certainly used Shoutbox before. I had the same problem. I solve it with a drop of table shout in phpmyadmin. To avoid this (i don't know if it's possible) the script should check if the table exists or not and then behaves differently.

cclaerhout 07-30-2005 08:09 AM

Quote:

Originally Posted by cuphongle
zero tolerance...u know how i can add a quick reply to a different style?

Go to your Admincp -> Styles & Templates -> Select the style you want to modify -> and edit templates : forumhome_vbshout and forumhome_vbshout_shout. Just save them.

But don't forget, if there's an update of vBShout, you will have to update manually the templates you have changed. Why ? Because the product manager installs templates in the master style and your different styles use its settings except if you customize them.

Loki12 07-30-2005 08:16 AM

Are guests able to use the shoutbox? Is there a way to restrict its usage to certain usergroups?

cuphongle 07-30-2005 05:13 PM

zero tolerance - i keep gettin database error every now and then

monstergamer 07-30-2005 05:39 PM

this is a fresh install for me
and i keep getting, i use to have a shout box when i had 3.0.7 but i deleted the shout table in PHPmyadmin

PHP Code:

Invalid SQL:
CREATE TABLE `shout` (
  `
sidint(15NOT NULL auto_increment,
  `
s_byint(15NOT NULL default '0',
  `
s_timeint(15NOT NULL default '0',
  `
s_shouttext NOT NULL,
  
PRIMARY KEY  (`sid`)
ENGINE=MyISAM;;

MySQL Error  You have an error in your SQL syntax near 'ENGINE=MyISAM' at line 7
Error Number 
1064 


Boofo 07-30-2005 07:48 PM

Take the extra semi-colon out of the end of this line. ;)

Quote:

) ENGINE=MyISAM;;

monstergamer 07-30-2005 08:02 PM

now i get

PHP Code:

Database error in vBulletin 3.5.0 Release Candidate 1:

Invalid SQL:
alter table shout add `s_datatext not null default '';;

MySQL Error  Table 'mg_forum.shout' doesn't exist
Error Number : 1146
Date         : Saturday, July 30th 2005 @ 05:16:35 PM
Script       : http://www.monstergamer.net/vb/admincp/plugin.php 


Boofo 07-30-2005 08:04 PM

Ok, do like he told me to do. Make the table manually, then un-install the product and re-install it.


All times are GMT. The time now is 12:39 PM.

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.02943 seconds
  • Memory Usage 1,754KB
  • 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_php_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)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