Announcement

Collapse
No announcement yet.

MySQL Error : Table 'rxqptdcc_new.MixMake_pm' doesn't exist

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL Error : Table 'rxqptdcc_new.MixMake_pm' doesn't exist

    This has been a huge hassle for myself so I'll save you all the time and make this long story short. For some reason, the table rxqptdcc_new.MixMake_pm doesn't exist. Is there a query I can run that can add that table, even if it does erase all PMs. Here is the original error:

    Database error in vBulletin 3.5.4:

    Invalid SQL:

    SELECT pm.*, pmtext.*
    ,icon.iconpath, icon.title AS icontitle
    FROM MixMake_pm AS pm
    INNER JOIN MixMake_pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
    LEFT JOIN MixMake_icon AS icon ON(icon.iconid = pmtext.iconid)
    WHERE pm.userid = 1
    AND pmtext.dateline > 1148767842
    AND pm.messageread = 0;

    MySQL Error : Table 'rxqptdcc_new.MixMake_pm' doesn't exist
    Error Number : 1146
    Date : Sunday, June 4th 2006 @ 11:14:27 PM
    Script : http://64.72.127.170/forums/usercp.php
    Referrer : http://64.72.127.170/forums/index.php?
    IP Address : 70.170.79.43
    Username : Admin
    Classname : vb_database

  • #2
    I assume "MixMake_" is your table prefix.

    This is the query to create that table:

    Code:
    CREATE TABLE MixMake_pm (
    	pmid INT UNSIGNED NOT NULL AUTO_INCREMENT,
    	pmtextid INT UNSIGNED NOT NULL DEFAULT '0',
    	userid INT UNSIGNED NOT NULL DEFAULT '0',
    	folderid SMALLINT NOT NULL DEFAULT '0',
    	messageread SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    	PRIMARY KEY (pmid),
    	KEY pmtextid (pmtextid),
    	KEY userid (userid, folderid)
    )
    With one of the 3 PM tables missing, you might want to start fresh. See this thread.

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X