vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   I dont get it? (https://vborg.vbsupport.ru/showthread.php?t=200101)

silvermerc 12-29-2008 04:13 PM
I dont get it?
 
Quote:
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 12-29-2008 05:11 PM
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 12-29-2008 05:14 PM
Quote:
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 12-29-2008 05:19 PM
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 12-29-2008 05:23 PM
Quote:
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 12-29-2008 05:36 PM
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 12-29-2008 05:41 PM
Would it work if i re-installed the vB? or is it nothing to do with that?

Lynne 12-29-2008 05:45 PM
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 12-29-2008 06:06 PM
I just re-installed vB done absolutly nothing, How can i find how it dropped?

Lynne 12-29-2008 06:26 PM
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.

silvermerc 12-29-2008 06:26 PM
Nope it didnt change anything :L

Lynne 12-29-2008 06:30 PM
Then ask over on vb.com for the query to run to create the table or look in the install script for the query.

silvermerc 12-29-2008 08:12 PM
I did a support thing on vb.com and its been a hour at 11 mins, The response thing said 23 mins last time i checked :P

Paul M 12-29-2008 08:16 PM
CREATE TABLE pmtext (
pmtextid INT UNSIGNED NOT NULL AUTO_INCREMENT,
fromuserid INT UNSIGNED NOT NULL DEFAULT '0',
fromusername VARCHAR(100) NOT NULL DEFAULT '',
title VARCHAR(250) NOT NULL DEFAULT '',
message MEDIUMTEXT,
touserarray MEDIUMTEXT,
iconid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
dateline INT UNSIGNED NOT NULL DEFAULT '0',
showsignature SMALLINT UNSIGNED NOT NULL DEFAULT '0',
allowsmilie SMALLINT UNSIGNED NOT NULL DEFAULT '1',
PRIMARY KEY (pmtextid),
KEY fromuserid (fromuserid, dateline)
) ;

silvermerc 12-29-2008 09:39 PM
Now all fixed, Thanks to the support over at vB.com took a hour and a half but well worth it. Once again saved the day !

Digital Jedi 12-29-2008 11:38 PM
Quote:
Originally Posted by silvermerc (Post 1696712)
I did a support thing on vb.com and its been a hour at 11 mins, The response thing said 23 mins last time i checked :P
Keeping in mind that it's only an estimate and not a guarantee on how fast they will or are able to fix it. 90 minutes is pretty good response time though.


All times are GMT. The time now is 01:43 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01302 seconds
  • Memory Usage 1,807KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (16)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete