Keyword

k2 doesnt update publish_up field in db after editing

More
8 years 11 months ago #147984 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.

More
8 years 11 months ago #147994 by Grek
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
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
8 years 11 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?

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

More
8 years 11 months ago - 8 years 11 months ago #147998 by Grek
Europe/Kiev
Last edit: 8 years 11 months ago by Grek.

Please Log in or Create an account to join the conversation.

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
8 years 11 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?

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

More
8 years 11 months ago #148119 by Grek
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
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
8 years 11 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 :)

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.


Powered by Kunena Forum