By paul o brien on

Recently installed video.module and added content embedding content from Google.

I get this error message.
# user warning: Table 'poboneor_ppdrupal473.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 (190, 189, '3851588754676248082&hl', 13107200, 350, 250, 0, 0, 0, '', 52, 0, '', 0, '', '', '', '', '', '', 'N;') in /home/poboneor/public_html/drupal/includes/database.mysql.inc on line 172.
# user warning: Table 'poboneor_ppdrupal473.video' doesn't exist query: SELECT * FROM video WHERE vid = 190 in /home/poboneor/public_html/drupal/includes/database.mysql.inc on line 172.
# user warning: Table 'poboneor_ppdrupal473.video' doesn't exist query: UPDATE video SET play_counter = play_counter + 1 where vid = 190 in /home/poboneor/public_html/drupal/includes/database.mysql.inc on line 172.
etc...

The video module appears to be calling an old database that I had for a previous installation (poboneor_ppdrupal473). I had the same trouble with Drupal 4.7 , and gave up when I could not sort out the problem. I deleted some video tables then to eliminate this problem, all to no avail, and abandoned it. http://drupal.org/node/92270. I have since moved to Drupal 5.1. Shared Linux server.

So why is the video module calling an old database. Presumable there is something from the old installation that was carried over when I upgraded.

Any ideas?

Paul

⋅ Categories: Drupal 5.x

Comments

fax8’s picture

fax8 commented

Video module will use the Drupal database. There is no any code in it which can make it using another database.
Please check your settings.php file and carefully check the DB URLs.. also check for tables overrides and prefix.
If everything seems ok .. then check that the video table exists on the DB (using a tool like PHPMyAdmin).

Hope this helps.

------------
www.varesano.net - Fabio Varesano Personal Homepage

paul o brien’s picture

paul o brien commented

thank fax8, the database name was wrong, otherwise OK though.

there was no video table. i deleted the video module, reinstalled it, turned it on and updated the database.

Still getting:

user warning: Table 'poboneor_ppdrupal.video' doesn't exist query: SELECT * FROM video WHERE vid = 196 in /home/poboneor/public_html/drupal/includes/database.mysql.inc on line 172.

no video table in database (there is video_rendering table).

when i updated the database i was not told that new database was created.

what next?

Paul