Start Publishing Date

When I add or edit an item, the "Start Publishing" date is changed to a time in the future. I have the global config time zone correct as UTC -05:00.

After adding or editing, I have to manually change the start publishing date in order to view the item on the front end.

Using ver. 1.5.4 (r558)

What should I do to correct this?

Thank you.

The item submit user is in the same timezone as the item viewing user?

During testing phase - the item submitter is me. And will be the same timezone as the user when it goes live.

Is there code I can change somewhere to say...

Set Start Publishing date to (submit time/date) - 24 hours.

Then the start publishing time/date would be yesterday.

Thanks again.

Please try the latest v1.5.6 revision for J1.5
(NOTE that v2.0 is for J2.5 and has the same features as J1.5 plus ACL, in J1.5 you need FLEXIaccess for ACL):

code.google.com/p/flexicontent/downloads/list

How do I upgrade to 1.5.6?

I couldn't get the 1.5.6 version to install.

1) uninstalled 1.5.4
2) installed 1.5.6 (db errors)then:

JInstaller::install: SQL Error. DB function failed with error number 2006
MySQL server has gone away SQL=CREATE TABLE IF NOT EXISTS `jos_flexicontent_cats_item_relations` ( `catid` int(11) NOT NULL default '0', `itemid` int(11) NOT NULL default '0', `ordering` int(11) NOT NULL default '0', PRIMARY KEY (`catid`,`itemid`), KEY `catid` (`catid`), KEY `itemid` (`itemid`) ) ENGINE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
SQL =

CREATE TABLE IF NOT EXISTS `jos_flexicontent_cats_item_relations` (
`catid` int(11) NOT NULL default '0',
`itemid` int(11) NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
PRIMARY KEY (`catid`,`itemid`),
KEY `catid` (`catid`),
KEY `itemid` (`itemid`)
) ENGINE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;

Component Install: SQL error or missing or unreadable SQL file. DB function failed with error number 2006
MySQL server has gone away SQL=CREATE TABLE IF NOT EXISTS `jos_flexicontent_cats_item_relations` ( `catid` int(11) NOT NULL default '0', `itemid` int(11) NOT NULL default '0', `ordering` int(11) NOT NULL default '0', PRIMARY KEY (`catid`,`itemid`), KEY `catid` (`catid`), KEY `itemid` (`itemid`) ) ENGINE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
SQL =

CREATE TABLE IF NOT EXISTS `jos_flexicontent_cats_item_relations` (
`catid` int(11) NOT NULL default '0',
`itemid` int(11) NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
PRIMARY KEY (`catid`,`itemid`),
KEY `catid` (`catid`),
KEY `itemid` (`itemid`)
) ENGINE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;

Error Loading ModulesMySQL server has gone away SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 2 AND m.client_id = 1 ORDER BY position, ordering

Then trying to access the site (front/back):
Warning: require_once(/home/marshall/public_html/components/com_flexicontent/helpers/route.php) [function.require-once]: failed to open stream: No such file or directory in /home/marshall/public_html/plugins/system/flexisystem.php on line 135

Fatal error: require_once() [function.require]: Failed opening required '/home/marshall/public_html/components/com_flexicontent/helpers/route.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/marshall/public_html/plugins/system/flexisystem.php on line 135

It seems your server time-out during installation

delete via FTP the flexicontent system plugins:
plugins/system/flexisystem.php
plugins/system/flexiadvroute.php

This will get you back access to your site

Do not try to uninstall FLEXIcontent

Try reinstalling v1.5.6, if it fails again then redelete flexicontent plugins via FTP and try installing v1.5.5 or v1.5.4

Back using 1.5.4 - Can you direct me on the documentation to upgrade from 1.5.4 to the latest version?

Do you know if in fact 1.5.6 will fix the problem with the publish_up date?

To recap.

Adding and editing an item on the back end - the "Start Publishing" date (i.e. jos_content.publish_up) works fine.

Adding and editing an item on the front end - the "Start Publishing" date is set to current date + 4 hours. So the item is not published.

If you can guide me to the file and code so I can check it out and/or a mod. I have hunted for the code but can't seem to find where the date is stored in the variable.

Thank you.

Yes, the timezone issue is fixed in v1.5.6 , and further more in all views the publish up time is compared to UTC time instead of user local time, so the item becomes worldwide available at the time the author specified, instead of becoming gradually available as it is done in v1.5.4

to upgrade safely
do a backup with akeeba
install in tour computer
install flexicontent
test and adpat your tempkate
do a backup
install your backup in your domaine
regards

1) Backed Up site using Akeeba
2) Restored the site (using Akeeba installer)
3) Tested the restored site
4) Installed (com_flexicontent_v1.5.6_RC5_r1338.tar)

Received this:
JInstaller::install: SQL Error. DB function failed with error number 2006
MySQL server has gone away SQL=CREATE TABLE IF NOT EXISTS `jos_flexicontent_cats_item_relations` ( `catid` int(11) NOT NULL default '0', `itemid` int(11) NOT NULL default '0', `ordering` int(11) NOT NULL default '0', PRIMARY KEY (`catid`,`itemid`), KEY `catid` (`catid`), KEY `itemid` (`itemid`) ) ENGINE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
SQL =

CREATE TABLE IF NOT EXISTS `jos_flexicontent_cats_item_relations` (
`catid` int(11) NOT NULL default '0',
`itemid` int(11) NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
PRIMARY KEY (`catid`,`itemid`),
KEY `catid` (`catid`),
KEY `itemid` (`itemid`)
) ENGINE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;

Component Install: SQL error or missing or unreadable SQL file. DB function failed with error number 2006
MySQL server has gone away SQL=CREATE TABLE IF NOT EXISTS `jos_flexicontent_cats_item_relations` ( `catid` int(11) NOT NULL default '0', `itemid` int(11) NOT NULL default '0', `ordering` int(11) NOT NULL default '0', PRIMARY KEY (`catid`,`itemid`), KEY `catid` (`catid`), KEY `itemid` (`itemid`) ) ENGINE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
SQL =

CREATE TABLE IF NOT EXISTS `jos_flexicontent_cats_item_relations` (
`catid` int(11) NOT NULL default '0',
`itemid` int(11) NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
PRIMARY KEY (`catid`,`itemid`),
KEY `catid` (`catid`),
KEY `itemid` (`itemid`)
) ENGINE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;

Error Loading ModulesMySQL server has gone away SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 2 AND m.client_id = 1 ORDER BY position, ordering

Any ideas?