Mass mail problem

[zolotujin]

<b>Source:</b> Microsoft JET Database Engine<br/><b>Description:</b> No value given for one or more required parameters.
---------------------- Debug Info -------------------------------
0: plib\common_func.php3:160
com->execute(string 'select [id], [name], [createdBy], [sendToResellers], [sendToClients], [sendToDomainUsers], [sendToAdmins], [cr_date] from massmail_templates', NULL null)
1: plib\common_func.php3:160
db_query(string 'select `id`, `name`, `createdBy`, `sendToResellers`, `sendToClients`, `sendToDomainUsers`, `sendToAdmins`, `cr_date` from massmail_templates')
2: plib\mass-mail\MassMailTemplatesList.php:36
MassMailTemplatesList->fetchMassMailTemplatesList()
3: plib\class.cList.php3:105
cList->fetchList()
4: plib\class.cList.php3:124
cList->init()
5: plib\ui\mass-email.php:36
plesk__mass_email->accessItem(string 'GET', NULL null)
6: plib\UIPointer.php:601
UIPointer->access(string 'GET')
7: htdocs\plesk.php:41



Plesk 9.0.1

help this error ... send mass mail.

thanks!!!

 

[Peter Johansson]

I have the same issue when trying to use the mass e-mail function. Here's the error details:

DB query failed: Unknown column 'sendToResellers' in 'field list'
---------------------- Debug Info -------------------------------
0: plib\common_func.php3:170
db_query(string 'select `id`, `name`, `createdBy`, `sendToResellers`, `sendToClients`, `sendToDomainUsers`, `sendToAdmins`, `cr_date` from massmail_templates')
1: plib\mass-mail\MassMailTemplatesList.php:36
MassMailTemplatesList->fetchMassMailTemplatesList()
2: plib\class.cList.php3:105
cList->fetchList()
3: plib\class.cList.php3:124
cList->init()
4: plib\ui\mass-email.php:36
plesk__mass_email->accessItem(string 'GET', NULL null)
5: plib\UIPointer.php:601
UIPointer->access(string 'GET')
6: htdocs\plesk.php:41

Any ideas? When is the next update of Plesk (9.1?) coming?

 

[zolotujin]

Sorry....this problem

I have the same problem, and so far not seen any solution. I
Is difficult to help the staff here at the forum.

Unfortunately I do not know ... need this help too.

 

[Joseph Symon]

Reason:
The "sendToResellers" column is missing in PSA database table 'massmail_templates'.

You need to alter the table to add this column in the massmail_templates table.

Do the following steps to fix the issue.
-----------
1) Backup the plesk database table 'massmail_templates' using mysqldump utility:
cd %plesk_dir%\mysql\bin
mysqldump.exe -u admin -p -P8306 psa massmail_templates massmail_templates.BakSql
2) Alter the table 'massmail_templates' using:
ALTER TABLE massmail_templates add sendToResellers varchar(255) NOT NULL default '';

You can now access the "Mass E-mail Messages" using "Plesk -> Home -> Server -> Mass E-mail Messages (Drop down)".

Have a nice day.
---------------------
Joseph Symon
Bobcares.com
[email protected]