vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Major Additions - AWCoding- Donation System (https://vborg.vbsupport.ru/showthread.php?t=177437)

Gomojoe 01-30-2011 10:31 PM

So I just installed this mod and confirmed that it works. However, I am having an issue with the donate drop down list. It shows up in the navbar, but when you click it you don't see anything under it.

AWJunkies 02-01-2011 08:15 PM

Quote:

Originally Posted by aymelek (Post 2132927)
I have VB version 3.5.4 and installed the latest version (4.0) which installed perfectly fine, but when I went into the AWCoding Software LITE setting in the adminCP I'm getting a SQL error:


SELECT varname, text
FROM `vb_phrase`
WHERE fieldname = 'awclsettings'
AND languageid IN( -1, 0, 1 )
ORDER BY languageid ASC;

MySQL Error : Unknown column 'fieldname' in 'where clause'

Yes in PRO etc before purchasing it says contact me if below 3.6 There needs to be a few edits to work on 3.5 platform as fields where not present yet. As you see in that error message. You will need to contact me and I can make the edits for you and send you the files.

AWJunkies 02-01-2011 08:20 PM

Quote:

Originally Posted by Gomojoe (Post 2156669)
So I just installed this mod and confirmed that it works. However, I am having an issue with the donate drop down list. It shows up in the navbar, but when you click it you don't see anything under it.

Did you set your permissions correctly for who can see list and donate page? What browser are you using can you send link. I know there is an issue with the drop down a few have reported so I will be looking at it and fixing really soon. Just compiling all the issues to do them all at once.

pjkcards 02-15-2011 10:08 PM

I uploaded the files and installed it, and when I visit the forum I get this error (I installed v4.0.2). Any ideas on how to fix it? Many thanks:
Quote:

Database error in vBulletin 4.0.6:

Invalid SQL:

SELECT
FROM `awcl_payments`
WHERE sid = 'dsl' AND payment_status = 'Completed' AND item_number = 1
AND date_format( from_unixtime( payment_date ), '%m%y' ) = '0211';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM `awcl_payments`
WHERE sid = 'dsl' AND payment_status = 'Completed'' at line 2
Error Number : 1064
Request Date : Tuesday, February 15th 2011 @ 07:06:17 PM
Error Date : Tuesday, February 15th 2011 @ 07:06:18 PM
Script : http://www.domain.com/testforum/forum/forum.php
Referrer :
IP Address : xxx
Username : xxx
Classname : vB_Database
MySQL Version : 5.0.91-community

pjkcards 03-07-2011 03:46 AM

Can anyone help with this? Thanks in advance!

AWJunkies 03-08-2011 05:26 PM

Quote:

Originally Posted by pjkcards (Post 2170441)
Can anyone help with this? Thanks in advance!

Should not be getting that the FROM information is missing. This seems like you edited the plugin directly. As should not get that at all clearly the FROM info is declared at top of the plugin. I would uninstall and install again.

fxwoody 03-10-2011 10:12 AM

For anyone interested, if you have the vB4 SuperCharged mod. It will conflict with this one as it removes the amount and also the transfer to paypal!

AWJunkies 03-10-2011 04:29 PM

Quote:

Originally Posted by fxwoody (Post 2171790)
For anyone interested, if you have the vB4 SuperCharged mod. It will conflict with this one as it removes the amount and also the transfer to paypal!

It conflicts with my JS as it can not be cached and that mod caches my js. So in that mod you need to exclude my mod from being cached. So it is not my mod conflicting with theirs it is there mod conflicting with mine. So need to add exclusion not to cache my JS on my payment page or turn of JS caching in the mod above.

bashy 03-10-2011 05:27 PM

Hi again, back to this hack as i have just reverted back to 3.8.6 from VB4 to try to upgrade this hack to the latest build but sadly still struggling, it let me upgrade to v3.0.0, but will not let me upgrade to any higher build, it just gives me this DB error

Code:

Database error in vBulletin 3.8.6:

Invalid SQL:
INSERT IGNORE INTO `adv_modules` VALUES( 2000, 'Donation LITE Support SideBar', 'dsl_adv_cmps_sb', 'dsl_adv_cmps_sb.php', 'php_file', 'awcl_dsl_block', '4,6,9,7,10,2,5,1,3', '', 1, 0, '', 1, '', '', 0, '' );

MySQL Error  : Column count doesn't match value count at row 1
Error Number  : 1136
Request Date  : Thursday, March 10th 2011 @ 07:23:08 PM
Error Date    : Thursday, March 10th 2011 @ 07:23:09 PM
MySQL Version : 5.1.54

I think its the same error as shown when i had VB 4 installed and tried to update....

AWJunkies 03-22-2011 04:26 PM

Quote:

Originally Posted by bashy (Post 2171980)
Hi again, back to this hack as i have just reverted back to 3.8.6 from VB4 to try to upgrade this hack to the latest build but sadly still struggling, it let me upgrade to v3.0.0, but will not let me upgrade to any higher build, it just gives me this DB error

Code:

Database error in vBulletin 3.8.6:

Invalid SQL:
INSERT IGNORE INTO `adv_modules` VALUES( 2000, 'Donation LITE Support SideBar', 'dsl_adv_cmps_sb', 'dsl_adv_cmps_sb.php', 'php_file', 'awcl_dsl_block', '4,6,9,7,10,2,5,1,3', '', 1, 0, '', 1, '', '', 0, '' );

MySQL Error  : Column count doesn't match value count at row 1
Error Number  : 1136
Request Date  : Thursday, March 10th 2011 @ 07:23:08 PM
Error Date    : Thursday, March 10th 2011 @ 07:23:09 PM
MySQL Version : 5.1.54

I think its the same error as shown when i had VB 4 installed and tried to update....

That has to do with vBAdvanced CMS. What version of that mod are you on? He may have added a column which is causing the issue.


All times are GMT. The time now is 07:34 AM.

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