Zip Code upgrades
I had to take off the last ); for the zip codes to install correctly.
Also Problem for those in New Englnd
Zip codes start with
02354 for example
A user enters it in & the tables only see it as
2345 & reads no zip code was entered.
Try changing line 334 in showcat.php to:
$query = "SELECT lon,lat FROM zipData WHERE zipcode = '".addslashes($zipcode)."'";
Sorry line 415 is an image query on mine
Did you mean
$query = "SELECT lon,lat FROM zipData WHERE zipcode = '".intval($prodzipcode)."'";
That didn't work same thing is happening.
hmmmm.... I ran a test (without the change above); and its saving the zipcode properly:
Why do you think its not finding the zip code or removing the leading zero?
I made a slight change to the line above, different line number; although it will have no effect, but should be done anyways.
Did you try it on the creation of an ad?
It will works fine if a user sees an ad
But it doesn't work when the person posting the zip ad has a zip code that starts with 0.
No, but you didn't say anything about creating an ad in your first post, so I wasn't looking there. I "guessed" you meant as a user on the showcat page.
Sorry still going through getting familiar with the software only had it for a few days.
line 259 in uploadproduct.php change intval to addslashes.
My Product tables in mysql just aren't holding any zip codes that start with 0
On the install the structure was
zipcode INT(5) default '0'
On the Zipcode tables the row is
(zipcode varchar(5) NOT NULL default '',
Should they be the same
When I edit an existing product with a zip code that starts with 0 it doesn't hold.
Wen I enter in a new product it doesn't hold.
If I enter in 03245
It just has 3245 in the zipcode row in the Product table.
I tried to enter it manually & it didn't work.
We'll have to change the data type to a varchar:
ALTER TABLE products CHANGE zipcode zipcode VARCHAR( 5 ) ;
|All times are GMT -5. The time now is 03:15 AM.|
Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0