Advertisement:

Author Topic: Error with pictures  (Read 2034 times)

kingsult

  • Premium
  • Full Member
  • *****
  • Posts: 204
Error with pictures
« on: May 06, 2011, 11:16:14 pm »
Hi,

I have a bug with the pictures on my site. When someone posts an ad, the link to the picture is broken.

I have checked my ftp and saw that every new ad, produces an image called 0_thumbnail.png 0.png etcetera...

Any idea how to solve it ?

Thx

kingsult

  • Premium
  • Full Member
  • *****
  • Posts: 204
Re: Error with pictures
« Reply #1 on: May 06, 2011, 11:27:17 pm »
Checked my db in the table t_item_resources

Ads are created but there is no information about the picture... strange strange...

s_name, s_path, etc... are all empty

Juan Ramón

  • Osclass Developer
  • Hero Member
  • *****
  • Posts: 2382
Re: Error with pictures
« Reply #2 on: May 07, 2011, 02:30:34 am »
wow... strange...

Can you make a couple of changes in your t_item_resource structure?

You should convert s_name and s_content_type to allow null values. So, now we'll be four fields that will allow null values: s_name, s_extension, s_content_type and s_path.

kingsult

  • Premium
  • Full Member
  • *****
  • Posts: 204
Re: Error with pictures
« Reply #3 on: May 07, 2011, 02:40:37 am »
Ok done... no result. I tried to update an ad and upload a picture... and nothing appears...

kingsult

  • Premium
  • Full Member
  • *****
  • Posts: 204
Re: Error with pictures
« Reply #4 on: May 07, 2011, 02:51:57 am »
I have done a clean install and see that I don't have a primary key in my table...
will try tomorrow

any other idea where it might come from ?

kingsult

  • Premium
  • Full Member
  • *****
  • Posts: 204
Re: Error with pictures
« Reply #5 on: May 08, 2011, 07:03:13 am »
Ok problem solved... My DB table contained some errors. It didn't have a primary key and the default value for the key was 0...

Thanks,

Juan Ramón

  • Osclass Developer
  • Hero Member
  • *****
  • Posts: 2382
Re: Error with pictures
« Reply #6 on: May 09, 2011, 10:11:23 pm »
Great to hear that you solved the problem!