6 Sep
2013
6 Sep
'13
7:32 a.m.
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."
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/
6 Sep
6 Sep
3:04 p.m.
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."
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.
--
Marc Delisle
http://infomarc.info
3:19 p.m.
New subject: [Phpmyadmin-devel] UT for import Sharp file
Hi all,
I am adding unit test cases for importing Sharp files.
https://github.com/phpmyadmin/phpmyadmin/blob/master/libraries/plugins/impo…
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
Adam
3:32 p.m.
New subject: [Phpmyadmin-devel] UT for import Sharp file
On Fri, Sep 6, 2013 at 5:49 PM, adam <adamgsoc2013(a)gmail.com> wrote:
Hi all,
I am adding unit test cases for importing Sharp files.
https://github.com/phpmyadmin/phpmyadmin/blob/master/libraries/plugins/impo…
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
3:38 p.m.
New subject: [Phpmyadmin-devel] UT for import Sharp file
Hi,
On Fri, Sep 6, 2013 at 5:49 PM, adam
<adamgsoc2013(a)gmail.com> wrote:
thanks Madhura,
I will try these files. thanks for the useful data.
thanks,
Adam
Hi all,
I am adding unit test cases for importing Sharp files.
https://github.com/phpmyadmin/phpmyadmin/blob/master/libraries/plugins/impo…
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
14 Sep
14 Sep
12:11 p.m.
New subject: [Phpmyadmin-devel] UT for import Sharp file encouters a "Maximum execution time exceeded" error
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
15 Sep
15 Sep
7:45 p.m.
New subject: [Phpmyadmin-devel] UT for import Sharp file encouters a "Maximum execution time exceeded" error
Hi Adam
Dne Sat, 14 Sep 2013 17:11:05 +0800
adam <adamgsoc2013(a)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...
--
Michal Čihař | http://cihar.com | http://phpmyadmin.net
16 Sep
16 Sep
4:53 a.m.
New subject: [Phpmyadmin-devel] UT for import Sharp file encouters a "Maximum execution time exceeded" error
Hi Michal,
Hi Adam
Dne Sat, 14 Sep 2013 17:11:05 +0800
adam <adamgsoc2013(a)gmail.com> napsal(a):
I have changed the data file to a small one (2.801 kb)
https://github.com/adamgsoc2013/phpmyadmin/blob/d3a87951dee7de55a3d16277b69…
But the error still existed.
regards,
Adam
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...
9:34 a.m.
New subject: [Phpmyadmin-devel] UT for import Sharp file encouters a "Maximum execution time exceeded" error
Hi
Dne Mon, 16 Sep 2013 09:53:44 +0800
adam <adamgsoc2013(a)gmail.com> napsal(a):
Hi Michal,
And how long does this test run in your environment?
--
Michal Čihař | http://cihar.com | http://blog.cihar.com
Hi Adam
Dne Sat, 14 Sep 2013 17:11:05 +0800
adam <adamgsoc2013(a)gmail.com> napsal(a):
I have changed the data file to a small one (2.801 kb)
https://github.com/adamgsoc2013/phpmyadmin/blob/d3a87951dee7de55a3d16277b69…
But the error still existed. 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... 
9 Sep
9 Sep
6:20 p.m.
2013/9/6 Marc Delisle <marc(a)infomarc.info>fo>:
Setting a LONGBLOB to NULL is possible, I used a statement of this
form : 'UPDATE `table` SET `longblob_column` = NULL'
--
Kind regards,
Dieter Adriaenssens
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.
4018
days inactive
4028
days old
9 comments
6 participants
participants (6)
-
adam -
Dieter Adriaenssens -
Isaac Bennetch -
Madhura Jayaratne -
Marc Delisle -
Michal Čihař