Table dropped but still used

[XavierAntoviaque]

The release 4 includes the following line:

DROP TABLE IF EXISTS `mission_state`;

However this table still seems to be used (when clicking on "reply" in the chat:

2010-12-06 14:47:12 - DEBUG --> /ajax/missions.php: [DB] hackit_DataObjects_Mission_state : Query Error : [mdb2_error: message="MDB2 Error: no such table" code=-18 mode=return level=notice prefix="" info="_doQuery: [Error message: Could not execute statement]
[Last executed query: SELECT *
 FROM `mission_state`

 WHERE ( `mission_state`.`session_id` = 'cpc1ktp5omkm9l3uj7t7hcdp34' ) AND ( `mission_state`.`user_id` = 477 ) AND ( `mission_state`.`mission_identifier` = 'FirstMission' ) AND ( `mission_state`.`status` = 'open' )
]
[Native code: 1146]
[Native message: Table 'hackit.mission_state' doesn't exist]

[Vlad Dragu (vlad-dragu)]

I used make release to generate the r4 release and i didn't dropped that table, so i'm not sure why it added the drop statement there.
I did a make release right now and it didn't add that statement.
Also i checked the r4 version and the statement is no longer there, i assume you deleted it.

[XavierAntoviaque (xavier-antoviaque)]

Yup, I deleted it, since it was blocking the "make upgrade" and was creating issues for David (if you are ever in doubt about a change on a file, you can see the revision history for any particular file on the repository - cf http://bazaar.launchpad.net/~hackit/hackit/trunk/changes?filter_file_id=update_db_hackit_r4.-20101203031837-gamt33k1a2n4e7mz-1 here - also, now that you're not the only one modifying the code, you'll need to follow the revisions feed to stay in touch with the changes others are doing: http://feeds.launchpad.net/hackit/revisions.atom ).

I'm closing this bug since it's not an issue anymore.