[AWJunkies]

Originally Posted by wottech

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.

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

Originally Posted by wottech

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.

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