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)
-   -   Show Thread Enhancements - Limited Guest Viewing -- Motivate Guests to Register (https://vborg.vbsupport.ru/showthread.php?t=231352)

denman75 12-28-2009 04:51 PM

thank your for the fast replay
really apriciate it

this is my code i get

PHP Code:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<
html>
<
head>
    <
title>bullterrierforum Database Error</title>
    <
meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
    <
meta name="ROBOTS" content="NOINDEX,NOFOLLOW,NOARCHIVE" />
    <
style type="text/css">
    <!--    
    
body background-colorwhitecolorblack; }
    
#container { width: 400px; }
    #message   { width: 400px; color: black; background-color: #FFFFCC; }
    #bodytitle { font: 13pt/15pt verdana, arial, sans-serif; height: 35px; vertical-align: top; }
    
.bodytext  font8pt/11pt verdanaarialsans-serif; }
    
a:link     font8pt/11pt verdanaarialsans-serifcolorred; }
    
a:visited  font8pt/11pt verdanaarialsans-serifcolor#4e4e4e; }
    
-->
    </
style>
</
head>
<
body>
<
table cellpadding="3" cellspacing="5" id="container">
<
tr>
    <
td><img src="http://bullterrierforum.nl/bullforums/image.php?type=dberror" alt="Database Error" width="48" height="48" /></td>
    <
td id="bodytitle" width="100%">Database error</td>
</
tr>
<
tr>
    <
td class="bodytext" colspan="2">The bullterrierforum database has encountered a problem.</td>
</
tr>
<
tr>
    <
td colspan="2"><hr /></td>
</
tr>
<
tr>
    <
td class="bodytext" colspan="2">
        
Please try the following:
        <
ul>
            <
li>Load the page again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</abutton in your web browser.</li>
            <
li>Open the <a href="/">bullterrierforum.nl</ahome pagethen try to open another page.</li>
            <
li>Click the <a href="javascript:history.back(1)">Back</abutton to try another link.</li>
        </
ul>
    </
td>
</
tr>
<
tr>
    <
td class="bodytext" colspan="2">The bullterrierforum.nl forum technical staff have been notified of the errorthough you may <a href="mailto:dbmaster@example.com">contact them</a> if the problem persists.</td>
</
tr>
<
tr>
    <
td class="bodytext" colspan="2">&nbsp;<br />We apologise for any inconvenience.</td>
</
tr>
</
table>


<!--
Database error in vBulletin 4.0.0:

Invalid SQL:

        
SELECT thread.threadidthread.title
            
        FROM thread 
AS thread
        
        WHERE forumid 
41
            
AND visible 1
            
AND open &lt;&gt10
            
            
        
AND lastpost &gt
        
ORDER BY lastpost
        LIMIT 1
;

MySQL Error   You have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY lastpost
        LIMIT 1' 
at line 11
Error Number  
1064
Request Date  
MondayDecember 28th 2009 07:50:12 PM
Error Date    
MondayDecember 28th 2009 07:50:12 PM
Script        
http://bullterrierforum.nl/bullforums/showthread.php?t=9427&amp;goto=nextnewest
Referrer      http://bullterrierforum.nl/bullforums/portaal-nieuws/9427-buldog-voor-david-beckham.html
IP Address    82.101.235.244
Username      
Niet geregistreerd
Classname     
vB_Database
MySQL Version 

-->


</
body>
</
html


Ted S 12-28-2009 05:10 PM

Interesting. That error has nothing to do with this mod that I can see... when you turn it off does this go away immediately?

denman75 12-28-2009 05:16 PM

yes its gone if i disable or remove the plug in

its really strange it looks like its conflicting with something or so
i really have no clue

ps sorry for my late replay ,since i am online here
but i use translator ,my English is not that good
sorry

Ted S 12-28-2009 05:20 PM

what settings are you using for this modification (in your admin cp --> settings --> limited guest viewing system)

denman75 12-28-2009 05:30 PM

here its it

[img=http://www3.picturepush.com/photo/a/2696106/220/2696106.jpg]

Ted S 12-28-2009 05:33 PM

And what other mods are you running?

denman75 12-28-2009 05:43 PM

Add additional css to your style 1.0 This just adds a new additional_css.css template to your pages for custom css

Add Default Stylevars 1.0 Adds default stylevars directly under Styles & Templates

AME 3 3.0.0 Beta 2a Autom Media Embedder and Video Extender disabled

BBR - Google Analytics Addon 1.02 Adds Google analytics code before the</body> tag.

BBR - Resize Images with lytebox v3.22 1.0 Will resize images posted with [img] and images in signatures

BBR - Welcome Thread On Register 2.0 Creates a welcome thread when a new user registers

DesiHearts Latest Posters 1.1.0 Displays Latest Posts on Forumhome

Forum Icons 1.0 New option when editing a forum to include an icon.

Limited Guest Viewing 2.0.5 Limit guests to view a set number of threads before being locked out.

Members who have Visited 4.0.3 Display members who have visited the forum.

Separate Sticky and Normal Threads 4.0.1 Separate Sticky and Normal Threads

vBH - Add new tabs 1.1 1.1 This plugin adds new tabs to the main navbar

vBSEO 3.5.0 RC1 PL1 vBulletin SEO

vbStopForumSpam 0.61 This plugin allows you to check new registrations against www.StopForumSpam.com

vBulletin Blog 4.0.0 Personal web log, integrated with vBulletin.

vBulletin CMS

Alibass 12-28-2009 06:33 PM

Ted S

I have run your mod before on earlier versions and thank you for updating it to vb4.

I seem to be having a issue with the cron routine. When I run the lgv_cleardb as run now, it does not clear the db nor does it make a log entry when I check the scheduled task log. I have the enable db logging on [yes].

The mod is working properly for the number of posts to read. I just cant manully clear the db.

Any suggestions?

Alibass

Ted S 12-28-2009 09:00 PM

Quote:

Originally Posted by Alibass (Post 1940705)
Ted S

I have run your mod before on earlier versions and thank you for updating it to vb4.

I seem to be having a issue with the cron routine. When I run the lgv_cleardb as run now, it does not clear the db nor does it make a log entry when I check the scheduled task log. I have the enable db logging on [yes].

The mod is working properly for the number of posts to read. I just cant manully clear the db.

Any suggestions?

Alibass

Shoot! I need to post the updated version of this file. Look for it shortly.

Ted S 12-28-2009 09:28 PM

Small bug fix released as 2.0.6. There is no need to update unless you had problems installing.


All times are GMT. The time now is 03:17 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.02341 seconds
  • Memory Usage 1,785KB
  • 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_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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