[Librefm-bugs] [bug #26759] Geoname fail in profile editing page

[anonymous]

URL:
  <http://savannah.nongnu.org/bugs/?26759>

                 Summary: Geoname fail in profile editing page
                 Project: libre.fm
            Submitted by: None
            Submitted on: Mon 08 Jun 2009 09:31:12 PM UTC
                Category: None
                Severity: 3 - Normal
              Item Group: None
                  Status: None
                 Privacy: Public
             Assigned to: None
             Open/Closed: Open
         Discussion Lock: Any

    _______________________________________________________

Details:

Error type: PHP error (linked to databases).

How to reproduce:
When I get to the profile editing page and click ("Find...") next to
"geoname" it finds well my location (nearby, to be exact): "Oświęcim,
Silesian Voivodeship, Poland [50.03;19.23]"

Then the green link is appended below that button ("Find..."):
http://sws.geonames.org/3089658/

Then I click "Change" below the whole form, the page refreshes and error
occures:

Fatal error: Uncaught exception 'ADODB_Exception' with message 'postgres7
error: [-1: ERROR: INSERT has more expressions than target columns] in
EXECUTE("INSERT INTO Places VALUES ('http://sws.geonames.org/3089658/',
50,033333, 19,233333, 'PL')") ' in
/usr/share/php/adodb/adodb-exceptions.inc.php:78 Stack trace: #0
/usr/share/php/adodb/adodb.inc.php(1036): adodb_throw('postgres7', 'EXECUTE',
-1, 'ERROR: INSERT ...', 'INSERT INTO Pla...', false, Object(ADODB_postgres7))
#1 /usr/share/php/adodb/adodb.inc.php(1011): ADOConnection->_Execute('INSERT
INTO Pla...', false) #2
/home/librefm/websites/live/stable/nixtape/data/Server.php(385):
ADOConnection->Execute('INSERT INTO Pla...') #3
/home/librefm/websites/live/stable/nixtape/data/User.php(113):
Server::getLocationDetails('http://sws.geon...') #4
/home/librefm/websites/live/stable/nixtape/user-edit.php(121): User->save() #5
{main} thrown in /usr/share/php/adodb/adodb-exceptions.inc.php on line 78




    _______________________________________________________

Reply to this item at:

  <http://savannah.nongnu.org/bugs/?26759>

_______________________________________________
  Message sent via/by Savannah
  http://savannah.nongnu.org/