#4784 (ok 4.3.12) Incomplete bookmark saving

[derados]

It is not possible to save big query as bookmark.
If you have query of 20 lines(multiple INSERTS,UPDATES delimited by ;), and try to bookmark it, it will break it and save only last 2-3 lines.
In version 4.2.13.1 it all works.

[derados]

starting already with 4.3.0 , saving complete query under bookmark is not working.
last 4.2.x works without problems.

[Dan Ungureanu]

I was not able to reproduce it. I tried with two bookmarks: a 400 lines long (random SELECT, DELETE, INSERT and UPDATE queries) and a 128 lines (a database schema). They were both saved successfully. Can you give us more details?

Thank you!

[derados]

I know you can't execute this query but this is an example what i am trying to save. It executes and shows message that it's saved but when opening it with "Bookmarked query - View only", it shows only 2 lines:

" b.Mak = t.Mak AND b.PolNr = t.PolNr AND b.BRAN = t.Branche AND
b.BRNR = t.BranZ;"

P.S.
It was tested on Chrome and Firefox, by 3 different Users. Also, in all versions of 4.3.x and 4.4.0alfa & beta.
Finally it was saved properly with last 4.2.x version.

[Dan Ungureanu]

Thank you very much! I will get on it ASAP!

Done! https://github.com/phpmyadmin/phpmyadmin/pull/1566

[derados]

Changed my import.php file , tested, now working without problems.
Plans for adding this changement to next official version 4.3.12 or 4.4.0 ?

[Dan Ungureanu]

I am glad I could help. I am not sure. Wait for a member of the development team to answer.

[Marc Delisle]

Yes, this will be part of 4.3.12.