Author |
Message |
emmaphp
Worker
![Worker Worker](modules/Forums/images/ranks/3stars.gif)
![](modules/Forums/images/avatars/gallery/blank.gif)
Joined: Aug 22, 2006
Posts: 192
|
Posted:
Sun Jun 10, 2007 9:04 am |
|
Im using Raven's RavenNuke(tm) v2.02.02 Distro.
I know for a fact that when this was first installed some months ago, the 'User Info Block' worked perfectly.
However I have just noticed that it now permanently displayes as Zero ('0'), the number of visitors and members online, even when there are users browsing my site.
I have not (knowingly) made any changes to anything that would affect this.
Can anyone help with this please? |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
Susann
Moderator
![](modules/Forums/images/avatars/4e3210db4efb891870d79.gif)
Joined: Dec 19, 2004
Posts: 3191
Location: Germany:Moderator German NukeSentinel Support
|
Posted:
Sun Jun 10, 2007 10:49 am |
|
Run optimize and repair in your database maybe that helps.
Also 2.02.02 isn´t the newest version I would upgrade. |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
emmaphp
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Sun Jun 10, 2007 11:21 am |
|
Thanks Susan, but I am not sure how to 'Run optimize and repair' in my database.
I am also interested to know why this function would have stopped working if I have made no changes to my database? |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
Susann
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Sun Jun 10, 2007 12:31 pm |
|
For example using phpMyAdmin:Check all tables of your database use the drop down box at the bottom and choose repair there is also the function optimize and some others too. You can optimize it from your administration too.
If that doesn´t help set in your config.php display_errors = TRUE;
and check for errors.
Well, sometimes it happens without any changes. My nuke_sessions table got suddenly corrupt in version 6.5 with the result that nobody could log in anymore.
Btw:I often optimize my db tables. |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
emmaphp
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Sun Jun 10, 2007 12:44 pm |
|
Susan, when you advise to Optimize tables, are you refering to the Optimize facility on PHP-Nuke, (which is accessible from the Admin section), or is this something different and on the PHPMyAdmin control panel? |
Last edited by emmaphp on Sun Jun 10, 2007 12:48 pm; edited 2 times in total |
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
Susann
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Sun Jun 10, 2007 12:46 pm |
|
The optimize function is in your nuke administration.
But for other functions you need to use PHPMyAdmin.
NukeSentinel has also such a feature but only for NS tables. |
Last edited by Susann on Sun Jun 10, 2007 12:51 pm; edited 1 time in total |
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
emmaphp
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Sun Jun 10, 2007 12:48 pm |
|
I did just try setting my website config.php file to 'display_errors = TRUE', however nothing was displayed at the top of my website home page (and that is usually where such errors are displayed). Was I looking in the right place? |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
Susann
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Sun Jun 10, 2007 2:07 pm |
|
Are you logged in as admin ? However, would there be a real blocks problem you would also get such a message:There is a problem right now with this block.
Did you already run optimize and repaire the table ?
I would also clear cookie, cache and upload the same block again of course I would also check an other User Info block if there is exactly the same issue. |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
emmaphp
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Mon Jun 11, 2007 4:07 pm |
|
Hi Susan...I am logged in as admin.
The code in the block has never been changed since it was working an there is no errors showing that there is a problem with the block or something like that.
I also notice that the standard 'Who is Online' block is also not showing when anyone is on the website, so this suggests to me that there must be an error somewhere other than in any blocks.
I do not understand why this would just stop working wen I have not made any changes to my database. |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
Gremmie
Former Moderator in Good Standing
![](modules/Forums/images/avatars/0cd76dcf45da5de2cf864.jpg)
Joined: Apr 06, 2006
Posts: 2415
Location: Iowa, USA
|
Posted:
Mon Jun 11, 2007 4:53 pm |
|
Things can change behind your back....files can get corrupt, etc.
Use phpMyAdmin to check and possibly repair your tables. Check the sessions table for sure.
I would also check your error logs. Ask your host where they are if you don't know what I am talking about. |
_________________ Only registered users can see links on this board! Get registered or login! - An Event Calendar for PHP-Nuke
Only registered users can see links on this board! Get registered or login! - A Google Maps Nuke Module |
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
emmaphp
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Mon Jun 11, 2007 5:37 pm |
|
Gremmie wrote: | Use phpMyAdmin to check and possibly repair your tables. Check the sessions table for sure. |
Gremmie thanks for your input here, but how do i do what you are suggesting. I mean where should I look and begin in MyPHPAdmin and what do I do to check things and the session tables. I dont even know what I am looking for and what it should be like, if indeed something has been changed etc. |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
Gremmie
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Mon Jun 11, 2007 7:25 pm |
|
Well that kind of thing varies on what tools your host has given you (it is very host dependent). You can ask your host if you have access to phpMyAdmin, and ask how to get at your error logs too.
If you can get into phpMyAdmin you will typically navigate to your Nuke database, then find your *_sessions table. You can then run a repair or optimize.
If you are totally lost you may want to post in the for hire forum and maybe someone can assist.
Good luck!!! |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
emmaphp
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Tue Jun 12, 2007 2:08 pm |
|
Gremmie, see all I ever need is a little guidance and as an intuitive person i usually am able to deal with matters such as this.
Thank you so much for your advise. Small though it may seem to you, I think it has helped me tremendously.
I have indeed navigated to the sessions table in MyPHPAdmin and sure enough it reads the following:
Error
SQL query:
SHOW KEYS FROM `nuke_session` ;
MySQL said:
#1016 - Can't open file: 'nuke_session.MYI' (errno: 145)
So moving on, because I have saved all the back up copeis of my database that I have ever made, (going back 12 months, since this website was originally installed), I decided to do the following:
1. I backup up todays database, (the faulty one).
2. I then updated the website with the 1st ever back up I had made and then checked the functionality of the 'User Info Block' I am having problems with and it began to work again, (with there no longer being any error message displayed in PHPMyAdmin).
3. I restored the database with the back up version I had made today and the error returned, along with the 'User Info Block' giving problems again.
4. So what I then did, was to reload the back up copy of my database, (which eliminated the error when I used it previously)
5. I copied the SQL code from the 'Sessions Table' in the 'old backup' of the database.
6. I then subsequently reinstalled the back up copy of the database from today, (with the fault).
7. Next I 'Dropped' the 'Sessions Table' in the database I was now currently running, (i.e. from the backup I had made earlier today, (with the fault).
8. Then I took the 'Session Table' code that I had copied from the version of the 'old database' that worked and I ran the SQL code and this all solved my problem! |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
Susann
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Tue Jun 12, 2007 3:34 pm |
|
Congratulation !
Don´t forget to optimize your database tables from time to time. ![Smile](modules/Forums/images/smiles/icon_smile.gif) |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
emmaphp
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Tue Jun 12, 2007 4:49 pm |
|
Sussan, from where and how do I optimise the tables?
The only 'Optimize' function I am aware of is the one in the Nuke Admin section and I already click this from time to time. |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
Susann
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Tue Jun 12, 2007 5:00 pm |
|
emmaphp I m sure I have already talked about how to do this with phpMyAdmin (see above). You can choose this for all tables or each of them. However, from the administration its the same. I just prefer to go directly to the database because its like my second home.
And you can find some tutorials like Nuke HowTo here on Ravens site where some of this is also explained I believe. Just search for this. |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
Gremmie
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Tue Jun 12, 2007 6:16 pm |
|
Actually I believe the MySQL engine will automatically run the optimize function on tables from time to time behind your back when it thinks it needs it. You would only run it if you manually deleted a bunch of rows in a table that isn't inserted into often.
From the manual:
Quote: |
OPTIMIZE TABLE should be used if you have deleted a large part of a table or if you have made many changes to a table with variable-length rows (tables that have VARCHAR, VARBINARY, BLOB, or TEXT columns). Deleted rows are maintained in a linked list and subsequent INSERT operations reuse old row positions. You can use OPTIMIZE TABLE to reclaim the unused space and to defragment the data file.
...
In most setups, you need not run OPTIMIZE TABLE at all. Even if you do a lot of updates to variable-length rows, it is not likely that you need to do this more than once a week or month and only on certain tables.
|
The sessions table is a table that gets inserted to a lot, so it will have no problem reclaiming space quickly. At least that is my take on it...
Great job emmaphp! |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
warren-the-ape
Worker
![Worker Worker](modules/Forums/images/ranks/3stars.gif)
![](modules/Forums/images/avatars/5064660247507d6711183.jpg)
Joined: Nov 19, 2007
Posts: 196
Location: Netherlands
|
Posted:
Sat Dec 01, 2007 2:36 pm |
|
Little kick of this topic.
After I discovered this forum (and the one from Montego) im trying to fix things like a mad man
I had this problem for 2-3 weeks now. It happened after the server suddenly went down for a couple of minutes and wasnt able to fix it ever since
I now finally discoverd how to use phpmyadmin, and repaired the Nuke_session table, it works again like a charm
Soo... thnx Susann for pointing out that table ![:clap:](modules/Forums/images/smiles/icon_welldone.gif) |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
Susann
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Sat Dec 01, 2007 5:48 pm |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
express
Client
![](modules/Forums/images/avatars/d84324e5473c6e34afc9a.jpg)
Joined: Jan 03, 2007
Posts: 94
|
Posted:
Sun Dec 02, 2007 9:45 pm |
|
I'm absorbing all of this info thru osmosis. Good stuff...thanks. ![worship](modules/Forums/images/smiles/icon_worship.gif) |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
Raven
Site Admin/Owner
![](modules/Forums/images/avatars/45030c033f18773153cd2.gif)
Joined: Aug 27, 2002
Posts: 17088
|
Posted:
Tue Dec 04, 2007 12:14 am |
|
emmaphp wrote: |
Error
SQL query:
SHOW KEYS FROM `nuke_session` ;
MySQL said:
#1016 - Can't open file: 'nuke_session.MYI' (errno: 145)
|
Whenever you see this error, the first thing you need to try is to do a Repair Table. Log into phpMyAdmin and select your Database. Then put a check mark beside the nuke_session table (in this case). Then select Repair Table from the selection box at the bottom or the icon at the right. That usually fixes it. |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
Raven
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Tue Dec 04, 2007 12:16 am |
|
When knowing when to optimize or not, use the option in phpMyAdmin to Check Tables Having Overhead. Those are the tables that need optimizing. Then do a Select All and run Analyze Table on all tables to make MySQL "smarter". |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
warren-the-ape
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Tue Dec 04, 2007 4:22 am |
|
Raven wrote: |
Whenever you see this error, the first thing you need to try is to do a Repair Table. |
Yep exactly what I did
Dont really understand why emmaphp went to all that trouble, copying and replacing db's.
About optimizing, Susann already mentioned that there is no difference between phpmyadmin and the optimize function in phpnuke, so it wouldnt make a difference right?
I think i run the optimize function, every month or every 2 weeks, it feels a bit like defragmentating ![Wink](modules/Forums/images/smiles/icon_wink.gif) |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
Raven
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Tue Dec 04, 2007 8:13 am |
|
Optimize in both cases is calling the same MySQL function so it makes no difference. It actually is defragmentation . This is right from the Manual.
==============================================
Only registered users can see links on this board! Get registered or login!
OPTIMIZE TABLE should be used if you have deleted a large part of a table or if you have made many changes to a table with variable-length rows (tables that have VARCHAR, VARBINARY, BLOB, or TEXT columns).
Deleted rows are maintained in a linked list and subsequent INSERT operations reuse old row positions.
You can use OPTIMIZE TABLE to reclaim the unused space and to defragment the data file.
In most setups, you need not run OPTIMIZE TABLE at all. Even if you do a lot of updates to variable-length rows, it is not likely that you need to do this more than once a week or month and only on certain tables.
============================================== |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
zbv2net
New Member
![New Member New Member](modules/Forums/images/ranks/1star.gif)
![](modules/Forums/images/avatars/3ea2b94445e86247dbbe4.gif)
Joined: Feb 26, 2007
Posts: 13
|
Posted:
Sun Jan 06, 2008 9:27 pm |
|
emmaphp wrote: | Gremmie, see all I ever need is a little guidance and as an intuitive person i usually am able to deal with matters such as this.
Thank you so much for your advise. Small though it may seem to you, I think it has helped me tremendously.
I have indeed navigated to the sessions table in MyPHPAdmin and sure enough it reads the following:
Error
SQL query:
SHOW KEYS FROM `nuke_session` ;
MySQL said:
#1016 - Can't open file: 'nuke_session.MYI' (errno: 145)
So moving on, because I have saved all the back up copeis of my database that I have ever made, (going back 12 months, since this website was originally installed), I decided to do the following:
1. I backup up todays database, (the faulty one).
2. I then updated the website with the 1st ever back up I had made and then checked the functionality of the 'User Info Block' I am having problems with and it began to work again, (with there no longer being any error message displayed in PHPMyAdmin).
3. I restored the database with the back up version I had made today and the error returned, along with the 'User Info Block' giving problems again.
4. So what I then did, was to reload the back up copy of my database, (which eliminated the error when I used it previously)
5. I copied the SQL code from the 'Sessions Table' in the 'old backup' of the database.
6. I then subsequently reinstalled the back up copy of the database from today, (with the fault).
7. Next I 'Dropped' the 'Sessions Table' in the database I was now currently running, (i.e. from the backup I had made earlier today, (with the fault).
8. Then I took the 'Session Table' code that I had copied from the version of the 'old database' that worked and I ran the SQL code and this all solved my problem! |
I have the same problem on my site but i dont see no error in my phpmyadmin
Code:Table Op Msg_type Msg_text
zbavitu_rvn18september.nuke_session check status OK
|
Can you asist me how to fix this because i dont have a backup
and it have stoped working as u said after some time after no modification is made |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
|