SQL command with multiple rows (separated by Enter) phpLiteAdmin not work

[Former user]

Originally reported on Google Code with ID 163

When I attempt run SQL command with multiple rows (separated by Enter) phpLiteAdmin
not work.
But work in one line.

Reported by ktretyakGM on 2012-12-30 14:28:49

<hr> * Attachment: SQLcommandMultiLine.PNG<br>

[Christopher Kramer]

Thanks for reporting this issue.
I could reproduce it in 1.9.3 and 1.9.4.
The problem is that phpliteAdmin searches for "select ". Instead, it should preg_match
for "select\s".
Woraround: Add a space after select.
I will fix the issue soon.

Reported by crazy4chrissi on 2012-12-30 14:47:59 - Status changed: Accepted

[Christopher Kramer]

This issue was closed by revision r308.

Reported by crazy4chrissi on 2012-12-30 14:55:18 - Status changed: Fixed

[Christopher Kramer]

I just fixed the problem in svn, revision r308.

You can get the latest development version from svn here:
http://phpliteadmin.googlecode.com/svn/source/1.9.4/phpliteadmin.php

Please confirm if this solves your problem.

Thanks again for reporting the issue.

Reported by crazy4chrissi on 2012-12-30 14:58:49

[Former user]

Yes, this problem has been solved. Thank you!

Reported by ktretyakGM on 2012-12-31 23:05:49