muhammad_barki

Hi pbpools, I noticed you got the lightbox working with more pics. Would you be kind enough to give me the code that you changed? Thanks.

Thanks Robert. Just needed some help finding where the issue was. Doing a favour for a friend, i.e. not setting up a cheap template but keeping the site up and running with that cheap template. I showed the attitude because I didnt like your way of saying I will see if I can find what bit javascript is causing the module to fail.

Cheap or expensive, who cares. Do you have the solution or not?

Hi, I will appriciate if anyone can be of assistance to me. I have installed the latest (205) version of the addon and it appears as if the URLs are being generated correctly. The issue comes when I click on any of the product URLs. I am being redirected to the homepage of the website. .htaccess file is in the right place with the right settings. In fact I have the same addon working just fine on another domain on the same server. Any clues what the issue could be? URI format is set to path_rewrite on MySQL

Hi, Has anyone come across this issue where all the product links get redirected to the homepage. For example, if I type in http://www.localhost.com/quisque-accumsan/product-104-p-104.html,'>http://www.localhost.com/quisque-accumsan/product-104-p-104.html, I get redirected to http://www.localhost.com/ The SEO URL settings I am using are as follows: Select your chosen cache system? mysql Choose the uri format path_rewrite Choose how your product link text is made up c Add category parent to beginning of category uris? true Add cPath to product URLs? true Force www.mysite.com/ when www.mysite.com/index.php false The .htaccess has been taken from the extras folder that came with the addon. Removing the .htaccess file give me a 404 error on the product link. Any ideas what so ever? It may be worth mentioning that the I have used the same addon on another website, same server, same settings, same .htaccess file and all is good there.

Hi, Yes, I have followed the instructions for modifying EP to enable import and export of shipping prices. I have also narrowed the issue down to the UPDATE query. The EP works fine on INSERT but when it comes to updating the fields it doesnt update the shipping prices. Here is my update query. // update products table with indv shipping $query = "UPDATE " . TABLE_PRODUCTS . " as p JOIN " . TABLE_PRODUCTS_SHIPPING . " ps ON p.products_id=ps.products_id SET p.products_price='$v_products_price', ps.products_ship_price='$v_products_ship_price', ps.products_ship_price_two='$v_products_ship_price_two', $tmp_products_image_update $ep_additional_updates p.products_weight='$v_products_weight', p.products_tax_class_id='$v_tax_class_id', p.products_date_available=".$v_date_avail.", p.products_date_added=".$v_date_added.", p.products_last_modified='".date("Y-m-d H:i:s")."', p.products_quantity = $v_products_quantity, p.manufacturers_id = ".(!empty($v_manufacturer_id)?$v_manufacturer_id:'NULL').", p.products_status = $v_db_status WHERE (p.products_id = $v_products_id AND ps.products_id=$v_products_id) "; tep_db_query($query); //$v_products_id = tep_db_insert_id();

Hi, I was wondering if any one can help me with this issue. I have just installed the 'Individual Product Shipping Prices - v.4.5' and have tried to integrate it with the already installed 'Easy Populate 2.76i-MS2'. EP exports the file perfectly fine but when it comes to importing data, EP doesnt add the shipping prices to the database. It updates all the other details of products as normal. Has any come across such issue and knows how to fix it? If not then is someone using these 2 contributes together successfully? If so, will it possible for them to upload their easypopulate.php so I can compare it with mine? Thanks.

Hi Chris, Yes, I had been using v2.03 and just tested the new v2.06 and I am quite happy to say that it is a much more mature and up-to-the-standards version. Not to mention that it has resolved the problem of users being able to select the £0.00 shipping option for overweighted products. So, I guess you dont have to worry about: Thanks for the new version, now I can happily move back to using this contribution. Regards, Muhammad Barki.

Hi Chris, I dont know if its just me or is it actually a feature of this module? And though its one of the best produced mods that I have come across, it for some reason puts me off when it comes to using it and I end up using Table based shipping mod in the end. Well, the issue is that, if we take the scenario below: Royal Mail Standard Parcels The shipping rate cannot be determined at this time £0.00 Royal Mail Special Delivery Delivery Weight : 5 Kg's (Insured upto £500, ships Nextday) £21.65 Parcelforce 48 Delivery Weight : 5 Kg's (Insured upto £500, ships within 48 Hours) £27.99 Now, I am fine with package not being able to be shipped by Royal Mail Standard Parcels method because of weight restrictions. But if Royal Mail Standard Parcels method is not suitable for this package, then why does it appear or why does it still offer the customer the option to select it and checkout with £0.00 on delivery. Can't the options which cannot handle the increased weights be disabled or something? So, only those options appear in the frontend which can either handle the delivery weight or atleast have the radio buttons disabled, so customer cant select them Or is it actually me doing something wrong and havnt understood the mod correctly? Please, let me know. Thanks.

For me, the solution offered by Ron has worked. I deleted the shipping modules folder along with the module files (e.g. flat.php, item.php, usp.php, etc) on the server and uploaded an old folder from the backup I had taken somewhile back. All seems to be working fine now. I hope this solution works for others too. Cheers.

Hi, I am facing a bizar problem in my shops admin panel. Under modules, the 'Shipping' modules page isnt showing the Info panel, which allows the installation, editing and uninstallation of different shipping modules. Admin panel uses admin/modules.php page to show the 'Payment', 'Shipping' & 'Order Total' modules. I can access the Info panel on 'Payment' and 'Order Total', but when I click on 'Shipping' link, the info panel goes missing. Any ideas why and where is something wrong?? The image below is of 'Shipping' module, which doesnt have an Info panel This is what the other modules page look like and so should the 'Shipping' module page.

As Kymation mentioned here: http://www.oscommerce.com/forums/index.php?sho...t&p=1351670 Its a typo, Change p.image_filename to pi.image_filename and you will hopefully have it working.

Thanks Buddy!

Where is this tep_remove_product(()) funtion located and how am i supposed to edit it to avoid deleting all the images? Thanks.

Can any one expand a little bit more on this please??

Brilliant!!!! It worked like a charm. Thanks.

I am having a similar issue. By enabling 'Options as images' contribution, all the code which is to execute after [include ('options_images.php');] on product_info.php page stops working. Any ideas why is this happening?

By the way, I havent yet updated to version 2.0.3. I am still on 2.0.2. I tried your settings and now the MAIN PRODUCT IMAGE on the product_info page appears along with the rest of the images in the popup window. Which is perfectly fine. Here is a working link with multiple images: http://www.vkjewellers.co.uk/product_info.php?products_id=3 The problem now remains that: If I only have one MAIN PRODUCT IMAGE, the popup window displays that image with LEFT AND RIGHT arrows at the bottom and they are actually clickable. I dont want those arrows to appear if there is only one image. I think there is something wrong with the popup_image.php image number checking code. Here is the link to a product with a single image: http://www.vkjewellers.co.uk/product_info....p;products_id=1 And here is my popup_image.php code: <?php /* $Id: popup_image.php,v 1.18 2003/06/05 23:26:23 hpdl Exp $ $Mod: 20081216 More Pics 2.0 kymation $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); $navigation->remove_current_page(); // BOF - Extra Pictures Enhancement // // BOF removed for EP enhancement // //$products_query = tep_db_query("select pd.products_name, p.products_image from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and pd.language_id = '" . (int)$languages_id . "'"); //$products = tep_db_fetch_array($products_query); // EOF removed for EP enhancement // $PID = (int) $_GET['pID']; $display = (int) $_GET['display']; if ($PID != 0) { // Do nothhing if there is no PID // Add restrictions to the query based on admin settings $and_sql = ''; if (MORE_PICS_GROUP_WITH_CATEGORY == 'false') { $and_sql .= " and category_page = '0' "; } if (MORE_PICS_GROUP_WITH_PRODUCTS == 'false') { $and_sql .= " and product_page = '0' "; } $products_query = tep_db_query ("select products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . $PID . "' and language_id = '" . (int) $languages_id . "' "); $products = tep_db_fetch_array ($products_query); $image_no = 0; $images_array = array(); $products_images_query = tep_db_query ("select images_id, image_filename from " . TABLE_PRODUCTS_IMAGES . " where products_id = '" . $PID . "' " . $and_sql . " order by images_order ASC "); // Commented out due to the above query update // $products_query = tep_db_query ("select products_name // from " . TABLE_PRODUCTS_DESCRIPTION . " // where products_id = '" . $PID . "' // " . $and_sql . " // and language_id = '" . (int) $languages_id . "' // "); // $products = tep_db_fetch_array ($products_query); // // $image_no = 0; // $images_array = array(); // $products_images_query = tep_db_query ("select images_id, // image_filename // from " . TABLE_PRODUCTS_IMAGES . " // where products_id = '" . $PID . "' // order by images_order ASC // "); $num_products_images = tep_db_num_rows ($products_images_query); $last_image = $num_products_images - 1; $max_images = (int) MORE_PICS_NUMBER_OF_ROWS * MORE_PICS_NUMBER_OF_COLS; if ($max_images < $last_image) { $last_image = $max_images; } while ($products_images = tep_db_fetch_array ($products_images_query) ) { $images_array[$image_no] = $products_images['image_filename']; $image_no++; } // Get next & previous IDs and the current image name switch ($display) { case 0: $previous_image_id = -1; if (MORE_PICS_WRAP_POPUP_IMAGES == 'true') { $previous_image_id = $last_image; } $current_image = $images_array[0]; $next_image_id = $display + 1; break; case $last_image: $previous_image_id = $last_image - 1; $current_image = $images_array[$last_image]; $next_image_id = -1; if (MORE_PICS_WRAP_POPUP_IMAGES == 'true') { $next_image_id = 0; } break; default: $previous_image_id = $display - 1; $current_image = $images_array[$display]; $next_image_id = $display + 1; } // EOF - Extra Pictures Enhancement // ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo $products['products_name']; ?></title> <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <script language="javascript"><!-- var i=0; function resize() { <!-- // BOF - Extra Pictures Enhancement // --> /* if (navigator.appName == 'Netscape') i=40; if (document.images[0]) window.resizeTo(document.images[0].width +30, document.images[0].height+160-i);*/ if (document.layers) i=40; if (document.images[0]) window.resizeTo(document.images[0].width +50, document.images[0].height+150); <!-- // EOF - Extra Pictures Enhancement // --> self.focus(); } //--></script> <!-- // BOF - Extra Pictures Enhancement // --> <meta http-equiv="Page-Enter" content="blendTrans(Duration=0.5)"> <meta http-equiv="Page-Exit" content="blendTrans(Duration=0.5)"> <!-- // EOF - Extra Pictures Enhancement // --> </head> <body onLoad="resize();"> <!-- // BOF - Extra Pictures Enhancement // --> <?php //echo tep_image(DIR_WS_IMAGES . $products['products_image'], $products['products_name']); ?> <table border="0" cellpadding="0" cellspacing="0" align="center"> <?php /* // // for use if you want to define a maximum width and height for the large popup images. // This is a waste of your bandwidth -- just size the images correctly before you upload // $max_width=0; $max_height=0; $img = DIR_WS_IMAGES . $current_image; list($width, $height, $type, $attr) = getimagesize($img); if ($max_width!=0 && $max_width<$width && $max_height!=0 && $max_height<$height) { if (($max_width-$width)>($max_height-$height)) { $width = $max_width; $height = 0; } else { $width = 0; $height = $max_height; } } elseif ($max_width!=0 && $max_width<$width) { $width = $max_width; $height = 0; } elseif ($max_height!=0 && $max_height<$height) { $width = 0; $height = $max_height; } echo '<tr><td align="center"><img src="' . $img . '"' . (($width!=0)?' width="'.$width.'"':'') . (($height!=0)?' height="'.$height.'"':'') . '></td>'; */ // // to use the above code, you must remove the next line. echo '<tr><td align="center"><img src="' . DIR_WS_IMAGES . $current_image . '"></td>'; ?> </tr> <tr> <td height="0" align="center"></td> </tr> <tr> <td height="20" align="center"> <?php if ($previous_image_id != -1 || $next_image_id != -1) { echo '<hr color="#666" size="1">'; } if ($previous_image_id != -1){ echo '<a href="' . tep_href_link (FILENAME_POPUP_IMAGE, 'pID=' . $PID . '&display=' . $previous_image_id) . '">' . tep_image (DIR_WS_IMAGES . 'left.gif', 'previous', '', '', 'border="0"') . '</a>'; } if ($next_image_id != -1){ echo '<a href="' . tep_href_link (FILENAME_POPUP_IMAGE, 'pID=' . $PID . '&display=' . $next_image_id) . '">' . tep_image (DIR_WS_IMAGES . 'right.gif', 'next', '', '', 'border="0"') . '</a>'; } ?> </td> </tr> </table> <!-- // EOF - Extra Pictures Enhancement // --> </body> </html> <?php require('includes/application_bottom.php'); // BOF - Extra Pictures Enhancement // } // if ($PID // EOF - Extra Pictures Enhancement // ?> Please have a look and get me out of my misery. Thanks.

Explain me one more thing please. If I add 2 additional images to a product, I can only select any 2 appear in the popup window and the remaining one to appear as the main image with product description. Now this feature is turning into a bug, because if I only have one product image and I click on ZOOM button, the popup window shows the LEFT and RIGHT arrows but no image. Do you think there is a work around it? or will i need to upload the same image as popup image?

Any chances of an update with More Pics v2.0.2 and above supported with Easy Populate 2.67g?

Also Jim, any ideas of when will you be working on an update for Easy Pouplate's integration with More Pics 2.0.2?

Hi Jim, This is what I get, after modifying my admin/categories.php file and SQL: 1054 - Unknown column 'p.image_filename' in 'field list' select p.products_id, pd.products_name, p.products_quantity, p.image_filename, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from products p left join products_images pi on p.products_id = pi.products_id, products_description pd, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = '1' and pi.product_page = '1' order by pd.products_name Any Clues???

Thanks Jim! The update worked!!!

Rite! yes, i noticed that in the upgrade.sql file.... but after applying the SQL update, i am still getting the same error. i think its because the popup_image.php file is executing the query on 'PRODUCT_DESCRIPTION' table and your SQL update is for 'PRODUCT_IMAGES' table. I did get the additional images thingi working. thanks for that. now i need to just change the HTML to suite my template and hopefully it will be working fine. Hopefully the update you are working on will solve these issues and sorry about the crashing HD. Hoping to hear some good news from you soon.

Sorry if this has been brought up before!! I get the following error message, when i click on the ZOOM button to see more images. 1054 - Unknown column 'category_page' in 'where clause' select products_name from products_description where products_id = '48' and category_page = '0' and product_page = '0' and language_id = '1' I tried solving the above issue by adding the missing entity in the database and images poped up fine, but i am not if that is the right solution. and whether the issue below is related to this missing entity: in the popup window, i get the images with left and right arrows but with no sense of image numbers. By that i mean, when the last image in the popup approaches, the 'right' arrow doesnt disappear. Not to mention that i dont get all images displayed on the product_info page if i enable 'top', 'bottom' or ' middle', etc option. Only one image would appear with the zoom button at the bottom. Any idea why is this all happening??