#2378 (ok 2.10.1) PDF export is too wide

[Charlie]

In phpmyadmin 2.10.0.2 when I use export as PDF, the columns are wider than in the previous version I was using, 2.9.1.1. In some cases there is much more white space than needed. This causes some data to wrap, in cases where it didn't before. With the older version I could print my favorite report on a single page. Now it takes two.

The problem happens consistently in 2.10.0.2 but never in 2.9.1.1, while running against the same data.

[Marc Delisle]

Logged In: YES
user_id=210714
Originator: NO

I confirm that a DATETIME field is too wide but I would like to catch all these problems. Please attach a small dump of your table with sample data.

[Charlie]

Test data table for PDF problem

[Charlie]

Logged In: YES
user_id=1723433
Originator: YES

File Added: creatcbl.sql

[Charlie]

Logged In: YES
user_id=1723433
Originator: YES

I attached a table dump. Here's the query:

SELECT `Jack`, `Type`, `Color`, `Location`, `User`, `InUse`, `PhonePort`, CAST(ROUND(IF(`Extension` > 10000,`Extension` / 10,`Extension`)) AS UNSIGNED) AS 'Extension', `NetworkPort`, `Connection`, `Comment` FROM `Cabling` where `Type` != 'unwired' order by IF(Jack IS NULL or jack='', 1, 0), Jack, Type, Color, IF(PhonePort IS NULL or PhonePort='', 1, 0), PhonePort, IF(Extension IS NULL or Extension='', 1, 0), Extension, IF(NetworkPort IS NULL or NetworkPort='', 1, 0), NetworkPort, Location, User

I'll attach the output from the PDF export for the two versions as well, if I can get it to upload.

[Charlie]

Logged In: YES
user_id=1723433
Originator: YES

File Added: Cablingpa.pdf

[Charlie]

This one should be correct, done on 2.9.1.1

[Charlie]

Logged In: YES
user_id=1723433
Originator: YES

I'm unable to upload the other example, I get an error that it's either too large or too small. You have the important one though, the one showing the correct output in the old version. For the new version you should be able to do an export and compare.

[Marc Delisle]

Logged In: YES
user_id=210714
Originator: NO

Yes I can see the differences between phpMyAdmin versions, working on it.

[Marc Delisle]

Logged In: YES
user_id=210714
Originator: NO

Fixed in subversion, thanks for reporting.

[Charlie]

Logged In: YES
user_id=1723433
Originator: YES

Tested the fix on my data and it looks fine. Thanks and good work!