| 3.0.2. -> 3.04 RC 1 "fud_tv_1.id " [message #167185] |
Sat, 12 May 2012 08:24  |
alopezie
Messages: 106
Registered: September 2003
Karma:
|
Senior Member |
|
|
Strange error when upgrading from 3.0.2 to 3.0.4 RC1
During consistency check following message appears
Rebuilding Topic Views
Fatal error: Uncaught exception 'Exception' with message '(/srv/XXX/html/fud/include/theme/default/db.inc:80<br /> /srv/XXX/html/fud/include/theme/default/db.inc:212<br /> /srv/XXX/html/fud/include/theme/default/th_adm.inc:75<br /> /srv/XXX/html/fud/include/theme/default/th_adm.inc:100<br /> /srv/XXX/html/fud/adm/consist.php:730<br /> ) 1054: Unknown column 'fud_tv_1.id' in 'where clause'<br /> Query: SELECT fud_thread.id FROM fud_tv_1 INNER JOIN fud_thread ON fud_thread.id=fud_tv_1.thread_id INNER JOIN fud_msg ON fud_thread.root_msg_id=fud_msg.id WHERE fud_tv_1.id>-50 AND fud_tv_1.iss>0 AND fud_thread.thread_opt>=2 AND (fud_msg.post_stamp+fud_thread.orderexpiry)<=1336806466<br /> _POST: array ( 'conf' => 'Yes', 'SQ' => 'e77fa776fbcb7725661692f24385856', )<br /> Database version: 5.0.51a-24+lenny5<br /> [Referring Page] http://www.alopezie.de/fud/adm/consist.php?&SQ=e77fa776fbcb7725661692f24385856<br /> ' in /srv/XXX/html/fud/include/core.inc:259 Stack trace: #0 /srv/XXX/html/fud/include/theme/default/db.inc(80): fud_sql_error_handler('SELECT fud_thre...', 'Unknown column ...', 1054, '5.0.51a-24+lenn...') #1 /srv/XXX/html/fud/include/theme/default/db.inc(212): uq('SELECT fud_thre...') #2 /srv/XXX/html/fud/include/theme/default/th_adm.inc(75): db_all('SELECT fud_thre...') #3 /srv/XXX/html/fud/include/theme/default/th_adm.inc(100): __th_cron_emu('1', 0) #4 /srv/XXX/html/fud/adm/consist.php(730): rebuild_forum_view_ttl('1') #5 {main} thrown in /srv/XXX/html/fud/include/core.inc on line 259
The error is in the SQL statement:
SELECT fud_thread.id FROM fud_tv_1 INNER JOIN fud_thread ON fud_thread.id=fud_tv_1.thread_id INNER JOIN fud_msg ON fud_thread.root_msg_id=fud_msg.id WHERE fud_tv_1.id>-50 AND fud_tv_1.iss>0 AND fud_thread.thread_opt>=2 AND (fud_msg.post_stamp+fud_thread.orderexpiry)<=1336806466
seems to look for fud_tv_1.id which was not existing.
So I created this field manually ... but running again upgrade script it was "gone" and same error reappeared.
Quite strange, as this field was existing in the original database.
Also the whole content of these index files was gone, so I had to use my backup and go back to 3.0.2
Alopezie.de - das Forum zum Thema Haarausfall
[Updated on: Sun, 13 May 2012 06:37] Report message to a moderator |
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]