Page 1 of 1

staticpages tables missing last_modified field

Posted: Sun Jan 20, 2008 6:53 pm
by Timbalu
Hi

Version: event_staticpages 3.60

I just discovered an error in mysql insert when changing a staticpage.
It says field last_modified is missing, but the create table function nor the updates don't include this field.

Is this just a missing field, a bug in the form or just something weired?

Ian

Update:
Just tried to ALTER by hand

Code: Select all

 ALTER TABLE `rvb_staticpages` ADD `last_modified` INT( 10 ) UNSIGNED NOT NULL AFTER `timestamp`;
 ALTER TABLE `rvb_staticpages` ADD related_category_id int(4) default 0 AFTER `articletype`;
now its ok - I just wonder why it didn't fetch the updates?

Re: staticpages tables missing last_modified field

Posted: Mon Jan 21, 2008 10:05 am
by garvinhicking
Hi!

Both the create function and the updates contain a "last_modified" stamp, please search the PHP code for "last_modified" and you'll find it.

Depending on how often you upgraded the staticpage plugin it might have happened that you downloaded a version of the plugin that didn't properly add this in the past...

Regards,
Garvin