vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Major Additions - DamnComp - MemberMap (https://vborg.vbsupport.ru/showthread.php?t=285479)

Poppet 07-13-2012 11:48 PM

We've installed this tonight and this is the database error,

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT U.username as username,
U.userid as userid,
MM.lat as lat,
MM.lon as lon,
IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid,
U.avatarrevision,
AV.avatarpath,
NOT ISNULL(CAV.userid) AS hascustomavatar,
CAV.dateline AS avatardateline,
CAV.width AS avwidth,
CAV.height AS avheight,
U.lastactivity

FROM vBdc_membermap AS MM
LEFT JOIN vBuser AS U ON U.userid = MM.userid
LEFT JOIN vBavatar AS AV ON (AV.avatarid = U.avatarid)
LEFT JOIN vBcustomavatar AS CAV ON (CAV.userid = U.userid);

MySQL Error : Table 'troton_forum.vBdc_membermap' doesn't exist
Error Number : 1146

Doc2911 07-14-2012 03:57 AM

Quote:

Originally Posted by soniceffect (Post 2347786)
Will have to look into that. This is the fix I have just put in place for the avatars which seems to be disabled on your php installation. May be worth contacting your host with this message as they may be able to enable it for you. In the meantime I will try and find a workaround.

your are right, this
Quote:

allow_url_fopen
was the prob in the php installation, fixed and now it works perfect.

thx for help and the mod.

cya

nukinfuts29 07-14-2012 05:07 AM

For many of you with DB issues it may be something very simple that you overlooked, I know i did:

Check the prefix on the dc table. I have a custom vb prefix on my database and the mod was looking in the wrong place.

ywwz 07-14-2012 07:00 AM

Fantastic update! I can see Avatar now! Exellent!

Ricsca 07-14-2012 07:11 AM

Quote:

Originally Posted by soniceffect (Post 2347786)

[sql]
CREATE TABLE IF NOT EXISTS `vb_dc_membermap` (
`markerid` int(11) NOT NULL AUTO_INCREMENT,
`userid` int(11) NOT NULL,
`desc` text,
`lat` float(10,6) NOT NULL,
`lon` float(10,6) NOT NULL,
PRIMARY KEY (`markerid`),
UNIQUE KEY `idx_user` (`userid`))
[/sql]

The map work but if save the position have this error:

http://www.tuttoserpenti.it/dcMembermap.php

soniceffect 07-14-2012 08:13 AM

Quote:

Originally Posted by nukinfuts29 (Post 2347873)
For many of you with DB issues it may be something very simple that you overlooked, I know i did:

Check the prefix on the dc table. I have a custom vb prefix on my database and the mod was looking in the wrong place.

YOU MY FRIEND ARE A GENIOUS! ....... I cant believe I overlooked something so simple. Fix on its way

CoZmicShReddeR 07-14-2012 08:21 AM

Please test this on a fixed theme/style as I do not see anyone posting here using a fixed theme and I removed all the plugins you said might be causing the misalignment...

http://www.cozworld.com/dcMembermap.php

Thanks!

soniceffect 07-14-2012 08:25 AM

No worries m8. If you do need that plugin you removed and need it sorting for you let me know. Looks good on there though m8 other than the popup colours which is actually sorted in beta2 being released shortly

Seems to look find on your theme from here btw

soniceffect 07-14-2012 08:33 AM

1 Attachment(s)
Has been tested on default skin only as cannot build a modification that fits every skin on the planet due to not knowing what those skins entail. However it does work on fixed skins no problem, including yours as you can see in this screenshot.

If you find it is being hidden somewhat though or its overlapping the edge of your skin, this will be due to the size of the map which you would have to have a look at within dcMembermap.css template

Geisthund99 07-14-2012 09:35 AM

Quote:

Originally Posted by nukinfuts29 (Post 2347873)
For many of you with DB issues it may be something very simple that you overlooked, I know i did:

Check the prefix on the dc table. I have a custom vb prefix on my database and the mod was looking in the wrong place.

Code appears to be missing: TABLE_PREFIX


All times are GMT. The time now is 10:42 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02010 seconds
  • Memory Usage 1,740KB
  • 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
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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