osCmax v2.5 User Manual
Results 1 to 9 of 9

HELP.........

This is a discussion on HELP......... within the osCommerce 2.2 Modification Help forums, part of the osCommerce 2.2 Forums category; I had my store up and running with no problems at all. Its been a few weeks now. Today I ...

      
  1. #1
    New Member
    Join Date
    Mar 2003
    Posts
    20
    Rep Power
    0


    Default HELP.........

    I had my store up and running with no problems at all. Its been a few weeks now.

    Today I went to check the store and got this error..

    1016 - Can't open file: 'whos_online.MYI'. (errno: 145)

    delete from whos_online where time_last_click < '1053120001'

    [TEP STOP]


    Can anyone help, please......

    I have done any thing to the files or even uploaded any new stuff to the store. I was checking the who is online last night and it was working find.... .

    Please please help.

    Stressed out Angie

  2. #2
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,907
    Rep Power
    568


    Default

    Angie,

    This is related to mysql 4. All you have to do is repair the table 'whos_online' using phpmyadmin. Then, to prevent this from happening again, change the table type to INNODB, again using phpmyadmin.

    The fix takes about 2 minutes, but will keep it from happening again.
    Michael Sasek
    osCMax Developer


    osCmax Installation Service
    - Have our professionals install osCmax on your server - same day service!
    osCmax 2.5 User Manual - the must have beginners guide to osCmax v2.5

    Stay Up To Date with everything osCMax:
    Free osCmax Newsletters - Security notices, New Releases, osCMax News
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  3. #3
    New Member
    Join Date
    Mar 2003
    Posts
    20
    Rep Power
    0


    Default

    Hi,

    Thanks for the fast reply! I really appreciate it.

    What do I need to do to the table? I'm not very familiar with phpmyadmin...

    I will go and have alook into it now... any further help greatly appreciated.

  4. #4
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,907
    Rep Power
    568


    Default

    on the main page of phpmyadmin that lists all the tables, scroll down and find the whos_online table and click the checkbox next to it.

    Then at the bottom of that listing of tables, there is a dropdown list box, you want to select 'repair'

    This will fix the error.

    Then, again from the main table listing, you want to scroll down and find the whos_online table again. This time click the 'browse' link to the right of the table. Then on the next page, select the tab at the top that says 'Options"

    Then, on the options page, find the dropdown box for "table type" and select INNO DB and click 'GO'

    Thats it...
    Michael Sasek
    osCMax Developer


    osCmax Installation Service
    - Have our professionals install osCmax on your server - same day service!
    osCmax 2.5 User Manual - the must have beginners guide to osCmax v2.5

    Stay Up To Date with everything osCMax:
    Free osCmax Newsletters - Security notices, New Releases, osCMax News
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  5. #5
    New Member
    Join Date
    Mar 2003
    Posts
    20
    Rep Power
    0


    Default

    Hi Msasek,

    Thank you so much for your help... its greatly greatly appreciated!

    Any ideas why this happened. Could it have been something that I did or just a glitch. I know I was looking at the who is page lastnight and had over 20 people in the shop with a few of them with orders. This morning no orders in my inbox... thats why I went to check the shop and found the error...

    Again thank you

    Angie

  6. #6
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,907
    Rep Power
    568


    Default

    Angie,

    It is actually a problem with MySQL 4. It doesn't have anything to do with anything that you did. It is a strange problem, and doesnt happen to all databases. You were just unlucky. Making the changes should eradicate it
    Michael Sasek
    osCMax Developer


    osCmax Installation Service
    - Have our professionals install osCmax on your server - same day service!
    osCmax 2.5 User Manual - the must have beginners guide to osCmax v2.5

    Stay Up To Date with everything osCMax:
    Free osCmax Newsletters - Security notices, New Releases, osCMax News
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  7. #7
    Lurker
    Join Date
    Oct 2004
    Posts
    1
    Rep Power
    0


    Default

    Dear msasek


    Thanks for your advice !
    It helped me too!

    But when I use PHPmyadmin, I don't have this option of INNODB.
    What I have is the following:

    heap
    berkeley DB
    ISAM
    Merge

    Kindly Advice which one should I choose pls ?

    Thanks in advance

    Bala

  8. #8
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,907
    Rep Power
    568


    Default

    If you dont have the option for INNODB, your host has disabled this table type. You must use ISAM.
    Michael Sasek
    osCMax Developer


    osCmax Installation Service
    - Have our professionals install osCmax on your server - same day service!
    osCmax 2.5 User Manual - the must have beginners guide to osCmax v2.5

    Stay Up To Date with everything osCMax:
    Free osCmax Newsletters - Security notices, New Releases, osCMax News
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  9. #9
    Lurker
    Join Date
    May 2005
    Location
    taupo
    Posts
    4
    Rep Power
    0


    Default

    my format for all that is MyISAM, should i change it??????????????
    how???????????- above doesnt work as i cant find options

    peter w

    ps: u helped me whth this error thanks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •