miniBB ®

miniBB

®
Support Forums
  
 · Start · Sign in · Register · Search · Statistics · File Bank · Manual ·
Specific miniBB Support Forums / Specific /  
 

User's IP-Not Found

 
Author Prince
Partaker
#1 · Posted: 30 Nov 2011 19:45Reply Quote
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 Lead Developer
#2 · Posted: 30 Nov 2011 19:51Reply Quote
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
Partaker
#3 · Posted: 1 Dec 2011 00:50Reply Quote
Same again.. No IPs Found.. in Localhost it works.. kinda strange!
Maybe I would reinstall it again!

Author Paul
Lead Lead Developer
#4 · Posted: 1 Dec 2011 10:33Reply Quote
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
Partaker
#5 · Posted: 1 Dec 2011 21:49Reply Quote
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 Lead Developer
#6 · Posted: 2 Dec 2011 13:26Reply Quote
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
Partaker
#7 · Posted: 2 Dec 2011 14:21Reply Quote
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 Lead Developer
#8 · Posted: 2 Dec 2011 15:20Reply Quote
MYI is a mysql's table physical file.
Ask the hoster what's corrupted... they need to fix this file.

Author Prince
Partaker
#9 · Posted: 2 Dec 2011 15:30Reply Quote
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 Lead Developer
#10 · Posted: 2 Dec 2011 19:38Reply Quote
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
Partaker
#11 · Posted: 8 Jan 2012 20:45Reply Quote
I got this completely working

Specific miniBB Support Forums / Specific /
 User's IP-Not Found
 Share Topic's Link

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

BB code for the Bold StyleBB code for the Italic StyleBB Code for the PictureBB code for the URLUpload a File

  ?
Post as a Guest, leaving the Password field blank. You could also enter a Guest name, if it's not taken by a member yet. Sign-in and post at once, or just sign-in, bypassing the message's text.


Before posting, make sure your message is compliant with forum rules; otherwise it could be locked or removed with no explanation.

 

 
miniBB Support Forums Powered by Forum Software miniBB ® Home  Features  Requirements  Demo  Download  Showcase  Gallery of Arts
Compiler  Premium Extensions  Premium Support  License  Contact Us
Proceed with the File and Picture Attachments add-on: extend your miniBB-forums, attaching images and files.