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)
-   -   Portal Software - WebTemplates 4.x: VB Integrated CMS (Content Management System) (https://vborg.vbsupport.ru/showthread.php?t=250202)

Logician 10-13-2012 12:57 PM

Quote:

Originally Posted by ryancooper (Post 2372577)
Get an error with this:

Can't find FULLTEXT index matching the column list

This query works on 3.x structure but apparently it is not possible to do this with one query in vb 4.x due to db changes

FlyingRon 10-24-2012 07:41 PM

I've inherited an existing vB/WebTemplates installation. The files installed seem to be identical to the 4.0.1 I downloaded. The TEXT and HTML webtemplates when run display the header and footers (and even insert the edit this page link if that is allowed) but the actual contents of the template do not appear in the output. The webquery used also is executed.

If I use the PHP type, then I get output that I specifically print (but no headers or footers).

Pretty much behave the same if I use the test ones, old ones we had lying around, or attempt to generate new ones.

Any ideas?

Logician 10-25-2012 07:50 AM

Quote:

Originally Posted by FlyingRon (Post 2375722)
I've inherited an existing vB/WebTemplates installation. The files installed seem to be identical to the 4.0.1 I downloaded. The TEXT and HTML webtemplates when run display the header and footers (and even insert the edit this page link if that is allowed) but the actual contents of the template do not appear in the output. The webquery used also is executed.

If I use the PHP type, then I get output that I specifically print (but no headers or footers).

Pretty much behave the same if I use the test ones, old ones we had lying around, or attempt to generate new ones.

Any ideas?

Edit the webtemplate you have this problem and check which theme its using. (In the section that says "Using a Theme?").

Then edit that theme (eg. Two Column Theme) and make sure it has this variable in it:
{includedtemplate}

If it does, try disabling all other pluggins/products/hacks but webtemplates and see if this solve the problem (in case another hack is clashing with WT).

If this also does not solve the problem, give me admin cp/ftp access to your board and I can check.

FlyingRon 10-28-2012 08:23 PM

Thanks, Log....putting the includedtemplate into the style fixed it.

Christos Teriakis 11-20-2012 03:54 PM

Hello,

Seems to be very useful addon. Can someone tell me if it supports CMS widgers or Forum blocks? Or do I need to build my own?

Thank you
Chris

Naijasite 12-30-2012 11:39 PM

best page creator

Naijasite 01-04-2013 08:01 PM

Please how do i make all the Template to be edited by WYSIWYG?

ged 01-04-2013 09:53 PM

Hi, first of all, I'd like to say I've searched the entire topic to prevent double posting same problem. :)

I'm trying to modify webquery WQ_lastxthreadfromforumy only to show thread title's first 20 characters:

PHP Code:

SELECT threadidLEFT(title20), dateline
FROM 
" . TABLE_PREFIX . "thread 
WHERE sticky
=AND visible=AND forumid=6
ORDER BY dateline DESC
LIMIT 5 

Can you tell me what I did wrong? :)

Thank you very much.

Logician 01-04-2013 10:21 PM

Quote:

Originally Posted by ged (Post 2394776)
Hi, first of all, I'd like to say I've searched the entire topic to prevent double posting same problem. :)

I'm trying to modify webquery WQ_lastxthreadfromforumy only to show thread title's first 20 characters:

PHP Code:

SELECT threadidLEFT(title20), dateline
FROM 
" . TABLE_PREFIX . "thread 
WHERE sticky
=AND visible=AND forumid=6
ORDER BY dateline DESC
LIMIT 5 

Can you tell me what I did wrong? :)

Thank you very much.

I believe this should work:

SELECT threadid, LEFT(title, 20) as title, dateline
FROM thread
WHERE sticky=0 AND visible=1 AND forumid=6
ORDER BY dateline DESC
LIMIT 5

ged 01-04-2013 10:26 PM

Quote:

Originally Posted by Logician (Post 2394782)
I believe this should work:

SELECT threadid, LEFT(title, 20) as title, dateline
FROM thread
WHERE sticky=0 AND visible=1 AND forumid=6
ORDER BY dateline DESC
LIMIT 5

Thank you very much, unbelievable support speed! :)


All times are GMT. The time now is 12:01 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.01320 seconds
  • Memory Usage 1,746KB
  • 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
  • (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