CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • can't configure payment processer with 1.8
Pages: [1] 2

Author Topic: can't configure payment processer with 1.8  (Read 10905 times)

ekendra

  • Guest
can't configure payment processer with 1.8
July 22, 2007, 04:51:36 pm

Everything seemed to work until i went to register for an event. an error came up that there was no payment processor. (paypal was set up before i upgraded) when i go to add one i get this:


  Sorry. A non-recoverable error has occurred.

    Could not find payment processor meta information

below is the debugging info.

backTrace

/home/my_domain/public_html/modules/civicrm/CRM/Core/Error.php, backtrace, 239
/home/my_domain/public_html/modules/civicrm/CRM/Admin/Form/PaymentProcessor.php, fatal, 77
/home/my_domain/public_html/modules/civicrm/CRM/Core/Form.php, preProcess, 283
/home/my_domain/public_html/modules/civicrm/CRM/Core/QuickForm/Action/Display.php, buildForm, 98
/home/my_domain/public_html/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 195
/home/my_domain/public_html/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 95
/home/my_domain/public_html/modules/civicrm/CRM/Core/Controller.php, handle, 213
/home/my_domain/public_html/modules/civicrm/CRM/Core/Page/Basic.php, run, 314
/home/my_domain/public_html/modules/civicrm/CRM/Core/Page/Basic.php, edit, 159
/home/my_domain/public_html/modules/civicrm/CRM/Admin/Page/PaymentProcessor.php, run, 122
/home/my_domain/public_html/modules/civicrm/CRM/Core/Invoke.php, run, 701
/home/my_domain/public_html/modules/civicrm/CRM/Core/Invoke.php, admin, 93
/home/my_domain/public_html/modules/civicrm/drupal/civicrm.module, invoke, 288
/home/my_domain/public_html/includes/menu.inc, civicrm_invoke, 418
/home/my_domain/public_html/includes/menu.inc, call_user_func_array, 418
/home/my_domain/public_html/index.php, menu_execute_active_handler, 15

unrecoverable error
 
« Last Edit: July 22, 2007, 04:53:20 pm by ekendra »

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: can't configure payment processer with 1.8
July 23, 2007, 07:14:14 am
It looks like the 1.7 to 1.8 upgrade sql script isn't populating the required DB records in the civicrm_payment_processor_type table. I assume you ran sql/civicrm_upgradedb_v1.7_v1.8_41.mysql to upgrade the DB - and I don't see the inserts which would be needed in the current 1.8 revision.

Please check if that table is empty - it should have 7 rows, one for each supported processor. If it's empty, you should be able to run the INSERT below to fix the problem. I'll look at fixing the upgrade script.

Code: [Select]
INSERT INTO `civicrm_payment_processor_type`
 (domain_id, name, title, description, is_active, is_default, user_name_label, password_label, signature_label, subject_label, class_name, url_site_default, url_recur_default, url_button_default, url_site_test_default, url_recur_test_default, url_button_test_default, billing_mode, is_recur )
VALUES
 (@domain_id,'Dummy','Dummy Payment Processor',NULL,1,1,'User Name',NULL,NULL,NULL,'Payment_Dummy',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL),
 (@domain_id,'PayPal_Standard','PayPal - Website Payments Standard',NULL,1,0,'Merchant Account Email',NULL,NULL,NULL,'Payment_PayPalImpl','https://www.paypal.com/','https://www.paypal.com/',NULL,'https://www.sandbox.paypal.com/','https://www.sandbox.paypal.com/',NULL,4,1),
 (@domain_id,'PayPal','PayPal - Website Payments Pro',NULL,1,0,'User Name','Password','Signature',NULL,'Payment_PayPalImpl','https://www.paypal.com/',NULL,'https://www.paypal.com/en_US/i/btn/btn_xpressCheckout.gif','https://www.sandbox.paypal.com/',NULL,'https://www.paypal.com/en_US/i/btn/btn_xpressCheckout.gif',3,NULL),
 (@domain_id,'PayPal_Express','PayPal - Express',NULL,1,0,'User Name','Password','Signature',NULL,'Payment_PayPalImpl','https://www.paypal.com/',NULL,'https://www.paypal.com/en_US/i/btn/btn_xpressCheckout.gif','https://www.sandbox.paypal.com/',NULL,'https://www.paypal.com/en_US/i/btn/btn_xpressCheckout.gif',3,NULL),
 (@domain_id,'Google_Checkout','Google Checkout',NULL,1,0,'Merchant ID','Key',NULL,NULL,'Payment_Google','https://checkout.google.com/',NULL,'http://checkout.google.com/buttons/checkout.gif','https://sandbox.google.com/checkout',NULL,'http://sandbox.google.com/checkout/buttons/checkout.gif',4,NULL),
 (@domain_id,'Moneris','Moneris',NULL,1,0,'User Name','Password','Store ID',NULL,'Payment_Moneris','https://www3.moneris.com/',NULL,NULL,'https://esqa.moneris.com/',NULL,NULL,1,1),
 (@domain_id,'AuthNet_AIM','Authorize.Net - AIM',NULL,1,0,'API Login','Payment Key','MD5 Hash',NULL,'Payment_AuthorizeNet','https://secure.authorize.net/gateway/transact.dll','https://api.authorize.net/xml/v1/request.api',NULL,'https://secure.authorize.net/gateway/transact.dll','https://apitest.authorize.net/xml/v1/request.api',NULL,1,1);
Protect your investment in CiviCRM by  becoming a Member!

emilyf

  • Ask me questions
  • ****
  • Posts: 696
  • Karma: 54
  • CiviCRM version: 2.x - 4.x
  • CMS version: Drupal 5, 6, 7
Re: can't configure payment processer with 1.8
July 23, 2007, 09:09:44 am
I just upgrade to 1.8 today, and I can confirm this behavior. However, upon running that query, I got this error:
Code: [Select]
Error

SQL query:

INSERT INTO `civicrm_payment_processor_type` (
domain_id,
name,
title,
description,
is_active,
is_default,
user_name_label,
password_label,
signature_label,
subject_label,
class_name,
url_site_default,
url_recur_default,
url_button_default,
url_site_test_default,
url_recur_test_default,
url_button_test_default,
billing_mode,
is_recur
)
VALUES (
@domain_id , 'Dummy', 'Dummy Payment Processor', NULL , 1, 1, 'User Name', NULL , NULL , NULL , 'Payment_Dummy', NULL , NULL , NULL , NULL , NULL , NULL , 1, NULL
), (
@domain_id , 'PayPal_Standard', 'PayPal - Website Payments Standard', NULL , 1, 0, 'Merchant Account Email', NULL , NULL , NULL , 'Payment_PayPalImpl', 'https://www.paypal.com/', 'https://www.paypal.com/', NULL , 'https://www.sandbox.paypal.com/', 'https://www.sandbox.paypal.com/', NULL , 4, 1
), (
@domain_id , 'PayPal', 'PayPal - Website Payments Pro', NULL , 1, 0, 'User Name', 'Password', 'Signature', NULL , 'Payment_PayPalImpl', 'https://www.paypal.com/', NULL , 'https://www.paypal.com/en_US/i/btn/btn_xpressCheckout.gif', 'https://www.sandbox.paypal.com/', NULL , 'https://www.paypal.com/en_US/i/btn/btn_xpressCheckout.gif', 3, NULL
), (
@domain_id , 'PayPal_Express', 'PayPal - Express', NULL , 1, 0, 'User Name', 'Password', 'Signature', NULL , 'Payment_PayPalImpl', 'https://www.paypal.com/', NULL , 'https://www.paypal.com/en_US/i/btn/btn_xpressCheckout.gif', 'https://www.sandbox.paypal.com/', NULL , 'https://www.paypal.com/en_US/i/btn/btn_xpressCheckout.gif', 3, NULL
), (
@domain_id , 'Google_Checkout', 'Google Checkout', NULL , 1, 0, 'Merchant ID', 'Key', NULL , NULL , 'Payment_Google', 'https://checkout.google.com/', NULL , 'http://checkout.google.com/buttons/checkout.gif', 'https://sandbox.google.com/checkout', NULL , 'http://sandbox.google.com/checkout/buttons/checkout.gif', 4, NULL
), (
@domain_id , 'Moneris', 'Moneris', NULL , 1, 0, 'User Name', 'Password', 'Store ID', NULL , 'Payment_Moneris', 'https://www3.moneris.com/', NULL , NULL , 'https://esqa.moneris.com/', NULL , NULL , 1, 1
), (
@domain_id , 'AuthNet_AIM', 'Authorize.Net - AIM', NULL , 1, 0, 'API Login', 'Payment Key', 'MD5 Hash', NULL , 'Payment_AuthorizeNet', 'https://secure.authorize.net/gateway/transact.dll', 'https://api.authorize.net/xml/v1/request.api', NULL , 'https://secure.authorize.net/gateway/transact.dll', 'https://apitest.authorize.net/xml/v1/request.api', NULL , 1, 1
)

MySQL said: Documentation
#1054 - Unknown column 'url_recur_default' in 'field list'

Help is appreciated!

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: can't configure payment processer with 1.8
July 23, 2007, 01:08:29 pm
Thanks for testing this... apparently the upgrade script has several problems (civicrm_upgradedb_v1.7_v1.8_41.mysql) due to some late changes in the Payment Processor code - one of which you're hitting below. I've re-opened the corresponding issue in the bug-tracker - so you can follow this to see when the fix(es) are committed:

http://issues.civicrm.org/jira/browse/CRM-2002

In the meantime, if you want to forge ahead, you can try dropping the civicrm_payment_processor_type table and then recreating it using this SQL snippet:

Code: [Select]
CREATE TABLE civicrm_payment_processor_type (


     id int unsigned NOT NULL AUTO_INCREMENT  COMMENT 'Payment Processor Type ID',
     domain_id int unsigned NOT NULL   COMMENT 'Which Domain owns this payment processor.',
     name varchar(64)    COMMENT 'Payment Processor Name.',
     title varchar(64)    COMMENT 'Payment Processor Name.',
     description varchar(255)    COMMENT 'Payment Processor Description.',
     is_active tinyint    COMMENT 'Is this processor active?',
     is_default tinyint    COMMENT 'Is this processor the default?',
     user_name_label varchar(255)    ,
     password_label varchar(255)    ,
     signature_label varchar(255)    ,
     subject_label varchar(255)    ,
     class_name varchar(255)    ,
     url_site_default varchar(255)    ,
     url_recur_default varchar(255)    ,
     url_button_default varchar(255)    ,
     url_site_test_default varchar(255)    ,
     url_recur_test_default varchar(255)    ,
     url_button_test_default varchar(255)    ,
     billing_mode int unsigned NOT NULL   COMMENT 'Billing Mode',
     is_recur tinyint    COMMENT 'Can process recurring contributions'
,
    PRIMARY KEY ( id )
 
    ,     UNIQUE INDEX UI_name(
        name
  )
 
,     
     CONSTRAINT FK_civicrm_payment_processor_type_domain_id FOREIGN KEY (domain_id) REFERENCES civicrm_domain(id)
 
)  ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci  ;
Protect your investment in CiviCRM by  becoming a Member!

ekendra

  • Guest
Re: can't configure payment processer with 1.8
July 23, 2007, 03:32:53 pm
forging ahead ....

I tried dropping the 'civicrm_payment_processor_type' table and using the recommended code to recreate it. this went ok. then i went up further to grab the code to populate the table with default data. no errors so far.

but still nothing shows up in administer 'civicrm/global settings/payment processers' - instead it prompts me to add a processer. when i go to do that i get this page (see attached image) with nothing in the drop down menu.

something doesn't seem normal to me.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: can't configure payment processer with 1.8
July 23, 2007, 03:56:40 pm

Can you please wait for a day or so while we fix the upgrade script. Looks like the upgrade script is also missing values for payment processor type

Thanx for testing this part of the code :( apologies for the bugginess

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

ekendra

  • Guest
Re: can't configure payment processer with 1.8
July 23, 2007, 04:54:13 pm
ok. attached is a screen shot of phpmyadmin. as you can see, something is there but still not showing up in the list of payment processors via 'global settings'.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: can't configure payment processer with 1.8
July 23, 2007, 04:56:57 pm

can u update the domain_id to 1 (most likely this is your domain_id, if not set it to the value u have in your civicrm.settings.php file) in the below table.

thanx

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

ekendra

  • Guest
Re: can't configure payment processer with 1.8
July 23, 2007, 05:50:05 pm
ok. changed the domain_id to 1 for every row. then the options showed up in the drop-down menu. when i go to save the settings i get this:

backTrace

/home/domain/public_html/modules/civicrm/CRM/Core/Error.php, backtrace, 148
/home/domain/public_html/modules/civicrm/packages/PEAR.php, handle, 901
/home/domain/public_html/modules/civicrm/packages/PEAR.php, call_user_func, 901
/home/domain/public_html/modules/civicrm/packages/DB.php, PEAR_Error, 888
/home/domain/public_html/modules/civicrm/packages/PEAR.php, DB_Error, 563
/home/domain/public_html/modules/civicrm/packages/DB/common.php, raiseError, 1849
/home/domain/public_html/modules/civicrm/packages/DB/mysql.php, raiseError, 894
/home/domain/public_html/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 324
/home/domain/public_html/modules/civicrm/packages/DB/common.php, simpleQuery, 1162
/home/domain/public_html/modules/civicrm/packages/DB/DataObject.php, query, 2344
/home/domain/public_html/modules/civicrm/packages/DB/DataObject.php, _query, 1033
/home/domain/public_html/modules/civicrm/CRM/Core/DAO.php, insert, 257
/home/domain/public_html/modules/civicrm/CRM/Admin/Form/PaymentProcessor.php, save, 315
/home/domain/public_html/modules/civicrm/CRM/Admin/Form/PaymentProcessor.php, updatePaymentProcessor, 280
/home/domain/public_html/modules/civicrm/CRM/Core/StateMachine.php, postProcess, 166
/home/domain/public_html/modules/civicrm/CRM/Core/QuickForm/Action/Next.php, perform, 63
/home/domain/public_html/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 195
/home/domain/public_html/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 95
/home/domain/public_html/modules/civicrm/CRM/Core/Controller.php, handle, 213
/home/domain/public_html/modules/civicrm/CRM/Core/Page/Basic.php, run, 314
/home/domain/public_html/modules/civicrm/CRM/Core/Page/Basic.php, edit, 159
/home/domain/public_html/modules/civicrm/CRM/Admin/Page/PaymentProcessor.php, run, 122
/home/domain/public_html/modules/civicrm/CRM/Core/Invoke.php, run, 701
/home/domain/public_html/modules/civicrm/CRM/Core/Invoke.php, admin, 93
/home/domain/public_html/modules/civicrm/drupal/civicrm.module, invoke, 288
/home/domain/public_html/includes/menu.inc, civicrm_invoke, 418
/home/domain/public_html/includes/menu.inc, call_user_func_array, 418
/home/domain/public_html/index.php, menu_execute_active_handler, 15


Settings - Payment Processor

unrecoverable error
    Sorry. A non-recoverable error has occurred.

    Database Error Code: Unknown column 'url_recur' in 'field list', 1054

    Return to CiviCRM menu.

Error Details:

Array
(
    [callback] => Array
        (
           
  • => CRM_Core_Error
    • [1] => handle
            )

       
Code: [Select]
=> -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_payment_processor (domain_id , name , description , payment_processor_type , is_active , is_default , is_test , user_name , password , signature , url_site , url_recur , subject , class_name , billing_mode , is_recur ) VALUES ( 1 , 'test' , '' , 'PayPal_Standard' ,  1 ,  1 ,  0 , 'donations@mihet.org' ,  NULL ,  NULL , 'https://www.paypal.com/' , 'https://www.paypal.com/' ,  NULL , 'Payment_PayPalImpl' ,  4 ,  1 )  [nativecode=1054 ** Unknown column 'url_recur' in 'field list']
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_payment_processor (domain_id , name , description , payment_processor_type , is_active , is_default , is_test , user_name , password , signature , url_site , url_recur , subject , class_name , billing_mode , is_recur ) VALUES ( 1 , 'test' , '' , 'PayPal_Standard' ,  1 ,  1 ,  0 , 'donations@mihet.org' ,  NULL ,  NULL , 'https://www.paypal.com/' , 'https://www.paypal.com/' ,  NULL , 'Payment_PayPalImpl' ,  4 ,  1 )  [nativecode=1054 ** Unknown column 'url_recur' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_payment_processor (domain_id , name , description , payment_processor_type , is_active , is_default , is_test , user_name , password , signature , url_site , url_recur , subject , class_name , billing_mode , is_recur ) VALUES ( 1 , 'test' , '' , 'PayPal_Standard' ,  1 ,  1 ,  0 , 'donations@mihet.org' ,  NULL ,  NULL , 'https://www.paypal.com/' , 'https://www.paypal.com/' ,  NULL , 'Payment_PayPalImpl' ,  4 ,  1 )  [nativecode=1054 ** Unknown column 'url_recur' in 'field list']"]
)

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: can't configure payment processer with 1.8
July 23, 2007, 05:53:53 pm

We will release a new version in the next day or two to address this and other issues. Trying to fix this via the forums is just not very efficient. we need to do some more QA and testing of the script

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

ekendra

  • Guest
Re: can't configure payment processer with 1.8
July 23, 2007, 06:47:07 pm
ok. cool. wish i could help.

emilyf

  • Ask me questions
  • ****
  • Posts: 696
  • Karma: 54
  • CiviCRM version: 2.x - 4.x
  • CMS version: Drupal 5, 6, 7
Re: can't configure payment processer with 1.8
July 24, 2007, 05:21:52 am
Kind of a newbie question here, but since it's related to the upgrade script, does that mean I will be able to just run the new upgrade script over my current 1.8 installation, or do I need to revert to 1.7 and start again? Thanks.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: can't configure payment processer with 1.8
July 24, 2007, 01:55:45 pm

You will need to revert to your 1.7 database and start again. Sorry for the hassles

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

ekendra

  • Guest
Re: can't configure payment processer with 1.8
August 08, 2007, 12:38:19 pm
anything happen with this yet?  ::)

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: can't configure payment processer with 1.8
August 08, 2007, 01:56:10 pm

please download the latest beta and give it a go. let us know the results :)

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions
Pages: [1] 2
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • can't configure payment processer with 1.8

This forum was archived on 2017-11-26.