Registry Redux - Occasion Form Not Show Type Of Occasions

[LoOneTx 0]

Hello friends.

 

I install Registry Redux Contribution but in link REGISTY (to create a registry) have a form with:

 

Registry Details

Co-Registrant First Name:

Co-Registrant Last Name:

Occasion Date: (eg. 05/21/1970) required

Occasion: Select Event required

 

 

But in Occasion (Select Event) not have events for selection.

In BD the events are correctly. What the problem?

 

Wait for a help.

Thank you!

[Guest]

Hello friends.

 

I install Registry Redux Contribution but in link REGISTY (to create a registry) have a form with:

 

Registry Details

Co-Registrant First Name:

Co-Registrant Last Name:

Occasion Date: (eg. 05/21/1970) required

Occasion: Select Event required

 

 

But in Occasion (Select Event) not have events for selection.

In BD the events are correctly. What the problem?

 

Wait for a help.

Thank you!

The events are stored in the database. Did you install the SQL?

[accarter 0]

The events are stored in the database. Did you install the SQL?

 

I am having the same problem - I did run the mysql changes.

Thank you,

Allison

[accarter 0]

Just so you know - what was going on was that the install instructions i was using skipped the part where you define functions in /includes/functions.php. The following code was missing:

 

//start gift registry

////

// Function to return all inmate facilities

function tep_get_registry_occasions($pull_down_default_value = true) {

global $languages_id;

if($pull_down_default_value) {

$occassion_array = array(array('id' => '', 'text' => PULL_DOWN_DEFAULT_REGISTRY));

}else{

$occassion_array = array();

}

$occassion_query_string = "select registry_occasion_id, registry_occasion_name from " . TABLE_REGISTRY_OCCASION . " WHERE language_id = '" . $languages_id . "' order by registry_occasion_name";

$occassion_query = tep_db_query($occassion_query_string);

while ($occassion_values = tep_db_fetch_array($occassion_query)) {

$occassion_array[] = array('id' => $occassion_values['registry_occasion_id'],

'text' => $occassion_values['registry_occasion_name']);

}

 

return $occassion_array;

}

 

////

// Function to return all inmate facilities

function tep_get_registry_occasion_name($occasion_id) {

global $languages_id;

$occassion_query_string = "select registry_occasion_name from " . TABLE_REGISTRY_OCCASION . " WHERE language_id = '" . $languages_id . "' AND registry_occasion_id = '" . $occasion_id . "'";

$occassion_query = tep_db_query($occassion_query_string);

$occassion_value = tep_db_fetch_array($occassion_query);

 

return $occassion_value['registry_occasion_name'];

}

 

////

// Function to return name and email address from the registry owner

function tep_get_registry_email_info($registry_owner_id) {

$registry_owner_query_string = "select customers_firstname, customers_lastname, customers_email_address from " . TABLE_CUSTOMERS . " WHERE customers_id = '" . $registry_owner_id . "'";

$registry_owner_query = tep_db_query($registry_owner_query_string);

$registry_owner_value = tep_db_fetch_array($registry_owner_query);

 

return $registry_owner_value;

}

 

function tep_get_registry_customers_id($reg_id){

$registry_customers_id_query_string = "select customers_id from " . TABLE_REGISTRY_PRODUCTS . " WHERE registry_id = '" . $reg_id . "'";

$registry_customers_id_query = tep_db_query($registry_customers_id_query_string);

$registry_customers_id_value = tep_db_fetch_array($registry_customers_id_query);

 

return (int)$registry_customers_id_value['customers_id'];

}

 

function tep_get_registry_owners($reg_id){

 

$registry_owners_query_string = "select c.customers_firstname, c.customers_lastname, r.co_registrant_first_name, r.co_registrant_last_name from " . TABLE_CUSTOMERS . " c, " . TABLE_REGISTRY . " r where r.customers_id = c.customers_id AND r.registry_id = '" . $reg_id . "'";

$registry_owners_query = tep_db_query($registry_owners_query_string);

$registry_owners_value = tep_db_fetch_array($registry_owners_query);

 

return $registry_owners_value;

}

 

function tep_get_default_address($customers_id){

$registry_default_address_id_string = "select c.customers_default_address_id from " . TABLE_CUSTOMERS . " c where c.customers_id = '" . $customers_id . "'";

$registry_default_address_id_query = tep_db_query($registry_default_address_id_string);

$registry_default_address_id_value = tep_db_fetch_array($registry_default_address_id_query);

 

return $registry_default_address_id_value['customers_default_address_id'];

}

//end gift registry

 

 

 

best!

Allison