No announcement yet.

Fix broken pm table using existing data.

  • Filter
  • Time
  • Show
Clear All
new posts

  • Fix broken pm table using existing data.

    Hello all. I hope someone from vbulletin reads this.

    I recently encountered a problem when doing a forum upgrade / merge. Somehow my pm table in mysql lost some of its data. The pmtext table is still there, but my users can't access their pms because of the broken pm table.

    I figured there HAS to be a way to rebuild this pm table using just sql commands. I haven't been able to figure out how to do the following...

    For each row in table 'user'
    For each row in table 'pmtext'
    If user:username is found in pmtext:touserarray {
    Insert New Row into table 'pm'
    Set pmtextid = Current(pmtextmtextid)
    Set userid = Current(user:userid)
    }End If
    Next RowIn pmtext
    Next RowIn user

    I know its a bad mix of visualbasic, php and sql, but the concept is there. The guys at vbulletin said that I needed to go to, and I didn't find any help there. I'm hoping that someone from Team Vbulletin might take this opportunity to either

    A. Add this to the next vbulletin release,
    B. Possibly whip me up a SQL statement, or multiple statements.

  • #2
    Do you have a recent backup?


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