Author Topic: Price Set Export - DB Error: no such field (Read 1969 times)

gholt · June 05, 2011, 01:02:51 pm

I'm getting an error when I run the custom search "Price Set Details for Event Participants." I had a DB Error like this with a different field once in the past, and figured out that I hadn't run the upgrade script. I got the advice to go ahead and upgrade to the new release and run the upgrade script, and that took care of the problem.

So I just upgraded from 3.4.1 to 3.4.2, and I'm still getting the following error.

Code: [Select]

Database Error Code: Unknown column 'price_field_3' in 'field list', 1054
Additional Details:

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

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => 
UPDATE civicrm_temp_custom_8cabdf18a42c0990f64828df03b7ab5a
SET price_field_1 = 1,price_field_3 = 1,price_field_6 = 1,price_field_8 = 1,price_field_12 = 1,price_field_16 = 1,price_field_47 = 1
WHERE participant_id = 2;
 [nativecode=1054 ** Unknown column 'price_field_3' in 'field list']
    [type] => DB_Error
    [user_info] => 
UPDATE civicrm_temp_custom_8cabdf18a42c0990f64828df03b7ab5a
SET price_field_1 = 1,price_field_3 = 1,price_field_6 = 1,price_field_8 = 1,price_field_12 = 1,price_field_16 = 1,price_field_47 = 1
WHERE participant_id = 2;
 [nativecode=1054 ** Unknown column 'price_field_3' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="
UPDATE civicrm_temp_custom_8cabdf18a42c0990f64828df03b7ab5a
SET price_field_1 = 1,price_field_3 = 1,price_field_6 = 1,price_field_8 = 1,price_field_12 = 1,price_field_16 = 1,price_field_47 = 1
WHERE participant_id = 2;
 [nativecode=1054 ** Unknown column 'price_field_3' in 'field list']"]
)

The civicrm_domain.version in the database confirms that it is updated to 3.4.2. The Price Set Export works fine on the Demo Site, so I'm guessing that it's not a bug. But since I'm new here, I wouldn't be the judge of that.

When I got a DB Error in the past, speleo was kind enough to give me the following link as a solution.
http://wiki.civicrm.org/confluence/display/CRMDOC40/Ensuring+Schema+Integrity+on+Upgrades
But to be honest, those instructions are a little scary for my level of experience.

So I'm looking for advice on other options of where to look next. Any advice would be very much appreciated.

gholt · June 06, 2011, 09:05:53 pm

Whew! I didn't have to rebuild the structure of the database!

I figured it was possible that the records got messed up when I did some test registrations and then changed some of the fields in the profiles and price sets. So I found and deleted all of the participants and test participants, and it's been working fine.

So, the rule I'm working from (just in case it helps someone else) is that if I need to make any more changes, I'll delete all participants before I do any more test registrations.

Lesson learned. I think. (So far?)

petednz · July 10, 2011, 04:37:06 pm

am also hitting this but not sure the solution you suggest works for me - though it was worth the try.

My error is

Code: [Select]

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

Code: [Select]

UPDATE civicrm_temp_custom_087fd819756069da38451940a4460f3f
SET price_field_1 = 1
WHERE participant_id = 2;
 [nativecode=1054 ** Unknown column 'price_field_1' in 'field list']

Odd thing to me is the Price Field ID =1 isn't in the Price Set that is used for the Event I am trying to run the search for.
Any pointers anyone?

tamarackmedia · January 03, 2012, 02:01:00 pm

I'm getting a similar error as noted above on a new install of Civi (3.4.7 on Drupal 6.15). I installed Civi and set up several events, all using the same price set. In setting up the price fields, I disabled a few that didn't do what I wanted. I registered several test registrants and tested the Price Set Custom Search. All worked perfectly.

Then, some changes needed to be made to pricing, so we disabled some more fields, copied some price sets and edited their fields. Now, I have 7 events, each using one of 3 price sets. I went to use the Price Set Custom Search and got the error as described above. This happens for every event, with slightly different tables referenced. I deleted all test participant records. No help. I even created a brand new price set and tested it on one of the events and got the same error.

This is for a non-profit conference with registration hoping to start this week. We want to make sure we have this configured properly so that the reporting can be used. Any ideas? I don't have coding experience.

(I tried to post an example of the error I'm getting, but it says I can't post links. There don't appear to be any links in there? Anyway, it's very similar to the above error, with different field numbers and temp file number. Thanks!

tamarackmedia · January 03, 2012, 02:39:11 pm

A bit more...when I create a new event and use an existing price set, I get the error. When I create a copy of an existing price set, I get the error. However, when I create a new event and price set, it works fine, just as before to error appeared.

tamarackmedia · January 04, 2012, 05:53:00 am

Okay, I think I may have found a fix here and this will likely be helpful to others with this issue. It's not enough just to delete participants. In searching for participants, you also need to check the Find Test Participants filter, which may turn up other participants to delete. This seemed to open the Price Set Custom Search back up for me. For good measure, I went in and looked at the participant table and found several records still there, all marked as Test. I deleted those as well.

Donald Lobo · January 04, 2012, 07:29:51 pm

wouldnt fixing the price set custom search code to exclude all test participants fix the issue? If so, can you investigate and submit a patch that does the needful

lobo

tamarackmedia · January 05, 2012, 05:24:58 am

It would fix part of the issue, I think. As I was getting the error from what seemed to be a modification to a price set after registrants had signed up, that larger piece would still be an issue.

For the exclusion of test participants I'm happy to help. I have no php skills...is that required to submit a patch? If I can't do the patch, I could at least recreate the problem on the demo site and submit a bug report if that's helpful. Let me know.

Donald Lobo · January 05, 2012, 10:02:24 am

yes, the patch and improvements would require php/mysql/civicrm skills

would really help the project if you can get a developer from your org to look at the code and contribute a few patches to improve price set custom search and export

thanx

lobo

tamarackmedia · January 05, 2012, 10:23:10 am

I'll see if we can find someone to help us do that. Thanks!

petednz · July 26, 2012, 09:11:29 pm

I think another circumstance that can cause this is if changes are made to the Label of a price set option after people have already registered

CiviCRM Community Forums (archive)

News:

Author Topic: Price Set Export - DB Error: no such field (Read 1969 times)

gholt

Price Set Export - DB Error: no such field

gholt

Re: Price Set Export - DB Error: no such field

petednz

Re: Price Set Export - DB Error: no such field

tamarackmedia

Re: Price Set Export - DB Error: no such field

tamarackmedia

Re: Price Set Export - DB Error: no such field

tamarackmedia

Re: Price Set Export - DB Error: no such field

Donald Lobo

Re: Price Set Export - DB Error: no such field

tamarackmedia

Re: Price Set Export - DB Error: no such field

Donald Lobo

Re: Price Set Export - DB Error: no such field

tamarackmedia

Re: Price Set Export - DB Error: no such field

petednz

Re: Price Set Export - DB Error: no such field