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

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'idbjobportal.notice' doesn't exist (SQL: select * from notice where status = 1) #5

Open
arvindpundir opened this issue Mar 3, 2019 · 1 comment

Comments

@arvindpundir
Copy link

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'idbjobportal.notice' doesn't exist (SQL: select * from notice where status = 1)

@DeepCode30303
Copy link

his error message is indicating that the database is unable to find a table named "notice" in the "idbjobportal" database. It is possible that the table does not exist, or that the spelling or capitalization of the table name is incorrect.

Here are a few things you can try to resolve this issue:

Verify that the table name is spelled and capitalized correctly in your SQL statement.
Check the database to see if the table actually exists. If it does not, you may need to create it before you can query it.
If the table exists but you are still getting this error, it could be due to a lack of privileges. Make sure that you have the necessary permissions to access the table.
It is also possible that the table has been deleted or renamed. If this is the case, you will need to update your SQL statement to reflect the correct table name.
I hope this helps!

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

2 participants