Tracmor Forum - Upgrading to 0.3.0 from 0.2.0 problems

Re: Upgrading to 0.3.0 from 0.2.0 problems

2010-10-14T17:14:33Z

I modified the update script but I have the same error message.

ERROR 1025 (HY000) at line 49: Error on rename of './tracmor/inventory_location' to './tracmor/#sql2-2ef-ed' (errno: 152)

Re: Upgrading to 0.3.0 from 0.2.0 problems

2010-10-14T16:59:55Z

Try modifying the db_update-0.3.0.sql file as shown below. As we always recommend, make sure you have a backup of your database before attempting the upgrade.

Add at top:

SET foreign_key_checks = 0;

Add at bottom:

SET foreign_key_checks = 1;

Let us know if that fixes it for you.

Re: Upgrading to 0.3.0 from 0.2.0 problems

2010-10-14T16:32:13Z

I have the same error message on my server as well

ERROR 1025 (HY000) at line 48: Error on rename of './tracmor/inventory_location' to './tracmor/#sql2-2ef-ab' (errno: 152)

Is there a solution?

Re: Upgrading to 0.3.0 from 0.2.0 problems

2010-08-12T16:42:12Z

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.

Re: Upgrading to 0.3.0 from 0.2.0 problems

2010-07-19T09:31:32Z

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.

Upgrading to 0.3.0 from 0.2.0 problems

2010-07-19T09:19:33Z

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.