On Fri, Sep 6, 2013 at 5:49 PM, adam <adamgsoc2013@gmail.com> wrote:

Hi all,

I am adding unit test cases for importing Sharp files.

https://github.com/phpmyadmin/phpmyadmin/blob/master/libraries/plugins/impor...

But I don't know where to get a Sharp file that can be imported by PMA. (PMA seems don't have the function for exporting data to Sharp files).

Can someone share me one sharp file to me? thanks

Hi Adam, You can find ESRI shape files at http://sourceforge.net/p/phpmyadmin/patches/669/ -- Thanks and Regards, Madhura Jayaratne

Hi all, I am making a pull request about UT for import Sharp file. https://github.com/phpmyadmin/phpmyadmin/pull/688 but the trival result shows a error. https://travis-ci.org/phpmyadmin/phpmyadmin/jobs/11353415 I don't know why this error happens: PHP Fatal error: Maximum execution time of 300 seconds exceeded in /home/travis/.phpenv/versions/5.5.0/share/pyrus/.pear/php/PHP/Token/Stream.php on line 205 this pull request just import a sharp file and verify the import result. It is OK when I am testing on my dev box. I was thinking that is due to the sharp file size, so I changed to a small one. but the error still existed. thanks for your help adam

Hi Michal,

Hi Adam

Dne Sat, 14 Sep 2013 17:11:05 +0800 adam <adamgsoc2013@gmail.com> napsal(a):

...

I am making a pull request about UT for import Sharp file. https://github.com/phpmyadmin/phpmyadmin/pull/688

Just small note - these are called Shape files, not Sharp files :-).

...

but the trival result shows a error. https://travis-ci.org/phpmyadmin/phpmyadmin/jobs/11353415 I don't know why this error happens: PHP Fatal error: Maximum execution time of 300 seconds exceeded in /home/travis/.phpenv/versions/5.5.0/share/pyrus/.pear/php/PHP/Token/Stream.php on line 205

this pull request just import a sharp file and verify the import result. It is OK when I am testing on my dev box. I was thinking that is due to the sharp file size, so I changed to a small one. but the error still existed.

Probably 3MB test file is quite big, how long does the test run on your side?

We might simply just icrease time limit for PHP on Travis build as well...

I have changed the data file to a small one (2.801 kb) https://github.com/adamgsoc2013/phpmyadmin/blob/d3a87951dee7de55a3d16277b69d... But the error still existed. regards, Adam

2013/9/6 Marc Delisle <marc@infomarc.info>:

Isaac Bennetch a écrit :

...

Does anyone recall or is able to reproduce [1], "If you update a row with a BLOB column and set it to NULL, the operation works but says 0 rows affected, which obviously is an incorrect row count."

I recall there was an issue, but I don't remember the details.

...

This was one of the bugs we discovered at the team meeting but we're having difficulty reproducing it. If you were the one to discover/mention it, could you jump in the conversation at that bug thread?

Thanks

1 - https://sourceforge.net/p/phpmyadmin/bugs/4062/

At the team meeting, the only BLOB situation I remember is that, for the tutorial, we had a LONGBLOB in the employees table. Not sure if it could be set to NULL.

Setting a LONGBLOB to NULL is possible, I used a statement of this form : 'UPDATE `table` SET `longblob_column` = NULL' -- Kind regards, Dieter Adriaenssens