vb.org Archive
Page 2 of 2 1 2
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Reason for database errors? (https://vborg.vbsupport.ru/showthread.php?t=299225)

Simon Lloyd 06-17-2013 10:18 PM
Quote:
Originally Posted by snakes1100 (Post 2428789)
Any system would support xcache, as long as you install it, i assume your not on a vps/dedi?
Not with the way my setup is, i'm on dedicated box.

Quote:
Originally Posted by ForceHSS (Post 2428799)
are you trying to make a new mod if so i can give you site for testing i am not using will install what version u need
Nope just all of a sudden had these database isues, but thanks :)

Quote:
Originally Posted by Zachery (Post 2428800)
Don't ever repair or optimize a database if you don't have to. Repairs should only be run if the table is actually crashed. Optimize if and only if you've removed large groups of data from an myisam table.

If you run that query yourself, do you get any errors?

Without an error message hard to tell. php might have timed out and killed the query/connection. or MySQL timed out and killed the query, which made php exit and give you an error. But its weird you're not getting an error message.
Ok i ran that query through admincp>maintainance>execut query and it spat this out:

Fatal error: Could not obtain file lock in [path]/includes/class_datastore.php on line 807
#0 vb_error_handler(256, Could not obtain file lock, /public_html/forumz/includes/class_datastore.php, 807, Array ([title] => options,[data] => a:1512

And then spat out the entire contents of datastore!

Zachery 06-17-2013 11:35 PM
How are you storing the datastore? default or in the filesystem/xcache/apc/memcache?

Simon Lloyd 06-17-2013 11:39 PM
Well here's the rub, around 4 days ago my forum experienced major problems, no access to admincp...etc, the hosts couldn't see what was wrong and asked cpanel to check it out, they said the issue is with cpanel and APC (they dont support it) however its been working fine for a year, but sure enough comment out the line for acp and i had control back (after changing config.php to filecache and turning off apc usage in dbtechs vboptimies mod), so now im running on filecache but it all appears to be there inm the databse just fine?

Zachery 06-17-2013 11:44 PM
Chances are it cannot write/lock the datastore cache file. Switch back to the normal datastore cache (nothing).

Then try the same query again. Also double check your database user has ALL permissions (short of grant) on its own database.

Simon Lloyd 06-18-2013 12:09 AM
Hmmm i dont see why the databse user should have changed the forums been the same (all barr creating mods and tinkering) for the last 4 years :)

So you recon if i comment out all caching in config.php that should do it?

Zachery 06-18-2013 12:22 AM
Its not going to hurt anything, if it doexn't fix anything you can change it back just as easily.

Simon Lloyd 06-18-2013 12:24 AM
Ok just done that and the query executed fine?? now that we've established that what can i do to enable caching of some sort?


All times are GMT. The time now is 01:10 PM.
Page 2 of 2 1 2
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.01111 seconds
  • Memory Usage 1,728KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)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