Mantis - ISSUES

0015423: Criterias don't work with large (22k+) db ("no users found")

I have a database of 50 000 users. With some test users only sending with criterias works fine, but as soon as I import the other e-mails I get this message on sending:

-------
Processing message 2
Looking for users
1 users apply for attributes, now checking lists
No users apply for attributes
Finished this run
Script stage: 6
Finished, Nothing to do
Finished, All done
-------

Plus this error message:

-------
Database error 1064 while doing query You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Fatal Error: Debugging not configured properly
-------

0015422: HELP. Forum Admin Dragonrider cannot log into admin pages

This morning I find that trying to access the phpList forum admin pages results in a Error 403 so I cannot currently log in to block spammers IP/usernames.

Thanks, David (Dragonrider)

0015402: Process Message Send Hangs In Broswer

See - http://mantis.phplist.com/view.php?id=4102 [^]

The described fix does not resolve this issue.

This issue was closed prematurely.

Issue occurs every time I try to process a message.

Messages do get sent but I had to sit up for 15 hours to load the page manually every hour as it just hangs in browser till time out so the meta or js refresh code never gets sent to the browser.

Really annoying, this is the most important part of the software and since I upgraded it is useless.

Is there a way to roll back to a version that works?

0015225: Error when processing bounces

I have not seen this error in previous versions. When I process bounses, the top of the screen generate as normal but at the bottom of the screen, I get the following errors after the "Processed messages will be deleted from mailbox" message.

1) ONLY once - "Database error 2013 while doing query Lost connection to MySQL server during query"

2) About 6 times - "Database error 2006 while doing query MySQL server has gone away".

Help!

0015421: Importing CSV with multiple values for Checkboxgroup crashes with SQL Error

I have a CSV file that I use to import users, the file contains the email, the first name, the last name, and several other single value fields in addition to the field (Course) that is causing the problem which is an attribute defined as a checkboxgroup.

I am trying to import users with multiple values for the course field separating them by ; and adding a space after it.

The user is imported along with all attributes but it crashes on the multi-value attribute Course.

I have added the importcsv to my installation: ref http://mantis.phplist.com/view.php?id=5921 [^]

But I get an error always

"Database error 1064 while doing query You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; CFA) and phplist_user_user_attribute.attributeid = 50' at line 4"

I have tried adding the option id and the option value, all fail with the same error, tried removing the space before the semi column, same issue.

I have attached the csv file for reference..

I have attached my CSV file

0015420: phplist_message message field should be (at least) mediumtext

When sending large HTML messages, they are truncated to 65535 chars. Which can be annoying since this limit is easily reached with inline style generated by some crappy tools.

0015418: phplist constantly requires log in

Hello!
phplist asks for log in each time a page is called up, no matter what action.
This occured just suddenly and has been working 3 weeks ago just fine.
Is this a known bug? Is there any help?
Thank you very much!
Sura

0015273: Check for safe_mode wrong

At 8 occurrences in the code, phplist checks for the PHP Safe Mode like this: "if (ini_get("safe_mode"))". But ini_get("safe_mode") returns "off" which is resolved to true. Thus, phplist always thinks it would run in Safe Mode.

My environment:
PHP Version 5.2.9
System Linux server116 2.6.27-gentoo-r8 #3 SMP Mon Mar 23 02:30:09 CET 2009 i686
Apache Version Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.8k PHP/5.2.9

0015419: Allow MAILQUEUE_THROTTLE to be a decimal value

It can be useful to have a delay between mail send of less than one second. Attached patch allow MAILQUEUE_THROTTLE to be specified as a decimal

0015417: speed up bounce management by optimizing mysql tables and queries to use indices

bounce management will significantly improve in speed by adding an index to the status column of the bounce table.

create index statusindex on phplist_bounce (status(10));

Also, there are a number of queries throughout the phplist scripts which do not make use of the "date" index. Rewriting the query in the manner below makes use of them:

@@ -16,10 +16,10 @@
if (isset($_GET['action']) && $_GET['action']) {
switch($_GET['action']) {
case "deleteunidentified":
- Sql_Query(sprintf('delete from %s where comment = "unidentified bounce" and date_add(date,interval 2 month) < now()',$tables["bounce"]));
+ Sql_Query(sprintf('delete from %s where status = "unidentified bounce" and `date` < date_sub(now(),interval 2 month)',$tables["bounce"]));
break;
case "deleteprocessed":
- Sql_Query(sprintf('delete from %s where comment != "not processed" and date_add(date,interval 2 month) < now()',$tables["bounce"]));
+ Sql_Query(sprintf('delete from %s where comment != "not processed" and `date` < date_sub(now(),interval 2 month)',$tables["bounce"]));
break;
case "deleteall":
Sql_Query(sprintf('delete from %s',$tables["bounce"]));

0015416: "bounce count" on view bounces page does not fully correlate with listed bounces

The bounce count takes a full count of the rows in the bounces table,
however the bounces show below only show bounces where status != "unidentified bounce".

below is a patch for bounces.php.

Note: This will slow the bounces.php script to a crawl when there are a large number of bounces in the table. It is recommended that a index be added to the status column.

mysql query: create index statusindex on phplist_bounce (status(10));

This will speed a number of things up significantly.

@@ -33,7 +33,7 @@
}

# view bounces
-$count = Sql_Query(sprintf('select count(*) from %s',$tables["bounce"]));
+$count = Sql_Query(sprintf('select count(*) from %s where status != "unidentified bounce"',$tables["bounce"]));
$totalres = Sql_fetch_Row($count);
$total = $totalres[0];
$find_url = '';

0015415: "delete unidentified > 2 months" does not work. Delete query is incorrect

query is incorrect in bounces.php

line 19:
Sql_Query(sprintf('delete from %s where comment = "unidentified bounce" and date_add(date,interval 2 month) < now()',$tables["bounce"]));

should be
Sql_Query(sprintf('delete from %s where status = "unidentified bounce" and date_add(date,interval 2 month) < now()',$tables["bounce"]));

I found this in 2.10.4, and it also exists in the current 2.10.10. It may go back earlier.

0015414: Use ckeditor instead of FCKEditor

FCKEditor has changed to ckeditor in the new releases. Ckeditor provides many great functions FCKEditor does not have, so it would be great to include ckeditor in the next release.

0015413: "Delete user" and "delete bounce and go to next" doesn't work

after processing bounces, I open view bounces and click on "show" of the bounce message. It opens, I inspect the bounce message and see that user doesnt exist in remote mail server so I choose "delete user" and "Delete this bounce and go to the next" (select checkboxes) and press "Do the above" button. The page refreshes and I see the same bounce again, the checkbox from "Delete user" is unchecked and bounce still exists. If I do just "Delete this bounce and go to the next" then also nothing happens.

0015412: messages.php displays incorrect total of sent messages

This issue was reported by rrrob on the forum:

==== Start Quote ====

On the page "phplist - list of messages" under the section "status" there is a table that lists, "in this order," total text html PDF both.

Beneath these headings are figures 48, 5, 53, 0, 0

I know how many tests I've sent and I know how many messages were sent, the figures them selves are accurate, but they are in the wrong order.

Currently it is saying there were 48 total, 5 text and 53 html...

But actually there were 53 total, 5 text and 48 html.

I'd like to correct this before the list goes completely live with a couple 1000 users but I haven't been able to find the correct code to swap in order to make this happen.

==== End Quote ====

ref: http://forums.phplist.com/viewtopic.php?f=17&t=30467 [^]

0015411: When uploading images to templates using spaces on the name it does not embedded correctly

When inserting an image in a template, if the name of the image has got spaces in it, it won't get embedded in the email. The source of the email has instead of for a correctly embedded image.

0015410: savechanges() does not detect changes within message body when fckeditor enabled

Under send a message link. When fckeditor is enabled in config.php, changes within the message body are not detected. When fckeditor is disabled changes are detected correctly. I had same behavior using firefox 3.5.7 and internet explorer 8.0.6001 on a windows xp platform. Changes within the message subject are detected correctly both with fckeditor enabled and disabled.

0015409: two lines falsly moved in phplist.css

CSS invalid, because the css-definition for "div#menutable div#menuheader" is inside the css-definition of "a:link"

0015408: A patch unicode support for database connection

It's kind of surprising that phplist doesn't really support non-Latin Unicode. Please make it possible by simply adding this code to admin/mysql.inc:

function Sql_Connect...
...
// custom code - start
if (strcasecmp($GLOBALS['strCharSet'], 'utf-8') == 0)
mysql_query ("SET NAMES 'utf8'");
// custom code - end
return $db;
}

0015302: "Send this user HTML emails" set to 0 when user is added through "list membership"

Steps to reproduce the bug:
1. Click "Lists"
2. Click "View Members" in any mail list
3. Input a NEW user email address and click "Add"
4. System report "No user found with that email"
5. Check the "I prefer to receive emails in HTML format" checkbox
6. Click "Add User" button
7. System report "User Added".
8. Click "Users" and input the new email to find the user
9. The "Send this user HTML emails" is set to 0

0015406: Normal admins cannot delete users in users page

Normal admins can be set in permissions page to have an owner or all value in "users" field.

This implies that admin can delete their own users in users page.

Currently no users are able to be deleted by these admins.

The patch attached enables to admins that have "owner" or "all" value in "users" field to delete their users.

However I think it should be improved so that there is actually a check that an user is owned by the admin (the user in one of the mailing list in which the admin is the mailing list owner).

My patch does not make this checking.

0015407: pagetop seems not to be included

pagetop seems not to be included in any of the admin pages.

I have found this error in revision 1703. If I knew what were the pages involved in this problem I would check new versions of the pages in the svn but I do not which ones they are.

This applies to svn revision 1703.

This might cause problems to proper utf8 webpages display because the charset is never seen by the browser.

0001644: Subject error with UTF-8 encode in Traditional Chinese

I'm trying to use phplist in UTF-8 enviornment with Traditional Chinese language. Everything seems OK but the subject. Some characters of the subject were be translated to no meanful ones. Anyone could please tell me where or which of the scripts I can trying to fix this problem?? I'm still looking into the code..

0015385: Danish translation - backend & frontend

This Danish translation of backend and frontend was made available by helmuth for release 2.10.5:

====== start quote =======

attached you'll find the Danish language pack for version 2.10.5 (da.zip)

danish.zip is an updated and revised version of the danish.inc file

cheers ;)

====== end quote ======

0015383: RSS stripped from message when "Forward A Message to Someone" is used

When a message with a parsed RSS feed in it is forwarded to someone using the "Forward a Message to Someone" link, php list strips the feed from the message.