Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
2 registered (packlite, 1 invisible), 29 Guests and 19 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 12/15/08
Posts: 7
Top Posters (30 Days)
Ruben Rocha 103
Rick 81
Mark S 72
Thelockman 56
Gizmo 50
driv 35
ntdoc 30
Sirdude 30
packlite 24
AllenAyres 22
Latest Photos
bear test
Beach Barbie-Q
Sunset
Accept the challenge!
Trees
Topic Options
Rate This Topic
#166391 - 10/17/06 02:46 AM [NOTABUG] SQL Command window
Zarzal Offline
old hand

Registered: 06/05/06
Posts: 1097
Loc: Berlin, Germany
It seams to be impossible to chain more then one command. I like to setup a saved query to repair all tables like this:

repair table ubbt_ADDRESS_BOOK;
repair table ubbt_ADMIN_SEARCHES;
repair table ubbt_ANNOUNCEMENTS;
etc.

If I do only one line it work, if I use more then one I get an error. I guess this worked in Threads 6.5.5


Edited by Rick (10/17/06 08:53 AM)
_________________________
my board: http://www.dragon-clan.de
my hobby: http://www.biker-reise.de
Ich kann bei Fragen zu UBBthreads in Deutsch weiterhelfen oder es zumindest versuchen

Top
#166393 - 10/17/06 05:16 AM Re: SQL Command window [Re: Zarzal]
Gizmo Moderator Offline

***

Registered: 06/04/06
Posts: 12089
Loc: Portland, OR; USA
Why not one large query?

REPAIR TABLE `forums_ADDRESS_BOOK` , `forums_ADMIN_SEARCHES` , `forums_ANNOUNCEMENTS` , `forums_BANNED_EMAILS` , `forums_BANNED_HOSTS` , `forums_CACHE` , `forums_CACHED_PERMISSIONS` , `forums_CALENDAR_EVENTS` , `forums_CATEGORIES` , `forums_CENSOR_LIST` , `forums_DISPLAY_NAMES` , `forums_FILES` , `forums_FORUMS` , `forums_FORUM_LAST_VISIT` , `forums_FORUM_PERMISSIONS` , `forums_GRAEMLINS` , `forums_GROUPS` , `forums_IMPORT_MAP` , `forums_LANGUAGES` , `forums_MAILER` , `forums_MEMBER_SEARCHES` , `forums_MODERATORS` , `forums_MODERATOR_NOTIFICATIONS` , `forums_MODERATOR_PERMISSIONS` , `forums_ONLINE` , `forums_POLL_DATA` , `forums_POLL_OPTIONS` , `forums_POLL_VOTES` , `forums_PORTAL_BOXES` , `forums_POSTS` , `forums_PRIVATE_MESSAGE_POSTS` , `forums_PRIVATE_MESSAGE_TOPICS` , `forums_PRIVATE_MESSAGE_USERS` , `forums_RATINGS` , `forums_REGISTRATION_FIELDS` , `forums_RESERVED_NAMES` , `forums_RSS_FEEDS` , `forums_SAVED_QUERIES` , `forums_SEARCH_RESULTS` , `forums_SHOUT_BOX` , `forums_STYLES` , `forums_TOPICS` , `forums_TOPIC_VIEWS` , `forums_USERS` , `forums_USER_DATA` , `forums_USER_GROUPS` , `forums_USER_NOTES` , `forums_USER_PROFILE` , `forums_USER_TITLES` , `forums_VERSION` , `forums_WATCH_LISTS`


Edited by Rick (10/17/06 02:38 PM)
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#166395 - 10/17/06 05:29 AM Re: SQL Command window [Re: Gizmo]
Zarzal Offline
old hand

Registered: 06/05/06
Posts: 1097
Loc: Berlin, Germany
because I'm a noob and need help Thank you. Saved the query for future use if needed in my board.
_________________________
my board: http://www.dragon-clan.de
my hobby: http://www.biker-reise.de
Ich kann bei Fragen zu UBBthreads in Deutsch weiterhelfen oder es zumindest versuchen

Top
#166405 - 10/17/06 08:53 AM Re: SQL Command window [Re: Zarzal]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7993
Loc: Aberdeen, WA
The builtin SQL command box is limited to one query just due to the way things are designed. Even in older versions it was limited to just one.
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#166422 - 10/17/06 02:16 PM Re: SQL Command window [Re: Rick]
Gizmo Moderator Offline

***

Registered: 06/04/06
Posts: 12089
Loc: Portland, OR; USA
Suprisingly mysql can be both difficult and easy at the same time once you learn how to utilize it properly hehe...
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#166423 - 10/17/06 02:35 PM Re: SQL Command window [Re: Gizmo]
Mors Offline
addict

Registered: 06/26/06
Posts: 445
Loc: So. California
Nice Thread can't see anything
_________________________
Happy Customer !!!

Top


Shout Box

Today's Birthdays
GOTMYSELFA...., smilinjack
Recent Topics
New members don't get access and are not displayed in the config panel
by Yomar
Today at 03:32 AM
How to Change Link Color / Underline in styles?
by ECNet
Yesterday at 10:00 PM
Chaging the "max online" number and date
by wanted
Yesterday at 02:22 PM
7.4.1. In Threaded Mode - "Mark All Read" Doesn't Work
by packlite
Yesterday at 10:26 AM
Custom island with sql connection
by Robje01
Yesterday at 09:13 AM
Forum Stats
4296 Members
33 Forums
30687 Topics
156017 Posts

Max Online: 978 @ 06/24/07 08:19 PM