<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:12pt"><div>Well i installed the osv at localhost and it is working well.But still the problem(Onclick of image) is there.I am unable to change the file(OSVMain.js).Perhaps i couldn't understood the code of (OSV/OpenStreetView/public/javascripts) OSVMain.js file well.But i have made a html file that accepts the number of thumnails when page loads and click on any thumnail show the full resolution of the same and vice versa.It is a simple html file and doesn't interact with osv'source code in any way.I think you wisdom peoples must see the code ,may be it would helpful.I have posted all the stuff related to osv at my blog .Please check out.<br><br><span><a target="_blank"
href="http://amritpalpathakgne.wordpress.com/2010/11/21/openstreetview/">http://amritpalpathakgne.wordpress.com/2010/11/21/openstreetview/</a></span><br><br>Thanks <br></div><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><font face="Tahoma" size="2"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> John McKerrell <john@mckerrell.net><br><b><span style="font-weight: bold;">To:</span></b> Amrit Pal <amrit.pal27@yahoo.com><br><b><span style="font-weight: bold;">Cc:</span></b> Real mailing list TO MEMBESS <photos@openstreetmap.org><br><b><span style="font-weight: bold;">Sent:</span></b> Thu, November 18, 2010 9:48:14 PM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: [OSM-Photos] How to Show the photos at Osv(localhost:3000)<br></font><br>
<base>Check the photos in the database, what does it say their statuses are?<div><br><div><div>On 18 Nov 2010, at 15:53, Amrit Pal wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; font-size: medium;"><div><div style="margin: 0px; font-family: times,serif; font-size: 12pt;">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?<br>Photos are geocoded. Still photos are not showing on the map?<br><div style="margin: 0px;"><br></div><div style="margin: 0px;
font-family: times,serif; font-size: 12pt;"><br><div style="margin: 0px; font-family: times,serif; font-size: 12pt;"><font face="Tahoma" size="2"><hr size="1"><b><span style="font-weight: bold;">From:</span></b><span class="Apple-converted-space"> </span>John McKerrell <<a rel="nofollow" ymailto="mailto:john@mckerrell.net" target="_blank" href="mailto:john@mckerrell.net">john@mckerrell.net</a>><br><b><span style="font-weight: bold;">To:</span></b><span class="Apple-converted-space"> </span>Amrit Pal <<a rel="nofollow" ymailto="mailto:amrit.pal27@yahoo.com" target="_blank" href="mailto:amrit.pal27@yahoo.com">amrit.pal27@yahoo.com</a>><br><b><span style="font-weight: bold;">Cc:</span></b><span class="Apple-converted-space"> </span>Real mailing list TO MEMBESS <<a rel="nofollow" ymailto="mailto:Photos@openstreetmap.org" target="_blank" href="mailto:Photos@openstreetmap.org">Photos@openstreetmap.org</a>><br><b><span
style="font-weight: bold;">Sent:</span></b><span class="Apple-converted-space"> </span>Wed, November 17, 2010 2:02:33 PM<br><b><span style="font-weight: bold;">Subject:</span></b><span class="Apple-converted-space"> </span>Re: [OSM-Photos] How to create a account at Osv(localhost:3000)<br></font><br>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.<div style="margin: 0px;"><br><div style="margin: 0px;"><div style="margin: 0px;">On 17 Nov 2010, at 15:23, Amrit Pal wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px;
text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; font-size: medium;"><div style="margin: 0px;"><div style="margin: 0px; font-family: times,serif; font-size: 12pt;">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".<br> Now there is not any images for processing and modreation.<br> How moderated image would be possible to show on the Main page(localhost:3000).What are the further procedure to do that.?<br><br>Thanking you<br><div style="margin: 0px;"><br></div><div style="margin: 0px; font-family: times,serif; font-size: 12pt;"><br><div style="margin: 0px; font-family: times,serif; font-size: 12pt;"><font face="Tahoma" size="2"><hr size="1"><b><span style="font-weight: bold;">From:</span></b><span
class="Apple-converted-space"> </span>John McKerrell <<a rel="nofollow" ymailto="mailto:john@mckerrell.net" target="_blank" href="mailto:john@mckerrell.net">john@mckerrell.net</a>><br><b><span style="font-weight: bold;">To:</span></b><span class="Apple-converted-space"> </span>Amrit Pal <<a rel="nofollow" ymailto="mailto:amrit.pal27@yahoo.com" target="_blank" href="mailto:amrit.pal27@yahoo.com">amrit.pal27@yahoo.com</a>><br><b><span style="font-weight: bold;">Cc:</span></b><span class="Apple-converted-space"> </span>Real mailing list TO MEMBESS <<a rel="nofollow" ymailto="mailto:photos@openstreetmap.org" target="_blank" href="mailto:photos@openstreetmap.org">photos@openstreetmap.org</a>><br><b><span style="font-weight: bold;">Sent:</span></b><span class="Apple-converted-space"> </span>Sun, November 14, 2010 7:44:10 AM<br><b><span style="font-weight: bold;">Subject:</span></b><span
class="Apple-converted-space"> </span>Re: [OSM-Photos] How to create a account at Osv(localhost:3000)<br></font><br><span class="Apple-style-span" style="font-family: monospace;">./script/tools/processor.rb</span><div style="margin: 0px;"><font class="Apple-style-span" face="monospace"><br></font><div style="margin: 0px;"><div style="margin: 0px;">On 13 Nov 2010, at 09:56, Amrit Pal wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; font-size: medium;"><div style="margin: 0px;"><div style="margin: 0px; font-family: times,serif; font-size: 12pt;"><div style="margin: 0px;">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)...<br>Can you tell me how the images are processed OR i should change the status from backend<br>Thanx<span class="Apple-converted-space"> </span><br></div><div style="margin: 0px; font-family: times,serif; font-size: 12pt;"><br><div style="margin: 0px; font-family: times,serif; font-size: 12pt;"><font face="Tahoma" size="2"><hr size="1"><b><span style="font-weight: bold;">From:</span></b><span class="Apple-converted-space"> </span>John McKerrell <<a rel="nofollow" ymailto="mailto:john@mckerrell.net" target="_blank" href="mailto:john@mckerrell.net">john@mckerrell.net</a>><br><b><span style="font-weight: bold;">To:</span></b><span class="Apple-converted-space"> </span>Amrit Pal <<a rel="nofollow" ymailto="mailto:amrit.pal27@yahoo.com" target="_blank"
href="mailto:amrit.pal27@yahoo.com">amrit.pal27@yahoo.com</a>><br><b><span style="font-weight: bold;">Cc:</span></b><span class="Apple-converted-space"> </span>Real mailing list TO MEMBESS <<a rel="nofollow" ymailto="mailto:Photos@openstreetmap.org" target="_blank" href="mailto:Photos@openstreetmap.org">Photos@openstreetmap.org</a>><br><b><span style="font-weight: bold;">Sent:</span></b><span class="Apple-converted-space"> </span>Sat, November 13, 2010 3:37:18 AM<br><b><span style="font-weight: bold;">Subject:</span></b><span class="Apple-converted-space"> </span>Re: [OSM-Photos] How to create a account at Osv(localhost:3000)<br></font><br>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.<div style="margin: 0px;"><br></div><div style="margin: 0px;">John</div><div style="margin: 0px;"><br><div style="margin: 0px;"><div style="margin:
0px;">On 13 Nov 2010, at 04:37, Amrit Pal wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; font-size: medium;"><div style="margin: 0px;"><div style="margin: 0px; font-family: times,serif; font-size: 12pt;">mysql> update users set state='active',activated_at=NOW(), activation_code=NULL WHERE id=1;<br>Query OK, 1 row affected (0.07 sec)<br>Rows matched: 1 Changed: 1 Warnings: 0<br><br> Now for login what would be My username and password?<br><br><br><div style="margin: 0px; font-family: times,serif; font-size: 12pt;"><br><div
style="margin: 0px; font-family: times,serif; font-size: 12pt;"><font face="Tahoma" size="2"><hr size="1"><b><span style="font-weight: bold;">From:</span></b><span class="Apple-converted-space"> </span>John McKerrell <<a rel="nofollow" ymailto="mailto:john@mckerrell.net" target="_blank" href="mailto:john@mckerrell.net">john@mckerrell.net</a>><br><b><span style="font-weight: bold;">To:</span></b><span class="Apple-converted-space"> </span>Amrit Pal <<a rel="nofollow" ymailto="mailto:amrit.pal27@yahoo.com" target="_blank" href="mailto:amrit.pal27@yahoo.com">amrit.pal27@yahoo.com</a>>; Real mailing list TO MEMBESS <<a rel="nofollow" ymailto="mailto:photos@openstreetmap.org" target="_blank" href="mailto:photos@openstreetmap.org">photos@openstreetmap.org</a>><br><b><span style="font-weight: bold;">Sent:</span></b><span class="Apple-converted-space"> </span>Fri, November 12, 2010 11:23:03 AM<br><b><span style="font-weight:
bold;">Subject:</span></b><span class="Apple-converted-space"> </span>Re: [OSM-Photos] How to create a account at Osv(localhost:3000)<br></font><br>I missed a comma, try this:<div style="margin: 0px;"><br></div><div style="margin: 0px;"><span class="Apple-style-span" style="font-family: times,serif; font-size: 16px;">update users set state='active',activated_at=NOW(), activation_code=NULL WHERE id=1;</span></div><div style="margin: 0px;"><font class="Apple-style-span" face="'times new roman', 'new york', times, serif" size="4"><span class="Apple-style-span" style="font-size: 16px;"><br></span></font></div><div style="margin: 0px;"><font class="Apple-style-span" face="'times new roman', 'new york', times,
serif" size="4"><span class="Apple-style-span" style="font-size: 16px;">(comma was missing after the NOW() )</span></font></div><div style="margin: 0px;"><font class="Apple-style-span" face="'times new roman', 'new york', times, serif" size="4"><span class="Apple-style-span" style="font-size: 16px;"><br></span></font><div style="margin: 0px;"><div style="margin: 0px;">On 12 Nov 2010, at 16:16, Amrit Pal wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; font-size: medium;"><div style="margin: 0px;"><div style="margin: 0px; font-family: times,serif; font-size: 12pt;">i did as you said as follow<br><br>mysql> use
openstreetview_org_development;<br>Reading table information for completion of table and column names<br>You can turn off this feature to get a quicker startup with -A<br><br>Database changed<br>SELECT * FROM users;<br>+----+-------------------+------+---------------------------+------------------------------------------+------------------------------------------+---------------------+---------------------+----------------+---------------------------+------------------------------------------+--------------+---------+------------+--------------------+<br>| 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
|<br>+----+-------------------+------+---------------------------+------------------------------------------+------------------------------------------+---------------------+---------------------+----------------+---------------------------+------------------------------------------+--------------+---------+------------+--------------------+<br>| 1 | amritpalpathak | |<span class="Apple-converted-space"> </span><a rel="nofollow" ymailto="mailto:amrit.pal27@yahoo.com" target="_blank" href="mailto:amrit.pal27@yahoo.com">amrit.pal27@yahoo.com</a> | 741a49866ce8e2c75258e45260bcb792e9f94ebf | 943151e8982076c970eef6f3db7f5bce91e32548 | 2010-11-10 13:04:36 | 2010-11-10 13:04:36 | NULL | NULL |
0042394543328e126473c212b145ace2ec760933 | NULL | pending | NULL | 1 |<br>| 2 | amritpalpathak1 | |<span class="Apple-converted-space"> </span><a rel="nofollow" ymailto="mailto:palamrit76@gmail.com" target="_blank" href="mailto:palamrit76@gmail.com">palamrit76@gmail.com</a> | a4e897157fef65cf94b257ccd0da6b9816c817e5 | ec286e1dfceed448121142217736dd36d82dbfd5 | 2010-11-10 14:02:50 | 2010-11-10 14:02:50 | NULL | NULL | 296123f2bec2b69045fbfe20c1094ec90ca26a3d |
NULL | pending | NULL | 6 |<br>| 3 | amritpalpathakgne | |<span class="Apple-converted-space"> </span><a rel="nofollow" ymailto="mailto:ginnygne@yahoo.com" target="_blank" href="mailto:ginnygne@yahoo.com">ginnygne@yahoo.com</a> | 8a556b71abedc119767c7e7b64cba1a7ad5329bf | c3c1d308cfb982d849a5afd803782c5b46638c73 | 2010-11-10 15:15:45 | 2010-11-10 15:15:45 | NULL | NULL | 67bcf6118c6b0e91780eac88e174015cc7769a67 | NULL | pending |
NULL | 1 |<br>| 4 | nannu | |<span class="Apple-converted-space"> </span><a rel="nofollow" ymailto="mailto:amritpalpathak1@gmail.com" target="_blank" href="mailto:amritpalpathak1@gmail.com">amritpalpathak1@gmail.com</a><span class="Apple-converted-space"> </span>| 970f28d5beb335fef7fcd70f6e02527bc349c4f1 | ac4fdc1b6cdb0e5de0c432bdd1c338ee0af01ef8 | 2010-11-11 14:37:21 | 2010-11-11 14:37:21 | NULL | NULL | e5332dcde6d384449eaaf01a150d64e1baa0c719 | NULL | pending |
NULL | 1 |<br>+----+-------------------+------+---------------------------+------------------------------------------+------------------------------------------+---------------------+---------------------+----------------+---------------------------+------------------------------------------+--------------+---------+------------+--------------------+<br>4 rows in set (0.07 sec)<br><br>mysql><span class="Apple-converted-space"> </span><br><br> Then I selected login id 1 .and then issued following<span
class="Apple-converted-space"> </span><br><br>mysql> update users set state='active',activated_at=NOW() activation_code=NULL WHERE id=1;<br><br><br> Here i got the following error message<span class="Apple-converted-space"> </span><br><br> 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<br>mysql><span class="Apple-converted-space"> </span><br><br>Help to resolve this.<br><br>Thanx<span class="Apple-converted-space"> </span><br><br><br><br></div><br></div></span><br
class="Apple-interchange-newline"></blockquote></div><br></div></div></div></div><br></div></span><br class="Apple-interchange-newline"></blockquote></div><br></div></div></div></div><br></div></span><br class="Apple-interchange-newline"></blockquote></div><br></div></div></div></div><br></div></span><br class="Apple-interchange-newline"></blockquote></div><br></div></div></div></div><br></div></span><br class="Apple-interchange-newline"></blockquote></div><br></div></div></div>
</div><br>
</body></html>