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

Home » FUDforum » FUDforum Installation Issues » No messages after upgrade to 3.0.3
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
icon9.gif  No messages after upgrade to 3.0.3 [message #166175] Thu, 06 October 2011 08:51 Go to next message
Fladi is currently offline  Fladi   Germany
Messages: 19
Registered: April 2011
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Hi!

I upgraded from 3.0.2 to 3.0.3 and now there are no messages shown anymore. The messages itself seems to be existing in the file-system and the connection to the database-entries seems ok.

When I run a consistency-check i get the following error:

[....]
Rebuilding Topic Views

Fatal error: Uncaught exception 'Exception' with message '(/var/apache/cid700/data/FUDforum/include/theme/default/db.inc:80<br />
/var/apache/cid700/data/FUDforum/include/theme/default/db.inc:212<br />
/var/apache/cid700/data/FUDforum/include/theme/default/th_adm.inc:75<br />
/var/apache/cid700/data/FUDforum/include/theme/default/th_adm.inc:100<br />
/var/apache/cid700/htdocs/adm/consist.php:730<br />
) 1054: Unknown column 'fud30_tv_3.id' in 'where clause'<br />
Query: SELECT fud30_thread.id FROM fud30_tv_3
			INNER JOIN fud30_thread ON fud30_thread.id=fud30_tv_3.thread_id
			INNER JOIN fud30_msg ON fud30_thread.root_msg_id=fud30_msg.id
			WHERE fud30_tv_3.id&gt;-50 
				AND fud30_tv_3.iss&gt;0
				AND fud30_thread.thread_opt&gt;=2 
				AND (fud30_msg.post_stamp+fud30_thread.orderexpiry)&lt;=1317901803<br />
_POST: array (
  'conf' =&gt; 1,
)<br />
Database version: 5.1.47-log<br />
' in /var/apache/cid700/data/FUDforum/include/core.inc:256
Stack trace:
#0 /var/apache/cid700/data/FUDforum/include/theme/default/db.inc(80): fud_sql_error_handler('SELECT fud30_th...', 'Unknown column ...', 1054, '5.1.47-log')
#1 /var/apache/cid700/data/FUDforum/include/theme/default/db.inc(212): uq('SELECT fud30_th...')
#2 /var/apache/cid700/data/FUDforum/include/theme/default/th_adm.inc(75): db_all('SELECT fud30_th...')
#3 /var/apache/cid700/data/FUDforum/include/theme/default/th_adm.inc(100): __th_cron_emu('3', 0)
#4 /var/apache/cid700/htdocs/adm/consist.php(730): rebuild_forum_view_ttl('3')
#5 {main}
  thrown in /var/apache/cid700/data/FUDforum/include/core.inc on line 256


Any idea what i could to next?

Thnaks
Re: No messages after upgrade to 3.0.3 [message #166176 is a reply to message #166175] Thu, 06 October 2011 13:13 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3624
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
All your messages are still there, but somehow the cache tables weren't recreated.
Drop all tv_* tables and rerun the consistency checker.
If it doesn't work, mail me an admin account for debugging.
Aw: Re: No messages after upgrade to 3.0.3 [message #166181 is a reply to message #166176] Sat, 08 October 2011 02:44 Go to previous messageGo to next message
Fladi is currently offline  Fladi   Germany
Messages: 19
Registered: April 2011
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Dpone this - still the same error. I'll PM you....
Re: Aw: Re: No messages after upgrade to 3.0.3 [message #166183 is a reply to message #166181] Sun, 09 October 2011 08:35 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3624
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
Just to summarize: The "default" theme was invalid (due to template changes in 3.0.3). As a result the consistency checker was still using old pre-3.0.3 include files. To fix the problem, one can either (pick one):

1) Change the default theme to use one of the default template sets.

2) Remove or fix-up 'index.tmpl' in the custom template set.
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Log action failure in path_info (fixed)
Next Topic: avatar approval not found (fixed)
Goto Forum:
  

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

Current Time: Tue Oct 24 00:12:56 EDT 2017

Total time taken to generate the page: 0.00802 seconds