X-Cart: shopping cart software

X-Cart forums (https://forum.x-cart.com/index.php)
-   News and Announcements (https://forum.x-cart.com/forumdisplay.php?f=28)
-   -   Have you noticed that upgrade to X-Cart 5.1.7 is available? (https://forum.x-cart.com/showthread.php?t=70293)

Ksenia 10-21-2014 01:44 AM
Have you noticed that upgrade to X-Cart 5.1.7 is available?
 
Hi X-Carters.

Have you noticed that upgrade to X-Cart 5.1.7 is available? The new version contains Free Shipping, News, Two-Factor auth; beautiful Contact Us and Akismet-the spam filter; Ogone, eSelect, PayU India, Yandex.Money and other changes.

Most of the improvements are described in this article:
http://blog.x-cart.com/5-1-7-released.html

What it doesn't cover is the changes in REST API. Different security keys for reading and writing for the sake of better security and other improvements. If you're interested, let's ask Tony to shed more light on it=)

Also, please pay attention to the Free Shipping module. We need a better understanding of how it should work from your point of view. That's why instead of "marketing text" on the module page I shifted the accent to the logic of the module. Please read, install, try and comment:
http://www.x-cart.com/extensions/addons/free-shipping.html

RichieRich 10-21-2014 06:58 AM
Re: Have you noticed that upgrade to X-Cart 5.1.7 is available?
 
Never experienced an error with upgrade before on 5.x until this one.

the upgrade went through, but then opened the storefront to get error message.

Code:

ERROR: "42" (code N/A)

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'x5_x5_orders' doesn't exist SQL query: SELECT t0.order_id AS order_id1, t0.shipping_id AS shipping_id2, t0.shipping_method_name AS shipping_method_name3, t0.payment_method_name AS payment_method_name4, t0.tracking AS tracking5, t0.date AS date6, t0.lastRenewDate AS lastRenewDate7, t0.notes AS notes8, t0.adminNotes AS adminNotes9, t0.orderNumber AS orderNumber10, t0.total AS total11, t0.subtotal AS subtotal12, t0.profile_id AS profile_id13, t0.orig_profile_id AS orig_profile_id14, t0.payment_status_id AS payment_status_id15, t0.shipping_status_id AS shipping_status_id16, t0.currency_id AS currency_id17, t0.is_order FROM x5_x5_orders t0 WHERE t0.profile_id = ? AND t0.is_order IN ('0') LIMIT 1 SQL query parameters: array ( 0 => 4, )

Soft reset has made it work again.

Brian Watts 10-21-2014 09:36 AM
Re: Have you noticed that upgrade to X-Cart 5.1.7 is available?
 
Tried to install 5.1.7 on development site. error in cache #8
Soft reset did not work

The site is temporarily closed for maintenance
We are deploying new changes to our store. One minute and they will go live!

tony_sologubov 10-21-2014 11:32 AM
Re: Have you noticed that upgrade to X-Cart 5.1.7 is available?
 
RichieRich did you have any 3rd party modules installed? If so, which ones?

[bBrian][/b] could you please check php_errors log in the <X-Cart>/var/log folder? There should be an exact error message that explains what happened.

Tony.

Brian Watts 10-21-2014 11:57 AM
Re: Have you noticed that upgrade to X-Cart 5.1.7 is available?
 
<?php die(1); ?>
[21-Oct-2014 13:27:30] Error (code: 0): Binding entities to query parameters only allowed for entities that have an identifier.
Server API: cgi-fcgi;
Request method: GET;
URI: /admin.php?target=upgrade&1413912448.86&cpid=4e2fb0 5c05552f9400df56a91b5b85aa;
Backtrace:
#0 /home/devrocket/public_html/lib/Doctrine/ORM/AbstractQuery.php(245): Doctrine\ORM\AbstractQuery->convertObjectParameterToScalarValue(Object(XLite\ Model\Cart))
#1 /home/devrocket/public_html/lib/Doctrine/ORM/AbstractQuery.php(216): Doctrine\ORM\AbstractQuery->processParameterValue(Object(XLite\Model\Cart))
#2 /home/devrocket/public_html/lib/Doctrine/ORM/AbstractQuery.php(284): Doctrine\ORM\AbstractQuery->setParameter('order', Object(XLite\Model\Cart), 2)
#3 /home/devrocket/public_html/lib/Doctrine/ORM/QueryBuilder.php(217): Doctrine\ORM\AbstractQuery->setParameters(Array, Array)
#4 /home/devrocket/public_html/var/run/classes/XLite/Model/QueryBuilder/AQueryBuilder.php(83): Doctrine\ORM\QueryBuilder->getQuery()
#5 /home/devrocket/public_html/var/run/classes/XLite/Module/BCSE/CustomerRewards/Model/Repo/Points.php(215): XLite\Model\QueryBuilder\AQueryBuilder->getResult()
#6 /home/devrocket/public_html/var/run/classes/XLite/Module/BCSE/CustomerRewards/Model/Repo/Points.php(51): XLite\Module\BCSE\CustomerRewards\Model\Repo\Point s->searchResult(Object(XLite\Model\QueryBuilder\Base \Common))
#7 /home/devrocket/public_html/var/run/classes/XLite/Module/BCSE/CustomerRewards/Model/Repo/Points.php(156): XLite\Module\BCSE\CustomerRewards\Model\Repo\Point s->search(Object(XLite\Core\CommonCell))
#8 /home/devrocket/public_html/var/run/classes/XLite/Module/BCSE/CustomerRewards/Logic/Order/Modifier/PointsDiscount.php(37): XLite\Module\BCSE\CustomerRewards\Model\Repo\Point s->findPaymentByOrder(Object(XLite\Model\Cart))
#9 [internal function]: XLite\Module\BCSE\CustomerRewards\Logic\Order\Modi fier\PointsDiscount->calculate()
#10 /home/devrocket/public_html/var/run/classes/XLite/Model/Order/Modifier.php(89): call_user_func_array(Array, Array)
#11 /home/devrocket/public_html/var/run/classes/XLite/Model/OrderAbstract.php(1967): XLite\Model\Order\Modifier->__call('calculate', Array)
#12 /home/devrocket/public_html/var/run/classes/XLite/Model/OrderAbstract.php(1967): XLite\Model\Order\Modifier->calculate()
#13 /home/devrocket/public_html/var/run/classes/XLite/Model/CartAbstract.php(193): XLite\Model\OrderAbstract->calculate()
#14 /home/devrocket/public_html/var/run/classes/XLite/Model/OrderAbstract.php(2006): XLite\Model\CartAbstract->calculate()
#15 /home/devrocket/public_html/var/run/classes/XLite/Model/CartAbstract.php(138): XLite\Model\OrderAbstract->renew()
#16 /home/devrocket/public_html/var/run/classes/XLite/Module/XC/ProductVariants/Model/ProductVariantAbstract.php(349): XLite\Model\CartAbstract::getInstance()
#17 /home/devrocket/public_html/var/run/classes/XLite/Module/XC/ProductVariants/Model/ProductVariantAbstract.php(360): XLite\Module\XC\ProductVariants\Model\ProductVaria ntAbstract->getLockedItems()
#18 /home/devrocket/public_html/var/run/classes/XLite/Module/XC/ProductVariants/Model/ProductVariantAbstract.php(310): XLite\Module\XC\ProductVariants\Model\ProductVaria ntAbstract->getLockedAmount()
#19 /home/devrocket/public_html/var/run/classes/XLite/Module/XC/ProductVariants/Model/ProductVariantAbstract.php(298): XLite\Module\XC\ProductVariants\Model\ProductVaria ntAbstract->getAvailableAmount()
#20 /home/devrocket/public_html/var/run/classes/XLite/Module/XC/ProductVariants/Model/Product.php(170): XLite\Module\XC\ProductVariants\Model\ProductVaria ntAbstract->isOutOfStock()
#21 /home/devrocket/public_html/var/run/classes/XLite/Module/XC/ProductVariants/Model/Product.php(151): XLite\Module\XC\ProductVariants\Model\Product->defineDefaultVariant()
#22 /home/devrocket/public_html/var/run/classes/XLite/Module/XC/ProductVariants/Model/Product.php(195): XLite\Module\XC\ProductVariants\Model\Product->getDefaultVariant()
#23 /home/devrocket/public_html/var/run/classes/XLite/Model/ProductAbstract.php(545): XLite\Module\XC\ProductVariants\Model\Product->getClearPrice()
#24 /home/devrocket/public_html/var/run/classes/XLite/Core/QuickData.php(158): XLite\Model\ProductAbstract->getQuickDataPrice()
#25 /home/devrocket/public_html/var/run/classes/XLite/Core/QuickData.php(123): XLite\Core\QuickData->updateData(Object(XLite\Model\Product), Object(XLite\Model\Membership))
#26 /home/devrocket/public_html/var/run/classes/XLite/Core/QuickData.php(60): XLite\Core\QuickData->updateProductDataInternal(Object(XLite\Model\Prod uct))
#27 /home/devrocket/public_html/Includes/Decorator/Plugin/Doctrine/Plugin/QuickData/Main.php(45): XLite\Core\QuickData->update()
#28 /home/devrocket/public_html/Includes/Decorator/Utils/PluginManager.php(71): Includes\Decorator\Plugin\Doctrine\Plugin\QuickDat a\Main->executeHookHandler()
#29 /home/devrocket/public_html/Includes/Decorator/Utils/CacheManager.php(823): Includes\Decorator\Utils\PluginManager::invokeHook ('step_eight')
#30 [internal function]: Includes\Decorator\Utils\CacheManager::executeStep Handler8()
#31 /home/devrocket/public_html/Includes/Utils/Operator.php(218): call_user_func_array(Array, Array)
#32 /home/devrocket/public_html/Includes/Decorator/Utils/CacheManager.php(636): Includes\Utils\Operator::executeWithCustomMaxExecT ime('600', Array)
#33 /home/devrocket/public_html/Includes/Decorator/Utils/CacheManager.php(654): Includes\Decorator\Utils\CacheManager::runStep(8)
#34 /home/devrocket/public_html/Includes/Decorator/Utils/CacheManager.php(946): Includes\Decorator\Utils\CacheManager::runStepCond itionally(8)
#35 /home/devrocket/public_html/top.inc.PHP53.php(108): Includes\Decorator\Utils\CacheManager::rebuildCach e()
#36 /home/devrocket/public_html/top.inc.php(45): require_once('/home/devrocket...')
#37 /home/devrocket/public_html/admin.php(35): require_once('/home/devrocket...')
#38 {main}

[21-Oct-2014 13:31:41] Error (code: 0): Binding entities to query parameters only allowed for entities that have an identifier.
Server API: cgi-fcgi;
Request method: GET;
URI: /admin.php?target=main&1413912700.12&cpid=c73290c38 c0bff28b08c8e9e5054a927;
Backtrace:
#0 /home/devrocket/public_html/lib/Doctrine/ORM/AbstractQuery.php(245): Doctrine\ORM\AbstractQuery->convertObjectParameterToScalarValue(Object(XLite\ Model\Cart))
#1 /home/devrocket/public_html/lib/Doctrine/ORM/AbstractQuery.php(216): Doctrine\ORM\AbstractQuery->processParameterValue(Object(XLite\Model\Cart))
#2 /home/devrocket/public_html/lib/Doctrine/ORM/AbstractQuery.php(284): Doctrine\ORM\AbstractQuery->setParameter('order', Object(XLite\Model\Cart), 2)
#3 /home/devrocket/public_html/lib/Doctrine/ORM/QueryBuilder.php(217): Doctrine\ORM\AbstractQuery->setParameters(Array, Array)
#4 /home/devrocket/public_html/var/run/classes/XLite/Model/QueryBuilder/AQueryBuilder.php(83): Doctrine\ORM\QueryBuilder->getQuery()
#5 /home/devrocket/public_html/var/run/classes/XLite/Module/BCSE/CustomerRewards/Model/Repo/Points.php(215): XLite\Model\QueryBuilder\AQueryBuilder->getResult()
#6 /home/devrocket/public_html/var/run/classes/XLite/Module/BCSE/CustomerRewards/Model/Repo/Points.php(51): XLite\Module\BCSE\CustomerRewards\Model\Repo\Point s->searchResult(Object(XLite\Model\QueryBuilder\Base \Common))
#7 /home/devrocket/public_html/var/run/classes/XLite/Module/BCSE/CustomerRewards/Model/Repo/Points.php(156): XLite\Module\BCSE\CustomerRewards\Model\Repo\Point s->search(Object(XLite\Core\CommonCell))
#8 /home/devrocket/public_html/var/run/classes/XLite/Module/BCSE/CustomerRewards/Logic/Order/Modifier/PointsDiscount.php(37): XLite\Module\BCSE\CustomerRewards\Model\Repo\Point s->findPaymentByOrder(Object(XLite\Model\Cart))
#9 [internal function]: XLite\Module\BCSE\CustomerRewards\Logic\Order\Modi fier\PointsDiscount->calculate()
#10 /home/devrocket/public_html/var/run/classes/XLite/Model/Order/Modifier.php(89): call_user_func_array(Array, Array)
#11 /home/devrocket/public_html/var/run/classes/XLite/Model/OrderAbstract.php(1967): XLite\Model\Order\Modifier->__call('calculate', Array)
#12 /home/devrocket/public_html/var/run/classes/XLite/Model/OrderAbstract.php(1967): XLite\Model\Order\Modifier->calculate()
#13 /home/devrocket/public_html/var/run/classes/XLite/Model/CartAbstract.php(193): XLite\Model\OrderAbstract->calculate()
#14 /home/devrocket/public_html/var/run/classes/XLite/Model/OrderAbstract.php(2006): XLite\Model\CartAbstract->calculate()
#15 /home/devrocket/public_html/var/run/classes/XLite/Model/CartAbstract.php(138): XLite\Model\OrderAbstract->renew()
#16 /home/devrocket/public_html/var/run/classes/XLite/Module/XC/ProductVariants/Model/ProductVariantAbstract.php(349): XLite\Model\CartAbstract::getInstance()
#17 /home/devrocket/public_html/var/run/classes/XLite/Module/XC/ProductVariants/Model/ProductVariantAbstract.php(360): XLite\Module\XC\ProductVariants\Model\ProductVaria ntAbstract->getLockedItems()
#18 /home/devrocket/public_html/var/run/classes/XLite/Module/XC/ProductVariants/Model/ProductVariantAbstract.php(310): XLite\Module\XC\ProductVariants\Model\ProductVaria ntAbstract->getLockedAmount()
#19 /home/devrocket/public_html/var/run/classes/XLite/Module/XC/ProductVariants/Model/ProductVariantAbstract.php(298): XLite\Module\XC\ProductVariants\Model\ProductVaria ntAbstract->getAvailableAmount()

Brian Watts 10-21-2014 11:59 AM
Re: Have you noticed that upgrade to X-Cart 5.1.7 is available?
 
Continued::
#20 /home/devrocket/public_html/var/run/classes/XLite/Module/XC/ProductVariants/Model/Product.php(170): XLite\Module\XC\ProductVariants\Model\ProductVaria ntAbstract->isOutOfStock()
#21 /home/devrocket/public_html/var/run/classes/XLite/Module/XC/ProductVariants/Model/Product.php(151): XLite\Module\XC\ProductVariants\Model\Product->defineDefaultVariant()
#22 /home/devrocket/public_html/var/run/classes/XLite/Module/XC/ProductVariants/Model/Product.php(195): XLite\Module\XC\ProductVariants\Model\Product->getDefaultVariant()
#23 /home/devrocket/public_html/var/run/classes/XLite/Model/ProductAbstract.php(545): XLite\Module\XC\ProductVariants\Model\Product->getClearPrice()
#24 /home/devrocket/public_html/var/run/classes/XLite/Core/QuickData.php(158): XLite\Model\ProductAbstract->getQuickDataPrice()
#25 /home/devrocket/public_html/var/run/classes/XLite/Core/QuickData.php(123): XLite\Core\QuickData->updateData(Object(XLite\Model\Product), Object(XLite\Model\Membership))
#26 /home/devrocket/public_html/var/run/classes/XLite/Core/QuickData.php(60): XLite\Core\QuickData->updateProductDataInternal(Object(XLite\Model\Prod uct))
#27 /home/devrocket/public_html/Includes/Decorator/Plugin/Doctrine/Plugin/QuickData/Main.php(45): XLite\Core\QuickData->update()
#28 /home/devrocket/public_html/Includes/Decorator/Utils/PluginManager.php(71): Includes\Decorator\Plugin\Doctrine\Plugin\QuickDat a\Main->executeHookHandler()
#29 /home/devrocket/public_html/Includes/Decorator/Utils/CacheManager.php(823): Includes\Decorator\Utils\PluginManager::invokeHook ('step_eight')
#30 [internal function]: Includes\Decorator\Utils\CacheManager::executeStep Handler8()
#31 /home/devrocket/public_html/Includes/Utils/Operator.php(218): call_user_func_array(Array, Array)
#32 /home/devrocket/public_html/Includes/Decorator/Utils/CacheManager.php(636): Includes\Utils\Operator::executeWithCustomMaxExecT ime('600', Array)
#33 /home/devrocket/public_html/Includes/Decorator/Utils/CacheManager.php(654): Includes\Decorator\Utils\CacheManager::runStep(8)
#34 /home/devrocket/public_html/Includes/Decorator/Utils/CacheManager.php(946): Includes\Decorator\Utils\CacheManager::runStepCond itionally(8)
#35 /home/devrocket/public_html/top.inc.PHP53.php(108): Includes\Decorator\Utils\CacheManager::rebuildCach e()
#36 /home/devrocket/public_html/top.inc.php(45): require_once('/home/devrocket...')
#37 /home/devrocket/public_html/admin.php(35): require_once('/home/devrocket...')
#38 {main}

cflsystems 10-21-2014 02:33 PM
Re: Have you noticed that upgrade to X-Cart 5.1.7 is available?
 
@Tony

I just ran the upgrade to 5.1.7 from 5.1.6. And again I get the message I mentioned before after the upgrade
Quote:
Notice: Undefined index: name in /var/www/xcart-devs/xc5/var/run/classes/XLite/Core/Translation.php on line 474
Notice: Undefined index: name in /var/www/xcart-devs/xc5/var/run/classes/XLite/Core/Translation.php on line 474

Other than that everything else seems to be working fine.

I did not have time to go through all the improvements or new features but one thing caught my eye - now I can delete modules directly without the need to disable them first - this cuts off cache generation time in half on some situations when module is no longer needed - I like this improvement (I was just about to ask for it and why it is not implemented)

kevinrm 10-21-2014 08:23 PM
Re: Have you noticed that upgrade to X-Cart 5.1.7 is available?
 
Same exact situation as Richie Rich (ERROR: "42" (code N/A)), and no 3rd party mods. Soft reset seemed to work.

GreatLakesVacuum 10-22-2014 04:33 AM
Re: Have you noticed that upgrade to X-Cart 5.1.7 is available?
 
Mine upgraded fine even with a 3rd party module installed.

kevfromwiganinlancashire 10-22-2014 10:28 PM
Re: Have you noticed that upgrade to X-Cart 5.1.7 is available?
 
Mine upgraded with no problem but a few minutes after I left for work I got alerts about one of my sites down. When I tried others all were unavailable. I had to restart the server but the only we space I couldn't access was 5.1.7. I restored server from the mornings backup but still the same so restored from previous night and got into webspace but no store 503 error.

Will come back tonight

tony_sologubov 10-23-2014 05:48 AM
Re: Have you noticed that upgrade to X-Cart 5.1.7 is available?
 
Hi guys!

cflsystems Thanks for kind words. I just reported the problem with PHP indexes to the team.

Brian, could you please try to physically remove the following directory <X-Cart>/classes/XLite/Module/BCSE/CustomerRewards and try to rebuild the cache? Please, let me know if it works out.

RichieRich and kevfromwiganinlancashire just sent you an email.

kevinrm once I check the problem on RichieRich's store, I will post a solution here. If you need urgent assistance, please contact our support team via support@x-cart.com.

Tony.

tony_sologubov 10-23-2014 06:20 AM
Re: Have you noticed that upgrade to X-Cart 5.1.7 is available?
 
cflsystems

Could you please run the following query to your MySQL database:
Code:
select * from xc_language_labels where name="";

cflsystems 10-23-2014 06:27 AM
Re: Have you noticed that upgrade to X-Cart 5.1.7 is available?
 
No results.

tony_sologubov 10-23-2014 06:30 AM
Re: Have you noticed that upgrade to X-Cart 5.1.7 is available?
 
Thank you.

Brian Watts 10-23-2014 07:28 AM
Re: Have you noticed that upgrade to X-Cart 5.1.7 is available?
 
Quote:
Originally Posted by tony_sologubov
Hi guys!

cflsystems Thanks for kind words. I just reported the problem with PHP indexes to the team.

Brian, could you please try to physically remove the following directory <X-Cart>/classes/XLite/Module/BCSE/CustomerRewards and try to rebuild the cache? Please, let me know if it works out.

RichieRich and kevfromwiganinlancashire just sent you an email.

kevinrm once I check the problem on RichieRich's store, I will post a solution here. If you need urgent assistance, please contact our support team via support@x-cart.com.

Tony.

Tony
removed the BCSE directory and rubuild cache and site loaded again. template is a little odd though

kevfromwiganinlancashire 10-23-2014 10:02 AM
Re: Have you noticed that upgrade to X-Cart 5.1.7 is available?
 
Hello Tony I've just replied.


Quote:
Originally Posted by tony_sologubov
Hi guys!

cflsystems Thanks for kind words. I just reported the problem with PHP indexes to the team.

Brian, could you please try to physically remove the following directory <X-Cart>/classes/XLite/Module/BCSE/CustomerRewards and try to rebuild the cache? Please, let me know if it works out.

RichieRich and kevfromwiganinlancashire just sent you an email.kevinrm once I check the problem on RichieRich's store, I will post a solution here. If you need urgent assistance, please contact our support team via support@x-cart.com.

Tony.

Cheers,

Kevin Morley

tony_sologubov 10-23-2014 09:55 PM
Re: Have you noticed that upgrade to X-Cart 5.1.7 is available?
 
Quote:
Originally Posted by Brian Watts
Tony
removed the BCSE directory and rubuild cache and site loaded again. template is a little odd though

Please, report this problem to BCSE team:
http://www.bcsengineering.com/contact_us/

BCSE 10-27-2014 06:08 AM
Re: Have you noticed that upgrade to X-Cart 5.1.7 is available?
 
Quote:
Originally Posted by tony_sologubov
Please, report this problem to BCSE team:
http://www.bcsengineering.com/contact_us/

Wouldn't the template being a little odd be an X-cart upgrade issue though? Especially without the module installed?

Carrie

Brian Watts 10-27-2014 07:30 AM
Re: Have you noticed that upgrade to X-Cart 5.1.7 is available?
 
Quote:
Originally Posted by BCSE
Wouldn't the template being a little odd be an X-cart upgrade issue though? Especially without the module installed?

Carrie

Carrie,
when I refreshed to browser, template went back to normal

tony_sologubov 10-30-2014 02:37 AM
Re: Have you noticed that upgrade to X-Cart 5.1.7 is available?
 
Quote:
Originally Posted by BCSE
Wouldn't the template being a little odd be an X-cart upgrade issue though? Especially without the module installed?

Carrie

I did not notice any oddness, but could you please let me know what you mean exactly, Carrie?


All times are GMT -8. The time now is 01:26 PM.

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.