Sold Ads not showing

laidback64 · April 30th, 2010, 08:26 AM

I marked one of my ads as sold and it disappeared. It did add the dollar amount of the ad to the total amount sold and it did add the ad to total ads sold, which is one.

If you go to the section were the ad was listed, it still shows I have one ad in it, but when you click on the ad nothing shows up.

Is this what it is suppose to do? I have the amount of days a sold ad stays visible as 90.

My site is Main Index - Semo Sales Classifieds and the section is Toys, username Jasper.

You can post a test ads under the username of Test, password is password.

Chuck S · April 30th, 2010, 10:02 AM

HMM I wonder here.

This query in editproduct.php try removing the code in bold then place a test ad and mark it sold. is it viewable?

Code:

Content visible to verified customers only.

laidback64 · April 30th, 2010, 11:04 AM

I did that and this is the error code I received:

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: UPDATE cp_products SET status='1272643455',WHERE id=15

Result: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id=15' at line 1

Database handle: Resource id #26

Chuck S · April 30th, 2010, 01:15 PM

You did not remove ALL of what I bolded

There needs to be a space between the ' and the WHERE and the comma gets removed.

Code:

Content visible to verified customers only.

laidback64 · April 30th, 2010, 08:21 PM

Sorry, my mistake. I did it right this time and it worked. Thank You!

Chuck S · April 30th, 2010, 09:31 PM

enjoy your weekend

Badger · May 4th, 2010, 10:14 AM

Same question, as I may have a problem, so I ran a test ...

I just closed the ad below ...

It added to the ad count and total dollars, but after leaving the screen showing immediately after having "Sold it", I can't find it any more?

Second, looking at the ad below, even if I could find it again, how does anyone know from viewing it that the ad is indeed CLOSED?

Thanks Chuck ...

Regards,
Doug

Chuck S · May 4th, 2010, 10:29 AM

Doug

You can do the edit stated above and do a test.

also make sure the option in admin to show sold ads has something more than 0 in it.

Badger · May 4th, 2010, 10:37 AM

I made the same edit as recommended and after doing another "Sold it", now the SOLD ad appears in the search but the Navbar starts to act up afterwards, or maybe that bug was there all the time? See pics..

Regards,
Doug

Badger · May 4th, 2010, 10:38 AM

Quote:

Originally Posted by Chuck S

Doug

You can do the edit stated above and do a test.

also make sure the option in admin to show sold ads has something more than 0 in it.

It has 30 days in it ...

Be back later .. have a meeting..

Regards,
Doug

Chuck S · May 4th, 2010, 10:40 AM

no problem have fun at your meeting.

Badger · May 4th, 2010, 12:39 PM

Ok, I'm back ...

Any idea why it's substituting the word "Personals" instead of "Home" when a personals ad is selected?

Something to do with the fact that it's a "SOLD" item?

... or, we changed the template as indicated?

Thanks ...

Regards,
Doug

Chuck S · May 4th, 2010, 12:47 PM

Home would be replaced with personals if you where set to use the personals template set for a category. Try looking language files in your languages/english directory at the various php language files and see where that sting is that has the wording you wish and change it to read Home instead of personals.

Badger · May 4th, 2010, 01:03 PM

Ok, I'm not explaining this well ...

When one selects any ad from the listing of ads (say ALL ads) and clicks on it, the screen changes to a display of that individual ad. In all cases for EVERY category, the word "Home" remains on the Classfieds navbar to the left of "Members List".

ONLY when a user selects the ad that is in the "Personals" category, as in the example in the pics above, does the word "Home" in the Classfieds navbar to the left of "Members List", change to "Personals"....

The only unusual thing about thing about that particular ad, is that it's a "SOLD" ad and we had previously edited the template as you indicated in the previous posts to the other user here, so we could even get SOLD ads to show.

Is that a clearer explanation?

Sorry about that ...

Regards,
Doug

Chuck S · May 4th, 2010, 01:24 PM

I know what you mean

If the ad is selected as I stated where ever if your viewing an ad thats in a personals category then the word home should turn to personals.

Overwriting base wording is done as posted in my last post your languages/english subdirectory you have script files which override default wording by loading a secondary language file

You will find the phrase you want to change in the languages/english/showproduct2.php file. The wording used is based on the ad type you select to assign to a category. Did you mean to setup that category as a Personals Template Type?

Badger · May 4th, 2010, 02:11 PM

Ok, I need to go away and examine each category as set up, to better understand what you're saying ....

I'll be back ...

Regards,
Doug

Chuck S · May 4th, 2010, 02:44 PM

Yes you will see what I mean. The ad category that ad is placed has the ad type under edit categories for that cat set to Personals ad type.

If you go to Admin => Ad Types you will see the listed ad types.

0 -- For Sale
1 -- Wanted
2 -- Personals
3 -- Help Wanted
4 -- Business

That is the default ad types under our Ad types in admin.

Thus when you set a category to the personals type we load the appropriate ad type language file which overrides the master phrases and allows you to have different ad types with different wording. Same thing also you already learning your templates a few of them have numerical ones which are used to provide a different layout it works the same for language phrasing.

Badger · May 4th, 2010, 02:51 PM

Ok, I'm back ...

Our "Business" category is based upon a "Business" ad type ...

Our "Personals" category is based upon a "Personals" ad type ...

If we click on a "Business" ad placed, the navbar shows "Home" and if you click on that, it takes you to the Classfieds Home.

If we click on a "Personals" ad placed, the navbar shows "Personals" and if you click on that, it takes you to the "Classfieds" Home.

So, I'm assuming we have no logic problem and there's a typo in the file you mentioned that needs to be corrected?

Regards,
Doug

Badger · May 4th, 2010, 02:56 PM

I think I get it ...

See attached?

Regards,
Doug

Badger · May 4th, 2010, 03:03 PM

Yup, that worked ...

Pretty soon, you're going to have to put me in staff to make a $1.64/hour like you do ...

On a more serious note, we're testing this in a devforum, but when we go live, we're going to install vb4 over top of our vb3 production site. I can't see myself completely re-installing Photopost Classfieds once we've upgraded our production site to vb4 and trying to remember ALL these edits and configuration issues we've been doing here.

Can I simply copy devforum/pp-classifieds directory over to the production sever under liveforum/pp-classifieds, then do some kind of a RESET to zero for al the ad counts etc, so we don't have to go through all this again?

Of course, I need to change the config files pointers and all that, but essentially should this come live fairly easily doing it that way?

Thanks for your help Chuck...

I have no idea how I would have got this far without you patience on here almost 7x24 ...

Regards,
Doug