bugGNU FM - Bugs: bug #26759, Geoname fail in profile editing...

 
 

bug #26759: Geoname fail in profile editing page

Submitted by:  None
Submitted on:  Mon 08 Jun 2009 09:31:12 PM UTC  
 
Category: nixtape/alphaSeverity: 3 - Normal
Item Group: UIStatus: Fixed
Privacy: PublicAssigned to: None
Open/Closed: Closed

Add a New Comment(Rich Markup)
   

You are not logged in

Please log in, so followups can be emailed to you.

 

Thu 11 Jun 2009 06:26:50 PM UTC, comment #3:

finally!

Nicolas Reynolds <fauno>
Project Member
Wed 10 Jun 2009 12:35:06 AM UTC, comment #2:

should be done in revision #1749

Nicolas Reynolds <fauno>
Project Member
Tue 09 Jun 2009 11:54:57 PM UTC, comment #1:

error happens because float separator is a comma, like the sql field separator.

Nicolas Reynolds <fauno>
Project Member
Mon 08 Jun 2009 09:31:12 PM UTC, original submission:

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

Anonymous

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach File(s):
   
   
Comment:
   

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -unavailable- added by fauno (Posted a comment)
  •  

    Do you think this task is very important?
    If so, you can click here to add your encouragement to it.
    This task has 0 encouragements so far.

    Only logged-in users can vote.

     

    Please enter the title of George Orwell's famous dystopian book (it's a date):

     

     

    Follow 5 latest changes.

    Date Changed By Updated Field Previous Value => Replaced By
    Thu 11 Jun 2009 06:26:50 PM UTCfaunoStatusConfirmed=>Fixed
      Open/ClosedOpen=>Closed
    Tue 09 Jun 2009 11:54:57 PM UTCfaunoCategoryNone=>nixtape/alpha
      Item GroupNone=>UI
      StatusNone=>Confirmed

    Back to the top


    Powered by Savane 3.1-cleanup1