Problems with email

[romashka]

Hello everybody!

I try to configure email setting, but when I fill in all the form, then the white list with message "Query Failed:UPDATE outbound_email SET id = '3b3859d7-e61d-970d-d8fc-499e9ca7c81e', name = 'system', type = 'system', user_id = '1', mail_sendtype = 'SMTP', mail_smtptype = 'exchange', mail_smtpserver = '***', mail_smtpport = '25', mail_smtpuser = '***', mail_smtppass = '***', mail_smtpauth_req = 1, mail_smtpssl = 0 WHERE id = '3b3859d7-e61d-970d-d8fc-499e9ca7c81e'::MySQL error 1054: Unknown column 'mail_smtptype' in 'field list'" appears.

What can I do to solve the problem?

[kuske]

Which version do you use?
What is your version history?
Can you post your diagnostic zip here?

[romashka]

Hello, Kuske!

Thank you for your answer.

We used 5.2a version, next we upgraded it to 5.5 and finally to 6.0.1.

But what diagnostic zip you mean? How can I create it?

[andopes]

This missing field should be defined on script metadata/outboundEmailMetaData.php.
Make sure this script exists and this field is defined inside such script.
Go to Admin -> Repair -> Repair Database

Cheers

[romashka]

this file exists and contains:

$dictionary['OutboundEmail'] = array ('table' => 'outbound_email',
	'fields' => array (
		'id' => array (
			'name' => 'id',
			'vname' => 'LBL_ID',
			'type' => 'id',
			'required' => true,
			'reportable' => false,
		),
		'name' => array (
			'name' => 'name',
			'vname' => 'LBL_NAME',
			'type' => 'varchar',
			'len' => 50,
			'required' => true,
			'reportable' => false,
		),
		'type' => array (
			'name' => 'type',
			'vname' => 'LBL_TYPE',
			'type' => 'varchar',
			'len' => 15,
			'required' => true,
			'default' => 'user',
			'reportable' => false,
		),
		'user_id' => array (
			'name' => 'user_id',
			'vname' => 'LBL_USER_ID',
			'type' => 'id',
			'required' => true,
			'reportable' => false,
		),
		'mail_sendtype' => array(
			'name' => 'mail_sendtype',
			'vname' => 'LBL_MAIL_SENDTYPE',
			'type' => 'varchar',
			'len' => 8,
			'required' => true,
			'default' => 'smtp',
			'reportable' => false,
		),
		'mail_smtptype' => array(
			'name' => 'mail_smtptype',
			'vname' => 'LBL_MAIL_SENDTYPE',
			'type' => 'varchar',
			'len' => 20,
			'required' => true,
			'default' => 'other',
			'reportable' => false,
		),
		'mail_smtpserver' => array(
			'name' => 'mail_smtpserver',
			'vname' => 'LBL_MAIL_SMTPSERVER',
			'type' => 'varchar',
			'len' => 100,
			'required' => false,
			'reportable' => false,
		),
		'mail_smtpport' => array(
			'name' => 'mail_smtpport',
			'vname' => 'LBL_MAIL_SMTPPORT',
			'type' => 'int',
			'len' => 5,
			'default' => 0,
			'reportable' => false,
		),
		'mail_smtpuser' => array(
			'name' => 'mail_smtpuser',
			'vname' => 'LBL_MAIL_SMTPUSER',
			'type' => 'varchar',
			'len' => 100,
			'reportable' => false,
		),
		'mail_smtppass' => array(
			'name' => 'mail_smtppass',
			'vname' => 'LBL_MAIL_SMTPPASS',
			'type' => 'varchar',
			'len' => 100,
			'reportable' => false,
		),
		'mail_smtpauth_req' => array(
			'name' => 'mail_smtpauth_req',
			'vname' => 'LBL_MAIL_SMTPAUTH_REQ',
			'type' => 'bool',
			'default' => 0,
			'reportable' => false,
		),
		'mail_smtpssl' => array(
			'name' => 'mail_smtpssl',
			'vname' => 'LBL_MAIL_SMTPSSL',
			'type' => 'int',
			'len' => 1,
			'default' => 0,
			'reportable' => false,
		),
	),
	'indices' => array (
		array(
			'name' => 'outbound_email_pk',
			'type' =>'primary',
			'fields' => array(
				'id'
			)
		),
		array(
			'name' => 'oe_user_id_idx',
			'type' =>'index',
			'fields' => array(
				'id',
				'user_id',
			)
		),
	), /* end indices */
);

[kuske]

You can create the diagnostic package in admin - Diagnostic Tool.

Try to set the log level to debug in admin - System Settings and run an admin - repair - repair database before creating the diagnostic package.

[romashka]

Hello!

I try to repair DB, but I have a mistake:

Executing repair query: Query Failed:ALTER TABLE contracts modify column date_entered datetime NULL , modify column date_modified datetime NULL , ADD INDEX idx_CONTRACT_name (name)::MySQL error 1061: Duplicate key name 'idx_CONTRACT_name'

[romashka]

Any ideas?

[romashka]

Kuske,

Here is TableSchema from the diagnistic file.

[kuske]

I'm confused what happend with your database?

To repair the outbound_email table you can do that in mysql by the command:

ALTER TABLE outbound_email ADD COLUMN mail_smtptype VARCHAR(20) DEFAULT 'other';


But it seems there are some other tables having problems.