Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.


  • Content count

  • Joined

  • Last visited

Posts posted by Dacotah

  1. Please forgive me in advance I'm new to osCommerce and PHP, old school HTML guy here...slowly but surely I'm getting there :)


    Three Questions:

    1. I do not understand this step in the directions: 4. Run the database.sql file

    I saw it referenced in the previous posts, but did not see any (or understand) responses


    2. What location are the folling files at: login.php, logoff.php, & create_account.php

    I am 99% sure its the files in the directory /catalog/


    3. What is this whitespace issue I see in a lot of the posts? I've done some research, but still a bit confused.





    1. Andes1 answers this on page 3 of this thread. The confusing part is that the sql file wasn't actually included in the download I used. The command is: ALTER TABLE customers ADD fb_user_id VARCHAR(32);


    2. Correct, your root directory, whatever that is.


    3. I didn't have this issue, but they discuss it on page one. Whitespace is unseen tabs, line returns and spacebar spaces. Some text editors will let you view whitespace. In this case they are talking about the whitespace at the end of the file it looks like.


    Good Luck, and this extension works in my heavily modified store.

  2. What's with the xd_receiver.htm ? Do I have to enter the URL anywhere in the Facebook application settings? I am not getting forwarded to the create_account.php and logged in or not on facebook - it does not change anything on my site.

    You do have to enter your URL on your FB app. It is under the Web Site tab, fill in Site URL and Site Domain.

  3. Here is how to show a FB image, link and reminder on logoff.php for only those FB users. It does not log them out of FB, but redirects them so they can do so.


    In logoff.php, find and add the five "if" statement lines...


       //Facebook Connect
     include 'includes/classes/facebook.php';
     include_once "fbconnect.php";
     if ($fbme){
    $fbuser = "<br><a href=\"http://www.facebook.com\"><img src=images/site/fb_logout.png></a><small>  Remember to Logout out of Facebook if on a public computer.</small><br><br>";
    } else {
    $fbuser = "";
     setcookie('fbs_'.$facebook->getAppId(), '', time()-100, '/', '.mydomain.com');


    then add the line after infoBoxContents...

             <tr class="infoBoxContents">
             <?php echo $fbuser; ?>


    and of course, edit your image path and upload your image to the appropriate directory.

    Here is the image I used... feel free to download.


  4. Thanks Andrea


    The link could either be just a simple link, or it could actually do a FB logout. I was hoping you had the code for the later. I think either would be ok, but I'll try to make the link show only if the customer is using FB Connect.


    My previous problem was just a stuck cookie. I used Developer Tools in Chrome to watch the cookie being created and deleted. Firefox has a similar plugin.


    So this is working just fine with PWA, Steve.

  5. logout works good, give the customer the choice to finish his FB session if he wants.


    when a customer logout from your store, that does not mean that he wants to finish his FB activities; for that reason is good to give him this choice on logout page...


    a simple link to FB CAN DO THAT!


    watch this video





    So there is supposed to be a FB logout link in logout.php? Because mine is not showing.


    If it is not included in the contrib, can you share your code? There seems to be a lot of discussion on how to do this on non-osc forums.


    This is working with PWA as far as I can tell, but I seem to be having a cookie issue as sometimes I can log off FB and log off OSC... hit My Account and immediately be logged back in.

  6. you have a product model which has many product attributes is the way it works



    So I need a new attribute_value_name column every time I want a new attribute? This will result in ten thousand columns, each of them used once since each attribute is unique and will only be used once. Just so I understand, in one attribute_value_name column, all entries in that column have to be identical?

  7. I'm testing EP on my dev server. I have a store with many attributes, and soon to be very many more since we need to add model numbers to each attribute. Products with a different attribute have a different model number, and I can't think of any other way to do it.


    Anyway, in the test upload file I have made a few changes and it seems to upload ok with the exception that it seems that in the attribute_value_name columns the names do not change unless I change the bottom entry of that column. I would like these columns to have all different attributes instead of being fill with "VHS" all the way down. I'd like them to have, for example, VHS 53789 then VHS 93848 under it and so on, so that in one attribute_value_name column each entry is different.



    Am I doing something wrong, or is this how it works?


  8. This is what EasyPopulate is doing now on my dev server. I haven't gone live with it yet partially because of this. The partial downloads work for me, you might want to try that. In a different post I just read about the same problem, Mibble I believe, thought that the database was timing out. Possibly because of a large database. His suggestion was to use the partial downloads and splice them together.


    I know that isn't much help, but if you figure it out please post back.

  9. Thanks Chris. That confirms what I have been thinking, so last evening I bought an SSL cert and plan to get that up and running next which will give me a little more leway in deciding who to go with, plus it's a good idea anyway.

  10. Another little tidbit of info regarding PayPal is this... get the debit card and use that for your expenses. Then start an E-Bay account and sell something once every three weeks. It doesn't have to be much.


    Now you will receive 1.5% cash on all purchases made with the debit card and if you are using it to pay your supplier your cash rebate will be significant.


    My PayPal rate is 2.2% and everything we buy from our supplier goes onto the PayPal debit card thereby reducing each transaction cost to under 1%.


    Now for my own dilema, we're processing over $10k a month and I know I should get another gateway but I just can't let go of that <1% transaction cost. Plus I know if I add another I suspect over 50% of our sales will go to that payment process...I've heard it's about 70%. I suppose some could be made up with extra sales but I just don't know.


    Thoughts? Recommendations?

  11. I ended up taking a silly shortcut.  It seemed to me that my problem stemmed from a lack of L10N entries.  So I went into the paypal_ipn.php script and removed all references to language translations from the SQL queries.  Then all was well.  Of course, I run a purely American site, so that solution might not fly elsewhere in the world.




    That would work just fine for me. Could you post your ipn file? There are a lot of references to language and I'd much rather see a working file than start hacking myself (which I will do if I have to!)



  12. OSC2.2 MS2 OSC PayPal IPN 12/20/2004


    2) All of my confirmation emails are now stripped of the product attributes. This is annoying me a lot as I use the email to send to my distributor and the attributes are important. I have to check each order and past it in at the moment.


    Exactly and it is a pain. Does anyone have this problem or better yet have a fix for it?

  13. Looks to me like the page cache wasn't working. So in the Admin -> Config -> Cache I set this to true and now it seems to be caching. I'd just like to confirm that this is where I can turn on and off Chemo's Page cache, or is this still the original cache?


    Ok, that is the original OSC cache. Chemo's was installed and working. I didn't think so because I had 80 queries, then when I turned on the stock cache, it would drop to about 40. I reset the SEO Urls cache, reran the debug and seen I had 277 queries, refresh and it drops to 80 so it is working. Now to do something about that many queries...

  14. I've been using the SEO Ultimate Urls 2.0 for about a month and it is working very well.


    I just installed the Output Debug Queries contrib, and seen the the number of queries does not change if I refresh. Looks to me like the page cache wasn't working. So in the Admin -> Config -> Cache I set this to true and now it seems to be caching. I'd just like to confirm that this is where I can turn on and off Chemo's Page cache, or is this still the original cache?

  15. I ran into an issue today. I had about 90 products that had 5 attribute sets each. Four of the attribute sets were common to all 90 products. I edited one of the sets, just changed the name of an option, and it deleted all the attribute sets from all 90 products except for the one I edited. I then had to go back through all those products and reenter the sets.


    So obviously unless there is a fix, I don't dare change anything unless I want to reenter them all. Is there anyway to fix this in an upcoming release?

  16. I am also getting this error. This is a fresh install no other mods and copied total replacement files over. Ne ideas?


    Ditto on this error exactly. Probably the way it is supposed to be, but I'd rather see a "This portion disabled by the Attributes Sets contrib" note instead of an error.

  17. No need to disable...just run the uninstall script (make sure it is the install-seo.php file!!!) and then turn right around and install it.


    The uninstall will remove both entries and the install will put one of them back in. As soon as you get the settings back in the database go configure it again.




    Excellent, Bobby! 30 seconds max and it was fixed. A small (unfortunantely) donation coming your way. :thumbsup:

  18. If you are capable go in with phpmyadmin and remove one of the groups and then filter for that group in configuration and remove them...


    If you cant do that go back to the install/uninstall page and remove them and start over....


    I don't think I have enough sql experience to try #1 yet.


    So for option #2, I'm thinking I should disable the module, run install-seo.php and select uninstall. Then rerun it to do the install, and turn the module back on? This sound right? It's a live store.


    Thanks again

  19. Ok, my .htaccess didn't transfer correctly. Now the urls work just fine in redirect mode.




    I still have double listings in the Admin -> Configure panel. How can I get rid of the first one?


    I'm a new administrator on this site, and AFAIK there wasn't any SEO contribs installed previously. I checked to make sure SEF URLs was disabled before installing, and it said so, but maybe it had said SEO URls instead of SEF Urls? I'm confusing myself now.




  20. Hi all,


    I tried installing with the 2.0b Feb 7 release. I ended up with two listings of SEO URLs in the Admin Config. They both have the same added and modified date of today.


    When I enable the second listing, I can see it is changing the urls to .html however none of the urls exist. Enabling the first listing does nothing as far as I can tell.


    Since the second listing seems to be working, I changed to cName instead of Rewrite and it seems cName is working ok. Rewrite does not.


    I shut it back off. What do I need to check?