- Posts: 133
COMMUNITY FORUM
Item Image Field in Database
- piperchick
-
Topic Author
- Offline
- Premium Member
Less
More
15 years 3 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.
- Simon Wells
-
- Offline
- Platinum Member
Less
More
- Posts: 955
15 years 3 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
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
-
Topic Author
- Offline
- Premium Member
Less
More
- Posts: 133
15 years 3 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.
I'm still trying to work on that image issue.
Please Log in or Create an account to join the conversation.
- Simon Wells
-
- Offline
- Platinum Member
Less
More
- Posts: 955
15 years 3 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.
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.
- Heather
-
- Offline
- Junior Member
Less
More
- Posts: 35
15 years 2 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
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.
- Kyriakos Liarakos
-
- Offline
- New Member
Less
More
- Posts: 2
14 years 2 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
Some help please
Please Log in or Create an account to join the conversation.
- william white
-
- Offline
- Platinum Member
Less
More
- Posts: 3722
14 years 1 month 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.
- Kyriakos Liarakos
-
- Offline
- New Member
Less
More
- Posts: 2
14 years 1 month 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.
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.
- Nick
-
- Offline
- Elite Member
Less
More
- Posts: 190
14 years 1 month 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!
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.
- Anas Bouhtouch
-
- Offline
- New Member
Less
More
- Posts: 1
13 years 7 months 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!
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.
- Igor
-
- Offline
- New Member
Less
More
- Posts: 1
12 years 8 months ago #78516
by Igor
Replied by Igor on topic Re: Item Image Field in Database
HOW I link the record in the table jos_k2_items with the image I have in media/k2/items/src ????
Please Log in or Create an account to join the conversation.
- william white
-
- Offline
- Platinum Member
Less
More
- Posts: 3722
12 years 8 months ago #78517
by william white
Replied by william white on topic Re: Item Image Field in Database
Check the above posts and the code in pastibin
Please Log in or Create an account to join the conversation.