problems when adding new forums..

[king sting]

In the admincp whenever I try to add a new forum I am now getting this error:

Database error in vBulletin Control Panel 2.3.0:
Invalid SQL: INSERT INTO forum
(forumid,styleid,title,description,active,displayorder,parentid,
parentlist,allowposting,cancontainthreads,daysprune,newpostemail,newthreademail,
moderatenew,allowhtml,allowbbcode,allowimages,allowsmilies,allowicons,
styleoverride,allowratings,countposts,moderateattach,allowguestpostview,minposts)
VALUES
(NULL,'1','Movie','','1','1','21',
'','1','1','30','','',
'0','0','1','0','1','1',
'0','1','1','0', '1, ''')
mysql error: Column count doesn't match value count at row 1
mysql error number: 1136
Date: Wednesday 30th of April 2003 09:59:11 PM
Script: http://www.cali-stylez.net/vb/vb/admin/forum.php
Referer: http://www.cali-stylez.net/vb/admin/...dd&parentid=21

I don't understand what the problem is, can anyone help?

[Steve Machol]

Reupload the original admin/forum.php file from the 2.3.0 zip file. Make sure you upload in ASCII and overwrite the one on the server.

[king sting]

ok i got that one fixed, but now i get this error when anyone trys to view the board..

Database error in vBulletin 2.3.0:
Invalid SQL: SELECT threadid,title,replycount FROM thread ORDER BY RAND() LIMIT 1
mysql error: Can't open file: 'thread.MYI'. (errno: 145)
mysql error number: 1016
Date: Thursday 01st of May 2003 09:35:12 PM
Script: http://www.cali-stylez.net/vb/vb/
Referer:

any ideas?

[Steve Machol]

1. Upload repair.php (it's in the 'extras' folder of the zip file) to your admin directory. Close your forums, then run it from your browser with this syntax:

http://www.yourdomain.com/forum/admin/repair.php?html=1&check=1

[Of course change the exact URL as appropriate for your forums.]

If everything reports 'Ok' then reopen your forums. If not, then run it again. The second time everything should report Ok.

2. Read this thread:

http://www.vbulletin.com/forum/showt...threadid=69803