Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Errors Newsletter Manager and mail().


limipl

Recommended Posts

I have the two following errors, what's happen ?

I run win XP (SMTP and CRLF set).

thanks for your help.

 

Newsletter Manager:

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 '-20, 20' at line 1

 

select newsletters_id, title, length(content) as content_length, module, date_added, date_sent, status, locked from newsletters order by date_added desc limit -20, 20

 

[TEP STOP]

 

 

Mail:

Warning: mail(): Failed to connect to mailserver at "localhost" port 25, verify your "SMTP" and "smtp_port" setting in php.ini or use ini_set() in c:\program files\easyphp1-8\www\catalog\includes\classes\email.php on line 500

 

Warning: Cannot modify header information - headers already sent by (output started at c:\program files\easyphp1-8\www\catalog\includes\classes\email.php:500) in c:\program files\easyphp1-8\www\catalog\includes\functions\general.php on line 29

Link to comment
Share on other sites

  • 2 weeks later...

Open your php.ini file located in the Windows directory.

 

Goto the mail function

 

Replace localhost with the adress of your mailserver, the same you use for your email.

Replace the email adress in sendmail_from with your own adress, remove the semicolon at the beginning of the line

 

[mail function]

; For Win32 only.

SMTP = localhost <- replace this with your smtp server

smtp_port = 25

 

; For Win32 only.

sendmail_from = [email protected] <- replace this with your email adress

 

If there are semicolons at the beginning of the line remove them like above.

 

Restart your server and it should work.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...