Blog Documentation Book a Demo
Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Bug: increase CountDiscussions SQL

jben.netjben.net
edited August 2006 in Vanilla 1.0 Help

I'm using my own users table, I've set my column names to all use a prefix, which I've added to my conf/database.php file and I think I've found a bug. When you try to post a new disussion, Vanilla tries to increase the CountDiscussions value by one, but it's trying to retrieve the value using the none custom column name, which generates an SQL error:

update users set LUM_DateLastActive='2006-08-15 16:20:52', LUM_CountDiscussions=CountDiscussions+1, LUM_DiscussionSpamCheck='1', LUM_LastDiscussionPost='2006-08-15 16:20:52' where id = '1'

as you can see, it's setting the value of LUM_CountDiscussions to CountDiscussions+1, but CountDiscussions doesn't exist.

thanks,

jon

Comments

  • MarkMark Vanilla Staff
    Thanks for this. I've just fixed it in subversion and it will be in the Vanilla 1.0.1 release.
  • jben.netjben.net
    not a problem.

    is it possible for to grab the amended files, or perhaps the latest trunk, because it's impossible for me to add any discussions at present.

    Thanks,

    jon
  • MarkMark Vanilla Staff
    Yes. Vanilla source: http://lussumo.com/svn/vanilla/trunk/ Vanilla's library/framework and library/people sources: http://lussumo.com/svn/framework/trunk/ http://lussumo.com/svn/people/trunk/
This discussion has been closed.