vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Add-On Releases - [ITech] [AJAX] Inferno vBShout Lite 2.5.0 (https://vborg.vbsupport.ru/showthread.php?t=147346)

Nudda 04-05-2008 05:06 AM

Yup, getting the same error.

Kiros72 04-05-2008 05:07 AM

And I uninstalled it, reinstalled it (without reuploading the files) and it seems to work fine, except, like ranj, the shouts are not visible. Also, the "Options" page is... empty. 0_o

PimvanJ 04-05-2008 08:26 AM

After upgrading this mesage in the shout (forum runs normaly but has some strange lay-out, fonts are different)

Quote:

Database error in vBulletin 3.6.8:

Invalid SQL:

select s.*, u.username, u.displaygroupid, u.usergroupid, u.userid, o.*
from infernoshout s
left join user u on (u.userid = s.s_user)
left join infernoshoutusers o on (o.s_user = s.s_user)
where
(
(s.s_private = -1)
OR
(s.s_private = '1')
OR
(s.s_private <> -1 AND s.s_user = '1')
)
and
(
o.s_silenced = '0'
OR
(o.s_silenced <> '0' AND u.userid = '1')
)

order by s.s_time desc
limit 20;

MySQL Error : Unknown column 's.s_private' in 'where clause'
Error Number : 1054
Date : Saturday, April 5th 2008 @ 11:20:45 AM
Script : http://mydomain/infernoshout.php
Referrer : http://mydomain/index.php
IP Address : xxxxxxxxxxxx
Username : xxx
Classname : vB_Database
Any idea what this means?

reteep 04-05-2008 11:16 AM

Getting the same error as PimvanJ.

anoob 04-05-2008 11:43 AM

I am getting a simular message too.
Quote:

Database error in vBulletin 3.6.8:

Invalid SQL:

select s.*, u.username, u.displaygroupid, u.usergroupid, u.userid, o.*
from infernoshout s
left join user u on (u.userid = s.s_user)
left join infernoshoutusers o on (o.s_user = s.s_user)
where
(
(s.s_private = -1)
OR
(s.s_private = '6')
OR
(s.s_private <> -1 AND s.s_user = '6')
)
and
(
o.s_silenced = '0'
OR
(o.s_silenced <> '0' AND u.userid = '6')
)

order by s.s_time desc
limit 15;

MySQL Error : Unknown column 's.s_private' in 'where clause'
Error Number : 1054

Inferno Tech 04-05-2008 12:31 PM

Hey guys, sounds like two separate issues here - the first seems like it's being caused by the shoutbox being updated without being uninstalled first, the second sounds like it's being caused by missing files.

Can i ask you to completely remove the shoutbox from your server, then to try installing 2.5.0 from scratch and see if that works? If not could you head over to the support forums (a link is in the main mod post) So we can keep track of all the support in one place?

Thanks a lot =)

Iain "Decado" Kidd

PimvanJ 04-05-2008 01:15 PM

I will when I found some time.
Thank You for Your quick response.

Keep up the good work!:up:

ranj 04-05-2008 04:11 PM

Its working i don't know after like 10 hrs its working now..

only the prob. left is that option button is not working..

ovnnet 04-05-2008 04:53 PM

I'm upgrade --> vesion 3.6.9 but shoutbox not work. Shoutbox loading...
Help me, Please!

Inferno Tech 04-05-2008 05:07 PM

ovnnet - uninstall the shoutbox, remove the files from your server, then reupload and reinstall the new shoutbox. After this hit ctrl+f5 on your page to refresh the javascript. Also *points to the main post* You'll get support etc much easier if you *use the support forums*


All times are GMT. The time now is 06:36 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.01998 seconds
  • Memory Usage 1,734KB
  • 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_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