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)

odie3 07-25-2007 01:12 PM

Today I had this error, I took the table backup from yesterday and Drop/reCreated it. All is well now. However, any ideas why this happened?

Quote:

Invalid SQL:

SELECT * FROM guest FORCE INDEX (lastactive) WHERE lastactive > 1185339600;

MySQL Error : Can't open file: 'guest.MYI' (errno: 145)
Error Number : 1016

Paul M 07-25-2007 07:25 PM

The table index crashed - that's just one of those things that happens with mysql, which is why it has a repair command. All you needed to do was repair it via the ACP.

imports 07-26-2007 01:32 AM

any step by step procedure on this one? i transfered the file using smart FTP to my forum folder and when i open my vb options its not there?

Paul M 07-26-2007 12:51 PM

No file transfers are required for this - you import the xml file using the plugin/product manager.

loonytune15 07-26-2007 11:29 PM

Quote:

Originally Posted by Paul M (Post 1301521)
The table index crashed - that's just one of those things that happens with mysql, which is why it has a repair command. All you needed to do was repair it via the ACP.

I have the same prob, and it has happened for 3 consecutive days. If I go offline for a few days no-one will be able to access the forum.

It seems strange that this has happened to a number of people and my self 3 times in a matter of a week..

Paul M 07-27-2007 01:35 AM

Quote:

Originally Posted by loonytune15 (Post 1302650)
I have the same prob, and it has happened for 3 consecutive days.

Then you probably have a dodgy table. Backup the table, drop it, and then restore it from backup (we had to do the same here a couple of weeks ago when one of our custom tables kept crashing).

Quote:

Originally Posted by loonytune15 (Post 1302650)
It seems strange that this has happened to a number of people and my self 3 times in a matter of a week..

There is nothing strange about mysql table faults, they happen all the time.

UaeStar 07-27-2007 06:17 AM

realy nice ^_^

fringehead 07-27-2007 09:00 PM

Thanks for the mod! I had this working before, but not I only get (x) Visitors and no actual names of the spiders, etc.. I have removed the members who visited today hack and am just running this but I still have the same problem... Any suggestions?

Thanks,

Sean

fringehead 07-27-2007 10:09 PM

Quote:

Originally Posted by fringehead (Post 1303400)
Thanks for the mod! I had this working before, but not I only get (x) Visitors and no actual names of the spiders, etc.. I have removed the members who visited today hack and am just running this but I still have the same problem... Any suggestions?

Thanks,

Sean

Paul, I have show spiders on in who's online options. I still get no spiders just guests.

dknelson 08-08-2007 01:46 AM

Quote:

Originally Posted by fringehead (Post 1303400)
Thanks for the mod! I had this working before, but not I only get (x) Visitors and no actual names of the spiders, etc.. I have removed the members who visited today hack and am just running this but I still have the same problem... Any suggestions?

Thanks,

Sean

I'm suddenly seeing this exact same problem. It has been working fine but now only showing (x) visitors and nothing else.


All times are GMT. The time now is 10: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.01896 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
  • (6)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