FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Installation Issues » Newsgroup import problem - sql error ?
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Newsgroup import problem - sql error ? [message #33776] Wed, 20 September 2006 16:09 Go to next message
Frozentech is currently offline  Frozentech   United States
Messages: 3
Registered: September 2006
Location: Alaska, USA
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
I just installed FUDforum and was impressed so far, especially with the ability import nntp usenet newsgroups. I tried setting up a new blank forum for a group, found a good free nntp host, set up the cron job, etc., but it doesn't work. Here is the error message the cron is sending me :


(/path_to_my_site/FUDforum/include/theme/default/db.inc:73<br />
/path_to_my_site/FUDforum/include/theme/default/db.inc:133<br />
/path_to_my_site/FUDforum/include/theme/default/th_adm.inc:73<br/>
/path_to_my_site/FUDforum/include/theme/default/th_adm.inc:157<br/>
/path_to_my_site/FUDforum/include/theme/default/imsg_edt.inc:414<br/>
/path_to_my_site/FUDforum/include/nntp.inc:471<br />
/path_to_my_site/FUDforum/scripts/nntp.php:91<br />
) 1146: Table 'pyrotechs_forumdb.fud26_tv_4' doesn't exist<br />
Query: SELECT seq FROM fud26_tv_4 ORDER BY seq DESC LIMIT 1<br />
_GET: array (
1 =&gt; '',
)<br />
Server Version: 5.0.18-standard-log<br />

It seems that a table is missing in the database ? Why would FUDforum miss that, when the rest of the forum seems to work fine?

Mark
Re: Newsgroup import problem - sql error ? [message #33794 is a reply to message #33776] Thu, 21 September 2006 18:11 Go to previous messageGo to next message
Ilia is currently offline  Ilia   United States
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
What version of the forum are you using?

FUDforum Core Developer
Re: Newsgroup import problem - sql error ? [message #33798 is a reply to message #33776] Thu, 21 September 2006 18:42 Go to previous messageGo to next message
Frozentech is currently offline  Frozentech   United States
Messages: 3
Registered: September 2006
Location: Alaska, USA
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
It's 2.7.6. I am planning to integrate it with a Drupal website as soon as I get it running smoothly by itself. I just don't know enough mySQL to know what happened. I set up the database, FUDform runs fine standalone, until I add the import newsgroup function.
Re: Newsgroup import problem - sql error ? [message #33819 is a reply to message #33798] Fri, 22 September 2006 13:05 Go to previous messageGo to next message
Ilia is currently offline  Ilia   United States
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Have you tried running the consistency checker?

FUDforum Core Developer
Re: Newsgroup import problem - sql error ? [message #33845 is a reply to message #33776] Sat, 23 September 2006 15:30 Go to previous message
Frozentech is currently offline  Frozentech   United States
Messages: 3
Registered: September 2006
Location: Alaska, USA
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Well, I got it working. I did a quick deinstall/reinstall, and this time import of newsgroups works fine. Not exactly certain what I did wrong the 1st time, but I *think* that the forum files were locked when I was addding the topic for newsgroup imports.

Thanks Ilia, for your hints and suggestions.

Mark
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Problem with making a dump
Next Topic: FUDforum broken after upgrade from 2.7.5 to 2.7.6 (pgsql)
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 23 11:54:10 EDT 2018

Total time taken to generate the page: 0.00630 seconds