3.8.4 to 4.0.7 OK. 4.0.8 DB error

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • arturvill
    New Member
    • Jul 2004
    • 27
    • 2.3.0
    #1

    [Suite] 3.8.4 to 4.0.7 OK. 4.0.8 DB error

    Hi, I've tried to upgrade my vb3 to v4 but failed when got to 4.0.8 Step 1 (Misc Changes).

    So I've downloaded v4.0.7 and upgrade from v3 was fine. I ran DB repair from admincp and tried to upgrade from v4.0.7 to v4.0.8 again but getting same DB error message.

    Database error in vBulletin 4.0.7:

    Invalid SQL:
    ALTER TABLE post DROP INDEX userid, ADD INDEX userid (userid, parentid);

    MySQL Error : Can't DROP 'userid'; check that column/key exists
    Error Number : 1091
    ...
    Classname : vB_Database
    MySQL Version : 5.1.48-log
    My vB has no mods/plugins. Running on MySQL v5.1.48 and PHP v5.2.14

    any ideas?
    Tags: upgrade database error
    • borbole
      Senior Member
      • Feb 2010
      • 3074
      • 4.0.0
      #2
      Originally posted by arturvill
      Hi, I've tried to upgrade my vb3 to v4 but failed when got to 4.0.8 Step 1 (Misc Changes).

      So I've downloaded v4.0.7 and upgrade from v3 was fine. I ran DB repair from admincp and tried to upgrade from v4.0.7 to v4.0.8 again but getting same DB error message.

      Database error in vBulletin 4.0.7:



      My vB has no mods/plugins. Running on MySQL v5.1.48 and PHP v5.2.14

      any ideas?
      Can you run this query at your phpmyadmin?

      Code:
      SHOW columns FROM post;
      And list here the results.

        Comment

        • arturvill
          New Member
          • Jul 2004
          • 27
          • 2.3.0
          #3
          Code:
          [B]Field		Type			Null	Key	Default	Extra[/B]

postid		int(10) unsigned	NO	PRI	NULL	auto_increment
threadid	int(10) unsigned	NO	MUL	0	 
username	varchar(100)		NO	 	 	 
userid		int(10) unsigned	NO	 	0	 
title		varchar(250)		NO	 	 	 
dateline	int(11)			NO	MUL	0	 
pagetext	mediumtext		YES	 	NULL	 
allowsmilie	smallint(6)		NO	 	0	 
showsignature	smallint(6)		NO	 	0	 
ipaddress	varchar(16)		NO	MUL	 	 
iconid		smallint(5) unsigned	NO	 	0	 
visible		smallint(6)		NO	 	0	 
isemailpost	int(2)			NO	 	0	 
parentid	int(10) unsigned	NO	 	0	 
attach		smallint(5) unsigned	NO	 	0	 
infraction	smallint(5) unsigned	NO	 	0	 
reportthreadid	int(10) unsigned	NO	 	0	 
htmlstate	enum('off','on','on_nl2br')NO	 	on_nl2br

            Comment

            • arturvill
              New Member
              • Jul 2004
              • 27
              • 2.3.0
              #4
              vB database dates back to v2 I think. Might something to do with that? Here is beginning and end of 'post' table.

              Code:
              [B]
postid	threadid username userid title		dateline	pagetext	allowsmilie	showsignature	ipaddress	iconid	visible	isemailpost	parentid attach	infraction	reportthreadid	htmlstate[/B]

1	1	 Artur	  0	 		993175270	Just testing... 0		0	 			0	1	0	 	0	 0	0		0		on_nl2br
2	1	 Artur	  0	T88tab..	993175981	tropp.. asi 	0		0	 			0	1	0	 	1	 0	0		0		on_nl2br
3	1	 Neil     0	 		993182281	Hey Artur...	0		0	 			0	1	0	 	1	 0	0		0		on_nl2br
4	1	 Artur	  0	colors		993183533	I will cha...	0		0	 			0	1	0	 	1	 0	0		0		on_nl2br
5	2	 Georg	  0	 		993185290	nice page yo...	0		0	 			0	1	0	 	0	 0	0		0		on_nl2br
6	3	 Artur	  0	 		993624361	what is the...	0		0	 			0	1	0	 	0	 0	0		0		on_nl2br
7	4	 Artur	  0	 		993642547	Kuule marko...	0		0	 			0	1	0	 	0	 0	0		0		on_nl2br
8	4	 Marko	  0	Universumi..	993664989	Ma ostsin...	0		0	 			0	1	0	 	7	 0	0		0		on_nl2br
9	4	 Anton	  0	mina		993665420	Mina olen...	0		0	 			0	1	0	 	7	 0	0		0		on_nl2br
10	2	 Robin 	  0	nice page.. 	993666594	nice page  ...	0		0	 			0	1	0	 	5	 0	0		0		on_nl2br
11	2	 Anton 	  0	mina		993667088	äää... ma ...	0		0	 			0	1	0	 	5	 0	0		0		on_nl2br
12	1	 Anton 	  0	mina		993667476	I don't..	0		0	 			0	1	0	 	1	 0	0		0		on_nl2br
13	1	 Artur 	  0	mina		993682392	Don't...	0		0	 			0	1	0		1	 0	0		0		on_nl2br

...
[B]
postid	threadid username userid title		dateline	pagetext	allowsmilie	showsignature	ipaddress	iconid	visible	isemailpost	parentid attach	infraction	reportthreadid	htmlstate[/B]

21089	2713	 Papp	  2	 01.11.10	1288602032	Üks...		1		0		88.196.55.74	0	1	0		0	 8	0		0		on_nl2br
21090	2713	 Papp	  2	 		1288602179	:)		1		0		88.196.55.74	0	1	0		21089	 8	0		0		on_nl2br
21091	2713	 Papp	  2	 		1288602323	:))		1		0		88.196.55.74	0	1	0		21089	 8	0		0		on_nl2br
21092	2713	 Papp	  2	 		1288602464	:)))		1		0		88.196.55.74	0	1	0		21089	 8	0		0		on_nl2br
21093	2713	 Papp	  2	 		1288602617	:)))))		1		0		88.196.55.74	0	1	0		21089	 8	0		0		on_nl2br
21094	2713	 Papp	  2	 		1288602831	Siuk...		1		0		88.196.55.74	0	1	0		21089	 2	0		0		on_nl2br
21095	2713	 Anton	  3	 		1288612661	looks..		1		0		217.71.35.1	0	1	0		21089	 0	0		0		on_nl2br
21096	2602	 Papp	  2	 		1288680765	Press		1		0		78.28.88.126	0	1	0		20579	 1	0		0		on_nl2br
21097	2602	 Artur	  1	 		1288757101	Eestiss..	1		0		210.5.37.1	0	1	0		20579	 0	0		0		on_nl2br
21098	2714	 Artur	  1	 ...		1288917448	<object..	1		0		210.5.37.1	0	1	0		0	 0	0		0		on_nl2br

                Comment

                • Trevor Hannant
                  vBulletin Support
                  • Aug 2002
                  • 24358
                  • 5.7.X
                  #5
                  It looks like an index was never added to that table in the past or has been previously dropped. What's the URL in your browser when you get that error?
                  Vote for:

                  - Admin Settable Paid Subscription Reminder Timeframe (vB6)
                  - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

                    Comment

                    • arturvill
                      New Member
                      • Jul 2004
                      • 27
                      • 2.3.0
                      #6
                      .../forums408/install/upgrade_408.php?step=1

                      or would you like full path?

                        Comment

                        • Trevor Hannant
                          vBulletin Support
                          • Aug 2002
                          • 24358
                          • 5.7.X
                          #7
                          Can you open the upgrade_408.php file and edit line 111 from this:

                          Code:
                                      "ALTER TABLE " . TABLE_PREFIX . "post DROP INDEX userid, ADD INDEX userid (userid, parentid)",
                          to this:

                          Code:
                                      "ALTER TABLE " . TABLE_PREFIX . "post ADD INDEX userid (userid, parentid)",
                          Then refresh the page to re-run that step.

                          Does this resolve the problem?
                          Vote for:

                          - Admin Settable Paid Subscription Reminder Timeframe (vB6)
                          - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

                            Comment

                            • arturvill
                              New Member
                              • Jul 2004
                              • 27
                              • 2.3.0
                              #8
                              yes, curiously it worked!!! :-)

                              Thank you very much!

                                Comment

                                Previous template Next

                                Related Topics

                                Collapse
                                Working...