unknown styleoverride

[Lee Herron]

I see a few threads with this topic, but no clear resolution.

I've been running vB2 for quite some time now and recently upgraded to vb3, now I'm receiving emails with the errors:

Invalid SQL: SELECT forum.forumid,styleid,styleoverride FROM forum,thread WHERE forum.forumid=thread.forumid AND threadid='135835'
mysql error: Unknown column 'styleoverride' in 'field list'

mysql error number: 1054

Date: Monday 03rd of May 2004 12:41:00 PM
Script: /showthread.php?s=&threadid=135835&highlight=tutorials

and

Invalid SQL: SELECT templatesetid,replacementsetid,userselect FROM style WHERE styleid='1'
mysql error: Unknown column 'templatesetid' in 'field list'

mysql error number: 1054

Date: Monday 03rd of May 2004 12:25:23 PM
Script: /showthread.php?s=1c5a2923d412a084619e3b4f13c2f4

indicating that there are fields missing from my database. I ran all the upgrade scripts from the vb2 version I was running to vb3.01 with no errors.

Any ideas here?

[Steve Machol]

Those columns don't exist in vB3 and are not called for in showthread.php. Reupload the original showthread.php file from the vB 3.0.1 zip file. Make sure you upload in ASCII and overwrite the one on the server.

[pjk]

I got same error

Invalid SQL: SELECT templatesetid,replacementsetid,userselect FROM style WHERE styleid='1'
mysql error: Unknown column 'templatesetid' in 'field list'

mysql error number: 1054

and did try as your suggestion buy upload the original showthread.php to the web site (actually, the existed one is the original unhack one). But the problem is still there.

Help..

Thank you.

PS: My board was upgraded from V2.2.9 to V3.0.1 and changed attachments storage type to file.

[Steve Machol]

Since that column and query is not called by showthread.php, the only way this could be happening from that script is if you are using the wrong file.

[pjk]

Then how can I solve the problem, the only hack that I install to my board is microstat, and I just edit some phrase to local language and modify color in main css that all.

Thank you.

[Steve Machol]

As I said you will not get this error with the original showthread.php file (assuming that is the script mentioned in the error.) Since you have not posted the entire error message I don't know this for certain.

[pjk]

Sorry that I forgot to post the full error - look like it happend from index.php files and the my index.php is genuine unhack one. I did try to upload fresh uncompressed from zip file I downloaded from vbulletin.com (actually there're exactly same file) and the problem is still there.

Database error in vBulletin :

Invalid SQL: SELECT templatesetid,replacementsetid,userselect FROM style WHERE styleid='1'
mysql error: Unknown column 'templatesetid' in 'field list'

mysql error number: 1054

Date: Monday 10th of May 2004 05:12:00 PM
Script: /forum/index.php
Referer:

[Steve Machol]

There is no 'templatesetid' column in the vB3 style table - nor does any vB3 file call it. You will not get this error if you are running the default vB3 files and templates.

[pjk]

Is it possible that it happend from upgrad procedure? And again that I confirm you the MicroStat is the only hack I installed. Does it serious to leave the error like that or should I do something?

[Steve Machol]

This has nothing to do with the upgrade process except for the fact that you are not using the 3.0.1 files and templates. I have already told you how to fix this. Reupload the original vB 3.0.1 files and possibly revert the templates as well.

[alkahf]

Same Error

Hello
The same Error when I submit announcement from ACP:

<!--
Database error in vBulletin 3.0.1:

Invalid SQL:
### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO announcement
(forumid, title, allowbbcode, allowsmilies, allowhtml, startdate, enddate, pagetext, userid)
VALUES
('-1', 'test', '1', '1', '0', '1085209200', '1087887600', 'test', '1')
mysql error: Unknown column 'allowbbcode' in 'field list'

mysql error number: 1054

Date: Saturday 22nd of May 2004 01:49:46 PM
Script: http://www.?????.com/admincp/announcement.php
Referer: http://www.?????.com/admincp/announcement.php?do=add
Username: admin
IP Address: xx.xxx.xxx.xxx
-->

SOS

alkahf

[Steve Machol]

alkahf, please start your own thread. Your problem is a different one. Nonetheless you are missing a default field in the announcement table. In the new thread please post exactly what you have done up to now.