[ozzy47]

Ahh cool, thanks for reporting back, I would have never though of that as I have always used FileZilla.

[dawges]

Finally added this. Thank you, now i can remove like 3 mods that this one alone replaced.

[Pocket Aces]

How to use this mod in custom style? Header is all messed up.

[wildheart]

Great mod thank you so much!

Is there a way to make these templates accessible via tapatalk?

[Logician]

Originally Posted by wildheart

Great mod thank you so much!

Is there a way to make these templates accessible via tapatalk?

I don't know a way to do that but this is really about tapatalk, not webtemplates. Tapatalk app can pull information from webtemplates if they design it like that so asking this in their forum might have a better chance of getting it done.

[midnz]

Hi Logician, I was wondering if you can solve my puzzle:

I'm using your default web query $WQ_last10threadfromforum2 but changed it to extract threads from forum#121 and it works as it should.

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

I duplicated that web query ($WQ_last10threadfromforum3) and tried to extract the threads from forumid=230 but it didn't work. The resulting display was blank.

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

... and so I executed an SQL Query and noticed the following error:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 '" . TABLE_PREFIX . "thread
WHERE sticky=0 AND visible=1 AND forumid=230
ORDER' at line 2

So, I did the same with the code that works as it should:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 '" . TABLE_PREFIX . "thread
WHERE sticky=0 AND visible=1 AND forumid=121
ORDER' at line 2

But that one does in fact display the last ten threads from forum#121.
I did try to read the 5.1.72 manual until my eyes crossed and fell out on to my cheeks.
Can you help please?

Logician's WebTemplates 4.0.2
MySQL Version - 5.1.72-cll
vB 4.2.2

[Logician]

Originally Posted by midnz

Hi Logician, I was wondering if you can solve my puzzle:

I'm using your default web query $WQ_last10threadfromforum2 but changed it to extract threads from forum#121 and it works as it should.

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

I duplicated that web query ($WQ_last10threadfromforum3) and tried to extract the threads from forumid=230 but it didn't work. The resulting display was blank.

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

... and so I executed an SQL Query and noticed the following error:
So, I did the same with the code that works as it should:
But that one does in fact display the last ten threads from forum#121.
I did try to read the 5.1.72 manual until my eyes crossed and fell out on to my cheeks.
Can you help please?

Logician's WebTemplates 4.0.2
MySQL Version - 5.1.72-cll
vB 4.2.2

You can't directly run these SQL queries in applications like phpmyadmin because it has a vbulletin replacement in it. (which is " . TABLE_PREFIX . " ).

So its NORMAL that BOTH of these queries will produce a syntax error when you try to run them "as they are" in tools like phpmyadmin. If you want to run them there, you need to remove " . TABLE_PREFIX . " part and use this query:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

or

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

These should run fine in phpmyadmin.

However this still does not explain why your query is not running in webtemplates. I suspect there is another problem somewhere else rather than the query syntax. I don't know if your webmaster email in config.php file is accurate but if webquery died with a DB error (like syntax error) you would get a DB error notification in your email. Since you didn't get it, I'd think that there is no problem with your webquery.

Blank pages usually means PHP errors and they happen in servers where PHP error display is turned off in php.ini. If it was on, the page would display the error and we would have more clue. Since its off, I don't know what is causing the error but maybe you can check it in your server's php error log. I'd suspect something about the webtemplate your recently created (rather than webquery).

So my first suggestion is, create a new test webtemplate with nothing in it but a simple "hello there $WQ_last10threadfromforum3" and see if it will also produce a blank page. If it works, then you can understand its somehow related to the content of your other webtemplate (not webquery!). It might be clashing with an other plugin or smt.

It would really help if you enable php error display in server so that we'll see the error message that blank page is suppose to produce.

[midnz]

Originally Posted by Logician

However this still does not explain why your query is not running in webtemplates. I suspect there is another problem somewhere else rather than the query syntax.

You were 100% correct. The problem was within my brain. I hadn't ticked that webquery to run in the page that I wanted it to run in.



Thanks for your effort. My apologies for wasting your time.

[Hasanudin]

vB 4.2.2

bellow 'Site Help Pages' :

Error: Header Template is Customised

[tbworld]

I do not use this mod, but I believe the error message is saying that it cannot auto insert changes to the header template, due to it being already modified.

You should always test a new modification on a default vbulletin setup (no customizations) -- a test board. Make sure you read the thread on this mod since there are some change you will have to make to run it on v4.2.2.

[JenniferK]

I am using the Header 2 location in ad management. I am running 4.2.2, using the default style. Based on advice I was given to correct a display issue (header 2 ad was just right of the header image instead of all the way to the right), this has been corrected on all forum pages, but it is still displaying incorrectly on the pages using webtemplates (see attachment). The attachement image is not a webtemplate page, but that is how it is still displaying there. To fix it on the forum pages, I entered this into additional.css:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

What can I do to fix it on the pages that use webtemplates?

[Logician]

Originally Posted by JenniferK

I am using the Header 2 location in ad management. I am running 4.2.2, using the default style. Based on advice I was given to correct a display issue (header 2 ad was just right of the header image instead of all the way to the right), this has been corrected on all forum pages, but it is still displaying incorrectly on the pages using webtemplates (see attachment). The attachement image is not a webtemplate page, but that is how it is still displaying there. To fix it on the forum pages, I entered this into additional.css:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

What can I do to fix it on the pages that use webtemplates?

Depends on the webtemplate. If its using a theme like "Default Basic Theme", then you can edit that theme's webtemplate "default_basic_theme1" and insert it after "{vb:raw headinclude}" part.

[JenniferK]

Yes, they are all Default Basic Theme that I am concerned with. I am not great at all of this, can you give me some more direction? I know what template to edit now, but what am I inserting exactly? Does it go immediately after "{vb:raw headinclude}"?

Sorry to be dense, my know-how with all of this is minimal.

[Logician]

Originally Posted by JenniferK

Yes, they are all Default Basic Theme that I am concerned with. I am not great at all of this, can you give me some more direction? I know what template to edit now, but what am I inserting exactly? Does it go immediately after "{vb:raw headinclude}"?

Sorry to be dense, my know-how with all of this is minimal.

Yes according to what you described it seems that you need to edit webtemplate theme named "Default Basic Theme" and after the section {vb:raw headinclude} copy paste your code.

[JenniferK]

You mean the same code (as above) that I put into addition.css? If so, I did try that and the image was still in the same place but the code was listed out at the top of the page. If it is something else I am supposed to put after, then I'm not sure it that code would be.