Start Publishing Date

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?

Did it take long to reach this result?

It seems like the installation timed-out ?

Also please do not install v1.5.6_RC5 r1338,
but v1.5.6 RC7 1420

I have installed Jomsocial on this site (much larger install) and it didn't timeout.

???????

Any suggested php settings so it wouldn't time out?

right now PHP max execution time is 2048s
Max Post size 80Mb
Max upload size 80Mb