Tables missing from install - manual install file
rbl - May 21, 2008 - 04:00
| Project: | Pay2Publish |
| Version: | 5.x-1.0 |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | postponed (maintainer needs more info) |
Description
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
#1
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
#2
Same here!
#3
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 ;
#4
this should be fixed now
#5
Automatically closed -- issue fixed for two weeks with no activity.
#6
I am still getting this error. I tried the install sql txt above and still getting error.
#7
never mind. sorry. forgot to add the db prefix.
#8
This should be fixed now in the latest 5.x development version. Please report back here if it does work for you. Thx
#9