I GET TONS OF THIS KIND TO MY MAIL. :confused:


Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,

thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
thread.lastpost, lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
hiddencount


,post.pagetext
FROM thread AS thread






WHERE thread.threadid IN (0,184)
ORDER BY sticky DESC, thread.lastpost DESC;

MySQL Error : Unknown table 'post' in field list
Error Number : 1109
Date : Saturday, July 29th 2006 @ 04:14:45 PM
Script : http://myweb.com/forumdisplay.php?f=8 <-- IE
Referrer :
IP Address : xx.xx.xxx.xx
Username : UnRegistered
Classname : vb_database

--------------------------------
TNX FOR HELPERS.

i know nothing about SQL really, but i would fathom a few GUESSES at that error. If i am wrong someone please correct me before my advice causes harm

Your database has gotten corrupted or messed up or someone deleted the wrong thing (possibly a hack gone wrong??)

IT would seem to me that it is looking for the table "post" in the database, and that table is not there.

If you have a backup of your database, restore it and see if it helps.
If not or if you want to get a little deeper, use phpmyadmin or whatever your host provides, and look at the database, and see if the table "post" exists. if it doesnt, try creating it manually, and see if you still get this error.
WARNING Performing the following action is almost 100% to cause data loss on the forums. I do not know what this table is or does, but i am guessing that it is used to store the content of the posts on the forums. You will probably lose ALL of the posts on your forums, and maybe even more. do this at your own risk.
If the table does exist, you could try emptying the data from that table, as maybe a portion of it is corrupt. This also MIGHT correct the problem, but is a pretty drastic measure.

Anyone, i would rather have someone come in here and tell me if im right or wrong, i do not wish to give bad advice.
Knowing as little as i do about this stuff, this is just what i would try based on my own logic.

It would seem that way. But before you do anything drastic go into your forums ACP and execute a query (under maintenance): SELECT * FROM POST. If it comes back with a result thats good if it doesn't thats bad. If it does come back with a result run another query: SELECT pagetext FROM post. If that comes back with results then i would suggest the porblem is corrupt code.

You see to select something out of 2 tables in 1 query you have to left join the 2nd table to the first so what your query should look like is: just an idea.... It might have lost the left join..

__________________
vB Nova - Great vBulletin Help, Mods & Skins | PicoSphere - Free Image Hosting with No Pop-Ups
---------

i tried to execute and i got this msg:

You are not authorized to execute SQL queries

Go into your includes folder and edit config.php go to the permissions at the bottom and set it so your userid can run queries.

ok i executed this: "SELECT * FROM POST" without the " ofc.

and i got this error:


---------
An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'teltech_website.POST' doesn't exist
---------

Roger thank you very much for helping !



EDIT:

after i executed second: "SELECT pagetext FROM post"
i got 20 pages of messages from the board..(no errors tho)

*bump* sry ^ ^

roger, can u help plz ?

so you got an error for the first querie saying it didn't exist and yet for the second you didn't get an error. hmm run the first and second again and see whaat it says.

Can you also give me a link to your board?

my web is in hebrew.. u still want a link ?
www.torrent.co.il