Keyword

SQL queries to create new K2 item

  • jabeznika
  • jabeznika's Avatar Topic Author
  • Offline
  • New Member
More
7 years 4 months ago #163135 by jabeznika
SQL queries to create new K2 item was created by jabeznika
Hello!

I'm sorry if my question isn't new, but...

When we create new k2 item in admin panel, which sql queries are affected?

Only "INSERT into ##_k2_items (bla bla bla)" or there are another DB tables to fill?

It is imortant for me, because I want to export DB from other site to Joomla/K2 site (with CSV).

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

  • Ronny Van Der Borght
  • Ronny Van Der Borght's Avatar
  • Offline
  • Senior Member
More
7 years 3 months ago #163232 by Ronny Van Der Borght
Replied by Ronny Van Der Borght on topic SQL queries to create new K2 item

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

  • jabeznika
  • jabeznika's Avatar Topic Author
  • Offline
  • New Member
More
7 years 3 months ago - 7 years 3 months ago #163253 by jabeznika
Replied by jabeznika on topic SQL queries to create new K2 item
Thank you. Maybe it is one of solutions.

I found answer.

We need to find mysql configuration file and add these:
general_log_file = /var/log/mysql/mysql.log
general_log = 1
after than restart server.

mysql.log file shows all SQL requests from Joomla site.

So K2 fills only "_k2_items" table at "new item" action.
Last edit: 7 years 3 months ago by jabeznika.

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

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
7 years 3 months ago #163268 by Krikor Boghossian
Replied by Krikor Boghossian on topic SQL queries to create new K2 item
It is not that simple. You will need to update the references to categories, tags, users. I think K2 Import should be preferred.

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