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?

CommentFileSizeAuthor
#2 storefinder_build_ui.txt7.09 KBthompsono

Comments

duncanbeevers’s picture

duncanbeevers commented
Component: User interface » Code
Category: bug » support

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
thompsono’s picture

thompsono commented
StatusFileSize
new storefinder_build_ui.txt7.09 KB

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