View Single Post
  #14  
Old 04-01-2015, 10:39 AM
  zychen's Avatar 
zychen zychen is offline
 

Advanced Member
  
Join Date: Jul 2007
Posts: 48
 

Default Re: Changing Versions for Custom Modules

Hey Tony,

Quote:
Originally Posted by tony_sologubov
Could you please let me know what exactly MySQL error message did you get?

Here's the error log when I disable my custom module.

Quote:
<?php die(1); ?>
[01-Apr-2015 19:36:29] Error (code: 0): An exception occurred while executing 'ALTER TABLE xc_products DROP packSize, DROP POQty, DROP available, DROP techData, CHANGE sku sku VARCHAR(32) DEFAULT NULL':

SQLSTATE[01000]: Warning: 1265 Data truncated for column 'sku' at row 9410
Server API: apache2handler;
Request method: GET;
URI: /admin.php?target=addons_list_installed&__cache_key __=e7aa43343234933acc6b95e4c7a0daff&cpid=966aa2f8a 1e4b00166397a28bec422ad;
Backtrace:
#0 G:\Xcart\Apache24\htdocs\lib\Doctrine\DBAL\DBALExc eption.php(116): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDOException))
#1 G:\Xcart\Apache24\htdocs\lib\Doctrine\DBAL\Connect ion.php(833): Doctrine\DBAL\DBALException::driverExceptionDuring Query(Object(XLite\Core\PDOMySqlDriver), Object(Doctrine\DBAL\Driver\PDOException), 'ALTER TABLE xc_...', Array)
#2 G:\Xcart\Apache24\htdocs\var\run.e7aa43343234933ac c6b95e4c7a0daff\classes\XLite\Core\Connection.php( 72): Doctrine\DBAL\Connection->executeQuery('ALTER TABLE xc_...', Array, Array, NULL)
#3 G:\Xcart\Apache24\htdocs\var\run.e7aa43343234933ac c6b95e4c7a0daff\classes\XLite\Core\DatabaseAbstrac t.php(631): XLite\Core\Connection->executeQuery('ALTER TABLE xc_...')
#4 G:\Xcart\Apache24\htdocs\Includes\Decorator\Plugin \Doctrine\Plugin\UpdateSchema\Main.php(80): XLite\Core\DatabaseAbstract->executeQueries(Array)
#5 G:\Xcart\Apache24\htdocs\Includes\Decorator\Utils\ PluginManager.php(83): Includes\Decorator\Plugin\Doctrine\Plugin\UpdateSc hema\Main->executeHookHandler()
#6 G:\Xcart\Apache24\htdocs\Includes\Decorator\Utils\ CacheManager.php(955): Includes\Decorator\Utils\PluginManager::invokeHook ('step_fifth')
#7 [internal function]: Includes\Decorator\Utils\CacheManager::executeStep Handler5()
#8 G:\Xcart\Apache24\htdocs\Includes\Utils\Operator.p hp(234): call_user_func_array(Array, Array)
#9 G:\Xcart\Apache24\htdocs\Includes\Decorator\Utils\ CacheManager.php(808): Includes\Utils\Operator::executeWithCustomMaxExecT ime('600', Array)
#10 G:\Xcart\Apache24\htdocs\Includes\Decorator\Utils\ CacheManager.php(826): Includes\Decorator\Utils\CacheManager::runStep(5)
#11 G:\Xcart\Apache24\htdocs\Includes\Decorator\Utils\ CacheManager.php(1150): Includes\Decorator\Utils\CacheManager::runStepCond itionally(5)
#12 G:\Xcart\Apache24\htdocs\top.inc.PHP53.php(108): Includes\Decorator\Utils\CacheManager::rebuildCach e()
#13 G:\Xcart\Apache24\htdocs\top.inc.php(45): require_once('G:\\Xcart\\Apache...')
#14 G:\Xcart\Apache24\htdocs\admin.php(37): require_once('G:\\Xcart\\Apache...')
#15 {main}

[01-Apr-2015 19:36:29] Error (code: 2): Cannot modify header information - headers already sent by (output started at G:\Xcart\Apache24\htdocs\Includes\Utils\Operator.p hp:185) in file G:\Xcart\Apache24\htdocs\error_handler.php : 47
Server API: apache2handler;
Request method: GET;
URI: /admin.php?target=addons_list_installed&__cache_key __=e7aa43343234933acc6b95e4c7a0daff&cpid=966aa2f8a 1e4b00166397a28bec422ad;
Backtrace:
#0 Includes\ErrorHandler::logInfo() called at [G:\Xcart\Apache24\htdocs\Includes\ErrorHandler.php :353]
#1 Includes\ErrorHandler::handleCommonError()
#2 header() called at [G:\Xcart\Apache24\htdocs\error_handler.php:47]
#3 showErrorPage() called at [G:\Xcart\Apache24\htdocs\Includes\ErrorHandler.php :285]
#4 Includes\ErrorHandler::showErrorPage() called at [G:\Xcart\Apache24\htdocs\Includes\ErrorHandler.php :366]
#5 Includes\ErrorHandler::handleException() called at [G:\Xcart\Apache24\htdocs\admin.php:42]


The error happens at:
Quote:
Deploying store [step 5 of 12], please wait...
Run the "Doctrine_Plugin_UpdateSchema" plugin...

-Niboon
__________________
X-Cart 5.1.10
X-Cart Next 5.2.1 Beta
Reply With Quote