[Deploying Sakai] Critical problem with melete 2.6.0 (part 2)

[Jean-Francois Leveque]

Thanks Mallika,

The resource does not exist in CONTENT_RESOURCE:
select * from CONTENT_RESOURCE where 
RESOURCE_ID='/private/meleteDocs/fmpmcPM1_2007/uploads/evaluation-1';
Empty set (0.00 sec)

The resource does not exist in melete_resource:
select * from melete_resource where RESOURCE_ID = 
'/private/meleteDocs/fmpmcPM1_2007/uploads/evaluation-1';
Empty set (0.00 sec)

The resource exists in melete_section_resource:
select * from melete_section_resource where SECTION_ID=22282244;
+------------+--------------------------------------------------------+
| SECTION_ID | RESOURCE_ID                                            |
+------------+--------------------------------------------------------+
|   22282244 | /private/meleteDocs/fmpmcPM1_2007/uploads/evaluation-1 |
+------------+--------------------------------------------------------+
1 row in set (0.00 sec)

I did not know about anything to be kept in the section:

select * from melete_section where SECTION_ID=22282244;
+------------+---------+-----------+------------+------------------+------------------+-------------------+-------------------+-------+--------------+---------------+---------------+-----------------+-------------+---------------------+---------------------+-------------+
| SECTION_ID | VERSION | MODULE_ID | title      | CREATED_BY_FNAME | 
CREATED_BY_LNAME | MODIFIED_BY_FNAME | MODIFIED_BY_LNAME | INSTR | 
CONTENT_TYPE | AUDIO_CONTENT | VIDEO_CONTENT | TEXTUAL_CONTENT | 
DELETE_FLAG | CREATION_DATE       | MODIFICATION_DATE   | OPEN_WINDOW |
+------------+---------+-----------+------------+------------------+------------------+-------------------+-------------------+-------+--------------+---------------+---------------+-----------------+-------------+---------------------+---------------------+-------------+
|   22282244 |       1 |  20742144 | evaluation | Lea              | 
Reymond          | NULL              | NULL              |       | 
typeLink     |             0 |             0 |               1 | 
    0 | 2009-11-24 14:51:35 | 2009-11-24 14:51:35 |           1 |
+------------+---------+-----------+------------+------------------+------------------+-------------------+-------------------+-------+--------------+---------------+---------------+-----------------+-------------+---------------------+---------------------+-------------+
1 row in set (0.00 sec)

So I removed the entries in melete_section_resource and melete_section.

Is the melete admin able to deal with such incoherent state?

Should I create a JIRA on your server for this?

Cheers,

Jean-Francois

Mallika a écrit :
> Jean-Francois,
> 
> There are a couple of additional checks you can do prior to fixing this:
> 
> 1. Check to see if this resource_id exists in the CONTENT_RESOURCE 
> table. If it does, and you want to keep the section,
> you can insert a record into MELETE_RESOURCE for this RESOURCE_ID, You 
> can set the LICENSE_CODE to 0(set all int column values to 0 and all 
> varchar values to null).
> 
> 2. If the resource_id does not exist in the CONTENT_RESOURCE table, 
> check to see if you still want to keep this section. This means that the 
> content of the section is lost but information such as instructions etc 
> is retained. If you want to preserve just this information *and if the 
> DELETE_FLAG of this section in MELETE_SECTION is not set to 1*, set the 
> RESOURCE_ID in MELETE_SECTION_RESOURCE to null.
> 
> 3. If the resource_id does not exist in the CONTENT_RESOURCE table and 
> you do not want to keep the section, you need to delete the entry  from 
> MELETE_SECTION as well as MELETE_SECTION_RESOURCE.
> 
> Thanks,
> Mallika
> 
> Jean-Francois Leveque wrote:
>> Hi again,
>>
>> I've been able to find the following problem in the database:
>>
>> mysql> select * from melete_section_resource where RESOURCE_ID like 
>> '/private/meleteDocs/fmpmcPM1_2007/uploads/evaluation-1';
>> +------------+--------------------------------------------------------+
>> | SECTION_ID | RESOURCE_ID                                            |
>> +------------+--------------------------------------------------------+
>> |   22282244 | /private/meleteDocs/fmpmcPM1_2007/uploads/evaluation-1 |
>> +------------+--------------------------------------------------------+
>> 1 row in set (0.00 sec)
>>
>> mysql> select * from melete_resource where RESOURCE_ID = 
>> '/private/meleteDocs/fmpmcPM1_2007/uploads/evaluation-1';
>> Empty set (0.00 sec)
>>
>> melete_section_resource is referring to a missing melete_resource.
>>
>> Is it safe to remove the entry in melete_section_resource?
>>
>> Thanks
>>
>> Jean-Francois Leveque
>> Sakai Chief Technical Officer
>> Universite Pierre et Marie Curie
>> Paris, France