vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Major Additions - [DBTech] vBSlider v3 (vB4) (https://vborg.vbsupport.ru/showthread.php?t=277166)

ScarlosSantana 02-25-2012 02:33 PM

When I place it at forum home it causes a database error.

Quote:

Database error in vBulletin 4.0.8:

Invalid SQL:
SELECT cms_article.contentid, cms_article.pagetext AS message, cms_node.nodeid, cms_node.url, cms_node.publishdate, cms_nodeinfo.title, cms_article.previewimage
FROM cms_article AS cms_article
INNER JOIN cms_node AS cms_node ON ( cms_node.contentid = cms_article.contentid )
INNER JOIN cms_nodeinfo AS cms_nodeinfo ON ( cms_nodeinfo.nodeid = cms_node.nodeid )
LEFT JOIN cms_nodecategory AS cms_nodecategory ON ( cms_node.nodeid = cms_nodecategory.nodeid )
WHERE 1 =1

AND cms_node.setpublish =1
AND cms_node.publishdate <= 1330183858
AND cms_node.publicpreview =1
ORDER BY cms_node.publishdate DESC
LIMIT 0,;

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 12
Error Number : 1064
Request Date : Saturday, February 25th 2012 @ 10:30:58 AM
Error Date : Saturday, February 25th 2012 @ 10:30:58 AM
Script : http://www.thedoomship.com/forum.php
Referrer : http://www.thedoomship.com/content.php?s=&styleid=46
IP Address : **.***.***.***
Username : ScarlosSantana
Classname : vB_Database_MySQLi
MySQL Version : 5.0.92-community

DragonByte Tech 02-25-2012 03:01 PM

Per your PM at DBTech, this has been resolved, correct? Thanks.

Brad

ScarlosSantana 02-25-2012 04:35 PM

YEah, weird thing is when I disabled it, it started working. So I'm not gonna enable it anymore for fear of it not working again,

DragonByte Tech 02-25-2012 05:24 PM

What are you enabling/disabling and how? That's what's confusing me...

Brad

alhidaya 02-26-2012 09:52 AM

Everything works great for the slider cms version v1.0.7. I have a problem with version v.2.0.0, the slider in the cms disappears after a few minutes.

I have vbulletin 4.1.1.0 suite.

DragonByte Tech 02-26-2012 02:03 PM

Can you post or PM me a link to your site? I can't recreate this. I've had my dev server running the slider for over 10 min now, and its still going.

Brad

alhidaya 02-26-2012 10:23 PM

I uninstall the product. Thank you for a future update. I liked this slider

DragonByte Tech 02-26-2012 11:39 PM

I'd love to try to help you out, but if its not something I can recreate, then I don't know where I need to fix the code.

Brad

bposner 03-04-2012 01:38 AM

I must be doing something wrong. Slider seems to be set up correctly but all that shows are blank areas. I've messed a few times with the settings, add ALL forums just to try to get it to work, including VBcms.. nothing.. I'm sure it's not the program, just something I'm doing.
Thoughts?
Edit: Ok, the widget seem to work with custom option and blogs, and CMS articles. However the forum side doesn't seem to pull, even though I have CMS and FORUM setting the same..

Thanks for the help.

DragonByte Tech 03-04-2012 01:38 PM

Are you sure you have a quantity for the threads? Can you PM me your site URL so I can look into it further? Thanks.

Brad


All times are GMT. The time now is 05:39 AM.

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