mysql

Browse and Moderate Logs -> Statistics Grouping - Event brings DB error:

I switched my cache from memcache to xcache this morning and vboptomise stopped working. I uninstalled then reinstalled and it started working again. All the system checks passed. After about 10 minutes the load on the mysql server skyrocketed and when I checked I saw hundreds of the following...

Is there a way to force people onto having a default tab? Possibly a mysql line I can run? EDIT: additionally for it to apply to guests too..

Reuploaded and reinstalled 1.4.0 b2 and got blank pages... I tried to uninstall, and... got the same blank page After this I can see vbdownloads section in products.

Hello guys, I started receiving this error today. Hope someone can help me out? Invalid SQL: INSERT INTO credits_transaction (eventid, actionid, userid, timestamp, amount, status, referenceid, forumid, ownerid, multiplier, currencyid, negate, message) VALUES (11, 'paycheck', 30994...

If you are having difficulties installing the mod due to a large post table (~1 million posts or more) you may wish to opt for running some of the queries ran by the installer in the MySQL command line. Remember to add your table prefix if you use any. Manually run the following queries: ALTER...

If you are having difficulties installing the mod due to a large post table (~1 million posts or more) you may wish to opt for running some of the queries ran by the installer in the MySQL command line. Remember to add your table prefix if you use any. Manually run the following queries: ALTER...

Ok, so our forum has a big post table (61 million posts) and there's no way I can run the install script without things breaking horribly. Any chance I can get instructions on what queries to run manually? I'm paging through the stuff in the install directory, but I'm not sure if I'll see it...

What is involved in writing a importer? I read the post about custom work and what it costs. But this is not a 1 week job, more like a 3-4 hour job. I could probably map the old database to the new database structure, but I don't know enough to write it myself. Is this anything that you guys...

I don't visit here often, but I noticed that the general speed of the forum is slow. Sometimes it is even very slow. I'm just curious as to whether this is from all of the modifications, the server, both, or something else.

I'm still having problems with the Thanks mod and slow queries. I tried changing the dbtech_thanks_entry table to Innodb and the query time went from 1 - 2 seconds to 9 - 10 seconds. Any idea why this happened? What tables can be changed to innodb for this mod that will help with the slow queries?

MySQL Error 1060 during reinstall - Duplicate column name 'screenshot' I try to install this mod on my test-forum (some month ago I already installed the lite version), but I get mySQL error after xml-file import: Invalid SQL: ALTER TABLE dbtech_downloads_fileinfo ADD COLUMN `screenshot`...

Just updated mi vbslider version to the 3.0 Gold versión and my CMS returns a totally blank page without error messajes. If I upload the old widget.php (from previus version) the slider works but without the new improvements. Any solution?.

Hi, i uninstall the shoutbox from our site, but we have now a problem with some error MySQL : Database error in vBulletin 4.2.0: Invalid SQL: SELECT languageid, phrasegroup_global AS phrasegroup_global...

This started few days ago and i have no idea what is causing this. Database error in vBulletin 4.2.0: Invalid SQL: SELECT u.*, a.avatarpath, NOT ISNULL(c.userid) AS hascustomavatar, c.dateline AS avatardateline, c.width AS avwidth, c.height AS avheight, c.height_thumb AS avheight_thumb...

Thank you for the installation, but it turned out some of the problems :) Flush cache screenshot of the error message? ****************************** "Save Attachments as Files " ******************* After you have installed vBSEO does not work : ( No vBSEO ... last request...

When I Recalculate Points, There are not complete all user pionts and it show white page!

I am getting this error "Your Opcache Operator extension is functioning, however it is unable to store data. Please check your extension configuration." Sometimes I get it sometimes I don't. Can you help me on it. I dont have Xcache Auth enabled.

Hi team, I'm finishing my site for a future opening. First I'm doing some tests on various products, to ensure proper operation, Unfortunately this product is giving me a problem. When the installation main page is no longer within reach, I can only enter the admin panel. The index i returns...

Users are not receiving credits after upgrading from 2.00 to 2.1.0. A new user registered on September 1. He created 87 posts and two threads. He should have received 5,000 points per post and 50,000 points per thread. Other members have also donated more than 1,000,000 points but his profile...