upgrading 3.8 to error

محروم.كوم · #1 01-26-2013, 06:20 AM

I got this error when going a upgrade to 4.xx

Unexpected Text:

Database Error</p>

Invalid SQL: INSERT IGNORE INTO attachment
(attachmentid, contenttypeid, contentid, userid, dateline, filedataid, state, counter, filename)
VALUES
(
1,
1,
38,
2,
1046607552,
1,
'visible',
206,
'oilcap.jpg'
),
(
2,
1,
47,
23,
1046620916,
2,
'visible',
256,
'crossslide.jpg'
),
(
6,
1,
95,
57,
1046786745,
6,
'visible',
583,
'p1010001aaa.jpg'
),
(
7,
1,
122,
1,
1046839017,
7,
'visible',
1298,
'p6200003.jpg'
),
(
8,
1,
128,
53,
1046862126,
8,
'visible',
454,
'cncmill4.jpg'
),
(
9,
1,
129,
53,
1046862594,
9,
'visible',
648,
'wireedm10.jpg'
),
(
10,
1,
131,
53,
1046864332,
10,
'visible',
660,
'cnc mill7.jpg'
),
(
11,
1,
144,
1,
1046905386,
11,
'visible',
4694,
'cnc5.jpg'
),
(
12,
1,
145,
57,
1046908305,
12,
'visible',
582,
'p1010014a.jpg'
),
(
13,
1,
147,
53,
1046909731,
13,
'visible',
569,
'square hole.jpg'
),
(
15,
1,
163,
57,
1046973478,
15,
'visible',
501,
'derr boiler a .75 iron pipe grid .jpg'
),
(
16,
1,
166,
1,
1047008650,
16,
'visible',
1165,
'quick.jpg'
),
(
17,
1,
183,
53,
1047070130,
17,
'visible',
725,
'cncmill3.jpg'
),
(
18,
1,
191,
57,
1047076653,
18,
'visible',
453,
'p1010002cc.jpg'
),
(
19,
1,
217,
57,
1047310185,
19,
'visible',
233,
'7x10_4_y.jpg'
),
(
20,
1,
220,
1,
1047310602,
20,
'visible',
216,
'lathe2.jpg'
),
(
21,
1,
230,
2,
1047339188,
21,
'visible',
124,
'cncban..jpg'
),
(
22,
1,
232,
108,
1047393227,
22,
'visible',
478,
'engine1.jpg'
),
(
23,
1,
242,
1,
1047408967,
23,
'visible',
1428,
'gtoengine0004.jpg'
),
(
30,
1,
346,
20,
1047774028,
30,
'visible',
1340,
'texas_state_in_abalam.jpg'
),
(
31,
1,
347,
20,
1047774232,
31,
'visible',
1247,
'mother_of_pearl_.473x.418.jpg'
),
(
32,
1,
348,
20,
1047774404,
32,
'visible',
1282,
'ivory_10_piece_edge_marker_set.jpg'
),
(
33,
1,
349,
20,
1047774600,
33,
'visible',
1194,
'small_ivory_heel_plate.jpg'
),
(
34,
1,
453,
150,
1048207302,
34,
'visible',
7584,
'cncrouter.jpg'
),
(
35,
1,
470,
1,
1048254423,
35,
'visible',
1286,
'p002.jpg'
),
(
36,
1,
476,
96,
1048275571,
36,
'visible',
287,
'onecncxp.jpg'
),
(
39,
1,
506,
113,
1048473578,
39,
'visible',
341,
'hm.gif'
),
(
40,
1,
533,
1,
1048555254,
40,
'visible',
949,
'p3240442.jpg'
),
(
41,
1,
534,
1,
1048555386,
41,
'visible',
971,
'p3240444.jpg'
),
(
42,
1,
535,
1,
1048555480,
42,
'visible',
519,
'p3240448.jpg'
),
(
44,
1,
596,
113,
1048658558,
44,
'visible',
1188,
'grinning-smiley-035.gif'
),
(
45,
1,
613,
113,
1048727577,
45,
'visible',
175,
'violent-smiley-090.gif'
),
(
47,
1,
708,
217,
1048983574,
47,
'visible',
3051,
'cnczzj.jpg'
),
(
48,
1,
709,
217,
1048983725,
48,
'visible',
3305,
'cnczzi.jpg'
),
(
49,
1,
712,
217,
1048984025,
49,
'visible',
2097,
'cnczzk.jpg'
),
(
50,
1,
713,
217,
1048984089,
50,
'visible',
1925,
'cnczzl.jpg'
),
(
52,
1,
722,
1,
1048993332,
52,
'visible',
841,
'p3150436.jpg'
),
(
53,
1,
724,
1,
1048993570,
53,
'visible',
193,
'1590.jpg'
),
(
54,
1,
732,
1,
1048996219,
54,
'visible',
114,
'untitled.jpg'
),
(
55,
1,
746,
1,
1049032958,
55,
'visible',
2083,
'p3240442.jpg'
),
(
56,
1,
774,
217,
1049057490,
56,
'visible',
499,
'cnczzj.jpg'
),
(
58,
1,
775,
217,
1049058184,
58,
'visible',
1296,
'0425_005 copy.jpg'
),
(
59,
1,
795,
217,
1049073927,
59,
'visible',
443,
'cnczzg.jpg'
),
(
60,
1,
799,
217,
1049078846,
60,
'visible',
2292,
'cnczzm.jpg'
),
(
61,
1,
864,
217,
1049164922,
61,
'visible',
2168,
'cnczzq.jpg'
),
(
62,
1,
872,
96,
1049171226,
62,
'visible',
107,
'untrimmed.gif'
),
(
63,
1,
873,
96,
1049171484,
63,
'visible',
98,
'toolpath.gif'
),
(
64,
1,
874,
96,
1049171831,
64,
'visible',
193,
'solution_prtnr.gif'
),
(
65,
1,
900,
150,
1049232753,
65,
'visible',
1375,
'belt.gif'
),
(
66,
1,
903,
182,
1049240025,
66,
'visible',
204,
'im000439.jpg'
);

Unknown column 'contenttypeid' in 'field list']]>
Database error in vBulletin 3.8.7</p>

Invalid SQL:

INSERT IGNORE INTO attachment
(attachmentid, contenttypeid, contentid, userid, dateline, filedataid, state, counter, filename)
VALUES
(
1,
1,
38,
2,
1046607552,
1,
'visible',
206,
'oilcap.jpg'
),
(
2,
1,
47,
23,
1046620916,
2,
'visible',
256,
'crossslide.jpg'
),
(
6,
1,
95,
57,
1046786745,
6,
'visible',
583,
'p1010001aaa.jpg'
),
(
7,
1,
122,
1,
1046839017,
7,
'visible',
1298,
'p6200003.jpg'
),
(
8,
1,
128,
53,
1046862126,
8,
'visible',
454,
'cncmill4.jpg'
),
(
9,
1,
129,
53,
1046862594,
9,
'visible',
648,
'wireedm10.jpg'
),
(
10,
1,
131,
53,
1046864332,
10,
'visible',
660,
'cnc mill7.jpg'
),
(
11,
1,
144,
1,
1046905386,
11,
'visible',
4694,
'cnc5.jpg'
),
(
12,
1,
145,
57,
1046908305,
12,
'visible',
582,
'p1010014a.jpg'
),
(
13,
1,
147,
53,
1046909731,
13,
'visible',
569,
'square hole.jpg'
),
(
15,
1,
163,
57,
1046973478,
15,
'visible',
501,
'derr boiler a .75 iron pipe grid .jpg'
),
(
16,
1,
166,
1,
1047008650,
16,
'visible',
1165,
'quick.jpg'
),
(
17,
1,
183,
53,
1047070130,
17,
'visible',
725,
'cncmill3.jpg'
),
(
18,
1,
191,
57,
1047076653,
18,
'visible',
453,
'p1010002cc.jpg'
),
(
19,
1,
217,
57,
1047310185,
19,
'visible',
233,
'7x10_4_y.jpg'
),
(
20,
1,
220,
1,
1047310602,
20,
'visible',
216,
'lathe2.jpg'
),
(
21,
1,
230,
2,
1047339188,
21,
'visible',
124,
'cncban..jpg'
),
(
22,
1,
232,
108,
1047393227,
22,
'visible',
478,
'engine1.jpg'
),
(
23,
1,
242,
1,
1047408967,
23,
'visible',
1428,
'gtoengine0004.jpg'
),
(
30,
1,
346,
20,
1047774028,
30,
'visible',
1340,
'texas_state_in_abalam.jpg'
),
(
31,
1,
347,
20,
1047774232,
31,
'visible',
1247,
'mother_of_pearl_.473x.418.jpg'
),
(
32,
1,
348,
20,
1047774404,
32,
'visible',
1282,
'ivory_10_piece_edge_marker_set.jpg'
),
(
33,
1,
349,
20,
1047774600,
33,
'visible',
1194,
'small_ivory_heel_plate.jpg'
),
(
34,
1,
453,
150,
1048207302,
34,
'visible',
7584,
'cncrouter.jpg'
),
(
35,
1,
470,
1,
1048254423,
35,
'visible',
1286,
'p002.jpg'
),
(
36,
1,
476,
96,
1048275571,
36,
'visible',
287,
'onecncxp.jpg'
),
(
39,
1,
506,
113,
1048473578,
39,
'visible',
341,
'hm.gif'
),
(
40,
1,
533,
1,
1048555254,
40,
'visible',
949,
'p3240442.jpg'
),
(
41,
1,
534,
1,
1048555386,
41,
'visible',
971,
'p3240444.jpg'
),
(
42,
1,
535,
1,
1048555480,
42,
'visible',
519,
'p3240448.jpg'
),
(
44,
1,
596,
113,
1048658558,
44,
'visible',
1188,
'grinning-smiley-035.gif'
),
(
45,
1,
613,
113,
1048727577,
45,
'visible',
175,
'violent-smiley-090.gif'
),
(
47,
1,
708,
217,
1048983574,
47,
'visible',
3051,
'cnczzj.jpg'
),
(
48,
1,
709,
217,
1048983725,
48,
'visible',
3305,
'cnczzi.jpg'
),
(
49,
1,
712,
217,
1048984025,
49,
'visible',
2097,
'cnczzk.jpg'
),
(
50,
1,
713,
217,
1048984089,
50,
'visible',
1925,
'cnczzl.jpg'
),
(
52,
1,
722,
1,
1048993332,
52,
'visible',
841,
'p3150436.jpg'

),
(
53,
1,
724,
1,
1048993570,
53,
'visible',
193,
'1590.jpg'
),
(
54,
1,
732,
1,
1048996219,
54,
'visible',
114,
'untitled.jpg'
),
(
55,
1,
746,
1,
1049032958,
55,
'visible',
2083,
'p3240442.jpg'
),
(
56,
1,
774,
217,
1049057490,
56,
'visible',
499,
'cnczzj.jpg'
),
(
58,
1,
775,
217,
1049058184,
58,
'visible',
1296,
'0425_005 copy.jpg'
),
(
59,
1,
795,
217,
1049073927,
59,
'visible',
443,
'cnczzg.jpg'
),
(
60,
1,
799,
217,
1049078846,
60,
'visible',
2292,
'cnczzm.jpg'
),
(
61,
1,
864,
217,
1049164922,
61,
'visible',
2168,
'cnczzq.jpg'
),
(
62,
1,
872,
96,
1049171226,
62,
'visible',
107,
'untrimmed.gif'
),
(
63,
1,
873,
96,
1049171484,
63,
'visible',
98,
'toolpath.gif'
),
(
64,
1,
874,
96,
1049171831,
64,
'visible',
193,
'solution_prtnr.gif'
),
(
65,
1,
900,
150,
1049232753,
65,
'visible',
1375,
'belt.gif'
),
(
66,
1,
903,
182,
1049240025,
66,
'visible',
204,
'im000439.jpg'
);

MySQL Error : Unknown column 'contenttypeid' in 'field list'

Error Number : 1054

Request Date : Friday, January 25th 2013 @ 08:51:06 PM

Error Date : Friday, January 25th 2013 @ 08:51:06 PM

Script : http://ppgzone.com/forums/install/upgrade.php

Referrer : http://ppgzone.com/forums/install/upgrade.php

Classname : vB_Database

MySQL Version : 5.1.66-cll

]]>

How can I fix this? __DEFINE_LIKE_SHARE__

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	مشاركات	آخر مشاركة
Error upgrading from 4.1.5	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	09-13-2012 08:20 AM
I'm getting an SQL Error after upgrading	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	08-09-2010 02:50 AM
Error After Upgrading	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	06-09-2010 07:36 PM
Suite Upgrading Error Parse error: syntax error* unexpected T_STATIC*	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	12-24-2009 02:30 AM
Error upgrading	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	06-24-2009 09:00 AM