Trying to manually add records to the back end to replace those lost in the sauce causes a SQL error. Not sure if this might be related to the record display issue I posted a half hour ago.
An error has occurred.
1064 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 'and (fe.showed in(1,3) or (fe.showed =-1 and df.showed in(1,3))) and df.publishe' at line 3 SQL=Select fe.id as key1, fe.* , df.id as key2 , df.* , if(fe.showed =-1, fe.showed,fe.showed) as showed , if(fe.showed =-1, fe.required,fe.required) as required ,if(fe.showed =-1, fe.group_behave ,fe.group_behave ) as group_behave From jcms_dtregister_fields as df inner join jcms_dtregister_field_event_archive as fe on fe.field_id = df.id where fe.event_id= and (fe.showed in(1,3) or (fe.showed =-1 and df.showed in(1,3))) and df.published=1 order by ordering
Please advise.
