feedjack benutzt bei mir die web9_db1!

| feedjack_link              | 
| feedjack_post              | 
| feedjack_post_tags         | 
| feedjack_site              | 
| feedjack_site_links        | 
| feedjack_subscriber        | 
| feedjack_tag               

die Tags stehen in der Tabelle

Beispiel:

mysql> select * from feedjack_tag limit 10; 
+-----+----------------------+
| id  | name                 |
+-----+----------------------+
| 109 | qualitätsoffensive   | 
| 338 | manipulation         | 
| 447 | gegenöffentlichkeit  | 
| 611 | krieg                | 
|  81 | ignorranz            | 
|  26 | humor                | 
| 536 | versicherung         | 
| 103 | skandal              | 
| 613 | rechtsextremismus    | 
| 599 | rechtsruck           | 
+-----+----------------------+

Die Tabelle

mysql> select * from feedjack_post_tags limit 10;
+----+---------+--------+
| id | post_id | tag_id |
+----+---------+--------+
|  1 |   17159 |    389 | 
|  2 |   17131 |    296 | 
|  3 |   17131 |     32 | 
|  4 |   17140 |    305 | 
|  5 |   17140 |    304 | 
|  6 |   17150 |    305 | 
|  7 |   17150 |    304 | 
|  8 |   17153 |    338 | 
|  9 |   17153 |    339 | 
| 10 |   17155 |    390 | 
+----+---------+--------+
10 rows in set (0.01 sec)

speichert die Verwendung von den Tags. Hier ist also zu überprüfen ob die post_id noch vorhanden ist!

mysql> describe feedjack_post ;
+---------------+--------------+------+-----+---------+----------------+
| Field         | Type         | Null | Key | Default | Extra          |
+---------------+--------------+------+-----+---------+----------------+
| id            | int(11)      | NO   | PRI | NULL    | auto_increment | 
| feed_id       | int(11)      | NO   | MUL |         |                | 
| title         | varchar(255) | NO   |     |         |                | 
| link          | varchar(200) | NO   |     |         |                | 
| content       | longtext     | NO   |     |         |                | 
| date_modified | datetime     | YES  |     | NULL    |                | 
| guid          | varchar(200) | NO   | MUL |         |                | 
| author        | varchar(50)  | NO   |     |         |                | 
| author_email  | varchar(75)  | NO   |     |         |                | 
| comments      | varchar(200) | NO   |     |         |                | 
| date_created  | date         | NO   |     |         |                | 
+---------------+--------------+------+-----+---------+----------------+
11 rows in set (0.00 sec)

einige Tests:

welche sind ohne Title! select feedjack_post.id as PostID ,title from feedjack_post,feedjack_post_tags where feedjack_post_tags.post_id=feedjack_post.id and title = limit 100;

mysql> select feedjack_post.id as PostID ,title from feedjack_post_tags left join feedjack_post on feedjack_post_tags.post_id=feedjack_post.id limit 10;

welche Tags sind gespeichert? select distinct( tag_id),post_id from feedjack_post_tags limit 10;

select distinct( tag_id),post_id from feedjack_post_tags limit 10; select distinct( tag_id),feedjack_post.id as PostID ,title from feedjack_post_tags left join feedjack_post on feedjack_post_tags.post_id=feedjack_post.id limit 10;

Welche Tags sind gelöscht: select distinct( tag_id),feedjack_post.id as PostID ,title from feedjack_post_tags right join feedjack_post on feedjack_post_tags.post_id=feedjack_post.id where title= limit 10;

select distinct( tag_id),feedjack_post.id as PostID ,title from feedjack_post, join feedjack_post where feedjack_post_tags.post_id=feedjack_post.id where title= limit 10;

SELECT * FROM feedjack_post_tags,feedjack_tag WHERE feedjack_tag.id=feedjack_post_tags.id AND feedjack_tag.name='adobe 9' ;

SELECT * FROM feedjack_post_tags,feedjack_tag WHERE feedjack_tag.id=feedjack_post_tags.id ;

SELECT * FROM feedjack_post_tags,feedjack_tag WHERE feedjack_tag.id=feedjack_post_tags.id

• AND

post_id=13821;

DELETE FROM feedjack_post_tags WHERE id=1386;

SELECT * FROM feedjack_tag WHERE NAME='adobe 9';

SELECT count(*) FROM feedjack_tag;

SELECT * FROM feedjack_tag WHERE VISIBLEONPAGE=1;

-- DetlevLengsfeld 2008-11-16 15:41:09

Kategorie/Mobbing

Python/Django/Feedjack und gelöschte Postings (last edited 2009-12-11 13:23:36 by DetlevLengsfeld)