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

Home » FUDforum Development » FUDforum 3.0+ » 2.6.0 upgrades failing
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
2.6.0 upgrades failing [message #13863] Wed, 29 October 2003 16:12 Go to next message
tgaastra is currently offline  tgaastra   United States
Messages: 90
Registered: June 2002
Karma: 0
Member
add to buddy list
ignore all messages by this user
RC1 and RC2 have given me the same error on trying to run the upgrade script. This is being done from a 2.5.3RC3 install.

Checking if SQL permissions to perform the upgrade are avaliable
Disable the forum
Forum is now disabled
Beginning the file upgrade process
Begining to decompress the archive
Finished decompressing the archive
File Upgrade Complete
Any changed files were backed up to: "/var/www/FUDforum/errors/.backup/"

Beginning SQL Upgrades
SQL Upgrades Complete
MySQL Error: #1054 (Unknown column 'theme_opt' in 'where clause'): SELECT id FROM fud2_themes WHERE (theme_opt & 3) > 0 LIMIT 1

[Updated on: Wed, 29 October 2003 16:12]

Report message to a moderator

Re: 2.6.0 upgrades failing [message #13864 is a reply to message #13863] Wed, 29 October 2003 16:19 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
This means some fields were not added... This can only happen if your fud_thread_view.tbl is old or was incorrectly parsed.

What database system are you using?


FUDforum Core Developer
Re: 2.6.0 upgrades failing [message #13866 is a reply to message #13864] Wed, 29 October 2003 16:21 Go to previous messageGo to next message
tgaastra is currently offline  tgaastra   United States
Messages: 90
Registered: June 2002
Karma: 0
Member
add to buddy list
ignore all messages by this user
MySQL 4.0.13
Re: 2.6.0 upgrades failing [message #13869 is a reply to message #13866] Wed, 29 October 2003 16:58 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Could you please tell me what is the output of:

DESCRIBE fud2_msg;


FUDforum Core Developer
Re: 2.6.0 upgrades failing [message #13871 is a reply to message #13869] Wed, 29 October 2003 17:15 Go to previous messageGo to next message
tgaastra is currently offline  tgaastra   United States
Messages: 90
Registered: June 2002
Karma: 0
Member
add to buddy list
ignore all messages by this user
This is from the restored backup I switched back to but:
 +-----------------+------------------+------+-----+---------+-------------- --+
| Field           | Type             | Null | Key | Default | Extra          |
 +-----------------+------------------+------+-----+---------+-------------- --+
| id              | int(10) unsigned |      | PRI | NULL    | auto_increment |
| thread_id       | int(10) unsigned |      | MUL | 0       |                |
| poster_id       | int(10) unsigned |      | MUL | 0       |                |
| reply_to        | int(10) unsigned |      |     | 0       |                |
| ip_addr         | varchar(15)      |      | MUL | 0.0.0.0 |                |
| host_name       | varchar(255)     | YES  |     | NULL    |                |
| post_stamp      | int(10) unsigned |      | MUL | 0       |                |
| update_stamp    | int(10) unsigned |      |     | 0       |                |
| updated_by      | int(10) unsigned |      |     | 0       |                |
| icon            | varchar(100)     | YES  |     | NULL    |                |
| subject         | varchar(100)     |      | MUL |         |                |
| attach_cnt      | int(10) unsigned |      | MUL | 0       |                |
| poll_id         | int(10) unsigned |      | MUL | 0       |                |
| approved        | enum('Y','N')    |      | MUL | N       |                |
| show_sig        | enum('Y','N')    |      |     | Y       |                |
| smiley_disabled | enum('Y','N')    |      |     | N       |                |
| foff            | int(10) unsigned |      |     | 0       |                |
| length          | int(10) unsigned |      |     | 0       |                |
| file_id         | int(10) unsigned |      |     | 1       |                |
| offset_preview  | int(10) unsigned |      |     | 0       |                |
| length_preview  | int(10) unsigned |      |     | 0       |                |
| file_id_preview | int(10) unsigned |      |     | 0       |                |
| mlist_msg_id    | varchar(100)     | YES  | MUL | NULL    |                |
| attach_cache    | text             | YES  |     | NULL    |                |
| poll_cache      | text             | YES  |     | NULL    |                |
 +-----------------+------------------+------+-----+---------+-------------- --+

[Updated on: Wed, 29 October 2003 17:15]

Report message to a moderator

Re: 2.6.0 upgrades failing [message #13873 is a reply to message #13871] Wed, 29 October 2003 17:39 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
it appears that none of the new fields are being created. Could you check if the files (*.tbl) inside the sql/ directory were replaced/changed?

FUDforum Core Developer
Re: 2.6.0 upgrades failing [message #13886 is a reply to message #13873] Wed, 29 October 2003 21:18 Go to previous messageGo to next message
tgaastra is currently offline  tgaastra   United States
Messages: 90
Registered: June 2002
Karma: 0
Member
add to buddy list
ignore all messages by this user
I don't know. I'd have to re-apply the upgrade, which I know will break things, to see, so I don't know when I'll have a chance to do that in the next couple days.
Re: 2.6.0 upgrades failing [message #13887 is a reply to message #13886] Wed, 29 October 2003 21:22 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
K, let me know when you have more information.

FUDforum Core Developer
Re: 2.6.0 upgrades failing [message #13968 is a reply to message #13887] Sun, 02 November 2003 01:56 Go to previous messageGo to next message
hy2jinxnc is currently offline  hy2jinxnc   United States
Messages: 25
Registered: October 2003
Location: NC
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user

Same error message here.
Current FUD: 2.5.2
Upgrade script: v2.6.0RC2 from web
MySQL: 3.23.56
PHP: 4.2.2
safe_mode: off
no *.myd/myi files were modified/replaced

fud25_msg:
| Field | Type | Null | Key | Default | Extra |
+-----------------+------------------+------+-----+---------+-------------- --+
| id | int(10) unsigned | | PRI | NULL | auto_increment |
| thread_id | int(10) unsigned | | MUL | 0 | |
| poster_id | int(10) unsigned | | MUL | 0 | |
| reply_to | int(10) unsigned | | | 0 | |
| ip_addr | varchar(15) | | MUL | 0.0.0.0 | |
| host_name | varchar(255) | YES | | NULL | |
| post_stamp | int(10) unsigned | | MUL | 0 | |
| update_stamp | int(10) unsigned | | | 0 | |
| updated_by | int(10) unsigned | | | 0 | |
| icon | varchar(100) | YES | | NULL | |
| subject | varchar(100) | | MUL | | |
| attach_cnt | int(10) unsigned | | MUL | 0 | |
| poll_id | int(10) unsigned | | MUL | 0 | |
| approved | enum('Y','N') | | MUL | N | |
| show_sig | enum('Y','N') | | | Y | |
| smiley_disabled | enum('Y','N') | | | N | |
| foff | int(10) unsigned | | | 0 | |
| length | int(10) unsigned | | | 0 | |
| file_id | int(10) unsigned | | | 1 | |
| offset_preview | int(10) unsigned | | | 0 | |
| length_preview | int(10) unsigned | | | 0 | |
| file_id_preview | int(10) unsigned | | | 0 | |
| attach_cache | text | YES | | NULL | |
| poll_cache | text | YES | | NULL | |
| mlist_msg_id | varchar(100) | YES | MUL | NULL | |
+-----------------+------------------+------+-----+---------+-------------- --+

This is my personal box and not live forum, so I'm game to tinker.
Re: 2.6.0 upgrades failing [message #13972 is a reply to message #13968] Sun, 02 November 2003 13:52 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
It appears that not a single index was created nor any new fields added. This means that the *.tbl tables you have were not replaced by the setup. Could you attach fud_msg.tbl to your reply please?

FUDforum Core Developer
Re: 2.6.0 upgrades failing [message #13977 is a reply to message #13972] Sun, 02 November 2003 14:24 Go to previous messageGo to next message
hy2jinxnc is currently offline  hy2jinxnc   United States
Messages: 25
Registered: October 2003
Location: NC
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user

Files (frm, myi, myd) too large to attach. Available here (4.5meg):
(edited as it was incorrect) Confused

Interestingly this morning, after bootup and therefore a restart of MySQL, I'm now getting:
DESCRIBE fud25_msg;
ERROR 1033: Incorrect information in file: './FUDforum/fud25_msg.frm'

When I get time later today I will restore 2.5.2 (yes, I made a backup) and retry the upgrade again to see if this was a fluke on my part.

[Updated on: Sun, 02 November 2003 14:43]

Report message to a moderator

Re: 2.6.0 upgrades failing [message #13979 is a reply to message #13977] Sun, 02 November 2003 14:32 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
I don't need the mysql database files, those are useless to me. I was asking for FUDforum's *.tbl files that can be found inside the sql/ directory of FUDforum.

FUDforum Core Developer
Re: 2.6.0 upgrades failing [message #13982 is a reply to message #13979] Sun, 02 November 2003 14:41 Go to previous messageGo to next message
hy2jinxnc is currently offline  hy2jinxnc   United States
Messages: 25
Registered: October 2003
Location: NC
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user

Right... right. Color me red. I've had my head stuck in database mode for too long (other projects).

File attached and yes the date is concurrent to when I ran the upgrade script. However there is still a fud_msg.tbl in /sql/mysql that has the old date if it matters.

TY
Re: 2.6.0 upgrades failing [message #13986 is a reply to message #13982] Sun, 02 November 2003 15:16 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
The file you've sent me appears to be correct, the .tbl files inside mysql/ & pgsql/ directories are not (should not be) used and are absolete. If you would to install a new FUDforum you wouldn't have them.

Clearly there is something wrong with the intial table, question is what :/

Ok, let's try to add some debug code and try to see what breaks. Open upgrade.php and find line which says:
$db_col = get_fud_col_list($tbl['name']);

After that line add:
var_dump('<pre>', $db_col, $tbl['flds'], $v, '</pre>').

Reply with the output.

P.S. If you can join irc.freenode.org (IRC server) #fudforum channel we can talk realtime and probably resolve the problem much faster.


FUDforum Core Developer
Re: 2.6.0 upgrades failing [message #13992 is a reply to message #13986] Sun, 02 November 2003 22:41 Go to previous messageGo to next message
hy2jinxnc is currently offline  hy2jinxnc   United States
Messages: 25
Registered: October 2003
Location: NC
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user

In function glob... change line $ext =... to? I thought I'd turned conversation logging on and therefore rm -rf'ed my FUD directories for the restore. Rolling Eyes
Re: 2.6.0 upgrades failing [message #13997 is a reply to message #13992] Mon, 03 November 2003 08:59 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Change '\.' to '\\'

FUDforum Core Developer
Re: 2.6.0 upgrades failing [message #14011 is a reply to message #13863] Mon, 03 November 2003 19:00 Go to previous messageGo to next message
Juanisan is currently offline  Juanisan   United States
Messages: 24
Registered: July 2002
Location: Conshohocken, PA
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
DITTO!

http://utadmins.homelinux.com/forum/upgrade.php
Checking if SQL permissions to perform the upgrade are avaliable
Disable the forum
Forum is now disabled
Beginning the file upgrade process
Begining to decompress the archive
Finished decompressing the archive
File Upgrade Complete
Any changed files were backed up to: "/var/www/forum-uta/errors/.backup/"

Beginning SQL Upgrades
SQL Upgrades Complete
MySQL Error: #1054 (Unknown column 'theme_opt' in 'where clause'): SELECT id FROM fud25_themes WHERE (theme_opt & 3) > 0 LIMIT 1

http://utadmins.homelinux.com/forum/adm/admloginuser.php
(admloginuser.php) 1054: Unknown column 'users_opt' in 'where clause'
Query: SELECT id FROM fud25_users WHERE login='BAR|BeerThePenguin' AND passwd='4c39e90d6a5c38a3f8a9b1f05840f240' AND users_opt>=1048576 AND (users_opt & 1048576) > 0
Server Version: 3.23.56
[Referring Page] http://utadmins.homelinux.com/forum/adm/admloginuser.php

Please, how do i fix?


Never ask a geek why, just nod your head and slowly back away.
Re: 2.6.0 upgrades failing [message #14012 is a reply to message #14011] Mon, 03 November 2003 19:11 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Try the install script at:
http://bb.prohost.org/upgrade.tar.gz


FUDforum Core Developer
Re: 2.6.0 upgrades failing [message #14013 is a reply to message #13997] Mon, 03 November 2003 19:43 Go to previous messageGo to next message
hy2jinxnc is currently offline  hy2jinxnc   United States
Messages: 25
Registered: October 2003
Location: NC
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user

Ilia wrote on Mon, 03 November 2003 08:59

Change '\.' to '\\'


Worked beautifully. TY
Re: 2.6.0 upgrades failing [message #14015 is a reply to message #14013] Mon, 03 November 2003 19:50 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Great...

FUDforum Core Developer
Re: 2.6.0 upgrades failing [message #14039 is a reply to message #14015] Tue, 04 November 2003 08:52 Go to previous messageGo to next message
plugz is currently offline  plugz   Lithuania
Messages: 23
Registered: November 2003
Location: Kaunas, Lithuania
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
i upgraded with script find here but i cannot login with administrator, i type in accound and password but then after pressing button nothing happens only info i entered dissaper... so i can't enable forum...
Re: 2.6.0 upgrades failing [message #14040 is a reply to message #14039] Tue, 04 November 2003 09:00 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Are you logging in via the normal login or the admin one (adm/)?

FUDforum Core Developer
Re: 2.6.0 upgrades failing [message #14041 is a reply to message #14040] Tue, 04 November 2003 09:23 Go to previous messageGo to next message
plugz is currently offline  plugz   Lithuania
Messages: 23
Registered: November 2003
Location: Kaunas, Lithuania
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
normal i cannot acces becouse forum after upgrading disabled vie adm
Re: 2.6.0 upgrades failing [message #14043 is a reply to message #14041] Tue, 04 November 2003 09:33 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Try to login via admin control panel login form, by going to http://your_forum_url/adm/

FUDforum Core Developer
Re: 2.6.0 upgrades failing [message #14044 is a reply to message #14043] Tue, 04 November 2003 09:39 Go to previous messageGo to next message
plugz is currently offline  plugz   Lithuania
Messages: 23
Registered: November 2003
Location: Kaunas, Lithuania
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
same... nothing happens simply flushing info and getting new blank login form

[Updated on: Tue, 04 November 2003 09:40]

Report message to a moderator

Re: 2.6.0 upgrades failing [message #14048 is a reply to message #14044] Tue, 04 November 2003 11:25 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Resolved, fix will be in the CVS shortly.

FUDforum Core Developer
Re: 2.6.0 upgrades failing [message #14088 is a reply to message #14012] Wed, 05 November 2003 03:21 Go to previous message
Juanisan is currently offline  Juanisan   United States
Messages: 24
Registered: July 2002
Location: Conshohocken, PA
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Ilia wrote on Mon, 03 November 2003 19:11

Try the install script at:
http://bb.prohost.org/upgrade.tar.gz

This worked fabulously.. Very Happy


Never ask a geek why, just nod your head and slowly back away.
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: If I upgrade I loos the custom config.
Next Topic: Upgrade 2.5.3RC3 to 2.6.0RC3 fails
Goto Forum:
  

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

Current Time: Mon Dec 11 14:14:29 EST 2017

Total time taken to generate the page: 0.01062 seconds