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

currupt database

This is a discussion on currupt database within the osCommerce 2.2 Modification Help forums, part of the osCommerce 2.2 Forums category; I have an error with my whos_online table. I tried to repair it and deleted it by accident. How do ...

      
  1. #1
    New Member
    Join Date
    Dec 2003
    Posts
    15
    Rep Power
    0


    Default currupt database

    I have an error with my whos_online table. I tried to repair it and deleted it by accident. How do I create a new one?

  2. #2
    osCMax Developer

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


    Default Re: currupt database

    Get the sql from the install directory in the oscommerce download package. Edit the sql file in a text editor, find the whos_online table sql and paste it into the sql box of phpmyadmin or whatever mysql front end you are using...
    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
    Dec 2003
    Posts
    15
    Rep Power
    0


    Default Re: currupt database

    Thanks but someone on another forum help me and I did the following...........

    whos_online table deleted. Need help creating new one. - osCommerce Community Support Forums


    Go to phpMyAdmin sql box and paste the followin in then click go.

    You can fine all the sql in the install dir of osc zip "oscommerce.sql"



    DROP TABLE IF EXISTS whos_online;
    CREATE TABLE whos_online (
    customer_id int,
    full_name varchar(64) NOT NULL,
    session_id varchar(12 NOT NULL,
    ip_address varchar(15) NOT NULL,
    time_entry varchar(14) NOT NULL,
    time_last_click varchar(14) NOT NULL,
    last_page_url varchar(64) NOT NULL
    );
    Last edited by bagged89s10; 02-27-2007 at 03:46 PM.

  4. #4
    osCMax Developer

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


    Default Re: currupt database

    That is exactly what I told you to do... Glad you got it working.
    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

Similar Threads

  1. HELP MY DATABASE IS GONE!!
    By markymrk22 in forum osCommerce 2.2 Discussion
    Replies: 4
    Last Post: 07-28-2005, 10:39 AM
  2. Errors in database
    By auntie22 in forum osCmax v1.7 Discussion
    Replies: 0
    Last Post: 07-24-2005, 05:59 PM
  3. Customer downloads product but file is currupt
    By dno in forum osCommerce 2.2 Installation Help
    Replies: 3
    Last Post: 08-08-2004, 02:09 PM
  4. Database
    By marbor in forum osCommerce 2.2 Installation Help
    Replies: 1
    Last Post: 01-26-2004, 06:33 AM
  5. What name should database be?
    By Anonymous in forum osCommerce 2.2 Installation Help
    Replies: 2
    Last Post: 11-25-2002, 05:31 AM

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
  •