Hi,
I noticed in MySQL some tables has no primary key set : humanverify and googlemapme_settings (I assume this is two tables created by default by vBulletin).
Is there a reason for...
Announcement
Collapse
No announcement yet.
Search Result
Collapse
119 results in 0.0069 seconds.
Keywords
Members
Tags
-
Tables without primary key
-
Accidental topic hard removal by moderator. Is there any way to restore it?
Hello Wayne and colleagues,
One of the moderators at the Forum which I technically support has removed the topic. Completely removed, not soft deleted.
However I have a backup of the... -
Time Date Numbers
Just noted that time, date, some miscellaneous other numbers aren't displaying properly. Tried a database repair on the server, haven't edited Time Zone other than to select Eastern Time.
... -
vBulletin 5 Database Best Practices
-
Created by:
Wayne Luke
- Published: Sat 1 Dec '18, 8:09am
- views
- 0 comments
vBulletin 5 Database Best Practices
The database is the heart and soul of your vBulletin site. All content and user information is stored in the database. Protect the database and you protect your site. This document will go over the creation and usage of a MySQL database for the use of vBulletin 5 Connect. If you have shared hosting and are provided a web-based control panel like cPanel, you will need to access your hosting provider's documentation on how to carry out these operations. This document assumes a general familiarity with the command line operations of your Operating System. All commands listed assume that you are accessing your server via SSH. ...Last edited by Wayne Luke; Wed 8 Apr '20, 8:06am. -
Created by:
-
Message Center Moderation - pending posts redirects to forum home page
We are using vBulletin 5.4.2 and we've been having issues with moderating posts in the message center for a while, even with previous versions of vb5.
When a moderator or admin attempts to... -
Why does large forum have slow page load speeds?
I have a 5.4 forum with these stats:
Topics: 195,223 Posts: 1,034,594 Members: 356,471 Active Members: 10,870
I think there are about 100-200 main forums and the same amount... -
I can't approve a new posts in admincp
Hello guys !
i get a problem after upgraded my forum from 4.2.3 to 5.3.0.
this problem i can't Moderate ( approve or ignore...... ) a new topics or posts in my forum. I repaired tables SQL... -
'Error Fetching Forums' after 5.1.8 to 5.1.10 Upgrade
Hi,
After upgrading from 5.1.8 to 5.1.10, forum listing page shows error in screenshot attached- 'Error fetching forums'.
There is nothing in nginx, php5-fpm, mySQL logs, or...1 PhotoLast edited by David Karol; Sun 6 Dec '15, 2:36pm. -
Transfere Database Tables to over Server not Completed
Hello Guys,
I have one big problem, I start changing to new server hosting
Just after my Backup by Cpanel & phpmyadmin is not 100% ok
All time i have 250 Tables all work fine...Last edited by apache@93; Mon 14 Sep '15, 12:34am. -
Deadlocks on node 9 in node table in vBulletin 5.1.1
Hi,
I'm having more than 2k database error emails about deadlocks happened between these 2 SQL statements:
1: Invalid SQL:
UPDATE node SET
textcount =
CASE WHEN 1 > 0...