Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2008-12-02 10:06:34

douglgm
Member
From: Bristol
Registered: 2006-08-23
Posts: 182
Website

4.0.7 - Problems with article expiry

When I try and edit an article I get the following message when I click on the save button, and the article is not saved:

Warning: Incorrect datetime value: ‘0’ for column ‘Expires’ at row 1 update textpattern set Title = ‘Test Title’, Body = ‘Test body – modified’, Body_html = ‘Test body – modified’, Excerpt = ‘’, Excerpt_html = ‘’, Keywords = ‘’, Image = ‘’, Status = 1, LastMod = now(), LastModID = ‘droberts’, Section = ‘about’, Category1 = ‘’, Category2 = ‘’, Annotate = 0, textile_body = 1, textile_excerpt = 1, override_form = ‘’, url_title = ‘test-title’, AnnotateInvite = ‘’, custom_1 = ‘’, custom_2 = ‘’, custom_3 = ‘’, custom_4 = ‘’, custom_5 = ‘’, custom_6 = ‘’, custom_7 = ‘’, custom_8 = ‘’, custom_9 = ‘’, custom_10 = ‘’, Posted=now(), Expires=‘0’ where ID = 57 C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\quintectxp\textpatter in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\quintectxp\textpattern\lib\txplib_db.php on line 82

If I set an expiry date it’s fine – however what is the proper method of clearing an expiry – if I set the expiry to all 0’s or blank fields I get the error above.

Doug.

Offline

#2 2008-12-02 10:38:01

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 11,453
Website GitHub

Re: 4.0.7 - Problems with article expiry

You’re not alone. See if any of that helps.


The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.

Txp Builders – finely-crafted code, design and Txp

Online

Board footer

Powered by FluxBB