ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Contact form database errors

July 26, 2012 3:09pm

Subscribe [3]
  • #1 / Jul 26, 2012 3:09pm

    kellysims

    123 posts

    We are getting close to launch of a client site and we’re having issues with email being sent from EE. This is a Windows IIS server, and their IT guy and I have not been able to figure this one out.

    Sending emails via Tools > Communicate using SMTP just times out. PHPMail and Sendmail don’t work either. Posting via contact form using Freeform gives the following:

    Error Number: 1364
    
    Field 'weblog_id' doesn't have a default value
    
    INSERT INTO `exp_freeform_entries` (`author_id`, `group_id`, `ip_address`, `entry_date`, `edit_date`, `status`, `form_name`, `name`, `email`, `message`) VALUES (1, '1', '98.112.224.26', 1343329503, 1343329503, 'open', 'Contact Form', 'Kelly', '[email protected]', 'Test')
    
    Filename: C:\inetpub\HSAWebsite\system\codeigniter\system\database\DB_driver.php
    
    Line Number: 330

    We are running EE 2.5.0. Any help on figuring this out would be great.

  • #2 / Jul 26, 2012 3:23pm

    John Henry Donovan

    12339 posts

    Hi Kelly,

    You could try setting these two variables in your config.php file

    $config['email_crlf'] = "\r\n";
    $config['email_newline'] = "\r\n";

    The default SMTP port is 25 in EE. If this is different you can try overriding this via this config

    $config['email_smtp_port'] = "2525";

    EE Docs : Hidden Configuration Variables

    Also make sure you have a return email in your Email Config.
    Turn on Email debugging and try Communicate again and see if that throws an error

    Hope that helps

    John Henry

  • #3 / Jul 26, 2012 6:09pm

    kellysims

    123 posts

    Quick update on this, the fixes from John Henry Donovan didn’t work. I do think it’s a server configuration issue though. After these fixes a few new PHP errors popped up that lead me to check a few more things. The client is working through some fixes on their end, and I have no access to the server so I wait.

  • #4 / Jul 27, 2012 3:55pm

    Kevin Smith

    4784 posts

    Yep, the behavior you noted and then the error shown don’t seem to connect directly to each other. They may have a common problem though, and it sounds like the other PHP errors you’re experiencing might point to that. Have you found out any more from your client?

    I’d also recommend trying out email_test.php under /system/utilities since that takes EE completely out of the equation. (It’s a stand-alone PHP script.) Any results there?

  • #5 / Jul 30, 2012 5:28pm

    kellysims

    123 posts

    No updates on this. email_test.php failed to send, so the client is trying to figure out what the cause is on their end. I appreciate the help on this though!

  • #6 / Jul 31, 2012 1:33pm

    Shane Eckert

    7174 posts

    Hey kellysims,

    Thank you for letting us know!

    We will stay tuned for more!

    Cheers,

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases