Keyword

Item Image Field in Database

  • piperchick
  • piperchick's Avatar Topic Author
  • Offline
  • Premium Member
More
14 years 8 months ago #78506 by piperchick
Item Image Field in Database was created by piperchick
Hi,I am trying to solve an issue with the Item Image and I am looking in the phpMyAdmin database to see the reference to the image, but I can't find it in the table jos_k2_items.  Where is it hiding?  The image caption and credits are in that table.Thanks.

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

More
14 years 8 months ago #78507 by Simon Wells
Replied by Simon Wells on topic Item Image Field in Database
I believe that the image info is not stored in the DB.
The images used as the intro image for an item can be found in media/k2/items/src

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

  • piperchick
  • piperchick's Avatar Topic Author
  • Offline
  • Premium Member
More
14 years 8 months ago #78508 by piperchick
Replied by piperchick on topic Item Image Field in Database
Thanks, Simon. You're always so quick to reply.

I'm still trying to work on that image issue.

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

More
14 years 8 months ago #78509 by Simon Wells
Replied by Simon Wells on topic Item Image Field in Database
I try my best ;)

piperchick said:Thanks, Simon. You're always so quick to reply.
I'm still trying to work on that image issue.

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

More
14 years 7 months ago #78510 by Heather
Replied by Heather on topic Item Image Field in Database
Simon, I have a quick question. I moved a small K2 site yesterday from one server to another, and it no longer recognized any of the images as existing. I just reloaded them, since it was a quick solution.

I have a MUCH larger site with thousands of images, which are not convenient to reload all... any ideas on how I can make sure that it actually finds the item images in the cache, since they are not recorded in the database?

Thanks, Heather

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

More
13 years 7 months ago #78511 by Kyriakos Liarakos
Replied by Kyriakos Liarakos on topic Item Image Field in Database
I have the same problem I just move a big portal with more than 5000 images and they are not stored in the database.

Some help please

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

More
13 years 7 months ago #78512 by william white
Replied by william white on topic Item Image Field in Database
Try Akeeba Pro to move the site

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

More
13 years 7 months ago #78513 by Kyriakos Liarakos
Replied by Kyriakos Liarakos on topic Item Image Field in Database
Thank you for your reply,

Akeeba is a great software. Because of the size of the site I had to move it partialy. I found that I had some bad image files that are blocking transfers. Now I'm  tranfering images month by month and its working.

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

More
13 years 6 months ago #78514 by Nick
Replied by Nick on topic Item Image Field in Database
the images are stored in an... interesting way to say the least. it uses md5 encoding and is linked to the item by using the item ID. You can use the md5() function and use 'Image' as a constant and the itemid as the variable. I have a favorites module i wrote myself which uses this code to get the image for the corresponding item:
pastebin.com/gYjURjrX

this is a direct copy paste of the source of my module. It's very simple, but maybe it helps you!

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

More
13 years 1 month ago #78515 by Anas Bouhtouch
Replied by Anas Bouhtouch on topic Item Image Field in Database
Thanks Nick, this helped me :)

P.S: maybe its better to load the image only after a if_file_exist() ^^Nick Tsutsunava said:

the images are stored in an... interesting way to say the least. it uses md5 encoding and is linked to the item by using the item ID. You can use the md5() function and use 'Image' as a constant and the itemid as the variable. I have a favorites module i wrote myself which uses this code to get the image for the corresponding item:http://pastebin.com/gYjURjrXthis is a direct copy paste of the source of my module. It's very simple, but maybe it helps you!

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


Powered by Kunena Forum