search

tuxis-ie / nsedit

DNS Editor working with PowerDNS's new API
GNU General Public License v2.0
199 stars 55 forks source link

Warning: SQLite3Stmt::execute() [sqlite3stmt.execute]: Unable to execute statement: constraint failed in .../nsedit/includes/misc.inc.php on line 297 #109

Closed jasonhorton closed 8 years ago

jasonhorton commented 8 years ago

Brand new setup on Centos 6, PHP 5.3.3

When I disable logging in config.inc.php, we get past this error, but then are hit with "An error occured while communicating to the server."

richard-underwood commented 8 years ago

I've not tried with PHP 5.3, but there's at least one issue which will prevent 5.4 from working (and therefore also 5.3).

You could try the diff linked below which addresses it, but there may be other issues with 5.3 - you would probably do better installing CentOS 7 which has PHP 5.4 or using a repository like IUS (https://ius.io/) and installing 5.6.

https://github.com/richard-underwood/nsedit/commit/2cb95a695932c3c5e34ac1a7e6a3b8a6be80d848

tuxis-ie commented 8 years ago

Logging issue is fixed in #105 (Which is now merged). The second issue, could it be related to 2cb95a695932c3c5e34ac1a7e6a3b8a6be80d848 ?

tuxis-ie commented 8 years ago

This was probably the issue with #103 as well..

jasonhorton commented 8 years ago

These two fixed the issue so far. Thanks!