Hi!
Just install the stable version and I'm getting this error in the P2P admin page:

user warning: Table 'drupal.pay2publish' doesn't exist query: SELECT v.*, n.type FROM pay2publish v LEFT JOIN pay2publish_node_types n ON v.vid = n.vid ORDER BY v.weight, v.name in /Library/WebServer/Documents/drupal.site/includes/database.mysql.inc on line 172.
user warning: Table 'drupal.pay2publish_duration' doesn't exist query: SELECT * FROM pay2publish_duration ORDER BY weight, name in /Library/WebServer/Documents/drupal.site/includes/database.mysql.inc on line 172.

Ricardo

CommentFileSizeAuthor
#3 pay2publishinstall sql.txt2.26 KBearth

Comments

rbl’s picture

rbl commented

Actually, no table whatsoever was installed.

I can't see anything wrong with the install file except the name of the function:
function taxonomy_actions_install()

=)
Ricardo

vlooivlerke’s picture

vlooivlerke commented

Same here!

earth’s picture

earth commented
Title: Tables missing from install » Tables missing from install- manual install file- needs reviewed
StatusFileSize
new pay2publishinstall sql.txt2.26 KB

here is a rough install file I just modified from the original, as it needs to be reviewed and tested and it may work via the GUI with the install script, not sure, maybe someone can view it and test it out, as I got to run for the day, now!

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

CREATE TABLE `pay2publish` (
`vid` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`description` longtext,
`taxtermstart` int(11) NOT NULL default '0',
`taxtermend` int(11) NOT NULL default '0',
`cattermstart` int(11) NOT NULL default '0',
`cattermend` int(11) NOT NULL default '0',
`duration` int(11) NOT NULL default '0',
`cost` int(11) NOT NULL default '0',
`weight` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `pay2publish_duration` (
`vid` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
description longtext,
`duration` int(11) NOT NULL default '0',
`weight` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `pay2publish_node` (
`tid` int(11) NOT NULL default '0',
`nid` int(10) unsigned NOT NULL default '0',
`vid` int(10) unsigned NOT NULL default '0',
`uid` int(11) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`act` varchar(255) NOT NULL default '',
`duration_m` int(11) NOT NULL default '0',
`duration` int(11) NOT NULL default '0',
`cost` int(11) NOT NULL default '0',
`payment` int(11) NOT NULL default '0',
`weight` int(11) NOT NULL default '0',
PRIMARY KEY (`tid`),
KEY nid (`nid`),
KEY tid (`vid`),
KEY uid (`uid`),
KEY vid (`vid`),
KEY payment (`payment`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `pay2publish_node_types` (
`vid` int(10) unsigned NOT NULL default '0',
`type` varchar(32) NOT NULL default '',
PRIMARY KEY (`vid`, `type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

marcoBauli’s picture

marcoBauli commented
Status: Active » Fixed

this should be fixed now

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.

mrgoltra’s picture

mrgoltra commented

I am still getting this error. I tried the install sql txt above and still getting error.

mrgoltra’s picture

mrgoltra commented

never mind. sorry. forgot to add the db prefix.

marcoBauli’s picture

marcoBauli commented
Status: Closed (fixed) » Closed (duplicate)

This should be fixed now in the latest 5.x development version. Please report back here if it does work for you. Thx

marcoBauli’s picture

marcoBauli commented
Title: Tables missing from install- manual install file- needs reviewed » Tables missing from install - manual install file
Status: Closed (duplicate) » Postponed (maintainer needs more info)
pitxels’s picture

pitxels commented

Not installing tables for me at all with any version of the module, is this module stable? I was looking forward to try it and port it to d6 :(