- Posts: 5
COMMUNITY FORUM
- Forum
- K2 Community Forum
- English K2 Community
- [SOLVED] Item created & published dates change on edit
[SOLVED] Item created & published dates change on edit
- Amy Lewis
-
Topic Author
- Offline
- New Member
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.
- Mario Beck
-
- Offline
- New Member
- Posts: 17
did you manage to solve the problem?
I am experiencing the same
Please Log in or Create an account to join the conversation.
- Yiota
-
- Visitor
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
-
Topic Author
- Offline
- New Member
- Posts: 5
Please Log in or Create an account to join the conversation.
- Yiota
-
- Visitor
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
-
Topic Author
- Offline
- New Member
- Posts: 5
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.
- Mario Beck
-
- Offline
- New Member
- Posts: 17
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
-
- Visitor
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.
- Mario Beck
-
- Offline
- New Member
- Posts: 17
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
-
- Visitor
Please Log in or Create an account to join the conversation.
- Amy Lewis
-
Topic Author
- Offline
- New Member
- Posts: 5
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!
Please Log in or Create an account to join the conversation.
- Mario Beck
-
- Offline
- New Member
- Posts: 17
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
-
- Visitor
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.
- Mario Beck
-
- Offline
- New Member
- Posts: 17
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
-
- Visitor
Please Log in or Create an account to join the conversation.
- Mario Beck
-
- Offline
- New Member
- Posts: 17
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.
- Lefteris
-
- Offline
- Moderator
- Posts: 8743
@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
-
Topic Author
- Offline
- New Member
- Posts: 5
Please Log in or Create an account to join the conversation.
- Mario Beck
-
- Offline
- New Member
- Posts: 17
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.
- Mario Beck
-
- Offline
- New Member
- Posts: 17
Kind Regards
Please Log in or Create an account to join the conversation.
- Forum
- K2 Community Forum
- English K2 Community
- [SOLVED] Item created & published dates change on edit