email notification, issue when signup account

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
adam
Posts: 9
Joined: 15 Jul 2011, 09:04

email notification, issue when signup account

Post by adam »

Hello,

I'm having some hard time to configure email notifications of Mantis.
I followed the tutorial of this topic : http://www.mantisbt.org/forums/viewtopi ... =3&t=15398

At signup account step, I get the following error message :
Échec de la requête de base de données. L'erreur renvoyée par la base de données était #1406 : Data too long for column 'subject' at row 1 pour la requête : INSERT INTO mantis_email_table
( email,
subject,
body,
submitted,
metadata)
VALUES
( ?,
?,
?,
?,
?
).
Can you tell me what am I doing wrong ?

Thanks.
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: email notification, issue when signup account

Post by atrol »

Which version of MantisBT do you use?
Did you run admin/check.php ?
Please use Search before posting and read the Manual
adam
Posts: 9
Joined: 15 Jul 2011, 09:04

Re: email notification, issue when signup account

Post by adam »

I'm using the last one, 1.2.5.
I don't have an "admin/check.php" page, but I have an "admin_bak/check.php" page, and this one isn't working.
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: email notification, issue when signup account

Post by atrol »

Did you try temporary renaming admin_bak to admin?
Please use Search before posting and read the Manual
adam
Posts: 9
Joined: 15 Jul 2011, 09:04

Re: email notification, issue when signup account

Post by adam »

Renaming folder in "admin" seems to make the page work.

I have some errors/warnings :
Warning: The configuration option $g_ldap_port is now obsolete
please use $g_ldap_server instead.
I don't find any $g_ldap_port variable in config_inc.php.
Checking MantisBT upload file size is less than php
BAD
I don't think this is really important in my case.
Some Tests Failed. Please correct failed tests before using MantisBT.
This is the last message of the page.
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: email notification, issue when signup account

Post by atrol »

adam wrote:
Warning: The configuration option $g_ldap_port is now obsolete
please use $g_ldap_server instead.
I don't find any $g_ldap_port variable in config_inc.php.
This is a bug in MantisBT, but nothing more than a wrong warning.
adam wrote:
Checking MantisBT upload file size is less than php
BAD
I don't think this is really important in my case.
I agree

Is this a new installation or an upgrade from an earlier version?
Which database do you use?
Please use Search before posting and read the Manual
adam
Posts: 9
Joined: 15 Jul 2011, 09:04

Re: email notification, issue when signup account

Post by adam »

This is a new installation and I'm using a MySQL 5.0 database.
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: email notification, issue when signup account

Post by atrol »

Do you get this problem only when signing up an account, or also when other notification emails are sent?
Did you try using english language settings?
Please use Search before posting and read the Manual
adam
Posts: 9
Joined: 15 Jul 2011, 09:04

Re: email notification, issue when signup account

Post by adam »

I let the default notification options (new case, state change...).
I get this error only at signing up account.
When I try other notification on a test case, I don't get any error message, but I don't have any notification in my email box.


I tried signing up with the application in english, but I get the same error message :
Database query failed. Error received from database was #1406: Data too long for column 'subject' at row 1 for the query: INSERT INTO mantis_email_table
( email,
subject,
body,
submitted,
metadata)
VALUES
( ?,
?,
?,
?,
?
).
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: email notification, issue when signup account

Post by atrol »

Check the stucture of mantis_email_table
Should be
Attachments
email.png
email.png (12.16 KiB) Viewed 20967 times
Please use Search before posting and read the Manual
adam
Posts: 9
Joined: 15 Jul 2011, 09:04

Re: email notification, issue when signup account

Post by adam »

Seems that I have the good structure :
Attachments
table structure
table structure
ps.png (30.57 KiB) Viewed 20962 times
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: email notification, issue when signup account

Post by atrol »

temporary add the following lines to file core/email_api.php after line 448 (before call of email_store)

Code: Select all

var_dump ( $t_subject );
die ("Before mail storage");
Any curios output when trying to signup?
Please use Search before posting and read the Manual
adam
Posts: 9
Joined: 15 Jul 2011, 09:04

Re: email notification, issue when signup account

Post by adam »

I get this message with nothing else on the page :
string(71) "[Gestion des am�liorations et corrections ANF] Enregistrement de compte" Before mail storage
The user is well created, but no email notification.
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: email notification, issue when signup account

Post by atrol »

I have no real idea at the moment.
Check collation of the database column, is it utf8_general_ci ?

Maybe you can try to update your database to a newer version.
Please use Search before posting and read the Manual
adam
Posts: 9
Joined: 15 Jul 2011, 09:04

Re: email notification, issue when signup account

Post by adam »

Seems that I have "latin1_swedish_ci" if I don't mistake.

How can I change the collation database charset ?
Attachments
lang.png
lang.png (62.88 KiB) Viewed 20945 times
Post Reply