vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Prevent Doubleposting (https://vborg.vbsupport.ru/showthread.php?t=96602)

Hornstar 08-06-2006 05:01 AM

Quote:

Originally Posted by Stoebi
Hi

Plugin 'Main Doublepost Prevent Engine' - Hook newpost_complete


Search for:
Code:

AND dateline > " . (TIMENOW - $vbulletin->options['xen_dp_timespan'] * 60) . "
Change to:
Code:

AND post.dateline > " . (TIMENOW - $vbulletin->options['xen_dp_timespan'] * 60) . "

Reason:
With vBulletin v3.6.x the row dateline exists in the tables post and deletionlog (ambiguous).



Regards, Stoebi

Awesome, was wondering why I was getting database errors after the upgrade.

Thanks

Paul M 08-06-2006 03:07 PM

What is your question exactly ?

redlabour 08-07-2006 12:24 PM

Any update for 3.6 ?

bashy 08-13-2006 06:32 PM

here ya go https://vborg.vbsupport.ru/showpost....&postcount=549

Kaleem 08-15-2006 07:05 PM

Thank u installed for v3.6 woking fine :)

Ben Wilkins 08-16-2006 09:38 AM

Hey, this doesnt work for me, when i create a double post, it will just make a new post and not edit the post above.

phonexpo 08-16-2006 10:01 AM

*Clicks Install*

:)

phonexpo 08-16-2006 10:16 AM

Ok I have some problems;

1. When I use quick reply I get an error "The following errors occurred when this message was submitted" and a okay link shows up that links to the thread.
2. When I use the normal reply button I get a batabase error;

Code:


Database error in vBulletin 3.6.0:
Invalid SQL:
  SELECT post.*
  FROM post AS post
  LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
  WHERE threadid = 1891
  AND dateline > 1155640094
  AND visible = 1 AND deletionlog.primaryid IS NULL
  AND postid <> 12160
  ORDER BY dateline DESC
  LIMIT 1;
MySQL Error  : Column 'dateline' in where clause is ambiguous
Error Number : 1052
Date        : Wednesday, August 16th 2006 @ 12:08:14 PM
Script      : http://phonexpo.ie/newreply.php?do=postreply&t=1891
Referrer    : http://phonexpo.ie/newreply.php?do=n...uote=1&p=12159
IP Address  : **************
Username    : Patrick
Classname    : vb_database

What's the problem here?

redlabour 08-16-2006 01:01 PM

Quote:

Originally Posted by Ben Wilkins
Hey, this doesnt work for me, when i create a double post, it will just make a new post and not edit the post above.

*omg* Refresh your Browser. :D

bondjetta 08-16-2006 02:50 PM

Quote:

Originally Posted by redlabour
Any update for 3.6 ?

agreed. I'm getting the same error as phonexpo after i upgraded to 3.6...

i'll try uninstalling and re-installing next chance I get, but i've got bigger fish to fry right now anyways ;)


All times are GMT. The time now is 05:07 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.02670 seconds
  • Memory Usage 1,740KB
  • 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
  • (3)bbcode_code_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)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