湖濱散記部落格的樹心幽徑[login][主頁]
225:20130621修訂gallery3的thumb問題


(1)
mysql> select count(*) from ga3items where thumb_height > 100;
+----------+
| count(*) |
+----------+
|     1962 |
+----------+
1 row in set (0.00 sec)

 



(2)

mysql>  update ga3items set thumb_dirty = 1 where thumb_height > 100;
Query OK, 1949 rows affected (0.02 sec)
Rows matched: 1962  Changed: 1949  Warnings: 0

mysql>

 

(3)

login to Gallery3 and Admin -> Maintenance, Rebuild Images

選重建相片 有 1963 張相片已經過時


select id,article_id,topic,text from lt_articles_text where article_id =225; ok. update lt_articles set num_reads=num_reads +1 where id=225; ok.