I'm using Reportico 4.4 with a MySql database 5.6. I had a few reports written in Reportico. They worked fine, and I haven't changed them in a few years. Recently I discovered that the reports no longer seem to work.
They're invoked from the following URL:
Instead of a report, the user receives the messages:
--Unable To Continue:
--Notice: A non well formed numeric value encountered
--Main Report Query - Error: Query Failed
The Query is then displayed
SELECT CONCAT ( f.family_last_name, ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', 'Entry Date:', ' ', DATE_FORMAT(f.created_date,'%b %d %Y %r'), ' ', ' ', ' ', ' ', 'Family_key:', ' ', LPAD(f.prim_key, 5, '0') ) family, f.address Address, CONCAT (f.city, ' ', f.state, ' ', f.zip ) City_State_Zip, f.home_phone Home_Phone, f.home_email Home_eMail, m.relationship Relationship, m.last_name Member_Last, m.first_name Member_First, m.email eMail, m.cell Cell, m.occupation_skills occupation, CONCAT(m.member_type, ' ', ' ', case m.member_type when 'Adult' then CONCAT('Age Range: ', m.age_range) when 'Child' then CONCAT('D.O.B.: ', DATE_FORMAT(m.dob,'%b %d %Y')) end) Age FROM susanna_parishioner.family f LEFT JOIN susanna_parishioner.member m ON f.prim_key = m.family_fkey Where f.prim_key = "40" ORDER BY f.prim_key DESC, m.prim_key
Status 0 -
It seems that the parameter of "40" is being passed from the URL into the report because the "40" is included in the Where clause. Also, If I just copy the Query from the user's error message and run it directly against the MYSQL db, the query produces expected results.
Any idea why this Reportico report stopped working?
By the way, my old Username of "Phil" didn't work for a login, so I created this new one. Do logins get deleted after a certain amount of time?
Many Thanks for your help.