miniBB ® 

miniBB

®
Support Forums
  
 | Start | 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: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
Partaker
#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
Partaker
#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 
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: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 
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: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
Partaker
#11 | Posted: 8 Jan 2012 20:45 
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


  ?
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
Get the Captcha add-on: protect your miniBB-forums from the automated spam and flood.


  ⇑