Keyword

Database structure

More
4 years 4 months 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.

More
4 years 4 months ago #176464 by JoomlaWorks
Replied by JoomlaWorks 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...

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

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

More
4 years 4 months 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
4 years 4 months 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.

More
4 years 4 months ago #176480 by JoomlaWorks
Replied by JoomlaWorks on topic Database structure
You should ask the template's developer :)

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

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

More
4 years 4 months ago - 4 years 4 months 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: 4 years 4 months ago by Inigo.

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

More
4 years 4 months 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
4 years 4 months 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.

More
4 years 4 months ago #176605 by JoomlaWorks
Replied by JoomlaWorks on topic Database structure
Thanks for the feedback.

Fotis / 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