Author Topic: problems with custom search and membership type listing (Read 1257 times)

noraD · June 24, 2008, 04:04:36 am

Hello,

I tried to modifiy the custom search to get a Membership Types and Member Address Data Listing - but it don't get it and I'm not that experienced with PHP and SQL.
Maybe you can help me -
^{Database Error Code: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') JOIN civicrm_membership_type AS mtype ON mem.membership_type_id=m' at line 14, 1064}
I attach my modified MembershipListing

thanx n

speleo · June 24, 2008, 04:33:05 am

Looks like your SQL FROM statement has unmatched brackets (line 143)

civicrm_contact contact
LEFT JOIN civicrm_address ca ON (ca.contact_id = contact.id AND ca.is_primary = 1)
LEFT JOIN civicrm_membership AS mem ON contact.id=mem.contact_id)
JOIN civicrm_membership_type AS mtype ON mem.membership_type_id=mtype.id AND mem.status_id!=4)
JOIN civicrm_membership_log AS mlog ON mem.end_date=mlog.end_date

noraD · June 24, 2008, 05:20:40 am

sorry - I solved the problem,
forgot the brackets in line 143
^{function from( ) {
return "
((((}

greets
n

CiviCRM Community Forums (archive)

News:

Author Topic: problems with custom search and membership type listing (Read 1257 times)

noraD

problems with custom search and membership type listing

speleo

Re: problems with custom search and membership type listing

noraD

Re: problems with custom search and membership type listing