Hello,

Just as the title says :

when going to the admin/config/content/setupsimpelyoutubefeed I get a critical error :

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'packt_mod_dev.feed_to_node' doesn't exist: SELECT s.* FROM {feed_to_node} s; Array ( ) in feed_to_node_admin_setup_feed() (line 275 of C:\xampp\htdocs\drupal\sites\all\modules\sandbox\feed_to_node.module).

I'm guessing the required table isn't made available upon installation of the module?

Comments

redsd’s picture

redsd commented

Yes correct,

I haven't created the install file yet, I didn't figure Anyone would check this repo out within a day... Next time I keep that in mind...

The SQL is:
CREATE TABLE `feed_to_node` (
`fid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`url` text NOT NULL,
`name` varchar(250) NOT NULL,
`nid` int(10) unsigned NOT NULL,
`published` tinyint(1) NOT NULL,
`parser` varchar(250) NOT NULL,
PRIMARY KEY (`fid`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

CREATE TABLE `feed_to_node_item` (
`fiid` varchar(250) NOT NULL COMMENT 'Unique youtube id',
`nid` int(10) unsigned NOT NULL,
`fid` int(10) unsigned NOT NULL,
PRIMARY KEY (`fiid`,`nid`) USING BTREE,
KEY `node` (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Alienpruts’s picture

Alienpruts commented

The speed of the communty : it's mindboggling these days :)

i'll take a further look and let you know what I come up with.

redsd’s picture

redsd commented
Assigned: Unassigned » redsd

Haha yeah!

I added the install file and a README.txt with the same explination as on the module page.

I also changed the url path which reffered to earlier naming of the module.

redsd’s picture

redsd commented
Status: Needs review » Fixed

Fixed Install file was added, including some extra updates.

redsd’s picture

redsd commented
Status: Fixed » Closed (fixed)