How to fix my sql error

[mohammedali]

Having an error installing the points system in mybb plugin
can anyone help??

I downloaded and uploaded files and i get this error in the log section and others as well...

Log Error:
SQL Error:
1146 - Table 'mohammed_mybb1.mybb_newpoints_log' doesn't exist
Query:
SELECT COUNT(lid) as log_entries FROM mybb_newpoints_log

Settings Error:
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1146 - Table 'mohammed_mybb1.mybb_newpoints_settings' doesn't exist
Query:
SELECT COUNT(sid) as settings FROM mybb_newpoints_settings WHERE plugin='main'

Forum Rules:
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1146 - Table 'mohammed_mybb1.mybb_newpoints_settings' doesn't exist
Query:
SELECT COUNT(sid) as settings FROM mybb_newpoints_settings WHERE plugin='main'

Group Rules:
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1146 - Table 'mohammed_mybb1.mybb_newpoints_grouprules' doesn't exist
Query:
SELECT * FROM mybb_newpoints_grouprules ORDER BY rid ASC

Any help please?
Thanks!

Also got this error on plugins page. The attachment.

 

[sharma]

Did you install the plugin properly - the errors are related to a series of tables that do not exist. Make sure you are using the correct prefix and make sure the plugin created the new tables properly.

 

[mohammedali]

@sharma,
How can i verify i did everything correctly?
Because i uploaded the files twice to make sure, and got the same error...

 

[randomlinux]

if you aren't sure how to check that through the command line, you can usually do it though phpmyadmin. You might want to check to make sure that the mybb_newpoints_log table is in the database and that it actually has the right mybb_ prefix.

The screenshot you gave also shows that there's a file named global.php that isn't there. Did you make sure it's there too?