./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
