Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

maniac101

Archived
  • Posts

    77
  • Joined

  • Last visited

Everything posted by maniac101

  1. Hi Chique, ok ive found the problem in includes\modules\family_products.php This file is seperated into sections based on the type of display format you choose from admin - i chose 'box' and 'random' so line 64 onwards controls teh products being listed from familys. The code does not check for no familys - ie products that are not in a family. This is bad as i think this would be the norm for most sites - i.e some familys but not too many and not every product. The fix i did for my site is around line 80 - look for start of first query return: if (tep_db_num_rows($family_name_query) == '1') { $family_results = tep_db_fetch_array($family_name_query); Ive added BEFORE THIS: if (tep_db_num_rows($family_name_query) > 0) { and then at the end of this section of code at around line 128: new contentBox($info_box_contents); echo '<p>'; } } ?> Just add another } to close the if statement so you have: new contentBox($info_box_contents); echo '<p>'; } } } ?> If you choose other options from admin other then 'box' and 'random' then you will need to do something similar to the other statements in this file using these options. The problem was the $where_clause was getting left as a blank '' so the sql query failed with 'and () and ' instead of '...and (something in here) and ..' works for me now. Someone else out there may be able to code this better and update the contrib. I can hack it but dont think its very elegant.
  2. I just installed the contrib and it seems to all work fine except I get SQL error messages for any products which are not assigned to any family (most of the products!) : I guess this is a simple error not checking for something.. but i dunno how to fix it yet.. any clues ? Thanks mark
  3. Hi Kevin, i recently installed easypopulate and it worked fine apart from the auto-splitting of large files ( i had over 17000 records to add to a book store). Best way to start with easypopulate is to use it to download your current product list FIRST. That way you have a csv file with the correct headings in it. Use this as the starting point to upload your products. regards mark
  4. HI, I installed the last sales report v1.3 and all went well. I have a problem with the previous/next links on the weekly reports (and a few others). Current weekly reports for this year show no previous link although they start at 29/1/2006 - so how do i see weekly reports for the previous weeks ? I can actually go to the data by first showing monthly reports, then clicking through to January - then i see the weekly report for January - so the data is there. Just something to do with the way the 'previous' link is created. Not sure how to fix this yet. Ive tried removing all checks for prev/next links so the links are always there - except now the missing prev link will go daily stats instead of january weekly stats so that hasnt helped much! I have added some extra colums for shipping and tax - but these only work properly when i dont filter based on pending/processing/dispatched - when filtered the shipping and tax show as negative amounts due to the way i am calculating them from the sum. I will work some more on this and hopefully upload a new version of this great contrib. Any help on the previous/next and filtering would be appreciated. thanks
  5. Hi, ive just installed the Manufacturers sales report contribution. Worked well, except default currency does not use standard oscommerce format but is hard-coded with dollar sign. Also date format is in US format too (y-m-d). I have managed to recode to fix the currency value but not the date entry format - any help ? I have also added the tax back in as a column although maybey no one else wants to see this. The main problem we have is not an easy one to fix i dont think - the data is based on the order table and products table of current products - so any products which were in the database and have since been removed are not included in the total figures shown. I have one customer who wants this option but i cannot see how that could be made available now since there appears to be no link between order history and manufacturer - other then a tentative link within this particular site which uses the manufacturers name as the first item in the product description. Am i right in thinking there is no way to gather historical linkage between manufacturer and order, once the product has been removed from the database ? thanks mark
  6. Hi, ive just uploaded your contrib. Ive been looking for something like this for a while. Thanks. Ive made a minor change to it to make the review look nicer in same way as standard product_review_info.php - putting line breaks into it. find around line 21: $reviews['reviews_text']); replace with: tep_break_string(nl2br(tep_output_string_protected($reviews['reviews_text'])), 60, '-<br>')); I also plan to mod the product_info.php so that the existing review links and stars are not displayed. I think that may have been from another contrib but am not sure at the moment. Thanks for the contrib anyway. regards mark
  7. Hi Ive just been testing 2.3/3.0 with single and multiple attributes. With single attributes i get correct 'out of stock messages' in product_info, but i am allowed to checkout these products if i do not explicitly set the stock value of the attribute to zero in the admin stock page. So this is not so good, but setting zero is a workaround that should probably be good practice to do. With multiple attributes, i get 'out of stock' messages in product_info for all products even when all of the attribute combinations are set correctly with stock levels in admin stock. The database table of PRODUCT_STOCK is correct - i see the attribute pairs correctly - one pair for each attribute in a comma delimited list. The appropriate bit (i think) of product_info.php code looks like this: //START get attribute stock values $attribute_stock_query = tep_db_query("select products_stock_quantity from " . TABLE_PRODUCTS_STOCK . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and products_stock_attributes = '" . (int)$products_options['options_id'] . "-" . (int)$products_options['options_values_id'] . "'"); $attributes_stock = tep_db_fetch_array($attribute_stock_query); $option_stock = $attributes_stock['products_stock_quantity']; //END get attribute stock values if ($option_stock == 0) { $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => 'Out of Stock - ' . $products_options['products_options_values_name']); } else { $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']); } In theory the query is returning a zero value for qty - but my PHP is no good yet, so can someone look at this section of code and see if it really would get a zero when the sql entry is something like 1-26,2-35 (meaning attrib option 1 is 26 and attrib option 2 is 35. Ive got a php book now so im gonna try to work it out, but if anyone gets time first please help.. I assume it would be simple task to modify product_info to not display the option at all (as some people have asked for) instead of marking the attribute out of stock. In theory that should look okay if you used it in conjunction with another change that displayed a out of stock message for the product as a whole. Thanks for any help on this.
  8. Ah fixed the problem. Didnt realise the fatal error meant my function def was no good - i have another contrib for stock status messages too in general.php which i accidently screwed in the process.
  9. Hi, I installed QTpro3.0 then reverted to the SQL from 2.3 and found the issues with missing LOW_STAT filename in the admin filenames.php and so far its sort of working okay. I can add stock and the stock shows up fine as expected in product_info - even makes the qty correct for all options together in the stock qty for the product in admin. But i have a simple problem now - should be simple! i get a fatal error: in both checkout_payment.php and shopping_cart.php. But.. this function is in /includes/general.php which is included via application_top.php (which is included via both the two files where it is used) so i am a little confused as to why this function isnt being found..?? How do i troubleshoot the cause of this ? Thanks
  10. Ah... just been testing with spider simulators (several) and none of them see the site unless autologon feature is disabled in admin.. so logoff page was a pain, but spiders leaving is caused by autologon trying to set cookies i guess. in MS2 the sid killer is built in to admin functon- i read some threads on putting in sid killer in with this as well so will try to make some mods that allow both to work..i hope.
  11. Hi Ethan, I have had the same problem as you - when no cookie you go to the logoff page on first entry to the site, caused by autolon contrib. I hadnt actually noticed this for a while as ive been testing without deleting cookies for a while. Testing today i saw this and needed to fix before going live. I cannot see why the autolon needs to go to logoff page at all - so i changed the code in autologon.php slightly: from same code snippet you supplied at start of thread FILENAME_LOGOFF changed to FILENAME_DEFAULT Now the first entry page is the standard default page of the store if you have no cookie - as you woudl expect. Seems to work fine and doesnt seem to screw anything else up (so far). If you fixed this in some other way then please let me know. The main thread for the autologon contrib has some info but it didnt help much.
  12. Oh yes.. it works fine now the directory protection is off. IPNs received properly and all reporting/emails etc work fine. Great contrib. cheers
  13. I'll be able to let you know wether my IPNs start working tommorrow - my hosting support people have gone home as its 9pm here, and when i use the provided tools to remove my directory protection it makes the directory unavailable to anyone ! Running on Plesk. Most things work... Thanks for the tip Jose - i guess i was just being over-protective.
  14. I feel like a bit of an idiot - just realised i have a login/password authentication for my /shop/ (catalog) directory - to stop anyone getting in whilst i am building it !!! Hence the 401. Still cant test it though until i get the username disassociated with the directory, but looks hopeful..
  15. I now notice in my server logs that im getting a 401 for access by paypal address: This comes up 4 times every time i do a transaction. But still get no IPN from paypal. Ive tried setting the ipn.php file to 777 but that makes no difference. Im also not getting any debug emails which doesnt help. Why is the POST from paypal being blocked at my server ? (if that is what is happening)...
  16. Just did a 0.01 transaction, but same as using sandbox - i.e no IPN received from Paypal. i get the emails to customer and admin from ebay saying that transaction has been performed. and i get the same checkout return, but no IPN. Ive noticed on other posts - do we need to set the digest key to match the PAYPAL data key and switch paypal data ON ? Or is that a red herring. ? so am a bit stumped now. I always also get a script error on the paypal entry page from IE too which isnt good either but doesnt seem to stop anything from working...
  17. Ive just tested using the 'IPN test' facility - and have got an IPN back okay (with type INVALID). This also shows up in my customer orders and now reduces my stock count too. So... everything is working sort of .. but why cant i get an IPN back from the sandbox ?? I will try the other suggested testing option of using live paypal with a 0.01 item and see if that does work. I have a number of real paypal accounts to play with. Incidently - the addition of the checkout text does not seem to be true. Unless i am missing something - with UK paypal merchant accounts you cannot take payment unless the customer has a paypal account. Is this a US only thing - as the merchant tools in teh paypal account does not have a facility to allow this ?? Apologies for turning this into a bit of a blog - but i think you are all on a different timezone to me. Thanks
  18. Ive now sorted the SQL error - i had a really duff admin\orders.php file as a base that had some wierd stuff with hardcoded images (ic_up.gif..) that i cant find where it came from, but starting with the original 2.2 and adding the payal ipn contrib it now works and i can see my customer orders. Hurrah ! However - still no IPN returned by payal, so no ipn info showing in the admin area. And all my orders remain as 'pending'. Also no stock deductions - even when i update an order to 'processing' or 'delivered' - although not sure if that would make the stock actually change anyway. So when should my stock count be reduced ? Is this only going to happen when the IPN is returned ? One last problem is the order history box - the links in here are wrong and actually vary depending on what page you are in (as a user). If you are on a products page looking at pid=34, then the order history links are: If you are in say conditions.php then the links from order history box will be If i actually go into the order history page (via My account->) the real links to the actual orders are I might just remove the order history box for the time being and force users to look in the history via 'My account'. But it would be nice to fix this too.. Thanks
  19. Thanks Greg yep my configure.php was wrong and now my return link works fine from paypal and the cart is cleared. This had also screwed my links on site to checkout etc too. However, IPNs are not showing in the admin for these transactions. Nor is any product being removed from my stock list (am using low stock report contrib v1.3) or showing up in the customer orders total (reports->products purchased). My customer->orders still gives the same SQL error message - which may be related to there being no orders in the table i suppose. But i do have a value figure in the Reports->customer orders total against the user id - this value gets added to BEFORE i actually get the link back from paypal which is probably not right, since the user hasnt physically paid by then. I suppose the IPN not showing is the first place to start looking..
  20. Hi, i have installed the Paypal IPN contrib and am having a couple of simple problems. Ive been testing through the sandbox and my orders are processed. But when i go to 'continue' - to return to the store site - the url listed is just http://checkout_success.php/?success=yes or similar. There is no server name in the link and the extra '/' before the ?success. If i manually type in the correct url then the return to my site works and the user cart gets cleared. Where is the missing server address ? or where should i look to add this back in ? I guess its one of the variables passed to paypal, since all the info suggests i leave my ipn url blank on the sandbox. Second problem is with my orders in the admin section customers->orders I get a SQL error 1064 as below: 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit 0, 20' at line 1 select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by limit 0, 20 Mysql version is 4.0.20 but dont think this is the issue. The offending line is in the catalog/admin/orders.php file (v1.112) around line 437 in my version of this file. But its not something that this contrib has touched and im not sure if i had een looked at the orders until now as ive been testing other parts of teh site. The query string is: $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and s.orders_status_id = '" . (int)$status . "' and ot.class = 'ot_total' order by $order"; Anyone see a problem with this ? so far i havent got an IPN showing but if i get the return url working i hope to be closer.. Any help will be appreciated.
  21. Hi, after re-reading this forum and the reame files many times, i have finally got this contrib working. I tried various rewriting of the path (i am on a virtual hosting plan too) and got various results (red herrings but they helped) - but it wasnt until i realised that the only .htaccess file you need is the one in teh image directory you are pulling your files from - and this .htaccess file must have TWO rewrite's lines to work with both image.php and thumb.php. add the .htaccess file to the directory with your jpg images in it - say /catalog/images .htaccess file looks like: RewriteEngine on RewriteRule ^(.*)\.jpg /catalog/image.php?%{REQUEST_FILENAME} RewriteRule ^(.*)\.thumb /catalog/thumb.php?%{REQUEST_FILENAME} I was missing the plot ! My htaccess was working fine for creating a watermark on my large images, but wasnt showing me my thumb images at all. I was not expecting (dunno why) to be able to directly go to http://myserver.com/catalog/images/image1.thumb - but with the .thumb rewrite in the same .htaccess file - these started showing up and everything worked fine exactly as in the original posted contrib. - except for confusion about the .htaccess files. Ive been pulling my hair out on this. So to recap - you should be able to use one .htaccess file for both the image watermark on the big image and the thumb (watermarked or not as you choose in thumb.php). no guarantee that it works for you though !
×
×
  • Create New...