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 <[email protected]> > To: Amrit Pal <[email protected]> > Cc: Real mailing list TO MEMBESS <[email protected]> > 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 <[email protected]> >> To: Amrit Pal <[email protected]> >> Cc: Real mailing list TO MEMBESS <[email protected]> >> 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 <[email protected]> >>> To: Amrit Pal <[email protected]> >>> Cc: Real mailing list TO MEMBESS <[email protected]> >>> 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 <[email protected]> >>>> To: Amrit Pal <[email protected]>; Real mailing list TO MEMBESS >>>> <[email protected]> >>>> 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 | | [email protected] | >>>>> 741a49866ce8e2c75258e45260bcb792e9f94ebf | >>>>> 943151e8982076c970eef6f3db7f5bce91e32548 | 2010-11-10 13:04:36 | >>>>> 2010-11-10 13:04:36 | NULL | NULL | >>>>> 0042394543328e126473c212b145ace2ec760933 | NULL | pending | NULL >>>>> | 1 | >>>>> | 2 | amritpalpathak1 | | [email protected] | >>>>> a4e897157fef65cf94b257ccd0da6b9816c817e5 | >>>>> ec286e1dfceed448121142217736dd36d82dbfd5 | 2010-11-10 14:02:50 | >>>>> 2010-11-10 14:02:50 | NULL | NULL | >>>>> 296123f2bec2b69045fbfe20c1094ec90ca26a3d | NULL | pending | NULL >>>>> | 6 | >>>>> | 3 | amritpalpathakgne | | [email protected] | >>>>> 8a556b71abedc119767c7e7b64cba1a7ad5329bf | >>>>> c3c1d308cfb982d849a5afd803782c5b46638c73 | 2010-11-10 15:15:45 | >>>>> 2010-11-10 15:15:45 | NULL | NULL | >>>>> 67bcf6118c6b0e91780eac88e174015cc7769a67 | NULL | pending | NULL >>>>> | 1 | >>>>> | 4 | nannu | | [email protected] | >>>>> 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 >>>>> >>>>> >>>>> >>>>> >>>>> >>>> >>>> >>>> >>> >>> >>> >> >> >> > > >
_______________________________________________ Photos mailing list [email protected] http://lists.openstreetmap.org/listinfo/photos
