Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
2 registered (Dunny, Ruben), 48 Guests and 14 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/05/06
Posts: 709
Top Posters (30 Days)
Ruben 50
DennyP 24
Gizmo 24
Dunny 15
SteveS 13
AllenAyres 12
dbremer 10
SD 10
drkknght00 9
driv 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Topic Options
#222802 - 02/22/09 11:05 AM [FIXED for 7.5] 7.5b2 Saved SQL queries w/line breaks
DLWebmaestro Offline
enthusiast
Registered: 03/26/08
Posts: 333
Loc: North Carolina
admin/database.php?returntab=1 (SQL Command in CP)

  1. Type a query that contains line breaks into the Query box.
  2. Save the query.
  3. Click the 'Execute' link next to the saved query.
  4. Enjoy a SQL error.


Fix:
In templates/default/admin/database.tmpl find:
Code:
function exeCommand (i) {
	document.sql.command.value = commandArray[i];
	document.sql.submit();
}
and replace it with:
Code:
function exeCommand (i) {
	document.sql.command.value = commandArray[i].replace(/JSLBR/g,'\n');
	document.sql.submit();
}
_________________________
Marching Percussion ( Drumline ) Community
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#222803 - 02/22/09 11:08 AM Re: 7.5b2 Saved SQL queries w/line breaks [Re: DLWebmaestro]
gliderdad Offline
Registered: 06/08/06
Posts: 1466
Loc: NY
Yes, I saw this bout a week ago when doing the same. I needed to click use and than execute for it to wor.k right
Top
#222805 - 02/22/09 11:35 AM Re: 7.5b2 Saved SQL queries w/line breaks [Re: gliderdad]
DLWebmaestro Offline
enthusiast
Registered: 03/26/08
Posts: 333
Loc: North Carolina
It appears that this existed in 7.4.2 (since the code snippet culprit is identical) but I guess nobody noticed it. I don't know how far back in versions it goes, but at least they have a fix now. smile
_________________________
Marching Percussion ( Drumline ) Community
Top
#222806 - 02/22/09 11:37 AM Re: 7.5b2 Saved SQL queries w/line breaks [Re: DLWebmaestro]
gliderdad Offline
Registered: 06/08/06
Posts: 1466
Loc: NY
I noticed it in 7.4.2 and while in Pm with Rick mentioned it, not sure if he saw it though.
Top
#222848 - 02/23/09 10:31 AM Re: 7.5b2 Saved SQL queries w/line breaks [Re: gliderdad]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Thanks for the report and fix.
Top
#222856 - 02/23/09 11:12 AM Re: 7.5b2 Saved SQL queries w/line breaks [Re: Rick]
DLWebmaestro Offline
enthusiast
Registered: 03/26/08
Posts: 333
Loc: North Carolina
_________________________
Marching Percussion ( Drumline ) Community
Top
#222859 - 02/23/09 11:24 AM Re: 7.5b2 Saved SQL queries w/line breaks [Re: DLWebmaestro]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
-1 brownie points for posting dancing fruit frown
Top
#222860 - 02/23/09 11:27 AM Re: 7.5b2 Saved SQL queries w/line breaks [Re: Rick]
DLWebmaestro Offline
enthusiast
Registered: 03/26/08
Posts: 333
Loc: North Carolina
But that's how you know it's ripe! wink
_________________________
Marching Percussion ( Drumline ) Community
Top
#222863 - 02/23/09 11:37 AM Re: 7.5b2 Saved SQL queries w/line breaks [Re: DLWebmaestro]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
That's how you know it's been possessed by the devil!
Top
#222871 - 02/23/09 02:46 PM Re: 7.5b2 Saved SQL queries w/line breaks [Re: Rick]
DLWebmaestro Offline
enthusiast
Registered: 03/26/08
Posts: 333
Loc: North Carolina
Mmm... sacrilicious.
_________________________
Marching Percussion ( Drumline ) Community
Top



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Temporary Password email not being received
by
05/24/12 10:02 PM
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Forum Stats
10492 Members
36 Forums
33842 Topics
181709 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image