|
Joined: Jul 2006
Posts: 4,057
|
Joined: Jul 2006
Posts: 4,057 |
Its been mentioned a few times around the forums, but i think it would be really handy to post those advanced mysql commands for fixing and resolving problems. Or any neat queries you would like to share. Please state the version of Threads the query works with, as database changes and tweaks happen all the time. I'm hopeless at them so i cant leave an example
BOOM !! Version v7.6.1.1 People who inspire me Isaac ME Gizmo
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
To be honest I would say this would be better at ubbdev Queries for Threads 7 should be separate from those for previous reasons, as an SQL query can do a lot of damage in the wrong hands. Another reason to do this at ubbdev. Just my 2 pennies worth
|
|
|
|
Joined: Jul 2006
Posts: 4,057
|
Joined: Jul 2006
Posts: 4,057 |
I would agree, but there are examples that have been posted on these forums by rick and others. Removing all Signatures Contentversion 7.1 If you just want to blank out everyone's signature, then you can run the following SQL command. Note, if you have a lot of users, you probably should just close the board before you run this because it might take a bit. update ubbt_USER_PROFILE set USER_SIGNATURE='',USER_DEFAULT_SIGNATURE='' That will set everyone's signature to blank, including yours why not play nice and update only those with images in their signature...
update ubbt_USER_PROFILE set USER_SIGNATURE='',USER_DEFAULT_SIGNATURE='' WHERE USER_SIGNATURE LIKE '%img%'
BOOM !! Version v7.6.1.1 People who inspire me Isaac ME Gizmo
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
My 2 pents would concourr with Ian... The improper formatting of an SQL (or SSH) command will render your forum, or server, useless... You of all people should know this Mark ...
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
Select wrongstuff Where "I need a server rebuild" = now
|
|
|
|
Joined: Jul 2006
Posts: 4,057
|
Joined: Jul 2006
Posts: 4,057 |
ok ok ok just trying to be helpful as New Admins don't know / understand ubbdev when registering, or using a site search. Do as you wish with this topic
BOOM !! Version v7.6.1.1 People who inspire me Isaac ME Gizmo
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
If Groupee officially recognise Ubbdev (which I am sure they do) it would be good to have a prominent link on this site - maybe top left.
|
|
|
|
Joined: Jul 2006
Posts: 4,057
|
Joined: Jul 2006
Posts: 4,057 |
agreed
BOOM !! Version v7.6.1.1 People who inspire me Isaac ME Gizmo
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
If Groupee officially recognise Ubbdev (which I am sure they do) it would be good to have a prominent link on this site - maybe top left. Oh riiiiii iiiiick.... lol
|
|
|
|
Joined: Jul 2006
Posts: 4,057
|
Joined: Jul 2006
Posts: 4,057 |
Link to DEV SQL Stuff Click Me Someone may want to add that link to the first post ? If Groupee officially recognise Ubbdev (which I am sure they do) it would be good to have a prominent link on this site - maybe top left. They must do or very close as every time i type "UBBDEV" i get a hyperlink (Active text i know).
Last edited by Mark S; 06/12/2007 5:11 AM.
BOOM !! Version v7.6.1.1 People who inspire me Isaac ME Gizmo
|
|
|
|
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
|
Pooh-Bah
Joined: Dec 2003
Posts: 1,796 |
We have a prominent link in every post I make
|
|
|
|
Joined: Jul 2006
Posts: 4,057
|
Joined: Jul 2006
Posts: 4,057 |
Sorry Gizmo its a handy one Simple SQL Queries:
Allow Attachments Everywhere: UPDATE `forum_FORUMS` SET `FORUM_ALLOW_ATTACHMENTS` = '1';
Allow Polls in Every Forum: UPDATE `forum_FORUMS` SET `FORUM_ALLOW_POLLS` = '1';
Allow Polls in Replies UPDATE `forum_FORUMS` SET `FORUM_POLLS_ANYWHERE` = '1';
Replace forum_ with your dbprefix. And handy to know. V7.1
BOOM !! Version v7.6.1.1 People who inspire me Isaac ME Gizmo
|
|
|
1 members (Ruben),
1,101
guests, and
206
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|