|
|
Joined: Mar 2008
Posts: 326
Enthusiast
|
Enthusiast
Joined: Mar 2008
Posts: 326 |
admin/database.php?returntab=1 (SQL Command in CP) - Type a query that contains line breaks into the Query box.
- Save the query.
- Click the 'Execute' link next to the saved query.
- Enjoy a SQL error.
Fix: In templates/default/admin/database.tmpl find: function exeCommand (i) {
document.sql.command.value = commandArray[i];
document.sql.submit();
} and replace it with: function exeCommand (i) {
document.sql.command.value = commandArray[i].replace(/JSLBR/g,'\n');
document.sql.submit();
}
|
|
|
|
Joined: Jun 2006
Posts: 1,344
veteran
|
veteran
Joined: Jun 2006
Posts: 1,344 |
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
|
|
|
|
Joined: Mar 2008
Posts: 326
Enthusiast
|
Enthusiast
Joined: Mar 2008
Posts: 326 |
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.
|
|
|
|
Joined: Jun 2006
Posts: 1,344
veteran
|
veteran
Joined: Jun 2006
Posts: 1,344 |
I noticed it in 7.4.2 and while in Pm with Rick mentioned it, not sure if he saw it though.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Thanks for the report and fix.
|
|
|
|
Joined: Mar 2008
Posts: 326
Enthusiast
|
Enthusiast
Joined: Mar 2008
Posts: 326 |
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
-1 brownie points for posting dancing fruit
|
|
|
|
Joined: Mar 2008
Posts: 326
Enthusiast
|
Enthusiast
Joined: Mar 2008
Posts: 326 |
But that's how you know it's ripe!
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
That's how you know it's been possessed by the devil!
|
|
|
|
Joined: Mar 2008
Posts: 326
Enthusiast
|
Enthusiast
Joined: Mar 2008
Posts: 326 |
|
|
|
0 members (),
744
guests, and
147
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|
|