vb.org Archive - VBGooglemap Member Edition

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.

JD45	05-14-2006 05:23 PM

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

Code:

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 @ 02:22:18 PM

Script       : http://www.justpressplay.net/forum/admincp/plugin.php

Referrer     : http://www.justpressplay.net/forum/admincp/plugin.php?do=productadd

IP Address   : 

Username     : JD45

Classname    : vb_database

JD45	05-14-2006 05:26 PM

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

Thanks again for all your assistance..:)

stonyarc

05-14-2006 05:33 PM

Quote:

Originally Posted by JD45

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

moonclamp

05-14-2006 05:39 PM

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*

hilfe-forum

05-14-2006 05:47 PM

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

stonyarc

05-14-2006 05:55 PM

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.

kompakt

05-14-2006 06:01 PM

Quote:

Originally Posted by stonyarc

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

Preferably with an account I can use to test

Thanks, its working great now :cool:

stonyarc

05-14-2006 06:35 PM

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.

soulface

05-14-2006 06:43 PM

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

All times are GMT. The time now is 07:34 PM.

Page 115 of 172

115

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01970 seconds Memory Usage 1,746KB 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 (2)bbcode_code_printable (4)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: