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 CiviContribute (Moderator: Donald Lobo) »
  • Non-recoverable error after I hit the donation button.
Pages: [1]

Author Topic: Non-recoverable error after I hit the donation button.  (Read 1707 times)

liza.s

  • I’m new here
  • *
  • Posts: 15
  • Karma: 0
Non-recoverable error after I hit the donation button.
January 19, 2008, 06:59:30 pm
I have CiviCRM 1.8 installed (sorry, but I am not running PHP4 and upgrading right now is out of the question, so don't even suggest it :)

So, I have a donation page set up. I put in my information and such. I get to the second page where the transaction record appears. I hit ENTER (or whatever it is that starts the payment process) and I get the following error :

Quote
Sorry. A non-recoverable error has occurred.

Could not find location id

Location ID?

Any and all help on this will be greatly appreciated it.

I'm on deadline  :-\

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: Non-recoverable error after I hit the donation button.
January 19, 2008, 09:16:27 pm

Can you check if you have a Location Type of 'Billing'. I suspect not, which means there are some larger issues with your installation.

We added the Billing location type in v1.7 and this was part of the 1.6 -> 1.7 upgrade script. Here's the relevant part from that upgrade script:


-- /*******************************************************
-- *
-- * Insert Billing location type (used for billing address
-- * entered in online contribution forms)
-- *
-- *******************************************************/

        SELECT @domain_id := id from civicrm_domain;
    INSERT INTO `civicrm_location_type` ( `domain_id`, `name`, `vcard_name`, `description`, `is_reserved`, `is_active` )
    VALUES
        ( @domain_id, 'Billing', NULL, 'Billing Address location', 1, 1 );

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

liza.s

  • I’m new here
  • *
  • Posts: 15
  • Karma: 0
Re: Non-recoverable error after I hit the donation button.
January 19, 2008, 09:47:24 pm
UPDATE:

So I just noticed those are DB values.

I do have that table in there. Always had.

Here's the issue I had with this DB : It would not take either the "SELECT @domain_id" commands nor would it recognize the "NULL" for the domain_id.

I had to manually insert the domain_id in order to install the DB.

Quote
-- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 19, 2008 at 11:48 PM
-- Server version: 4.1.11
-- PHP Version: 4.4.7
--
-- Database: `ns2008`
--

-- --------------------------------------------------------

--
-- Table structure for table `civicrm_location_type`
--

CREATE TABLE `civicrm_location_type` (
  `id` int(10) unsigned NOT NULL auto_increment COMMENT 'Location Type ID',
  `domain_id` int(10) unsigned NOT NULL default '0',
  `name` varchar(64) collate utf8_unicode_ci default NULL COMMENT 'Location Type Name.',
  `vcard_name` varchar(64) collate utf8_unicode_ci default NULL COMMENT 'vCard Location Type Name.',
  `description` varchar(255) collate utf8_unicode_ci default NULL COMMENT 'Location Type Description.',
  `is_reserved` tinyint(4) default NULL COMMENT 'Is this location type a predefined system location?',
  `is_active` tinyint(4) default NULL COMMENT 'Is this property active?',
  `is_default` tinyint(4) default NULL COMMENT 'Is this location type the default?',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `UI_name_domain_id` (`name`,`domain_id`),
  KEY `FK_civicrm_location_type_domain_id` (`domain_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;

--
-- Dumping data for table `civicrm_location_type`
--

INSERT INTO `civicrm_location_type` VALUES (5, 1, 'Billing', NULL, 'Billing Address location', 1, 1, 0);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `civicrm_location_type`
--
ALTER TABLE `civicrm_location_type`
  ADD CONSTRAINT `FK_civicrm_location_type_domain_id` FOREIGN KEY (`domain_id`) REFERENCES `civicrm_domain` (`id`);


Any other ideas?



« Last Edit: January 19, 2008, 11:20:10 pm by liza.s »

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: Non-recoverable error after I hit the donation button.
January 20, 2008, 08:40:11 am

1. not sure what version of civicrm you started with? i'm pretty sure u did not start with 1.8

2. considering your upgrade script(s) from 1.6 -> 1.7 -> 1.8, might not have completed (or even started), i suspect your db is potentially in an inconsistent state and might not really reflect what our current schema is

3. I highly recommend you get some help from the professional services list and get someone to check the db structure and ensure it matches the 1.8 db structure

4. You need to add a 'Billing' location type to your location types which can be found in Administer CiviCRM menu. However, i think this is just an early indicator of some serious db consistency issues

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

liza.s

  • I’m new here
  • *
  • Posts: 15
  • Karma: 0
Re: Non-recoverable error after I hit the donation button.
January 20, 2008, 09:28:22 am
Thanks lobo, but I didn't upgrade from a previous version. I did a fresh install of 1.8.11536 Drupal PHP4 (and this is from the version doc within CiviCRM).

I do have a billing location type but I cannot choose one. In the schema you gave me, "Is Reserved" is marked off. So there is no way for me to choose one in the Admin panel.

Anyhow. I'll try to install the DB again before I contact a vendor.

/ liza

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: Non-recoverable error after I hit the donation button.
January 20, 2008, 05:31:46 pm

liza:

if this is a new install and you have the Billing location type, then i'm not sure whats causing the error. Based on the error message, i assumed this might be a upgraded db

not sure what is causing this specific bug.

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

liza.s

  • I’m new here
  • *
  • Posts: 15
  • Karma: 0
Re: Non-recoverable error after I hit the donation button.
January 21, 2008, 08:34:37 am
GRRRR.

I just found out the cause of the problem.
I am running an old version of Apache.

 :P
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviContribute (Moderator: Donald Lobo) »
  • Non-recoverable error after I hit the donation button.

This forum was archived on 2017-11-26.