vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Add-On Releases - vBulletin-Membermap (https://vborg.vbsupport.ru/showthread.php?t=154533)

yotsume 09-11-2008 09:27 AM

Bugs and Errors in This Mod!
1. Installing certain map geodata returns database errors in the AdminCP.
2. After installing your mod and geodata files which import a mass amount of info into the database the database will NO LONGER backup completely!

WARNING!
Anyone who has this mod installed needs to do a database backup and then check how many tables where backed up! You may find that during the database backup when VB gets to the tables where this mod is installed the database will become cut off and not download. So you will have an incomplete database backup and wont know it!

No Response From The Developer For Support!
I've asked for support and have been waiting more then a week with no reply. A number of your Geodata files when you click install in the AdminCP give me a database error. France Geodata for example. Now that I have your map mod installed I can no longer backup my full database. It times out now after only downloading a few MBs.

Also I can not change my attachment storage type from database to the filing system. Your mod gets in the way and gives another database error!

Anyone who installs this on vb3.7.3x should be WARNED!
If I do not get support from you in the next couple of days I will have to uninstall your mod and will have to post a warning about this...

Here is the database error:

Quote:

Database error in vBulletin 3.7.3:

Invalid SQL:
SELECT * FROM vb_vbmembermap_geo ORDER BY geo_latitude desc;

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Request Date : Thursday, September 11th 2008 @ 05:21:52 AM
Error Date : Thursday, September 11th 2008 @ 05:21:55 AM
Script : http://www.mydomain.com/admincp/admi...eratestatistic
Referrer : http://www.mydomain.com/admincp/admi...p.php?do=tools
IP Address : xx.xxx.xx.xxx
Username : myname
Classname : vb_database
So how about a reply already please. This mod is by far the best map system for VB. Small problem is, it has the potential to KILL a VB 3.7x site!

Keyser Soze 09-11-2008 01:35 PM

Don't blame the authors of this mod for your corrupt database tables and/or your weak server hardware. Repair your database tables using mysql and buy faster hardware. This mod is not responsible for the "Lost connection to MySQL server during query"-error and everything is working fine with this mod on my forum, even on 3.7.3.

yotsume 09-22-2008 07:01 AM

Quote:

Originally Posted by Keyser Soze (Post 1619833)
Don't blame the authors of this mod for your corrupt database tables and/or your weak server hardware. Repair your database tables using mysql and buy faster hardware. This mod is not responsible for the "Lost connection to MySQL server during query"-error and everything is working fine with this mod on my forum, even on 3.7.3.

Not a very helpful reply so I'll just ignore it...

To help anyone who might have a similar problem that I have had importing some of the geodata files... The problem is the amount of data being important and the speed at which it is trying to enter your database. Some of the geodata files contain much more info then others. Yes, due to my server configuration there is a timeout issue which can not be solved on my server side. However, it can be easily solved within the code of this mode and some changes which I am working on. The changes will only be to the amount of data and speed that important info from the geodata files are allowed to be transfered to your database. I am working on a way to slow it so it you can match settings on your server so there will no longer be any time outs. There will be a new setting within the admincp to pick an import speed similar to the setting of when you change the attachment storage type from database to the file system with the admincp.

When I have this coded and worked out I will post some instructions for anyone else who might have experienced this problem.

Thanks for a great mod... it is by far the best map system we have for vb to date. I wish we could hear from the developer once and a while here. :D

Vossi 09-22-2008 07:23 AM

Quote:

Originally Posted by yotsume (Post 1627517)
Not a very helpful reply so I'll just ignore it...

To help anyone who might have a similar problem that I have had importing some of the geodata files... The problem is the amount of data being important and the speed at which it is trying to enter your database. Some of the geodata files contain much more info then others. Yes, due to my server configuration there is a timeout issue which can not be solved on my server side. However, it can be easily solved within the code of this mode and some changes which I am working on. The changes will only be to the amount of data and speed that important info from the geodata files are allowed to be transfered to your database. I am working on a way to slow it so it you can match settings on your server so there will no longer be any time outs. There will be a new setting within the admincp to pick an import speed similar to the setting of when you change the attachment storage type from database to the file system with the admincp.

When I have this coded and worked out I will post some instructions for anyone else who might have experienced this problem.

Thanks for a great mod... it is by far the best map system we have for vb to date. I wish we could hear from the developer once and a while here. :D

What I could offer is the actual and even more stable version which has to be translated into english first.

Keyser Soze 09-22-2008 07:25 AM

Quote:

Originally Posted by yotsume (Post 1627517)
Not a very helpful reply so I'll just ignore it...

You're the man :rolleyes:
P.S.: phpMyAdmin already has a feature called "partial import".

yotsume 09-22-2008 07:37 AM

Quote:

Originally Posted by Vossi (Post 1627523)
What I could offer is the actual and even more stable version which has to be translated into english first.

Awesome! Will the new version be available here as an update?

yotsume 09-22-2008 07:45 AM

Quote:

Originally Posted by Keyser Soze (Post 1627527)
P.S.: phpMyAdmin already has a feature called "partial import".

Yes but it is much nicer to have a mod with a built in setting for speed or amount of info transfered to the database right within the admincp. If we had more mods built that way there would be a heck of a lot less posts requesting help with time out issues. ;)

CLUB AMPLE 09-27-2008 03:23 PM

Quote:

Originally Posted by Vossi (Post 1627523)
What I could offer is the actual and even more stable version which has to be translated into english first.


Dear sir... You have a fabulous mod here... as many have stated. If you finished it 100%... with English conversion and world maps... you could easily charge to download this mod. I wouldn't think twice to spend 5 or 10 bucks to have this on my forum in a finished and more complete version.

Very much looking forward to you getting some more free time in your coding future. :)

yotsume 09-27-2008 06:33 PM

I'll second that!

The "final version" I hope takes into account the ability to cycle down how much data has to be imported into the database per map. I hope the next version stores the map data in a file system rather then bulk up our databases with a mass amount of map info.

LCN2007 10-14-2008 05:48 AM

is there a 3.7 version?


All times are GMT. The time now is 10:53 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.01570 seconds
  • Memory Usage 1,757KB
  • 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
  • (7)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