Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 23 Apr 2017, 19:49
chikuru chikuru is offline
 
Join Date: Nov 2011
Recreate table


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Whats the query to recreate that table in vbulletin 4.2?
Thanks!
Reply With Quote
  #2  
Old 23 Apr 2017, 20:57
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
You can get it from the mysql-schema.php file, in the install folder.
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #3  
Old 24 Apr 2017, 03:28
chikuru chikuru is offline
 
Join Date: Nov 2011
Thanks!

The missing threadviews table caused the database to create lots of taggregate_temp_xxxx tables.
Is there sql query to delete them all at once? Because I cant manually delete them because phpmyadmin hangs when I tried to load the database. Thanks!
Reply With Quote
  #4  
Old 24 Apr 2017, 17:48
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Real name: Andreas
Unfortuatenly, there is no way to delete all those tables with one query.

You could do some trickery with information_schema though:
http://stackoverflow.com/questions/1...es-with-prefix

Alternatively you could run a simple script:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

No guarantees whatsoever, eg. you should be prepared to have a backup ready if anything goes wrong

Last edited by Andreas; 25 Apr 2017 at 12:49.
Reply With Quote
  #5  
Old 25 Apr 2017, 12:21
chikuru chikuru is offline
 
Join Date: Nov 2011
Thanks Andreas! Problem solved
More than 100,000 temp tables have been removed
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 09:28.

Layout Options | Width: Wide Color: