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
Page 1 of 2 1 2 >
Topic Options
#223801 - 03/09/09 12:51 AM [FIXED for 7.5.1] 7.5 Database Execute not working
Basil Offline
addict
Registered: 08/18/06
Posts: 685
Loc: Southwest US
When I save a database query in the Database tools, then try to click the execute link to execute that query, nothing happens. I have to cut and past the query into the query window, then click the execute button and that does work, But the execute link for a saved query doesn't work at all for me.

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."
#223809 - 03/09/09 01:20 PM Re: 7.5 Database Execute not working [Re: Basil]
Ruben Online   hyper

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL
Basil must be bored and testing a lot of items. Go Basil!!
I tried this myself for the first time and it does not work either except for delete using 7.5.

But I do have a question on the options on saved queries.
There is use,execute and delete.

What is the difference between use and execute?
_________________________
Blue Man Group
Top
#223810 - 03/09/09 01:37 PM Re: 7.5 Database Execute not working [Re: Ruben]
SD Offline
Registered: 04/19/07
Posts: 4056
Loc: SoCal, USA
Use should load it into the textarea for possible edit..

Execute does a load into the textarea and simulates (javascript) hitting the 'Execute' button right after that..

I put that code in for 7.3 and dunno why it might have changed. :shrug:

I think there was some modification to just cleanup the <br /> stuff in the actual text, but nothing more...

i'm curious as to which browser y'all are usin.. i use FFox 3
_________________________

Threads tutorials . Threads & Wordpress experts . UBB resume

If I you, click this link as to why
Top
#223811 - 03/09/09 01:39 PM Re: 7.5 Database Execute not working [Re: SD]
Ruben Online   hyper

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL
Okay. When it works I guess.
Thanks guy.
Right now nothing happens at all.
_________________________
Blue Man Group
Top
#223813 - 03/09/09 01:55 PM Re: 7.5 Database Execute not working [Re: Ruben]
SD Offline
Registered: 04/19/07
Posts: 4056
Loc: SoCal, USA
yep.. it was working in 7.4.1 from my test.. now broken in 7.5

tested with FF3, IE7, Chrome frown

/templates/default/admin/database.tmpl

Php Code:
document.sql.command.value = commandArray[i].replace(/JSLBR/g,'\n'); 


in an effort to solve the <br> issue, it got broke..
_________________________

Threads tutorials . Threads & Wordpress experts . UBB resume

If I you, click this link as to why
Top
#223814 - 03/09/09 01:58 PM Re: 7.5 Database Execute not working [Re: SD]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Hmm, will look and see what I may have borken.
Top
#223819 - 03/09/09 02:28 PM Re: 7.5 Database Execute not working [Re: Rick]
Mark S Offline
Carpal Tunnel
Registered: 07/04/06
Posts: 4447
Loc: Liverpool : England : UK
Originally Posted By: Rick
Hmm, will look and see what I may have borken.


I Love Ricks Honesty wink
_________________________
Version v7.5.6 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.
Top
#223825 - 03/09/09 02:40 PM Re: 7.5 Database Execute not working [Re: Mark S]
SD Offline
Registered: 04/19/07
Posts: 4056
Loc: SoCal, USA
and his schpeeling too laugh
_________________________

Threads tutorials . Threads & Wordpress experts . UBB resume

If I you, click this link as to why
Top
#223828 - 03/09/09 02:54 PM Re: 7.5 Database Execute not working [Re: SD]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Found it. Line 39 of templates/default/admin/database.tmpl currently has this:

Code:

document.sql.command.value = commandArray[i].replace(/JSLBR/g,'\n');



That, should be this:

Code:

document.sql.command.value = commandArray[i].replace(/JSLBR/g,'\\n');




Edited by Rick (03/09/09 02:54 PM)
Top
#223900 - 03/10/09 05:42 PM Re: 7.5 Database Execute not working [Re: Rick]
Basil Offline
addict
Registered: 08/18/06
Posts: 685
Loc: Southwest US
Looks like it's juat an extra \ needed, right?
Top
#223901 - 03/10/09 05:43 PM Re: 7.5 Database Execute not working [Re: Basil]
SD Offline
Registered: 04/19/07
Posts: 4056
Loc: SoCal, USA
correct.. the \ is a special char and needs to be escaped by using another \ smile
_________________________

Threads tutorials . Threads & Wordpress experts . UBB resume

If I you, click this link as to why
Top
Page 1 of 2 1 2 >



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