FUDforum

Post Form

Logged in user:

CommonCrawl [Bot] [logout]

Forum:

FUDforum Installation Issues

Title:

Poll:

Message Icon:

No Icon

Smiley Shortcuts:
[ list all smilies ]

Embarassed

Razz

Mad

Laughing

Cool

Confused

Shocked

Surprised

Sad

Smile

Very Happy

Crying or Very Sad

Evil or Very Mad

Twisted Evil

Rolling Eyes

Formatting Tools:

Body:

Forum Options:
HTML code is off
BBcode is on
Images are on
Smilies are on
Editing Time Limit: Unlimited

[quote title=Fladi wrote on Thu, 06 October 2011 08:51]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:

[....]
[code]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
[/code]

Any idea what i could to next?

Thnaks[/quote]

File Attachments:

Allowed File Extensions: jpg jpeg png gif txt doc gz bz2 inc php zip diff
Maximum File Size: 1000KB
Maximum Files Per Message: 3

Options:

	Post Notification
	Notify me when someone replies to this message.
	Include Signature
	Include your profile signature.
	Disable smilies in this message

Topic View

Re: Aw: Re: No messages after upgrade to 3.0.3

Sun, 09 October 2011 08:35

naudefj

Karma:

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.

Aw: Re: No messages after upgrade to 3.0.3

Sat, 08 October 2011 02:44

Fladi

Karma:

Dpone this - still the same error. I'll PM you....

Re: No messages after upgrade to 3.0.3

Thu, 06 October 2011 13:13

naudefj

Karma:

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.

No messages after upgrade to 3.0.3

Thu, 06 October 2011 08:51

Fladi

Karma:

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

Current Time: Tue Sep 10 19:27:40 EDT 2024

Total time taken to generate the page: 0.04771 seconds