XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Modules Support forums / 
  3. Module troubleshooting 
  4.  / Google Maps 0.5
Register
1
khuhner
Google Maps 0.5

  • 2006/8/2 2:20

  • khuhner

  • Quite a regular

  • Posts: 232

  • Since: 2006/1/6 3


Marco:

Thanks for the updated module!

However, I'm still getting the same error from 0.4:

Error Code: 0013

ERROR: Could not query the database. 
Error: Out of range value adjusted for column 'map_id' at row 1

[ Go Back ]


I also noticed this when adding a category:

Error Code: 0013


ERROR: Could not query the database. 
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 ' '1', '1')' at line 1


Kurt
2
Marco
Re: Google Maps 0.5

  • 2006/8/2 4:59

  • Marco

  • Home away from home

  • Posts: 1256

  • Since: 2004/3/15


hello,

well, i don't have done much, but i'm now making many improvments on this module, adding new features and rewriting some parts.

Could you give me your environment : XOOPS version, php version, MySQL version
thanks
marco
Do synergy or die.
3
simon132
Re: Google Maps 0.5

  • 2006/8/2 11:41

  • simon132

  • Just popping in

  • Posts: 48

  • Since: 2003/11/19


Marco,

While you are tinkering with this module could you look at adding a scale, a la standard Google maps.

My wish list:

1. Ability to add data to the DB and fields to collect such as lat/long and other geo information.

2. integration with other modules such as news or piCal would be great.
4
khuhner
Re: Google Maps 0.5

  • 2006/8/7 21:40

  • khuhner

  • Quite a regular

  • Posts: 232

  • Since: 2006/1/6 3


Quote:

khuhner wrote:
Marco:

Thanks for the updated module!

However, I'm still getting the same error from 0.4:

[code]
Error Code: 0013

ERROR: Could not query the database.
Error: Out of range value adjusted for column 'map_id' at row 1

[ Go Back ]

Kurt


Still getting this issue with 0.7b. I'd really like to use this module, but catn get past this error.

Kurt
5
Marco
Re: Google Maps 0.5

  • 2006/8/7 21:42

  • Marco

  • Home away from home

  • Posts: 1256

  • Since: 2004/3/15


@ khuhner

as asked before, could you give me your environment (xoops version, MySQL version, php version)
thanks
Do synergy or die.
6
khuhner
Re: Google Maps 0.5

  • 2006/8/8 0:58

  • khuhner

  • Quite a regular

  • Posts: 232

  • Since: 2006/1/6 3


Apologies:

Xoops 2.0.13.2
mySql 4.1.19
PHP 4.4.2

Regards,
Kurt
7
Marco
Re: Google Maps 0.5

  • 2006/8/8 7:44

  • Marco

  • Home away from home

  • Posts: 1256

  • Since: 2004/3/15


hello khuhner,

i've made some fixes, could you install that new version and confirm it's bug free for you
googlemaps (fix for some MySQL errors)

thanks
marco
Do synergy or die.
8
khuhner
Re: Google Maps 0.5

  • 2006/8/9 3:01

  • khuhner

  • Quite a regular

  • Posts: 232

  • Since: 2006/1/6 3


Marco-

Looks like the original problem of creating a category is fixed thanks!

Now when adding a point I get:

Error Code: 0013

ERROR: Could not query the database. 
Error: Out of range value adjusted for column 'id' at row 1


[ Go Back ]

Fatal error: Call to undefined function themefooter() in c:Inetpubwwwroothtmlfooter.php on line 43
Notice [PHP]: Undefined variable: error in file c:Inetpubwwwroothtmlmodulesgooglemapsmanagepoint.php line 190
Notice [PHP]: Undefined variable: xoopsOption in file c:Inetpubwwwroothtmlfooter.php line 33
Notice [PHP]: Undefined variable: xoopsConfigMetaFooter in file c:Inetpubwwwroothtmlfooter.php line 35


Suggestions?

Kurt
9
Marco
Re: Google Maps 0.5

  • 2006/8/9 7:46

  • Marco

  • Home away from home

  • Posts: 1256

  • Since: 2004/3/15


khuhner

thanks for your confirmation, this has fixed our problem. i was waiting for it to go further.
here comes a more global solution, for add point, add category, add polyline.
please check from admin side and user side, should be ok now.
download link is on my website

Quote:

Notice [PHP]: Undefined variable: error in file c:\Inetpub\wwwroot\html\modules\googlemaps\managepoint.php line 190

after having applied the above code, could you confirm/infirm me this last one ?


thanks
marco
Do synergy or die.
10
khuhner
Re: Google Maps 0.5

  • 2006/8/9 21:47

  • khuhner

  • Quite a regular

  • Posts: 232

  • Since: 2006/1/6 3


Thanks Marco!

Tested 0.7e.

The adding points problem is fixed.

A couple of things I noted:

When viewing a 'point', the map isnt zoomed to the level specified when the point was created. Is that by design?

When creating the first category, why do I need to enter a zoom factor?

After adding one point, end-user is unable to add additional points?

Can the description be optional?

The directions fails with the error:
Quote:

We could not understand the location point.lat(),point.ln()


Looks like you are sending "point.lat(),point.lng()" as the location from the map.



Thanks for speedy turnaround on the fixes...it is very appreciated!

Kurt
(1) 2 »

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

335 user(s) are online (292 user(s) are browsing Support Forums)

Members: 0

Guests: 335

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits