Thread: Major Additions - AWCoding- Donation System
View Single Post
  #633  
Old 04-06-2009, 10:08 AM
wottech wottech is offline
 
Join Date: May 2006
Posts: 122
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Just installed this mod, and it is great. I'm not sure what part of the code is doing it, but on my main site (vbdrupal install), I get the following mySQL error:

Database error in vBulletin 3.8.2:

Invalid SQL:
SELECT SUM(mc_gross) AS amount FROM vb_awc_payments WHERE payment_status='Completed' AND sid='ss' AND date_format(from_unixtime(payment_date),'%m%y')='0 409';

MySQL Error : Table 'wottech_vbforum.vb_awc_payments' doesn't exist
Error Number : 1146
Request Date : Monday, April 6th 2009 @ 06:02:49 AM
Error Date : Monday, April 6th 2009 @ 06:02:49 AM
Script : http://60degreev6.com/
Referrer : http://60degreev6.com/forum/
IP Address : 70.178.0.7
Username : bszopi
Classname : vB_Database
MySQL Version : 5.0.67-community

So somewhere, it is looking for awc_payments table instead of awcl_payments table. The mod seems to work just fine the forums, though. Have any ideas? Thanks!

EDIT: Since it is happening when a user comes directly to the site, I have put up a redirect to the forums until the issue is fixed. The error can be recreated by going to any of the content via the links in the left hand menus.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01082 seconds
  • Memory Usage 1,763KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete