[OSM-Photos] How to create a account at Osv(localhost:3000)

[Amrit Pal]

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/20101117/2f670f18/attachment.html>