I installed this module to play with it, and when finished, I uninstalled it and manually removed the tables from the database. Now when I reinstall the module, it refuses to recreate the tables. I don't know if this is by design or a bug, but I don't know what to do. I suppose I could recreate the tables manually, but I thought it would be better to ask if there's a better way first.

What should I do?

Comments

fax8’s picture

fax8 commented

delete video module folder from "modules" folder then refresh module list...
then install again the video module.

Fabio

register’s picture

register commented

Thanks for the reply, but that didn't work. I verified that the tables were not recreated and received the following message after trying to add a video entry.


    * user warning: Table 'drupal.video' doesn't exist query: INSERT INTO video (vid, nid, vidfile, size, videox, videoy, video_bitrate, audio_bitrate, audio_sampling_rate, audio_channels, playtime_seconds, disable_multidownload, download_folder, use_play_folder, custom_field_1, custom_field_2, custom_field_3, custom_field_4, custom_field_5, custom_field_6, serialized_data) VALUES (47, 47, '', 642928, 320, 240, 0, 0, 0, '', 60, 1, '', 0, '', '', '', '', '', '', 'N;') in /home/user/example.com/drupal/includes/database.mysql.inc on line 121.
    * user warning: Table 'drupal.video' doesn't exist query: SELECT * FROM video WHERE vid = 47 in /home/user/example.com/drupal/includes/database.mysql.inc on line 121.
vhmauery’s picture

vhmauery commented
Status: Active » Closed (fixed)

The system module keeps track of whether or not you have ever installed the module. If you want to completely delete it, you have to delete the tables and then remove the entry from the system table:

mysql> DELETE FROM system WHERE name='video';
register’s picture

register commented

That did it! Thanks vhmauery... :-)

My only problem now is that it won't play flash video files. It loads the player, but won't load the file. For the record, I've been trying to do this using other methods and have been having the same problem. I believe the path is correct and it's not alerting me of any problems in my log, so I assume it's something that I'm doing wrong. Does this require a .swf file to play .flv files, because I've only been uploading a .flv.

register’s picture

register commented

I have it working now. Seemingly the problem was that I have my "Download method" set to private in admin>>settings and was posting using filtered html. I didn't realize that setting the download method to private required using the full html input method.

Thanks guys!

simoon’s picture

simoon commented

"The system module keeps track of whether or not you have ever installed the module. If you want to completely delete it, you have to delete the tables and then remove the entry from the system table:"

Would you please tell me where is the system table? how to open it and delete which table if the error report drupal.video doesn't exit?