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”:
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