redirect to 404.php

[phploaded]

Everything worked smooth until login. When i am trying to login with admin account i am always being redirected to 404.php. It says:

You're already logged in!
Oops, looks like our database encountered an error.
We couldn't load your account. We'll try to get this fixed right away!

Can you pinpoint what is wrong......?

[alexweissman]

Do you have PHP 5.4+, and PDO enabled? Looks like you're probably encountering an error in load_current_user.php. Could you please check your php error log and tell me what it says?

[n30nh4ck3r]

i encountered an error during installation and the error i encountered goes like this 'call to a member function execute() on a non-object in C:\wamp\ufrost\install\install.php on line 291...php version is 5.4.16 and pdo for both msql and sqli are enabled...

[alexweissman]

Oops, yeah there was a semicolon where there should have been a comma. Try now please!

[n30nh4ck3r]

Wow.Thanks...worked out fine...but there is still a little problem...you're logged in already-Oops,looks like our database encountered an error

[alexweissman]

Hmm, that's the same error as phploaded got. What does your PHP error log say?

[n30nh4ck3r]

php fatal error:call to a member function execute() on a non-object in C:.../load_current_user.php on line 73:referer: http://localhost/ufrost/dashboard_admin.php

Php Stack trace:, referer:dashboard_admin.php

PHP 1. {main}() load_current_user.php:0,same referer(dashboard_admin)

[alexweissman]

Ok, so it's clearly some sort of database error, when load_current_user.php tries to query the uc_users table. What actions lead to that error? Right when you try to log in? Can you look at your database and see if there is anything in the uc_users table?

[n30nh4ck3r]

Its there,an admin user plus 2 users and their details

[alexweissman]

Ok, I've modified load_current_users.php and db_settings.php to provide more specific error messages for SQL. Can you please download those new files, try to log in again, and see if a more specific error appears in your php error log?

[n30nh4ck3r]

ooops,looks like our database encountered an error...

[alexweissman]

Hmm, there are currently only two files where that error could be generated: load_current_user.php and admin_load_permissions.php. But admin_load_permissions.php is only accessed when you try to view the Users section. So, it must be a problem happening in load_current_user.php. There's no more specific error message in the php error log? Did you update both load_current_user.php AND models/db_settings.php?

models/db_settings.php needs to be updated because I added a line telling PDO to throw exceptions for database errors, which should then be logged in the php error log. Please check the timestamp of the error log to make sure that it's logging the most recent error.

[n30nh4ck3r]

SQLSTATE[42S02]: base table or view not found : 1146 Table 'userfrosting.uc_users' doesnt exist,referer:http://localhost/ufrost/dashboard_admin.php

[n30nh4ck3r]

i got the reason i think...now working perfectly...i changed the table prefix back to the default...thanks a lot for your time and i love this project...

[alexweissman]

Sweet! You can always change the table prefix on line 37 of models/db_settings.php. Glad you like the project and good luck!

[alexweissman]

I'm actually going to reopen this, because all DB queries should prepend the table prefix...load_current_users doesn't do that.

[alexweissman]

Fixed as of v0.1.5.