vb.org Archive - VBGooglemap Member Edition

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.

soulface

05-14-2006 07:00 PM

Quote:

Originally Posted by soulface

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

Code:

Database error in vBulletin 3.5.4:



Invalid SQL:

SELECT title,googlemapmetype    FROM usergroup where showonvbgme = '1';



MySQL Error  : Unknown column 'showonvbgme' in 'where clause'

Error Number : 1054

Date         : Sunday, May 14th 2006 @ 03:41:57 PM

Script       : http://www.*******.com/vbgooglemapme.php?

Referrer     : 

IP Address   : **********

Username     : Eros

Classname    : vb_database

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

stonyarc

05-14-2006 07:05 PM

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.

Gizmo999

05-14-2006 07:07 PM

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

stonyarc

05-14-2006 07:10 PM

Quote:

Originally Posted by Gizmo999

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.

moonclamp

05-14-2006 07:16 PM

Quote:

Originally Posted by stonyarc

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.

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.

stonyarc

05-14-2006 07:33 PM

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.

xfaethorx

05-14-2006 07:59 PM

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!

stonyarc

05-14-2006 08:06 PM

Quote:

Originally Posted by xfaethorx

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

hilfe-forum

05-14-2006 08:10 PM

Quote:

Originally Posted by stonyarc

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.

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..

All times are GMT. The time now is 04:19 AM.

Page 116 of 172

116

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02644 seconds Memory Usage 1,747KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (5)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: