opencats.org

Posted: **18 Jul 2011, 11:43**

Get following error when I click at button "Candidates"
Tried this with both, creating new database and using database from opencats 0.9.1
Is there already a work around of this problem?
Thx
Jens

Query Error -- Report to System Administrator ASAP

MySQL Query Failed: Tabelle 'cats.tag' existiert nicht

SELECT
t1.tag_id,
t1.tag_parent_id,
t2.title AS tag_parent_title,
t1.title AS tag_title
FROM
tag t1
LEFT JOIN
tag t2 ON t2.tag_id = t1.tag_parent_id
WHERE t1.site_id = 201
ORDER BY IFNULL(t1.tag_parent_id, t1.tag_id), t1.tag_id

Posted: **18 Jul 2011, 11:54**

I think this is because you've exported the current 0.9.1 version from the assembla subversion repository? there's an incomplete commit in there that doesn't quite play nicely. The one for candidate tagging. Just use the version from the download link for now. I need to roll back that commit and work it through on the 0.9.2 branch.

Posted: **18 Jul 2011, 19:32**

hi Russ,

RussH wrote:I think this is because you've exported the current 0.9.1 version from the assembla subversion repository? there's an incomplete commit in there that doesn't quite play nicely.

Sorry. I should have said that this happens only with version 0.9.2 which I donload as follows:
svn checkout http://subversion.assembla.com/svn/open ... cats-0.9.2 .
On the vesion 0.9.1 I do not have this problem but thought I shall use 0.9.2. to catch up the improvements you have implemented meanwhile.
Jens

Posted: **16 Feb 2012, 16:17**

Still get same error when using the 0.9.2 trunk version from assembla

jk2020 wrote:Get following error when I click at button "Candidates"
Tried this with both, creating new database and using database from opencats 0.9.1
Is there already a work around of this problem?
Thx
Jens

Query Error -- Report to System Administrator ASAP

MySQL Query Failed: Tabelle 'cats.tag' existiert nicht

SELECT
t1.tag_id,
t1.tag_parent_id,
t2.title AS tag_parent_title,
t1.title AS tag_title
FROM
tag t1
LEFT JOIN
tag t2 ON t2.tag_id = t1.tag_parent_id
WHERE t1.site_id = 201
ORDER BY IFNULL(t1.tag_parent_id, t1.tag_id), t1.tag_id

Posted: **02 Jun 2012, 13:10**

Hi, just run following SQL command

Code: Select all

/*Table structure for table `tag` */

CREATE TABLE `tag` (
  `tag_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tag_parent_id` int(10) unsigned DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` varchar(500) DEFAULT NULL,
  `site_id` int(11) unsigned DEFAULT NULL,
  `date_created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`tag_id`)
) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=utf8;

/*Data for the table `tag` */

insert  into `tag`(`tag_id`,`tag_parent_id`,`title`,`description`,`site_id`,`date_created`) values (1,NULL,'tag1','-',1,'2009-11-19 10:24:02');
insert  into `tag`(`tag_id`,`tag_parent_id`,`title`,`description`,`site_id`,`date_created`) values (5,1,'tag13','-',1,'2009-11-19 12:06:08');
insert  into `tag`(`tag_id`,`tag_parent_id`,`title`,`description`,`site_id`,`date_created`) values (77,1,'test tag','-',1,'2009-11-20 13:13:35');
insert  into `tag`(`tag_id`,`tag_parent_id`,`title`,`description`,`site_id`,`date_created`) values (78,NULL,'tag2','-',1,'2009-11-20 13:13:42');
insert  into `tag`(`tag_id`,`tag_parent_id`,`title`,`description`,`site_id`,`date_created`) values (79,78,'tag21','-',1,'2009-11-20 13:13:47');
insert  into `tag`(`tag_id`,`tag_parent_id`,`title`,`description`,`site_id`,`date_created`) values (80,78,'tag22','-',1,'2009-11-20 13:13:50');
insert  into `tag`(`tag_id`,`tag_parent_id`,`title`,`description`,`site_id`,`date_created`) values (81,78,'tag23','-',1,'2009-11-20 13:13:52');


CREATE TABLE `candidate_tag` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `site_id` int(10) unsigned DEFAULT NULL,
  `candidate_id` int(10) unsigned NOT NULL,
  `tag_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8;

/*Data for the table `candidate_tag` */

insert  into `candidate_tag`(`id`,`site_id`,`candidate_id`,`tag_id`) values (55,1,1,5);
insert  into `candidate_tag`(`id`,`site_id`,`candidate_id`,`tag_id`) values (56,1,1,78);
insert  into `candidate_tag`(`id`,`site_id`,`candidate_id`,`tag_id`) values (57,1,1,80);
insert  into `candidate_tag`(`id`,`site_id`,`candidate_id`,`tag_id`) values (58,1,1,81);

Posted: **02 Jun 2012, 20:57**

thanks! Have fixed the db issue in the 0.9.2, but not yet rolled into a release as I want to include the html mass-email replacement instead of the text-only thats in there right now.

If you have updates / changes feel free to request access and you can roll them into 0.9.2. as well..

opencats.org

MySQL Query Failed: Tabelle 'cats.tag' existiert nicht

MySQL Query Failed: Tabelle 'cats.tag' existiert nicht

Re: MySQL Query Failed: Tabelle 'cats.tag' existiert nicht

Re: MySQL Query Failed: Tabelle 'cats.tag' existiert nicht

Re: MySQL Query Failed: Tabelle 'cats.tag' existiert nicht

Re: MySQL Query Failed: Tabelle 'cats.tag' existiert nicht

Re: MySQL Query Failed: Tabelle 'cats.tag' existiert nicht