Relationship Graph View Issue Dependency Graph
related to child of duplicate of

View Issue Details

IDProjectCategoryView StatusLast Update
0009229phpList 3 applicationGeneralpublic07-03-07 01:24
ReporterDick Griffin 
PrioritynormalSeveritymajorReproducibilityalways
Status resolvedResolutionno change required 
Product Version2.10.4 
Target VersionFixed in Version 
Summary0009229: With Link tracking on, links are broken in messages sent through list and db errors reported on GUI screens
DescriptionIn the template for the message, the link from the icons should be:
 
http://www.domain_name.com/description/cart.php
 
but in the transmission of the message, the phplist somehow changes that link to be
http://www.domain_name.com/phplist/lists/lt.php?id=eEsaXQ8eVw%3D%3D
in the message as it comes through the Outlook client
 
This seems to be related to the way the [UNSUBSCRIBE]links are being broken too.
Additional Informationit may be a different issue, but when 'process bounces' is triggered, the following db error is reported:

"Database error 1030 while doing query Got error 127 from table handler -----"

When I reviewed the MySQL tables, the php_linktrack table appears to me broken, with the MySQLadmin app reporting it as 'busy'. When a 'repair table' function is executed on the table, nothing happens and the 'in use' message appears in the GUI.
"phplist_linktrack Browse Select Insert Properties Drop Empty in use"

Drilling down to look at the structure of the table reveals:

"Can't open file: 'phplist_linktrack.MYD'. (errno: 144)

Error

SQL-query :

SHOW KEYS FROM `phplist_linktrack`

MySQL said:

Can't open file: 'phplist_linktrack.MYD'. (errno: 144)

Back"
TagsNo tags attached.

Activities

michiel

07-03-07 01:23

manager   ~0024437

the first issue is the tracked link, and should be correct. The encoding will track the click and store it in the database.
the second one is a crashed DB and needs to be corrected on the server.