snubbr.com

How do I enable Verisign SSL for Safari (on Mac)?

Get a Verisign SSL certificate for 30 days FREE. Click here to use coupon...

Get a free trial of Verisign SSL certificates. Click here for this special deal...
Got a question... How do I enable Verisign SSL for Safari (on Mac)? Many thanks for any comment. Another question I got... Could someone give me an idea what might be going wrong while doing an update on products?.

Scenario is this:.

OsCommerce CRE5 (Ian's Loaded 5) with Multi-Level Price Mod, Easy Populate, osCAffiliate, WAP Access and Down for Maintenance. When updating a product (as in adding information) the Date Available field is blank (even if I just entered a date and processed the update) as well as all of the non-primary language fields. The primary language fields seem to update fine. The items were imported into the catalog using the Easy Populate mod in only the primary language. (translations haven't been done yet!).

I am looking through categories.php as well as the tables for the product catalog and those added for the pricing mod. It would be helpful if someone could at least tell me if I'm looking in the right place or not....

THANKS!!..

Comments (78)

I would like to know the answer too. Anyone here know what is the answer to that question. I'll do some poking around and get back to you if I find an good answer. You should email the people at Verisign as they probably could assist you..

Comment #1

...forgot to mention that this only solves the date available issue which was my major problem....

Could someone please tell me what that little snippet actually does? My PHP skills aren't that astounding..

Comment #2

That code is try to say that if today is before the available date leave it alone otherwise clear it out. It would be more clear if it was written like this.

If (date('Y-m-d') >= $products_date_available).

{.

  $products_date_available = 'null';.

}..

Comment #3

Thanks!.

Kinda figured that out when I thought about it. So the bottom line is that you cannot update the.

Date available.

Field to a date that has already occured......

Comment #4

Thanks guys for the ideas on the date field, I'll give those a try soon. I did find out what the problem was with the multi-lingual issue. I don't know if this is a bug in the easy populate tool, but there were no records in the products_description table for any language other than the primary language. I did a dump from the mysql command line and used a text editing tool to change the language_id field for each language and then ran the sql dump to add those records to the table. This part seems to be working fine now..

I'll let you know how the date thing works out :?..

Comment #5

One of these days I'll learn to use the preview feature. :oops:.

Scratch the "sql dump" part of the explanation. I actually executed the following command to extract the data (I also upgraded database versions and changed db servers while I was at it.);.

Mysqldump -F database_name > dump-file.sql.

Then on the other server I used the following sequence to import the data;.

Mysql database_name < dump-file.sql (for the primary language records).

Alter with Find/Replace for the language integer changing it to the appropriate value, save the file as dump-file2.sql then execute;.

Mysql database_name < dump-file2.sql to bring the changed records into the products_description table..

This would be repeated for each langague that you have. I know it's probably not the most graceful of solutions, but at least the records are there and the translated versions can now be saved when the product(s) are updated. (currently have about 14,000 items with about 5 or 6K items that have attributes associated with them. I guess this means that doing it by hand was completely out of the question... :shock:..

Comment #6

Dan,.

You probably have this answered by now, but I found just rediscovered this post and thought I would post my solution for posterity sake;.

I ended up reworking the /admin/categories.php page to fix the date issue and the following is the code and comments regarding the changes and what they are:.

// Removed 'null' from date value to fix insert error that caused loss of input.

//$products_date_available = (date('Y-m-d') < $products_date_available) ? $products_date_available : 'null';.

// following line resets the date available to the current date if todays date is more recent.

//$products_date_available = (date('Y-m-d') < $products_date_available) ? $products_date_available : date('Y-m-d');.

// following line ignores today's date when updating the product record and inserts whatever existed prior to the edit/update - desired default behavior.

$products_date_available = (date('Y-m-d') < $products_date_available) ? $products_date_available : $products_date_available;.

NOTE: The control structure (part after the = sign) is called a tertiary expression and the syntax is [expression] ? [value if true] : [value if false].

So basically the desired default behavior says if today's date is older than the date in the variable $products_date_available use the $products_date_available value and if not use the $products_date_available value anyway. The second variant (actually before the example previously referenced) says that if today's date is older than the date in the variable $products_date_available use the $products_date_available value and if not then use the current date value with the format year-month-day...

Comment #7

Could someone give me an idea what might be going wrong while doing an update on products?.

Scenario is this:.

OsCommerce CRE5 (Ian's Loaded 5) with Multi-Level Price Mod, Easy Populate, osCAffiliate, WAP Access and Down for Maintenance. When updating a product (as in adding information) the Date Available field is blank (even if I just entered a date and processed the update) as well as all of the non-primary language fields. The primary language fields seem to update fine. The items were imported into the catalog using the Easy Populate mod in only the primary language. (translations haven't been done yet!).

I am looking through categories.php as well as the tables for the product catalog and those added for the pricing mod. It would be helpful if someone could at least tell me if I'm looking in the right place or not....

THANKS!!..

Comment #8

I have exactly the same problem... My solution so far is to find the following line in admin/categories.php.

$products_date_available = (date('Y-m-d') < $products_date_available) ? $products_date_available : 'null';.

And disable it:.

//$products_date_available = (date('Y-m-d') < $products_date_available) ? $products_date_available : 'null';.

Don't really know what this code does or why it causes the problem. But I suspect I will learn the hard way someday when I forgot about this little hack.....

//Dan..

Comment #9


This question was taken from a support group/message board and re-posted here so others can learn from it.

 

Categories: Home | Diet & Weight Management | Vitamins & Supplements | Herbs & Cleansing |

Sexual Health | Medifast Support | Nutrisystem Support | Medifast Questions |

Web Hosting | Web Hosts | Website Hosting | Hosting |

Web Hosting | GoDaddy | Digital Cameras | Best WebHosts |

Web Hosting FAQ | Web Hosts FAQ | Hosting FAQ | Hosting Group |

Hosting Questions | Camera Tips | Best Cameras To Buy | Best Cameras This Year |

Camera Q-A | Digital Cameras Q-A | Camera Forum | Nov 2010 - Cameras |

Oct 2010 - Cameras | Oct 2010 - DSLRs | Oct 2010 - Camera Tips | Sep 2010 - Cameras |

Sep 2010 - DSLRS | Sep 2010 - Camera Tips | Aug 2010 - Cameras | Aug 2010 - DSLR Tips |

Aug 2010 - Camera Tips | July 2010 - Cameras | July 2010 - Nikon Cameras | July 2010 - Canon Cameras |

July 2010 - Pentax Cameras | Medifast Recipes | Medifast Recipes Tips | Medifast Recipes Strategies |

Medifast Recipes Experiences | Medifast Recipes Group | Medifast Recipes Forum | Medifast Support Strategies |

Medifast Support Experiences |

 

(C) Copyright 2010 All rights reserved.