Stunning cant wait :)

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.

Fixed. In the new product XML file, there is still a db entry of AWC_ instead of AWCL_. I found it in Notepad, so I can't say exactly what line number it is. But do a search for it, and I think you will find it. I'm pretty sure it was the second to last one in the file.

that error is caused by having AWCoding- Subscription System amounts added to goal amount integration setting ON in bar section. It is NOT on by default NOR should you have turned it on without AWCoding- Subscription System which is explicitly says. Don't want to add a query to check if table exists before adding it to goal as that is additional query everyplace sidebar, centerbar, and main bar are shown not good :)

So go to AWcoding LITE->Settings->Donation System LITE->bar settings->Last option AWCoding subscription system integration set that OFF only have it on if you have SS installed on site.
LINK TO SEE SETTING LOCATION

DO NOT DO THIS :) you turned on a setting you shouldn't have because you don't have the software revert this or you will get DOUBLE the donation bar amount :)
I repeat change that back go to plugins my software parse_templates and change dsl_bar_awc_ss is statement area back to awc NOT awcl. Basically re-download and override XML this will put the correct table back and not effect settings or payments or anything.

Make sure to turn off the setting I stated above before re-importing as override.

AGAIN THIS IS NOT AN ERROR OR BUG PLEASE READ THROUGH ALL SETTINGS AND SETUP BEFORE USING.

Also I have to make CLEAR there was no version 2.0 of the LITE software everyone who has 0.2.1 or 0.2.0 are FAR behind in versions as 1.0.0 was released a year ago you have been using wrong version so please upgrade 3.0.0 to stop the confusion :)

I was actually on version 1.0.0, but I just stated it wrong in my thread. I read through the instructions, but obviously missed that part. I will go back and fix it as you stated. Thanks for the info, and sorry about the false bug report.

No problem at all enjoy the software.

does this system allow for a 2nd paypal address to be incorporated. For example: if i wanted to allow my users to donate to someone else's paypal to support a get together fund etc.

LITE does not have goals system so your answer is no. Lite uses a timed slot system not goals system per say.

PRO has goals and will be getting a goal owner system which they can set own payment methods to be used etc. Not sure how I want to implement it at this time there is discussions on it on FC. But I have done custom stuff for users for PRO software with platinum service I have done alternating paypal accounts per transaction etc and so on. Anything can be done it is just a matter of you guys suggesting it and me coding it. BUT this will never be in LITE version as it has no goals system and I will not be bringing that to LITE it is a PRO only along with awards and so much more.

...link me to where i need to be :-)

PM sent..

Everyone:
Please click installed to show support as well as please respond and give feedback.