Keyword

Missing k2_items from database

  • Stamatis
  • Stamatis's Avatar Topic Author
  • Offline
  • Senior Member
  • Athens Day & Night
More
4 years 10 months ago #176123 by Stamatis
Missing k2_items from database was created by Stamatis
Hello

i have this error after update joomla in last vertion

1146 Table 'xxxxxxxx.#__k2_items doesn't exist

In database is not cell k2_items. All other is ok . Do you know why i have this problem?

Thank you

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

More
4 years 10 months ago #176127 by JoomlaWorks
Replied by JoomlaWorks on topic Missing k2_items from database
Someone delete the main table that stores all the item info. 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.

  • Stamatis
  • Stamatis's Avatar Topic Author
  • Offline
  • Senior Member
  • Athens Day & Night
More
4 years 10 months ago #176130 by Stamatis
Replied by Stamatis on topic Missing k2_items from database
Hello Fotis

I have big luck and i had a backup. The strange is that delete only one !

Any way now run ok again.

thank you

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

More
4 years 10 months ago #176132 by JoomlaWorks
Replied by JoomlaWorks on topic Missing k2_items from database
You're welcome.

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

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

  • Stamatis
  • Stamatis's Avatar Topic Author
  • Offline
  • Senior Member
  • Athens Day & Night
More
4 years 10 months ago #176144 by Stamatis
Replied by Stamatis on topic Missing k2_items from database
Hello Fotis

today i had the same thing in other website with k2. I have 3 sites where use k2. in last three months i use Joomgrabber where you suggest me for auto publish article. I think if this is the problem as the only table where they delete is K2_items . Do you have any idea if is it right?

Thank you

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

More
4 years 10 months ago #176148 by JoomlaWorks
Replied by JoomlaWorks on topic Missing k2_items from database
There is probably a bug in that component and ends up deleting your items. You should contact Joomgrabber's developers as soon as possible to have this resolved.

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

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

  • Stamatis
  • Stamatis's Avatar Topic Author
  • Offline
  • Senior Member
  • Athens Day & Night
More
4 years 10 months ago #176202 by Stamatis
Replied by Stamatis on topic Missing k2_items from database
I send them and i waitting for answer. Probably it was a bug because 2 days before i update it in last vertion.

Thank you

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

More
4 years 10 months ago #176212 by JoomlaWorks
Replied by JoomlaWorks on topic Missing k2_items from database
Let us know in any case. Thanks.

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

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

  • Stamatis
  • Stamatis's Avatar Topic Author
  • Offline
  • Senior Member
  • Athens Day & Night
More
4 years 10 months ago #176240 by Stamatis
Replied by Stamatis on topic Missing k2_items from database
Hello Fotis

we unistall the joomGrabber and we left the site for one week stable. Today the k2_items table again deleted. We search what happent but the only component that now run is k2 & JBDirectory . Is possible k2 hacked into our site?

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

More
4 years 10 months ago #176244 by JoomlaWorks
Replied by JoomlaWorks on topic Missing k2_items from database
As far as I know (the VEL included), K2 has no known vulnerabilities (never really had any to be honest). It's rock solid.

Perhaps there's a leftover system plugin or cron job that deletes the content. Or if your site is indeed hacked as you say, it's most likely through some other extension.

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

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

  • Stamatis
  • Stamatis's Avatar Topic Author
  • Offline
  • Senior Member
  • Athens Day & Night
More
4 years 9 months ago - 4 years 9 months ago #176357 by Stamatis
Replied by Stamatis on topic Missing k2_items from database
Hello Foti

The poblem it was from JoomGrabber. We sent them tha they have some hole inside component or with cron job
they tell as that it will fix it from 10-6-20. Steel waitting. Any way thank you
Last edit: 4 years 9 months ago by Stamatis.

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

More
4 years 9 months ago #176360 by JoomlaWorks
Replied by JoomlaWorks on topic Missing k2_items from database
Sorry for the bad news :(

In any case it's good that you pinpointed the issue.

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

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

  • Stamatis
  • Stamatis's Avatar Topic Author
  • Offline
  • Senior Member
  • Athens Day & Night
More
4 years 9 months ago #176569 by Stamatis
Replied by Stamatis on topic Missing k2_items from database
Hello fotis

I try to use again this component after 8 day again the same. in data base i take this error mesage

/libraries/classes/Dbi/DbiMysqli.php#199: mysqli->query(
string 'SELECT COUNT(*) FROM `mydatabase`.`kos_k2_items`',
integer 0,
)
./libraries/classes/DatabaseInterface.php#316: PhpMyAdmin\Dbi\DbiMysqli->realQuery(
string 'SELECT COUNT(*) FROM `mydatabase`.`kos_k2_items`',
,
integer 1,
)
./libraries/classes/DatabaseInterface.php#1698: PhpMyAdmin\DatabaseInterface->tryQuery(
string 'SELECT COUNT(*) FROM `mydatabase`.`kos_k2_items`',
integer 256,
integer 1,
boolean false,
)
./libraries/classes/Table.php#766: PhpMyAdmin\DatabaseInterface->fetchValue(string 'SELECT COUNT(*) FROM `mydatabase`.`kos_k2_items`')
./libraries/classes/Controllers/Database/StructureController.php#1065: PhpMyAdmin\Table->countRecords(boolean true)
./libraries/classes/Controllers/Database/StructureController.php#931: PhpMyAdmin\Controllers\Database\StructureController->getValuesForInnodbTable(
array,
integer 92845121,
)
./libraries/classes/Controllers/Database/StructureController.php#381: PhpMyAdmin\Controllers\Database\StructureController->getStuffForEngineTypeTable(
array,
integer 92845121,
integer 24,
)
./libraries/classes/Controllers/Database/StructureController.php#172: PhpMyAdmin\Controllers\Database\StructureController->displayTableList()
./db_structure.php#56: PhpMyAdmin\Controllers\Database\StructureController->index(array)
./index.php#101: include(./db_structure.php)

is this because the k2_item again deleteted?

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

More
4 years 9 months ago #176575 by JoomlaWorks
Replied by JoomlaWorks on topic Missing k2_items from database
This seems like a phpMyAdmin related issue which you'll need to sort out before checking your site's DB tables...

Unless you fully control the server, you should probably contact your hosting provider for that.

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