Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

macmizer

Members
  • Content count

    63
  • Joined

  • Last visited

  1. macmizer

    photo gallery for oscommerce

    Is there a way with the gallery to set it up so that you can upload any height and width image. Right now it is limited to 800 wide by 600 high. I know I cna just change those values but I don't want to keep guessing what size is a good size to set. I am also concerned about file size. It is set to 100000 right now. I know I can change all these values but what would be a good size? The way it is now is just not user friendly. Customers would have to know how to resize their files and if they have to do those additional steps they may get annoyed and end up not uploading at all.
  2. macmizer

    photo gallery for oscommerce

    Has anyone installed this contribution into cre loaded?
  3. macmizer

    photo gallery for oscommerce

    Ok I understand that part. Now I just need to find out why I am getting that sql error mentioned earlier. 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 ',,,3,,,,,,,,,,,,,,,,,,,,) and c.categories_id = cd.categories_id and cd.language' at line 1 select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id in (4,3,3,3,3,3,3,3,3,3,4,3,3,3,3,3,3,3,3,3,3,3,3,3,3,,,,,3,,,,,,,,,,,,,,,,,,,,) and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name
  4. macmizer

    photo gallery for oscommerce

    I am having the following 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 ',,,3,,,,,,,,,,,,,,,,,,,,) and c.categories_id = cd.categories_id and cd.language' at line 1 select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id in (4,3,3,3,3,3,3,3,3,3,4,3,3,3,3,3,3,3,3,3,3,3,3,3,3,,,,,3,,,,,,,,,,,,,,,,,,,,) and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name I reimported the gallery.sql and made sure the extra space before the last semi colon was removed. But it had not effect. There was another person in this forum that had the same error. I am not running 5.0 or higher of mysql either. I am running version 4.1.22 I get this error when I go to my main site. When i go into admin all I find is a Gallery link under configuration and once I click on it the page on the right shows "Clean up thumbnail folder" There is nothing else in that window under admin. SHouldn't I have more things to configure or look at?
  5. I have two suggestions. If you want to PM me I can arrange for an explanation but to document the many approaches I took is just too much for me to type out.
  6. I have implemented this contribution into a cre loaded store. I attempted this installation even though the I have cre loaded and not osCommerce. I have used both osCommerce and CRE loaded many times. My reason for attempting the installation is due to the fact that the documentation makes it seem very straight forward. Well I thought so at least. I am very close. I have the More Categories link showing under the Configuration section but I do not have the More Categories showing under Catalog at all. Nothing new there. I think it may be an issue with the file called catalog/includes/column_left.php. this column_left.php however is not used for the admin from what I can tell. I believe the file that should be showing the More Categories under Catalog in the admin is catalog.php. I did have an issue with the file located at admin/includes/boxes/catalog.php. Below is the code from that page. You will notice that I could not use the same exact code given to me in the readme.txt for the contribution. Does anyone know what may be causing this issue of not seeing the More Categories inside of the Catalog menu? <?php /* osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2002 osCommerce Chain Reaction Works, Inc Copyright © 2005 - 2006 Chain Reaction Works, Inc. Last Modified by $Author$ Last Modifed on : $Date$ Latest Revision : $Revision: 705 $ Released under the GNU General Public License */ ?> <!-- catalog //--> <tr> <td> <?php $heading = array(); $contents = array(); $heading[] = array('text' => BOX_HEADING_CATALOG, 'link' => tep_href_link(FILENAME_CATEGORIES, 'selected_box=catalog')); if ($selected_box == 'catalog' || $menu_dhtml == true) { $contents[] = array('text' => tep_admin_files_boxes(FILENAME_CATEGORIES, BOX_CATALOG_CATEGORIES_PRODUCTS) . tep_admin_files_boxes(FILENAME_PRODUCTS_ATTRIBUTES, BOX_CATALOG_CATEGORIES_PRODUCTS_ATTRIBUTES) . tep_admin_files_boxes(FILENAME_PRODUCTS_CATEGORY_OPTIONS, BOX_CATALOG_CATEGORIES_PRODUCTS_CATEGORY_OPTIONS) . tep_admin_files_boxes(FILENAME_PRODUCTS_MULTI, BOX_CATALOG_CATEGORIES_PRODUCTS_MULTI) . tep_admin_files_boxes(FILENAME_MANUFACTURERS, BOX_CATALOG_MANUFACTURERS) . tep_admin_files_boxes(FILENAME_REVIEWS, BOX_CATALOG_REVIEWS) . tep_admin_files_boxes(FILENAME_SHOPBYPRICE, BOX_CATALOG_SHOP_BY_PRICE) . tep_admin_files_boxes(FILENAME_XSELL_PRODUCTS, BOX_CATALOG_XSELL_PRODUCTS) . tep_admin_files_boxes(FILENAME_FEATURED, BOX_CATALOG_FEATURED) . tep_admin_files_boxes(FILENAME_PRODUCTS_EXPECTED, BOX_CATALOG_PRODUCTS_EXPECTED). tep_admin_files_boxes(FILENAME_MORE_CATEGORIES,BOX_CATALOG_MORE_CATEGORIES) . tep_admin_files_boxes(FILENAME_PRODUCTS_EXTRA_FIELDS,BOX_CATALOG_PRODUCTS_EXTRA_ FIELDS)); //Admin end } $box = new box; echo $box->menuBox($heading, $contents); ?> </td> </tr> <!-- catalog_eof //-->
  7. Yes I do understand about working on free contributions. ;-) Just wanting to make sure that I understand what the code was supposed to do. So does this mean there is no such feature yet in the code called Gift Voucher? Can someone confirm that I am correct in my evaluation of the feature set for the Discount Coupon piece? Rob.
  8. macmizer

    Discount Coupon Codes download

    Please see my message below. I fixed the one issue with the discount not showing on the order on the customer side. I had to fix the sort order inside of Admin/modules/coupons. The sort order number was the same as another Order total item. Now I see the discount being applied. Please read the rest below. I cannot see anything that pertains to Gift Voucher and the Discount. Only see a very limited Discount Coupon contribution.
  9. macmizer

    Discount Coupon Codes download

    I have installed the following per a reference from GLCustoms here on oscommerce forums: http://addons.oscommerce.com/info/5743 It is called Gift Voucher (GV) and Discount Coupons (DC) for RC1, RC2, RC2a Luckily I had installed a brand new fresh copy of Ver 2.2 RC2 so all I had to do was overwrite files. I did so and loaded the sql tables that came with it. But when I follow the instructions to install a Discount coupon and it seems that this add on has alot less features then I would expect for a discount coupon feature. I can't even assign the coupon to a specific product or category or limit how long the coupon is good for. Furthermore, I do not see anything in the admin interface that pertains to Gift Voucher. This contrib refers to Gift Voucher and Discount Coupons. Where is the Gift Voucher config? Why does the discount coupon seem so limited? Another problem... no discount is being deducted from the order. I cash/cod set right now as a payment module. When I enter the coupon code where applicable, no discount appears for that order even if I confirm the order. I have tried either fix amount for a discount or percentage. Neither shows a deduction on the order.
  10. I have installed the following per a reference from GLCustoms here on oscommerce forums: http://addons.oscommerce.com/info/5743 It is called Gift Voucher (GV) and Discount Coupons (DC) for RC1, RC2, RC2a Luckily I had installed a brand new fresh copy of Ver 2.2 RC2 so all I had to do was overwrite files. I did so and loaded the sql tables that came with it. But when I follow the instructions to install a Discount coupon and it seems that this add on has alot less features then I would expect for a discount coupon feature. I can't even assign the coupon to a specific product or category or limit how long the coupon is good for. Furthermore, I do not see anything in the admin interface that pertains to Gift Voucher. This contrib refers to Gift Voucher and Discount Coupons. Where is the Gift Voucher config? Why does the discount coupon seem so limited?
  11. macmizer

    Discount Coupon Codes download

    What is the difference between the MS version of osCommerce and RC version of osCommerce? I just installed the RC version since that is what I found on the downloads section of this oscommerce.com site. So now I have a fresh install.
  12. I see that the Discount Coupon Codes has several files on the contribution section. But for the past 5 or 6 uploads they are just fixes. I wanted to get a full copy of the Discount Coupon Codes with all the fixes embedded into it. Unless I am stuck downloading the full package from Sep 27, 2007 called Discount Coupon Codes 3.31. Please tell me I don't have to dowload the other 6 updates after that. Looks like the latest full package was on Sep 27. What is the difference between this contribution Discount Coupon Codes and the coupons built in already with osCommerce?
  13. macmizer

    Get 1 Free

    I have added this contribution and it seemed to be working fine at first. For example, we setup all 5 products we have in the catalog to offer buy 2 and get 1 of the same product free. If I go to any one of the products and say Buy Now it will allow me to change the quantity from 1 to 2 and then I will see two different items in my cart. One will show the two products I am buying as well as the total price for both and then it will show a 2nd pic of the same product I ordered 2 of. This time on the 2nd item it will show quantity of "1" and no cost. This is all well and good. But here is the problem, all of the products we sell have an attribute for the different flavors we sell. So for one product I may have three different flavors. If I order one chocolate and one vanilla, the buy 2 get one free does not work any longer. I can order one chocolate and then one vanilla and then add one chocolate again for a total of 2 chocolates. Then I have three line items in my cart, the one vanilla with a price next to it, 2 chocolates with the total of both items then a third line item that shows a price of $0.00. Now the first two line items have the name of the flavor right below the product name but for the freebie item it never shows the flavor the person is getting which in my test case would be chocolate. Is there some kind of workaround for this? Since the admin piece does not give me control over the attributes of the product I don't see a way around this. So if I have 3 to 5 flavors of a product I will have to create 3 or 5 seperate products all with identical info and just change the name of the product to include the flavor. Not an option we want to do. So to recap there are two issues, teh free product does not show the attribute of the product that is included free and when buying two of one item if there is an attribute involved it will not work either. Anyone have any ideas?
  14. I am getting this same problem. I have installed the latest version of this contribution. I took it from the contributions here and it is called Shipdate v2.3 Terra 8 Nov 2006 After doing the installation and rechecking everything three or four times I get the following on the checkout_shipping page. It states the title fo the page Delivery Information then right below it there is "Select Arrival Date" but then the rest of the page is blank. My webserver error log states: PHP Fatal error: Cannot redeclare class shippingschedule in /var/www/vhosts/t5photo.com/httpdocs/includes/classes/shipsched.php on line 3, referer: http://www.t5photo.com/shopping_cart.php I am not sure why I am getting this type of error. Can anyone help?
  15. I have installed the latest version of this contribution. I took it from the contributions here and it is called Shipdate v2.3 Terra 8 Nov 2006 After doing the installation and rechecking everything three or four times I get the following on the checkout_shipping page. It states the title fo the page Delivery Information then right below it there is "Select Arrival Date" but then the rest of the page is blank. My webserver error log states: PHP Fatal error: Cannot redeclare class shippingschedule in /var/www/vhosts/t5photo.com/httpdocs/includes/classes/shipsched.php on line 3, referer: http://www.t5photo.com/shopping_cart.php I am not sure why I am getting this type of error. Can anyone help?
×