Users running a non-download version of Vanilla (pulled from github), on branch release/2019.016 or master from the last 2 weeks should upgrade to release/2019.017 or latest master for security reasons. Downloaded official open sources releases are not affected.
Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.

Wordpress & Vanilla integration problem

edited November 2006 in Vanilla 1.0 Help
I was attempting the wordpress and vanilla integration (using wordpress 2.0.5 & vanilla 1.0.1) and I thought I dropped everything in correctly, inputted the SQL code for the altering of the wp_users table and this is what happens when I try to load up the wordpress/vanilla/index.php main page. I even tried removing the people.php file completely which has no effect.

Any ideas?

Notice: Undefined index: Discussion in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Functions.php on line 439 Notice: Undefined index: Discussion in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 117 Notice: Undefined index: Discussion in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 117 Notice: Undefined index: Discussion in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 117 Notice: Undefined index: Discussion in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 117 Notice: Undefined index: Discussion in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 117 Notice: Undefined index: Discussion in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 117 Notice: Undefined index: Discussion in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 117 Notice: Undefined index: Discussion in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 117 Notice: Undefined index: Discussion in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 117 Notice: Undefined index: Discussion in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 117 Notice: Undefined index: Discussion in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 117 Notice: Undefined index: Discussion in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 117 Notice: Undefined index: Discussion in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 117 Notice: Undefined index: Discussion in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 117 Notice: Undefined index: Discussion in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 68 Notice: Undefined index: Discussion in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 68 Notice: Undefined index: Category in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Functions.php on line 439 Notice: Undefined index: Discussion in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 68 Notice: Undefined index: Category in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 68 Notice: Undefined index: Category in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 117 Notice: Undefined index: CategoryRoleBlock in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Vanilla/Vanilla.Class.DiscussionManager.php on line 108 Notice: Undefined index: CategoryRoleBlock in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Functions.php on line 439 Notice: Undefined index: Discussion in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 68 Notice: Undefined index: CategoryRoleBlock in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 68 Notice: Undefined index: UserBookmark in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Vanilla/Vanilla.Class.DiscussionManager.php on line 116 Notice: Undefined index: UserBookmark in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Functions.php on line 439 Notice: Undefined index: Discussion in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 68 Notice: Undefined index: UserBookmark in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 68 Notice: Undefined index: UserBookmark in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 117 Notice: Undefined index: UserDiscussionWatch in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Vanilla/Vanilla.Class.DiscussionManager.php on line 120 Notice: Undefined index: UserDiscussionWatch in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Functions.php on line 439 Notice: Undefined index: Discussion in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 68 Notice: Undefined index: UserDiscussionWatch in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 68 Notice: Undefined index: UserDiscussionWatch in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 117 Notice: Undefined index: UserDiscussionWatch in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 117 Notice: Undefined index: Discussion in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 94 Notice: Undefined index: Discussion in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 94 Notice: Undefined index: CategoryRoleBlock in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 251 Notice: Undefined index: CategoryRoleBlock in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 251 Notice: Undefined index: CategoryRoleBlock in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 251 Notice: Undefined index: Discussion in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 251 Notice: Undefined index: Discussion in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 251 Notice: Undefined index: Discussion in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 251 Notice: Undefined index: Discussion in /home/tyrun/public_html/creativity-unleashed/wordpress/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 251 A fatal, non-recoverable error has occurred Technical information (for support personel): Error Message An error occurred while retrieving discussions. Affected Elements DiscussionManager.GetDiscussionList(); The error occurred on or near: 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 'as DiscussionID, t. as FirstCommentID, t. as AuthUserID, t. as WhisperUserID,' at line 1 For additional support documentation, visit the Lussumo Documentation website at: lussumo.com/docs

Comments

  • I've got no ideas as that's all way beyond me, but you may want to edit your post and select "HTML" where it says "Format comments as" at the bottom, just above the post/preview buttons ;)
  • Thanks :)
    A little easier to read the errors... unfortunately they're still errors :(
  • Fixed.
    I deleted the entire directory and started again from scratch, testing each step along the way.

    Everything worked fine, even the authentication integration module.

    Thanks for putting together a great software project here Mark (and everyone else that's contributed)! Keep up the great work!!
This discussion has been closed.