El Queso
05-07-2015, 09:27 PM
A few days ago, our forum stopped working, with a message from vBulletin that the Datastore was corrupted. All pages, even the AdminCP. The message suggested that we should run the "bitfield" option in Tools.php to fix the issue.
I had to upload tools.php, as well as the Install folder, in order to do so. I ran the option indicated and received some errors about mysql_specialchars being deprecated (we are running php 5.4.3, vBulletin 4.1.4) and have made some previous modifications when we upgraded our PHP version to get rid of those problems in the forum itself. We had forgotten about this issue when running tools.php.
Running the "bitfield" options completed, even with the errors, and it seemed to fix the issue with the datastore.
But it left the forum with problems. At first the problems were pretty big. A number of plugins that we've created and added ourselves didn't work at all, including a banner ad manager. Just for grins, I went in and turned off one of the Products our Plugins were attached to, and suddenly most of the functionality re-appeared correctly. I turned on the one product I'd disabled and it continued to work correctly as well.
Later, I realized we still had two problems.
1) We have a "Front Page" via vbAdvanced (vBa CMPS) that is not working. The configuration data for the CMPS is showing up in the AdminCP correctly, the Front Page is configured correctly, and all modules we are displaying on the Front Page are configured correctly. When we try to access the Front Page (via vBa's replacement index.php) we get a vBulletin error that says it can't find the page specified.
2) Users cannot add attachments to posts. When they click to create a new post, the Attachment area under the post editor is simply not there. I've reviewed permissions in user groups and can't find a reason that anyone who is logged in and able to create a post should not have permissions to access attachments. All previously-uploaded attachments (i.e., those uploaded before our problem) display and act correctly.
We run two other forums that have almost identical configurations and I've compared those forums to the problem forum and can't find any differences. Obviously this must have to do with some sort of caching/pre-parsed text issue in the database, but I'm damned if I know what at this point.
I'm a developer, although with a couple of decades of experience writing c#/.Net code and only a few years' experience developing with PHP and vBulletin. I have a development environment set up on my local machine, though I have yet to run the "bitfield" option in the tools.php script locally in order to try to "break" my local environment. That's probably my next play, so I can debug directly and try to see what's happening, but I was kind of hoping to avoid having to do that :)
Anyone have any suggestions as to what to look at?
I had to upload tools.php, as well as the Install folder, in order to do so. I ran the option indicated and received some errors about mysql_specialchars being deprecated (we are running php 5.4.3, vBulletin 4.1.4) and have made some previous modifications when we upgraded our PHP version to get rid of those problems in the forum itself. We had forgotten about this issue when running tools.php.
Running the "bitfield" options completed, even with the errors, and it seemed to fix the issue with the datastore.
But it left the forum with problems. At first the problems were pretty big. A number of plugins that we've created and added ourselves didn't work at all, including a banner ad manager. Just for grins, I went in and turned off one of the Products our Plugins were attached to, and suddenly most of the functionality re-appeared correctly. I turned on the one product I'd disabled and it continued to work correctly as well.
Later, I realized we still had two problems.
1) We have a "Front Page" via vbAdvanced (vBa CMPS) that is not working. The configuration data for the CMPS is showing up in the AdminCP correctly, the Front Page is configured correctly, and all modules we are displaying on the Front Page are configured correctly. When we try to access the Front Page (via vBa's replacement index.php) we get a vBulletin error that says it can't find the page specified.
2) Users cannot add attachments to posts. When they click to create a new post, the Attachment area under the post editor is simply not there. I've reviewed permissions in user groups and can't find a reason that anyone who is logged in and able to create a post should not have permissions to access attachments. All previously-uploaded attachments (i.e., those uploaded before our problem) display and act correctly.
We run two other forums that have almost identical configurations and I've compared those forums to the problem forum and can't find any differences. Obviously this must have to do with some sort of caching/pre-parsed text issue in the database, but I'm damned if I know what at this point.
I'm a developer, although with a couple of decades of experience writing c#/.Net code and only a few years' experience developing with PHP and vBulletin. I have a development environment set up on my local machine, though I have yet to run the "bitfield" option in the tools.php script locally in order to try to "break" my local environment. That's probably my next play, so I can debug directly and try to see what's happening, but I was kind of hoping to avoid having to do that :)
Anyone have any suggestions as to what to look at?