phemellc / yii2-settings

Yii2 Settings Module
Other
151 stars 74 forks source link

Using with sqlite #78

Open tony-ist opened 6 years ago

tony-ist commented 6 years ago

When I try to create new settings or edit I get error

SQLSTATE[HY000]: General error: 1 no such function: NOW
Failed to prepare SQL: INSERT INTO `settings` (`active`, `section`, `key`, `value`, `type`, `created`) VALUES (:qp0, :qp1, :qp2, :qp3, :qp4, NOW())

I am using sqlite database, seems like there is no function NOW there. How do I fix the problem?