RP3.3 - move product to a different category - content of extra fields disappear

criscokid · June 27th, 2006, 08:57 AM

I recently upgraded to RP3.3 and have just moved a product from one category to another and suddenlt the content of new extra fields disappeared. The same fields exist in both categories so that's not the problem. I have attempted to edit the product and re-enter the lost data but it's just not getting written to the mySQL database.

Chuck S · June 27th, 2006, 11:09 AM

This would be correct. The additional extra fields are defined by category and not product so if you define extra fields for say cat a and then move a product to cat b which has no extra fields the data will not show. Now the main 6 extra fields stored in the products table will show anywhere. My comments are only for the unlimited additional fields.

criscokid · June 27th, 2006, 01:30 PM

First off I'm sure it would help a huge number of people if we could come up with a standard term for the 'first six extra fields' and the 'unlimited extra fields'.

In my case the same 'unlimited extra fields' exist in all categories.

1 I have a product in Category 1. The data in the 'unlimited extra fields' shows.
2 I move the the product to Category 2. The data in the 'unlimited extra fields' does not show. I edit the product (now in Category 2) to input the data for the 'unlimited extra fields' shows and click the 'submit' button.
3 The page refreshes to show the product but my The data in the 'unlimited extra fields' don't show any data. On checking the mySQL database the The data for the 'unlimited extra fields' hasn't been written.

Chuck S · June 27th, 2006, 05:39 PM

Are you using the latest download?

I am able to edit the data and input on editproduct

As far as data showing if the same unlimited field exists it will never show if you move it cause it is specifically tied to the category and each extra has a specific id.

criscokid · June 28th, 2006, 07:21 AM

Using the latest version - downloaded last week I think.

I understand the issue of 'each extra having a specific id' but RP needs to at least allow users to re-enter the data by hand after moving the product to a new category. At the moment it's not accepting new data after a category move.

Chuck S · June 28th, 2006, 11:55 AM

Do a test for me. Upload a new product into the same category that you moved the specific product to. Try to edit that data does it work?

criscokid · July 18th, 2006, 07:27 PM

What I've found out is...

If I have a product with no data in extra fields and I later move it and then add data into the extra fields it all works ok.
If I have a product with data in extra fields and I later move it I lose the data and then adding the data back into the extra fields doesn't work.

Chuck S · July 18th, 2006, 08:53 PM

try making sure editproduct.php code line 439 to the end is this

Code:

Content visible to verified customers only.

criscokid · August 21st, 2006, 01:52 PM

I moved a product and lost the data in extra fields made the aforementioned code change to editproduct.php, edited the product to put the lost fields back in... but unfortunately that hasn't helped... the lost fields are still lost

Chuck S · August 21st, 2006, 02:15 PM

That change above has not effect on moving data. The latest build has any necessary bug fixes but as noted you may not move a product and expect the data in the extra fields to show

criscokid · August 22nd, 2006, 05:01 AM

"but as noted you may not move a product and expect the data in the extra fields to show" - I fully understand that... the problem is that RP isn't accepting any data(data isn't being written to the database) for those fields once the product has been moved.

I've uploaded the latest version of editproduct.php and so far so good on the products that I've edited... all of the data for the extrafields is being written to the database.

Chuck S · August 22nd, 2006, 08:43 AM

As stated fields do not move when you move a product.

You need to create additional fields on the other category. If you do this then you should be able to edit and reinput data

I have tested this and it works that I see

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

criscokid · August 22nd, 2006, 09:51 AM

Chuck: I think you lost the jist of this thread as it's been going on for quite some time and you probably deal with hundreds of different threads a day.

For the benefit of anyone else that may read this thread... "As stated fields do not move when you move a product. You need to create additional fields on the other category. If you do this then you should be able to edit and reinput data"... I'm totally aware of this.

Before this 'fix' the RP database often wasn't accepting any data when you re-enter the data.

Chuck S · August 22nd, 2006, 10:01 AM

Yes but as noted there are no issues anymore which is what I have said. Your last post sounded like you still had issues.