FUDforum: FUDforum 3.0+ » 2.6.0 upgrades failing

Home » FUDforum Development » FUDforum 3.0+ » 2.6.0 upgrades failing

Show: Today's Messages :: Polls :: Message Navigator

2.6.0 upgrades failing [message #13863]

Wed, 29 October 2003 21:12

tgaastra

Messages: 90
Registered: June 2002

Karma: 0

Member

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 21:12]

Report message to a moderator

Re: 2.6.0 upgrades failing [message #13864 is a reply to message #13863]

Wed, 29 October 2003 21:19

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

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

Report message to a moderator

Re: 2.6.0 upgrades failing [message #13866 is a reply to message #13864]

Wed, 29 October 2003 21:21

tgaastra

Messages: 90
Registered: June 2002

Karma: 0

Member

MySQL 4.0.13

Report message to a moderator

Re: 2.6.0 upgrades failing [message #13869 is a reply to message #13866]

Wed, 29 October 2003 21:58

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Could you please tell me what is the output of:

DESCRIBE fud2_msg;

FUDforum Core Developer

Report message to a moderator

Re: 2.6.0 upgrades failing [message #13871 is a reply to message #13869]

Wed, 29 October 2003 22:15

tgaastra

Messages: 90
Registered: June 2002

Karma: 0

Member

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 22:15]

Report message to a moderator

Re: 2.6.0 upgrades failing [message #13873 is a reply to message #13871]

Wed, 29 October 2003 22:39

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

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

Report message to a moderator

Re: 2.6.0 upgrades failing [message #13886 is a reply to message #13873]

Thu, 30 October 2003 02:18

tgaastra

Messages: 90
Registered: June 2002

Karma: 0

Member

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.

Report message to a moderator

Re: 2.6.0 upgrades failing [message #13887 is a reply to message #13886]

Thu, 30 October 2003 02:22

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

K, let me know when you have more information.

FUDforum Core Developer

Report message to a moderator

Re: 2.6.0 upgrades failing [message #13968 is a reply to message #13887]

Sun, 02 November 2003 06:56

hy2jinxnc

Messages: 25
Registered: October 2003
Location: NC

Karma: 0

Junior Member

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.

Report message to a moderator

Re: 2.6.0 upgrades failing [message #13972 is a reply to message #13968]

Sun, 02 November 2003 18:52

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

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

Report message to a moderator

Re: 2.6.0 upgrades failing [message #13977 is a reply to message #13972]

Sun, 02 November 2003 19:24

hy2jinxnc

Messages: 25
Registered: October 2003
Location: NC

Karma: 0

Junior Member

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

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 19:43]

Report message to a moderator

Re: 2.6.0 upgrades failing [message #13979 is a reply to message #13977]

Sun, 02 November 2003 19:32

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

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

Report message to a moderator

Re: 2.6.0 upgrades failing [message #13982 is a reply to message #13979]

Sun, 02 November 2003 19:41

hy2jinxnc

Messages: 25
Registered: October 2003
Location: NC

Karma: 0

Junior Member

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

Attachment: fud_msg.tbl.gz
(Size: 0.74KB, Downloaded 993 times)

Report message to a moderator

Re: 2.6.0 upgrades failing [message #13986 is a reply to message #13982]

Sun, 02 November 2003 20:16

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

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

Report message to a moderator

Re: 2.6.0 upgrades failing [message #13992 is a reply to message #13986]

Mon, 03 November 2003 03:41

hy2jinxnc

Messages: 25
Registered: October 2003
Location: NC

Karma: 0

Junior Member

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

Rolling Eyes

Report message to a moderator

Re: 2.6.0 upgrades failing [message #13997 is a reply to message #13992]

Mon, 03 November 2003 13:59

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Change '\.' to '\\'

FUDforum Core Developer

Report message to a moderator

Re: 2.6.0 upgrades failing [message #14011 is a reply to message #13863]

Tue, 04 November 2003 00:00

Juanisan

Messages: 24
Registered: July 2002
Location: Conshohocken, PA

Karma: 0

Junior Member

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.

Report message to a moderator

Re: 2.6.0 upgrades failing [message #14012 is a reply to message #14011]

Tue, 04 November 2003 00:11

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

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

FUDforum Core Developer

Report message to a moderator

Re: 2.6.0 upgrades failing [message #14013 is a reply to message #13997]

Tue, 04 November 2003 00:43

hy2jinxnc

Messages: 25
Registered: October 2003
Location: NC

Karma: 0

Junior Member

Ilia wrote on Mon, 03 November 2003 08:59

Change '\.' to '\\'

Worked beautifully. TY

Report message to a moderator

Re: 2.6.0 upgrades failing [message #14015 is a reply to message #14013]

Tue, 04 November 2003 00:50

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Great...

FUDforum Core Developer

Report message to a moderator

Re: 2.6.0 upgrades failing [message #14039 is a reply to message #14015]

Tue, 04 November 2003 13:52

plugz

Messages: 23
Registered: November 2003
Location: Kaunas, Lithuania

Karma: 0

Junior Member

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

Report message to a moderator

Re: 2.6.0 upgrades failing [message #14040 is a reply to message #14039]

Tue, 04 November 2003 14:00

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Are you logging in via the normal login or the admin one (adm/)?

FUDforum Core Developer

Report message to a moderator

Re: 2.6.0 upgrades failing [message #14041 is a reply to message #14040]

Tue, 04 November 2003 14:23

plugz

Messages: 23
Registered: November 2003
Location: Kaunas, Lithuania

Karma: 0

Junior Member

normal i cannot acces becouse forum after upgrading disabled vie adm

Report message to a moderator

Re: 2.6.0 upgrades failing [message #14043 is a reply to message #14041]

Tue, 04 November 2003 14:33

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Try to login via admin control panel login form, by going to http://your_forum_url/adm/

FUDforum Core Developer

Report message to a moderator

Re: 2.6.0 upgrades failing [message #14044 is a reply to message #14043]

Tue, 04 November 2003 14:39

plugz

Messages: 23
Registered: November 2003
Location: Kaunas, Lithuania

Karma: 0

Junior Member

same... nothing happens simply flushing info and getting new blank login form

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

Report message to a moderator

Re: 2.6.0 upgrades failing [message #14048 is a reply to message #14044]

Tue, 04 November 2003 16:25

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Resolved, fix will be in the CVS shortly.

FUDforum Core Developer

Report message to a moderator

Re: 2.6.0 upgrades failing [message #14088 is a reply to message #14012]

Wed, 05 November 2003 08:21

Juanisan

Messages: 24
Registered: July 2002
Location: Conshohocken, PA

Karma: 0

Junior Member

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

Very Happy

Never ask a geek why, just nod your head and slowly back away.

Report message to a moderator

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) ] [

]

Current Time: Mon Nov 25 00:21:07 GMT 2024

Total time taken to generate the page: 0.05280 seconds