Previous Thread
Next Thread
Print Thread
Hop To
#186255 06/10/2007 6:23 AM
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 frown


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Mark S #186258 06/10/2007 6:52 AM
Joined: Jun 2006
Posts: 3,837
I
Ian Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,837
To be honest I would say this would be better at ubbdev smile

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 smile


Ian #186261 06/10/2007 8:46 AM
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 Content

version 7.1
Originally Posted by Rick
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 wink


Originally Posted by Gizmo
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
Mark S #186301 06/10/2007 7:08 PM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
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 wink...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #186304 06/11/2007 12:09 AM
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

ntdoc #186327 06/11/2007 10:50 AM
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 wink


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Mark S #186330 06/11/2007 11:53 AM
Joined: Jun 2006
Posts: 3,837
I
Ian Offline
Carpal Tunnel
Carpal Tunnel
I Offline
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.

Ian #186335 06/11/2007 12:19 PM
Joined: Jul 2006
Posts: 4,057
Joined: Jul 2006
Posts: 4,057
agreed wink


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Ian #186363 06/11/2007 7:31 PM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Originally Posted by Ian
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


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #186386 06/12/2007 5:09 AM
Joined: Jul 2006
Posts: 4,057
Joined: Jul 2006
Posts: 4,057
Link to DEV SQL Stuff Click Me smile

Someone may want to add that link to the first post ?

Originally Posted by Ian
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 wink (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
Mark S #186427 06/12/2007 2:58 PM
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 wink


- Allen
- ThreadsDev | PraiseCafe
Joined: Jul 2006
Posts: 4,057
Joined: Jul 2006
Posts: 4,057
Sorry Gizmo its a handy one wink

Originally Posted by Gizmo
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

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
0 members (), 744 guests, and 147 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)