| View previous topic :: View next topic |
| Author |
Message |
PSD1
Occasional Visitor
Joined: Nov 10, 2009
Posts: 5
|
 Posted: Wed Nov 11, 2009 10:36 am Post subject: Trouble Downloading Database |
 |
|
Hi All
I am trying to download the speed camera database (v7.111 04.09.09) from the download page.
I am a new user so haven't downloaded it before.
I am clicking on the "Download Same Format" button and I get the following error :
"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 ') AND include ='yes'' at line 1"
Do I need to state which version of satnav system I have and use that link to download the database ? If so this is going to be used on a Nissan Connect system, but I can't see that in the drop down list ?
Any help appreciated.
Thank you |
|
| Back to top |
|
 |
PaulB2005
Pocket GPS Moderator
Joined: Jan 04, 2006
Posts: 9323
Location: Durham, UK
|
| Posted: Wed Nov 11, 2009 10:43 am Post subject: |
|
|
Hi and welcome.
The Download Same Format button is designed to be used when you have already downloaded a copy so you don't have to go through the selection procedure each time.
According to the instructions here the Nissan Connect System used Other - CSV database.
So below that Download Same Format button select "Other - CSV" from the drop down list. Click Continue and then chose the database type you want. Again according to the instructions "Single File with all cameras" is the one you want. Next week you'll be able to repeat that by just clicking Download Same Format. |
|
| Back to top |
|
|
PSD1
Occasional Visitor
Joined: Nov 10, 2009
Posts: 5
|
| Posted: Wed Nov 11, 2009 10:57 am Post subject: |
|
|
Thank you for your prompt reply and explanation....seems to have done the trick...
Will give it a go...
Cheers... |
|
| Back to top |
|
|
M8TJT
The Other Tired Old Man
Joined: Apr 04, 2006
Posts: 10118
Location: Bexhill, South Sussex, UK
|
| Posted: Wed Nov 11, 2009 11:02 am Post subject: Re: Trouble Downloading Database |
|
|
| PSD1 wrote: |
I am clicking on the "Download Same Format" button and I get the following error :
"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 ') AND include ='yes'' at line 1" |
Not a very helpfull error message MaFt  |
|
| Back to top |
|
|
PSD1
Occasional Visitor
Joined: Nov 10, 2009
Posts: 5
|
| Posted: Wed Nov 11, 2009 11:15 am Post subject: |
|
|
Hi again, sorry, just one other quick question.
I have followed the instructions and placed file
pocketgps_uk_sc.csv in the following folder structure :
x:\myPOIs\myPOIWarnings
What about the .bmp file which the instrcutions say to download but not delete ? Does the file eventually go somewhere ?
As the instrcutions just state :
"Copy the .csv file downloaded in Step 1 into the myPOIWarnings folder on the mass storage device. "
But never mention the .bmp file ? I imagine it must go somewhere ?
Thank you |
|
| Back to top |
|
|
MaFt
Pocket GPS Staff
Joined: Aug 31, 2005
Posts: 15157
Location: Bradford, West Yorkshire
|
| Posted: Wed Nov 11, 2009 11:24 am Post subject: Re: Trouble Downloading Database |
|
|
| M8TJT wrote: | | PSD1 wrote: |
I am clicking on the "Download Same Format" button and I get the following error :
"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 ') AND include ='yes'' at line 1" |
Not a very helpfull error message MaFt |
indeed not, BUT the download same again button shouldn't show if the user hasn't downloaded anything before... i'll check the code later... |
|
| Back to top |
|
|
PSD1
Occasional Visitor
Joined: Nov 10, 2009
Posts: 5
|
| Posted: Wed Nov 11, 2009 11:47 am Post subject: |
|
|
Anyone have any idea about the .bmp file location ?
Ta |
|
| Back to top |
|
|
Darren
Frequent Visitor
Joined: 11/07/2002 14:36:40
Posts: 23848
Location: Hampshire, UK
|
| Posted: Wed Nov 11, 2009 12:14 pm Post subject: |
|
|
| PSD1 wrote: | Anyone have any idea about the .bmp file location ?
Ta |
I don't think the Nissan system uses the .bmp file. Try without, if not, copy to same folder as the .csv file?
_________________
Darren Griffin |
|
| Back to top |
|
|
M8TJT
The Other Tired Old Man
Joined: Apr 04, 2006
Posts: 10118
Location: Bexhill, South Sussex, UK
|
| Posted: Wed Nov 11, 2009 4:33 pm Post subject: Re: Trouble Downloading Database |
|
|
| MaFt wrote: | | M8TJT wrote: | | Not a very helpfull error message MaFt |
Indeed not, BUT the download same again button shouldn't show if the user hasn't downloaded anything before.. |
Ahhh, I see. All is forgiven then  |
|
| Back to top |
|
|
PSD1
Occasional Visitor
Joined: Nov 10, 2009
Posts: 5
|
| Posted: Wed Nov 11, 2009 6:15 pm Post subject: |
|
|
| Darren wrote: | | PSD1 wrote: | Anyone have any idea about the .bmp file location ?
Ta |
I don't think the Nissan system uses the .bmp file. Try without, if not, copy to same folder as the .csv file? |
Hi Darren, you are quite correct - I placed the bmp file in the same folder as the .csv file - uploaded the POI's to the Satnav unit, all were accepted without issue, however you don't see the speedcameras bmp on the map - just a warning notice appearing on the screen when you come up to a camera which shows the type and location of the camera.....
Thanks for all your help chaps.... |
|
| Back to top |
|
|
|
![]() Posted: Today Post subject: Pocket GPS Advertising |
|
|
We see you’re using an ad-blocker. We’re fine with that and won’t stop you visiting the site.
Have you considered making a donation towards website running costs?. Or you could disable your ad-blocker for this site. We think you’ll find our adverts are not overbearing!
|
|
| Back to top |
|
|
|
Forum FAQ
Search
Usergroups
Profile
Log in for private messages
Log in
