[OSM-Photos] How to Show the photos at Osv(localhost:3000)

John McKerrell john at mckerrell.net
Thu Nov 18 16:18:14 GMT 2010


Check the photos in the database, what does it say their statuses are?

On 18 Nov 2010, at 15:53, Amrit Pal wrote:

> I created 2 more account i.e.now total are 3.Uploaded photos by 1st account have been moderated by its own and also by other 2 accounts.Now it shows there is not any photos that need moderation or processing from all 3  accounts?
> Photos are geocoded. Still photos are not showing on the map?
> 
> 
> From: John McKerrell <john at mckerrell.net>
> To: Amrit Pal <amrit.pal27 at yahoo.com>
> Cc: Real mailing list TO MEMBESS <Photos at openstreetmap.org>
> Sent: Wed, November 17, 2010 2:02:33 PM
> Subject: Re: [OSM-Photos] How to create a account at Osv(localhost:3000)
> 
> All photos need to be moderated by 3 people so you'll need to create a few test accounts to do that. Then if it's geocoded it should show up on the map, if it's not geocoded it should show up on the left hand side of the map.
> 
> On 17 Nov 2010, at 15:23, Amrit Pal wrote:
> 
>> After uploading images,it shows "photos needs pushing to moderation".After selecting it,"push to moderation" and then it shows "push to moderation".Finally Marked  that images with "Safe" and preview size "Small" and "Save changes".
>>   Now there is not any images for processing and modreation.
>>   How moderated image would be possible to show on the Main page(localhost:3000).What are the further procedure to do that.?
>> 
>> Thanking you
>> 
>> 
>> From: John McKerrell <john at mckerrell.net>
>> To: Amrit Pal <amrit.pal27 at yahoo.com>
>> Cc: Real mailing list TO MEMBESS <photos at openstreetmap.org>
>> Sent: Sun, November 14, 2010 7:44:10 AM
>> Subject: Re: [OSM-Photos] How to create a account at Osv(localhost:3000)
>> 
>> ./script/tools/processor.rb
>> 
>> On 13 Nov 2010, at 09:56, Amrit Pal wrote:
>> 
>>> Well i created account and able to login.Upload the image and it show "File Uploaded"Now i want to show these images at Osv i.e. localhost:3000(obviously after processing)...
>>> Can you tell me how the images are processed OR i should change the status from backend
>>> Thanx 
>>> 
>>> From: John McKerrell <john at mckerrell.net>
>>> To: Amrit Pal <amrit.pal27 at yahoo.com>
>>> Cc: Real mailing list TO MEMBESS <Photos at openstreetmap.org>
>>> Sent: Sat, November 13, 2010 3:37:18 AM
>>> Subject: Re: [OSM-Photos] How to create a account at Osv(localhost:3000)
>>> 
>>> Your username is 'amritpalpathak' and your password is whatever you typed in originally, I can't tell you that as it gets encrypted in the database.
>>> 
>>> John
>>> 
>>> On 13 Nov 2010, at 04:37, Amrit Pal wrote:
>>> 
>>>> mysql> update users set state='active',activated_at=NOW(), activation_code=NULL WHERE id=1;
>>>> Query OK, 1 row affected (0.07 sec)
>>>> Rows matched: 1  Changed: 1  Warnings: 0
>>>> 
>>>>                 Now for login what would be My username and password?
>>>> 
>>>> 
>>>> 
>>>> From: John McKerrell <john at mckerrell.net>
>>>> To: Amrit Pal <amrit.pal27 at yahoo.com>; Real mailing list TO MEMBESS <photos at openstreetmap.org>
>>>> Sent: Fri, November 12, 2010 11:23:03 AM
>>>> Subject: Re: [OSM-Photos] How to create a account at Osv(localhost:3000)
>>>> 
>>>> I missed a comma, try this:
>>>> 
>>>> update users set state='active',activated_at=NOW(), activation_code=NULL WHERE id=1;
>>>> 
>>>> (comma was missing after the NOW() )
>>>> 
>>>> On 12 Nov 2010, at 16:16, Amrit Pal wrote:
>>>> 
>>>>> i did as you said as follow
>>>>> 
>>>>> mysql> use openstreetview_org_development;
>>>>> Reading table information for completion of table and column names
>>>>> You can turn off this feature to get a quicker startup with -A
>>>>> 
>>>>> Database changed
>>>>> SELECT * FROM users;
>>>>> +----+-------------------+------+---------------------------+------------------------------------------+------------------------------------------+---------------------+---------------------+----------------+---------------------------+------------------------------------------+--------------+---------+------------+--------------------+
>>>>> | id | login             | name | email                     | crypted_password                         | salt                                     | created_at          | updated_at          | remember_token | remember_token_expires_at | activation_code                          | activated_at | state   | deleted_at | default_license_id |
>>>>> +----+-------------------+------+---------------------------+------------------------------------------+------------------------------------------+---------------------+---------------------+----------------+---------------------------+------------------------------------------+--------------+---------+------------+--------------------+
>>>>> |  1 | amritpalpathak    |      | amrit.pal27 at yahoo.com     | 741a49866ce8e2c75258e45260bcb792e9f94ebf | 943151e8982076c970eef6f3db7f5bce91e32548 | 2010-11-10 13:04:36 | 2010-11-10 13:04:36 | NULL           | NULL                      | 0042394543328e126473c212b145ace2ec760933 | NULL         | pending | NULL       |                  1 |
>>>>> |  2 | amritpalpathak1   |      | palamrit76 at gmail.com      | a4e897157fef65cf94b257ccd0da6b9816c817e5 | ec286e1dfceed448121142217736dd36d82dbfd5 | 2010-11-10 14:02:50 | 2010-11-10 14:02:50 | NULL           | NULL                      | 296123f2bec2b69045fbfe20c1094ec90ca26a3d | NULL         | pending | NULL       |                  6 |
>>>>> |  3 | amritpalpathakgne |      | ginnygne at yahoo.com        | 8a556b71abedc119767c7e7b64cba1a7ad5329bf | c3c1d308cfb982d849a5afd803782c5b46638c73 | 2010-11-10 15:15:45 | 2010-11-10 15:15:45 | NULL           | NULL                      | 67bcf6118c6b0e91780eac88e174015cc7769a67 | NULL         | pending | NULL       |                  1 |
>>>>> |  4 | nannu             |      | amritpalpathak1 at gmail.com | 970f28d5beb335fef7fcd70f6e02527bc349c4f1 | ac4fdc1b6cdb0e5de0c432bdd1c338ee0af01ef8 | 2010-11-11 14:37:21 | 2010-11-11 14:37:21 | NULL           | NULL                      | e5332dcde6d384449eaaf01a150d64e1baa0c719 | NULL         | pending | NULL       |                  1 |
>>>>> +----+-------------------+------+---------------------------+------------------------------------------+------------------------------------------+---------------------+---------------------+----------------+---------------------------+------------------------------------------+--------------+---------+------------+--------------------+
>>>>> 4 rows in set (0.07 sec)
>>>>> 
>>>>> mysql> 
>>>>> 
>>>>>                                                                 Then   I selected login id 1 .and then issued following 
>>>>> 
>>>>> mysql> update users set state='active',activated_at=NOW() activation_code=NULL WHERE id=1;
>>>>> 
>>>>> 
>>>>>                                                  Here i got the following error message 
>>>>> 
>>>>>  ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'activation_code=NULL WHERE id=1' at line 1
>>>>> mysql> 
>>>>> 
>>>>> Help to resolve this.
>>>>> 
>>>>> Thanx 
>>>>> 
>>>>> 
>>>>> 
>>>>> 
>>>>> 
>>>> 
>>>> 
>>>> 
>>> 
>>> 
>>> 
>> 
>> 
>> 
> 
> 
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/photos/attachments/20101118/3f30d8bb/attachment-0001.html>


More information about the Photos mailing list