Product Extra Fields for text, pdfs and flash

[mikebackhouse]

Hi all,

Does anyone know why I'm getting the following UL list appear when I dont add any additional files? :

Downloadable Datasheets

* NULL
* NULL
* NULL
* NULL
* NULL

Any products where I HAVE added additional files are fine. I've removed the mod for the time being, but really want to get it working as our customers need PDF's.

Fantastic contribution by the way Delia! Thank you! I just hope i can get it working properly

[delia]

Looks like you have put NULL in the database field. Did you add this into an cart with existing products? Or are these fields created by the sql that came with the mod?

The solution is to clean up those fields and I can give you a sql statement you can run to do that but we need to figure out how this happened.

[mikebackhouse]

Hi Delia

Thanks for your reply.. yes there were products in there in the 1st place. I've spoken to our techy/servery type guy.. and he admits he may not have copied the tables properly in the database!

He's going to take a look at it in the next few days, i'll let you know how I get on

Thank you!

[jezjones29]

hi, thanx for this great mod. The only problem I have is when I try and copy a product. Please can you confirm that this works?

When I copy a product at the moment, the new item just gives me errors:

Warning: reset() [function.reset]: Passed variable is not an array or object in /home/cashback/public_html/....../includes/classes/object_info.php on line 29

Warning: Variable passed to each() is not an array or object in /home/cashback/public_html/....../admin/includes/classes/object_info.php on line 30

[patrickuzu]

Hi
Well this contribution.
When you delete an item, the field in the table "product_extra_field" is not deleted.
A solution?
Thank you
Patrick

[delia]

Will someone who has this installed try copying a product and see if you get the same results as jezjones29?

Nope, it's not added into the delete file - when I get a chance I'll do that and probably attend to the copy function as well.

[ellivir]

Just trying to populate finally the old products in the shop to have their id in the product_extra_fields

- so, reading above, should I not put NULL in those fields I have nothing? I made an example, took the db structure out from the database and I've been building all hundreds of products like this in a spreadsheet: (1044, '<br />', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

- if the product id needs to be in the table product_extra_fields, can I update the site anymore with Easy Populate?!

Elli

[delia]

The fields should be left empty if there's nothing there. And no, easy populate will not populate these fields - it will still work however, no changes to the rest of the product database setup.

[ellivir]

The fields should be left empty if there's nothing there. And no, easy populate will not populate these fields - it will still work however, no changes to the rest of the product database setup.

Maybe there is a way to make the Easy Populate to populate this too or what is the wisest to fix that the populated once would work too?
Otherwise comes on error I guess (like now with the old products).

[delia]

can be coded, yes, but it would not simple.