susanjackman

Nice job! The only errors in the code where the break tags in a few pages, easy to fix and working great! I love that all code was added rather than modifying core code. My site is so heavily modified it's very difficult to use most contributions. I was actually hoping to find a way to include uploading an image into the account information. I haven't had any luck so far. I can write a simple script that opens in a new window and allows them to upload their "bio" photo to a folder on the server, but I want to at least have the filename attached to their customer info when they place an order. Anyone have any suggestions?

Yes, In Theory, this mod is going to save me so much time in the future, but it's taking alot of time to implement. Wait till you try to add other mods to it! My source code is so unrecognizable at this point that I can't add any more modifications without some major trial and error. This is a disadvantage to OSCommerce in General. I wish that modifications where add-ons like other open-source systems, I do not like having to alter the core code. I don't know how to put restrictions on the admins. I wish I could! Let me know if you find an answer:)

I don't know if its in this thread, but it's attached to the contribution. But it does not fix the new products page.

Yes, I am having the same issue. In theory you can link relatively to the main images folder in the multi-stores configuration, but I tried it and it didn't work. I have resigned to uploading into the main image folder and copying the images over through ftp for now, at least until I have time to figure it out...

Solution: Forgot to add the SQL into the configuration table for said store. :rolleyes:

This is showing up on the product info page that has no existing cross-sells set up. At first glance I thought it was a problem related to mySQL running version 5 on my server, but I did not have this problem on two of my other sites... so I'm thinking I missed something when I installed the contribution on this site. Error: 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 'MAX_DISPLAY_XSELL_PRODUCTS' at line 1 select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, products_price from products_cross_sell xp, products p, products_description pd where xp.products_id = '39' and xp.cross_sell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = '1' order by rand(1776191046) DESC limit MAX_DISPLAY_XSELL_PRODUCT

I am looking for a solution for this. I know that it is caused by running the contribution on MySQL 5. I have narrowed it down to includes/modules/new_products.php around line 18. "with MySQL 5.0 the processing of sql join queries was changed to follow the standards more strictly. As a result, queries that ran fine before MySQL 5.0.12 now give this 1054 - Unknown column 'xxx' in 'on clause'. http://dev.mysql.com/doc/refman/5.0/en/join.html Read the section which begins, "Before MySQL 5.0.12, the comma operator (,) and JOIN both had the same precedence" Solution: Standard oscommerce files affected have been updated in the nov 2005 update package, if you haven't installed this yet, you should do that first. But, contributions that you have installed might be suffering from this new strictness as well. Whenever you get this error, you need to dive into the code and make these changes." ~http://www.oscommerce.com/forums/index.php?showtopic=208286 However, I have yet to figure out what to replace the code with. I am looking through this thread hoping someone has posted the correction, but there is a lot to wade through and the search function on this forum never works for me. I will post when I find the solution. Please do the the same! :) There was a post for similar errors and a fix, but the new_products error is not included in the fix.

Well, just in case this helps, Fourth time was a charm, practice makes perfect, lesson learned: don't waste hours and hours trying to find the problem, just start over! I never found anything configured wrong, maybe I did something out of order, who knows!

I started from scratch and re-installed everything. (this is the fourth time) Same problem. Category is showing up in store 2 even though it is only enabled for the default store. I have changed the configuration table for store 2 (configuration_store2) in the database_tables.php in the includes and in the admin/includes to match what I used when I set up the store in the admin. Does anyone know what I am missing or overlooking? I read in a few places and in the install about changing the application_top to reflect the configuration table, but I've looked at it several times and don't see anywhere where it defines the configuration table.

I have given each store its own configuration table, I have updated the database_tables.php and I am still having the problem with my second store. Anything I create (catagory, product) They all show up in the second site.

I am having a very similar problem. I added a catagory and un-checked it for my second site but it's still showing up, and it's hidden in the main store. My second site is getting the catagories and products added to it but is the enablling/disabling is not working on it. I think it has to do with your comment "There is no seperate dtabse per store except the initial configuration table you add per store as per install instructions... " I have gone through the instructions and it states:I highly suggest checking "Insert default configuration table". However, for heavily modified stores that have made a lot of updates to the configuration table, you may wish to perform one of the following:" it then mentions the configuration table. I was under the impression that if you sleect to use the default configuration then the next step was not necessary. It discusses using an existing configuration table for an existing site. In my case, the site is not pre-existing and is using the same database from the get-go so I don't have a configuration table to copy. I selected to use the default configuration table.

I don't know why it wasn't working but I started everything from scratch and it worked fine the second time around. Although, I am having problems with enabling products to specific stores. I added a test category and made sure that it was not enabled to show up in my second store but it is showing up. I took a look at the store table and there is only one store in with store_id 1, but it's actually the second store. (Assuming the origional install of oscommerce would be the first store) I'm thinking this may be connected to the problem. Any ideas? Thanks!

Is anyone having problems with this mod and registered_globals. Do I have to have registered_globals on to use this mod? I have no problems running OSCommerce with register globals off, but after installing this mod I am given this error: Server Requirement Error: register_globals is disabled in your PHP configuration. This can be enabled in your php.ini configuration file or in the .htaccess file in your catalog directory. I have tried changing the .htaccess file, I have tried adding a php.ini file.

Sorry, I meant for this post to be in the thread for the Multi-Store multiple shops support thread. I have no problems running OSCommerce with register globals off, but after installing this mod I am given this error: Server Requirement Error: register_globals is disabled in your PHP configuration. This can be enabled in your php.ini configuration file or in the .htaccess file in your catalog directory. I have tried changing the .htaccess file, I have tried adding a php.ini file.

Is anyone having problems with this mod and registered_globals. Do I have to have registered_globals on to use this mod?