miniBB ® miniBB®
miniBB Support Forums
 | Forums | Register | Reply | Search | Statistics | Manual |
Specific miniBB Support Forums / Specific /   

User's IP-Not Found

Author Prince
Registered
#1 | Posted: 30 Nov 2011 19:45 
Hello,

Today I just checked users IP but it says: IP Not Found! (before wasn't like this) I've no idea how it happened!

No IPs Found

It's same for all users even admin!

Anyone knows and have any idea how to fix that?

Regards,

Author Paul
Lead Developer
#2 | Posted: 30 Nov 2011 19:51 
This needs more deep debugging. Most possible, you may try to REPAIR posts table.

If you investigate bb_func_viewip.php, you could see this error comes if mySQL request is not completed. And there is a DISTINCT statement... the reason may come from there.

Author Prince
Registered
#3 | Posted: 1 Dec 2011 00:50 
Same again.. No IPs Found.. in Localhost it works.. kinda strange!
Maybe I would reinstall it again!

Author Paul
Lead Developer
#4 | Posted: 1 Dec 2011 10:33 
As I wrote, one of the tables may be corrupted. Did you try to repair it?
Most possibly, it's about minibbtable_posts...

Author Prince
Registered
#5 | Posted: 1 Dec 2011 21:49 
Paul:
As I wrote, one of the tables may be corrupted. Did you try to repair it?
Most possibly, it's about minibbtable_posts...

Yes I did repair it but same again...!

Author Paul
Lead Developer
#6 | Posted: 2 Dec 2011 13:26 | Edited by: Paul 
Then you need to debug mySQL request. IP function uses setup_mysql.php - db_simpleSelect.
Under this function, you need to de-comment:

echo "<!-- ".$sql." -->\n";

then go to the IPs page and view it's source. You will see the list of commands, and there will be one command having DISTINCT statement. Like DISTINCT poster_name, poster_id... You need to check out this command in the regular mySQL command tool to execute it.

What kind of warning mySQL will give? You will see it's response and could get the idea what's wrong.

Author Prince
Registered
#7 | Posted: 2 Dec 2011 14:21 
Paul:
What kind of warning mySQL will give? You will see it's response and could get the idea what's wrong.

I got this error:

#1 - Can't create/write to file '/dev/shm/#sql_10a5_0.MYI' (Errcode: 28)

I should check with the host I think :)

Thanks :)

Author Paul
Lead Developer
#8 | Posted: 2 Dec 2011 15:20 | Edited by: Paul 
MYI is a mysql's table physical file.
Ask the hoster what's corrupted... they need to fix this file.

Author Prince
Registered
#9 | Posted: 2 Dec 2011 15:30 
Paul:
Ask the hoster what's corrupted... they need to fix this file.

Thanks, They fixed it.

It was due to server tempfs partition having exhausted its limit of inodes, so they increased the limit of inodes!

It's working now. :)

Author Paul
Lead Developer
#10 | Posted: 2 Dec 2011 19:38 
Prince:
It was due to server tempfs partition having exhausted its limit of inodes, so they increased the limit of inodes!

Now you see, what it means to know the software to debug it properly ;)

Author johnscarbrough
Registered
#11 | Posted: 8 Jan 2012 20:45 
I got this completely working

Specific miniBB Support Forums / Specific / User's IP-Not Found Top

Your Reply Click this icon to move up to the quoted message

 Short link for this topic:

 ?
Only registered users are allowed to post here. Please, enter your username/password details upon posting a message, or register first.


Before posting, make sure your message is compliant with our forum posting rules. If not, it may be locked or deleted with no explanation.
 
miniBB Support Forums Powered by Forum Software miniBB ® Features  Requirements  Demo  Download  Showcase  Gallery of Arts
Compiler  Premium Extensions  Premium Support  License  Contacts
Proceed with the Captcha add-on: protect your miniBB-forums from the automated spam and flood.
Captcha Addon for miniBB