- Posts: 4
COMMUNITY FORUM
k2 doesnt update publish_up field in db after editing
- Grek
-
Topic Author
- Offline
- New Member
Less
More
9 years 7 months ago #147984
by Grek
k2 doesnt update publish_up field in db after editing was created by Grek
Hi, I use K2 2.6.9 on Joomla 3 news portal. We have over then 8000 articles on our site and every day add a lot of new articles. Time of publications of some articles we plan on future (For example, we add new article on 8 am but time of publication we set on 10 am). But there is a problem - in such modules as newsgknewspro the future articles appear at 8am, and if some user will click on it - he get 404 error. If we change time of publication in the article in k2, after saving we will see new value of field "publish" , but if we check field "publish_up" in #_k2_items we will see no changes - there will be old value without updating. So, after updating field in k2 article this field in db doesnt change. If you can, fix this bug or give some advice how I can fix it (maybe I did or understood something wrong)
Please Log in or Create an account to join the conversation.
- Grek
-
Topic Author
- Offline
- New Member
Less
More
- Posts: 4
9 years 7 months ago #147994
by Grek
Replied by Grek on topic k2 doesnt update publish_up field in db after editing
Understood - the problem is in timezone. When I set in article creating time 8am and publication time 10am, in database table #_k2_items I get creating time 11am and publication time 13am (In general option of Joomla I set option "Timezone" - Kyiv). So I always get 3 hours difference. Who can explain, how to fix that?
Please Log in or Create an account to join the conversation.
- Krikor Boghossian
-
- Offline
- Platinum Member
Less
More
- Posts: 15920
9 years 7 months ago #147997
by Krikor Boghossian
Replied by Krikor Boghossian on topic k2 doesnt update publish_up field in db after editing
What is the timezone of your server?
Please Log in or Create an account to join the conversation.
- Grek
-
Topic Author
- Offline
- New Member
Less
More
- Posts: 4
9 years 7 months ago - 9 years 7 months ago #147998
by Grek
Replied by Grek on topic k2 doesnt update publish_up field in db after editing
Europe/Kiev
Last edit: 9 years 7 months ago by Grek.
Please Log in or Create an account to join the conversation.
- Krikor Boghossian
-
- Offline
- Platinum Member
Less
More
- Posts: 15920
9 years 7 months ago #148025
by Krikor Boghossian
Replied by Krikor Boghossian on topic k2 doesnt update publish_up field in db after editing
Is the item showing correctly in K2's core modules eg: K2 Content and in the component area?
Please Log in or Create an account to join the conversation.
- Grek
-
Topic Author
- Offline
- New Member
Less
More
- Posts: 4
9 years 6 months ago #148119
by Grek
Replied by Grek on topic k2 doesnt update publish_up field in db after editing
The problem was in mysql timezone (UTC) and timezone in site options (Europe|Kiev) - I got 3 hours difference in article publication. So future (planned) articles didn't appear in modules like gknewsshowpro. I fixed data_source k2 file model.php in the module with taking into account the time difference and problem was solved. All works fine now.
Please Log in or Create an account to join the conversation.
- Krikor Boghossian
-
- Offline
- Platinum Member
Less
More
- Posts: 15920
9 years 6 months ago #148149
by Krikor Boghossian
Replied by Krikor Boghossian on topic k2 doesnt update publish_up field in db after editing
Nice to hear that it works Grek :)
Please Log in or Create an account to join the conversation.