Announcement

Collapse
No announcement yet.

ImpEx Database error Message During FuseTalk Import

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

  • ImpEx Database error Message During FuseTalk Import

    I am receiving the error below during step 5 of the Impex import process (Import Thread) on a "clean" (new) forum install.

    Steps 1, 3, and 4 all complete without error (I skip step 2 - Associate Users).

    I have tried the "Force SQL" suggestion from the following forum post:

    http://www.vbulletin.com/forum/showt...vB-3.7.2-issue

    and verified that the Impex Config file is otherwise correct

    Any other suggestions? I was previously able to complete an import from Fusetalk during testing, so I'm not sure what the problem is at this point.


    --------------------

    ImpEx Database error

    mssql error: Invalid SQL: SELECT ithreadid,
    vchthreadname,
    dtinsertdate,
    iuserid,
    icategoryid,
    imessagecount,
    iviewcount,
    FROM ftdb_arcthreads WHERE ithreadid
    IN(SELECT TOP 0 ithreadid
    FROM (SELECT TOP 0 ithreadid FROM ftdb_arcthreads ORDER BY ithreadid)
    A ORDER BY ithreadid DESC)
    ORDER BY ithreadid


    mssql error: Incorrect syntax near the keyword 'ORDER'.

    Date: Friday 15th 2010f October 2010 11:15:34 AM
    Database: FuseTalk_import

  • #2
    Update:

    Since I received no response to this, I submitted a Support Ticket. After being notified that I needed to purchase a service contract per the newly-enforced policy mentioned here:

    http://www.vbulletin.com/forum/showt...Product-owners

    I purchased a new support contract and am anxiously waiting on a response/solution to justify the investment.

    Comment

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