Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » General » Database discussions » MySQL error when importing NNTP message
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Return to the default flat view Create a new topic Submit Reply
MySQL error when importing NNTP message [message #162739] Sat, 10 July 2010 11:46 Go to previous message
rush2112 is currently offline  rush2112   United States
Messages: 15
Registered: April 2005
Junior Member
add to buddy list
ignore all messages by this user
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



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

Report message to a moderator

[Message index]
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
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) ] [ RSS ]

Current Time: Sat Jul 21 13:42:16 EDT 2018

Total time taken to generate the page: 0.00685 seconds