ATutor

Learning Management Tools







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


Error deleting an announcement


  • 2004-03-22 09:19:07

    Error deleting an announcement

    Info:

    MySQL v 4.0.14
    Apache v 1.2
    PHP v 4
    Atutor v 1.3.1

    I'm experiencing a problem:

    I created an announcement.
    I went into the course a few days later to edit it and received an error message telling me that it couldn't be found.

    I tried to delete it and, of course, I received the same message.

    How do I proceed from here?

    thanks,

  • 2004-03-22 09:44:42

    Do some troubleshooting

    Apparently some other system issue here, if it was there one day, and not the next.

    php 4. what?

    apache 1.2 or apache 1.3?

    On what operating system?

    Did you try restarting your browser?

    Did you try adding another announcement, then editing/deleting it...

    Does your MySQL user account have update/delete permission?

  • 2004-03-22 11:02:23

    Additional Info

    Responses:

    - tried several times logging out, closing the browser, opening it again and logging in - no change
    - tried creating another announcement - now I have two, one I cannot edit or delete, and one that I can.
    - MySQL user account has full access

    Technical info:

    PHP 4.3.4
    RedHat Lynux - not sure of version
    Processor Name Pentium III (Coppermine)
    Vendor ID GenuineIntel
    Processor Speed (MHz) 996.876
    Total Memory 2064892 kB
    Free Memory 22624 kB
    Total Swap Memory 2096472 kB
    Free Swap Memory 2096188 kB
    System Uptime 6 Days, 15 Hours and 53 Minutes
    Apache 1.3.28 Running
    DirectAdmin 1.21.2 Running
    Exim 4.24 Running
    MySQL 4.0.14 Running
    Named 9.2.1 Running
    ProFTPd 1.2.8 Running
    sshd Running
    vm-Pop3d 1.1.6 Running

  • 2004-03-22 11:44:08

    Additional Info

    An IE error appears when I select Edit for the announcement that has the problem:

    Line 15
    Char 1
    Error 'document.form.title' is null or not an object
    Code 0
    URL http://mysite/atutor/editor/edit_news.php?aid=3

  • 2004-03-22 11:59:54

    Additional Info

    Here is an extract of the AT_News table:
    Which one is "aid" (from url)?
    Can I delete the offending row?

    news_id
    course_id
    member_id
    date
    formatting
    title
    body


    4
    4
    1
    2004-03-15 18:15:43
    1
    Welcome To ATutor
    This is some default content. See the <a href="hel...


    2
    3
    2
    2004-03-15 11:46:05
    1
    Welcome To ATutor
    This is some default content. See the <a href="hel...


    3
    3
    2
    2004-03-15 11:46:49
    1
    Discovery
    <p align="center"><img src="images/GMR/Discovery...


    5
    4
    1
    2004-03-15 18:19:52
    1
    Introduction
    <p align="center"><img src="images/GMR/Prayer_Sc...


    6
    3
    1
    2004-03-21 16:00:16
    1
    Discovery
    <p align="center"><img src="images/GMR/Discovery...

  • 2004-03-22 13:20:19

    Delete Manually

    Still don't see anything that might be causing the problem. Something else seems to have happened that's outside the scope of ATutor. Perhaps data from your original announcement was corrupted. Difficult to say. If we could see the problem, and reproduce it, we might be able to offer some additional suggestions.

    Try deleting the the announcement directly from the database using a application like phpMyAdmin.

    [reply][b]In reply to:[/b]
    Responses:

    - tried several times logging out, closing the browser, opening it again and logging in - no change
    - tried creating another announcement - now I have two, one I cannot edit or delete, ...
    [op]forums/view.php?fid=7;pid=1387;page=1#1395[/op][/reply]

  • 2004-03-23 11:19:09

    Resolution

    I took a look at the AT_News table.
    It appears that the original announcement was created with a different id.
    I recall creating this id (instructor) and creating the first course and the first announcement with it.
    Then I created another id and tried to switch instructors for the course to it.
    Then I continued to create content for the course with the second id.

    I deleted the first announcement and everything appears to be fine.
    Should there be a problem when switching instructors for a course?

    thanks