« previous next »
Pages: [1] 2

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

Offline ekendra

  • I post occasionally
  • **
  • Posts: 30
  • Karma: 0
    • krishnafarm.com
can't configure payment processer with 1.8
« on: July 22, 2007, 03: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, 03:53:20 pm by ekendra »
Logged
-------------------
Currently running:
CiviCRM ver 3.1.4
in Drupal
MySQL ver 5.0.90
PHP ver 5.2.13

Offline Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5016
  • Karma: 193
    • My CiviCRM Blog
Re: can't configure payment processer with 1.8
« Reply #1 on: July 23, 2007, 06: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);
Logged
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

My faves: Relative dates in search forms and Scheduled reminders for membership renewal.

Offline emilyf

  • Ask me questions
  • ****
  • Posts: 558
  • Karma: 53
Re: can't configure payment processer with 1.8
« Reply #2 on: July 23, 2007, 08: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!
Logged

Offline Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5016
  • Karma: 193
    • My CiviCRM Blog
Re: can't configure payment processer with 1.8
« Reply #3 on: July 23, 2007, 12: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  ;
Logged
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

My faves: Relative dates in search forms and Scheduled reminders for membership renewal.

Offline ekendra

  • I post occasionally
  • **
  • Posts: 30
  • Karma: 0
    • krishnafarm.com
Re: can't configure payment processer with 1.8
« Reply #4 on: July 23, 2007, 02: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.
Logged
-------------------
Currently running:
CiviCRM ver 3.1.4
in Drupal
MySQL ver 5.0.90
PHP ver 5.2.13

Online Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 12643
  • Karma: 396
    • CiviCRM site
  • CiviCRM version: 4.1
  • CMS version: Drupal 7, Joomla 1.7
  • MySQL version: 5.1.x
  • PHP version: 5.3.x
Re: can't configure payment processer with 1.8
« Reply #5 on: July 23, 2007, 02: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
Logged
Found this reply helpful? Contribute NOW and help improve CiviCRM with the Make it Happen! initiative.

My current favorite is CiviMobile.

Donate NOW

Offline ekendra

  • I post occasionally
  • **
  • Posts: 30
  • Karma: 0
    • krishnafarm.com
Re: can't configure payment processer with 1.8
« Reply #6 on: July 23, 2007, 03: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'.

Logged
-------------------
Currently running:
CiviCRM ver 3.1.4
in Drupal
MySQL ver 5.0.90
PHP ver 5.2.13

Online Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 12643
  • Karma: 396
    • CiviCRM site
  • CiviCRM version: 4.1
  • CMS version: Drupal 7, Joomla 1.7
  • MySQL version: 5.1.x
  • PHP version: 5.3.x
Re: can't configure payment processer with 1.8
« Reply #7 on: July 23, 2007, 03: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
Logged
Found this reply helpful? Contribute NOW and help improve CiviCRM with the Make it Happen! initiative.

My current favorite is CiviMobile.

Donate NOW

Offline ekendra

  • I post occasionally
  • **
  • Posts: 30
  • Karma: 0
    • krishnafarm.com
Re: can't configure payment processer with 1.8
« Reply #8 on: July 23, 2007, 04: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']"]
)
Logged
-------------------
Currently running:
CiviCRM ver 3.1.4
in Drupal
MySQL ver 5.0.90
PHP ver 5.2.13

Online Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 12643
  • Karma: 396
    • CiviCRM site
  • CiviCRM version: 4.1
  • CMS version: Drupal 7, Joomla 1.7
  • MySQL version: 5.1.x
  • PHP version: 5.3.x
Re: can't configure payment processer with 1.8
« Reply #9 on: July 23, 2007, 04: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
Logged
Found this reply helpful? Contribute NOW and help improve CiviCRM with the Make it Happen! initiative.

My current favorite is CiviMobile.

Donate NOW

Offline ekendra

  • I post occasionally
  • **
  • Posts: 30
  • Karma: 0
    • krishnafarm.com
Re: can't configure payment processer with 1.8
« Reply #10 on: July 23, 2007, 05:47:07 pm »
ok. cool. wish i could help.
Logged
-------------------
Currently running:
CiviCRM ver 3.1.4
in Drupal
MySQL ver 5.0.90
PHP ver 5.2.13

Offline emilyf

  • Ask me questions
  • ****
  • Posts: 558
  • Karma: 53
Re: can't configure payment processer with 1.8
« Reply #11 on: July 24, 2007, 04: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.
Logged

Online Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 12643
  • Karma: 396
    • CiviCRM site
  • CiviCRM version: 4.1
  • CMS version: Drupal 7, Joomla 1.7
  • MySQL version: 5.1.x
  • PHP version: 5.3.x
Re: can't configure payment processer with 1.8
« Reply #12 on: July 24, 2007, 12:55:45 pm »

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

lobo
Logged
Found this reply helpful? Contribute NOW and help improve CiviCRM with the Make it Happen! initiative.

My current favorite is CiviMobile.

Donate NOW

Offline ekendra

  • I post occasionally
  • **
  • Posts: 30
  • Karma: 0
    • krishnafarm.com
Re: can't configure payment processer with 1.8
« Reply #13 on: August 08, 2007, 11:38:19 am »
anything happen with this yet?  ::)
Logged
-------------------
Currently running:
CiviCRM ver 3.1.4
in Drupal
MySQL ver 5.0.90
PHP ver 5.2.13

Online Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 12643
  • Karma: 396
    • CiviCRM site
  • CiviCRM version: 4.1
  • CMS version: Drupal 7, Joomla 1.7
  • MySQL version: 5.1.x
  • PHP version: 5.3.x
Re: can't configure payment processer with 1.8
« Reply #14 on: August 08, 2007, 12:56:10 pm »

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

lobo
Logged
Found this reply helpful? Contribute NOW and help improve CiviCRM with the Make it Happen! initiative.

My current favorite is CiviMobile.

Donate NOW
Pages: [1] 2
« previous next »