phpMyAdmin / Bugs / #3071 (ok 3.3.8) error when edit record with geometry

#3071 (ok 3.3.8) error when edit record with geometry

Status: fixed

Owner: Marc Delisle

Labels: Data insertion/extraction/manipulation (334)

Priority: 1

Updated: 2013-06-11

Created: 2010-08-02

Creator: steve smith

Private: No

If a table has a geometry column the error always occurs when saving edited record.
phpMyAdmin seems to think the geometry value has changed when it has not.
This may occur with any blob.
Needs to just ignor geometry column.

Discussion

steve smith - 2010-08-03

example table sql dump is attached

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

steve smith - 2010-08-03

geo_x3dbuilding.sql

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2010-08-24

assigned_to: nobody --> lem9
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2010-08-24

Also I guess that when displaying in Browse mode or displaying one row, phpMyAdmin should ignore geometry columns?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2010-09-04

Any feedback?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2010-10-03

This bug was fixed in repository and will be part of a future release; thanks for reporting.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2010-10-03

priority: 5 --> 1

summary: error when edit record with geometry --> (ok 3.3.8) error when edit record with geometry

status: open --> open-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

steve smith - 2010-10-12

thanks for this,
will check it in the next RC1

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2010-10-25

status: open-fixed --> closed-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Michal Čihař - 2013-06-11

Status: closed-fixed --> fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

(ok 3.3.8) error when edit record with geometry

A software tool to bring MySQL to the Web

Group

Searches

Help

#3071 (ok 3.3.8) error when edit record with geometry

Discussion