CBSub importing baskets from CRM

8 years 1 month ago #280052 by beat
Replied by beat on topic CBSub importing baskets from CRM

activha wrote: The english error is :

'ERROR_IN_LAST_SCHEDULED_TAKS_FOR_THIS_BASKET_BASKE_cc0778' => 'Error in last scheduled taks for this Basket [BASKET_ID] or error in payment scheduling table: Unexpected state (e.g. already executing) or cannot store. This state will be cleared automatically after 3 cron jobs so that a retry can automatically occur.',

and the row is :

INSERT INTO `yq0g1_cbsubs_payment_baskets` (`id`, `user_id`, `owner`, `payment_method`, `gateway_account`, `time_initiated`, `time_updated`, `time_completed`, `time_completed_date`, `time_completed_day_of_week`, `time_completed_yearweek`, `time_completed_yearmonth`, `time_completed_hour`, `shared_secret`, `ip_addresses`, `geo_ip_country_code`, `charset`, `test_ipn`, `address_name`, `address_street`, `address_city`, `address_state`, `address_zip`, `address_country`, `address_country_code`, `address_status`, `first_name`, `last_name`, `payer_business_name`, `payer_name`, `payer_email`, `payer_id`, `payer_status`, `residence_country`, `contact_phone`, `vat_number`, `business`, `item_name`, `item_number`, `quantity`, `receiver_email`, `receiver_id`, `custom`, `invoice`, `proformainvoice`, `memo`, `option_name1`, `option_selection1`, `option_name2`, `option_selection2`, `tax`, `auth_id`, `auth_exp`, `auth_amount`, `auth_status`, `num_cart_items`, `parent_txn_id`, `payment_date`, `payment_status`, `payment_type`, `pending_reason`, `reason_code`, `remaining_settle`, `shipping`, `transaction_entitiy`, `txn_id`, `txn_type`, `receipt_id`, `sale_id`, `exchange_rate`, `mc_currency`, `mc_fee`, `mc_gross`, `mc_handling`, `mc_shipping`, `payment_fee`, `payment_gross`, `settle_amount`, `settle_currency`, `auction_buyer_id`, `auction_closing_date`, `auction_multi_item`, `for_auction`, `subscr_date`, `subscr_effective`, `period1`, `period2`, `period3`, `amount1`, `amount2`, `amount3`, `mc_amount1`, `mc_amount2`, `mc_amount3`, `recurring`, `reattempt`, `retry_at`, `recur_times`, `username`, `password`, `subscr_id`, `case_id`, `case_type`, `case_creation_date`, `recur_times_used`, `reattempts_tried`, `scheduler_state`, `scheduler_next_maturity`, `integrations`, `is_business`, `vat_verification`) VALUES
(1001, 10001, 0, 'offline', 7, '2012-12-04 00:00:00', '2012-12-04 00:00:00', '2012-12-04 00:00:00', '2012-12-04', 2, '2012−W49', '2012-12', 8, '0', '::2', '', 'utf-7', 0, '', 'Chemin Louis Chripaz', 'ECULLY', '', '69130', 'France', 'FR', '', '', 'CIMER', 'CIMER', '', 'cimer@inva', '', 'unverified', '', '04 78 27 3', '', '', 'NegoPME cotisation annuelle', 'ZCRM-1701', 1, '', '', '301', '121439', '', '', '', '', '', '', '43.12000', '', '', '', '', '', '', 'mar. 4 déc. 2012 00:00:00', 'Completed', 'web_accept', '', '', '', '0.00000', '', '', 'web_accept', '', '', '0.00000000', 'EUR', '0.00000', '263.12000', '0.00000', '0.00000', '0.00000', '0.00000', '0.00000', '', '', '', '', '', '', '', '', '', '', '0.00000', '0.00000', '0.00000', '0.00000', '0.00000', '0.00000', 0, 0, '', 0, '', '', '', '', '', '', 0, 0, '', '0000-00-00 00:00:01', '[]', 0, '');

We have imported about 2000 items with this structure.

Can you tell me what needs to be changed in the DB ?
Thanks


This request goes far beyond our regular support. We do not support in our standard support any direct database imports on CBSubs.

In your case, it is most probably the "scheduler_state`, `scheduler_next_maturity` fields that are wrong (compared to non-auto-recuring baskets).

Beat - Community Builder Team Member

Before posting on forums: Read FAQ thoroughly -- Help us spend more time coding by helping others in this forum, many thanks :)
CB links: Our membership - CBSubs - Templates - Hosting - Forge - Send me a Private Message (PM) only for private/confidential info

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.451 seconds

Facebook Twitter LinkedIn