Hi,
I've downloaded version 2.0.0 and installed the CMS version. But we do not have the vbulletin blog installed so we receive this error:
Invalid SQL:
SELECT blog.blogid, blog.title, blog.dateline AS publishdate, blog_text.blogtextid, blog_text.pagetext AS message, contenttype.class, attachment.attachmentid as previewimage, fd.width, fd.height
FROM vb3_blog AS blog
INNER JOIN vb3_blog_text AS blog_text ON (blog_text.blogtextid = blog.firstblogtextid)
LEFT JOIN vb3_blog_categoryuser AS cu ON (cu.blogid = blog.blogid)
LEFT JOIN vb3_contenttype as contenttype ON (contenttype.class = 'BlogEntry')
LEFT JOIN vb3_attachment AS attachment ON ( attachment.contentid = blog.blogid ) AND ( contenttype.contenttypeid = attachment.contenttypeid )
LEFT JOIN vb3_filedata as fd ON (attachment.filedataid = fd.filedataid)
WHERE 1=1
AND blog.dateline <= 1337242640
GROUP BY blog.blogid
ORDER BY blog.dateline DESC
LIMIT 0,5;
MySQL-Error : Table 'db.vb3_blog' doesn't exist
I then installed the non CMS version for testing and there I get this error:
Invalid SQL:
SELECT cms_article.contentid, cms_article.pagetext AS message, cms_node.nodeid, cms_node.url, cms_node.publishdate, cms_nodeinfo.title, cms_article.previewimage
FROM vb3_cms_article AS cms_article
INNER JOIN vb3_cms_node AS cms_node ON ( cms_node.contentid = cms_article.contentid )
INNER JOIN vb3_cms_nodeinfo AS cms_nodeinfo ON ( cms_nodeinfo.nodeid = cms_node.nodeid )
LEFT JOIN vb3_cms_nodecategory AS cms_nodecategory ON ( cms_node.nodeid = cms_nodecategory.nodeid )
WHERE 1 =1
AND cms_node.parentnode IN (-1,)
AND cms_node.setpublish =1
AND cms_node.publishdate <= 1337243469
AND cms_node.publicpreview =1
ORDER BY cms_node.publishdate DESC
LIMIT 0,;
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 cms_node.setpublish =1
AND cms_node.publishdate <= 1337243469
' at line 7
I wold prefer the CMS version of your script. I also disabled everything in the Blog configuration of vbslider.
Thanks
Marco
I've downloaded version 2.0.0 and installed the CMS version. But we do not have the vbulletin blog installed so we receive this error:
Invalid SQL:
SELECT blog.blogid, blog.title, blog.dateline AS publishdate, blog_text.blogtextid, blog_text.pagetext AS message, contenttype.class, attachment.attachmentid as previewimage, fd.width, fd.height
FROM vb3_blog AS blog
INNER JOIN vb3_blog_text AS blog_text ON (blog_text.blogtextid = blog.firstblogtextid)
LEFT JOIN vb3_blog_categoryuser AS cu ON (cu.blogid = blog.blogid)
LEFT JOIN vb3_contenttype as contenttype ON (contenttype.class = 'BlogEntry')
LEFT JOIN vb3_attachment AS attachment ON ( attachment.contentid = blog.blogid ) AND ( contenttype.contenttypeid = attachment.contenttypeid )
LEFT JOIN vb3_filedata as fd ON (attachment.filedataid = fd.filedataid)
WHERE 1=1
AND blog.dateline <= 1337242640
GROUP BY blog.blogid
ORDER BY blog.dateline DESC
LIMIT 0,5;
MySQL-Error : Table 'db.vb3_blog' doesn't exist
I then installed the non CMS version for testing and there I get this error:
Invalid SQL:
SELECT cms_article.contentid, cms_article.pagetext AS message, cms_node.nodeid, cms_node.url, cms_node.publishdate, cms_nodeinfo.title, cms_article.previewimage
FROM vb3_cms_article AS cms_article
INNER JOIN vb3_cms_node AS cms_node ON ( cms_node.contentid = cms_article.contentid )
INNER JOIN vb3_cms_nodeinfo AS cms_nodeinfo ON ( cms_nodeinfo.nodeid = cms_node.nodeid )
LEFT JOIN vb3_cms_nodecategory AS cms_nodecategory ON ( cms_node.nodeid = cms_nodecategory.nodeid )
WHERE 1 =1
AND cms_node.parentnode IN (-1,)
AND cms_node.setpublish =1
AND cms_node.publishdate <= 1337243469
AND cms_node.publicpreview =1
ORDER BY cms_node.publishdate DESC
LIMIT 0,;
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 cms_node.setpublish =1
AND cms_node.publishdate <= 1337243469
' at line 7
I wold prefer the CMS version of your script. I also disabled everything in the Blog configuration of vbslider.
Thanks
Marco