Keyword

Empty Category Listing

  • Carlos Bahiana
  • Carlos Bahiana's Avatar Topic Author
  • Offline
  • New Member
More
8 years 2 months ago #156221 by Carlos Bahiana
Replied by Carlos Bahiana on topic Empty Category Listing
Some improvement

I created a new category and moved some of the items to it. No result.

Then I started opening and saving one by one. Those show up.

The problem is: I have more then 6000 items...

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

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
8 years 2 months ago #156230 by Krikor Boghossian
Replied by Krikor Boghossian on topic Empty Category Listing
This indicates that something went really wrong during the migration (captain obvious once again).

I think at this point, you might need to re-run the migration script.
Before you do this however make sure to backup.

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

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

  • Carlos Bahiana
  • Carlos Bahiana's Avatar Topic Author
  • Offline
  • New Member
More
8 years 2 months ago #156239 by Carlos Bahiana
Replied by Carlos Bahiana on topic Empty Category Listing
I'll give it a try, but I might get to where I am again.

It would be great to have a script automating the open-save-close routine, that would certainly do.

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

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
8 years 2 months ago #156244 by Krikor Boghossian
Replied by Krikor Boghossian on topic Empty Category Listing
Try the following:
Open phpMyAdmin or an equivalent software.
Go to the #_k2_items table and check an unsaved item's row.
Save it and see which aspects have been changed.
This way you can see which cells and values where affected and you can build your SQL script.

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

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

  • Carlos Bahiana
  • Carlos Bahiana's Avatar Topic Author
  • Offline
  • New Member
More
8 years 2 months ago - 8 years 2 months ago #156439 by Carlos Bahiana
Replied by Carlos Bahiana on topic Empty Category Listing
Finally got it!

The field "language" cannot be empty, and all were. After an update k2_items set language = "*" all is good again!
Last edit: 8 years 2 months ago by Carlos Bahiana. Reason: Forgot to include the field name

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

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
8 years 2 months ago #156446 by Krikor Boghossian
Replied by Krikor Boghossian on topic Empty Category Listing
Nice to hear this Carlos :)
Kudos for your hard work!

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