View Single Post
  #1137  
Old 01-17-2009, 04:47 PM
BadgerDog BadgerDog is offline
 
Join Date: Oct 2006
Location: Toronto
Posts: 1,789
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hello all ...

I realize that Paul no longer supports this mod and for a whole bunch of reasons to numerous to mention here, we can't upgrade our site past v3.67pl1 and therefore can't use the 3.7 version of this fine mod. It has proven to be extremely useful to us over the last year or so.....

However, I thought I'd ask anyone still reading this thread if they have encountered the following consistent error and have found a solution they could share.

We get dozens and dozens of these specific errors every day and it's driving us crazy emailing us with vBulletin Database Errors.

The same error occurs frequently as follows: (shortened and dealt with privacy issues)

EXAMPLE

====================================
Database error in vBulletin 3.6.7:

Invalid SQL:

INSERT INTO referrers
(url, count)
VALUES
('google.co.il%2Fsearch%3Fhl%3Diw%26amp%3Bclient%3 Dfirefox-a%26amp%3Brls%3Dorg.mozilla%253Aen-US%253Aofficial%26amp%3Bhs%3DHxf%26amp%3Bq%3D%2522 %25D7%2597%25D7%2599%25D7%2595%25D7%25AA%2B%25D7%2 59C%25D7%2599%25D7%259C%25D7%2594%2522%2B25.07.08% 26amp%3BbtnG%3D%25D7%2597%25D7%2599%25D7%25A4%25D7 %2595%25D7%25A9%26amp%3Bmeta%3D', 1);

MySQL Error : Duplicate entry 'google.co.il%2Fsearch%3Fhl%3Diw%26amp%3Bclient%3D firefox-a%26amp' for key 1 Error Number : 1062
Date : Friday, January 16th 2009 @ 08:58:56 PM
Script : http://www.yourwebsite/yt.php?v=J4GwzQmLd9U
Referrer : http://www.google.co.il/search?hl=iw...95%D7%A9&meta=
IP Address : xx.xx.xx.xx
Username : Unregistered
Classname : vB_Database

====================================

Anyone else get these and perhaps can help us solve it?

Thanks for any feedback ....

Regsrds,
Badger
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02382 seconds
  • Memory Usage 1,766KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete