Impex Database error ((****_vbulletin.contenttype' doesn't exist))

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • MsJacquiiC
    Senior Member
    • Nov 2006
    • 325
    • 3.8.x

    Impex Database error ((****_vbulletin.contenttype' doesn't exist))

    I receive the following error when attempting to redo the Import attachment module for a phpBB 3 to vB 3.8.7 migration:

    ImpEx Database error

    mysql error: Invalid SQL:
    SELECT c.contenttypeid
    FROM contenttype AS c
    INNER JOIN package AS p ON (c.packageid = p.packageid)
    WHERE
    c.class = ''
    AND
    p.productid = ''


    mysql error: Table '****_vbulletin.contenttype' doesn't exist

    mysql error number: 1146

    Date: Monday 03rd 2011f October 2011 02:38:37 PM
    Database: ****_vbulletin
    MySQL error:
    This was after a successful migration where attachments seemed to show just fine. I've verified that 270+ attachments were successfully imported:



    However - the attachment icons in forumdisplay do not show, even if there are attachments in the thread. And "some" attachments are not showing in thread/posts at all, even after running update counters.

    Someone help assist with this issue please

    Jacquii.



    "Question my skill set perhaps, but never question my heart." -- JacquiiCooke.com
  • borbole
    Senior Member
    • Feb 2010
    • 3074
    • 4.0.0

    #2
    Can you check the database and see if the contenttype table is there?

    Comment

    • MsJacquiiC
      Senior Member
      • Nov 2006
      • 325
      • 3.8.x

      #3
      I'm viewing via AdminCP Repair / Optimize Tables and no - I don't see the contenttype table



      "Question my skill set perhaps, but never question my heart." -- JacquiiCooke.com

      Comment

      • Lynne
        Former vBulletin Support
        • Oct 2004
        • 26255

        #4
        That contenttype table is a vB4 table, not a vB3 table.

        Please don't PM or VM me for support - I only help out in the threads.
        vBulletin Manual & vBulletin 4.0 Code Documentation (API)
        Want help modifying your vbulletin forum? Head on over to vbulletin.org
        If I post CSS and you don't know where it goes, throw it into the additional.css template.

        W3Schools <- awesome site for html/css help

        Comment

        • MsJacquiiC
          Senior Member
          • Nov 2006
          • 325
          • 3.8.x

          #5
          That has to be a bug of some sort in the impex script then, as I'm 100% sure I'd selected the correct vB version.
          The error would occur only when rerunning the module.

          Whatever the case may be - I simply cleaned up and restarted the import. After a few times - the data imported correctly.
          Thanks for responses everybody.

          J.



          "Question my skill set perhaps, but never question my heart." -- JacquiiCooke.com

          Comment

          • cea
            New Member
            • Sep 2011
            • 14
            • 4.1.x

            #6
            Definite Bug

            You are correct. There is a bug. I have attempted Wordpress to VB CMS import 10 times in the past 48 hours.

            Each time with similar errors.

            No help from Support.

            ImpEx Database error

            mysql error: Invalid SQL:
            SELECT node.nodeid
            FROM vbcms_article AS article
            INNER JOIN vbcms_node AS node ON (article.contentid = node.contentid AND node.contenttypeid = 24)
            WHERE article.importcmscontentid <> 0


            mysql error: Unknown column 'article.importcmscontentid' in 'where clause'

            mysql error number: 1054

            Comment

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