Keyword

[SOLVED] Item created & published dates change on edit

  • Amy Lewis
  • Amy Lewis's Avatar Topic Author
  • Offline
  • New Member
More
11 years 3 months ago #122891 by Amy Lewis
I've used K2 on many sites over the years and I've never had anything like this happen and just noticed it this morning.

I created an item and noticed that it was giving an error when the menu item was clicked. When I went back to the item list it showed as pending. I reopened the item changed the 'Start Publishing' date to today and then it worked fine. Performed some edits, saved, and again got an error from the link on the frontend. When I opened the item again, the publish date had changed.

I opened then saved the item multiple times and each time I reopen the item, the Create Date and Start Publishing date advance by 8 hours. The same thing happens with older items that I open.

Tried reinstalling K2 and it didn't help.

Hoping someone can point me toward a solution. Thank you!

Joomla version 3.2.1
k2 version 2.6.7

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

More
11 years 2 months ago #122892 by Mario Beck
Replied by Mario Beck on topic Re: Item created & published dates change on edit
Hi Amy,

did you manage to solve the problem?
I am experiencing the same

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

  • Yiota
  • Yiota's Avatar
  • Visitor
11 years 2 months ago #122893 by Yiota
@Amy Lewis,

Try to update to the K2 2.6.8 SVN version if you are using Joomla 3.2.1 version and check again. You can find the new K2 package here: getk2.org/assets/get/

@Mario Beck, I have already suggested you do the same in your topic.

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

  • Amy Lewis
  • Amy Lewis's Avatar Topic Author
  • Offline
  • New Member
More
11 years 2 months ago #122894 by Amy Lewis
Hi Yiota. Thanks for your reply. I installed the new package as you suggested but the problem is still occurring. Is there something else I could try?

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

  • Yiota
  • Yiota's Avatar
  • Visitor
11 years 2 months ago #122895 by Yiota
Try to check on a new item.
Also before that try to also do this

In Joomla Admin area go to Extension Manager > Discover (side bar nav)
Click on the "Discover" button at the top.
Find all of the K2 files that weren't installed and select them. Click on "Install" button at the top.
Go back to Extension Manager > Install
Reinstall the K2 SVN version zip file on top of your old installation.

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

  • Amy Lewis
  • Amy Lewis's Avatar Topic Author
  • Offline
  • New Member
More
11 years 2 months ago - 11 years 2 months ago #122896 by Amy Lewis
I found 4 files in the Discover list and installed them, then reinstalled K2 v2.6.8 (Dev Build).

Created a new item and saved it. Then saved it again and the create date and publish date both advanced by 8 hours each time I click save.

Sorry, it didn't work. :( What's next? ;)

EDITED to add:
Also I have the following error on the Control panel page now:
An error has occurred.
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM ulrw_k2_items as i LEFT JOIN ulrw_k2_categories AS c ON c.id = i.c' at line 1 SQL=SELECT i.*, v.name AS author, (SELECT COUNT(*) FROM ulrw_k2_comments WHERE itemID = i.id) AS numOfComments, FROM ulrw_k2_items as i LEFT JOIN ulrw_k2_categories AS c ON c.id = i.catid LEFT JOIN ulrw_users AS v ON v.id = i.created_by WHERE i.trash = 0 AND c.trash = 0 ORDER BY numOfComments DESC LIMIT 0, 10

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

More
11 years 2 months ago #122897 by Mario Beck
Replied by Mario Beck on topic Re: Item created & published dates change on edit
Same here.. updated Joomla to the latest version and installed the K2_DEV_BUILD but still doesn't work.
Getting this warning message when entering a K2 Item

Error loading component: C:\inetpub\wwwroot\joomla\administrator\components\com_k2, Component not found

Thanks Kind Regards

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

  • Yiota
  • Yiota's Avatar
  • Visitor
11 years 2 months ago #122898 by Yiota
@Amy

Go to Extension Manager -> Database -> Fix.
Make sure that you have the correct settings both in Global configuration and user for the timezone.

@Mario

Have you tried to run the discover first?
It seems that your issue is that something has gone wrong in the installation.
Also, what Joomla version do you use and from what K2 version did you update to the 2.6.8 SVN?

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

More
11 years 2 months ago #122899 by Mario Beck
Replied by Mario Beck on topic Re: Item created & published dates change on edit
Hi yes I did,

installed all missing parts I could discover. I am using Joomla 3.2.2 and I've updated from K2 version 2.6.7
What I have recognized was... after updating to K2 2.6.8 I wasn't able to access my backend any longer.. i don't mean the login process.. the backend site was not accessible at all means the browser couldn't load it. I've checked the php error logs but there were no statement. I've made a backup with akeeba before so I've got my site back online, but that was a shock ;-)

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

  • Yiota
  • Yiota's Avatar
  • Visitor
11 years 2 months ago #122900 by Yiota
I have never heard that one before. You need to try and update again even in a local server and see what could have caused the issue. Try to enable error reporting from configuration.php file.

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

  • Amy Lewis
  • Amy Lewis's Avatar Topic Author
  • Offline
  • New Member
More
11 years 2 months ago #122901 by Amy Lewis
@Yiota

Thank you. I did the database Fix and also added the time zone to my user account (it was previously set to default) One of those things seems to have fixed the problem with the time stamp advancing on K2 items. I created a new item, saved it, reopened it and the time stamp stayed the same. Also opened an existing article and saved with the same result. Thank you!

I do still have that error on the Control Panel that I reported earler (1064) and the K2 icons which normally appear on the left side of the screen are all jumbled up in the top left corner of the screen. I've attached a screenshot so you can see it. Any ideas?

Thank you!
Attachments:

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

More
11 years 2 months ago #122902 by Mario Beck
Replied by Mario Beck on topic Re: Item created & published dates change on edit
Hi,

i've adjusted the time zone as well and did a database fix, unfortunately this didn't do it for me.

Also I have tried another time to update the K2 version and the same happens. Backend can't be found any longer, 404 error. I've enabled the error reporting, but there are no entries...puuh.. any idea where to check for the solution? maybe there is a wrong path in the database?

Iam using IIS 7.5, PHP 5.4.14 and Template is JSN Epic Pro

Thanks in advance

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

  • Yiota
  • Yiota's Avatar
  • Visitor
11 years 2 months ago #122903 by Yiota
@Amy

It is strange that this error comes up in your dashboard even though you had made a Database fix. Do you still get this error if you Disable the K2 Quick Icons (admin) module from the Extensions list for the administrator?
Check that and let me know.

@Mario

Did you check in your server's error log to see if any error popups up when you get the 404 page?

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

More
11 years 2 months ago #122904 by Mario Beck
Replied by Mario Beck on topic Re: Item created & published dates change on edit
Hi,

yes I did. I don't understand that, there are no entries about that at all.. so I've installed the backup again.
Maybe I've found something interesting. When I click on discover there are four K2 entries (I'll need to check again for the name of the entries) and when I click on enable I get the following notice, anyway the plugins seem to be enabled afterwards:

Warning

JFolder: :files: Path is not a folder. Path: C:\inetpub\wwwroot\joomla\plugins\josetta_ext\definitions

JFolder: :files: Path is not a folder. Path: C:\inetpub\wwwroot\joomla\plugins\josetta_ext\definitions

JInstaller: :Install: Cannot find XML setup file

JFolder: :files: Path is not a folder. Path: C:\inetpub\wwwroot\joomla\plugins\josetta_ext\definitions

JFolder: :files: Path is not a folder. Path: C:\inetpub\wwwroot\joomla\plugins\josetta_ext\definitions

JInstaller: :Install: Cannot find XML setup file

JFolder: :files: Path is not a folder. Path: C:\inetpub\wwwroot\joomla\plugins\josetta_ext\definitions

JFolder: :files: Path is not a folder. Path: C:\inetpub\wwwroot\joomla\plugins\josetta_ext\definitions

JInstaller: :Install: Cannot find XML setup file

JFolder: :files: Path is not a folder. Path: C:\inetpub\wwwroot\joomla\plugins\josetta_ext\definitions

JFolder: :files: Path is not a folder. Path: C:\inetpub\wwwroot\joomla\plugins\josetta_ext\definitions

JInstaller: :Install: Cannot find XML setup file

JFolder: :files: Path is not a folder. Path: C:\inetpub\wwwroot\joomla\plugins\josetta_ext\definitions

JFolder: :files: Path is not a folder. Path: C:\inetpub\wwwroot\joomla\plugins\josetta_ext\definitions

JInstaller: :Install: Cannot find XML setup file

JFolder: :files: Path is not a folder. Path: C:\inetpub\wwwroot\joomla\plugins\josetta_ext\definitions

JFolder: :files: Path is not a folder. Path: C:\inetpub\wwwroot\joomla\plugins\josetta_ext\definitions

JInstaller: :Install: Cannot find XML setup file

JFolder: :files: Path is not a folder. Path: C:\inetpub\wwwroot\joomla\plugins\josetta_ext\definitions

JFolder: :files: Path is not a folder. Path: C:\inetpub\wwwroot\joomla\plugins\josetta_ext\definitions

JInstaller: :Install: Cannot find XML setup file

JFolder: :files: Path is not a folder. Path: C:\inetpub\wwwroot\joomla\plugins\josetta_ext\definitions

JFolder: :files: Path is not a folder. Path: C:\inetpub\wwwroot\joomla\plugins\josetta_ext\definitions

JInstaller: :Install: Cannot find XML setup file



Also, as already mentioned before i always get following warning when accessing an K2 Item:

Warning

Error loading component: C:\inetpub\wwwroot\joomla\administrator\components\com_k2, Component not found

Error loading component: C:\inetpub\wwwroot\joomla\administrator\components\com_k2, Component not found

Error loading component: C:\inetpub\wwwroot\joomla\administrator\components\com_k2, Component not found

Error loading component: C:\inetpub\wwwroot\joomla\administrator\components\com_k2, Component not found

Error loading component: C:\inetpub\wwwroot\joomla\administrator\components\com_k2, Component not found

Error loading component: C:\inetpub\wwwroot\joomla\administrator\components\com_k2, Component not found

Error loading component: C:\inetpub\wwwroot\joomla\administrator\components\com_k2, Component not found

Error loading component: C:\inetpub\wwwroot\joomla\administrator\components\com_k2, Component not found

Error loading component: C:\inetpub\wwwroot\joomla\administrator\components\com_k2, Component not found

Error loading component: C:\inetpub\wwwroot\joomla\administrator\components\com_k2, Component not found

Error loading component: C:\inetpub\wwwroot\joomla\administrator\components\com_k2, Component not found

Error loading component: C:\inetpub\wwwroot\joomla\administrator\components\com_k2, Component not found

Error loading component: C:\inetpub\wwwroot\joomla\administrator\components\com_k2, Component not found

Error loading component: C:\inetpub\wwwroot\joomla\administrator\components\com_k2, Component not found

Error loading component: C:\inetpub\wwwroot\joomla\administrator\components\com_k2, Component not found



Thank you very much for helping us

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

  • Yiota
  • Yiota's Avatar
  • Visitor
11 years 2 months ago #122905 by Yiota
You get this warning, Error loading component: C:\inetpub\wwwroot\joomla\administrator\components\com_k2, Component not found, even though you got no errors when updating K2?

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

More
11 years 2 months ago - 11 years 2 months ago #122906 by Mario Beck
Replied by Mario Beck on topic Re: Item created & published dates change on edit
Yes :-/

this is what i've found out while trying to troubleshoot on my Virtual machine with xampp...
after updating to the k2_dev_build i get back the following SQL error, i am sorry, that's all i can deal with :-/

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM j3_k2_items as i LEFT JOIN j3_k2_categories AS c ON c.id = i.catid' at line 1 SQL=SELECT i.*, v.name AS author, (SELECT COUNT(*) FROM j3_k2_comments WHERE itemID = i.id) AS numOfComments, FROM j3_k2_items as i LEFT JOIN j3_k2_categories AS c ON c.id = i.catid LEFT JOIN j3_users AS v ON v.id = i.created_by WHERE i.trash = 0 AND c.trash = 0 ORDER BY numOfComments DESC LIMIT 0, 10

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

More
11 years 2 months ago #122907 by Lefteris
@Mario Beck
@Amy Lewis

The K2 dev version is updated every day. Probably you got a copy which contains an incorrect SQL query. Please grab a new copy from getk2.org/assets/get/ and install again. Time problem as well as SQL error should be gone. Please let me know if your issues have been resolved.

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

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

  • Amy Lewis
  • Amy Lewis's Avatar Topic Author
  • Offline
  • New Member
More
11 years 2 months ago #122908 by Amy Lewis
Uploaded the newest dev version and all errors are gone. Thank you!

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

More
11 years 2 months ago #122909 by Mario Beck
Replied by Mario Beck on topic Re: Item created & published dates change on edit
Hi,

I have uploaded the latest version and the backend works fine, but unfortunately this didn't solve the item pending issue. I sill can see the error message component could not be found.. on the other hand, beside of these two things k2 is working fine. Is there anything else I can do from my side ?

Thank you very much

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

More
11 years 2 months ago #122910 by Mario Beck
Replied by Mario Beck on topic Re: Item created & published dates change on edit
Any Idea left?

Kind Regards

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


Powered by Kunena Forum