ATutor

Learning Management Tools


  1. Home



Pages:1 2 3 4 5 6 7 8 9 10 11 12 13 14 15


error type 2 in eapacheatutorincludehtmlannouncementsincphp on line 93



  • 2005-04-18 07:31:19

    error type 2 in eapacheatutorincludehtmlannouncementsincphp on line 93

    Hi All
    After crash server where running ATutor Application we must reinstall all server with this enviroment:

    Ms Windows 2000 + sp4
    Apache 1.3.33
    PHP 4.3.11
    MySQL 4.0.24-nt

    next operation, we moved old data files ( Db MySql, Atutor/ACollab Pages) into respective folder then restart all services.

    In this moment we have some problems with 'announcement and user approve' procedure.

    We attach this mail the log files..

    asap you answer about this problem

    best regards

    Marco Masoni


  • 2005-04-18 19:46:38

    Describe again

    I am not sure I understand what you are describing.

    The upgrade script should have updated the database and moved the files for you. Revert back to the old version using the backup you took of your database and move the old ATutor installation back to where it was? Then try upgrading again.

    The error suggests that the database was not updated properly. See the upgrade instructions for details.

    http://www.atutor.ca/atutor/docs/installation.php#upgrade


  • 2005-04-19 05:19:51

    Describe again and at_news* problem

    I can try explain better all steps after crash our system.

    After reinstalled Windows 2000 with sp4, Apache and MySQL then we have restored the DB_MySQL Data File and Atutor Pages from backup off-line.

    At this point restart all services, Apache and MySQL.

    Atutor works but we have some problem with 'Announcement Procedure'.

    Today I continue to understand the problem and I think that i have the AT_NEWS.* Tables corrupt and when I try to check or repair, via myisamchk, the mysql can't repair.
    when I run

    D:\MySQL\bin>myisamchk -s d:\mysql\data\atutor\*.myi
    myisamchk: MyISAM file d:\mysql\data\atutor\ac_events.MYI
    myisamchk: warning: Table is marked as crashed and last repair failed
    MyISAM-table 'd:\mysql\data\atutor\ac_events.MYI' is usable but should be fixed
    myisamchk: error: 'd:\mysql\data\atutor\at_news.MYI' is not a MyISAM-table

    Can I create new table AT_NEWS ?

    asap you answer about this problem

    best regards

    Riccardo Raggi


  • 2005-04-19 10:13:35

    Recreate the table

    Rename the old news table (if you can). You can recreate the table with the following sql:

    CREATE TABLE `at_news` (
    `news_id` mediumint(8) unsigned NOT NULL auto_increment,
    `course_id` mediumint(8) unsigned NOT NULL default '0',
    `member_id` mediumint(8) unsigned NOT NULL default '0',
    `date` datetime NOT NULL default '0000-00-00 00:00:00',
    `formatting` tinyint(4) NOT NULL default '0',
    `title` varchar(100) NOT NULL default '',
    `body` text NOT NULL,
    PRIMARY KEY (`news_id`)
    ) TYPE=MyISAM;












    If you are asking for help, provide lots of detail so problems can be reproduced.

    Things to describe:
    operating system -
    version of ATutor -
    versions of php -
    version of mysq l -
    webserver & version -
    copies of error messages -
    changes to default settings -
    web browser being used -
    and anything else relevant -