vBulletin Modifications

PLZ help - my mail is gonna explode.

Welcome to vBHackers.com! - vBHackers Updates:

Go Back   vBulletin Modifications > General vBulletin Section > General vBulletin Support

Reply
 
LinkBack Thread Tools
Old 07-30-2006, 06:19 PM   #1
vB Newbie
Join Date: Dec 2005
IL-Slayer is on a distinguished road

Exclamation PLZ help - my mail is gonna explode.

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.




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
Old 07-30-2006, 08:03 PM   #2
Coder
BigJohnny's Avatar
Join Date: Jul 2006
BigJohnny is on a distinguished road

Default

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.




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 07-31-2006, 04:12 AM   #3
vBulletin Guru
Nick R's Avatar
Join Date: May 2006
Real Name: Nick
Location: Cyberspace, UK
Nick R is on a distinguished road

Default

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:
You must first be a registered member to view any code.
just an idea.... It might have lost the left join..




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 07-31-2006, 04:17 AM   #4
vB Newbie
Join Date: Dec 2005
IL-Slayer is on a distinguished road

Default

i tried to execute and i got this msg:

You are not authorized to execute SQL queries




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 07-31-2006, 04:19 AM   #5
vBulletin Guru
Nick R's Avatar
Join Date: May 2006
Real Name: Nick
Location: Cyberspace, UK
Nick R is on a distinguished road

Default

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.




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 07-31-2006, 01:22 PM   #6
vB Newbie
Join Date: Dec 2005
IL-Slayer is on a distinguished road

Default

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)

Last edited by IL-Slayer; 07-31-2006 at 01:26 PM.




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 08-01-2006, 06:00 PM   #7
vB Newbie
Join Date: Dec 2005
IL-Slayer is on a distinguished road

Default

*bump* sry ^ ^




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 08-04-2006, 05:54 AM   #8
vB Newbie
Join Date: Dec 2005
IL-Slayer is on a distinguished road

Default

roger, can u help plz ?




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 08-04-2006, 06:00 AM   #9
vBulletin Guru
Nick R's Avatar
Join Date: May 2006
Real Name: Nick
Location: Cyberspace, UK
Nick R is on a distinguished road

Default

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?




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 08-04-2006, 06:40 AM   #10
vB Newbie
Join Date: Dec 2005
IL-Slayer is on a distinguished road

Default

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




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
help me plz plz mohammed vBulletin Modification Requests 2 07-30-2006 11:15 AM
plz help me with this? mohammed General vBulletin Discussion 5 06-28-2006 05:22 PM
i want this hack plz mohammed vBulletin Modification Requests 2 06-04-2006 04:35 PM
HELP -- HELP -- HELP plz PLZ plz PLZ plz HELP -- HELP -- HELP Homie vBulletin Modification Requests 5 10-06-2005 11:59 AM
Spam Mail Ken Iovino Announcements 0 05-11-2005 02:57 AM


All times are GMT -3. The time now is 01:05 AM.


SEO by vBSEO 3.2.0 ©2008, Crawlability, Inc. (Patent Pending)