Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions

Reply
 
Thread Tools Display Modes
  #1  
Old 03-25-2008, 08:57 PM
baby41 baby41 is offline
 
Join Date: Jun 2007
Posts: 59
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Database error

Yesterday I got this error when I try to send a Pm:

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT COUNT(*) AS total, folderid
FROM pm AS pm
LEFT JOIN pmtext AS pmtext USING(pmtextid)
WHERE userid = 556
GROUP BY folderid;

MySQL Error : Unknown column 'pmtextid' in 'from clause'
Error Number : 1054
Date : Tuesday, March 25th 2008 @ 03:49:28 PM
Script : hxxp://www.xxxxxxxxx.com/forum/private.php?do=newpm&u=2
Referrer : hxxp://www.xxxxxxxxx.com/forum/member.php?u=2
IP Address : 91.xx.xx.xxx
Username : xxxxxxxxx
Classname : vb_database

And to make it worse I had a virus at my PC last week and lost all my files including a backup of my database , what can I do
Reply With Quote
  #2  
Old 03-25-2008, 09:20 PM
Jase2 Jase2 is offline
 
Join Date: Dec 2007
Location: USA
Posts: 1,575
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

To troubleshoot this, first reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server. Also be sure to upload the admincp files to whichever directory you have set in your config.php file. Then run 'Suspect File Versions' in Diagnostics to make sure you have all the original files for your version and that none show 'File does not contain expected contents':

Admin CP -> Maintenance -> Diagnostics -> Suspect File Versions


[Note: In some cases you may also need to remove any of the listed .xml files in the includes/xml directory.]

Next, disable all plugins.

Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

Then if you still have this problem, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it. Do you have the same problem?

Regards Jason
Reply With Quote
  #3  
Old 03-25-2008, 09:59 PM
baby41 baby41 is offline
 
Join Date: Jun 2007
Posts: 59
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks for your prompt reply,I have done all of the above and still have the same error when I try to send a PM.
Reply With Quote
  #4  
Old 03-25-2008, 10:06 PM
Jase2 Jase2 is offline
 
Join Date: Dec 2007
Location: USA
Posts: 1,575
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I think your PM table may have crashed. To fix it, run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

Admin CP -> Import & Maintenance -> Repair/Optimize Tables -> Check All -> Continue

Regards Jason
Reply With Quote
  #5  
Old 03-25-2008, 10:09 PM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It didnt crash, read the error msg.

MySQL Error : Unknown column 'pmtextid' in 'from clause'

Did you just install or un-install a hack before this started?
Reply With Quote
  #6  
Old 03-25-2008, 10:17 PM
baby41 baby41 is offline
 
Join Date: Jun 2007
Posts: 59
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by snakes1100 View Post
It didnt crash, read the error msg.

MySQL Error : Unknown column 'pmtextid' in 'from clause'

Did you just install or un-install a hack before this started?
No I didn?t install or n-install any hack but when talking with another Admin he told that was using the forum database for a test to a youtube clone installed in our server,do yo think it might be that,and what to do now.......
Reply With Quote
  #7  
Old 03-25-2008, 10:21 PM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hard to say, did you even check the db to see if the column is even there?
Reply With Quote
  #8  
Old 03-26-2008, 12:26 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Please use a tool like phpMyAdmin to see if the 'pm' & 'pmtext' tables exist and which columns they contain. Please post the results here.
Reply With Quote
  #9  
Old 03-26-2008, 02:50 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

And maybe suggest to the admin that he create a test board for testing things instead of using the live database.
Reply With Quote
  #10  
Old 03-26-2008, 08:15 PM
baby41 baby41 is offline
 
Join Date: Jun 2007
Posts: 59
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Marco van Herwaarden View Post
Please use a tool like phpMyAdmin to see if the 'pm' & 'pmtext' tables exist and which columns they contain. Please post the results here.
Pm has this:


pm_id
subject
body
sender
receiver
date
seen
inbox_track
outbox_track

Pmtext has this:


pmtextid
fromuserid
fromusername
title
message
touserarray
iconid
dateline
showsignature
allowsmilie
Reply With Quote
Reply

Thread Tools
Display Modes

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

Forum Jump


All times are GMT. The time now is 01:53 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.11214 seconds
  • Memory Usage 2,247KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete