(Sorry for my "spanglish")
Hello, I have a problem, my drupal upgraded to version 6.2, I had some trouble update and the various things I had to change hand (MySQL tables), the issue is that every time (I suppose that is) someone adds a story it eliminated the row of the table node_access (nid "0", vid "0", etc.) and common or anonymous users can not access content until there is cree that row again.
The mistakes that I see in the report are these two:
Duplicate entry '0' for key 2 query: INSERT INTO node (vid, type, language, title, uid, status, created, changed, comment, promote, moderate, sticky, tnid, translate) VALUES (0, 'story', 'es', 'Nuevo firmware bla bla DNIe', 2015, 0, 1212676540, 1212676540, 0, 1, 0, 0, 0, 0) in /home/publicas/public_html/includes/common.inc on line 3303.
and this other
Duplicate entry '0' for key 1 query: INSERT INTO node_revisions (nid, uid, title, body, teaser, log, timestamp, format) VALUES (0, 2015, 'Nuevo firmware para lectores USB con acceso al DNIe', 'La empresa española C3PO, bla bla con lector KBR36. \r\n\r\nCo in /home/publicas/public_html/includes/common.inc on line 3303.
If you look is inserting a nid (in node_revision) with the value "0" and "0" in vid of "node"
Here they wear as is the structure of both tables:
CREATE TABLE IF NOT EXISTS `node` (
`nid` int(10) unsigned NOT NULL auto_increment,
`vid` int(10) unsigned NOT NULL default '0',
`type` varchar(32) NOT NULL default '',
`title` varchar(255) NOT NULL default '',
`uid` int(11) NOT NULL default '0',
`status` int(11) NOT NULL default '1',
`created` int(11) NOT NULL default '0',
`changed` int(11) NOT NULL default '0',
`comment` int(11) NOT NULL default '0',
`promote` int(11) NOT NULL default '0',
`moderate` int(11) NOT NULL default '0',
`sticky` int(11) NOT NULL default '0',
`language` varchar(12) NOT NULL default '',
`tnid` int(10) unsigned NOT NULL default '0',
`translate` int(11) NOT NULL default '0',
PRIMARY KEY (`nid`),
UNIQUE KEY `vid` (`vid`),
KEY `node_type` (`type`(4)),
KEY `uid` (`uid`),
KEY `node_moderate` (`moderate`),
KEY `node_promote_status` (`promote`,`status`),
KEY `node_created` (`created`),
KEY `node_changed` (`changed`),
KEY `node_status_type` (`status`,`type`,`nid`),
KEY `nid` (`nid`),
KEY `tnid` (`tnid`),
KEY `translate` (`translate`),
KEY `node_title_type` (`title`,`type`(4))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7322 ;
and
CREATE TABLE IF NOT EXISTS `node_revisions` (
`nid` int(10) unsigned NOT NULL default '0',
`vid` int(10) unsigned NOT NULL default '0',
`uid` int(11) NOT NULL default '0',
`title` varchar(128) NOT NULL default '',
`body` longtext NOT NULL,
`teaser` longtext NOT NULL,
`log` longtext NOT NULL,
`timestamp` int(11) NOT NULL default '0',
`format` int(11) NOT NULL default '0',
PRIMARY KEY (`vid`),
KEY `nid` (`nid`),
KEY `uid` (`uid`),
FULLTEXT KEY `similar` (`title`,`body`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
I suppose that the problem is there, but I do not know that I have to change, I hope someone throw me a rope.
THANK YOU, cauly
(and thank you to google translate :D )
Comments
I alter in Node_revision the
I alter in Node_revision the option of "nid" and put "auto_increment," Now I do not strip the mistake that, but still the mistake of leaving the table "node" in phpMyAdmin I get this:
this table in my computer is like on the server, however on the server can not add the news (display a poster that says you can not add) and I could add in my pc news