Subject: Does topics table has lastdate field?

Posted on: 12/06/21 12:05pm
By: Anonymous

In my Geeklog, topics table has "lastdate" field and it looks like not used.
What is it for?
If it is the date when topic is edited, it is useful. Is it functioning?

Re: Does topics table has lastdate field?

Posted on: 12/06/21 05:20pm
By: Laugh

It should not. These are the columns the topics table has:

PHP Formatted Code
  tid varchar(75) NOT NULL default '',
  topic varchar(75) default NULL,
  title varchar(128) default NULL,
  imageurl varchar(255) default NULL,
  meta_description TEXT NULL,
  meta_keywords TEXT NULL,
  sortnum smallint(3) default NULL,
  limitnews tinyint(3) default NULL,
  is_default tinyint(1) unsigned NOT NULL DEFAULT '0',
  archive_flag tinyint(1) unsigned NOT NULL DEFAULT '0',
  parent_id varchar(128) NOT NULL default 'root',
  inherit tinyint(1) NOT NULL default '1',
  hidden tinyint(1) NOT NULL default '0',
  owner_id mediumint(8) unsigned NOT NULL default '1',
  group_id mediumint(8) unsigned NOT NULL default '1',
  perm_owner tinyint(1) unsigned NOT NULL default '3',
  perm_group tinyint(1) unsigned NOT NULL default '3',
  perm_members tinyint(1) unsigned NOT NULL default '2',
  perm_anon tinyint(1) unsigned NOT NULL default '2',
 

Re: Does topics table has lastdate field?

Posted on: 13/06/21 01:14am
By: Anonymous

OK, Thanks.
So, I think it is the field when my website is upgraded from customized geeklog1.4 to Geeklog 2.2.

I have another question. Are there easy way to find the last time topic table was updated?

Re: Does topics table has lastdate field?

Posted on: 13/06/21 09:49am
By: Laugh

I didn't know that was tracked at one point. Must be a bug in the upgrade code from that far back I guess.

For just the table (and any record in it) you can see here for some options:

https://stackoverflow.com/questions/307438/how-can-i-tell-when-a-mysql-table-was-last-updated

Re: Does topics table has lastdate field?

Posted on: 17/06/21 09:45am
By: Anonymous

Thanks a lot.

Geeklog - Forum
https://www.geeklog.net/forum/viewtopic.php?showtopic=97435