Hello, thanks for this module, i just install and have some problem to get it work as the demo you provide

First i add a type with name regular link with no to reciprocal link, then i add a package with regular name and add to the type! when i try to add a node link, it get published but only with description and no way to view link url, i try many type and package, nothing work, only description display! when i edit a node link, it doesn't store the mail or the url, i have to add it twice!

Get error in watchdog

Unknown column 'dwebmast_biladibe.t.vid' in 'on clause' query: SELECT n.package_id, n.name, n.email, n.ipaddress_created, n.ipaddress_changed, n_u.*, p_t.required, p_t.weight, t.reciprocal, t1.title FROM node_link_node n INNER JOIN node_link_package p USING(package_id) INNER JOIN node_link_package_type p_t USING(package_id) INNER JOIN node_link_type t USING(type_id) INNER JOIN node_link_node_url n_u USING(nid, vid, type_id) LEFT JOIN node_link_node_title t1 USING(nid, vid, type_id) WHERE n.nid = 5656 AND n.vid = 5656 ORDER BY p_t.weight dans /home/dwebmast/public_html/includes/database.mysql.inc à la ligne 172.

Comments

dortik’s picture

dortik commented

What database do you use (name + version) ?

toma’s picture

toma commented

Drupal 5.8
MySQL 4.1.22
PHP 5.2.6
Web server Apache/2.2.9

Thanks

dortik’s picture

dortik commented

Please try new version, I've just uploaded and let me know if it is ok now

toma’s picture

toma commented

I try and install the new version, get the same problem

Unknown column 'dwebmast_biladibe.t.vid' in 'on clause' query: SELECT n.package_id, n.name, n.email, n.ipaddress_created, n.ipaddress_changed, n_u.*, p_t.required, p_t.weight, t.reciprocal, t1.title FROM node_link_node n INNER JOIN node_link_package p USING(package_id) INNER JOIN node_link_package_type p_t USING(package_id) INNER JOIN node_link_type t USING(type_id) INNER JOIN node_link_node_url n_u USING(nid, vid, type_id) LEFT JOIN node_link_node_title t1 USING(nid, vid, type_id) WHERE n.nid = 5663 AND n.vid = 5663 ORDER BY p_t.weight dans /home/dwebmast/public_html/includes/database.mysql.inc à la ligne 172.

Thanks

dortik’s picture

dortik commented

Please attach dump of all tables with name starting with "node_link_", because I can not reproduce it locally and suspect it is issue in installation.

Thank you for assistance.

toma’s picture

toma commented

ok 

-- phpMyAdmin SQL Dump
-- version 2.11.6
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Mer 16 Juillet 2008 à 20:33
-- Version du serveur: 4.1.22
-- Version de PHP: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Base de données: `dwebmast_biladibe`
--

-- --------------------------------------------------------

--
-- Structure de la table `node_link_node`
--

CREATE TABLE IF NOT EXISTS `node_link_node` (
  `vid` int(10) unsigned NOT NULL default '0',
  `nid` int(10) unsigned NOT NULL default '0',
  `package_id` int(10) unsigned NOT NULL default '0',
  `name` varchar(255) default NULL,
  `email` varchar(255) default NULL,
  `ipaddress_created` varchar(15) default NULL,
  `ipaddress_changed` varchar(15) default NULL,
  PRIMARY KEY  (`vid`,`nid`),
  KEY `node_link_node_package_id` (`package_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `node_link_node`
--

INSERT INTO `node_link_node` (`vid`, `nid`, `package_id`, `name`, `email`, `ipaddress_created`, `ipaddress_changed`) VALUES
(5663, 5663, 2, 'toma', 'tomawebdev@yahoo.com', '81.192.199.123', '81.192.199.123');

-- --------------------------------------------------------

--
-- Structure de la table `node_link_node_title`
--

CREATE TABLE IF NOT EXISTS `node_link_node_title` (
  `vid` int(10) unsigned NOT NULL default '0',
  `nid` int(10) unsigned NOT NULL default '0',
  `type_id` int(10) unsigned NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`vid`,`nid`,`type_id`),
  KEY `node_link_node_title_type_id` (`type_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `node_link_node_title`
--


-- --------------------------------------------------------

--
-- Structure de la table `node_link_node_url`
--

CREATE TABLE IF NOT EXISTS `node_link_node_url` (
  `vid` int(10) unsigned NOT NULL default '0',
  `nid` int(10) unsigned NOT NULL default '0',
  `type_id` int(10) unsigned NOT NULL default '0',
  `url` varchar(255) NOT NULL default '',
  `errors` int(11) NOT NULL default '0',
  `checked` datetime default NULL,
  PRIMARY KEY  (`vid`,`nid`,`type_id`),
  UNIQUE KEY `node_link_node_url_url_idx` (`type_id`,`url`),
  KEY `node_link_node_url_checked_idx` (`checked`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `node_link_node_url`
--

INSERT INTO `node_link_node_url` (`vid`, `nid`, `type_id`, `url`, `errors`, `checked`) VALUES
(5663, 5663, 3, 'http://www.voyagez.info', 0, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `node_link_package`
--

CREATE TABLE IF NOT EXISTS `node_link_package` (
  `package_id` int(10) unsigned NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `weight` int(11) NOT NULL default '0',
  `node_status` int(11) default NULL,
  PRIMARY KEY  (`package_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `node_link_package`
--

INSERT INTO `node_link_package` (`package_id`, `title`, `weight`, `node_status`) VALUES
(2, 'Reciprocal', 0, 1);

-- --------------------------------------------------------

--
-- Structure de la table `node_link_package_role`
--

CREATE TABLE IF NOT EXISTS `node_link_package_role` (
  `package_id` int(10) unsigned NOT NULL default '0',
  `rid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`package_id`,`rid`),
  KEY `node_link_package_role_rid` (`rid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `node_link_package_role`
--

INSERT INTO `node_link_package_role` (`package_id`, `rid`) VALUES
(2, 1),
(2, 2),
(2, 3);

-- --------------------------------------------------------

--
-- Structure de la table `node_link_package_type`
--

CREATE TABLE IF NOT EXISTS `node_link_package_type` (
  `package_id` int(10) unsigned NOT NULL default '0',
  `type_id` int(10) unsigned NOT NULL default '0',
  `weight` int(11) NOT NULL default '0',
  `required` enum('t','f') NOT NULL default 'f',
  PRIMARY KEY  (`package_id`,`type_id`),
  KEY `node_link_package_type_type_id` (`type_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `node_link_package_type`
--

INSERT INTO `node_link_package_type` (`package_id`, `type_id`, `weight`, `required`) VALUES
(2, 3, 0, 't');

-- --------------------------------------------------------

--
-- Structure de la table `node_link_type`
--

CREATE TABLE IF NOT EXISTS `node_link_type` (
  `type_id` int(10) unsigned NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `reciprocal` enum('t','f') NOT NULL default 'f',
  PRIMARY KEY  (`type_id`),
  KEY `node_link_type_reciprocal_idx` (`reciprocal`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `node_link_type`
--

INSERT INTO `node_link_type` (`type_id`, `title`, `reciprocal`) VALUES
(3, 'Reciprocal', 't');
dortik’s picture

dortik commented

I've installed your dump on my machine and executed the following SQL query:
-----------
SELECT n.package_id, n.name, n.email, n.ipaddress_created, n.ipaddress_changed, n_u.*, p_t.required, p_t.weight, t.reciprocal, t1.title FROM node_link_node n INNER JOIN node_link_package p USING(package_id) INNER JOIN node_link_package_type p_t USING(package_id) INNER JOIN node_link_type t USING(type_id) INNER JOIN node_link_node_url n_u USING(nid, vid, type_id) LEFT JOIN node_link_node_title t1 USING(nid, vid, type_id) WHERE n.nid = 5663 AND n.vid = 5663 ORDER BY p_t.weight
-----------

And did not receive any error message, try it by yourself.

I recommend you to try the following steps:
1. Check if you don't have overloaded theme_view function or if you don't have some special treatment of node in your template.
2. Conflict with some module you have installed, try to do the following steps:
A. Install this module on clean drupal 5.x
B. Enable node_link module
C. make tests
If it will work:
D. enable your module one by one and check functionality, this way you can find conflict. If you'll find any, please report it to me, so I'll be able to find a solution.
If it won't work, please let me know.

Thanks

dortik’s picture

dortik commented
Status: Active » Fixed

I'm closing this bug, because I can not reproduce it.
If you will have this issue again, please let me know.

toma’s picture

toma commented

I try this to a new drupal website, and i get the same error 

user warning: Unknown column 'dwebmast_adver.t.vid' in 'on clause' query: SELECT n.package_id, n.name, n.email, n.ipaddress_created, n.ipaddress_changed, n_u.*, p_t.required, p_t.weight, t.reciprocal, t1.title FROM node_link_node n INNER JOIN node_link_package p USING(package_id) INNER JOIN node_link_package_type p_t USING(package_id) INNER JOIN node_link_type t USING(type_id) INNER JOIN node_link_node_url n_u USING(nid, vid, type_id) LEFT JOIN node_link_node_title t1 USING(nid, vid, type_id) WHERE n.nid = 1 AND n.vid = 1 ORDER BY p_t.weight in /home/dwebmast/public_html/includes/database.mysql.inc on line 172.
toma’s picture

toma commented

If you want i can give you a login and admin password to see yourself

Thanks for your module

dortik’s picture

dortik commented
Status: Fixed » Postponed (maintainer needs more info)

Have you tried it on fresh drupal without plugins?

Please attach me a list of all plugins you use.

Thanks

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
Assigned: toma » Unassigned
Issue summary: View changes
Status: Postponed (maintainer needs more info) » Closed (outdated)

I am closing this issue, since it is for a Drupal version that is not supported and the project does not have any release compatible with supported Drupal versions.