cdevroe/unmark

A Database Error Occurred Error Number: 1146

guillaumesoucy94 opened this issue · 0 comments

Hello,

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

At first it threw me a “1064 Error”:

Screenshot at 2022-03-20 19-18-59

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:

Screenshot at 2022-03-20 19-33-05

Thank-you,

Guillaume