By seaneffel on

Sheesh, I can't figure it out. I've got this lingering database table that contains no rows called "av_playlist" and I have no idea what cracked out module might have generated it. It might be legacy from the Video or Audio modules, or might be from Emfield, but I can't find any trace of it in the foo.install files of any module I currently have.

If you can correctly guess which module made it, I'll give you serious recognition on my blog. If that means anything to you.

Thanks for the help!

⋅ Categories: Drupal 6.x

Comments

mlle.yotnottin’s picture

mlle.yotnottin commented

Try the media.module http://drupal.org/project/media. It appears to access that table a few times in it's module file.

seaneffel’s picture

seaneffel commented

I haven't used the media.module yet on this instance of Drupal. I have used a near relative, the media_mover.module. What do you think?

Am I right when I assume -most- modules keep their install SQL schema in the .install file? Where else do the cool kids write their starter data?

mlle.yotnottin’s picture

mlle.yotnottin commented

Media module has a file named media.module.mysql.sql where the av_playlist table is created.

#
# Table structure for table `av_playlist`
#

CREATE TABLE `av_playlist` (
  `nid` int(10) NOT NULL default '0',
  `fid` int(10) NOT NULL default '0',
  `next_fid` int(10) NOT NULL default '0',
  KEY `nid` (`nid`)
) TYPE=MyISAM;

However, according to the revision information it has been removed as of version 1.2:

Revision 1.2 
Fri Jan 9 22:21:28 2009 UTC (7 months, 1 week ago) by arthuregg
Branch: MAIN
CVS Tags: HEAD
Changes since 1.1: +0 -0 lines
FILE REMOVED

removing old files to reclaim the name space

If your mystery table has the same structure as shown above then it most likely was created with an older version of media module.

mlle.yotnottin’s picture

mlle.yotnottin commented

Media module has a file named media.module.mysql.sql where the av_playlist table is created.

#
# Table structure for table `av_playlist`
#

CREATE TABLE `av_playlist` (
  `nid` int(10) NOT NULL default '0',
  `fid` int(10) NOT NULL default '0',
  `next_fid` int(10) NOT NULL default '0',
  KEY `nid` (`nid`)
) TYPE=MyISAM;

However, according to the revision information it has been removed as of version 1.2:

Revision 1.2 
Fri Jan 9 22:21:28 2009 UTC (7 months, 1 week ago) by arthuregg
Branch: MAIN
CVS Tags: HEAD
Changes since 1.1: +0 -0 lines
FILE REMOVED

removing old files to reclaim the name space

If your mystery table has the same structure as shown above then it most likely was created with an older version of media module.