staticpages tables missing last_modified field

Creating and modifying plugins.
Post Reply
Timbalu
Regular
Posts: 4598
Joined: Sun May 02, 2004 3:04 pm

staticpages tables missing last_modified field

Post 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?
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: staticpages tables missing last_modified field

Post 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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Post Reply