This section is an archive with no posting allowed. The software represented in this forum is no longer supported or updated. If you need help upgrading to a newer version of vBulletin please open a support ticket. You can also post in the section supporting the upgrade version you're planning to use.
We are sorry for any inconvenience this may cause.
Welcome to the vBulletin support forums! In our community forums you can receive professional support and assistance with any issues you might have with your vBulletin Products.
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.
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.
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.
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.
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.
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:
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.
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?
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, 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.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X
We process personal data about users of our site, through the use of cookies and other technologies, to deliver our services, personalize advertising, and to analyze site activity. We may share certain information about our users with our advertising and analytics partners. For additional details, refer to our Privacy Policy.
By clicking "I AGREE" below, you agree to our Privacy Policy and our personal data processing and cookie practices as described therein. You also consent to the transfer of your data to our servers in the United States, where data protection laws may be different from those in your country.
Comment