Announcement

Collapse
No announcement yet.

Wordpress Install Issue

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

  • Wordpress Install Issue

    Preface - I have attempted to import Wordpress to VB CMS about 20 times. Two separate development/production areas, different databases, multiple installs.

    Each time, I can successfully import users and categories.

    Posts will not import. We get a this error among many:

    ImpEx Database error


    mysql error: Invalid SQL:
    SELECT node.nodeid
    FROM vb_cms_article AS article
    INNER JOIN vb_cms_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


    Please help.

  • #2
    I'm getting the same thing. We have attempted the import using different versions of Wordpress. None Work.

    I'm not getting any satisfaction via support.

    Please help. Ditto.

    Comment


    • #3
      At this time, you would need to manually add that column to your article table to proceed with the import.

      alter table `article` add `importcmscontentid` integer not null;
      Translations provided by Google.

      Wayne Luke
      The Rabid Badger - a vBulletin Cloud demonstration site.
      vBulletin 5 API - Full / Mobile
      Vote for your favorite feature requests and the bugs you want to see fixed.

      Comment


      • #4
        Still not working

        No php or database error.

        Just says "Importing 0 Nodes" when I attempt to import CMS articles.

        Click image for larger version

Name:	Screen Shot 2011-10-13 at 10.30.44 AM.png
Views:	1
Size:	34.4 KB
ID:	3685660Click image for larger version

Name:	Screen Shot 2011-10-13 at 10.30.58 AM.png
Views:	1
Size:	88.6 KB
ID:	3685661

        Comment


        • #5
          I see you're working this issue in a ticket with Lynne. As she has the appropriate connection information and more of an idea of the underlying issues, can we keep this in a single location?
          Translations provided by Google.

          Wayne Luke
          The Rabid Badger - a vBulletin Cloud demonstration site.
          vBulletin 5 API - Full / Mobile
          Vote for your favorite feature requests and the bugs you want to see fixed.

          Comment


          • #6
            I'm just trying to get other help from people who are actually using the system. No answers on the backend.

            I'm really frustrated and need some help.

            Comment

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