PHPBB2 - problem with MySQL

[Person]

The last version of converter (still some bugs)

* private messages - inbox is not OK
* private messages - labels (one blank label)

phpbb2_to_smf_2006_08_24.zip

[pkeffect]

Just ran that new zip.

Beautiful!

No errors.

Thank you!


--pkeffect

[Person]

No errors.

Yes, but you will have corrupted private messages ... I'm waiting for fix ...

[Person]

If you want to set input charset:

Original code in file convert.php:

Code Select Expand

// Persist?
if (empty($db_persist))
mysql_connect($db_server, $db_user, $db_passwd);
else
mysql_pconnect($db_server, $db_user, $db_passwd);


Modified file (input/output charset is set to "UTF8")

Code Select Expand

// Persist?
if (empty($db_persist))
mysql_connect($db_server, $db_user, $db_passwd);
else
mysql_pconnect($db_server, $db_user, $db_passwd);

// UTF8
mysql_query("SET NAMES 'UTF8'");
mysql_query("SET CHARACTER SET 'UTF8'");

I think that it works 


These bugs are open:
* private messages - inbox messages ase not shown
* private messages - labels (one blank label)

[Person]

I think that I have solved these bugs
Fixed files: phpbb2_to_smf_2006_08_25.zip

Changed from previous version:
Original:

Code Select Expand

/******************************************************************************/
--- Converting personal messages (step 2)...
/******************************************************************************/

TRUNCATE {$to_prefix}pm_recipients;

---* {$to_prefix}pm_recipients
SELECT
pm.privmsgs_id AS ID_PM, pm.privmsgs_to_userid AS ID_MEMBER,
pm.privmsgs_type = 5 AS is_read, pm.privmsgs_type IN (2, 4) AS deleted,
'' AS labels
FROM ({$from_prefix}privmsgs AS pm, {$from_prefix}privmsgs_text AS pmt)
LEFT JOIN {$from_prefix}users AS uf ON (uf.user_id = pm.privmsgs_from_userid)
WHERE pmt.privmsgs_text_id = pm.privmsgs_id;
---*

Fixed:

Code Select Expand

/******************************************************************************/
--- Converting personal messages (step 2)...
/******************************************************************************/

TRUNCATE {$to_prefix}pm_recipients;

---* {$to_prefix}pm_recipients
SELECT
pm.privmsgs_id AS ID_PM, pm.privmsgs_to_userid AS ID_MEMBER,
pm.privmsgs_type = 5 AS is_read, pm.privmsgs_type IN (2, 4) AS deleted,
'-1' AS labels
FROM ({$from_prefix}privmsgs AS pm, {$from_prefix}privmsgs_text AS pmt)
LEFT JOIN {$from_prefix}users AS uf ON (uf.user_id = pm.privmsgs_from_userid)
WHERE pmt.privmsgs_text_id = pm.privmsgs_id;
---*

Changed default value of column labels from '' to '-1'.

Now should works 

[pkeffect]

Can I just run the part for the PM's alone and if so how would I go about doing that?

I would rather not go through eveything again.


--pk

[Ferny]

Great fix Person. I got that error and putting a '-1' in 'labels' column fixed it!!

There's still another minor bug. In the step 2, substep 10, it says something about that modSetting is not defined or something like that (I don't remember what said exactly). The line affected (in convert.php) is:

Code Select Expand

$filename = $modSettings['custom_avatar_dir'] . '/' . $row['filename'];

Although I got this error, the forum seems to have been converted successfully. I'll try to repair this error, but at the moment I recommend to use phpbb2_to_smf_2006_08_25.zip (see two posts ago).

Ferny

[Ferny]

Can I just run the part for the PM's alone and if so how would I go about doing that?

I would rather not go through eveything again.


--pk

If you have phpmyadmin, you only have to run this query in your database:

UPDATE smf_pm_recipients SET labels = -1

(change prefix if needed)

[pkeffect]

You sir rock, ty.

On another note, didn't know where to ask, maybe someone could point me somewhere.

Is there a way to migrate post count stats up through the child hierarchy to the index page? Total listed for all sub cats ect.

I thought the was an option in 1.0.8 but maybe I was dreaming. Not that I am running 1.0.8 now...


--pk

[Person]

Can I just run the part for the PM's alone and if so how would I go about doing that?

This should work:

Replace your phpbb2_to_smf.sql file with this text only & start convert.php again:

Code Select Expand

/* ATTENTION: You don't need to run or use this file!  The convert.php script does everything for you! */

/******************************************************************************/
---~ name: "phpBB2"
/******************************************************************************/
---~ version: "SMF 1.1 RC3"
---~ settings: "/extension.inc", "/config.php"
---~ defines: IN_PHPBB
---~ from_prefix: "`$dbname`.$table_prefix"
---~ table_test: "{$from_prefix}users"


/******************************************************************************/
--- Converting personal messages (step 2)...
/******************************************************************************/

TRUNCATE {$to_prefix}pm_recipients;

---* {$to_prefix}pm_recipients
SELECT
pm.privmsgs_id AS ID_PM, pm.privmsgs_to_userid AS ID_MEMBER,
pm.privmsgs_type = 5 AS is_read, pm.privmsgs_type IN (2, 4) AS deleted,
'-1' AS labels
FROM ({$from_prefix}privmsgs AS pm, {$from_prefix}privmsgs_text AS pmt)
LEFT JOIN {$from_prefix}users AS uf ON (uf.user_id = pm.privmsgs_from_userid)
WHERE pmt.privmsgs_text_id = pm.privmsgs_id;
---*


[Ferny]

Another fix to solve this error: Notice: Undefined variable: modSettings in [path]convert.php on line 1374

This error should only occur if you do the change in the way avatars are imported, which is in the second part of this post. If you don't do it, you'll not see this error, because the affected code will never be executed. But as I consider it a bug, I'll give the correction:

In convert.php find:

Code Select Expand

while ($row = mysql_fetch_assoc($request))
{
if ($row['attachmentType'] == 1)
$filename = $modSettings['custom_avatar_dir'] . '/' . $row['filename'];
else
$filename = getAttachmentFilename($row['filename'], $row['ID_ATTACH']);
// Probably not one of the converted ones, then?
if (!file_exists($filename))
continue;

$size = @getimagesize($filename);
if (!empty($size) && !empty($size[0]) && !empty($size[1]))
convert_query("
UPDATE {$to_prefix}attachments
SET
width = " . (int) $size[0] . ",
height = " . (int) $size[1] . "
WHERE ID_ATTACH = $row[ID_ATTACH]
LIMIT 1");
}

Replace it:

Code Select Expand

while ($row = mysql_fetch_assoc($request))
{
if ($row['attachmentType'] == 1)
{
$request2 = convert_query("
SELECT value
FROM {$to_prefix}settings
WHERE variable = 'custom_avatar_dir'
LIMIT 1");
list ($custom_avatar_dir) = mysql_fetch_row($request2);
mysql_free_result($request2);

$filename = $custom_avatar_dir . '/' . $row['filename'];
}
else
$filename = getAttachmentFilename($row['filename'], $row['ID_ATTACH']);
// Probably not one of the converted ones, then?
if (!file_exists($filename))
continue;

$size = @getimagesize($filename);
$filesize = @filesize($filename);
if (!empty($size) && !empty($size[0]) && !empty($size[1]) && !empty($filesize))
convert_query("
UPDATE {$to_prefix}attachments
SET
size = " . (int) $filesize . ",
width = " . (int) $size[0] . ",
height = " . (int) $size[1] . "
WHERE ID_ATTACH = $row[ID_ATTACH]
LIMIT 1");
}

This code updates filesize, width and height of uploaded avatars in custom avatar dir. Filesize is not updated in the original code, I've added it.



The following is not a fix, just another way to import uploaded avatars!!!

If you see sql file on "Converting members" section, you'll notice that avatars are converted like attachments, not like avatars (attachmentType is 0 and should be 1), and they're placed in the same directory as attachments. Although it works, I don't like this so I made one change. If you want avatars to be converted like uploaded avatars and placed in custom uploaded avatars dir, do this change in sql file:

Find:

Code Select Expand

/******************************************************************************/
--- Converting members...
/******************************************************************************/

TRUNCATE {$to_prefix}members;
TRUNCATE {$to_prefix}attachments;

---* {$to_prefix}members
---{
// Got the board timezone?
if (!isset($board_timezone))
{
$request2 = convert_query("
SELECT config_value
FROM {$from_prefix}config
WHERE config_name = 'board_timezone'
LIMIT 1");
list ($board_timezone) = mysql_fetch_row($request2);
mysql_free_result($request2);

// Find out where uploaded avatars go (attachments dir.)
$request2 = convert_query("
SELECT value
FROM {$to_prefix}settings
WHERE variable = 'attachmentUploadDir'
LIMIT 1");
list ($smf_attachments_dir) = mysql_fetch_row($request2);
mysql_free_result($request2);

$request2 = convert_query("
SELECT config_value
FROM {$from_prefix}config
WHERE config_name = 'avatar_path'
LIMIT 1");
$phpbb_avatar_upload_path = $_POST['path_from'] . '/' . mysql_result($request2, 0, 'config_value');
mysql_free_result($request2);
}

// timeOffset = phpBB user TZ - phpBB board TZ.
$row['timeOffset'] = $row['timeOffset'] - $board_timezone;

if ($row['user_avatar_type'] == 0)
$row['avatar'] = '';
// If the avatar type is uploaded (type = 1) copy avatar as an attachment with the correct name.
elseif ($row['user_avatar_type'] == 1 && strlen($row['avatar']) > 0)
{
$smf_avatar_filename = 'avatar_' . $row['ID_MEMBER'] . strrchr($row['avatar'], '.');
copy($phpbb_avatar_upload_path . '/' . $row['avatar'], $smf_attachments_dir . '/' . $smf_avatar_filename);

convert_query("
INSERT INTO {$to_prefix}attachments
(ID_MSG, ID_MEMBER, filename)
VALUES (0, $row[ID_MEMBER], SUBSTRING('" . addslashes($smf_avatar_filename) . "', 1, 255))");
$row['avatar'] = '';
}
elseif ($row['user_avatar_type'] == 3)
$row['avatar'] = substr('gallery/' . $row['avatar'], 0, 255);
unset($row['user_avatar_type']);

$row['signature'] = preg_replace('~\[size=([789]|[012]\d)\]~i', '[size=$1px]', $row['signature']);
if ($row['signature_uid'] != '')
$row['signature'] = preg_replace('~(:u:|:1:|:)' . preg_quote($row['signature_uid'], '~') . '~i', '', $row['signature']);
$row['signature'] = substr($row['signature'], 0, 65534);
unset($row['signature_uid']);
---}
SELECT
u.user_id AS ID_MEMBER, SUBSTRING(u.username, 1, 80) AS memberName,
SUBSTRING(u.username, 1, 255) AS realName,
SUBSTRING(u.user_password, 1, 64) AS passwd, u.user_lastvisit AS lastLogin,
u.user_regdate AS dateRegistered,
SUBSTRING(u.user_from, 1, 255) AS location,
u.user_posts AS posts, IF(u.user_level = 1, 1, mg.ID_GROUP) AS ID_GROUP,
u.user_new_privmsg AS instantMessages,
SUBSTRING(u.user_email, 1, 255) AS emailAddress,
u.user_unread_privmsg AS unreadMessages,
SUBSTRING(u.user_msnm, 1, 255) AS MSN,
SUBSTRING(u.user_aim, 1, 16) AS AIM,
SUBSTRING(u.user_icq, 1, 255) AS ICQ,
SUBSTRING(u.user_yim, 1, 32) AS YIM,
SUBSTRING(u.user_website, 1, 255) AS websiteTitle,
SUBSTRING(u.user_website, 1, 255) AS websiteUrl,
u.user_allow_viewonline AS showOnline, u.user_timezone AS timeOffset,
IF(u.user_viewemail = 1, 0, 1) AS hideEmail, u.user_avatar AS avatar,
REPLACE(u.user_sig, '\n', '<br />') AS signature,
u.user_sig_bbcode_uid AS signature_uid, u.user_avatar_type,
u.user_notify_pm AS pm_email_notify, u.user_active AS is_activated,
'' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS messageLabels,
'' AS personalText, '' AS timeFormat, '' AS usertitle, '' AS memberIP,
'' AS secretQuestion, '' AS secretAnswer, '' AS validation_code,
'' AS additionalGroups, '' AS smileySet, '' AS passwordSalt,
'' AS memberIP2
FROM {$from_prefix}users AS u
LEFT JOIN {$from_prefix}ranks AS r ON (r.rank_id = u.user_rank AND r.rank_special = 1)
LEFT JOIN {$to_prefix}membergroups AS mg ON (BINARY mg.groupName = CONCAT('phpBB ', r.rank_title))
WHERE u.user_id != -1
GROUP BY u.user_id;
---*

Replace it:

Code Select Expand

/******************************************************************************/
--- Converting members...
/******************************************************************************/

TRUNCATE {$to_prefix}members;
TRUNCATE {$to_prefix}attachments;

---* {$to_prefix}members
---{
// Got the board timezone?
if (!isset($board_timezone))
{
$request2 = convert_query("
SELECT config_value
FROM {$from_prefix}config
WHERE config_name = 'board_timezone'
LIMIT 1");
list ($board_timezone) = mysql_fetch_row($request2);
mysql_free_result($request2);

// Find out where uploaded avatars go (uploaded avatars dir)
$request2 = convert_query("
SELECT value
FROM {$to_prefix}settings
WHERE variable = 'custom_avatar_dir'
LIMIT 1");
list ($custom_avatar_dir) = mysql_fetch_row($request2);
mysql_free_result($request2);

$request2 = convert_query("
SELECT config_value
FROM {$from_prefix}config
WHERE config_name = 'avatar_path'
LIMIT 1");
$phpbb_avatar_upload_path = $_POST['path_from'] . '/' . mysql_result($request2, 0, 'config_value');
mysql_free_result($request2);
}

// timeOffset = phpBB user TZ - phpBB board TZ.
$row['timeOffset'] = $row['timeOffset'] - $board_timezone;

if ($row['user_avatar_type'] == 0)
$row['avatar'] = '';
// If the avatar type is uploaded (type = 1) copy avatar with the correct name.
elseif ($row['user_avatar_type'] == 1 && strlen($row['avatar']) > 0)
{
$smf_avatar_filename = 'avatar_' . $row['ID_MEMBER'] . strrchr($row['avatar'], '.');
@copy($phpbb_avatar_upload_path . '/' . $row['avatar'], $custom_avatar_dir . '/' . $smf_avatar_filename);

convert_query("
INSERT INTO {$to_prefix}attachments
(ID_MSG, ID_MEMBER, filename, attachmentType)
VALUES (0, $row[ID_MEMBER], SUBSTRING('" . addslashes($smf_avatar_filename) . "', 1, 255), 1)");
$row['avatar'] = '';
}
elseif ($row['user_avatar_type'] == 3)
$row['avatar'] = substr('gallery/' . $row['avatar'], 0, 255);
unset($row['user_avatar_type']);

$row['signature'] = preg_replace('~\[size=([789]|[012]\d)\]~i', '[size=$1px]', $row['signature']);
if ($row['signature_uid'] != '')
$row['signature'] = preg_replace('~(:u:|:1:|:)' . preg_quote($row['signature_uid'], '~') . '~i', '', $row['signature']);
$row['signature'] = substr($row['signature'], 0, 65534);
unset($row['signature_uid']);
---}
SELECT
u.user_id AS ID_MEMBER, SUBSTRING(u.username, 1, 80) AS memberName,
SUBSTRING(u.username, 1, 255) AS realName,
SUBSTRING(u.user_password, 1, 64) AS passwd, u.user_lastvisit AS lastLogin,
u.user_regdate AS dateRegistered,
SUBSTRING(u.user_from, 1, 255) AS location,
u.user_posts AS posts, IF(u.user_level = 1, 1, mg.ID_GROUP) AS ID_GROUP,
u.user_new_privmsg AS instantMessages,
SUBSTRING(u.user_email, 1, 255) AS emailAddress,
u.user_unread_privmsg AS unreadMessages,
SUBSTRING(u.user_msnm, 1, 255) AS MSN,
SUBSTRING(u.user_aim, 1, 16) AS AIM,
SUBSTRING(u.user_icq, 1, 255) AS ICQ,
SUBSTRING(u.user_yim, 1, 32) AS YIM,
SUBSTRING(u.user_website, 1, 255) AS websiteTitle,
SUBSTRING(u.user_website, 1, 255) AS websiteUrl,
u.user_allow_viewonline AS showOnline, u.user_timezone AS timeOffset,
IF(u.user_viewemail = 1, 0, 1) AS hideEmail, u.user_avatar AS avatar,
REPLACE(u.user_sig, '\n', '<br />') AS signature,
u.user_sig_bbcode_uid AS signature_uid, u.user_avatar_type,
u.user_notify_pm AS pm_email_notify, u.user_active AS is_activated,
'' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS messageLabels,
'' AS personalText, '' AS timeFormat, '' AS usertitle, '' AS memberIP,
'' AS secretQuestion, '' AS secretAnswer, '' AS validation_code,
'' AS additionalGroups, '' AS smileySet, '' AS passwordSalt,
'' AS memberIP2
FROM {$from_prefix}users AS u
LEFT JOIN {$from_prefix}ranks AS r ON (r.rank_id = u.user_rank AND r.rank_special = 1)
LEFT JOIN {$to_prefix}membergroups AS mg ON (BINARY mg.groupName = CONCAT('phpBB ', r.rank_title))
WHERE u.user_id != -1
GROUP BY u.user_id;
---*

IMPORTANT: if you want to do this change, BEFORE converting your forum you should go to SMF control panel, and in Avatar settings you need to change this:

Upload avatars to... -> Specific directory
Upload directory -> [Select the directory you want]

This is necessary in order to create 'custom_avatar_dir' entry in settings table. And you need to do the change in convert.php which is above.



This is updated converter only with the change in convert.php
http://ultrashare.net/hosting/fl/c37ccc563f/

This is updated converter with changes in convert.php and sql file:
http://ultrashare.net/hosting/fl/92752746ad/

I don't get more errors... if you see another one please tell it.

Ferny

[Person]

I have one small problem with Private Messages.
When I run convert script I get one unread private message in my inbox.
I will try to fix it.

[Person]

I think that I have fixed bug:

Your old script (based on avartar fix, the same part as in my file):

Code Select Expand

/******************************************************************************/
--- Converting personal messages (step 2)...
/******************************************************************************/

TRUNCATE {$to_prefix}pm_recipients;

---* {$to_prefix}pm_recipients
SELECT
pm.privmsgs_id AS ID_PM, pm.privmsgs_to_userid AS ID_MEMBER,
pm.privmsgs_type = 5 AS is_read, pm.privmsgs_type IN (2, 4) AS deleted,
'-1' AS labels
FROM ({$from_prefix}privmsgs AS pm, {$from_prefix}privmsgs_text AS pmt)
LEFT JOIN {$from_prefix}users AS uf ON (uf.user_id = pm.privmsgs_from_userid)
WHERE pmt.privmsgs_text_id = pm.privmsgs_id;
---*

Fixed script:

Code Select Expand

/******************************************************************************/
--- Converting personal messages (step 2)...
/******************************************************************************/

TRUNCATE {$to_prefix}pm_recipients;

---* {$to_prefix}pm_recipients
SELECT
pm.privmsgs_id AS ID_PM, pm.privmsgs_to_userid AS ID_MEMBER,
pm.privmsgs_type = 0 AS is_read, pm.privmsgs_type IN (2, 4) AS deleted,
'-1' AS labels
FROM ({$from_prefix}privmsgs AS pm, {$from_prefix}privmsgs_text AS pmt)
LEFT JOIN {$from_prefix}users AS uf ON (uf.user_id = pm.privmsgs_from_userid)
WHERE pmt.privmsgs_text_id = pm.privmsgs_id;
---*

I have tested phpBB2 forum. I think: Number 5 means that PM is stil unread. Number 0 mans that PM hvae been read.

Now I have correct flag in table smf_pm_recipients at column is_read.
Except for PM whic have been deleted ... but SMF auto correct their flags.


Person

[Person]

I have a little modified upper code ... now the deleted PM has correct flag for read/unread (I think)

Code Select Expand

/******************************************************************************/
--- Converting personal messages (step 2)...
/******************************************************************************/

TRUNCATE {$to_prefix}pm_recipients;

---* {$to_prefix}pm_recipients
SELECT
pm.privmsgs_id AS ID_PM, pm.privmsgs_to_userid AS ID_MEMBER,
pm.privmsgs_type IN (0,2,4)AS is_read, pm.privmsgs_type IN (2, 4) AS deleted,
'-1' AS labels
FROM ({$from_prefix}privmsgs AS pm, {$from_prefix}privmsgs_text AS pmt)
LEFT JOIN {$from_prefix}users AS uf ON (uf.user_id = pm.privmsgs_from_userid)
WHERE pmt.privmsgs_text_id = pm.privmsgs_id;
---*

From only 0 to (0,2,4)

EDITED:
Last version: phpbb2_to_smf_2006_08_26-3.zip

Last UTF8 version: phpbb2_to_smf_2006_08_26-3-utf8.zip

EDITED 2: Code correction

Person

[whitewun]

This is my problem! something to do with importing email address's can someone please please please advise me on a fix!

cheeeers!

Code Select Expand

Converting...
Converting ranks... Successful.
Converting groups... Successful.
Converting members... Unsuccessful!
This query:
SELECT
u.user_id AS ID_MEMBER, SUBSTRING(u.username, 1, 80) AS memberName,
SUBSTRING(u.username, 1, 255) AS realName,
SUBSTRING(u.user_password, 1, 64) AS passwd, u.user_lastvisit AS lastLogin,
u.user_regdate AS dateRegistered,
SUBSTRING(u.user_from, 1, 255) AS location,
u.user_posts AS posts, IF(u.user_level = 1, 1, mg.ID_GROUP) AS ID_GROUP,
u.user_new_privmsg AS instantMessages,
SUBSTRING(u.user_email AS emailAddress, 1, 255) AS emailAddress,
u.user_unread_privmsg AS unreadMessages,
SUBSTRING(u.user_msnm AS MSN, 1, 255) AS MSN,
SUBSTRING(u.user_aim AS AIM, 1, 16) AS AIM,
SUBSTRING(u.user_icq, 1, 255) AS ICQ,
SUBSTRING(u.user_yim, 1, 32) AS YIM,
SUBSTRING(u.user_website, 1, 255) AS websiteTitle,
SUBSTRING(u.user_website, 1, 255) AS websiteUrl,
u.user_allow_viewonline AS showOnline, u.user_timezone AS timeOffset,
IF(u.user_viewemail = 1, 0, 1) AS hideEmail, u.user_avatar AS avatar,
REPLACE(u.user_sig, '\n', '<br />') AS signature,
u.user_sig_bbcode_uid AS signature_uid, u.user_avatar_type,
u.user_notify_pm AS pm_email_notify, u.user_active AS is_activated,
'' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS messageLabels,
'' AS personalText, '' AS timeFormat, '' AS usertitle, '' AS memberIP,
'' AS secretQuestion, '' AS secretAnswer, '' AS validation_code,
'' AS additionalGroups, '' AS smileySet, '' AS passwordSalt,
'' AS memberIP2
FROM `swapahome`.phpbb_users AS u
LEFT JOIN `swapahome`.phpbb_ranks AS r ON (r.rank_id = u.user_rank AND r.rank_special = 1)
LEFT JOIN `swapahome`.smf_membergroups AS mg ON (BINARY mg.groupName = CONCAT('phpBB ', r.rank_title))
WHERE u.user_id != -1
GROUP BY u.user_id
LIMIT 0, 500;
Caused the error:

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 'AS emailAddress, 1, 255) AS emailAddress,
u.user_unread_privmsg AS unreadMessag' at line 9

[Ferny]

whitewun: use the converter that is in the post above yours, it has some fixes.

[Ferny]

Person, your last modification doesn't work. Maybe instead of pm.privmsgs_type = (0,2,4) should be pm.privmsgs_type IN (0,2,4)

?

I'll try with "IN"

[kitz]

Thanks guys.. specially ferny and person for their input..

finally got it to work after using the latest upgrade file and after doing a fresh install of SMF.

mhwuah 

[Person]

Person, your last modification doesn't work. Maybe instead of pm.privmsgs_type = (0,2,4) should be pm.privmsgs_type IN (0,2,4)

?

I'll try with "IN"

Oh, sorry, I have did a mistake with correction ... in my uploaded file is correct 
Yes,

Code Select Expand

pm.privmsgs_type IN (0,2,4)AS is_read is correct

[Person]

There might be another fix:
http://www.simplemachines.org/community/index.php?topic=109303.msg703496#msg703496