"Review Extra Fields" will not trickle down to children?

MitchSchaft · July 19th, 2006, 02:08 AM

"Apply these settings and permissions to all children" does not allow the for "Review Extra Fields" to be trickled down through all categories, correct? I read that in another thread; something about them belonging to a different table.

I'm wondering if there is an easier way to add review extra fields in bulk. I will be adding 6 new ones to each product. I'll have 100s to fill out soon

.

http://www.rig-talk.com/reviewpost/s....php/product/3

tj2653 · July 19th, 2006, 09:15 PM

This is a little different (deals with additional field types), but I'm actually very confused about this as well. I added 4 "additional field types":

Open To Public?
Date Automated
Height of Tower (ft.)
Height of Focal Plane (ft.)

and checked the "*Check box to apply these settings and permissions to all children:" box on a parent category (with and ID of 1). I believe I saw a post that stated that the additional field types don't apply to the children, even with the box checked. The child category (ID of 2) doesn't have the 4 additional field types, but when I looked in the database, I saw two instances of each field, one with a cat of 1 and one with a cat of 2 (see attachment).

Can you please clarify? I'm using Version 3.3. Thanks.

Chuck S · July 20th, 2006, 09:23 AM

Yes the additional fields do apply to children if you check it

Chuck S · July 20th, 2006, 09:25 AM

If your wanting to compare code in adm-misc.php this is what I have and it updates the children. I made a simple change to update the children cats numextra field to show when one is added

Code:

Content visible to verified customers only.

tj2653 · July 20th, 2006, 11:36 AM

Quote:

Originally Posted by Chuck S

If your wanting to compare code in adm-misc.php this is what I have and it updates the children. I made a simple change to update the children cats numextra field to show when one is added

Hi Chuck,

I'm still having the problem -- I've attached a new screenshot to make sure we're on the same page here.

Thanks,
Cary

Chuck S · July 20th, 2006, 04:27 PM

I have tested this thoroughly and here is a link to my site I have tested both category and review additional extra fields and they work fine. Make sure your checking the apply to children box

http://www.photopost.com/forum/showp...55&postcount=8

MitchSchaft · July 20th, 2006, 05:11 PM

Of course we're checking the box :P. Brand new install, separate database from phpbb, and I'm using the silver.css. I'm looking in to hard coding below the pro/con boxes to make sure this does not become a future issue.

MitchSchaft · July 20th, 2006, 05:17 PM

The only difference in the code you posted and what's in my file is:

mine

Quote:

$revextra = ppmysql_query("UPDATE {$Globals['rp_db_prefix']}categories SET revextra=(revextra+1) WHERE id=$catid", $link);

yours

Quote:

$revextra = ppmysql_query("UPDATE {$Globals['rp_db_prefix']}categories SET revextra=(revextra+1) WHERE id=$eachcat", $link);

I'll see if changing "catid" to "eachcat" does the trick!

MitchSchaft · July 20th, 2006, 05:18 PM

Here's all of my code.

Code:

Content visible to verified customers only.

MitchSchaft · July 20th, 2006, 05:21 PM

Nope, didn't do the trick

MitchSchaft · July 20th, 2006, 05:24 PM

Just tried replacing the entire group with yours with no go.

Chuck S · July 20th, 2006, 05:26 PM

Sorry but I have to beg to differ

I showed you an explicit example in my post above. If you go into your child cat you should see the additional extra field there. That is a given so it works.

There are two update lines one for the main cat and one query for each child cat. The code must be exactly as I posted

If you continue to have an issue I suggest you send me site access

MitchSchaft · July 20th, 2006, 05:48 PM

You speaking of Review Extra Fields? I'll doublecheck everything, thanks for being patient!

Chuck S · July 20th, 2006, 06:01 PM

Yes I am.

See this product I posted from my site

http://www.reeftalk.com/reviews/show...p?product=1865

Now the test extra was a field I created in that dry goods cat so that field was already present. I then went to online vendors which is the parent cat and made a test children field and as you can see if did trickle down to the categories

Your saying if you add one you go and edit the child category and its not there?

MitchSchaft · July 20th, 2006, 06:04 PM

Correct. I'm about to doublecheck everything

.

MitchSchaft · July 20th, 2006, 06:05 PM

I'm in to Goldfish myself. It's a fun hobby!

Chuck S · July 20th, 2006, 06:08 PM

Yeah coral reef nut here

MitchSchaft · July 20th, 2006, 06:11 PM

I want to know why freshwater folks do not have any plans to get rid of Nitrates like you guys do. I have a denitrator and plants and that cut the issue in half. I bet yours at at 0 .

MitchSchaft · July 20th, 2006, 06:46 PM

...,,

MitchSchaft · July 20th, 2006, 07:05 PM

Ok, I'm going to have to give you my account access then. I can now add a field, but it adds like 8 extra ones to the parent and child. And when I removed it from the parent cat, it does not remove it from the children. Yikes...
Also, notice the name of each field is '1'. I put 'Test' in the Parent cat field.