Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
1 registered members (Morgan), 66 guests, and 395 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Outdoorking
Outdoorking
Sydney, Australia
Posts: 320
Joined: June 2006
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 18
isaac 14
Morgan 13
Ruben 12
Latest Photos
Testing to drag photos
Comfortable Cats
Test
BSA photos
Chinese Buddhist temple.
Previous Thread
Next Thread
Print Thread
[FIXED for 7.5] 7.5b2 Saved SQL queries w/line breaks #222802
02/22/09 12:05 PM
02/22/09 12:05 PM
Joined: Mar 2008
Posts: 340
North Carolina
D
DLWebmaestro Offline OP
enthusiast
DLWebmaestro  Offline OP
enthusiast
D
Joined: Mar 2008
Posts: 340
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();
}

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."
Re: 7.5b2 Saved SQL queries w/line breaks [Re: DLWebmaestro] #222803
02/22/09 12:08 PM
02/22/09 12:08 PM
Joined: Jun 2006
Posts: 1,475
NY
G
gliderdad Offline
veteran
gliderdad  Offline
veteran
G
Joined: Jun 2006
Posts: 1,475
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

Re: 7.5b2 Saved SQL queries w/line breaks [Re: gliderdad] #222805
02/22/09 12:35 PM
02/22/09 12:35 PM
Joined: Mar 2008
Posts: 340
North Carolina
D
DLWebmaestro Offline OP
enthusiast
DLWebmaestro  Offline OP
enthusiast
D
Joined: Mar 2008
Posts: 340
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

Re: 7.5b2 Saved SQL queries w/line breaks [Re: DLWebmaestro] #222806
02/22/09 12:37 PM
02/22/09 12:37 PM
Joined: Jun 2006
Posts: 1,475
NY
G
gliderdad Offline
veteran
gliderdad  Offline
veteran
G
Joined: Jun 2006
Posts: 1,475
NY
I noticed it in 7.4.2 and while in Pm with Rick mentioned it, not sure if he saw it though.

Re: 7.5b2 Saved SQL queries w/line breaks [Re: gliderdad] #222848
02/23/09 11:31 AM
02/23/09 11:31 AM
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline
Former Developer
Rick  Offline
Former Developer
R
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
Thanks for the report and fix.

Re: 7.5b2 Saved SQL queries w/line breaks [Re: Rick] #222856
02/23/09 12:12 PM
02/23/09 12:12 PM
Joined: Mar 2008
Posts: 340
North Carolina
D
DLWebmaestro Offline OP
enthusiast
DLWebmaestro  Offline OP
enthusiast
D
Joined: Mar 2008
Posts: 340
North Carolina
[Linked Image]

Re: 7.5b2 Saved SQL queries w/line breaks [Re: DLWebmaestro] #222859
02/23/09 12:24 PM
02/23/09 12:24 PM
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline
Former Developer
Rick  Offline
Former Developer
R
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
-1 brownie points for posting dancing fruit frown

Re: 7.5b2 Saved SQL queries w/line breaks [Re: Rick] #222860
02/23/09 12:27 PM
02/23/09 12:27 PM
Joined: Mar 2008
Posts: 340
North Carolina
D
DLWebmaestro Offline OP
enthusiast
DLWebmaestro  Offline OP
enthusiast
D
Joined: Mar 2008
Posts: 340
North Carolina
But that's how you know it's ripe! wink

Re: 7.5b2 Saved SQL queries w/line breaks [Re: DLWebmaestro] #222863
02/23/09 12:37 PM
02/23/09 12:37 PM
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline
Former Developer
Rick  Offline
Former Developer
R
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
That's how you know it's been possessed by the devil!

Re: 7.5b2 Saved SQL queries w/line breaks [Re: Rick] #222871
02/23/09 03:46 PM
02/23/09 03:46 PM
Joined: Mar 2008
Posts: 340
North Carolina
D
DLWebmaestro Offline OP
enthusiast
DLWebmaestro  Offline OP
enthusiast
D
Joined: Mar 2008
Posts: 340
North Carolina
Mmm... sacrilicious.


Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Fixing Margins on Introduction? HELP!
by Lisanne. 05/26/18 05:37 PM
https http
by sundance. 05/22/18 05:46 PM
Want to Delete All Old Private Messages
by BellaOnline. 05/19/18 02:00 AM
How to remove Shout Chat
by Outdoorking. 05/17/18 08:37 AM
I am trying to put a banner ad on email template.
by sundance. 05/14/18 01:59 PM
Forum Statistics
Forums36
Topics35,116
Posts191,290
Members12,076
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.2
(Preview build 20180524)