| ||||||||||
Shopping cart software Solutions for online shops and malls | ||||||||||
|
X-Cart Home | FAQ | Forum rules | Calendar | User manuals | Login |
Newest Products | ||||
|
|
Thread Tools | Search this Thread |
#211
|
|||||||
|
|||||||
Re: Newest Products
Anyone have any ideas? PLEASE???
here's one of the messages that I get: [22-Apr-2008 23:46:20] (shop: 23-Apr-2008 00:46:20) SQL error: Site : http://www.flawfulfibers.com Remote IP : 82.165.28.150 Logged as : SQL query : SELECT xcart_products.productid, IF(xcart_products_lng.productid != '', xcart_products_lng.product, xcart_products.product) as product, xcart_products.productcode, xcart_products.avail, xcart_products.min_amount, xcart_pricing.price, xcart_quick_prices.variantid, IFNULL(xcart_variants.avail, xcart_products.avail) as avail, IFNULL(xcart_variants.weight, xcart_products.weight) as weight, IFNULL(xcart_variants.productcode, xcart_products.productcode) as productcode, IF(xcart_classes.classid IS NULL,'','Y') as is_product_options, IF(xcart_variants.variantid IS NULL,'','Y') as is_variant, IF(xcart_images_T.id IS NULL, '', 'Y') as is_thumbnail, xcart_images_T.image_path, xcart_product_taxes.taxid FROM xcart_pricing, xcart_products LEFT JOIN xcart_products_lng ON xcart_products.productid = xcart_products_lng.productid AND code = 'US' LEFT JOIN xcart_quick_prices ON xcart_quick_prices.productid = xcart_products.productid AND xcart_quick_prices.membershipid = '0' LEFT JOIN xcart_product_memberships ON xcart_product_memberships.productid = xcart_products.productid LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid AND xcart_quick_prices.variantid = xcart_variants.variantid LEFT JOIN xcart_images_T ON xcart_images_T.id = xcart_products.productid LEFT JOIN xcart_product_taxes ON xcart_product_taxes.productid = xcart_products.productid INNER JOIN xcart_products_categories ON xcart_products_categories.productid = xcart_products.productid INNER JOIN xcart_categories ON xcart_categories.categoryid = xcart_products_categories.categoryid AND xcart_categories.avail = 'Y' LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_categories.categoryid WHERE (xcart_category_memberships.membershipid = '' OR xcart_category_memberships.membershipid IS NULL) AND xcart_products.forsale='Y' AND (xcart_product_memberships.membershipid = '' OR xcart_product_memberships.membershipid IS NULL) AND xcart_quick_prices.priceid = xcart_pricing.priceid AND xcart_products.productid = xcart_products_categories.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_products.productid = xcart_pricing.productid AND xcart_pricing.quantity = '1' AND xcart_pricing.membershipid = '0' AND xcart_products.product_type <> 'C' AND xcart_products.forsale <> 'B' AND (xcart_pricing.variantid = '0' OR xcart_variants.variantid = xcart_pricing.variantid) AND (IFNULL(xcart_variants.avail, xcart_products.avail) > '0' OR xcart_products.product_type NOT IN ('','N')) AND xcart_products.avail > 0 AND add_date > 1208321180 AND add_date < 1208925980 GROUP BY xcart_products.productid ORDER BY xcart_products.http://www.thoseguysfilms.com/forums/templates/subSilver/images/timuji/ogu/ asc LIMIT 600 Error code : 1064 Description : 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 '://www.thoseguysfilms.com/forums/templates/subSilver/images/timuji/ogu/ asc LIMI' at line 1 Request URI: /newproducts.php?days=7&sortby=http%3A%2F%2Fwww.tho seguysfilms.com%2Fforums%2Ftemplates%2FsubSilver%2 Fimages%2Ftimuji%2Fogu%2F&sortdirection=1 Backtrace: /home/flawfulf/public_html/include/func/func.db.php:180 /home/flawfulf/public_html/include/func/func.db.php:106 /home/flawfulf/public_html/include/func/func.db.php:322 /home/flawfulf/public_html/include/func/func.product.php:579 /home/flawfulf/public_html/newproducts.php:113 ------------------------------------------------- and here's the newproducts.php file that I have: Code:
__________________
xcart Gold Ver. 4.1.9 |
|||||||
#212
|
|||||||
|
|||||||
Re: Newest Products
Quote:
Anyone get the short description thing sorted out yet? I have the same problem. Mike
__________________
X-Cart 4.3.1 Buy Together Module, AlteredCart CDSEO Pro One Page Checkout, AlteredCart Smart Search, AlteredCart On Sale, AlteredCart |
|||||||
#213
|
|||||||
|
|||||||
Re: Newest Products
I think it's awful that the only way this can be fixed is through a purchase.
I have it working properly on the newproducts.php page, but can't get it to import onto the homepage. If anyone can come up with a FREE fix, I'd greatly appreciate it. |
|||||||
#214
|
|||||||
|
|||||||
Re: Newest Products
This works great in v4.1.10. Very customizable too.
Everyone with questions - COMPARE THE NEWEST.TPL file with your recommends.tpl, products.tpl, product.tpl, products_t.tpl, featured.tpl, etc... You can grab/borrow/steal code from any or all of these files to get your Newest products looking the way you want.
__________________
xCart Pro Version 4.0.17, 4.0.19, 4.1.8, 4.1.10, 4.1.11, 4.1.12 - retired xCart Pro Version 4.3.1 - production xCart Pro Version 4.5.1 - testing RHEL Platform |
|||||||
#215
|
|||||||
|
|||||||
Re: Newest Products
__________________
http://www.lingerieblowout.com Version 4.1.10 http://www.topnichewebsites.com Version 4.4.5 Michael |
|||||||
#216
|
|||||||
|
|||||||
Re: Newest Products
Oh... I thought Lingerie Blowout was a verb. I was expecting heavy lifting and ripping noises. My bad! :P
__________________
xCart Pro Version 4.0.17, 4.0.19, 4.1.8, 4.1.10, 4.1.11, 4.1.12 - retired xCart Pro Version 4.3.1 - production xCart Pro Version 4.5.1 - testing RHEL Platform |
|||||||
#217
|
|||||||
|
|||||||
Re: Newest Products
LOL MBA ... Funny
__________________
http://www.lingerieblowout.com Version 4.1.10 http://www.topnichewebsites.com Version 4.4.5 Michael |
|||||||
#218
|
|||||||
|
|||||||
Re: Newest Products
Looks like the post i said last works for ONLY the last newest product and then is replaced by the next newest one.... Not getting all the newest one in the list
Modified .. I got it to work ... Must of been a fluke - All OK
__________________
http://www.lingerieblowout.com Version 4.1.10 http://www.topnichewebsites.com Version 4.4.5 Michael |
|||||||
#219
|
|||||||
|
|||||||
Re: Newest Products
I am trying to add this mod per instructions, i can pull up the newproducts.php....however in step six it says
6. Edit $xcart_dir/skin1/customer/home_main.php Find: {else} {include file="common_templates.tpl"} {/if} Insert BEFORE: {elseif $main eq "newproducts"} {include file="customer/main/newproducts.tpl"} Now I didn't see a .php file in there and I am assuming they mean the .tpl file, in which case when I added said code, it made my site go blank....do i need to proceed with step7 to make it work?(ex bring back pics?)
__________________
Tool Experts X-Cart DB Version: 5.4.1.49 Windows |
|||||||
#220
|
|||||||||
|
|||||||||
Re: Newest Products
Quote:
Yes, it is {xcart_dir}/skin1/customer/home_main.tpl, not home_main.php (there is no such thing). I've corrected it in my notes but not in the zip file (see post #185). You need to complete step 7 for it to work correctly. 7. Edit $xcart_dir/include/func/func.product.php FIND (approx line 363): $fields[] = "$sql_tbl[products].productcode"; $fields[] = "$sql_tbl[products].avail"; Add AFTER: // newproducts .. needed for quantity to work on newproducts module $fields[] = "$sql_tbl[products].min_amount"; Step 8 is optional. By default it should be set for 7 days. Also, as many people have noticed, 4.1.x sorts products by the title by default. X-cart has no provisions for sorting by Add Date. The thread at http://forum.x-cart.com/showthread.php?t=38263 deals with this issue, but if you read the last post I am personally having a conflict with Add_Date and recommended products.
__________________
Two Separate X-Cart Stores Version 4.4.4 Gold - X-AOM - Vivid Dreams Aquamarine (modified) - Linux Mods - Newest Products - View All -, and a few others. Numerous upgrades from 4.0.x series. Integrated with Stone Edge Order Manager + POS Version 4.1.12 Gold (fresh install) - X-AOM - Linux Mods - XCSEO free |
|||||||||
|
|||
X-Cart forums © 2001-2020
|