vb.org Archive
Page 4 of 4 « First 23 4
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Miscellaneous Hacks - Vanguard Guild Roster Integration Hack (https://vborg.vbsupport.ru/showthread.php?t=142066)

Xaices 12-18-2007 11:09 PM
Gandiel,

Need some help please. I get this when I run a scheduled task.

Quote:
Database error in vBulletin 3.6.8:
Invalid SQL:
INSERT INTO vbvgroster_roster VALUES ('','','');
MySQL Error : Column count doesn't match value count at row 1
Error Number : 1136
Date : Tuesday, December 18th 2007 @ 07:55:53 PM
Script : http://www.blackwatchguild.com/forum...cron&cronid=19
Referrer : http://www.blackwatchguild.com/forums/admincp/index.php
IP Address :
Username :
Classname : vB_Database
Thanks for you help in this matter.

Xaices 12-19-2007 11:53 PM
Ok Gandiel is no longer supporting this. Can any one assist?

Quote:
That error is due to a problem with the MySQL coding/syntax. The vbvgroster_roster has a total of 12 values in each row. That SQL query is only trying to write to 3 of them. Unless you define what specific columns you are filling in, you must have the exact number of columns that the table has in the VALUES portion of the query. This will need to be fixed in the script, and I would suggest contacting the developer of the script, or browsing support forums for the product.
I can't code so any assistance on this would be most appreciated.

Gandiel 12-20-2007 11:52 AM
Xaices and anyone else,

Seeing Xaices last post with that quote in it gave me some insight to the problem. I've provided a fix (for now) to the problem. You'll need to UNINSTALL the product first, then REINSTALL the new product-vgroster.xml file attached to this post and overwrite the vgroster_import.php in includes/cron/

The reason I say this is a temporary fix is because there's a problem with Vanguard's CSV output. They only want to display 11 headings:

Code:
name, id, prefixTitle,advtClass,advtLevel,craftingClass,craftingLevel,diplomacyClass,diplomacyLevel,dateJoined,guildRank
But in reality they're outputting 12 fields:

Code:
Xaices,81604385483,Founder,Dread Knight (20),50,Crafter (1050),1,Diplomat,4,,2007-12-10,Initiate
Notice the double commas between "4" and "2007-12-10"


If Vanguard ever fixes that, the cron job will break again.

I stopped supporting this months ago. I haven't even played Vanguard since April 2007. I just had some spare time this morning to take a deeper look into the problem.

GL to you all.


Gandiel

Xaices 12-20-2007 05:15 PM
Thank you Gandiel!


All times are GMT. The time now is 10:59 AM.
Page 4 of 4 « First 23 4
Show 40 post(s) from this thread on one page

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.01182 seconds
  • Memory Usage 1,726KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)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