vb.org Archive - Major Additions - AWCoding- Donation System

Page 66 of 83

« First

Last »

Show 40 post(s) from this thread on one page

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)

Doctor Death

04-14-2009 10:33 PM

Error on product import (with overwrite of previous version)

Quote:

Database error in vBulletin 3.8.2:

Invalid SQL:
INSERT INTO `vywddddh_phrase` VALUES('',-1,'dsl_navbar_hook_1','global','<td id="{1}" class="vbmenu_control"><a style="color:{2};" href="{3}">{4}</a><script type="text/javascript"> vbmenu_register("{1}"); </script></td>','vbulletin','AWJunkies',1239751795,'3.0.0');

MySQL Error : Duplicate entry 'dsl_navbar_hook_1--1-global' for key 2
Error Number : 1062
Request Date : Tuesday, April 14th 2009 @ 07:29:54 PM
Error Date : Tuesday, April 14th 2009 @ 07:29:55 PM
Script : http://www.ddddd.com/forums/admincp/...=productimport
Referrer : http://www.dddddd.com/forums/admincp...?do=productadd
IP Address : 70.333.33.132
Username : dddddddddddd
Classname : vb_database
MySQL Version : 4.1.22-standard

AWJunkies

04-16-2009 05:00 AM

Quote:

Originally Posted by Doctor Death (Post 1791368)

Error on product import (with overwrite of previous version)

Go to the product XML and search for:

PHP Code:


		
			
$columns_sql=$db->query_read("SHOW columns FROM `".TABLE_PREFIX."phrase`"); $columns_results=$db->num_rows($columns_sql); $time=time(); $vbstyles_sql=$db->query_read("SELECT styleid FROM ".TABLE_PREFIX."style"); while ($vbstyle=$db->fetch_array($vbstyles_sql)){$phrase="dsl_navbar_hook_".$vbstyle['styleid']; if ($columns_results==9){$db->query_write("INSERT INTO `".TABLE_PREFIX."phrase` VALUES('',-1,'".$phrase."','global','<td id=\"{1}\" class=\"vbmenu_control\"><a style=\"color:{2};\" href=\"{3}\">{4}</a><script type=\"text/javascript\"> vbmenu_register(\"{1}\"); </script></td>','vbulletin','AWJunkies',".$time.",'3.0.0')");}elseif ($rows_results==10){$db->query_write("INSERT INTO `".TABLE_PREFIX."phrase` VALUES('',-1,'".$phrase."','global','<td id=\"{1}\" class=\"vbmenu_control\"><a style=\"color:{2};\" href=\"{3}\">{4}</a><script type=\"text/javascript\"> vbmenu_register(\"{1}\"); </script></td>','vbulletin','AWJunkies',".$time.",'3.0.0',0)");}}

And remove it and re-upload the XML.

I was trying to make all the hooks for you for all styles in case you didn't have them. Not a big deal at all just remove the code that does it from XML and walla will load fine.

Doctor Death

04-16-2009 11:32 PM

Quote:

Originally Posted by AWJunkies (Post 1792221)

Go to the product XML and search for:

PHP Code:


		
			
$columns_sql=$db->query_read("SHOW columns FROM `".TABLE_PREFIX."phrase`"); $columns_results=$db->num_rows($columns_sql); $time=time(); $vbstyles_sql=$db->query_read("SELECT styleid FROM ".TABLE_PREFIX."style"); while ($vbstyle=$db->fetch_array($vbstyles_sql)){$phrase="dsl_navbar_hook_".$vbstyle['styleid']; if ($columns_results==9){$db->query_write("INSERT INTO `".TABLE_PREFIX."phrase` VALUES('',-1,'".$phrase."','global','<td id=\"{1}\" class=\"vbmenu_control\"><a style=\"color:{2};\" href=\"{3}\">{4}</a><script type=\"text/javascript\"> vbmenu_register(\"{1}\"); </script></td>','vbulletin','AWJunkies',".$time.",'3.0.0')");}elseif ($rows_results==10){$db->query_write("INSERT INTO `".TABLE_PREFIX."phrase` VALUES('',-1,'".$phrase."','global','<td id=\"{1}\" class=\"vbmenu_control\"><a style=\"color:{2};\" href=\"{3}\">{4}</a><script type=\"text/javascript\"> vbmenu_register(\"{1}\"); </script></td>','vbulletin','AWJunkies',".$time.",'3.0.0',0)");}}

I tried that and it still puked on install. Would it make sense to uninstall and reinstall new version or would that get rid of all my data?

Patrickftw

04-17-2009 07:12 PM

Is there a fix for this? I'm not sure why I'm getting it, I'd really like to use this.

Code:

Database error in vBulletin 3.8.1:



Invalid SQL:

SELECT dsl.*,dsl.mc_gross-awc.mc_fee AS amount,user.userid,user.username,user.avatarid,user.avatarrevision,avatar.avatarpath,NOT ISNULL(customavatar.userid) AS hascustomavatar,customavatar.dateline AS avatardateline FROM lpawcl_payments AS dsl LEFT JOIN lpuser AS user ON(dsl.userid=user.userid) LEFT JOIN lpavatar AS avatar ON(avatar.avatarid=user.avatarid) LEFT JOIN lpcustomavatar AS customavatar ON(customavatar.userid=user.userid) WHERE payment_status='Completed' AND item_number=1 AND date_format(from_unixtime(payment_date),'%m%y')='0409' ORDER BY payment_date DESC LIMIT 0,10;



MySQL Error   : Unknown table 'awc' in field list

Error Number  : 1109

Request Date  : Friday, April 17th 2009 @ 01:02:26 PM

Error Date    : Friday, April 17th 2009 @ 01:02:26 PM

Script        : http://mysite.com/awcl_dsl.php?do=list

Referrer      : 

Classname     : vB_Database

MySQL Version : 4.1.20

AWJunkies

04-17-2009 07:58 PM

Quote:

Originally Posted by Patrickftw (Post 1793492)

Is there a fix for this? I'm not sure why I'm getting it, I'd really like to use this.

Code:

Database error in vBulletin 3.8.1:



Invalid SQL:

SELECT dsl.*,dsl.mc_gross-awc.mc_fee AS amount,user.userid,user.username,user.avatarid,user.avatarrevision,avatar.avatarpath,NOT ISNULL(customavatar.userid) AS hascustomavatar,customavatar.dateline AS avatardateline FROM lpawcl_payments AS dsl LEFT JOIN lpuser AS user ON(dsl.userid=user.userid) LEFT JOIN lpavatar AS avatar ON(avatar.avatarid=user.avatarid) LEFT JOIN lpcustomavatar AS customavatar ON(customavatar.userid=user.userid) WHERE payment_status='Completed' AND item_number=1 AND date_format(from_unixtime(payment_date),'%m%y')='0409' ORDER BY payment_date DESC LIMIT 0,10;



MySQL Error   : Unknown table 'awc' in field list

Error Number  : 1109

Request Date  : Friday, April 17th 2009 @ 01:02:26 PM

Error Date    : Friday, April 17th 2009 @ 01:02:26 PM

Script        : http://mysite.com/awcl_dsl.php?do=list

Referrer      : 

Classname     : vB_Database

MySQL Version : 4.1.20

That was my bad this ONLY effects list view in NET not gross income format. Fixed now uploaded to zip

AWJunkies

04-17-2009 07:59 PM

Quote:

Originally Posted by Doctor Death (Post 1792906)

I tried that and it still puked on install. Would it make sense to uninstall and reinstall new version or would that get rid of all my data?

Ok what you need to do is go to product edit and change version to 3.0.0 save then upload XML as override and your all good. The initial error you got was at the end of install it just didnt get to load new templates and plugins so by bypassing the version # you will not reinstall 3.0.0 but just install plugins and templates.

Doctor Death

04-18-2009 05:39 PM

Quote:

Originally Posted by AWJunkies (Post 1793515)

Done. Worked. Thanks.

Now if I could get the paid version to work I would be happy.

AWJunkies

04-18-2009 07:45 PM

Quote:

Originally Posted by Doctor Death (Post 1794037)

Done. Worked. Thanks.

Now if I could get the paid version to work I would be happy.

You forget to load Donation System and only loaded Back-End. Pmed you on FC.

crazylegs

04-19-2009 10:38 AM

These are the best installation instructions that I've dealt with for a plugin yet, and I'm a tech writer, so I really appreciate that stuff. The install went smooth as butter. Great software!

AWJunkies

04-19-2009 04:48 PM

Quote:

Originally Posted by crazylegs (Post 1794348)

These are the best installation instructions that I've dealt with for a plugin yet, and I'm a tech writer, so I really appreciate that stuff. The install went smooth as butter. Great software!

Thanks so much enjoy the mod.

All times are GMT. The time now is 05:20 PM.

Page 66 of 83

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02117 seconds Memory Usage 1,775KB 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 (2)bbcode_php_printable (8)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)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
Messages: