The Arcive of Official vBulletin Modifications Site.

vietfancy · #1 01-14-2010, 11:10 AM

I'm not sure what causes it. The first time it go though, but when i re-imported the code, it gives me error , but if I change the productid to something else then it will go through.

Here is the database error message.

Code:

			UPDATE template SET
				styleid = -10
			WHERE product = 'ese_scholarship' AND styleid = -1;

MySQL Error   : Duplicate entry 'ese_scholarship--10-template' for key 'title'

and here is the product code:

PHP Code:


			
<?xml version="4.0" encoding="utf-8"?>

<product productid="ese_scholarship" active="1">

    <title>ESE Scholarship</title>

    <description>ESE scholarship</description>

    <version>4.0</version>

    <url />

    <versioncheckurl />

    <dependencies>

    </dependencies>

    <codes>

        <code version="4.0">

            <installcode><![CDATA[$db->query("CREATE TABLE IF NOT EXISTS `" . TABLE_PREFIX . "ese_scholarship` (                                               `id` int(4) unsigned NOT NULL AUTO_INCREMENT,

                          `donor` varchar(120) NOT NULL,

                          `amount` varchar(100) NOT NULL,

                          `fee` varchar(10) NOT NULL,

                          `month` varchar(10) NOT NULL,

                          `date` varchar(20) NOT NULL,

                          `year` varchar(4) NOT NULL,

                          PRIMARY KEY (`id`)

                          ) ENGINE=MyISAM");

$db->show_errors();]]></installcode>

            <uninstallcode><![CDATA[$db->query_write("DROP TABLE IF EXISTS `" . TABLE_PREFIX . "ese_scholarship`");

$db->show_errors();]]></uninstallcode>

        </code>

    </codes>

    <templates>

    <template name="ese_scholarship" templatetype="template" date="1260504996" username="JK" version="1.0">

    <![CDATA[{vb:stylevar htmldoctype}

<html xmlns="http://www.w3.org/1999/xhtml" dir="{vb:stylevar textdirection}" lang="{vb:stylevar languagecode}" id="vbulletin_html">

  <head>

    <title>ESE Scholarship - {vb:raw vboptions.bbtitle}</title>

    {vb:raw headinclude}

    <style type="text/css">

.ese_extra_top{

    width:100%;

    font-weight:bolder;

        text-align:center;

}

.ese_extra{

    width:100%;

    height:30px;

}

    .tname{

        width:20%;

        text-align:center;

    }

    .tfee{

        width:15%;

        text-align:center;

    }

    .tamount{

        width:17%;

        text-align:center;    

    }

    .tdate{

        width:15%;

        text-align:center;    

    }

    .ttotal{

        width:15%;

        text-align:center;

    }

    .sname{

    border-bottom: 1px solid #5a7f97;

        width:20%;

        text-align:center;

    }

    .sfee{

    border-bottom: 1px solid #5a7f97;

        width:15%;

        text-align:center;

    }

    .samount{

    border-bottom: 1px solid #5a7f97;

        width:17%;

        text-align:center;    

    }

    .sdate{

    border-bottom: 1px solid #5a7f97;

        width:15%;

        text-align:center;    

    }

    .stotal{

    border-bottom: 1px solid #5a7f97;

        width:15%;

        text-align:center;

        color:#C00;

    }





    .atname{

        width:20%;

        text-align:center;

    }

    .atdate{

        width:20%;

        text-align:center;    

    }

    .atfee, .atamount, .attotal, .atcp{

        width:12%;

        text-align:center;

    }





    .aname{

    border-bottom: 1px solid #5a7f97;

        width:20%;

        text-align:center;

    }

    .adate{

    border-bottom: 1px solid #5a7f97;

        width:20%;

        text-align:center;    

    }

    .afee{

    border-bottom: 1px solid #5a7f97;

        width:12%;

        text-align:center;

    }

    .aamount{

    border-bottom: 1px solid #5a7f97;

        width:12%;

        text-align:center;    

    }



    .atotal{

    border-bottom: 1px solid #5a7f97;

        width:12%;

        text-align:center;

        color:#C00;

    }

    .acp{

    border-bottom: 1px solid #5a7f97;

        width:12%;

        text-align:center;

    }

    </style>

  </head>

  <body>

    {vb:raw header}

    {vb:raw navbar}

<!-- Custom Code -->

<div style="padding:10px;"></div>

<vb:if condition="$ese_scholarship['do'] == 'add'">

    <h2 class="blockhead">Add A Donor to the Database</h2>

    <div class="blockbody"><div class="blockrow">

<vb:if condition="is_member_of($bbuserinfo, 6)"> 

<!-- start add form -->

<form action="scholarship.php?do=added"  method="post">

<input type="hidden" name="s" value="value" />

<input type="hidden" name="securitytoken" value="{vb:raw bbuserinfo.securitytoken}" />

<table class="tborder" cellpadding="0" cellspacing="6" border="0" width="100%" align="center">

    <tr valign="top">

        <td class="alt1" width="120" align="left" nowrap="nowrap">

        <div style="padding:4px;">Month / Date / Year:</div>

        <div style="padding:4px;">Donor:</div>

        <div style="padding:4px;">Base Amount:</div>

        <div style="padding:4px;">Transfer Fee:</div>

        </td>

        <td class="alt2" width="35%">

        <div style="padding:3px;"><SELECT  name="month">

                <option disabled selected>Month</option>

                <OPTION value="Jan">January</OPTION>

                <OPTION value="Feb">February</OPTION>

                <OPTION value="Mar">March</OPTION>

                <OPTION value="Apr">April</OPTION>

                <OPTION value="May">May</OPTION>

                <OPTION value="Jun">June</OPTION>

                <OPTION value="Jul">July</OPTION>

                <OPTION value="Aug">August</OPTION>

                <OPTION value="Sept">September</OPTION>

                <OPTION value="Oct">Octorber</OPTION>

                <OPTION value="Nov">November</OPTION>

                <OPTION value="Dec">December</OPTION>

                </SELECT> / 

                <SELECT  name="date">

                <option disabled selected>Date</option>

                <OPTION value="01">01</OPTION>

                <OPTION value="02">02</OPTION>

                <OPTION value="03">03</OPTION>

                <OPTION value="04">04</OPTION>

                <OPTION value="05">05</OPTION>

                <OPTION value="06">06</OPTION>

                <OPTION value="07">07</OPTION>

                <OPTION value="08">08</OPTION>

                <OPTION value="09">09</OPTION>

                <OPTION value="10">10</OPTION>

                <OPTION value="11">11</OPTION>

                <OPTION value="12">12</OPTION>

                <OPTION value="13">13</OPTION>

                <OPTION value="14">14</OPTION>

                <OPTION value="15">15</OPTION>

                <OPTION value="16">16</OPTION>

                <OPTION value="17">17</OPTION>

                <OPTION value="18">18</OPTION>

                <OPTION value="19">19</OPTION>

                <OPTION value="20">20</OPTION>

                <OPTION value="21">21</OPTION>

                <OPTION value="22">22</OPTION>

                <OPTION value="23">23</OPTION>

                <OPTION value="24">24</OPTION>

                <OPTION value="25">25</OPTION>

                <OPTION value="26">26</OPTION>

                <OPTION value="27">27</OPTION>

                <OPTION value="28">28</OPTION>

                <OPTION value="29">29</OPTION>

                <OPTION value="30">30</OPTION>

                <OPTION value="31">31</OPTION>

                </SELECT> / 

                <SELECT  name="year">

                <option disabled selected>Year</option>

                <OPTION value="2010">2010</OPTION>

                <OPTION value="2011">2011</OPTION>

                <OPTION value="2012">2012</OPTION>

                <OPTION value="2013">2013</OPTION>

                <OPTION value="2014">2014</OPTION>

                <OPTION value="2016">2015</OPTION>

                <OPTION value="2016">2016</OPTION>

                </SELECT></div>

        <div style="padding:3px;"><input type="text" size="37" maxlength="256" name="donor" autocomplete="off" /></div>

        <div style="padding:3px;"><input type="text" size="37" maxlength="256" name="amount" autocomplete="off" /></div>

        <div style="padding:3px;"><input type="text" size="37" maxlength="256" name="fee" autocomplete="off" /></div>

        </td>

        <td class="alt1" width="65%" align="left" nowrap="nowrap">

        <div style="padding:3px;">text go here</div>



        </td>

    </tr>

    <tr valign="top">

        <td class="alt2" colspan="3" width="100%" align="center" style="padding-top:20px;">

        <input type="submit" class="button" value="Submit" accesskey="s" />

        <input type="reset" class="button" value="Reset" accesskey="s" />

        </td>

    </tr>

</table>

</form>

<!-- end add form -->

<!-- End Custom Code -->

<vb:else />

     <div class="alert">You don't have permission to access this page.</div>

</vb:if>

      </div></div>

<vb:else />

<!-- START ESE DONATE -->

<h2 class="blockhead"><b>Donation Options</b></h2>

<div class="blockbody"><div class="blockbody">

<table class="ese_extra"><tr>

<td style="padding:10px;" width="50%" ><ul>

  <li><strong>Using Paypal:</strong><br/>

    1. You must have a paypal account to use this option.<br/>

    2. Paypal home page: <a href="http://www.paypal.com"> www.paypal.com</a><br/>

    <br/>

  </li></ul>

    <hr>

    1. You can go to <a href="http://www.paypal.com"> Paypal</a> and make a donation to <strong><font color="#FF0000">ESE.Scholarship@gmail.com</font></strong><br/>

    or<br/>

    2. You can just click on the button below to go to the donation page.<br/><br/>

    <div align="center">

<form action="https://www.paypal.com/cgi-bin/webscr" method="post">

<input type="hidden" name="cmd" value="_donations">

<input type="hidden" name="business" value="ESE.Scholarship@gmail.com">

<input type="hidden" name="item_name" value="Make a donation to support ESE scholarship.">

<input type="hidden" name="no_shipping" value="0">

<input type="hidden" name="no_note" value="1">

<input type="hidden" name="currency_code" value="USD">

<input type="hidden" name="tax" value="0">

<input type="hidden" name="lc" value="US">

<input type="hidden" name="bn" value="PP-DonationsBF">

<input type="image" src="https://www.paypal.com/en_US/i/btn/x-click-but21.gif" border="0" name="submit" alt="PayPal - The safer, easier way to pay online!">

<img alt="" border="0" src="https://www.paypal.com/en_US/i/scr/pixel.gif" width="1" height="1">

</form>



    </div>

    </td>     

<td style="padding:10px;" width="50%">



<ul>

  <li><strong>By Mail:</strong><br/>

    1. Attach a note to inform us of who you are. Please use nick on Paltalk and/or in this forum. Please include your email address.<br/>

    2. If you wish to be anonymous, please state that in your note.<br/>

    <br/>

  </li></ul>



  <hr>



Mail a check or money order to the address given below:<br/>

<br/>

<strong>    <font color="#FF0000">ESE Scholarship<br/>

    c/o Nguyen<br/>

    P.O. BOX 90481<br/>

    San Jose, Ca 95109, USA</font><br/>

</strong></td>     

</tr>  

</table></div></div>

<!-- /END ESE DONATE -->



{vb:raw current_total}

<h2 class="blockhead"><b>ESE Scholarship Fund</b></h2>

<vb:if condition="$bbuserinfo[userid] == 1">

<div class="blocksubhead">{vb:raw ese_admin_fund_top}</div>

<div class="blockbody"><div class="blockrow">

{vb:raw ese_admin_fund}

</div></div>

<vb:else />

<div class="blocksubhead">{vb:raw ese_fund_top}</div>

<div class="blockbody"><div class="blockrow">

{vb:raw ese_fund}

</div></div>

</vb:if>

<!-- End Custom Code -->

</vb:if>

    {vb:raw footer}

  </body>

</html>]]>

    </template>

    </templates>

</product>

Vaupell · #2 01-14-2010, 05:02 PM

aparently the IF NOT EXISTS is not doing its job

$vbulletin->db->hide_errors();
$vbulletin->db->query_write("CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX ."data_name
(id int(4) NOT NULL auto_increment, table1 varchar(120) NOT NULL, table2 varchar(100)NOT NULL, PRIMARY KEY (id))");
$vbulletin->db->show_errors();

thats how i would run the table..

but also noticed the install code version is 4.0
but your product code is 1.0

im quite sure the the product code needs to be same version or higher to run
the install code, other way around the product ignores the install code higher than
the product version.

try it, its not sure it will work since the IF NOT EXISTS dont check,
it should if the table exist then skip the step.

Paul M · #3 01-14-2010, 09:20 PM

The error has nothing to do with table creation, its a duplicate key error on updating a record in the template table.

Please post the actual product code, since what you posted above clearly isnt it.

vietfancy · #4 01-15-2010, 12:06 AM

actual code has updated. Thanks

vietfancy · #5 01-17-2010, 09:12 AM

could anyone helps? Thanks

Paul M · #6 01-17-2010, 11:37 AM

I cant see anything wrong with it, nor can i replicate your issue. I can import it multiple times with no errors.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04109 seconds Memory Usage 2,280KB Queries Executed 13 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (1)bbcode_code (1)bbcode_php (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (6)post_thanks_box (6)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (6)post_thanks_postbit_info (6)postbit (6)postbit_onlinestatus (6)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory 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 tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!