I dont get it?

[silvermerc]

Database error in vBulletin 3.7.4:

Invalid SQL:

SELECT pm.pmid, title, fromusername
FROM pmtext AS pmtext
LEFT JOIN pm AS pm USING(pmtextid)
WHERE pm.userid = 3687
AND pm.folderid = 0
ORDER BY dateline DESC
LIMIT 1;

MySQL Error : Table 'hhgsnet_vb.pmtext' doesn't exist
Error Number : 1146
Request Date : Monday, December 29th 2008 @ 06:05:24 PM
Error Date : Monday, December 29th 2008 @ 06:05:24 PM
Script : http://www.hhgs.net/
Referrer : http://www.hhgs.net/login.php?do=login
IP Address : *************
Username : Jin
Classname : vB_Database
MySQL Version : 5.0.51a-community

Whats this about?

[Lynne]

It looks like a problem with the table pmtext. Can you read your pms on your site? Have you tried to optimize/repair that table?

[silvermerc]

Database error in vBulletin 3.7.4:

Invalid SQL:

SELECT pm.*, pmtext.*
, icon.title AS icontitle, icon.iconpath
FROM pm AS pm
LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
WHERE pm.userid=1 AND pm.folderid=0
ORDER BY pmtext.dateline DESC
LIMIT 0, 50;

MySQL Error : Table 'hhgsnet_vb.pmtext' doesn't exist
Error Number : 1146
Request Date : Monday, December 29th 2008 @ 07:13:21 PM
Error Date : Monday, December 29th 2008 @ 07:13:21 PM
Script : http://www.hhgs.net/private.php
Referrer : http://www.hhgs.net/index.php
IP Address : ***********
Username : Ross
Classname : vB_Database
MySQL Version : 5.0.51a-community

When i attempt to read my PM's. How and where would i optimize the table?

[Lynne]

In your admin cp > maintenance > repair/optimize tables.

It looks to me like your pmtext table was dropped. What did you do just prior to having this problem?

[silvermerc]

Results
Table Action Message
access Check Status: OK
access Optimize Status: OK
adminhelp Check Status: OK
adminhelp Optimize Status: OK
administrator Check Status: OK
administrator Optimize Status: OK
adminlog Check Status: OK
adminlog Optimize Status: OK
adminmessage Check Status: OK
adminmessage Optimize Status: OK
adminutil Check Status: OK
adminutil Optimize Status: OK
adv_modules Check Status: OK
adv_modules Optimize Status: OK
adv_pages Check Status: OK
adv_pages Optimize Status: OK
adv_setting Check Status: OK
adv_setting Optimize Status: Table is already up to date
adv_settinggroup Check Status: OK
adv_settinggroup Optimize Status: OK
album Check Status: OK
album Optimize Status: OK
albumpicture Check Status: OK
albumpicture Optimize Status: OK
announcement Check Status: OK
announcement Optimize Status: OK
announcementread Check Status: OK
announcementread Optimize Status: OK
arcade_favorites Check Status: OK
arcade_favorites Optimize Status: Table is already up to date
attachment Check Status: OK
attachment Optimize Status: OK
attachmentpermission Check Status: OK
attachmentpermission Optimize Status: OK
attachmenttype Check Status: OK
attachmenttype Optimize Status: OK
attachmentviews Check Status: OK
attachmentviews Optimize Status: Table is already up to date
avatar Check Status: OK
avatar Optimize Status: OK
badwords Check Status: OK
badwords Optimize Status: Table is already up to date
bbcode Check Status: OK
bbcode Optimize Status: OK
bookmarksite Check Status: OK
bookmarksite Optimize Status: OK
bot Check Status: OK
bot Optimize Status: OK
bots Check Status: OK
bots Optimize Status: Table is already up to date
calendar Check Status: OK
calendar Optimize Status: OK
calendarcustomfield Check Status: OK
calendarcustomfield Optimize Status: OK
calendarmoderator Check Status: OK
calendarmoderator Optimize Status: OK
calendarpermission Check Status: OK
calendarpermission Optimize Status: OK
conversationlog Check Status: OK
conversationlog Optimize Status: OK
cron Check Status: OK
cron Optimize Status: OK
cronlog Check Status: OK
cronlog Optimize Status: OK
customavatar Check Status: OK
customavatar Optimize Status: OK
customprofilepic Check Status: OK
customprofilepic Optimize Status: OK
datastore Check Status: OK
datastore Optimize Status: OK
deletionlog Check Status: OK
deletionlog Optimize Status: OK
dstore Check Status: OK
dstore Optimize Status: OK
editlog Check Status: OK
editlog Optimize Status: OK
event Check Status: OK
event Optimize Status: OK
externalcache Check Status: OK
externalcache Optimize Status: OK
faq Check Status: OK
faq Optimize Status: OK
forum Check Status: OK
forum Optimize Status: OK
forumpermission Check Status: OK
forumpermission Optimize Status: OK
forumprefixset Check Status: OK
forumprefixset Optimize Status: OK
forumread Check Status: OK
forumread Optimize Status: OK
games_cats Check Status: OK
games_cats Optimize Status: OK
games_champs Check Status: OK
games_champs Optimize Status: OK
games_league Check Status: OK
games_league Optimize Status: OK
games_list Check Status: OK
games_list Optimize Status: OK
games_savedGames Check Status: OK
games_savedGames Optimize Status: Table is already up to date
games_scores Check Status: OK
games_scores Optimize Status: OK
games_session Check Status: OK
games_session Optimize Status: OK
games_settings Check Status: OK
games_settings Optimize Status: Table is already up to date
gmcache Check Status: OK
gmcache Optimize Status: OK
gossip Check Status: OK
gossip Optimize Status: OK
groupmessage Check Status: OK
groupmessage Optimize Status: OK
groupmessage_hash Check Status: OK
groupmessage_hash Optimize Status: OK
holiday Check Status: OK
holiday Optimize Status: OK
humanverify Check Status: OK
humanverify Optimize Status: OK
hvanswer Check Status: OK
hvanswer Optimize Status: OK
hvquestion Check Status: OK
hvquestion Optimize Status: OK
icon Check Status: OK
icon Optimize Status: OK
imagecategory Check Status: OK
imagecategory Optimize Status: OK
imagecategorypermission Check Status: OK
imagecategorypermission Optimize Status: OK
infraction Check Status: OK
infraction Optimize Status: OK
infractionban Check Status: OK
infractionban Optimize Status: OK
infractiongroup Check Status: OK
infractiongroup Optimize Status: OK
infractionlevel Check Status: OK
infractionlevel Optimize Status: OK
language Check Status: OK
language Optimize Status: OK
macro Check Status: OK
macro Optimize Status: OK
mailqueue Check Status: OK
mailqueue Optimize Status: OK
moderation Check Status: OK
moderation Optimize Status: OK
moderator Check Status: OK
moderator Optimize Status: OK
moderatorlog Check Status: OK
moderatorlog Optimize Status: OK
modsys_coder Check Status: OK
modsys_coder Optimize Status: OK
modsys_designer Check Status: OK
modsys_designer Optimize Status: OK
modsys_licences Check Status: OK
modsys_licences Optimize Status: OK
modsys_motm Check Status: OK
modsys_motm Optimize Status: Table is already up to date
modsys_settings Check Status: OK
modsys_settings Optimize Status: OK
modsys_stats Check Status: OK
modsys_stats Optimize Status: Table is already up to date
modsys_user_notification Check Status: OK
modsys_user_notification Optimize Status: OK
modsys_versions Check Status: OK
modsys_versions Optimize Status: OK
notice Check Status: OK
notice Optimize Status: OK
noticecriteria Check Status: OK
noticecriteria Optimize Status: OK
passwordhistory Check Status: OK
passwordhistory Optimize Status: OK
patterns Check Status: OK
patterns Optimize Status: OK
paymentapi Check Status: OK
paymentapi Optimize Status: OK
paymentinfo Check Status: OK
paymentinfo Optimize Status: OK
paymenttransaction Check Status: OK
paymenttransaction Optimize Status: OK
phrase Check Status: OK
phrase Optimize Status: OK
phrasetype Check Status: OK
phrasetype Optimize Status: OK
picture Check Status: OK
picture Optimize Status: OK
picturecomment Check Status: OK
picturecomment Optimize Status: OK
picturecomment_hash Check Status: OK
picturecomment_hash Optimize Status: OK
plugin Check Status: OK
plugin Optimize Status: OK
pm Check Status: OK
pm Optimize Status: OK
pmreceipt Check Status: OK
pmreceipt Optimize Status: OK
podcast Check Status: OK
podcast Optimize Status: Table is already up to date
podcastitem Check Status: OK
podcastitem Optimize Status: Table is already up to date
poll Check Status: OK
poll Optimize Status: OK
pollvote Check Status: OK
pollvote Optimize Status: OK
post Check Status: OK
post Optimize Status: OK
postedithistory Check Status: OK
postedithistory Optimize Status: OK
posthash Check Status: OK
posthash Optimize Status: OK
postindex Check Status: OK
postindex Optimize Status: OK
postlog Check Status: OK
postlog Optimize Status: OK
postparsed Check Status: OK
postparsed Optimize Status: OK
prefix Check Status: OK
prefix Optimize Status: OK
prefixset Check Status: OK
prefixset Optimize Status: OK
product Check Status: OK
product Optimize Status: OK
productcode Check Status: OK
productcode Optimize Status: OK
productdependency Check Status: OK
productdependency Optimize Status: OK
profilefield Check Status: OK
profilefield Optimize Status: OK
profilefieldcategory Check Status: OK
profilefieldcategory Optimize Status: Table is already up to date
profilevisitor Check Status: OK
profilevisitor Optimize Status: OK
ranks Check Status: OK
ranks Optimize Status: OK
rareimages Check Status: OK
rareimages Optimize Status: OK
reminder Check Status: OK
reminder Optimize Status: Table is already up to date
reputation Check Status: OK
reputation Optimize Status: OK
reputationlevel Check Status: OK
reputationlevel Optimize Status: OK
rssfeed Check Status: OK
rssfeed Optimize Status: OK
rsslog Check Status: OK
rsslog Optimize Status: OK
rule Check Status: OK
rule Optimize Status: OK
rvrusrs Check Status: OK
rvrusrs Optimize Status: OK
search Check Status: OK
search Optimize Status: OK
setting Check Status: OK
setting Optimize Status: OK
settinggroup Check Status: OK
settinggroup Optimize Status: OK
shout Check Status: OK
shout Optimize Status: OK
sigparsed Check Status: OK
sigparsed Optimize Status: OK
sigpic Check Status: OK
sigpic Optimize Status: OK
smilie Check Status: OK
smilie Optimize Status: OK
socialgroup Check Status: OK
socialgroup Optimize Status: OK
socialgroupmember Check Status: OK
socialgroupmember Optimize Status: OK
socialgrouppicture Check Status: OK
socialgrouppicture Optimize Status: OK
spamlog Check Status: OK
spamlog Optimize Status: Table is already up to date
stats Check Status: OK
stats Optimize Status: OK
strikes Check Status: OK
strikes Optimize Status: OK
style Check Status: OK
style Optimize Status: OK
subscribeevent Check Status: OK
subscribeevent Optimize Status: OK
subscribeforum Check Status: OK
subscribeforum Optimize Status: OK
subscribethread Check Status: OK
subscribethread Optimize Status: OK
subscription Check Status: OK
subscription Optimize Status: OK
subscriptionlog Check Status: OK
subscriptionlog Optimize Status: OK
subscriptionpermission Check Status: OK
subscriptionpermission Optimize Status: OK
tachyforumcounter Check Status: OK
tachyforumcounter Optimize Status: Table is already up to date
tachyforumpost Check Status: OK
tachyforumpost Optimize Status: OK
tachythreadcounter Check Status: OK
tachythreadcounter Optimize Status: Table is already up to date
tachythreadpost Check Status: OK
tachythreadpost Optimize Status: OK
tag Check Status: OK
tag Optimize Status: OK
tagsearch Check Status: OK
tagsearch Optimize Status: OK
tagthread Check Status: OK
tagthread Optimize Status: OK
template Check Status: OK
template Optimize Status: OK
templatehistory Check Status: OK
templatehistory Optimize Status: OK
templates Check Status: OK
templates Optimize Status: OK
thatindex Check Status: OK
thatindex Optimize Status: Table is already up to date
thatstack Check Status: OK
thatstack Optimize Status: Table is already up to date
thread Check Status: OK
thread Optimize Status: OK
threadrate Check Status: OK
threadrate Optimize Status: OK
threadread Check Status: OK
threadread Optimize Status: OK
threadredirect Check Status: OK
threadredirect Optimize Status: OK
threadviews Check Status: OK
threadviews Optimize Status: Table is already up to date
tournament_players Check Status: OK
tournament_players Optimize Status: OK
tournament_players_statut Check Status: OK
tournament_players_statut Optimize Status: OK
tournaments Check Status: OK
tournaments Optimize Status: OK
upgradelog Check Status: OK
upgradelog Optimize Status: OK
user Check Status: OK
user Optimize Status: OK
useractivation Check Status: OK
useractivation Optimize Status: OK
userban Check Status: OK
userban Optimize Status: OK
userchangelog Check Status: OK
userchangelog Optimize Status: OK
usercss Check Status: OK
usercss Optimize Status: OK
usercsscache Check Status: OK
usercsscache Optimize Status: OK
userfield Check Status: OK
userfield Optimize Status: OK
usergroup Check Status: OK
usergroup Optimize Status: OK
usergroupleader Check Status: OK
usergroupleader Optimize Status: OK
usergrouprequest Check Status: OK
usergrouprequest Optimize Status: OK
userlist Check Status: OK
userlist Optimize Status: OK
usernote Check Status: OK
usernote Optimize Status: OK
userpromotion Check Status: OK
userpromotion Optimize Status: OK
usertextfield Check Status: OK
usertextfield Optimize Status: OK
usertitle Check Status: OK
usertitle Optimize Status: OK
visitormessage Check Status: OK
visitormessage Optimize Status: OK
visitormessage_hash Check Status: OK
visitormessage_hash Optimize Status: OK
word Check Status: OK
word Optimize Status: OK

Nothing at all, I just got a email saying the vb error above ^_^

[Lynne]

Yep, it looks like your pmtext table was dropped. It got dropped somehow... you need to find out how or it may happen again.

i don't know what the query is to add it again. You should ask over on vb.com for it.

[silvermerc]

Would it work if i re-installed the vB? or is it nothing to do with that?

[Lynne]

Well, the pmtext table does get installed when you install vb. I'm really not sure if you can just run the upgrade script and have it appear since I have never had to do this.

Again, I'll say that you need to figure out how it was dropped or it may happen again.

[silvermerc]

I just re-installed vB done absolutly nothing, How can i find how it dropped?

[Lynne]

So, you reinstalled vB and then it was dropped? It sounds like you didn't do all the steps in the installation correctly if the table wasn't created.