Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

A Database Error Occurred Error Number: 1146 #283

Open
guillaumesoucy94 opened this issue Mar 20, 2022 · 0 comments
Open

A Database Error Occurred Error Number: 1146 #283

guillaumesoucy94 opened this issue Mar 20, 2022 · 0 comments

Comments

@guillaumesoucy94
Copy link

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant