Wordpress Install Issue

[cea]

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.

[cea]

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.

[Wayne Luke]

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;

[cea]

Still not working

No php or database error.

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

[Wayne Luke]

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?

[cea]

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.