Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
3 registered members (Gizmo, isaac, M4TT), 57 guests, and 389 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Gizmo
Gizmo
Portland, OR; USA
Posts: 16,788
Joined: June 2006
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 14
M4TT 12
Ruben 8
mmkk 4
FREAK 4
isaac 3
Latest Photos
Chinese Buddhist temple.
My buddha beads.
Rendered Walls
Multi-Screen wallpaper
Stockholm Metro
Previous Thread
Next Thread
Print Thread
[FIXED for 7.5] 7.5b2 Saved SQL queries w/line breaks #222802
02/22/09 11:05 AM
02/22/09 11:05 AM
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 11:08 AM
02/22/09 11:08 AM
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 11:35 AM
02/22/09 11:35 AM
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 11:37 AM
02/22/09 11:37 AM
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 10:31 AM
02/23/09 10: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 11:12 AM
02/23/09 11:12 AM
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 11:24 AM
02/23/09 11:24 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
-1 brownie points for posting dancing fruit frown

Re: 7.5b2 Saved SQL queries w/line breaks [Re: Rick] #222860
02/23/09 11:27 AM
02/23/09 11:27 AM
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 11:37 AM
02/23/09 11:37 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
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 02:46 PM
02/23/09 02: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
Users Unable to Upload Avatar [Not a Bug]
by M4TT. 12/13/17 08:51 AM
Shout Box Sound Effect
by M4TT. 11/29/17 08:28 PM
Ad island
by TGCsanderson. 11/25/17 06:41 PM
Taking to long to connect to DB
by AstroCat. 11/24/17 12:34 PM
Forum Statistics
Forums36
Topics35,015
Posts190,544
Members12,045
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.1
(Snapshot build 20171106)