Jump to content


  • Content count

  • Joined

  • Last visited

Profile Information

  • Real Name
    M Buswell
  • Website
  1. I am not sure if this is your problem, but for anyone missing the referer or user-agent values, it could be because you have not uploaded the includes/functions/whos_online.php file. there is both a admin/includes/functions/whos_online.php and an includes/functions/whos_online.php - i didn't notice that and through all updates were confined to the admin folder. May not be your problem but it was mine.
  2. Okay I figured out what went wrong, somehow I uploaded the admin/whos_online.php into admin/includes/languages/english/whos_online.php so it was calling sessions.php twice which was the problem, and it was calling all the whos_online functions 2x too. So once I fixed that then the redeclare errors when away.
  3. Adding that I have tried to revert to the original whos_online.php I am still getting a redeclare error Fatal error: Cannot redeclare _sess_open() (previously declared in /home/books/public_html/dfbadmin/includes/functions/sessions.php:23) in /home/books/public_html/dfbadmin/includes/functions/sessions.php on line 23 Right now it doesnt matter what I do to whos_online.php I cannot clear this error. I have tried logging off the admin interface several times, and left it logged off for approx 10hrs - but still sessions.php redeclare is present.
  4. I hope I am in the right support thread I have just installed Who's Online Enhancement After uploading, the first time i went to the page I got a successful page showing the who's online enhancement page - it was really good. I then applied the fixes and reuploaded. After this I started getting cannot redeclare errors. I removed the changes and reuploaded, but I still got the redeclare errors. So in admin/whos_online.php I added a if(!function_exists('foo')){ } around each function call. This removed all issues with the whos_online.php page, but now I am getting Fatal error: Cannot redeclare _sess_open() (previously declared in /home/books/public_html/admin/includes/functions/sessions.php:23) in /home/books/public_html/admin/includes/functions/sessions.php on line 23 I cannot see in any of the files related to whos online enhancement is trying to declare _sess_open. I have tried logging off and on, but to no avail. Hopefully someone can point me in the right direction. I am running osCommerce Online Merchant v2.2 RC2a Here are my server details Server OS: Linux 2.6.9-89.0.25.plus.c4smp Database: MySQL 5.0.90-community HTTP Server: WebServerX PHP Version: 5.2.9 (Zend: 2.2.0) MB
  5. Good point. I am looking at it. I am always worried I will mess something up.
  6. I know I am not the first to ask, and I know that it isn't yet available, however it would be great if SPECIALS could be included in EasyPopulate :D Failing that or additionally, the ability to export the product_id from the database would be handy. Understanding that model could still be easy populates primary key, however if product_id was exportable then it would be easier for people to do manual sql updates into other tables not supported by Easy Populate like SPECIALS. thanks
  7. mbuswell

    Official PayPal IPN Support Thread

    Whatever you set the completed status to be in the admin panel is what status you will get after the paypal transaction is complete. anything beyond that you have to deal with yourself ie: if you want to update to shipped for example. Personally mine is set to set the status to PAID.
  8. mbuswell

    Official PayPal IPN Support Thread

    Be aware that if the person doesnt return to you site after they complete the transaction (using the return to merchant link from paypal), then you may not see the status updated. You should do some testing of your own doing complete transactions, and also not returning to the site so you can see what effect it has on your orders.
  9. mbuswell

    Official PayPal IPN Support Thread

    Please excuse the double post but I believe this is actually the proper place to ask my question, especially since vger is probably watching this one. I am running OSCommerce 2.2 MS2, I have installed PayPal IPN. I have been getting some orders (or not getting them as the case may be), but it is slightly different than other people experience. My orders show up in the admin, however there are no products listed on the invoice. I have checked the database and there is an order in orders, but no line items in orders_products. From the looks of things the order items are still sitting in the customers_basket. The customers never complete the order through paypal, as I do not recieve a payment in paypal. I am not sure when they cancel out. It is not consistent that all paypal unpaid orders do not have items in their order, some orders do go through to orders_products correctly while the paypal part doesnt process. What might also be useful information is that I never get an email from my store when I have a broken paypal order. This is in both cases, ie: when items are in the orders_products table and when they are not but the order exists in the orders table. I cannot find the reason why the shopping cart would not get copied across to the orders table. Anyone have any ideas? I have tried testing myself going through successful transactions as well as not completing the paypal transaction, but mine always save correctly. very strange. thanks Mandi
  10. mbuswell

    Official PayPal IPN Support Thread

    The changes listed in CCGV(trad) are for the 1.2/1.4 version fo Paypal IPN. For version 2.x of Paypal IPN you cannot use CCGV(trad). They are not compatible. If you so a search on this forum you will find lots of detail as to why and lots of talk about it. I ended up installing just a Coupons contribution instead and that works with Paypal IPN 2.3. I believe once RC1 is verionised or MS3 is available then there will be a release of CCGV(trad) and/or Paypal IPN that will work together but until then you cannot get the two to work. Try either using Coupons ( http://addons.oscommerce.com/info/4269 ) or you can use another Paypal version - PayPal Express Checkout - that uses the SOAP API such as (http://addons.oscommerce.com/info/4791 ) as I understand that this will work with CCGV(trad).
  11. In this sql SELECT dc2z.geo_zone_id FROM discount_coupons_to_zones dc2z LEFT JOIN zones_to_geo_zones z2g USING( geo_zone_id ) WHERE ( z2g.zone_id= or z2g.zone_id = 0 or z2g.zone_id IS NULL ) AND ( z2g.zone_country_id= or z2g.zone_country_id = 0 ) AND dc2z.coupons_id="0GTRV9" Notice that the WHERE clause has z2g.zone_id= or (so there is no zone_id) that is what causes the sql error I believe. Same problem is in the AND statement z2g.zone_country_id= or Perhaps a general fix in the contribution could be to not do the look up if the zone information is blank. But in anycase, I would have expected zone details for the customer but if as Tracys said it was due to shipping zones not being set up that makes sense. there is a contribution that I use that sets up a shipping zone for the 'Rest of the World' automatically which is very helpful because as TracyS notes adding the countrys one at a tile to a zone is a bit painful. the contribution can be found here http://addons.oscommerce.com/info/4431 There are a few others that you can look at to if you do a search on "rest of the world" in the OSCommerce Contributions site.
  12. date_end and date_start are not the names of the fields so anywhere you see that you will get an error it needs to be coupons_date_start and coupons_date_end where are you getting these incorrect queries from?
  13. Yes so your date_start is definately called coupons_date_start, I bolded it above in your quote. Just try the query select * from discount_coupons cd order by cd.coupons_date_end, coupons_date_start limit 0, 20 that should work
  14. coupons_date start = coupons_date_start (the sql query I did included was correct though) can you do a describe discount_coupons; in sql and let me know the results
  15. If you are using the PWA - Proceed without an Account contribution you will need to be aware of a couple of things with this contribution. PWA doesnt by default store a seperate shipping to billing address so you need to modify catalog/includes/classes/discount_coupons.php where it checks the shipping zone to use the billto value ie: //shipping zone exclusions //MB: modified for PWA which only uses billto if ($customer_id>0) { $check_user_query = tep_db_query($sql = 'SELECT dc2z.geo_zone_id FROM '.TABLE_DISCOUNT_COUPONS_TO_ZONES.' dc2z LEFT JOIN '.TABLE_ZONES_TO_GEO_ZONES.' z2g USING( geo_zone_id ) WHERE ( z2g.zone_id='.$delivery['zone_id'].' or z2g.zone_id = 0 or z2g.zone_id IS NULL ) AND ( z2g.zone_country_id='.$delivery['country_id'].' or z2g.zone_country_id = 0 ) AND dc2z.coupons_id="'.tep_db_input( $code ).'"' ); } else { if (! $billto['country_id']) { $billto['country_id'] = 0; } $check_user_query = tep_db_query($sql = 'SELECT dc2z.geo_zone_id FROM '.TABLE_DISCOUNT_COUPONS_TO_ZONES.' dc2z LEFT JOIN '.TABLE_ZONES_TO_GEO_ZONES.' z2g USING( geo_zone_id ) WHERE ( z2g.zone_id = 0 or z2g.zone_id IS NULL ) AND ( z2g.zone_country_id='.$billto['country_id'].' or z2g.zone_country_id = 0 ) AND dc2z.coupons_id="'.tep_db_input( $code ).'"' ); } //MB: end PWA modify I couldnt find the zone_id in billto attributes so for now i default to 0. That should get your store working for people that select to PWA. What you also need to be aware of though, is you cannot use One coupon per customer with PWA, because all customer_ids for PWA accounts are created as customer_id=0. There will need to be another fix made to DCC that basically skips checking if customer_id=0 or even excludes the coupon if a person did not register, but I didn't have time to get that updated yet. When I do I will make a proper update to the contribution for it - but for now I wanted to add this to the forum in case anyone else was having issues.