Welcome to Geeklog Tuesday, October 26 2021 @ 02:28 am EDT

Geeklog Forums

Does topics table has lastdate field?


OMAL

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?
 Quote

Status: offline

Laugh

Site Admin
Admin
Registered: 27/09/05
Posts: 1438
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',
 

One of the Geeklog Core Developers.
 Quote

OMAL

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?
 Quote

Status: offline

Laugh

Site Admin
Admin
Registered: 27/09/05
Posts: 1438
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
One of the Geeklog Core Developers.
 Quote

OMAL

Anonymous
Thanks a lot.
 Quote

All times are EDT. The time is now 02:28 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content