1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Mass mail problem

Discussion in 'Plesk 9.x for Windows Issue, Fixes, How-To' started by zolotujin, Mar 3, 2009.

  1. zolotujin

    zolotujin Guest

    0
     
    <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!!!
     
  2. Peter Johansson

    Peter Johansson Guest

    0
     
    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?
     
  3. zolotujin

    zolotujin Guest

    0
     
    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.
     
  4. Joseph Symon

    Joseph Symon Guest

    0
     
    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
    jsymonkj@gmail.com
     
Loading...