FUDforum: Database discussions » MySQL error when importing NNTP message

Home » General » Database discussions » MySQL error when importing NNTP message

Show: Today's Messages :: Polls :: Message Navigator

MySQL error when importing NNTP message [message #162739]

Sat, 10 July 2010 15:46

rush2112

Messages: 15
Registered: April 2005

Karma:

Junior Member

I keep running in to this error when it the cron for the newsgroup triggers:

<br />
<b>Warning</b>:  mysql_fetch_row(): supplied argument is not a valid MySQL result resource in <b>/home/bythedr1/FUDforum/include/theme/default/db.inc</b> on line <b>28</b><br />
(/home/bythedr1/FUDforum/include/theme/default/db.inc:72<br />
/home/bythedr1/FUDforum/include/theme/default/db.inc:168<br />
/home/bythedr1/FUDforum/include/scripts_common.inc:82<br />
/home/bythedr1/FUDforum/include/nntp.inc:575<br />
/home/bythedr1/FUDforum/scripts/nntp.php:92<br />
) 2006: MySQL server has gone away<br />
Query: SELECT m.id, m.thread_id FROM fud30_msg m INNER JOIN fud30_thread t ON m.thread_id=t.id WHERE m(dot)mlist_msg_id='jIedncEGH95vaK7RnZ2dnUVZ_uSdnZ2d(at)speakeasy(dot)net' AND t.forum_id=6 ORDER BY m.post_stamp DESC LIMIT 1<br />
_GET: array (
  '/home/bythedr1/FUDforum/scripts/nntp_php' =&gt; '',
  5 =&gt; '',
)<br />
Server Version: <br />

In that newsgroup, it will re-post one message than stop any other imports. This might be all wrong, but I eventually deleted the thread, ran forum consistency, optimized the database and compacted the messages. The error keeps appearing and I can't figure this one out Confused

Some server specs.
Running FUD 3.0.0 on shared Linux server
PHP version: 5.2.10
Database version: 5.0.90-community

Thanks!

Rush

[Updated on: Sat, 10 July 2010 15:54]

Report message to a moderator

[Message index]

		MySQL error when importing NNTP message By: rush2112 on Sat, 10 July 2010 15:46
		Re: MySQL error when importing NNTP message By: naudefj on Sat, 10 July 2010 19:27
		Re: MySQL error when importing NNTP message By: rush2112 on Sun, 11 July 2010 04:06
		Re: MySQL error when importing NNTP message By: naudefj on Sun, 11 July 2010 08:02
		Re: MySQL error when importing NNTP message By: rush2112 on Sun, 11 July 2010 13:52
		Re: MySQL error when importing NNTP message By: naudefj on Mon, 12 July 2010 16:14
		Re: MySQL error when importing NNTP message By: rush2112 on Mon, 12 July 2010 17:38

Previous Topic:	Fatal error when trying import / take a forum datadump
Next Topic:	table fud28_ses missing issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 16:37:19 GMT 2024

Total time taken to generate the page: 0.04831 seconds