Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Major
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.3.0
-
Fix Version/s: 4.3.0
-
Component/s: Accounting Integration, CiviMember
-
Labels:None
Description
Membership Dashboard - 'more' -> Renew Membership
Submit
....
(looks like a isotomysql convert needed)
Database Error Code: Incorrect datetime value: '2012' for column 'transaction_date' at row 1, 1292
Backtrace
--------------
#0 /Users/dgg/svn/crm_v4.3/CRM/Core/Error.php(148): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /Users/dgg/svn/crm_v4.3/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /Users/dgg/svn/crm_v4.3/packages/DB.php(968): PEAR_Error->PEAR_Error("DB Error: unknown error", -1, 16, (Array:2), "INSERT INTO civicrm_financial_item (transaction_date , contact_id , descripti...")
#4 /Users/dgg/svn/crm_v4.3/packages/PEAR.php(564): DB_Error->DB_Error(-1, 16, (Array:2), "INSERT INTO civicrm_financial_item (transaction_date , contact_id , descripti...")
#5 /Users/dgg/svn/crm_v4.3/packages/DB/common.php(1903): PEAR->raiseError(NULL, -1, NULL, NULL, "INSERT INTO civicrm_financial_item (transaction_date , contact_id , descripti...", "DB_Error", TRUE)
#6 /Users/dgg/svn/crm_v4.3/packages/DB/mysql.php(898): DB_common->raiseError(-1, NULL, NULL, NULL, "1292 ** Incorrect datetime value: '2012' for column 'transaction_date' at row 1")
#7 /Users/dgg/svn/crm_v4.3/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /Users/dgg/svn/crm_v4.3/packages/DB/common.php(1216): DB_mysql->simpleQuery("INSERT INTO civicrm_financial_item (transaction_date , contact_id , descripti...")
#9 /Users/dgg/svn/crm_v4.3/packages/DB/DataObject.php(2421): DB_common->query("INSERT INTO civicrm_financial_item (transaction_date , contact_id , descripti...")
#10 /Users/dgg/svn/crm_v4.3/packages/DB/DataObject.php(1055): DB_DataObject->_query("INSERT INTO civicrm_financial_item (transaction_date , contact_id , descripti...")
#11 /Users/dgg/svn/crm_v4.3/CRM/Core/DAO.php(287): DB_DataObject->insert()
#12 /Users/dgg/svn/crm_v4.3/CRM/Financial/BAO/FinancialItem.php(120): CRM_Core_DAO->save()
#13 /Users/dgg/svn/crm_v4.3/CRM/Financial/BAO/FinancialItem.php(111): CRM_Financial_BAO_FinancialItem::create((Array:10), NULL, (Array:1))
#14 /Users/dgg/svn/crm_v4.3/CRM/Price/BAO/LineItem.php(292): CRM_Financial_BAO_FinancialItem::add(Object(CRM_Price_BAO_LineItem), Object(CRM_Contribute_BAO_Contribution))
#15 /Users/dgg/svn/crm_v4.3/CRM/Member/BAO/Membership.php(2687): CRM_Price_BAO_LineItem::processPriceSet("98", (Array:1), Object(CRM_Contribute_BAO_Contribution))
#16 /Users/dgg/svn/crm_v4.3/CRM/Member/Form/MembershipRenewal.php(762): CRM_Member_BAO_Membership::recordMembershipContribution((Array:28), (Array:0), "31")
#17 /Users/dgg/svn/crm_v4.3/CRM/Core/Form.php(246): CRM_Member_Form_MembershipRenewal->postProcess()
#