Keyword

Database structure

More
1 month 3 days ago #176455 by Inigo
Database structure was created by Inigo
Hello, iwhere in the database can I find K2_items? There are k2_attachments, k2_categories, k2_comments, etc, but no table for k2_items.

Thank you,
Attachments:

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

  • Fotis
  • Fotis's Avatar
  • Offline
  • Administrator
  • JoomlaWorks Support Team
More
1 month 3 days ago #176464 by Fotis
Replied by Fotis on topic Database structure
Unless the #__k2_items table uses a different prefix, it's apparently deleted from your database... I hope you have a backup...

If you use & love K2, please take a moment to add your review and rate it
at the Joomla Extensions Directory: extensions.joomla.org/extension/k2/


IMPORTANT: Please search the forum before posting a question!

JoomlaWorks Support Team Member

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

More
1 month 3 days ago #176466 by Inigo
Replied by Inigo on topic Database structure
No, no, the data is there, it has always been there. I am using a News247 demo version as a base.

themeforest.net/item/news247-responsive-news-magazine-newspaper/19611203

Maybe it had the k2_items table prefix changed, that is why. I will have a closer look and try to find it, it has to be there.

Thanks a lot!!

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

More
1 month 3 days ago #176467 by Inigo
Replied by Inigo on topic Database structure
Hello again, do you know if there a way I can find the k2_items prefix using web inspector? Or maybe any other way? I had a look at the DB but I can´t find it. The website is TodoTarifa.com

Thank you,

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

  • Fotis
  • Fotis's Avatar
  • Offline
  • Administrator
  • JoomlaWorks Support Team
More
1 month 1 day ago #176480 by Fotis
Replied by Fotis on topic Database structure
You should ask the template's developer :)

If you use & love K2, please take a moment to add your review and rate it
at the Joomla Extensions Directory: extensions.joomla.org/extension/k2/


IMPORTANT: Please search the forum before posting a question!

JoomlaWorks Support Team Member

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

More
3 weeks 1 day ago - 3 weeks 1 day ago #176576 by Inigo
Replied by Inigo on topic Database structure
I did and they suggested me to ask you...

www.joomlaworks.net/forum/k2-en/54696-database-structure#176576

I was wondering if there is a way using developer´s tools or else to find any given database table´s name. Because in principal, the k2 item´s content could not be properly display if it´s table is missing, right? But in this case the k2 item´s content is being displayed properly as you can see in www.todotarifa.com

Attachments:
Last edit: 3 weeks 1 day ago by Inigo.

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

More
2 weeks 5 days ago #176584 by Inigo
Replied by Inigo on topic Database structure
It is very weird. All the info is there in the frontend, but the _k2_items is gone. How could this be? I have double-checked the Joomla Admin > Global Configuration > Database Configuration to make sure I am looking at he correct DB. I have done a search for "items" in the DB and no table corresponding to K2 items found, not even with a different name.

My only hope is if someone could tell me how to track a DB table from the front end or from Joomla´s admin using some kind of webmaster´s tool or something. Anyone, please? Thank you so much.

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

More
2 weeks 5 days ago #176593 by Inigo
Replied by Inigo on topic Database structure
Well, I haven´t found the why but I found the how. The table is in fact there as I always suspected. It does not show up in the left column, but when doing a search the table shows up in the available tables window. It is as if the table is hidden or something for some reason.

Problem solved, don´t know why it happens but at least I can work on the table.
Attachments:

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

  • Fotis
  • Fotis's Avatar
  • Offline
  • Administrator
  • JoomlaWorks Support Team
More
2 weeks 4 days ago #176605 by Fotis
Replied by Fotis on topic Database structure
Thanks for the feedback.

If you use & love K2, please take a moment to add your review and rate it
at the Joomla Extensions Directory: extensions.joomla.org/extension/k2/


IMPORTANT: Please search the forum before posting a question!

JoomlaWorks Support Team Member

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


Powered by Kunena Forum