phpBB : Critical Error

Could not obtain lastvisit data from user table

DEBUG MODE

SQL Error : 1146 Table 'syren_nuke2.syren__users' doesn't exist

SELECT * FROM syren__users WHERE user_id = '1'

Line : 73
File : /home/syren/public_html/rpg/includes/sessions.php

I get this message when trying to access the Memberlist and the Forums. Also, now I can't log in at all because it keeps saying that my login/password is incorrect and it's not. User journals have been lost as well as 10 user accounts. They're there still, just not showing up.


When in myPHPAdmin, I was looking at the databases. I looked at nuke_users. Not sure if this is suppose to be there or not, but the user listed for user ID 1 is Anonymous. However, I think that my information is suppose to be there instead.

there is still some bad info in your config.php, as it looks for a table named 'syren__users' and you explicit state that the table is called 'nuke_users'

Make sure the info in the file is correct!

__________________
Yannick R. aka Mighty_Y
http://support.code-area51.com
http://www.code-area51.com

Search before asking makes my life easier!

Alright, here is what I have. I'm betting its rather simple to figure out but for some ungodly reason I can't. w:

$dbhost = "localhost";
$dbuname = "syren";
$dbpass = "edited for protection";
$dbname = "syren_nuke2";
$prefix = "nuke";
$user_prefix = "syren_";
$dbtype = "MySQL";
$sitekey = "edited for protection";
$gfx_chk = 7;
$subscription_url = "";

change

Code:

$user_prefix = "syren_";

to this

Code:

$user_prefix = "nuke";

That should do it

__________________
Yannick R. aka Mighty_Y
http://support.code-area51.com
http://www.code-area51.com

Search before asking makes my life easier!

Thanks. That fixed most of the troubles. I've got the forums, journal and members list back. However, when I try to log in to either the admin area or the users area, the security code isn't showing up. In its place is a box with [Security Code] inside of it but the code itself isn't there. Just the words 'Security Code'

want to keep the security code?? or doesn't it matter??
if it is the last, turn it off in your config.php
change

Code:

$gfx_chk = 7;

to

Code:

$gfx_chk = 0;

__________________
Yannick R. aka Mighty_Y
http://support.code-area51.com
http://www.code-area51.com

Search before asking makes my life easier!

Peachy! I don't think our website really has a need for the security code so that's been changed to 0 and everything's working again. With the exception of my fiance being able to access the admin area.

Any safe suggestions on rectifying that?

And -

What about the user in user ID 1 set as Anonymous? Should I remove that?

don't remove the user, I'll check out the Begone message

__________________
Yannick R. aka Mighty_Y
http://support.code-area51.com
http://www.code-area51.com

Search before asking makes my life easier!

can you please tell me what the Admin username of your fiance is??
FB misses some structure in his coding, I have some reasons to believe that his username is using a format that passes the creation but doesn't pass the login!
That's do to this code in auth.php

Code:

if (ereg("[^a-zA-Z0-9_-]",trim($aid))) { die("Begone"); }

you can commentt his, but that creates security risks so i just suggest to create a different admin name for him :?

__________________
Yannick R. aka Mighty_Y
http://support.code-area51.com
http://www.code-area51.com

Search before asking makes my life easier!

Oh yes! There was a space in his user nick name. I removed the space and it's working perfectly now!

Thank you SO MUCH for all the help, guys It's very appreciated.

Do I still want to keep that Anonymous as the user ID 1?