can't configure payment processer with 1.8

[ekendra]

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
 

[Dave Greenberg]

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);


[emilyf]

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]

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  ;


[ekendra]

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]

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

[ekendra]

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]

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

[ekendra]

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]

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

[ekendra]

ok. cool. wish i could help.

[emilyf]

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]

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

lobo

[ekendra]

anything happen with this yet? 

[Donald Lobo]

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

lobo