Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: Setup Pages
-
Labels:None
-
Environment:
client-st
Description
Copy account 'AvalonBay' or 'legalzoom' on staging, and the UI spins on 'Processing...' forever. This is seen in the debug:
Both of these accounts are on staging-db6, which has been upgraded to percona MySQL 5.1.
[13:06:02, 21 Sep 2010] (1) MYSQLDATABASE: Database::sql(): [insert into `st-tracker`.`searchEngineConversionTypeProductMap` (`searchEngineConversionTypeID`, `productID`, `accountID`) values ("2",null,757)]
[13:06:02, 21 Sep 2010] (1) MYSQLDATABASE: SQL Error: "Column 'productID' cannot be null"
[13:06:02, 21 Sep 2010] (1) MYSQLDATABASE: Exiting because [Column 'productID' cannot be null]
[13:06:02, 21 Sep 2010] (1) MYSQLDATABASE: Backtrace:
File: /usr/local/share/tsa/tsa-build-client-web-p53-r27223/client-web/libs/phpst/debug.class.php Line#579 Class: Debug Function: backtrace
File: /usr/local/share/tsa/tsa-build-client-web-p53-r27223/client-web/libs/phpst/basedatabase.class.php Line#433 Class: Debug Function: debug_die
File: /usr/local/share/tsa/tsa-build-client-web-p53-r27223/client-web/libs/phpst/basedatabase.class.php Line#479 Class: BaseDatabase Function: sql
File: /usr/local/share/tsa/tsa-build-client-web-p53-r27223/client-web/libs/phpst/basedatabasetable.inc.php Line#148 Class: BaseDatabase Function: insert
File: /usr/local/share/tsa/tsa-build-client-web-p53-r27223/client-web/libs/phpst/basedatabasetablerow.inc.php Line#391 Class: BaseDatabaseTable Function: insert
File: /usr/local/share/tsa/tsa-build-client-web-p53-r27223/client-web/src/formDefs/newaccountformdef.class.php Line#248 Class: BaseDatabaseTableRow Function: save
File: /usr/local/share/tsa/tsa-build-client-web-p53-r27223/client-web/src/formDefs/newaccountformdef.class.php Line#378 Class: NewAccountFormDef Function: copyProducts
File: /usr/local/share/tsa/tsa-build-client-web-p53-r27223/client-web/src/wizard/client/clientsetupwizard.class.php Line#631 Class: NewAccountFormDef Function: submitForm
File: /usr/local/share/tsa/tsa-build-client-web-p53-r27223/client-web/src/wizard/client/clientsetupwizard.class.php Line#451 Class: ClientSetupWizard Function: renderPage
File: /usr/local/share/tsa/tsa-build-client-web-p53-r27223/client-web/web/clientform.php Line#38 Class: ClientSetupWizard Function: processRequests
[13:06:02, 21 Sep 2010] (1) MYSQLDATABASE: PHP Error Message: Constant TSA_ERROR_MESSAGE_BOX_STYLE already defined
----------
Try copying an account not on staging-db6, and it works, like King.com. King.com is on an account db that still using MySQL 5.0.
