[Beta7] Upgrade bleibt hängen bei Step 16

[kaihawaii]

- Firebird + Cookies oder ie + cookies
- Posts etwa 60.000
- Kein Statusbar oder dgl. deutet auf Aktivität hin
- Dauer momentan 15 Minuten

[kaihawaii]

- tabllenkompatibilitätstool habe ich vorher genutzt => OK
- erneut aufgerufen =>

Step 16) Update Thread and Post Table

Please note, these steps may take several minutes to complete if you have a large number of posts in your database.

* Altering Post Table...



There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

[kaihawaii]

anbei die zugrundliegende struktur vor der konvertierung


# Tabellenstruktur für Tabelle `access`
#

CREATE TABLE access (
userid int(10) unsigned NOT NULL default '0',
forumid smallint(5) unsigned NOT NULL default '0',
accessmask smallint(5) unsigned NOT NULL default '0',
UNIQUE KEY userid (userid,forumid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `adminlog`
#

CREATE TABLE adminlog (
adminlogid int(10) unsigned NOT NULL auto_increment,
userid int(10) unsigned NOT NULL default '0',
dateline int(10) unsigned NOT NULL default '0',
script varchar(20) NOT NULL default '',
action varchar(20) NOT NULL default '',
extrainfo varchar(200) NOT NULL default '',
ipaddress varchar(15) NOT NULL default '',
PRIMARY KEY (adminlogid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `adminutil`
#

CREATE TABLE adminutil (
title varchar(10) NOT NULL default '',
text mediumtext NOT NULL,
PRIMARY KEY (title)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `announcement`
#

CREATE TABLE announcement (
announcementid smallint(5) unsigned NOT NULL auto_increment,
title varchar(250) NOT NULL default '',
userid int(10) unsigned NOT NULL default '0',
startdate int(10) unsigned NOT NULL default '0',
enddate int(10) unsigned NOT NULL default '0',
pagetext mediumtext NOT NULL,
forumid smallint(6) NOT NULL default '0',
PRIMARY KEY (announcementid),
KEY forumid (forumid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `attachment`
#

CREATE TABLE attachment (
attachmentid smallint(5) unsigned NOT NULL auto_increment,
userid int(10) unsigned NOT NULL default '0',
dateline int(10) unsigned NOT NULL default '0',
filename varchar(100) NOT NULL default '',
filedata mediumtext NOT NULL,
visible smallint(5) unsigned NOT NULL default '0',
counter smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (attachmentid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `avatar`
#

CREATE TABLE avatar (
avatarid smallint(5) unsigned NOT NULL auto_increment,
title char(100) NOT NULL default '',
minimumposts smallint(6) NOT NULL default '0',
avatarpath char(100) NOT NULL default '',
PRIMARY KEY (avatarid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `bbcode`
#

CREATE TABLE bbcode (
bbcodeid smallint(5) unsigned NOT NULL auto_increment,
bbcodetag varchar(200) NOT NULL default '',
bbcodereplacement varchar(200) NOT NULL default '',
bbcodeexample varchar(200) NOT NULL default '',
bbcodeexplanation mediumtext NOT NULL,
twoparams smallint(6) NOT NULL default '0',
PRIMARY KEY (bbcodeid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `calendar_events`
#

CREATE TABLE calendar_events (
eventid int(10) unsigned NOT NULL auto_increment,
userid int(10) unsigned NOT NULL default '0',
event mediumtext NOT NULL,
eventdate date NOT NULL default '0000-00-00',
public smallint(5) unsigned NOT NULL default '0',
subject varchar(254) NOT NULL default '',
allowsmilies smallint(6) NOT NULL default '1',
PRIMARY KEY (eventid),
KEY userid (userid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `customavatar`
#

CREATE TABLE customavatar (
userid int(10) unsigned NOT NULL default '0',
avatardata mediumtext NOT NULL,
dateline int(10) unsigned NOT NULL default '0',
filename varchar(100) NOT NULL default '',
PRIMARY KEY (userid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `forum`
#

CREATE TABLE forum (
forumid smallint(5) unsigned NOT NULL auto_increment,
styleid smallint(5) unsigned NOT NULL default '0',
title char(100) NOT NULL default '',
description char(250) NOT NULL default '',
active smallint(6) NOT NULL default '0',
displayorder smallint(6) NOT NULL default '0',
replycount int(10) unsigned NOT NULL default '0',
lastpost int(11) NOT NULL default '0',
lastposter char(50) NOT NULL default '',
threadcount mediumint(8) unsigned NOT NULL default '0',
allowposting tinyint(4) NOT NULL default '0',
cancontainthreads smallint(6) NOT NULL default '0',
daysprune smallint(5) unsigned NOT NULL default '0',
newpostemail char(250) NOT NULL default '',
newthreademail char(250) NOT NULL default '',
moderatenew smallint(6) NOT NULL default '0',
moderateattach smallint(6) NOT NULL default '0',
allowbbcode smallint(6) NOT NULL default '0',
allowimages smallint(6) NOT NULL default '0',
allowhtml smallint(6) NOT NULL default '0',
allowsmilies smallint(6) NOT NULL default '0',
allowicons smallint(6) NOT NULL default '0',
parentid smallint(6) NOT NULL default '0',
parentlist char(250) NOT NULL default '',
allowratings smallint(6) NOT NULL default '0',
countposts smallint(6) NOT NULL default '1',
styleoverride smallint(5) NOT NULL default '0',
PRIMARY KEY (forumid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `forumpermission`
#

CREATE TABLE forumpermission (
forumpermissionid smallint(5) unsigned NOT NULL auto_increment,
forumid smallint(5) unsigned NOT NULL default '0',
usergroupid smallint(5) unsigned NOT NULL default '0',
canview smallint(6) NOT NULL default '0',
cansearch smallint(6) NOT NULL default '0',
canemail smallint(6) NOT NULL default '0',
canpostnew smallint(6) NOT NULL default '0',
canmove smallint(6) NOT NULL default '0',
canopenclose smallint(6) NOT NULL default '0',
candeletethread smallint(6) NOT NULL default '0',
canreplyown smallint(6) NOT NULL default '0',
canreplyothers smallint(6) NOT NULL default '0',
canviewothers smallint(6) NOT NULL default '0',
caneditpost smallint(6) NOT NULL default '0',
candeletepost smallint(6) NOT NULL default '0',
canpostattachment smallint(6) NOT NULL default '0',
canpostpoll smallint(6) NOT NULL default '0',
canvote smallint(6) NOT NULL default '0',
cangetattachment smallint(6) NOT NULL default '1',
PRIMARY KEY (forumpermissionid),
KEY ugid_fid (usergroupid,forumid)
) TYPE=MyISAM;
# --------------------------------------------------------

[kaihawaii]

#
# Tabellenstruktur für Tabelle `icon`
#

CREATE TABLE icon (
iconid smallint(5) unsigned NOT NULL auto_increment,
title char(100) NOT NULL default '',
iconpath char(100) NOT NULL default '',
PRIMARY KEY (iconid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `moderator`
#

CREATE TABLE moderator (
moderatorid smallint(5) unsigned NOT NULL auto_increment,
userid int(10) unsigned NOT NULL default '0',
forumid smallint(6) NOT NULL default '0',
newthreademail smallint(6) NOT NULL default '0',
newpostemail smallint(6) NOT NULL default '0',
caneditposts smallint(6) NOT NULL default '0',
candeleteposts smallint(6) NOT NULL default '0',
canviewips smallint(6) NOT NULL default '0',
canmanagethreads smallint(6) NOT NULL default '0',
canopenclose smallint(6) NOT NULL default '0',
caneditthreads smallint(6) NOT NULL default '0',
caneditstyles smallint(6) NOT NULL default '0',
canbanusers smallint(6) NOT NULL default '0',
canviewprofile smallint(6) NOT NULL default '0',
canannounce smallint(6) NOT NULL default '0',
canmassmove smallint(6) NOT NULL default '0',
canmassprune smallint(6) NOT NULL default '0',
canmoderateposts smallint(6) NOT NULL default '0',
canmoderateattachments smallint(6) NOT NULL default '0',
PRIMARY KEY (moderatorid),
KEY userid (userid,forumid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `poll`
#

CREATE TABLE poll (
pollid int(10) unsigned NOT NULL auto_increment,
question varchar(100) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
options text NOT NULL,
votes text NOT NULL,
active smallint(6) NOT NULL default '1',
numberoptions smallint(5) unsigned NOT NULL default '0',
timeout smallint(5) unsigned NOT NULL default '0',
multiple smallint(5) unsigned NOT NULL default '0',
voters smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (pollid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `pollvote`
#

CREATE TABLE pollvote (
pollvoteid int(10) unsigned NOT NULL auto_increment,
pollid int(10) unsigned NOT NULL default '0',
userid int(10) unsigned NOT NULL default '0',
votedate int(10) unsigned NOT NULL default '0',
voteoption int(10) unsigned NOT NULL default '0',
PRIMARY KEY (pollvoteid),
KEY userid (userid,pollid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `post`
#

CREATE TABLE post (
postid int(10) unsigned NOT NULL auto_increment,
threadid int(10) unsigned NOT NULL default '0',
username varchar(50) NOT NULL default '',
userid int(10) unsigned NOT NULL default '0',
title varchar(100) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
attachmentid smallint(5) unsigned NOT NULL default '0',
pagetext mediumtext NOT NULL,
allowsmilie smallint(6) NOT NULL default '0',
showsignature smallint(6) NOT NULL default '0',
ipaddress varchar(16) NOT NULL default '',
iconid smallint(5) unsigned NOT NULL default '0',
visible smallint(6) NOT NULL default '0',
edituserid int(10) unsigned NOT NULL default '0',
editdate int(10) unsigned NOT NULL default '0',
PRIMARY KEY (postid),
KEY iconid (iconid),
KEY userid (userid),
KEY threadid (threadid,userid)
) TYPE=MyISAM;

[kaihawaii]

welche schritte werden bei step 16 durchgeführt? ich vermute fast, dass das skript die php-ausführungszeit überschreitet. werde das zunächst wohl zu fuss via ssh machen müssen.

[pogo]

Original geschrieben von kaihawaii
* Altering Post Table...



There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.
Schau mal bitte in den Quellcode der Seite, wenn du diese Fehlermeldung siehst. Dort steht drin, was genau falsch gelaufen ist. Nur mit dieser Info können wir dem Problem auf die Schliche kommen.

[kaihawaii]

hi, habe die schritte manuell ausgeführt bekomme im adminpanel aber noch einen fehler, wenn ich "Rebuild Thread Information" durchführe:
Database error in vBulletin 3.0.0 Beta 7:

Invalid SQL:
UPDATE thread SET
firstpostid = 1,
postusername = *,
postuserid = *,
lastpost = 1010263143,
replycount = 0,
attach = 0,
dateline = 1010263143,
lastposter = '*'
WHERE threadid = 1

mysql error: Unknown column 'firstpostid' in 'field list'

[kaihawaii]

habe es per hand gefixt. läuft jetzt soweit alles.