Aalst

Here is what I found for myself so far. The below code is where the problem is: if ($dltype == 'froogle'){ // For froogle, we check the specials prices for any applicable specials, and use that price // by grabbing the specials id descending, we always get the most recently added special price // I'm checking status because I think you can turn off specials $sql2 = "SELECT specials_new_products_price FROM specials WHERE products_id = " . $row['v_products_id'] . " and status = 1 and expires_date < CURRENT_TIMESTAMP ORDER BY specials_id DESC" ; $result2 = tep_db_query($sql2); $ll = 1; $row2 = tep_db_fetch_array($result2); if( $row2 ){ // reset the products price to our special price if there is one for this product $row['v_products_price'] = $row2['specials_new_products_price']; } The below part of this code is the problem. I used this select statement, and it returns nothing, but if you use it with out "and expires_date < CURRENT_TIMESTAMP" tt returns correctly with the sale price. The only problem I guess is if the item has expired and the store owner has not disabled the sale it will still return this price. Some how the SQL CURRENT_TIMESTAMP doesn't match the time stamping being used in a "datetime" type column. I checked my sql server has the correct date and time set. I have temporarly removed this part of this statement until I or someone can figure out how to fix this. I will just manage my sales closely to disable them when they are over. Sincerely, Rodney Arely Art

I am wondering if there are any savvy PHP programmers that are familiar already with EasyPopulate and would like to release a new update for it? :) There is one small problem with the Froogle export. It doesn't export the prices for items setup in the "Specials", it just exports the regular prices. This is bad because it doesn't give us the best listing on our sale items. Please let me know... Sincerely, Rodney Arely Art

I moved this to the support forums, and I forgot to update this one, but it some how fixed itself... with out doing anything the next day it started working. I was thinking maybe it was my HOST and how low they have all the config settings, like they had the daily SQL queries set to only 10,000 (max_questions). They had a lot of other strange things here and there. I am in the final stages of completing a migration from them (iPowerWeb.com) to JaguarPC.com. And so far it is sooo much better over than and its only been 24 hours and I can see the difference in everything like speed, support, features, etc etc. (If anyone is thinking of iPowerWeb.com -- "Don't Do It!") So if it is still doing this after a 24 hour period has past without you trying anything, then it maybe something to do with your HOST's configuration settings for MySQL or even PHP. If it is still not working after this, then their may be something else wrong, and you may not be seeing an error that is there. You can check out this: http://www.oscommerce.com/forums/viewtopic.php?t=57539 Jim Daemon was helping out, before it just "fixed" itself. You may want to continue asking questions in that thread or send him a PM. I wish you the best of luck in fixing the problem...

Does anyone have a site running this contrib, that wouldn't mind posting it here as an example of the Category and Menu Tabs? Thanks

I was able to make my first upload into the DB, and it all went great. Now I am trying to do another update to the DB, but it will not go. It doesn't give any errors, but doesn't show the inserts/updates like it did the first time. When I use the "Upload EP File" I get the following response: File uploaded. Temporary filename: /var/tmp/phphCz6dp User filename: products.txt Size: 44642 If I use the "Import from Temp Dir" I get the following response: This is strange, since it work so well the first time just a few hours ago. I tried chaning the file name, just in case, but no good. Any help would be appreciated... thanks... Aalst

I fixed this by changing the temp dir variables from: $tempdir = "/catalog/temp/"; $tempdir2 = "catalog/temp/"; To: $tempdir = "temp/"; $tempdir2 = "catalog/temp/"; Basicly the $tempdir should not have the directory of your OSC install it only needs the name of the temp dir with out the preceeding slash. Hope this helps

I am getting the exact same errors.

Sorry to seem like a pest, but I forgot another thing: In the manual you have a type-o for the name of the function to find for enabling support for Linda's Header Controller 2.0. It says to find function ep_create_file_layout when it is ep_create_filelayout. I know this is minor, but some less experienced users may try to search by the complete function name and come up with nothing. :) Again sorry to seem like a pest.

I forgot one other suggestion. However, in the 2.60 MS Word manual the "support for Linda's Header Controller 2.0" is supposed to be disabled, however it comes enabled. It would be nice to have a variable to disable or enable it in the config area, or to have it autodetect the MOD by checking if those fields exist in the DB. Thanks again... -Aalst

Okay, I downloaded EP one day before they posted a UPDATED "Manual", but figured it out and made the changes. However, I have a suggestion that wouldn't take much time at all to do and to be reposted by the Author. 1) Make the "tep_array_merge" to "array_merge" fucntion changes in the actually PHP file. 2) Change the temp file location from the root of the "catalog" directory to the root of the "admin" directory. 3) The one simple change you have user make in the catalog.php you may want to add BEGIN and END comments around it, to help some less exerienced users. It is recommend that all MODS to a file should have some type of BEGIN and END comments around them. The reason for #2 is that having a 777 directory in an unpassword protected area is a security hole. Anyone could use it as a drop off point for illeagal file tranfers, among other things. Most installation of OSC should have there admin directory password protect at the very least. Therefore anyone from the outside would have to know this before accessing it. However, EP is running from the admin directory therefore it can access the admin/temp directory without the use of a password. THANKS for one of the most useful OSC Mods I have seen, and also one of the easiest to install and to use. -Aalst