• Registered: 2009-10-29
  • Posts: 10

Topic: Upgrading to 0.3.0 from 0.2.0 problems

I am trying to upgrade my database from 0.2.0 to 0.3.0.

When i execute 

mysql test -uroot -p < ./db_update-0.3.0.sql

I get the following error message:

ERROR 1005 (HY000) at line 49: Can't create table 'test.#sql-536_54b' (errno: 150)

The rest of the steps are OK, but when logging in I get this error message:

Exception in PHP Script
/tracmor-0.3.0/assets/index.php     PHP Version: 5.2.10-2ubuntu6.4;  Zend Engine Version: 2.2.0;  Qcodo Version: 0.3.32 (Qcodo Beta 3)
Application: Apache/2.2.12 (Ubuntu);  Server Name: 10.1.3.31
HTTP User Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.1.9) Gecko/20100401 Ubuntu/9.10 (karmic) Firefox/3.5.9
Undefined GET property or variable in 'QAdvancedSearchComposite' class: chkArchived
Exception Type:   QUndefinedPropertyException

Source File:   /var/www/alameen-test/includes/qcodo/_core/qform/QControlBase.class.php     Line:   736

Line 731:            public function Render($blnDisplayOutput = true) {
Line 732:                // Call RenderHelper
Line 733:                $this->RenderHelper(func_get_args(), __FUNCTION__);
Line 734:                
Line 735:                try {
Line 736:                    $strOutput = $this->GetControlHtml();
Line 737:                } catch (QCallerException $objExc) {
Line 738:                    $objExc->IncrementOffset();
Line 739:                    throw $objExc;
Line 740:                }
Line 741:    


Call Stack:

#0 /var/www/alameen-test/includes/qcodo/_core/qform/QControlBase.class.php(933): QBaseClass->__get('chkArchived')
#1 /var/www/alameen-test/includes/qcodo/qform/QControl.class.php(252): QControlBase->__get('chkArchived')
#2 /var/www/alameen-test/includes/qcodo/qform/QAdvancedSearchComposite.class.php(374): QControl->__get('chkArchived')
#3 /var/www/tracmor-0.3.0/common/advanced_search_composite.tpl.php(56): QAdvancedSearchComposite->__get('chkArchived')
#4 /var/www/alameen-test/includes/qcodo/qform/QAdvancedSearchComposite.class.php(123): require('/var/www/tracmo...')
#5 /var/www/alameen-test/includes/qcodo/_core/qform/QControlBase.class.php(736): QAdvancedSearchComposite->GetControlHtml()
#6 /var/www/tracmor-0.3.0/assets/asset_search_composite.tpl.php(31): QControlBase->Render()
#7 /var/www/alameen-test/includes/qcodo/qform/QAssetSearchComposite.class.php(225): require('/var/www/tracmo...')
#8 /var/www/alameen-test/includes/qcodo/_core/qform/QControlBase.class.php(736): QAssetSearchComposite->GetControlHtml()
#9 /var/www/alameen-test/assets/asset_list.tpl.php(43): QControlBase->Render()
#10 /var/www/alameen-test/includes/qcodo/_core/qform/QFormBase.class.php(790): require('/var/www/alamee...')
#11 /var/www/alameen-test/includes/qcodo/_core/qform/QFormBase.class.php(297): QFormBase->Render()
#12 /var/www/tracmor-0.3.0/assets/asset_list.php(465): QFormBase::Run('AssetListForm', '/var/www/alamee...')
#13 /var/www/tracmor-0.3.0/assets/index.php(22): include('/var/www/tracmo...')
#14 {main}


Variable Dump:   Show/Hide

This is only happening for asset. Other things such as inventory / admin / reports seems to be working OK.

  • Registered: 2009-10-29
  • Posts: 10

Re: Upgrading to 0.3.0 from 0.2.0 problems

Please ignore the last error message. I forgot to change the __SUBDIRECTORY__ variable in the configuration.inc.php file after changing the directory for testing purposes. Everything seems to be working so far except the first error message.

  • Registered: 2010-05-12
  • Posts: 5

Re: Upgrading to 0.3.0 from 0.2.0 problems

I have that same error here.  Did you ever find a solution?  Has it caused any issues?

I dug a bit and found that it likely has something to do with a foreign key constraint and when I do a "show engine innodb status" I see this:

LATEST FOREIGN KEY ERROR
------------------------
100812 11:17:35 Error in foreign key constraint of table fsdinventory/#sql-d43_188b:
FOREIGN KEY (  `inventory_model_id` ) REFERENCES  `tracmor`.`inventory_model` (
`inventory_model_id`
) ON DELETE CASCADE ON UPDATE NO ACTION:
Cannot resolve table name close to:
(
`inventory_model_id`
) ON DELETE CASCADE ON UPDATE NO ACTION

Any help would be great.