Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: 2_7_0f SMTP and SQL problem

2_7_0f SMTP and SQL problem 14 years 1 month ago #10136

  • Mafra
  • Mafra's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 1
  • Thank you received: 0
Hi I have two problem with the new version (2_7_0f) :
SMTP error on validation :
"The addresses of the following recipients failed"

SQL error (new record from the backend) :
"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 jos_dtregister_fields as df inner join jos_dtregister_field_event 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 "

Somebody can help me ?

Please Log in or Create an account to join the conversation.

2_7_0f SMTP and SQL problem 13 years 10 months ago #12200

  • grey_sheep
  • grey_sheep's Avatar
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 20
  • Thank you received: 0
Hi

I had the same error. It turned out to be an incorrect email address in the paypal field in the pay options tab. Even though it wasn't a paid event, it presumably checked.

Once set to a valid email it was OK

Regards

Jan

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Time to create page: 0.194 seconds