Jump to content


  • Content count

  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Selena Vella
  1. Hi to all who responded, and apologies for the delay in responding; I have been working on other aspects of the website.... I thank you very much for all your responses. Yes, I realize that osCommerce searches only the database, and I have informed the client of such. Unfortunately, it was not my choice to create her web site using osCommerce, which integrates, as is correctly pointed out, *2* web sites, osCommerce and not. The osCommerce solution was already chosen when I started working with it, thus, I must either simply explain that the site searches the database and other solutions are somewhat intractractable, or see if something such as google search will do more of what the client wants. Selena Vella
  2. Hello, I have a client who wishes to search her osCommerce site by *keyword* not simply by product as the current search info box does. I have added quite a number of informational pages to her osCommerce spa site (FAQ's, treatment description pages, etc). There are also, products that are the osCommerce part of the site. Thus, she would like a search that not only search her products, FAQ's treamtments, etc. The products are of course in the database, the description of treatments, FAQ's etc are not. Is this possible? Will a utility such as Google Search added to the site instead of the current search accomplish this? (I haven't attempted this yet). My client is very insistent on this and I would greatly appreciate assistance. If any further information is required, please respond I will happy to provide any information required. Thank you.
  3. svella

    Check Order Status Contribution

    @@sakk, or anyone else, I also need an add on or a way for customers to check order status. I am using osCommerce 2.3. The video demonstrates the contribution, but unfortunately, I do NOT where to get it. I don't how to search for the add on. Please post the add on, or let us know how to get it. I need to have a way for customers to check order status. Thank you in advance for your assistance, I would greatly appreciate it.
  4. svella

    "buy now" contribution

    Hi, all: I think I have figured it out! @Praful, thank you very much for your kind suggestions! Best, Selena Vella
  5. svella

    "buy now" contribution

    @Praful Thank you very much! I will check it out. I have tried to use the code in the contribution for my store, however, what I find is that the right & left columns are very messed up: the left column is in 2 columns and the right column is on the left!? I will check the thread and see what I am able to discern -- I may be back... Thank you again!
  6. Hi, I have downloaded contribution "buy now" for new products & featured products: http://addons.oscommerce.com/info/7029 The issue is, I am using 2.3.1. I also wish to use this with featured products on the home page, instead of new products -- and I've already installed the featured products contrib for 2.3.1; no issue there. Unfortunately, for 2.3.1, I don't know where to add the code described or where - nor the *exact* code to add. I would greatly appreciate your assistance, Many thanks in advance!
  7. @@Chris: Hallelujah! It's is (more or less) working -- yes the entire center of the home page is blank until I add a featured product (that almost gave me a heart attack). And as is obvious since I was add a featured product, the admin panel works -- which I hadn't even broached. And I was able to figure out why catalog_includes_column_left kept giving me a problem - in this case, I had downloaded the 2.2.x file (duh!) -- I had originally downloaded all versions. No doubt, there will be more questions about this in the near future, thanks so much for all you suggestions and support!
  8. Hi just for clarification, and perhaps making it easier to help me: I did download the 2.3.1 fix - but it included the SPPC fix, so I removed all reference to SPPC; that's what remove the errors indicating that "customers_group_id" was not found. And I get the results above. It did see a little earlier today another fix for 2.3.1 (thank you, @@Chris!), and it looks like it may not have the SPPC included.. I will try that as well. In the meantime, I would greatly appreciate suggestions. I am beginning to run out of time.... As I mentioned, I am more than happy to provide any files, information, etc. that would help you. Thanks again in advance!!
  9. Hi, @@Chris and all, Yes, I once again check all my downloads and modifications, and did find that I had not download a file.... Now, if I still require your assistance (this is truly becoming frustrating, and I left this project for a day): I no longer get the error re "1054 - Unknown column 's.customers_group_id' in 'field list'" -- HOWEVER: 1. The center content section is completely blank -- now, I don't have any items in "featured products" but don't know if this is what is supposed to be rendered (ie, totaly blank after "welcome, guest") if there are featured products -- I will examine the code more closely, but I'm not *so* experience @ PHP, so would like your assistance here. 2. Clearly, 2.2 version is expecting a catalog/includes/column_left.php. When I click on the "featured products" link in the info box entitled information, I get an error indicating that: "catalog/includes/column_left.php does not exist. I know this existed in 2.2, but does not in 2.3.1. As I mentioned, I am not so experienced in PHP, and it would help a great deal if I knew where to look and how to correct this. As previously, I will happy to provide any further information and/or files that you may need to look at. Thank you in advance!
  10. @mention and all: I do wish to thank you all so much for your suggestions! I actually started over from the beginning, and restored the original OS Commerce files and started over.... and installed the new files and the modified files again. Please note: I am using 2.3.1, and I DON'T have SSPC installed. Now, I have the error message on the home page: 1054 - Unknown column 's.customers_group_id' in 'field list' SELECT p.products_id, p.products_image, p.products_tax_class_id, s.customers_group_id, IF (s.status, s.specials_new_products_price, NULL) AS specials_new_products_price, p.products_price, pd.products_name FROM products p LEFT JOIN specials s ON p.products_id = s.products_id LEFT JOIN products_description pd ON p.products_id = pd.products_id AND pd.language_id = '1' LEFT JOIN featured f ON p.products_id = f.products_id WHERE p.products_status = '1' AND f.status = '1' AND s.customers_group_id ='0' order by rand(1536182995) DESC limit 6 [TEP STOP] I realize that references to customers_group_id have to do with SSPC, therefore, I have removed or commented out (as far as I am to tell) all reference to this column form bm_featured.php. I thought I MUST use bm_featured.php as I am using 2.3.1, and the includes/boxes directory doesn't exist Yet, I still have the same error. The catalog/featured.php file contains NO reference to the customers_group_id column, as I am using the file from the download for 2.2.x. As far as I am able to tell, therefore, only the includes/modules/bm_features.php has any reference to the customers_group_id column in my files. Do I need to create the includes/boxes/directory and put featured.php in that directory? That doesn't sound correct for 2.3.1 - I haven't tried that, though Still, it's odd that as far as I am to tell, any reference to the customers_group_id has been removed or commented out, and I still have the error... Also note that 2.3.1 doesn't have the catalog/include/column_left.php file so I cannot follow step 14. I would truly appreciate your assistance. At this point, I've hit a wall. Unforutunately, the developer working on this before me agreed to a design that would necessitate the use of this contrib, and I am having to follow through somehow.... Thank you in advance! If you require further information, files, etc, etc, let me know, please.
  11. Hi, @@Steve, and all: A big thank you for your suggestion! There were many files to upload, and though I put in the defines in /includes/database_tables.php, I had not upload it to the server. Thanks so much. So, no complaints about databases tables... HOWEVER, I AM back to the original error message on my home page: vellatest.com/isistest Warning: include(includes/modules/FILENAME_FEATURED) [function.include]: failed to open stream: No such file or directory in /home/selenav/public_html/isistest/index.php on line 265 Warning: include(includes/modules/FILENAME_FEATURED) [function.include]: failed to open stream: No such file or directory in /home/selenav/public_html/isistest/index.php on line 265 Warning: include() [function.include]: Failed opening 'includes/modules/FILENAME_FEATURED' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/selenav/public_html/isistest/index.php on line 265 (It is repeated 3 times on the home page.) I would appreciate suggestions as to where to look -- do you believe it best for me to start all over and double check my edits and upload the files again? or as experts do you know where to look already? (I have to admit, I am new to OSCommerce.) Many thanks in advance!
  12. Hello again: I am not able to edit my previous post; it seemed I may not have uploaded "includes/application.top"... so I uploaded it to the server. Please disregard my previous error. So now I have a DIFFERENT error: 1146 - Table 'selenav_osc1.TABLE_FEATURED' doesn't exist select featured_id from TABLE_FEATURED where status = '1' and now() >= expires_date and expires_date > 0" Of course, I can access the database, and osc1 DOES have a "featured" table. (I am assuming the table should be named "featured" & not "table_featured") And yes, I did run the sql query script per instructions at the end, after importing the table. If I am able to get some help, that would be fantastic! If can provide further information to allow you to help me, please let me know what that would be... Thanks in advance!
  13. Update: after I posted this, checked to insure includes/modules/featured.php *is* present. Where else to look? Please read below. Hi, your assistance would be greatly appreciated: I have followed all the instructions installed the database table, & run the query. Now, I have errors on the home page of the site: vellatest.com/isistest; Warning: include(includes/modules/FILENAME_FEATURED) [function.include]: failed to open stream: No such file or directory in /home/selenav/public_html/isistest/index.php on line 265 Warning: include(includes/modules/FILENAME_FEATURED) [function.include]: failed to open stream: No such file or directory in /home/selenav/public_html/isistest/index.php on line 265 Warning: include() [function.include]: Failed opening 'includes/modules/FILENAME_FEATURED' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/selenav/public_html/isistest/index.php on line 265 (It is repeated 3 times on the home page.) I'm going to check this out, I am assuming that I should check index.php & includes/modules/FILENAME_FEATURED' -- but I would *really* appreciate some direction re *where to look* and *for what*. I would not be surprised if something is missing, as there were many files to update/upload. I am fairly new to OS Commerce, and this is one of more complex contribution I've attempted to use. Now: one thing I was NOT able to do per instructions: I was not able to able to upload include/boxes/featured.php, since in 2.3.1, the directory includes/boxes does not exist. Your assistance is greatly appreciated. Thank you!
  14. Hi, I do hope someone can assist me. I am "taking over" the development of an OSCommerce 2.3.1 site. The "home" page is already designed and apparently the intention was to use the "Features Products" contrib. and allow feature featured products on the home page. Now, I downloaded Featured Products v1.6.5_1.zip. There are installation instructions in the zip file. Then I found the update for OSC 2.3.1: featured_for_SPPC_fix.zip Now, I am not certain how/what to install. I would greatly appreciate help in what I need to add/replace etc to install this contrib on 2.3.1 Thank you greatly in advance.