[Version 1.1] Google User Map

[Brandon7 Brandon]

I ran this SQL Query:

CREATE TABLE phpbb_geocode (
user_from varchar(100) collate utf8_bin NOT NULL default,
user_lat double NOT NULL default 0,
user_long double NOT NULL default 0,
code_expire int(11) unsigned NOT NULL default 0,
UNIQUE KEY user_from (user_from)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


MySQL said:

#1064 - 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 '
user_lat double NOT NULL default 0,
user_long double NOT NULL default 0,

Does anybody know how to fix this?


I tried to contact the Mod's Author, with no response.



Thanks,
Brandon

[stitch626]

Hi Brandon,
I don't know if you found a solution to this but I was messing with this mod, just testing it out and I ran into the same problem.

There seems to be a double quote missing on the 2nd line of code. Here is how it should be. Only took me a 1/2 hour this time to figure it out. I am getting better. The last time I tried debugging a SQL it took me 4 hours (not all in one sitting though)

Code: Select all

CREATE TABLE `phpbb_geocode` (
  `user_from` varchar(100) collate utf8_bin NOT NULL default '',
  `user_lat` double NOT NULL default '0',
  `user_long` double NOT NULL default '0',
  `code_expire` int(11) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

[cichlid]

is it possible instead of having locations that a user can enter a gps mark instead and mark this spot on the map

cheers

[yaboymartell]

is there a new demo site link?

[doylefish Jason]

Hey guys,

Does anyone have the install code for this?

The original links are no longer being hosted, and I cant see them anywhere.

Cheers

J

[NMI]

Download link in original post is broken.

[scouthostinguk]

download link is not working again

[Boomi21]

Thanks for share good info keep it up...........