PDA

View Full Version : Cannot install blog beta 3



mihai11
Fri 10th Oct '08, 1:00pm
I get this error after the installation has succeeded:



Invalid SQL:
SELECT blog.*, blog_text.pagetext, blog_text.allowsmilie, user.*, blog_user.title AS blogtitle,
blog_textparsed.pagetexthtml, blog_textparsed.hasimages, blog_user.options_everyone, blog_user.options_buddy,
blog_editlog.userid AS edit_userid, blog_editlog.dateline AS edit_dateline, blog_editlog.reason AS edit_reason, blog_editlog.username AS edit_username
FROM ro_blog AS blog
INNER JOIN ro_blog_text AS blog_text ON (blog.firstblogtextid = blog_text.blogtextid)
LEFT JOIN ro_blog_editlog AS blog_editlog ON (blog_editlog.blogtextid = blog.firstblogtextid)
LEFT JOIN ro_blog_textparsed AS blog_textparsed ON(blog_textparsed.blogtextid = blog_text.blogtextid AND blog_textparsed.styleid = 2 AND blog_textparsed.languageid = 2)
LEFT JOIN ro_user AS user ON (blog.userid = user.userid)
LEFT JOIN ro_blog_user AS blog_user ON (blog_user.bloguserid = user.userid)
WHERE blog.blogid = 90;

MySQL Error : Unknown column 'blog_user.options_everyone' in 'field list'
Error Number : 1054
Request Date : Friday, October 10th 2008 @ 06:51:05 PM
Error Date : Friday, October 10th 2008 @ 06:51:05 PM
Classname : vB_Database
MySQL Version : 5.0.51a-3ubuntu5.1-log
I read in another thread that users of vBlogetin could face various issues - well, I never used vBlogetin on my board.

Previously, on my board I had VB-blog 1.0.4 which was running OK. After the upgrade, the whole board (just a testing board ;) ) is down because of the above error.

Please tell me how to fix it.


Regards,
Razvan

PitchouneN64ngc
Fri 10th Oct '08, 7:45pm
This is not a bug with Blog ;)

http://www.vbulletin.com/forum/project.php?issueid=26522