A Database Error Occurred Error Number: 1146

[guillaumesoucy94]

Hello,

I’ve encounter Database errors when trying to install Umark.

At first it threw me a “1064 Error”:

I refresh the page and then I was able to register, I’d enter my email and a password to use with the app and when I’d submit it, it threw:

A Database Error Occurred

Error Number: 1146

Table 'database1.users_to_marks' doesn't exist

SELECT users_to_marks.users_to_mark_id AS mark_id, users_to_marks.mark_title as mark_title, users_to_marks.notes, users_to_marks.active, users_to_marks.created_on, users_to_marks.archived_on, marks.title, marks.url, marks.embed, GROUP_CONCAT(tags.tag_id SEPARATOR '~~') AS tag_ids, GROUP_CONCAT(tags.name SEPARATOR '~~') AS tag_names, GROUP_CONCAT(tags.slug SEPARATOR '~*~') AS tag_slugs, labels.label_id, labels.name AS label_name FROM users_to_marks INNER JOIN marks ON users_to_marks.mark_id = marks.mark_id LEFT JOIN user_marks_to_tags ON users_to_marks.users_to_mark_id = user_marks_to_tags.users_to_mark_id LEFT JOIN labels ON users_to_marks.label_id = labels.label_id LEFT JOIN tags ON user_marks_to_tags.tag_id = tags.tag_id WHERE users_to_marks.user_id='1' AND users_to_marks.active = '1' AND users_to_marks.archived_on IS NULL GROUP BY users_to_marks.users_to_mark_id ORDER BY users_to_marks.created_on DESC LIMIT 0,30

Filename: core/Plain_Model.php

Line Number: 82

The database.php file is filled with the database information. Do I additionally need to create the table “users_to_marks”? If yes how to?

These are all the tables of the database:

Thank-you,

Guillaume

[llorenzin]

Hi! I just installed Unmark and am stuck at the same Error 1146. Can I create that table manually? Is there any way to move forward from here? Running on Synology NAS using their Docker Container Manager, no errors or problems with the install up to this point.

[cdevroe]

@guillaumesoucy94 @llorenzin What version of mySQL are you using?

[llorenzin]

Whatever version came with the container - looks like it's: root@synologynas:~# docker exec -it unmark_mysql sh sh-5.1# mysql -V mysql Ver 8.0.44 for Linux on x86_64 (MySQL Community Server - GPL)