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

Home » FUDforum » FUDforum Installation Issues » 3.0.2. -> 3.04 RC 1 "fud_tv_1.id "
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
3.0.2. -> 3.04 RC 1 "fud_tv_1.id " [message #167185] Sat, 12 May 2012 04:24 Go to next message
alopezie is currently offline  alopezie   Germany
Messages: 92
Registered: September 2003
Karma: 1
Member
add to buddy list
ignore all messages by this user
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&gt;-50 AND fud_tv_1.iss&gt;0 AND fud_thread.thread_opt&gt;=2 AND (fud_msg.post_stamp+fud_thread.orderexpiry)&lt;=1336806466<br /> _POST: array ( 'conf' =&gt; 'Yes', 'SQ' =&gt; 'e77fa776fbcb7725661692f24385856', )<br /> Database version: 5.0.51a-24+lenny5<br /> [Referring Page] http://www.alopezie.de/fud/adm/consist.php?&amp;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&gt;-50 AND fud_tv_1.iss&gt;0 AND fud_thread.thread_opt&gt;=2 AND (fud_msg.post_stamp+fud_thread.orderexpiry)&lt;=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 02: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 07:26 Go to previous messageGo to next message
alopezie is currently offline  alopezie   
Messages: 92
Registered: September 2003
Karma: 1
Member
add to buddy list
ignore all messages by this user
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 14:09]

Report message to a moderator

Re: Aw: 3.0.2. -> 3.04 RC 1 "fud_tv_1.id " [message #167187 is a reply to message #167186] Mon, 14 May 2012 05:39 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3634
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
You're using an old "consist.php" file. The file was somehow not replaced as part of the upgrade?
Aw: Re: Aw: 3.0.2. -> 3.04 RC 1 "fud_tv_1.id " [message #167191 is a reply to message #167187] Mon, 14 May 2012 11:41 Go to previous messageGo to next message
alopezie is currently offline  alopezie   
Messages: 92
Registered: September 2003
Karma: 1
Member
add to buddy list
ignore all messages by this user
Don´t think so. Current consist file is 5366, old one was 5071.I have now build a test system ... just to get an idea when and how this happens

Alopezie.de - das Forum zum Thema Haarausfall
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 13:00 Go to previous messageGo to next message
alopezie is currently offline  alopezie   
Messages: 92
Registered: September 2003
Karma: 1
Member
add to buddy list
ignore all messages by this user
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 13:02]

Report message to a moderator

Re: Aw: Re: Aw: 3.0.2. -> 3.04 RC 1 "fud_tv_1.id " [message #167195 is a reply to message #167192] Mon, 14 May 2012 15:53 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3634
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Correct, we've removed the "id" column because it's redundant. Any script still selecting from "id" must be wrong or old.
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 16:33 Go to previous messageGo to next message
alopezie is currently offline  alopezie   
Messages: 92
Registered: September 2003
Karma: 1
Member
add to buddy list
ignore all messages by this user
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 16:34]

Report message to a moderator

Re: Aw: Re: Aw: Re: Aw: 3.0.2. -> 3.04 RC 1 "fud_tv_1.id " [message #167197 is a reply to message #167196] Mon, 14 May 2012 16:41 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3634
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
That is a compiled file. Try to rebuild all your themes from the Theme Manager. If you get errors, it means you have a custom theme that needs some updating.
Aw: Re: Aw: Re: Aw: Re: Aw: 3.0.2. -> 3.04 RC 1 "fud_tv_1.id " [message #167198 is a reply to message #167197] Mon, 14 May 2012 16:47 Go to previous messageGo to next message
alopezie is currently offline  alopezie   
Messages: 92
Registered: September 2003
Karma: 1
Member
add to buddy list
ignore all messages by this user
Yes, your are right ... this option is easier ... but the consistency checks starts automatically, so this has to be deleted from the update-script before
no problem, but tomorrow anyway...

thx for the moment


Alopezie.de - das Forum zum Thema Haarausfall
Aw: Re: Aw: Re: Aw: Re: Aw: 3.0.2. -> 3.04 RC 1 "fud_tv_1.id " [message #167200 is a reply to message #167198] Tue, 15 May 2012 12:10 Go to previous messageGo to next message
alopezie is currently offline  alopezie   Germany
Messages: 92
Registered: September 2003
Karma: 1
Member
add to buddy list
ignore all messages by this user
In fact I realize it could be more a problem with the theme which is not compiled, therefore the system not updating and using old and wrong code.

Zitat:

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".

"merge_another_lnk" is just in language files
Please manually update custom theme contrast.
Unable to compile theme contrast. Please fix it manually: Undefined template: "TEMPLATE" inside "merge_another_lnk".


This problem has been mentioned a couple of times
http://fudforum.org/forum/index.php?t=msg&th=119768&goto=164373& ;#msg_164373
http://www.clearfoundation.com/component/option,com_kunena/Itemid,232/catid ,17/func,view/id,23883/

but actually I can´t see any sense in this error message,


Alopezie.de - das Forum zum Thema Haarausfall
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 03:07 Go to previous messageGo to next message
alopezie is currently offline  alopezie   Germany
Messages: 92
Registered: September 2003
Karma: 1
Member
add to buddy list
ignore all messages by this user
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&gt;=65536 AND gm.group_members_opt &amp; 65536 &gt; "

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
Re: Aw: Re: Aw: Re: Aw: Re: Aw: 3.0.2. -> 3.04 RC 1 "fud_tv_1.id " [message #167204 is a reply to message #167203] Wed, 16 May 2012 07:19 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3634
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Consist.php depends on code from the "default" theme. You need to recompile it until it is valid before continuing. You can do it by re-running the upgrade script until you see "Theme default was successfully compiled.".

PS: The compiler errors are not very useful in resolving the problem. I will get them fixed-up ASAP.
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 15:58 Go to previous messageGo to next message
alopezie is currently offline  alopezie   Germany
Messages: 92
Registered: September 2003
Karma: 1
Member
add to buddy list
ignore all messages by this user
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
Re: Aw: Re: Aw: Re: Aw: Re: Aw: Re: Aw: 3.0.2. -> 3.04 RC 1 "fud_tv_1.id " [message #167207 is a reply to message #167206] Thu, 17 May 2012 16:12 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3634
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Great news indeed!

More good news: I've manages to improve the compiler error messages and it should in future be much easier to understand what's wrong.

Best regards.
Frank
Aw: Re: Aw: Re: Aw: Re: Aw: Re: Aw: Re: Aw: 3.0.2. -> 3.04 RC 1 "fud_tv_1.id " [message #167211 is a reply to message #167207] Fri, 18 May 2012 13:20 Go to previous messageGo to next message
alopezie is currently offline  alopezie   Germany
Messages: 92
Registered: September 2003
Karma: 1
Member
add to buddy list
ignore all messages by this user
That sounds good, thx !!

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 11:08 Go to previous message
alopezie is currently offline  alopezie   Germany
Messages: 92
Registered: September 2003
Karma: 1
Member
add to buddy list
ignore all messages by this user
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
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Upgrade bollixed access to cPanel
Next Topic: HOME FUNCTION
Goto Forum:
  

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

Current Time: Thu Jan 18 20:37:54 EST 2018

Total time taken to generate the page: 0.00900 seconds