Bug #256

longitude=null beim Anlegen eines neuen Caches

Added by following almost 6 years ago. Updated over 3 years ago.

Status:erledigt% Done:

100%

Priority name:2 mittel
Assignee:following
Target version:Version 14
Ticket Referenz: Kategorien:listing

Description

Folgende SQL-Fehlermeldung erschien mehrfach vor einigen Monaten, im Abstand von einigen Minuten, d.h. der User hat mehrfach versucht einen Cache anzulegen und hatte jedesmal dieses Problem:

048: Column 'longitude' cannot be null
--------------------
Array
(
    [0] => Array
        (
            [file] => /var/www/www.opencaching.de/code/htdocs/lib/clicompatbase.inc.php
            [line] => 405
            [function] => sql_error
            [args] => Array
                (
                )

        )

    [1] => Array
        (
            [file] => /var/www/www.opencaching.de/code/htdocs/lib/clicompatbase.inc.php
            [line] => 212
            [function] => sql_internal
            [args] => Array
                (
                    [0] => Resource id #10
                    [1] => INSERT INTO `caches` (
                `cache_id`,
                `user_id`,
                `name`,
                `longitude`,
                `latitude`,
                `type` ,
                `status` ,
                `country` ,
                `date_hidden` ,
                `date_activate` ,
                `size` ,
                `difficulty` ,
                `terrain`,
                `logpw`,
                `search_time`,
                `way_length`,
                `wp_gc`,
                `wp_nc`,
                `node`
            ) VALUES (
                '', '&1', '&2', '&3', '&4', '&5', '&6', '&7', '&8', '2013-04-17 14:00:00', 
                '&9', '&10', '&11', '&12', '&13', '&14', '&15', '&16', '&17')
                    [2] => 
                    [3] => Array
                        (
                            [1] => 203998
                            [2] => Fortbildung Nienburg Orange
                            [3] => 
                            [4] => 
                            [5] => 3
                            [6] => 5
                            [7] => DE
                            [8] => 2013-04-16
                            [9] => 4
                            [10] => 2
                            [11] => 2
                            [12] => 
                            [13] => 1.5
                            [14] => 1
                            [15] => 
                            [16] => 
                            [17] => 1
                        )

                )

        )

    [2] => Array
        (
            [file] => /var/www/www.opencaching.de/code/htdocs/newcache.php
            [line] => 849
            [function] => sql
            [args] => Array
                (
                    [0] => INSERT INTO `caches` (
                        ... siehe oben ...
                    ) VALUES (
                        '', '&1', '&2', '&3', '&4', '&5', '&6', '&7', '&8', '2013-04-17 14:00:00', 
                        '&9', '&10', '&11', '&12', '&13', '&14', '&15', '&16', '&17')
                        ... siehe oben ...
                )
        )
)

Associated revisions

Revision 54eac692
Added by following almost 4 years ago

fixed coordinate verification for new listings; fixes #256

History

#1 Updated by following almost 4 years ago

  • Status changed from offen to in Arbeit
  • Assignee set to following

#2 Updated by following almost 4 years ago

  • Status changed from in Arbeit to in Arbeit 80%
  • Target version set to Version 14
  • % Done changed from 0 to 80

newcache.php hat bei leeren Koordinatenfeldern (mit Absicht) Null-Werte generiert, warum auch immer. editcache.php nicht.

#3 Updated by following almost 4 years ago

  • Status changed from in Arbeit 80% to erledigt
  • % Done changed from 80 to 100

Status geändert durch Changeset oc-server3|commit:54eac6927ff179fcb950b6d994d02c9e2382d877.

#4 Updated by following almost 4 years ago

  • Status changed from erledigt to im Test
  • % Done changed from 100 to 90

#5 Updated by following almost 4 years ago

  • Status changed from im Test to erledigt
  • % Done changed from 90 to 100

Status geändert durch Changeset oc-server3n|commit:54eac6927ff179fcb950b6d994d02c9e2382d877.

#6 Updated by following almost 4 years ago

  • Status changed from erledigt to im Test
  • % Done changed from 100 to 90

#7 Updated by following almost 4 years ago

  • Status changed from im Test to erledigt
  • % Done changed from 90 to 100

Status geändert durch Changeset oc-server3|commit:54eac6927ff179fcb950b6d994d02c9e2382d877.

#8 Updated by following almost 4 years ago

  • Status changed from erledigt to im Test
  • % Done changed from 100 to 90

#9 Updated by following almost 4 years ago

  • Status changed from im Test to erledigt
  • % Done changed from 90 to 100

Status geändert durch Changeset oc-server3|commit:54eac6927ff179fcb950b6d994d02c9e2382d877.

#10 Updated by following almost 4 years ago

  • Status changed from erledigt to im Test
  • % Done changed from 100 to 90

#11 Updated by following over 3 years ago

  • Status changed from im Test to erledigt
  • % Done changed from 90 to 100

Also available in: Atom PDF