vb.org Archive
Page 39 of 42 « First 293738 39 4041 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Forum Home Enhancements - [AJAX] Websites who have referred today (in the last 24 hours) (https://vborg.vbsupport.ru/showthread.php?t=137792)

XManuX 12-27-2008 07:21 AM
Up for a fix about the "w" problem !

wally 12-29-2008 07:47 PM
Quote:
Originally Posted by XManuX (Post 1694628)
Up for a fix about the "w" problem !
fix is on page 16

BadgerDog 01-18-2009 07:42 PM
Hello all ... :)

I realize that this mod is no longer supported, 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 ....

Regards,
Badger

wally 01-19-2009 06:34 PM
i get these errors from time to time also its not a big deal

BadgerDog 01-20-2009 02:25 PM
Quote:
Originally Posted by wally (Post 1718124)
i get these errors from time to time also its not a big deal
Thanks ... :)

I get dozens of these every day and each one sends me an SQL database error via email. Any way of fixing this, other than to have to turn off ALL database errors being sent to me via email?

Regards,
Badger

Leo Brazil 02-04-2009 10:24 AM
RedTyger,

I'm glad your back to activity !!!

How about a 3.8 upgrade for this one ?

Cheers

RedTyger 02-04-2009 10:41 AM
In what way does it not work on 3.8? There are a few bugs I could fix but there's nothing version-specific that I can see.

Cybertims 02-08-2009 05:15 PM
Can you provide a fix for the duplicate error in the database problem? I get emails all day every day from it.

Leo Brazil 02-09-2009 04:08 PM
Quote:
Originally Posted by RedTyger (Post 1734069)
In what way does it not work on 3.8? There are a few bugs I could fix but there's nothing version-specific that I can see.
That's right. If known bugs were fixed would be a perfect mod.

RedTyger 02-10-2009 10:05 AM
Some untested fixes to try, I cannot easily get it to work with 3.8 to try for myself.


If you are having trouble with database errors, try this:

OPEN: websites_who_have_referred_today_(versionnumber).x ml

FIND (it's there more than once!):
Code:
(" . $referrers_db_values . ")
REPLACE WITH:
Code:
(" . $referrers_db_values . ") ON DUPLICATE KEY UPDATE count = count + 1





If you are having trouble with the letter w being incorrectly removed from URLs, try this:

OPEN: websites_who_have_referred_today_(versionnumber).x ml

FIND (it's there more than once!):
Code:
// Catch different prefixes
if (strpos($referrer_short, 'https://') !== False)
{
        $referrer_short = str_replace("https://", "", "$referrer_short");
}
else if (strpos($referrer_short, 'ftp://') !== False)
{
        $referrer_short = str_replace("ftp://", "", "$referrer_short");
}
else if (strpos($referrer_short, 'http://') !== False)
{
        $referrer_short = str_replace("http://", "", "$referrer_short");
}
if (strpos($referrer_short, 'www.') == '0')
{
        $referrer_short = ltrim($referrer_short, "www.");
}
REPLACE WITH:
Code:
// Trim down to the domain
$referrer_short = preg_replace('#^[a-z]+://(?:www.)?#iU', '', $referrer_short);
AND

FIND (it's there more than once!):
Code:
        // Some might have a trailing / in their forum URL, some might not so do the same
        $bburl_match = $vbulletin->options['bburl'];
       
        if (strpos($bburl_match, 'https://') !== False)
        {
                $bburl_match = str_replace("https://", "", "$bburl_match");
        }
        else if (strpos($bburl_match, 'ftp://') !== False)
        {
                $bburl_match = str_replace("ftp://", "", "$bburl_match");
        }
        else if (strpos($bburl_match, 'http://') !== False)
        {
                $bburl_match = str_replace("http://", "", "$bburl_match");
        }
        if (strpos($referrer_short, 'www.') == '0')
        {
                $bburl_match = ltrim($bburl_match, "www.");
        }
REPLACE WITH:
Code:
// Trim down to the domain
$bburl_match = preg_replace('#^[a-z]+://(?:www.)?#iU', '', $bburl_match);


All times are GMT. The time now is 02:01 AM.
Page 39 of 42 « First 293738 39 4041 Last »
Show 40 post(s) from this thread on one page

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.01576 seconds
  • Memory Usage 1,750KB
  • 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
  • (6)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
  • (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