Home » Download » Modules » storefinder » Issues

Can't add more than one store, issue displaying even the one store, and no icons displayed

jnicola - October 29, 2008 - 06:57
Project:storefinder
Version:5.x-1.1
Component:Code
Category:support request
Priority:critical
Assigned:Unassigned
Status:active
Description

I receive this error when attempting to add a second store:

* warning: Missing argument 1 for storefinder_location_form() in /home/jnicola/mthoodsnowsports.com/drupal/sites/all/modules/storefinder/storefinder_build_ui.inc on line 44.
* user warning: Duplicate entry '0' for key 1 query: insert into storefinder (sname, address, city, state, zip, country, phone, http, lat, lon)values('asdfasdfasdf', 'asdfsd', 'asdfasdf', 'asdfsdfa', '97201', 'USA', '', '', '0', '0'); in /home/jnicola/mthoodsnowsports.com/drupal/includes/database.mysql.inc on line 172.

I receive this error when attempting to display even one store:

* user warning: Unknown column 'distance' in 'having clause' query: SELECT COUNT(*) FROM storefinder HAVING distance < '25' in /home/jnicola/mthoodsnowsports.com/drupal/includes/database.mysql.inc on line 172.
* user warning: Unknown column 'distance' in 'having clause' query: SELECT COUNT(*) FROM storefinder HAVING distance < '25' in /home/jnicola/mthoodsnowsports.com/drupal/includes/database.mysql.inc on line 172.

(Check it out here: http://www.mthoodsnowsports.com/drupal/locations/ )

I also have the following issue display the result(s):

No markers are shown. This means that I can't click on them either.

I am running the latest version of drupal, I have php5, I am on dreamhost. Any advice?

» Login or register to post comments

#1

duncanbeevers - October 31, 2008 - 17:24
Component:User interface» Code
Category:bug report» support request

I have implemented fixes for a number of errors and would like to be added as a contributor to this project so I may commit them back to the canonical version of the module.

Fixes include:

  • install script creates sid column as auto_increment to avoid duplicate key errors inserting more than one storefinder location
  • form for creating a new storefinder location has default value for optional variable, suppressing warning message
  • image links for markers and edit/delete links for storefinder locations take drupal base_path into account when generating paths
  • generated javascript does proper JSON escaping preventing errors when displaying results containing certain characters, such as single quotes
  • generated markup escapes html entities preventing errors when displaying results containing certain characters, such as a less-than.
  • results pagination query specifies count sql explicitly, fixing error where total results count query failed due to referencing unavailable column alias
  • perform results lookup only once, use result set resource to populate javascript markers, then reset to display search results table
Login or register to post comments

#2

thompsono - August 25, 2009 - 12:34

Hi All,

Please rename the attached file to storefinder_build_ui.inc, and copy and paste the file to sites/all/modules/storefinder or where ever you have the module installed. This fixes the majority of issues posted on this module.
I like this module, i think its alot cleaner than the PHP Google store locator module, but it does have fewer features, i have both working on different websties.

Kind regards

OT

AttachmentSize
storefinder_build_ui.txt 7.09 KB
Login or register to post comments
 
 

Drupal is a registered trademark of Dries Buytaert.