| 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: 1
|
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 |
|
|
|
| Aw: 3.0.2. -> 3.04 RC 1 "fud_tv_1.id " [message #167186 is a reply to message #167185] |
Sun, 13 May 2012 11:26  |
alopezie
Messages: 106
Registered: September 2003
Karma: 1
|
Senior Member |
|
|
Its a bit strange, I had the same problem trying to update to 3.03
It recreates just 3 columns instead of 4.
But maybe its related to ownership of Database files, I just managed successfully to get an Upgrade and consistency check for a test installation.
Simply did chown again the files, although nothing was wrong.
--- Update ---
Too early for good news - no error, but no Forums, entries are missing ... the test installation is corrupt.
So I will have to proceed in trying to get soem more info about what is happening.
---- Update II ----
The Upgrade-log does not show any activity related to the tv files
Zitat:Beginning SQL Upgrades.
Checking if SQL permissions to perform the upgrade are available.
Add new database column foff to table fud_pages.
Add new database column length to table fud_pages.
Drop unused database column body from table fud_pages.
Add new database column ann_opt to table fud_announce.
Add new database column start_minute to table fud_jobs.
Add new database column start_hour to table fud_jobs.
Add new database column start_dom to table fud_jobs.
Add new database column start_month to table fud_jobs.
Add new database column start_dow to table fud_jobs.
Drop unused database column minute from table fud_jobs.
Drop unused database column hour from table fud_jobs.
Drop unused database column dom from table fud_jobs.
Drop unused database column month from table fud_jobs.
Drop unused database column dow from table fud_jobs.
Drop unused database index fud_fc_view_i_c from table fud_fc_view.
Add new database column event_day to table fud_calendar.
Add new database column event_month to table fud_calendar.
Add new database column event_year to table fud_calendar.
Drop unused database column day from table fud_calendar.
Drop unused database column month from table fud_calendar.
Drop unused database column year from table fud_calendar.
Add new database index fud_calendar_i_ymd to table fud_calendar(event_year,event_month,event_day).
Alter database column ip_addr in table fud_pmsg.
Alter database column subject in table fud_pmsg.
Drop unused database index fud_msg_report_i_u from table fud_msg_report.
Drop unused database column id from table fud_forum_notify.
Drop unused database index fud_forum_notify_i_uf from table fud_forum_notify.
Create composite primary key on fud_forum_notify(user_id,forum_id).
Drop unused database index fud_group_resources_i_r from table fud_group_resources.
Drop unused database index fud_group_cache_i_g from table fud_group_cache.
Drop unused database index fud_group_cache_i_u from table fud_group_cache.
Alter database column salt in table fud_users.
Drop unused database index fud_users_i_l from table fud_users.
Drop unused database index fud_users_i_e from table fud_users.
Drop unused database index fud_users_i_a from table fud_users.
Drop unused database index fud_users_i_rk from table fud_users.
Drop unused database index fud_users_i_lv from table fud_users.
Drop unused database index fud_users_i_ck from table fud_users.
Drop unused database index fud_users_i_ri from table fud_users.
Drop unused database index fud_users_i_uo from table fud_users.
Drop unused database index fud_users_i_jd from table fud_users.
Drop unused database index fud_users_i_bd from table fud_users.
Add new database column fixed_from_address to table fud_mlist.
Drop unused database index fud_read_i_u from table fud_read.
Add new database column parent to table fud_forum.
Alter database column ip_addr in table fud_msg.
Alter database column subject in table fud_msg.
Drop unused database index fud_msg_i_ta from table fud_msg.
Drop unused database index fud_msg_i_ps from table fud_msg.
Drop unused database index fud_msg_i_pa from table fud_msg.
Drop unused database index fud_msg_i_a from table fud_msg.
Drop unused database index fud_msg_i_ac from table fud_msg.
Drop unused database index fud_msg_i_pi from table fud_msg.
Drop unused database index fud_msg_i_ip from table fud_msg.
Drop unused database index fud_msg_i_s from table fud_msg.
Add new database column ip_addr to table fud_ses.
Add new database column useragent to table fud_ses.
Drop unused database index fud_ses_i_s from table fud_ses.
Drop unused database index fud_ses_i_u from table fud_ses.
Drop unused database index fud_ses_i_tu from table fud_ses.
Drop unused database index fud_group_members_i_gu from table fud_group_members.
Drop unused database index fud_group_members_i_gmo from table fud_group_members.
Alter database column location in table fud_attach.
Add new database column votes to table fud_poll_opt.
Drop unused database column count from table fud_poll_opt.
Add new database column ip_addr to table fud_poll_opt_track.
Drop unused database index fud_thread_i_t from table fud_thread.
Drop unused database index fud_thread_i_r from table fud_thread.
SQL Upgrades Complete.
Checking GLOBAL Variables.
Please manually update custom theme default.
Unable to compile theme default. Please fix it manually: Undefined template: "TEMPLATE" inside "merge_another_lnk".
Please manually update custom theme contrast.
Unable to compile theme contrast. Please fix it manually: Undefined template: "TEMPLATE" inside "merge_another_lnk".
Anyhow the tv_ files are simply EMPTY after the upgrade script finished
So no chance for the following consistency check !
Alopezie.de - das Forum zum Thema Haarausfall
[Updated on: Sun, 13 May 2012 18:09] Report message to a moderator |
|
|
|
|
|
|
|
| Aw: Re: Aw: 3.0.2. -> 3.04 RC 1 "fud_tv_1.id " [message #167192 is a reply to message #167191] |
Mon, 14 May 2012 17:00 |
alopezie
Messages: 106
Registered: September 2003
Karma: 1
|
Senior Member |
|
|
I think I found it.
/sql/fud_tv_1.tbl is used to recreate the tv tables.
Called by function frm_add_view_tbl in forum_adm.inc
In my version 5251 from May 11, 2011 (3.03) fud_tv_1.tbl does contain only 3 columns, not the id column
In 3.02 (4976) it contained also the id column.
Alopezie.de - das Forum zum Thema Haarausfall
[Updated on: Mon, 14 May 2012 17:02] Report message to a moderator |
|
|
|
|
|
| Aw: Re: Aw: Re: Aw: 3.0.2. -> 3.04 RC 1 "fud_tv_1.id " [message #167196 is a reply to message #167195] |
Mon, 14 May 2012 20:33 |
alopezie
Messages: 106
Registered: September 2003
Karma: 1
|
Senior Member |
|
|
Okay, if this is the way it should be then is seems to come from include/theme/default/th_adm.inc, which is indeed "old" (5030 from 2010)
It conatins the .id -call
For whatever reason it was not updated (all files in this theme-directory remained "old")
Guess it should be possible to copy files from a new installation to get rid of the problem ... tomorrow ...
Alopezie.de - das Forum zum Thema Haarausfall
[Updated on: Mon, 14 May 2012 20:34] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Aw: Re: Aw: Re: Aw: Re: Aw: 3.0.2. -> 3.04 RC 1 "fud_tv_1.id " [message #167203 is a reply to message #167200] |
Wed, 16 May 2012 07:07 |
alopezie
Messages: 106
Registered: September 2003
Karma: 1
|
Senior Member |
|
|
New day new game.
I simply deleted my old template and replaced with "standard" template to get rid of this message
Now I get "Table 'gm' was not locked with LOCK TABLES<br /> Query: SELECT gm.user_id, gm.group_members_opt, gr.resource_id FROM fud2_group_members gm INNER JOIN fud2_group_resources gr ON gr.group_id=gm.group_id WHERE gm.group_members_opt>=65536 AND gm.group_members_opt & 65536 > "
Doing this SQL -Statement via phpmyadmin works
Its happening with the consist.php from 3.02 (so before Upgrade) as well als 3.04 RC1 (after Upgrade)
There have been a couple of reports about this locking problem, but all have been solved with a new consist.php
Alopezie.de - das Forum zum Thema Haarausfall
|
|
|
|
|
|
| Aw: Re: Aw: Re: Aw: Re: Aw: Re: Aw: 3.0.2. -> 3.04 RC 1 "fud_tv_1.id " [message #167206 is a reply to message #167204] |
Thu, 17 May 2012 19:58 |
alopezie
Messages: 106
Registered: September 2003
Karma: 1
|
Senior Member |
|
|
After many "try and error" procedures I finally managed to upgrade a test installation.
All these problems seem to come from minor changes in the themes and source code, so if you overlook a theme problem you get an error at a very different position.
At the end I made a fresh new install with the old release, then changed the database to the original one ... then upgraded ... and this worked. So I can now develop and test the theme for the upgrade.
Alopezie.de - das Forum zum Thema Haarausfall
|
|
|
|
|
|
|
|
| Aw: Re: Aw: Re: Aw: Re: Aw: Re: Aw: Re: Aw: 3.0.2. -> 3.04 RC 1 "fud_tv_1.id " [message #167321 is a reply to message #167211] |
Sun, 03 June 2012 15:08 |
alopezie
Messages: 106
Registered: September 2003
Karma: 1
|
Senior Member |
|
|
So today I upgraded all my forums to the new 3.0.4 RC2 with no problems.
In fact applying the old theme AFTER upgrade did work well.
But just for those who might encounter problems in that direction now a short summary of things I did:
- backup database + full webspace !!!
- MYSQL Repair of databases (just to get rid of any problem which might have come around in the time before)
From shell: mysqlrepair -u username -pPASSWORD databasename
if you have no root access do it via phpmyadmin
- Consistency check via Fudforum
- then I removed all content from /thm and /theme directory and replaced with code from an original fresh install of my current Fudforum version
- recompile themes; pay attention that a green positive message comes
- do the upgrade now ... and consistency check ... worked like hell (in fact the pure upgrade was around 1-2 minutes for 200.000+ posts !)
- recompile themes; again look for any faults or a green positive message
... and have a look whether you have "done" it
Alopezie.de - das Forum zum Thema Haarausfall
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]