X-Cart forums

[Victor D]

Originally Posted by Christofer

i added yesterday a product

Please PM me your FTP details. I'll take a look.

[yages]

Found this in my log file
The IP address is unkown to me
Is this Mod causing problems

[17-Sep-2009 21:56:33] (shop: 17-Sep-2009 21:56:33) SQL error:
Site : http://www.xxxxx.com.au
Remote IP : 72.20.99.171
Logged as :
SQL query : select count(*) from xcart_products where add_date > 1253188448, $Version=0 and add_date < 1253188593
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 ' $Version=0 and add_date < 1253188593' at line 1
Request URI: /home.php?cat=525
Backtrace:
/home/xxxx/public_html/include/func/func.db.php:180
/home/xxxx/public_html/include/func/func.db.php:106
/home/xxxx/public_html/include/func/func.db.php:347
/home/xxxx/public_html/modules/Whats_New/config.php:10
/home/xxxx/public_html/init.php:588
/home/xxxx/public_html/auth.php:44
/home/xxxx/public_html/home.php:38

[Jayk]

Originally Posted by yages

Found this in my log file
The IP address is unkown to me
Is this Mod causing problems

[17-Sep-2009 21:56:33] (shop: 17-Sep-2009 21:56:33) SQL error:
Site : http://www.xxxxx.com.au
Remote IP : 72.20.99.171
Logged as :
SQL query : select count(*) from xcart_products where add_date > 1253188448, $Version=0 and add_date < 1253188593
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 ' $Version=0 and add_date < 1253188593' at line 1
Request URI: /home.php?cat=525
Backtrace:
/home/xxxx/public_html/include/func/func.db.php:180
/home/xxxx/public_html/include/func/func.db.php:106
/home/xxxx/public_html/include/func/func.db.php:347
/home/xxxx/public_html/modules/Whats_New/config.php:10
/home/xxxx/public_html/init.php:588
/home/xxxx/public_html/auth.php:44
/home/xxxx/public_html/home.php:38

I see similar ones from time to time. I believe it may be when a visitor who visited your site before you installed the mod returns. It throws off the mod due to the date in the visitor's cookie. It doesn't seem to cause any problems except to log an error.

Jason

[Dorothy PCNC]

Hi Victor,

I've read through this whole thread and it seems I am having the same problems as some fo the others. When I first installed this mod, the new category showed up and I have some new products on my home page. Great I think....but I have since added new products and they are not registering on neither the New category page nor the home page. I am not using the bubble portion of the mod. I have already tried changing the days of the new products but that did nothing.

Can you help please? Thanks for the mod and the support.

Regard, Dorothy
printcutncreate.com

[mrerotic]

Victor any news on running 2 of these whats new on the site?

[Victor D]

Originally Posted by Dorothy PCNC

Hi Victor,

I've read through this whole thread and it seems I am having the same problems as some fo the others. When I first installed this mod, the new category showed up and I have some new products on my home page. Great I think....but I have since added new products and they are not registering on neither the New category page nor the home page. I am not using the bubble portion of the mod. I have already tried changing the days of the new products but that did nothing.

Can you help please? Thanks for the mod and the support.

Regard, Dorothy
printcutncreate.com

As I see from your Whats New category all its products added 21.09.2009 but these products are sorted in the reverse order and no pagination is available.
probably the last products are on the next pages

try this
in your products.php after the lines:
//+ + What's new
if ($active_modules["Whats_New"] && $WhatsNew == "Y"){
include "./modules/Whats_New/products.php";
}
//- - What's new
include $xcart_dir."/include/search.php";

add:

if ($active_modules["Whats_New"] && $WhatsNew == "Y"){
$products = array_reverse($products);
}

[Dorothy PCNC]

Thank you Victor for the reply...unfortunately your suggestion above did not work on my site. Is there anything else I can try?

Regards, Dorothy
printcutncreate.com

[mrerotic]

Victor - the category description does not show up. Can you please help me with this. I added exactly what you said to add. Also, I got it working for two different whats new sections. But please help on this last part. Thx

Also I want the categories to show up throughout all pages, but they disappear once I click into a subcategory. I followed the detailed instructions as well.

[Yalokin]

Hello.

we have 4.2.2
several time try to install automatically and manually both time need to run wn-install.php and on form first screen if click processed next page can not be found.

This happened with automatic installation however all permition were set correctly.

If I try to install manual I still need SQL pass and it is not provided in zip file.

With manual installation if you help me with sql do I really need to run installation file?

thank you for your help.

Originally Posted by Victor D

Do you update your inventory regularly? Do you know how to inform your visitors about fresh arrivals?

The solution is now available!

Just imagine - you are able:

• to create a virtual "New products" category shows all products added last week (month, quarter or any other time period);
• to have a personal pop-up notification to inform a particular customer about new products appear since his last visit.

This solution is FREE!

X-Cart-Customization.com team is glad to announce the "What's New?" module.

http://x-cart-customization.com/images/P/wnbox-200x260.png

Features:

• Javascript popup with a number of products added since last customer visit.
• Virtual "What's New" category with products added to your store within the specified time period.
• Both 4.1 and 4.2 X-Cart branches compatibility.
• Totally FREE!
• Completely open source! Feel free to modify.

Module screenshots:

http://x-cart-customization.com/images/marketplace/bubblefull_screenshot.gif

http://x-cart-customization.com/images/marketplace/bubble_screenshot.gif

http://x-cart-customization.com/images/marketplace/category_screenshot.gif

[JWait]

I am trying to install this on a test version of 4.2.2 and get the following when running wn_install.php

X-Cart installation... Warning: Cannot modify header information - headers already sent by (output started at /home/myaccount/public_html/xc42/wn_install.php:66) in /home/myaccount/public_html/xc42/include/sessions.php on line 74
Warning: Cannot modify header information - headers already sent by (output started at /home/myaccount/public_html/xc42/wn_install.php:66) in /home/myaccount/public_html/xc42/include/sessions.php on line 76
Warning: Cannot modify header information - headers already sent by (output started at /home/myaccount/public_html/xc42/wn_install.php:66) in /home/myaccount/public_html/xc42/include/sessions.php on line 85
Warning: Cannot modify header information - headers already sent by (output started at /home/myaccount/public_html/xc42/wn_install.php:66) in /home/myaccount/public_html/xc42/include/sessions.php on line 86
Warning: Cannot modify header information - headers already sent by (output started at /home/myaccount/public_html/xc42/wn_install.php:66) in /home/myaccount/public_html/xc42/include/sessions.php on line 93
Warning: Cannot modify header information - headers already sent by (output started at /home/myaccount/public_html/xc42/wn_install.php:66) in /home/myaccount/public_html/xc42/include/func/func.core.php on line 1819

Needless to say, it doesn't work.