I use postgres and never add this kind of weird error and it surely come from there...
Cheer! Richard On Tue, Feb 14, 2012 at 10:19 AM, Bruce Wade <[email protected]> wrote: > Yeah that could have been the problem. One of my scripts requires pure SQL > to run and that SQL only works with postgresql. I think one of the other > developers was using sqlite and pushed their database files by accident. > (Started right after a pull) > > > On Tue, Feb 14, 2012 at 7:15 AM, Richard Vézina < > [email protected]> wrote: > >> 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 >>> >> >> > > > -- > -- > Regards, > Bruce Wade > http://ca.linkedin.com/in/brucelwade > http://www.wadecybertech.com > http://www.warplydesigned.com > http://www.fitnessfriendsfinder.com >
