Announcement

Collapse
No announcement yet.

Error redoing module

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

  • Error redoing module

    Ok so this morning i imported my database from phpbb.
    Throughout the day i redid the forum permissions and got everything ready to make it live tonight.

    Right before I went live, i decided to redo the import user module (because 50 new users registered).

    Now it gave me a bunch of sql errors.

    http://www.pbvids.com/forums/

    These are the errors i got

    Database error in vBulletin 3.0.7:

    Invalid SQL:
    SELECT COUNT(*) AS threads,
    SUM(IF(lastpost>= AND open<>10,1,0)) AS newthread
    FROM vb3_thread AS thread
    LEFT JOIN vb3_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
    WHERE forumid = 9
    AND sticky = 0
    AND visible = 1

    AND lastpost >= 1106376586

    AND deletionlog.primaryid IS NULL

    mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND open<>10,1,0)) AS newthread
    FROM vb3_thread AS thread
    L

    mysql error number: 1064
    Database error in vBulletin 3.0.7:

    Invalid SQL:
    SELECT * FROM vb3_cpsession
    WHERE userid =
    AND hash = '3bc9a22def624452e9130053dc8c9230'
    AND dateline > 1108965224
    mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND hash = '3bc9a22def624452e9130053dc8c9230'
    AND dateline >
    Can someone please help me out?

    Thanks

  • #2
    I believe you are going to need to redo the import from scratch.
    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


    • #3
      Indeed you are, if you redo one module you need to redo the modules that are dependant on it as all the user id's would change.
      I wrote ImpEx.

      Blog | Me

      Comment

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