Category Avatar URLs

[pkilchermann]

Hey Guys,

I'm setting up a new install of Classifieds, and am having trouble getting category avatar's to appear.

I change the line "Category Avatar File Path:" to my avatar's URL: http://www.holstertrade.com/trade/avatars/1911.jpg

..But it still doesn't show up... It resets to '0' every time I save the changes.

Any ideas? I want it to look like this site, with the avatar to the left of the categories: http://www.photopost.com/class/sites...ieds/index.php

THANKS guys!

Pat

[Chuck S]

http://www.holstertrade.com/trade/index.php

What have you been changing on your site why is your database connection not up?

[Chuck S]

http://www.holstertrade.com/trade/index.php

[srob]

Hi Chuck:

I am having the very same problem..... I enter the url to the avatar but it still doesn't show up... It resets to '0' every time I save the changes.

What should I do?

Thanks,
Steve

[Chuck S]

try running the 2.6 upgrade script and see if this helps.

[CGMathis]

I just upgraded to 3.03 and it won't work for me either.

[Chuck S]

Did you run the 2.6 upgrade?

That changes the thumbnail field from int to varchar and is needed for this new feature to work

[CGMathis]

Originally Posted by Chuck S

Did you run the 2.6 upgrade?

That changes the thumbnail field from int to varchar and is needed for this new feature to work

I'm confused. I was running 2.6 (and it didn't work) before I upgraded to 3.03. Why would I run an "old" upgrade script to make 3.03 work?

How do I run the 2.6 upgrade on 3.03?

[Chuck S]

What do you mean it did not work?

You told me you just upgraded to classifieds 3.x series so the natural order would be to run the upgrade script which is why I asked. In that upgrade is a query that changes the value of the field meantioned and why it must be ran.

[CGMathis]

Originally Posted by Chuck S

What do you mean it did not work?

You told me you just upgraded to classifieds 3.x series so the natural order would be to run the upgrade script which is why I asked. In that upgrade is a query that changes the value of the field meantioned and why it must be ran.

I don't know anything about the scripts or how they work. All I can tell you is this...

When I was using 2.6, it did not work. I'm now using 3.03 and it still does not work.

I would think that 3.03 would have all the features included?

[Chuck S]

It does work and I think you are not understanding why I am saying run that upgrade. For the feature to store a url in edit categories your thumbnail column must be varchar not int as it was pre 3.0

Content visible to verified customers only.

This query is right in the upgrade script for 2.6 to 3.0 and it changes the field I noted to varchar which would be correct for this to work.

Is your url more than 125 characters?

[CGMathis]

Originally Posted by Chuck S

It does work and I think you are not understanding why I am saying run that upgrade. For the feature to store a url in edit categories your thumbnail column must be varchar not int as it was pre 3.0

Content visible to verified customers only.

This query is right in the upgrade script for 2.6 to 3.0 and it changes the field I noted to varchar which would be correct for this to work.

I ran the 2.6 upgrade script when I upgraded from 2.6 to 3.03. Are you saying run it again?

Maybe just tell me exactly what I should do at this point to make it work?

Is there a query I can run in phpMyAdmin?

Is your url more than 125 characters?

It's 75 characters.

[Chuck S]

If you know how to navigate in phpmyadmin you can tell me if the thumbnail column in the categories table is a varchar field of 125 characters. This is the query I showed it above.

ALTER TABLE cp_categories CHANGE thumbnail thumbnail VARCHAR(125) DEFAULT NULL;

[CGMathis]

Originally Posted by Chuck S

If you know how to navigate in phpmyadmin you can tell me if the thumbnail column in the categories table is a varchar field of 125 characters. This is the query I showed it above.

ALTER TABLE cp_categories CHANGE thumbnail thumbnail VARCHAR(125) DEFAULT NULL;

My tables have a prefix of "pp_", not "cp_" (that's how it was installed) and I don't see a field called "varchar".

[Chuck S]

Your table should have a field called thumbnail and it should be varchar if the upgrade has been ran and the feature will work if this is done.


ALTER TABLE pp_categories CHANGE thumbnail thumbnail VARCHAR(125) DEFAULT NULL;

[Chuck S]

Main Index - PhotoPost Classifieds

It will work fine if your thumbnail field is varchar not int and the 2.6 upgrade changes the field

ALTER TABLE pp_categories CHANGE thumbnail thumbnail VARCHAR(125) DEFAULT NULL;

I have show above using my avatar here on this site it works. So since your use to phpmyadmin does the pp_categories table field thumbnail set to varchar?

what is the site we are talking about here?

[CGMathis]

Originally Posted by Chuck S

So since your use to phpmyadmin does the pp_categories table field thumbnail set to varchar?

Yes.

Here's a screen shot. http://www.muzzleloadingforum.com/gr.../thumbnail.jpg

[Chuck S]

Thats a bad link apparently. As my link has shown this feature does work and you can send info to the contact link in our header if you want me to take a look at your site.

[CGMathis]

Originally Posted by Chuck S

Thats a bad link apparently. As my link has shown this feature does work and you can send info to the contact link in our header if you want me to take a look at your site.

The link works for me (and others), but I used the "contact us" at the top of the page, as you suggested.

http://www.muzzleloadingforum.com/gr.../thumbnail.jpg

[Chuck S]

I get some haha got ya no peeking thing probally some mod rewrite you got going on. I will check out your site with the info you sent since I have shown you it works quite easily its gotta be something simple