Announcement

Collapse
No announcement yet.

Persistant Error

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

  • #16
    Loose all the PMs? thats not a big deal, tho important to the users they can't send them at all atm really anyway so.. yeah hit me up with that. Thanks.

    BTW could a crappy server cause this to happen? B/c Mine sucks and I am moving from it asap then I am going to turn around and stab it... then run it over.

    Comment


    • #17
      First backup your database. Then delete those three tables and run these three queries to recreate them for 3.0.3:

      CREATE TABLE 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),
      KEY folderid (folderid)
      );

      CREATE TABLE pmreceipt (
      pmid INT UNSIGNED NOT NULL DEFAULT '0',
      userid INT UNSIGNED NOT NULL DEFAULT '0',
      touserid INT UNSIGNED NOT NULL DEFAULT '0',
      tousername VARCHAR(50) NOT NULL DEFAULT '',
      title VARCHAR(250) NOT NULL DEFAULT '',
      sendtime INT UNSIGNED NOT NULL DEFAULT '0',
      readtime INT UNSIGNED NOT NULL DEFAULT '0',
      denied SMALLINT UNSIGNED NOT NULL DEFAULT '0',
      PRIMARY KEY (pmid),
      KEY userid (userid),
      KEY touserid (touserid)
      );

      CREATE TABLE pmtext (
      pmtextid INT UNSIGNED NOT NULL AUTO_INCREMENT,
      fromuserid INT UNSIGNED NOT NULL DEFAULT '0',
      fromusername VARCHAR(50) NOT NULL DEFAULT '',
      title VARCHAR(250) NOT NULL DEFAULT '',
      message MEDIUMTEXT NOT NULL,
      touserarray MEDIUMTEXT NOT NULL,
      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)
      );

      Then run these queries to reset the pm totals:

      UPDATE user SET pmtotal='0';

      UPDATE user SET pmunread='0';
      Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
      Change CKEditor Colors to Match Style (for 4.1.4 and above)

      Steve Machol Photography


      Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


      Comment


      • #18
        Thank you! I will be doing that tommorow, I just had to post a message warning users today to back up any important PMs they can access..

        Comment


        • #19
          It worked, thanks guys!

          Comment

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