CiviCRM Community Forums (archive)

I have been trying to make this work for quite some time now and I just can't figure out what I'm doing wrong.
I've set up 4 membership types but everytime I try to add a membership or edit a membership I get the following error.  I can enter membership information only if I import it from a csv file, only I can't get the dates to come out right.  The only compatible date format I can get to work is MM/DD/YY, but when I import an end date of 06/01/09 it puts it in as 06/01/1909.  I've tried not importing the end date and letting it calculate it, but then it uses the member since date, not the start date.  Either way I end up with an expired membership that I can't edit.  I've tried to edit the database directly through Myphp Admin but the only place I can find is 'membership log' and changing it here doesn't seem to have any impact. 
Any help would be appreciated...


backTrace

/home/birming6/public_html/Members/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php, backtrace, 260
/home/birming6/public_html/Members/administrator/components/com_civicrm/civicrm/CRM/Utils/Type.php, fatal, 260
/home/birming6/public_html/Members/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php, validate, 906
/home/birming6/public_html/Members/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php, composeQuery, 859
/home/birming6/public_html/Members/administrator/components/com_civicrm/civicrm/CRM/Contact/BAO/Contact/Location.php, executeQuery, 71
/home/birming6/public_html/Members/administrator/components/com_civicrm/civicrm/CRM/Member/Form/Membership.php, getEmailDetails, 605
/home/birming6/public_html/Members/administrator/components/com_civicrm/civicrm/CRM/Core/Form.php, postProcess, 247
/home/birming6/public_html/Members/administrator/components/com_civicrm/civicrm/CRM/Core/StateMachine.php, mainProcess, 166
/home/birming6/public_html/Members/administrator/components/com_civicrm/civicrm/CRM/Core/QuickForm/Action/Next.php, perform, 63
/home/birming6/public_html/Members/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/home/birming6/public_html/Members/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/home/birming6/public_html/Members/administrator/components/com_civicrm/civicrm/CRM/Core/Controller.php, handle, 232
/home/birming6/public_html/Members/administrator/components/com_civicrm/civicrm/CRM/Member/Page/Tab.php, run, 177
/home/birming6/public_html/Members/administrator/components/com_civicrm/civicrm/CRM/Member/Page/Tab.php, edit, 219
/home/birming6/public_html/Members/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php, run, 197
/home/birming6/public_html/Members/administrator/components/com_civicrm/admin.civicrm.php, invoke, 45
/home/birming6/public_html/Members/administrator/components/com_civicrm/admin.civicrm.php, civicrm_invoke, 22
/home/birming6/public_html/Members/libraries/joomla/application/component/helper.php, require_once, 162
/home/birming6/public_html/Members/administrator/includes/application.php, renderComponent, 130
/home/birming6/public_html/Members/administrator/index.php, dispatch, 67
/home/birming6/public_html/Members/administrator/index2.php, include, 14

Sorry. A non-recoverable error has occurred.
is not of the type Integer

Return to home page.

So far that is the only compatible date format I have been able to find between excel and civicrm...
Most of excels other formats for the month allow a single digit in them which civicrm doesn't seem to like.
I tried the Month - dd - year format for excel and checked as input for civicrm and it errors on import saying format isn't correct (and it's converted it to d - month -two digit year on the error.csv form) (and all the places it errors have a single digit for month again).

Why can't I edit or add a membership from the interface instead of only through the import?

OK, well here's what I get when I follow the link you sent....

backTrace

/var/www/drupal-6.civicrm.org/public/sites/sandbox.civicrm.org/modules/civicrm/CRM/Core/Error.php, backtrace, 260
/var/www/drupal-6.civicrm.org/public/sites/sandbox.civicrm.org/modules/civicrm/CRM/Utils/Request.php, fatal, 108
/var/www/drupal-6.civicrm.org/public/sites/sandbox.civicrm.org/modules/civicrm/CRM/Contact/Page/View.php, retrieve, 100
/var/www/drupal-6.civicrm.org/public/sites/sandbox.civicrm.org/modules/civicrm/CRM/Member/Page/Tab.php, preProcess, 189
/var/www/drupal-6.civicrm.org/public/sites/sandbox.civicrm.org/modules/civicrm/CRM/Core/Invoke.php, run, 197
/var/www/drupal-6.civicrm.org/public/sites/sandbox.civicrm.org/modules/civicrm/drupal/civicrm.module, invoke, 342
, civicrm_invoke,
/var/www/drupal-6.civicrm.org/public/includes/menu.inc, call_user_func_array, 348
/var/www/drupal-6.civicrm.org/public/index.php, menu_execute_active_handler, 18

unrecoverable error
    Sorry. A non-recoverable error has occurred.

    Could not find valid value for cid

    Return to home page.