• Support will be limited until May 1st, as I will be out of the office travelling. Thank you for your patience and understanding.
Status
Not open for further replies.

DevOne5555

Customer
I'm noticing quite a number of occurrences of this in my Apache error logs. I was using APC cache until recently but changed to XCache due to recurring issues, and now the problem seems worse. My forum became completely unusable – rather than rendering pages properly, it would render them entirely in code, full of error messages. Some pages would render properly, however the search function showed up as code, and my vbseo/htaccess redirects in my site root stopped working, so that if I visited my site root it downloaded a php file rather than loading the site. Admincp panel for vb optimise renders properly, however when I hit the submit button to save changes it hangs on a white screen. Prior to that we've been having intermittent problems where the site loads a blank white page; the only thing that appeared to fix this was a full server reboot.

Currently, I've brought my forum back to working order by adding code to my config.php to disable plugin hooks entirely.

In any case, this is what I am most concerned about:
Code:
PHP Fatal error:  Call to undefined method vb_optimise_db::escape_string() in /home/koolaid/public_html/forums/vb/cache/db.php on line 141, referer: http://www.studioleaks.info/forums/

As an additional question, should I have caching turned off with vbseo if I'm using xcache with vb optimise? Also, do I need to use a cache prefix? I am only running 1 site with 1 database, and 1 instance of vbseo and vb optimise, respectively.
 
If you re-download and re-upload the files that issue should be fixed, for some reason that error started cropping up in vB 4.1.3...

I've added all the functions I've seen it erroring out on to the vb_optimise_db class so it should work fine :)


I'm not sure what vBSEO caches, so I don't feel fully qualified to answer that question. However, as a rule of thumb, having more than 1 cache system running isn't a good idea.

As for the prefix, it's only if you have more than 1 forum sending data to the cache system, really.
 
Fillip H.,

I uninstalled vb optimise, replaced the remaining files on my server with now ones, then did an import/add of the XML file to re-add the plugin, however It hung on the "importing, please wait" dialog." now it doesn't show up under my list of installed products, and when I try to import it again I get the following database error showing up as a window within the admincp page:
Database error in vBulletin 4.1.3:

Invalid SQL:
insert into vboptimise (`dateline`) values ('Installation');

MySQL Error : Duplicate entry 'Installation' for key 'dateline'
Error Number : 1062
Request Date : Wednesday, May 18th 2011 @ 02:22:51 PM
Error Date : Wednesday, May 18th 2011 @ 02:22:51 PM
Script : http://www.studioleaks.info/forums/administratorcontrolpanel/plugin.php?do=productimport
Referrer : http://www.studioleaks.info/forums/administratorcontrolpanel/plugin.php?do=productadd
IP Address : 99.231.200.169
Username : Poly
Classname : vB_Database
MySQL Version : 5.2.4-MariaDB-mariadb94
 
You didn't need to uninstall, just re-upload the files :)

TRUNCATE TABLE vboptimise

should do the trick
 
Ok, I fixed that, but now I'm getting internal server errors relating to ajax.php whenever I try to re-enable any vb optimise settings in admincp. For example when I hit the flush cache button, it doesn't load the page and nothing happens. I found one Modsec rule which I've disabled but this is the first time Modsec has caused me any problems; I've been using it for months with no changes to my setup.
 
Last edited:
Check your error_log on the server itself (not cpanel) - without the extra info that gives you there's nothing I can do :(
 
Here it is:

[Tue May 17 22:41:43 2011] [error] [client 141.154.28.6] ModSecurity: Access denied with code 403 (phase 2). Match of "beginsWith http://%{SERVER_NAME}/" against "MATCHED_VAR" required. [file "/usr/local/apache/conf/modsec/10_asl_rules.conf"] [line "455"] [id "340162"] [rev "193"] [msg "Atomicorp.com - FREE UNSUPPORTED DELAYED FEED - WAF Rules: Remote File Injection attempt in ARGS (AE)"] [data "138"] [severity "CRITICAL"] [hostname "studioleaks.info"] [uri "/forums/ajax.php"] [unique_id "TdMx57hrocoAAAZs-egAAABN"]
 
Aha, I see. Add the following to your .htaccess file:
Code:
<IfModule mod_security.c>
    SecFilterEngine Off
    SecFilterScanPOST Off
</IfModule>
 
I did that, but now I get a browser dialog stating the following:

Code:
AJAX Failure

Internal Server Error

If it helps I only seem to get that message when loading anything to do with the cache (e.g. flush cache, etc.). Also the Test setup progress wheel hangs on the Flush Cache portion.
 
Last edited:
Well then there's nothing more I can do I'm afraid, it's an Apache Module causing it, not vBO :(
 
I don't understand how that would be the only answer. I haven't changed my Apache setup and I've been using vb optimise for quite some time without incident. It's not obvious to me from looking at error_log what the source of the problem is. Are there any other logs I should be checking? Or is it ajax.php in vbulletin that is causing the problems? Should I replace it with another copy? Are there any Apache mods aside from Modsec that are known to conflict with vb optimise?
 
Last edited:
We haven't received reports of any conflicts no. I've never encountered this issue before so I can't really give more advice I'm afraid :(
 
Fillip H.,

I just thought I'd update you on what's going on. The problem basically came down to not being able to edit/submit changes for anything AJAX-related in the admincp as long as vb optimise was running. As soon as I disabled all plugins it would work again, and if I disabled vb optimise selectively it also worked. I'm running CentOS 5.6 x86_64 with EasyApache, php 5.3.6 (mod_fcgid) and xcache 1.3.1 extension compiled from source. One of the other problems I had was that vb optimise wouldn't play with my xcache admin settings in php.ini. Even with the login data entered in my vboptimise config file it would bring up the browser login/password prompt whenever I attempted to flush the cache. It didn't recognize my password as being correct, and even with no password specified, even with xcache admin functions disabled, it still failed with an AJAX internal server error dialog upon trying to flush the cache. If I repeated these steps with the plugin system enabled (by removing the disable plugin/hook code from includes/config.php), attempting these changes, or any others in the admincp, would result in a blank page.

As of right now, vb optimise is uninstalled, the plugin system is re-enabled, and everything appears to be working again. As a precautionary measure I've also completely removed xcache. My plan is to reinstall xcache, then reinstall vb optimise using completely new files.
 
Did you try w/o using xcache in vBulletin's config.php (datastore cache) and/or without using XCache in vBOptimise's configuration?
 
Yes, I did try that. At this point I've reinstalled xcache which appears to be working. I'm going to try and reinstall vb optimise again.
 
Fillip H.,

We're still experiencing this problem.

In the interim I did a fresh install of our OS, setup a new webserver (nginx 1.0.3 with php-fpm), a new install of xcache, memcached server (not currently running, since I plan on hosting it elsewhere), a new SQL server (MariaDB 5.2.6) using eva2000's modded version of the Centmin NMP server install. We haven't installed any new mods, in fact we've removed some of what we did have installed. vbOptimise is currently not installed. As soon as I install it however, and select xcache, the errors all return. By that I mean it completely locks up the admin panel, so hitting the submit button on anything results in blank pages, and running the vbo optimisation test results in an "ajax internal server error" browser dialog as soon as it hits the "verifying xcache" portion of the test. I'm at a complete loss. vbo worked fine for months, both before and after we installed xcache.

The only thing that has not changed during that time is our config.php:
// ****** DATASTORE CACHE CONFIGURATION *****
// Here you can configure different methods for caching datastore items.
// vB_Datastore_Filecache - to use includes/datastore/datastore_cache.php
// vB_Datastore_APC - to use APC
// vB_Datastore_XCache - to use XCache
// vB_Datastore_Memcached - to use a Memcache server, more configuration below
$config['Datastore']['class'] = 'vB_Datastore_XCache';

// ******** DATASTORE PREFIX ******
// If you are using a PHP Caching system (APC, XCache, eAccelerator) with more
// than one set of forums installed on your host, you *may* need to use a prefix
// so that they do not try to use the same variable within the cache.
// This works in a similar manner to the database table prefix.
$config['Datastore']['prefix'] = '';

// It is also necessary to specify the hostname or IP address and the port the server is listening on

$config['Datastore']['class'] = 'vB_Datastore_XCache';
$i = 0;
// First Server
$i++;
// $config['Misc']['xcacheserver'][$i] = '127.0.0.1';
// $config['Misc']['xcacheport'][$i] = 11211;
// $config['Misc']['xcachepersistent'][$i] = true;
// $config['Misc']['xcacheweight'][$i] = 1;
// $config['Misc']['xcachetimeout'][$i] = 1;
// $config['Misc']['xcacheretry_interval'][$i] = 15;
We also do have vbseo installed, as previously mentioned, however the errors occur both with xcache enabled and disabled in vbseo. In the case of vbseo, it has its own cache prefix settings, which we have set to the default, 'vbseo_storage'.
 
Check the error logs, there should be something there as to the reason for the internal server error :)

PS: The original issue is fixed, so the issue status remains Fixed. We generally prefer separate issues in separate threads, and this issue is unrelated :)
 
Fillip H.

Which issue specifically is fixed? The primary problem was the admin panel locking up/AJAX errors; that's still happening. Would you prefer I open a new support request? Or would it be possible to have you take a look at our setup/admin panel yourself? I am happy to set you up with an administrative account. Please let me know. This is a great product (but not a cheap date), I would like to be able to start using it again some time soon. :)
 
Status
Not open for further replies.

Similar threads

Legacy vB Optimise

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
1,980
Customer rating
0.00 star(s) 0 ratings
Back
Top