FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » FUDforum » FUDforum Installation Issues » 2.6RC1 upgrade fron 2.5.3RC3 issue
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
2.6RC1 upgrade fron 2.5.3RC3 issue [message #13777] Mon, 27 October 2003 17:13 Go to next message
AzaToth is currently offline  AzaToth   Sweden
Messages: 125
Registered: October 2003
Karma: 0
Senior Member
got:
Quote:

MySQL Error: #1075 (Incorrect table definition; There can only be one auto column and it must be defined as a key): ALTER TABLE fud25_thread_view DROP INDEX forum_id

Report message to a moderator

Re: 2.6RC1 upgrade fron 2.5.3RC3 issue [message #13778 is a reply to message #13777] Mon, 27 October 2003 17: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
Can you please output of the following mysql command:

DESCRIBE fud25_thread_view;

FUDforum Core Developer

Report message to a moderator

Re: 2.6RC1 upgrade fron 2.5.3RC3 issue [message #13779 is a reply to message #13777] Mon, 27 October 2003 17:31 Go to previous messageGo to next message
AzaToth is currently offline  AzaToth   Sweden
Messages: 125
Registered: October 2003
Karma: 0
Senior Member
Hmm, I installed a totaly new version instead, because it's only on our test-server;
I notice that in the install-php script, there is a typo:
on line 31, there is a '=' missing.

Report message to a moderator

Re: 2.6RC1 upgrade fron 2.5.3RC3 issue [message #13780 is a reply to message #13778] Mon, 27 October 2003 17:32 Go to previous messageGo to next message
AzaToth is currently offline  AzaToth   Sweden
Messages: 125
Registered: October 2003
Karma: 0
Senior Member
Den mån, 27 oktober 2003 18:25 skrev Ilia:

Can you please output of the following mysql command:

DESCRIBE fud25_thread_view;

mysql> DESCRIBE fud25_thread_view;
+-----------+---------+------+-----+---------+----------------+
| Field     | Type    | Null | Key | Default | Extra          |
+-----------+---------+------+-----+---------+----------------+
| forum_id  | int(11) |      | PRI | 0       |                |
| page      | int(11) |      | PRI | 0       |                |
| thread_id | int(11) |      |     | 0       |                |
| pos       | int(11) |      | PRI | NULL    | auto_increment |
| tmp       | int(11) | YES  |     | NULL    |                |
+-----------+---------+------+-----+---------+----------------+
5 rows in set (0.00 sec)

Report message to a moderator

Re: 2.6RC1 upgrade fron 2.5.3RC3 issue [message #13781 is a reply to message #13779] Mon, 27 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
Good catch, I fixed it in the CVS and will update the online archives shortly.

I wonder why php -l didn't catch it...

FUDforum Core Developer

Report message to a moderator

Re: 2.6RC1 upgrade fron 2.5.3RC3 issue [message #13782 is a reply to message #13777] Mon, 27 October 2003 17:43 Go to previous messageGo to next message
AzaToth is currently offline  AzaToth   Sweden
Messages: 125
Registered: October 2003
Karma: 0
Senior Member
I have managed to install (not upgrade) it now, but how can I convert my 2.5.3 theme?

Report message to a moderator

Re: 2.6RC1 upgrade fron 2.5.3RC3 issue [message #13783 is a reply to message #13780] Mon, 27 October 2003 17:44 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
I'll try upgrading a new install of 2.5.3RC3 in a moment, I wonder why I did not get such an error myself. Your table structure for the table in question seems fine.

FUDforum Core Developer

Report message to a moderator

Re: 2.6RC1 upgrade fron 2.5.3RC3 issue [message #13784 is a reply to message #13782] Mon, 27 October 2003 17:45 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
I suspect majority of the changes would be inside forum.css.tmpl ?
Apply the changes from your existing forum.css.tmpl to the new one and you should be set.

FUDforum Core Developer

Report message to a moderator

Re: 2.6RC1 upgrade fron 2.5.3RC3 issue [message #13785 is a reply to message #13777] Mon, 27 October 2003 17:48 Go to previous messageGo to next message
AzaToth is currently offline  AzaToth   Sweden
Messages: 125
Registered: October 2003
Karma: 0
Senior Member
can you give me a diff, because I have not the original forum.css.tmpl left Smile

I did mayor changes there on my own hehe...

[Updated on: Mon, 27 October 2003 17:49]

Report message to a moderator

Re: 2.6RC1 upgrade fron 2.5.3RC3 issue [message #13789 is a reply to message #13777] Mon, 27 October 2003 18:03 Go to previous messageGo to next message
AzaToth is currently offline  AzaToth   Sweden
Messages: 125
Registered: October 2003
Karma: 0
Senior Member
Ok, tried to make a new theme from scratch, got:
Quote:

DUPE: SECTION -> was_moved_msg_lnk found in (now parsing )

Report message to a moderator

Re: 2.6RC1 upgrade fron 2.5.3RC3 issue [message #13790 is a reply to message #13785] Mon, 27 October 2003 18:20 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
AzaToth wrote on Mon, 27 October 2003 12:48

can you give me a diff, because I have not the original forum.css.tmpl left Smile

I did mayor changes there on my own hehe...


Here is the forum.css.tmpl from FUDforum 2.5.3RC3

P.S. You can get those files yourself from the CVS, by specifying tag fud2_5_3RC3

FUDforum Core Developer

Report message to a moderator

Re: 2.6RC1 upgrade fron 2.5.3RC3 issue [message #13791 is a reply to message #13789] Mon, 27 October 2003 18:21 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
AzaToth wrote on Mon, 27 October 2003 13:03

Ok, tried to make a new theme from scratch, got:
Quote:

DUPE: SECTION -> was_moved_msg_lnk found in (now parsing )



Based on which template set was this theme created, defualt or path_info?

FUDforum Core Developer

Report message to a moderator

Re: 2.6RC1 upgrade fron 2.5.3RC3 issue [message #13792 is a reply to message #13791] Mon, 27 October 2003 18:27 Go to previous messageGo to next message
AzaToth is currently offline  AzaToth   Sweden
Messages: 125
Registered: October 2003
Karma: 0
Senior Member
Den mån, 27 oktober 2003 19:21 skrev Ilia:

AzaToth wrote on Mon, 27 October 2003 13:03

Ok, tried to make a new theme from scratch, got:
Quote:

DUPE: SECTION -> was_moved_msg_lnk found in (now parsing )



Based on which template set was this theme created, defualt or path_info?

default

Report message to a moderator

Re: 2.6RC1 upgrade fron 2.5.3RC3 issue [message #13794 is a reply to message #13792] Mon, 27 October 2003 20: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
Fixed in CVS.

Replace your compiler.inc with the one attached and the problem will go away.
  • Attachment: compiler.inc
    (Size: 18.10KB, Downloaded 768 times)


FUDforum Core Developer

Report message to a moderator

Re: 2.6RC1 upgrade fron 2.5.3RC3 issue [message #13795 is a reply to message #13794] Mon, 27 October 2003 21:02 Go to previous messageGo to next message
AzaToth is currently offline  AzaToth   Sweden
Messages: 125
Registered: October 2003
Karma: 0
Senior Member
Den mån, 27 oktober 2003 21:52 skrev Ilia:

Fixed in CVS.

Replace your compiler.inc with the one attached and the problem will go away.

thanx, works now Smile

Report message to a moderator

Re: 2.6RC1 upgrade fron 2.5.3RC3 issue [message #13797 is a reply to message #13795] Mon, 27 October 2003 21:54 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
Regarding the MySQL error you saw, did you forum have any information in it or was it blank?

I tried to replicate the problem by installing a fresh 2.5.3RC3 and then immidiately upgrading it to 2.6.0RC1 and recieved no errors. Any additional info you can think of would be most helpful.

FUDforum Core Developer

Report message to a moderator

Re: 2.6RC1 upgrade fron 2.5.3RC3 issue [message #13798 is a reply to message #13797] Mon, 27 October 2003 21:57 Go to previous messageGo to next message
AzaToth is currently offline  AzaToth   Sweden
Messages: 125
Registered: October 2003
Karma: 0
Senior Member
Den mån, 27 oktober 2003 22:54 skrev Ilia:

Regarding the MySQL error you saw, did you forum have any information in it or was it blank?

I tried to replicate the problem by installing a fresh 2.5.3RC3 and then immidiately upgrading it to 2.6.0RC1 and recieved no errors. Any additional info you can think of would be most helpful.

it had som "testing" information inside, like some test threads, and test topics.
We had tried to use every feature to see if the theme is correct.

Report message to a moderator

Re: 2.6RC1 upgrade fron 2.5.3RC3 issue [message #13799 is a reply to message #13798] Mon, 27 October 2003 22:03 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
Ok, I'll keep on trying to duplicate the problem.

Btw which version of MySQL were you using?

FUDforum Core Developer

Report message to a moderator

Re: 2.6RC1 upgrade fron 2.5.3RC3 issue [message #13800 is a reply to message #13799] Mon, 27 October 2003 22:05 Go to previous messageGo to next message
AzaToth is currently offline  AzaToth   Sweden
Messages: 125
Registered: October 2003
Karma: 0
Senior Member
Den mån, 27 oktober 2003 23:03 skrev Ilia:

Ok, I'll keep on trying to duplicate the problem.

Btw which version of MySQL were you using?

mysql Ver 12.21 Distrib 4.0.15, for pc-linux-gnu (i686)

Report message to a moderator

Re: 2.6RC1 upgrade fron 2.5.3RC3 issue [message #13831 is a reply to message #13800] Tue, 28 October 2003 19:45 Go to previous messageGo to next message
Hkkathome is currently offline  Hkkathome   Sweden
Messages: 42
Registered: June 2002
Location: [Sweden][Stockholm]
Karma: 0
Member
I've got the exact same error message as Azatoth. I'm upgrading from FUD 2.5.2 and are using MySQL dist 4.0.15 for Windows.

Hkkathome(TM) as always...

Report message to a moderator

Re: 2.6RC1 upgrade fron 2.5.3RC3 issue [message #13835 is a reply to message #13777] Tue, 28 October 2003 22:49 Go to previous messageGo to next message
jbodnar is currently offline  jbodnar   United States
Messages: 15
Registered: April 2003
Karma: 0
Junior Member
I've got the same mysql error as well, but I can't really follow this thread. Will replacing compiler.inc fix the mysql problem?

Looking at the indexes for fud23_thread_view the error makes sense. If you drop the forum_id index, which is comprised of fields forum_id, page and pos, pos, which is auto_increment, will no longer be a key, which mysql seems to need.

Report message to a moderator

Re: 2.6RC1 upgrade fron 2.5.3RC3 issue [message #13837 is a reply to message #13835] Tue, 28 October 2003 23:01 Go to previous messageGo to next message
Hkkathome is currently offline  Hkkathome   Sweden
Messages: 42
Registered: June 2002
Location: [Sweden][Stockholm]
Karma: 0
Member
I have no tested to update a totally empty forum (v2.3.2) to 2.6.0RC1. The same problem. Seems like the problem is in MySQL somehow.

Hkkathome(TM) as always...

Report message to a moderator

Re: 2.6RC1 upgrade fron 2.5.3RC3 issue [message #13839 is a reply to message #13835] Tue, 28 October 2003 23:08 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
jbodnar wrote on Tue, 28 October 2003 17:49

I've got the same mysql error as well, but I can't really follow this thread. Will replacing compiler.inc fix the mysql problem?

Looking at the indexes for fud23_thread_view the error makes sense. If you drop the forum_id index, which is comprised of fields forum_id, page and pos, pos, which is auto_increment, will no longer be a key, which mysql seems to need.



Which version of MySQL are you using? I am trying to see if this is 4.0 specific issue or if it affects any MySQL install, which seems unlikely since it works fine here...

FUDforum Core Developer

Report message to a moderator

Re: 2.6RC1 upgrade fron 2.5.3RC3 issue [message #13840 is a reply to message #13839] Tue, 28 October 2003 23:13 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
The error makes sense, but should not happen, since old indexes are removed only after the new indexes are added. Meaning that something prevented the indexes from being added.

Could you please tell me what do you when you run:

show index from fud23_thread_view;

(replace table prefix as needed).

FUDforum Core Developer

[Updated on: Tue, 28 October 2003 23:13]

Report message to a moderator

Re: 2.6RC1 upgrade fron 2.5.3RC3 issue [message #13841 is a reply to message #13840] Wed, 29 October 2003 00:09 Go to previous messageGo to next message
jbodnar is currently offline  jbodnar   United States
Messages: 15
Registered: April 2003
Karma: 0
Junior Member
It appears the necessary indeces were not created as your table only contains old indexes. Meaning that the new indexes (created 1st) were not made.

Try adding the following to upgrade.php, before line

add_index($tbl['name'], $k, $v['unique'], $v['cols']);

add

echo "Adding Index {$k}<br />\n";

and then re-rerun the script, it should now report what indexes are being created.

Report message to a moderator

Re: 2.6RC1 upgrade fron 2.5.3RC3 issue [message #13842 is a reply to message #13841] Wed, 29 October 2003 00:26 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
Whoops, I edited the above message instead of replying :/

D'oh...

Anyhow the above message should give you directions on how to get more info on the problem.

FUDforum Core Developer

Report message to a moderator

Re: 2.6RC1 upgrade fron 2.5.3RC3 issue [message #13844 is a reply to message #13842] Wed, 29 October 2003 06:20 Go to previous messageGo to next message
jbodnar is currently offline  jbodnar   United States
Messages: 15
Registered: April 2003
Karma: 0
Junior Member
Added the above to update.php and I got:

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/errors/.backup/"

Beginning SQL Upgrades
MySQL Error: #1075 (Incorrect table definition; There can only be one auto column and it must be defined as a key): ALTER TABLE fud23_thread_view DROP INDEX forum_id

So it appears that no indexes are added. Time to dig around.

Jason

Report message to a moderator

Re: 2.6RC1 upgrade fron 2.5.3RC3 issue [message #13846 is a reply to message #13844] Wed, 29 October 2003 14:21 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
Indeed, are you also using MySQL 4.0 like Hkkathome is?

FUDforum Core Developer

Report message to a moderator

Re: 2.6RC1 upgrade fron 2.5.3RC3 issue [message #13849 is a reply to message #13846] Wed, 29 October 2003 16:06 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
I found the bug and fixed it, the fixed version was released as RC2.

FUDforum Core Developer

Report message to a moderator

  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: an install error
Next Topic: upgrade from 2.02 -> 2.52, stuck at Admin Login console
Goto Forum:
  

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

Current Time: Sun Dec 01 11:19:32 GMT 2024

Total time taken to generate the page: 0.02571 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software