vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Add-On Releases - gWoWEvents - World of Warcraft Event Signup (https://vborg.vbsupport.ru/showthread.php?t=170592)

LostPhoenix 02-21-2008 10:04 PM

Anyone else having an issue with the cron job failing?

soothius 02-21-2008 10:16 PM

Thanks for the mods gryphon! I managed to get the other two to work fine but am having trouble with this one. It seems it's installed and i can edit the options but when i go to create an event i have no options to use the mod. Currently i just go to calender and create event but am i supposed to do it antoher way? Thanks for any help.

Btw my modest board is located at www.wowdownunder.com .

Gryphon 02-21-2008 10:28 PM

Quote:

Originally Posted by LostPhoenix (Post 1448385)
Anyone else having an issue with the cron job failing?

Going to need a bit more information to be able to help. Are there errors?


@soothius, just create an event and make sure to check the box to enable signup.

LostPhoenix 02-21-2008 11:31 PM

Quote:

Originally Posted by Gryphon (Post 1448397)
Going to need a bit more information to be able to help. Are there errors?

Code:

Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE vb_gwowevents SET
                                `charurl` = 'r=Arygos&n=Censored',
                                `level` = '70',
                                `title` = '',
                                `faction` = 'Horde',
                                `factionid` = '1',
                                `gender` = 'Male',
                                `genderid` = '0',
                                `race` = 'Undead',
                                `raceid` = '5',
                                `class` = 'Priest',
                                `classid` = '5',
                                `talentspec` = '20,41,0',
                                `talent1` = '20',
                                `talent2` = '41',
                                `talent3` = '0',
                                `guild` = '',
                                `guildurl` = 'r=Arygos&n=&p=1',
                                `hp` = '6891',
                                `mp` = '10065',
                                `str` = '38',
                                `agi` = '43',
                                `sta` = '368',
                                `int` = '515',
                                `spi` = '521',
                                `arm` = '1359',
                                `strbase` = '38',
                                `agibase` = '43',
                                `stabase` = '59',
                                `intbase` = '143',
                                `spibase` = '163',
                                `armbase` = '1359',
                                `prof1` = 'Engineering',
                                `skill1` = '375',
                                `prof2` = 'Mining',
                                `skill2` = '375',
                                `cooking` = '375',
                                `firstaid` = '375',
                                `fishing` = '375',
                                `riding` = '300',
                        `armorydata` = '1' WHERE `realmchar` = 'Arygos.Censored';

MySQL Error  : Lost connection to MySQL server during query
Error Number : 2013
Date        : Thursday, February 21st 2008 @ 06:27:46 PM
Classname    : vb_database

If I run the same SQL call from phpmyadmin it goes fine. I think vBulletin is closing the connection to the database while the cron is running.

Caerydd 02-22-2008 05:27 AM

wewt, I have a test site now ^^

Will be trying this out on that over the weekend.

jim6763nva 02-22-2008 01:49 PM

How long should it take to import armory data after submitting an event? I created an event and it's just sitting there saying Awaiting armory data import....

Jim

LostPhoenix 02-22-2008 10:18 PM

Quote:

Originally Posted by jim6763nva (Post 1448691)
How long should it take to import armory data after submitting an event? I created an event and it's just sitting there saying Awaiting armory data import....

Jim

Jim,

Looks like you have the same issue as me. Login to your admin and check your scheduled tasks. Select gWoWEvents and select run now. If you get an error then we are in the same boat.

Foghorn Deadhor 02-22-2008 10:23 PM

<i>Note: still haven't installed, so take it for what it's worth:</i>

The feature with the by-event stat pulling sounds cool, and having a "history" of stats is a neat idea, but I'm going to say that I personally would probably disable this as it's a feature that doesn't concern me personally and seems bound to have performance issues, especially with Armory's unreliable nature. Perhaps this could be a main-switch option, or perhaps it could be by-event.

I personally would vastly prefer that it pull from the same table as the roster.

Still waiting to hear that it will work with event forums :P

Gooner 02-24-2008 11:28 AM

Great mod, now i hope you do not abandon such a great mod like Elric did :)

Gooner 02-24-2008 11:45 AM

i also am getting error when running cron job...

Quote:

Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE gwowevents SET
`charurl` = 'r=Shadowsong&n=Aloysius',
`level` = '70',
`title` = '',
`faction` = 'Horde',
`factionid` = '1',
`gender` = 'Male',
`genderid` = '0',
`race` = 'Orc',
`raceid` = '2',
`class` = 'Warrior',
`classid` = '1',
`talentspec` = '8,5,48',
`talent1` = '8',
`talent2` = '5',
`talent3` = '48',
`guild` = 'Ordo Templi Draconis',
`guildurl` = 'r=Shadowsong&n=Ordo+Templi+Draconis&p=1',
`hp` = '11394',
`mp` = '100',
`str` = '287',
`agi` = '147',
`sta` = '713',
`int` = '30',
`spi` = '54',
`arm` = '13691',
`strbase` = '162',
`agibase` = '93',
`stabase` = '141',
`intbase` = '30',
`spibase` = '54',
`armbase` = '13691',
`prof1` = 'Blacksmithing',
`skill1` = '250',
`prof2` = 'Mining',
`skill2` = '155',
`cooking` = '',
`firstaid` = '375',
`fishing` = '1',
`riding` = '225',
`armorydata` = '1' WHERE `realmchar` = 'Shadowsong.Aloysius';

MySQL Error : MySQL server has gone away
Error Number : 2006
Date : Sunday, February 24th 2008 @ 08:43:47 AM
Script : http://www.********t/admincp/cronadm...cron&cronid=23
Referrer : http://www.********t/admincp/index.php
IP Address : 77.101.215.207
Username : ********
Classname : vB_Database


All times are GMT. The time now is 12:47 PM.

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.01436 seconds
  • Memory Usage 1,756KB
  • 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
  • (4)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