search

brantje / nextnote

A full Evernote / OneNote style WYSIWYG note editor for Nextcloud / ownCloud. Join our telegram at: https://t.me/NextNote
GNU Affero General Public License v3.0
163 stars 19 forks source link

Can't save note without a group (PSQL) #32

Closed enoch85 closed 6 years ago

enoch85 commented 7 years ago

Current master branch.

Doctrine\DBAL\Exception\NotNullConstraintViolationException: An exception occurred while executing 'INSERT INTO "oc_ownnote"("name","uid","note","mtime","shared") VALUES(?,?,?,?,?)' with params ["TEST2", "ncadmin", "", 1499644582, false]: SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column "grouping" violates not-null constraint DETAIL: Failing row contains (5, ncadmin, TEST2, null, f, 1499644582, 0, )./var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php - line 128: Doctrine\DBAL\Driver\AbstractPostgreSQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDOException))/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Statement.php - line 177: Doctrine\DBAL\DBALException driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOPgSql\Driver), Object(Doctrine\DBAL\Driver\PDOException), 'INSERT INTO "oc...', Array)/var/www/nextcloud/lib/public/AppFramework/Db/Mapper.php - line 247: Doctrine\DBAL\Statement->execute()/var/www/nextcloud/lib/public/AppFramework/Db/Mapper.php - line 125: OCP\AppFramework\Db\Mapper->execute('INSERT INTO `*P...', Array)/var/www/nextcloud/apps/nextnote/lib/Db/NextNoteMapper.php - line 125: OCP\AppFramework\Db\Mapper->insert(Object(OCA\NextNote\Db\NextNote))/var/www/nextcloud/apps/nextnote/lib/Service/NextNoteService.php - line 89: OCA\NextNote\Db\NextNoteMapper->create(Object(OCA\NextNote\Db\NextNote))/var/www/nextcloud/apps/nextnote/controller/nextnoteapicontroller.php - line 91: OCA\NextNote\Service\NextNoteService->create(Object(OCA\NextNote\Db\NextNote), 'ncadmin')[internal function] OCA\NextNote\Controller\NextNoteApiController->create('TEST2', NULL, Array)/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 160: call_user_func_array(Array, Array)/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 90: OC\AppFramework\Http\Dispatcher->executeController(Object(OCA\NextNote\Controller\NextNoteApiController), 'create')/var/www/nextcloud/lib/private/AppFramework/App.php - line 114: OC\AppFramework\Http\Dispatcher->dispatch(Object(OCA\NextNote\Controller\NextNoteApiController), 'create')/var/www/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php - line 47: OC\AppFramework\App main('OCA\\NextNote\\Co...', 'create', Object(OC\AppFramework\DependencyInjection\DIContainer), Array)[internal function] OC\AppFramework\Routing\RouteActionHandler->__invoke(Array)/var/www/nextcloud/lib/private/Route/Router.php - line 299: call_user_func(Object(OC\AppFramework\Routing\RouteActionHandler), Array)/var/www/nextcloud/lib/base.php - line 1000: OC\Route\Router->match('/apps/nextnote/...')/var/www/nextcloud/index.php - line 40: OC handleRequest(){main}

Saving a note with a group directly works.

alexisrosano89 commented 6 years ago

Same exception for me in MySQL database

ThomasDaheim commented 6 years ago

@alexisrosano89 Do you have the same exception?

Doesn't happen for my with the current master - would need to dig around more. On my end the grouping that is passed down is an empty string but not NULL. Somehow on your end its NULL and hence the exception. Could try a workaround til we know where this comes from...

brantje commented 6 years ago

@enoch85 Is there somewhere a tutorial how to install nextcloud with PSQL?

enoch85 commented 6 years ago

@brantje not afaik. You could use the scripts to set everything up.

enoch85 commented 6 years ago

@brantje Or if you give me your email I can give you the download link for the PostgreSQL VM.

brantje commented 6 years ago

Join us at telegram :smile:

enoch85 commented 6 years ago

@brantje I'm still in the Gitter group, I don't use Telegram and I rather don't add yet another chat-relay. :)

sunjam commented 6 years ago

afaik all communication is happening in Telegram and lots of commits. Project is active, but the Gitter is not.

enoch85 commented 6 years ago

@sunjam I'm in.

sunjam commented 6 years ago

Looks like you will need to install the telegram app in order to view the group.

On Sat, Apr 7, 2018 at 12:54 PM Daniel Hansson notifications@github.com wrote:

@sunjam https://github.com/sunjam Well, your link brings me to a site where it asks me to view the group. The link is: tg://resolve?domain=NextNote and gives me this:

[image: screenshot from 2018-04-07 21 51 43] https://user-images.githubusercontent.com/4511254/38459739-fb7cd8a0-3aad-11e8-8d25-c52cd12906f7.png

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/brantje/nextnote/issues/32#issuecomment-379494963, or mute the thread https://github.com/notifications/unsubscribe-auth/ABtFZqIWjpyjhFm-JMKHWQobPLaHeVQ7ks5tmRlMgaJpZM4OSPAC .

enoch85 commented 6 years ago

Just tested and it works on current master. Thanks @brantje!