vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Forum Home Enhancements - Track Guest Visits (https://vborg.vbsupport.ru/showthread.php?t=131314)

Paul M 06-02-2008 11:25 PM

Thats some sort of mysql problem/bug - it should be impossible to get a duplicate key error using RELACE INTO - the whole point is that it updates the found key - I would suggest you run a repair on the guest table, it may be corrupt in some way.

voter 06-03-2008 07:38 AM

Quote:

Originally Posted by Paul M (Post 1539218)
Thats some sort of mysql problem/bug - it should be impossible to get a duplicate key error using RELACE INTO - the whole point is that it updates the found key - I would suggest you run a repair on the guest table, it may be corrupt in some way.

Sure the reason was corrupted guest table, and after repairing SQL everything is ok.
My thought was to find a way to escape such a situation again.

I think the scenario is - during database backup, which is hard staff for server, the REPLACE comes and mysql starts to writes the data, but it do not mark it as finished and send any answer to your script for a long time and same request comes once more. Then one have same REPLACE query doubble in query.

Paul M 06-03-2008 05:19 PM

Replace just does an Insert, or Delete & Insert if the key exists.

If vb3.7 required mysql 4.1 or above then I could look at the "Insert ... On Duplicate Key Update" for the 3.7 version - however it only required 4.0.16 or above, this version needs to run on any mysql 4.0.x (and even mysql 3.xx) as well.

fpattberg 06-08-2008 06:55 AM

Hello.

I know that there is limited support on this plugin now but I have had the situation that suddenly (since yesterday) somehow there are now spiders shown next to my regular visitors.

My site: http://www.sustainabilityforum.com/forum

Has anyone an idea why that could be the case? Have I missed something? Are there no more spiders visiting my site?

I am using 3.6.7 PL1 but that should not be a problem right?

Please help.

Thanks.

Fabian

Paul M 06-08-2008 11:46 AM

Maybe your spiders cache has got corrupted, try running this and then waiting a few hours ;

[sql]DELETE FROM datastore WHERE title = 'wol_spiders'[/sql]

fpattberg 06-08-2008 12:14 PM

Okay.

I am getting a not allowed message. Do I have to get permission from my hosting provider?

In the vbseo forum they said that I had a robots.txt problem.
But I have no robots.txt on my ftp root and still it shows up:
http://www.sustainabilityforum.com/robots.txt

What is wrong with this?

Please help.

Thanks.
Fabian

Dean C 07-05-2008 10:55 PM

Hi,

Just installed this. Does it take a few hours to begin showing on the forumhome? I installed it, checked everything was turned on in the vB options and the block isn't showing up on forumhome. Note: I am running a completely stock vBulletin style.

Ack: permissions for admin were all set to no :) Nm

Philster 07-05-2008 11:58 PM

Dean, have you enabled spider display and guests in 'who's online' options of your admincp? Also have you ftp'd the latest spider.xml file to your forum?

Phil.

Welshy2008 08-06-2008 10:59 PM

Great Hack - Thank You Paul.

ggregg13 08-22-2008 10:38 AM

how do l do this exacly lam new to this Upload the bitfields file to your ../includes/xml folder thanks ggregg13


All times are GMT. The time now is 12:25 AM.

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.01844 seconds
  • Memory Usage 1,735KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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