Don't add new forum when after Upgrade

[camihuvn]

Hi all...
I run forum version 3.5.x. But when i upgarde to version 3.6.0 have a prolem when add new or child forum. (everything other ok)

Database error in vBulletin 3.6.0:

Invalid SQL:
INSERT INTO forum
(title_clean, title, description_clean, description, link, displayorder, parentid, daysprune, defaultsortfield, defaultsortorder, showprivate, newpostemail, newthreademail, options, styleid, password)
VALUES
('Add test forum', 'Add test forum', '', '', '', 1, 1, -1, 'lastpost', 'desc', 0, '', '', 97991, 0, '');

MySQL Error : Unknown column 'defaultsortfield' in 'field list'
Error Number : 1054
Date : Wednesday, September 27th 2006 @ 02:44:06 PM
Script : http://localhost/forum/admincp/forum.php?do=update
Referrer : http://localhost/forum/admincp/forum.php?do=add&parentid=1&s=
IP Address : 127.0.0.1
Username : CamihuVN
Classname : vB_Database
Please help me ! thank

[Marco van Herwaarden]

Please upgrade to 3.6.1, our latest stable version.

[camihuvn]

Database error in vBulletin 3.6.1:

Invalid SQL:
INSERT INTO forum
(title_clean, title, description_clean, description, link, displayorder, parentid, daysprune, defaultsortfield, defaultsortorder, showprivate, newpostemail, newthreademail, options, styleid, password)
VALUES
('ADD FORUM TEST', 'ADD FORUM TEST', '', '', '', 1, 6, -1, 'lastpost', 'desc', 0, '', '', 97991, 0, '');

MySQL Error : Unknown column 'defaultsortfield' in 'field list'
Error Number : 1054
Date : Wednesday, September 27th 2006 @ 04:13:08 AM
Script : http://localhost/forum/admincp/forum.php?do=update
Referrer : http://localhost/forum/admincp/forum.php?do=add&parentid=6&s=
IP Address : 222.252.234.122
Username : CamihuVN
Classname : vB_Database

That is errors when i upgrade 3.6.1

[Marco van Herwaarden]

Run the following query:

ALTER TABLE forum ADD COLUMN `defaultsortfield` varchar(50) NOT NULL default 'lastpost';

[camihuvn]

Thank you support and share code, But after query it and add new forum then error the same at first. What happened ?


Database error in vBulletin 3.6.1:

Invalid SQL:
INSERT INTO forum
(title_clean, title, description_clean, description, link, displayorder, parentid, daysprune, defaultsortfield, defaultsortorder, showprivate, newpostemail, newthreademail, options, styleid, password)
VALUES
('ADD FORUM TEST', 'ADD FORUM TEST', '', '', '', 1, 6, -1, 'lastpost', 'desc', 0, '', '', 97991, 0, '');

MySQL Error : Unknown column 'defaultsortfield' in 'field list'
Error Number : 1054
Date : Wednesday, September 27th 2006 @ 04:13:08 AM
Script : http://localhost/forum/admincp/forum.php?do=update
Referrer : http://localhost/forum/admincp/forum...&parentid=6&s= (http://localhost/forum/admincp/forum.php?do=add&parentid=6&s=)
IP Address : 222.252.234.122
Username : CamihuVN
Classname : vB_Database

[Steve Machol]

You cannot get that error if you ran the query Marco posted.

[camihuvn]

You cannot get that error if you ran the query Marco posted.

I am sure that mistake caused the problem, please help me ?

[Marco van Herwaarden]

Please run the query in post #4 again and tell me if you get a MySQL error.

[camihuvn]

After i query your code. I try and have problem.


MySQL Error : Unknown column 'defaultsortorder' in 'field list'
Error Number : 1054

I can not add or edit forum....help me

[Ranger187]

Same issue, ran that, and this is all it output:

Affected Rows: 30 (0.0481s)