Announcement

Collapse
No announcement yet.

Error redoing module

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

  • Jerry
    replied
    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.

    Leave a comment:


  • Steve Machol
    replied
    I believe you are going to need to redo the import from scratch.

    Leave a comment:


  • Pooh
    started a topic Error redoing module

    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
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X