phpBB • Free and Open Source Forum Software

by **eyesonly466** » Mon Oct 10, 2011 1:22 am

Hi, i have phpbb v 3.0.9 and i installed digest mod v 2.2.11. however i cant send emails and am receiving the below general error:
...............................................
SQL ERROR [ mysqli ]

Lost connection to MySQL server during query [2013]

SQL

SELECT f.*, t.*, p.*, u.* FROM (phpbb_posts p, phpbb_users u, phpbb_topics t) LEFT JOIN phpbb_forums f ON (t.forum_id = f.forum_id) WHERE f.forum_id = t.forum_id AND p.topic_id = t.topic_id AND p.poster_id = u.user_id AND p.post_time > 1318038064 AND p.forum_id IN (0, 1, 2) AND p.poster_id <> 2 AND p.post_approved = 1 ORDER BY f.left_id, f.right_id, t.topic_last_post_time DESC, p.post_time LIMIT 18446744073709551615

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/db/mysqli.php
LINE: 205
CALL: dbal_mysqli->sql_query()

FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysqli->_sql_query_limit()

FILE: mail_digests.php
LINE: 659
CALL: dbal->sql_query_limit()
.................................................
Any help on the above?
Also does the mod i have installed (2.2.11) work with phpbb 3.0.9 or will i be facing other errors?

by **MarkDHamill** » Mon Oct 10, 2011 12:45 pm

The message:

Lost connection to MySQL server during query [2013]

suggests there are other problems going on rather than mail_digests.php. The problem may be that you are using shared hosting and the host does not allocate much CPU before timing out.

Version 2.2.11 is rather old and was not written for phpBB 3.0.9. There is a newer version 2.2.18 on my website (link in footer) you might want to try. Rather than try to patch it I would uninstall it and reinstall the new version. It makes fewer SQL calls which might address you problem with shared hosting. There is one known bug for 2.2.18 that I posted a correction to in this forum.

by **eyesonly466** » Mon Oct 24, 2011 11:49 pm

hi again,
i installed the newest mod version and still same error. i have my own webserver that is fully dedicated to phpbb. My current webserver has os opensolaris2009.06, however i tested the mod (sending digest emails) using another webserver i have with os centos 5.6 nd the mod worked perfectly...
so i guess the problem is with the OS (here opensolaris in my case). Any help?
thnx

by **MarkDHamill** » Mon Oct 24, 2011 11:55 pm

How many digest subscribers do you have? If PHP safe mode is turned on, mail_digests.php could time out. Also check your PHP setting for maximum execution time. It may be set too low.

You might try copying and pasting the SQL into phpMyAdmin and see if there is a SQL error there somewhere. It looks fine.

	What:	Where:	Country:
vacatures php arbeit php jobs php lavoro php emploi php trabajo php jobs php arbeit php

phpBB Digests

errors in digest sending email - phpBB Digests

Advertisements