Sure you don't want that at that point. But did you change from sqlite to other backend during developpement it could happen because of that.
Richard On Tue, Feb 14, 2012 at 10:08 AM, Bruce Wade <[email protected]> wrote: > Yeah not sure just hope this doesn't happen when I move to the live > database with over 6000 members. > > > On Tue, Feb 14, 2012 at 6:50 AM, Richard Vézina < > [email protected]> wrote: > >> Surely a desynchronized sequence... >> >> :) >> >> Richard >> >> On Mon, Feb 13, 2012 at 7:45 PM, Bruce Wade <[email protected]> wrote: >> >>> Deleting the database looks to have fixed it. >>> >>> >>> On Mon, Feb 13, 2012 at 2:24 PM, Bruce Wade <[email protected]>wrote: >>> >>>> Yeah I don't think that is the issue because it has >>>> worked several times before, probably a bug in the database I will just >>>> rebuild it and try again. >>>> >>>> >>>> On Mon, Feb 13, 2012 at 2:08 PM, Richard Vézina < >>>> [email protected]> wrote: >>>> >>>>> Try db.commit() between your two insert... Maybe web2py is doing only >>>>> one commit at the end of your function, but since you do insert by hand >>>>> instead of let the form insert your maybe have to commit... >>>>> >>>>> Richard >>>>> >>>>> >>>>> On Mon, Feb 13, 2012 at 4:51 PM, Bruce Wade <[email protected]>wrote: >>>>> >>>>>> Didn't touch psql. there is 3 records in that table already, so I was >>>>>> not sure why it would even default to 1. >>>>>> >>>>>> Here is the code that processes after the form is accepted. My code >>>>>> didn't increment anything just standard web2py calls. >>>>>> >>>>>> ---- >>>>>> if ucashmethod.process(formname='ucash').accepted: >>>>>> """ >>>>>> 1) Check payment amount >>>>>> 2) Check owing amount >>>>>> 3) Make sure payment amount is not greater then owing amount >>>>>> 4) Make sure member has enough ucash to cover the payment >>>>>> amount >>>>>> 5) Complete the order >>>>>> 6) Add to the capital investments >>>>>> 7) Give all the sponsor bonus >>>>>> 8) Redirect to thank you page >>>>>> """ >>>>>> if float(ucash_available) >= >>>>>> float(product_details['product_orders'].owing): >>>>>> print "ucash amount is good" >>>>>> payment_amount = product_details['product_orders'].owing >>>>>> ucash_before = distributor.ucash_balance >>>>>> distributor.ucash_balance -= int(payment_amount) >>>>>> distributor.ucash_balance_available -= int(payment_amount) >>>>>> ucash_after = distributor.ucash_balance >>>>>> >>>>>> product_details['product_orders'].owing -= >>>>>> int(payment_amount) >>>>>> product_details['product_orders'].update_record() >>>>>> distributor.update_record() >>>>>> >>>>>> payment = db.payments.insert( >>>>>> order_id = product_details['product_orders'].id, >>>>>> ack = '', >>>>>> transactionid = '', >>>>>> paymentstatus = 'Completed', >>>>>> pendingreason = 'None', >>>>>> currencycode = 'USD', >>>>>> taxamt = '0.00', >>>>>> paymenttype = 'Youcash', >>>>>> token = 'N/A', >>>>>> version = 1, >>>>>> build = 1, >>>>>> feeamt = '', >>>>>> reasoncode = 'None', >>>>>> amt = payment_amount, >>>>>> correlationid = 'CORRELATIONID', >>>>>> transactiontype = 'Youcash' >>>>>> ) >>>>>> >>>>>> db.cash_journal.insert( >>>>>> transaction_type = UCashChangeType.buy_product, >>>>>> distributor_id = distributor.id, >>>>>> happen_amount = -int(payment_amount), >>>>>> ucash_before = ucash_before, >>>>>> ucash_after = ucash_after, >>>>>> transaction_id = payment, >>>>>> operator_id = distributor.id >>>>>> ) >>>>>> >>>>>> if product_details['product_orders'].owing <= 0: >>>>>> # 1) add product, do bonus calculations >>>>>> x = distributor_engine.addProduct(distributor, >>>>>> product_details['products']) >>>>>> buy_time = >>>>>> distributor_engine.get_valid_buy_times(distributor) >>>>>> >>>>>> if distributor.id == 1: >>>>>> # place member as root >>>>>> #distributor_engine.place_member(None, None, None) >>>>>> >>>>>> distributor_engine.member_purchase_prod_calc(distributor, >>>>>> product_details['products']) >>>>>> elif (db(db.capital_investments.member_id == >>>>>> distributor.id).count() > 1 and x != -1) or ((buy_time==0 or >>>>>> buy_time==1) and distributor.upline_id and distributor.sponsor_id): >>>>>> print "Calculating bonuses" >>>>>> >>>>>> >>>>>> distributor_engine.member_purchase_prod_calc(distributor, >>>>>> product_details['products']) >>>>>> else: >>>>>> session.flash = T("Sorry there is not enough ucash in >>>>>> your account to complete this purchase!") >>>>>> redirect(URL('products','payment/%s' % purchase_uuid)) >>>>>> >>>>>> #session.flash = 'Congrats for your new product' >>>>>> redirect(URL('products','index')) >>>>>> >>>>>> On Mon, Feb 13, 2012 at 1:46 PM, Ron McOuat <[email protected]>wrote: >>>>>> >>>>>>> It is like the sequence for that primary key has started over with a >>>>>>> reset to initial value since the key value that causes the exception is >>>>>>> 1. >>>>>>> To do that I would think you would have to tweak the sequence with psql >>>>>>> while there is data in the table. >>>>>>> >>>>>>> Ron >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> -- >>>>>> Regards, >>>>>> Bruce Wade >>>>>> http://ca.linkedin.com/in/brucelwade >>>>>> http://www.wadecybertech.com >>>>>> http://www.warplydesigned.com >>>>>> http://www.fitnessfriendsfinder.com >>>>>> >>>>> >>>>> >>>> >>>> >>>> -- >>>> -- >>>> Regards, >>>> Bruce Wade >>>> http://ca.linkedin.com/in/brucelwade >>>> http://www.wadecybertech.com >>>> http://www.warplydesigned.com >>>> http://www.fitnessfriendsfinder.com >>>> >>> >>> >>> >>> -- >>> -- >>> Regards, >>> Bruce Wade >>> http://ca.linkedin.com/in/brucelwade >>> http://www.wadecybertech.com >>> http://www.warplydesigned.com >>> http://www.fitnessfriendsfinder.com >>> >> >> > > > -- > -- > Regards, > Bruce Wade > http://ca.linkedin.com/in/brucelwade > http://www.wadecybertech.com > http://www.warplydesigned.com > http://www.fitnessfriendsfinder.com >
