Perl-Evozon / PearlBee

116 stars 44 forks source link

Password salt column too small #59

Open cromedome opened 8 years ago

cromedome commented 8 years ago

While porting PearlBee to PostgreSQL, I noticed that your password salt column (user.salt) is too small. It is defined as char(24), but when I was testing on Postgres, it was producing 25 character salts.

If you are using MySQL in Strict SQL mode, this insert will rightfully fail (as it does in Postgres). If you want to run PearlBee and have a better-than-default config, your blog will break.