Welcome to Geeklog, Anonymous Saturday, November 30 2024 @ 07:54 pm EST
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?
What is it for?
If it is the date when topic is edited, it is useful. Is it functioning?
27
27
Quote
Status: offline
Laugh
Site Admin
Admin
Registered: 09/27/05
Posts: 1470
Location:Canada
It should not. These are the columns the topics table has:
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.
Text 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.
29
21
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?
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?
24
23
Quote
Status: offline
Laugh
Site Admin
Admin
Registered: 09/27/05
Posts: 1470
Location:Canada
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.
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.
23
20
Quote
OMAL
Anonymous
Thanks a lot.
24
25
Quote
All times are EST. The time is now 07:54 pm.
- 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