Is the cpnav_vbgooglemap.xml available in the includes/xml????

Hmm...I'm having the same problem and I verified that all the files are uploaded and chmod'd correctly. As well as installed the product.

For whatever reason, they were missing on the server end even though I transferred everything at once. I uninstalled the hack and was going to reinstall it allowing it to overwrite and now I get:

Database error in vBulletin 3.5.4:

Invalid SQL:
ALTER TABLE vb_usergroup ADD showonvbgme int(10) unsigned NOT NULL;

MySQL Error : Duplicate column name 'showonvbgme'
Error Number : 1060
Date : Sunday, May 14th 2006 @ 12:32:29 PM
Script : http://xxx/forum/admincp/plugin.php
Referrer : http://xxx/forum/admincp/plugin.php?do=productadd
IP Address : xxx
Username : JD45
Classname : vb_database

When attempting to install with either setting of overwrite or not.


Update: I edited the .xml file and took out that one line and it installed. Still no admincp setting anywhere though.

You can drop the field via phpmyadmin safely.

I'm looking into it.

In some cases the cpnav doesn't seem to show.

Alrighty. Thanks for taking a look and supporting your hack. Truly apprecaited mate :)

Uploading a fix now. .....


Ok for those that have problems with the adminpages not showing in the admincp.

Please download the version now online and overwrite the cpnav_vbgooglemap.xml

I've included a temp workaround so that you're able to run this version.

for a bitfield rebuild index.php?do=buildbitfields

I checked the source code and it's looking here
I looked in my /bbs/images/googlemapme folder and there IS a file called mm_20_blue.png but they still aren't showing in the legend. Can you see any other problem with that link?

worked like a charm! Thanks again for the quick fix..:D

I tried to register but there is an error

The following errors occurred during your registration:
A required field called How did you hear about LGK? is missing or has an invalid value.

But the field isn't shown on the registration.

Please get me an account so I can see for myself.

The link it shows isn't normal

Oh wait, I just fired up Mozilla Firefox and it shows the pegs. It just doesn't work with MS IE 7.0 for some reason.

I understand but if you want me to help the least you could get me is access so that I can see the map.

It's working fine in IE7 for me.

For me too but he seems to have some custom code running on images.

It's tested on the major browsers on pc platform.

Hi

I am getting this SQL error in my inbox:

Yes, I uninstalled the previous version before installing the new one. As per your instructions.

In the db i see the following tables.

googlemapme
googlemapme_settings

And they seem to have the correct data.

There is no query that uses those fields in version 2.5.0

are you sure you removed everything from the old version.

It seems to be a call to an old query

Kompakt can you please post a link or pm it to me

Preferably with an account I can use to test

ah, I'm getting an sql error now as well:

are there old tables I should manually drop?

I think I know what this is

You haven't completed step 7 or 8 of the installation.

It's the findme plugin in the postbit that is causing this.

Or disable the plugin
Or add the post[findme] to the postbit

I found an old googlemap table, and I dropped that, but still no difference. Thanks for checking again..

JD,

just download the product again.

I changed the plugin with an error check so that it first looks if it knows the userid.

I also removed the duplicate entry for the usergroup table.

Product with overwrite to yes should fix the issue.

I just downloaded, and reinstalled the plugin with overwrite and:

took out that one line of the installer and perfecto..:)

Thanks again for all your assistance..:)

Well yiehaa,

Slap me on the head for including the wrong product/installer xml in the zip :confused: :confused: :confused:


That error should be gone

New problem

If a user clicks on some older threads they get the following. It's weird as it only happens on some threads

Quote:

Invalid SQL: SELECT userid,lat_map,username,lng_map FROM vb_googlemapme WHERE userid =; MySQL 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 '' at line 1 Error Number : 1064 Date : Sunday, May 14th 2006 @ 07:37:12 PM Script : http://www.xxxxxxxxx.com/interactive/showthread.php?t=2172 Referrer : http://www.xxxxxxxxx.com/interactive/forumdisplay.php?f=30

EDIT ... just noticed the post above *goes off to fix*

looks nice but i have a Problem...

Look
http://www.hilfe-forum.eu/vbgooglemapme.php


Loaded: 12 of 170
Loaded: 13 of 170
Loaded: 14 of 170
Loaded: 15 of 170
Loaded: 12 of 170
Loaded: 13 of 170
Loaded: 14 of 170
Loaded: 15 of 170
Loaded: 12 of 170
Loaded: 13 of 170
Loaded: 14 of 170
Loaded: 15 of 170
......


and...

Page generated in 0,67374 seconds with 349! queries ???

I don't have access to the page

I'm registered as normal user. Can you please allow normal users to see

For some reason he seems to count the javascript parsings and counters as queries. If you look at the total exectution time the number of queries just cannot be right.

Thanks, its working great now :cool:

It's the dynamic creation of the xml file that is causing these number of queries.

That has always been the case.

I'm working on a smart cache solution but that will remove the "user is online" function.

OK, just redownloaded & reinstalled the product again & getting same error like JD45..

I think this is another error.

It means one of the alter tables has failed for some reason in the installation.

I'm testing the install on a clean version of vb again

/edit

On both my testservers I cannot simulate the error.

Please make sure you have the version currently online. Uninstall the product completely and reinstall. It should create the missing field it's looking for.

removed the product & reinstalled in again! now its working. kinda wired :/

I've been plagued by weird voodoo tonight.

The number of queries is bothering me a lot. I need to find a way so I don't have to recreate the xml so often.

Install went OK, one small hiccup not in documentation was altering the usergroup icon colour, easily sorted and all looking good. thanks Stonyarc

Thanks gizmo hope you like it.

The next version will focus on performance and clearing up the number of queries in the xml generation.

What sort of load is that likely to put on the server?

My host has already complained about my excessive SQL usage in the past.

Well it's because of the major difference between client side and server side processing.

The googlemap API requires you to create xml file which is processed client side by the scripts.

You can fake some stuff by setting it with php but bottomline remains the same.

Point is that currently onload of the map the xml-file is created or onchange of data.

To create a line in the xml file I need a query. If you have a whole lot of users that means a lot of queries.

That's what I'm working on. It's not so much a programming error but more a behaviour by design from the googlemap itself.

Google also says it that it's not build for 250+ but I have seen forums that are running my app 600+ and more. I keep tweaking the code javascript and php to make it as performant as possible and I am working on a more permanent solution with smart caching.

I already created part of those scripts for the xbox live integration I made for my site xboxusersgroup.com.

anyone else got the problem where even though the usergroup option edit own marker is set to yes that the usergroup can't edit it unless edit markers option is on..which negates users markers security as anyone can change one!

I 'm checking it now

To allow only the entry and edit of your own entry the usergroup should be set to

Registered Can view the Googlemap ME YES
Registered Can add elements on the Googlemap ME YES
Registered Can edit elements on the Googlemap ME NO
Registered Can delete elements on the Googlemap ME NO
Registered Can edit own entry on the Googlemap ME YES

Ups Sorry!
now it?s for users and guests.

http://www.hilfe-forum.eu/vbgooglemapme.php


I dont now who is the prob..

the Server can not be to smal..

The DB use Quad-Xenon-Server mit 8 GB RAM.
Serverload in smaler 3
in moment we have only a litle bit Users online...

your Hack is realy great an I and my Users realy love him.


im realy lucky if you can help me...

Sorry for my broken english..