matissjanis / oc-mail Goto Github PK

I am getting:

"SQLSTATE[HY000]: General error: 1 near "MODIFY": syntax error (SQL: ALTER TABLE mja_mail_email_log MODIFY code VARCHAR(255) NULL;)" on line 624 of /home/staffcheck/staffcheck-web/vendor/laravel/framework/src/Illuminate/Database/Connection.php

https://www.sqlite.org/lang_altertable.html
the problems are in
make_body_column_nullable.php & make_code_column_nullable.php

The following statements are not supported by sqlite
DB::statement('ALTER TABLE mja_mail_email_log MODIFY body text COLLATE utf8_unicode_ci NULL;');
DB::statement('ALTER TABLE mja_mail_email_log MODIFY body text COLLATE utf8_unicode_ci NOT NULL;');
DB::statement('ALTER TABLE mja_mail_email_log MODIFY code VARCHAR(255) NULL;');
DB::statement('ALTER TABLE mja_mail_email_log MODIFY code VARCHAR(255);');

I did manage to install it by applying the changes manually in the tables, commenting all the above queries out and then running
php artisan october:up
That registered the migrations correctly but of course that might not be an option for others, especially on hosts where you don't have access to the command line.

I am trying to fix this and sent you a pull request

We use OctoberCms Queue for some tasks including sending mails. Mails sent from queue workers don't appear in the maillog. Mails sent appear in the log.

We don't use the Mail::queue method instead we use custom Queues and send Mails via Mail::send method.

Any idea why this happens?

This plugin has caused quite a bit of confusion on the octoberCMS issue tracker. Many were blaming it on October when in reality it turned out to be this plugin. Please refer to this post for more information about this error:

octobercms/october#2242

Here is the exact error that arises when submitting the contact form:

Hi,

How i can clean the Logs to have a fresh installation ?

Thank you.

SQLSTATE[22001]: String data, right truncated: 1406 Date too long for column 'code' at row 1...

when using the Campaign Manager plugin

http://octobercms.com/plugin/responsiv-campaign

plugin is not found in octobercms site

Are there any plans to make an export feature for this? We need the ability to send CSV exports of form data in our projects.

Since updating, I am now getting this exception error when I click on the "Mail log" on the backend.

Bit late for me right now, I'll look into it a bit more to see if it's on my end or the plugin's end. It just started happening after updating to the most recent build of October though so I'm assuming it's the Plugin?

Doesn't work, and no error found. What's wrong? I use PHP mail. The email is successfully sent, but no log there.

Just wondering, does this plugin work with the FormBuilder plugin?

I have installed the plugin and it seems to be working fine without errors, but messages send from the FormBuilder does not get logged..

When sending an email and leaving to field empty an error occurs cause to can not be null.

Hi,
There was an Error when enabling the plugins, I'm using PostgreSql database.
https://drive.google.com/file/d/0B-adqvQw9iQ4U1FvSEdnTnQzak0/view?usp=sharing

For some reason I am getting this error:

When I don't even have [janvince.smallcontactform] installed anywhere. How does your plugin choose which plugin to monitor for email sending/receiving?

website.com/vendor/laravel/framework/src/Illuminate/View/FileViewFinder.php line 112

if (! isset($this->hints[$segments[0]])) {
    throw new InvalidArgumentException("No hint path defined for [{$segments[0]}]."); <!--LINE WITH ERROR-->
}

tried to install this on a new installation

Update failed

"SQLSTATE[HY000]: General error: 1 near "MODIFY": syntax error (SQL: ALTER TABLE mja_mail_email_log MODIFY code VARCHAR(255) NULL;)" on line 624 of [...]\vendor\laravel\framework\src\Illuminate\Database\Connection.php

I deactivated the Rainlab User (or other plugin, which is used the mail sender). When I navigated to mja/mail/mail page, I got the following error message: No hint path defined for [rainlab.user].

You can see the comment thread that I discussed with the other plugin developer here:

Contact Plugin - "Unexpected Type of Array Error"

When I have this plugin enabled and paired up with the Contact Plugin I get the error message:

"Unexpected type of array, should attribute "reply_to" be jsonable?" on line 1064 of vendor/october/rain/src/databse/model.php

Upon disabling this plugin, the contact form worked perfectly fine. It is assumed that this plugin would be used in pair with a contact form plugin and the contact plugin linked appears to be the most popular so hopefully this can get resolved.

Thanks so much for this plugin, it really is phenomenal!

I get this error message, when I save the form.

I use the build in mail sender in afterSave() function.