• Registered: 2010-01-31
  • Posts: 3

Topic: Error after installation, database table doesn't exist?

HP Version: 5.2.10;  Zend Engine Version: 2.2.0;  Qcodo Version: 0.3.32 (Qcodo Beta 3)
Application: Apache;  Server Name: manhattane-com.coolpage.biz
HTTP User Agent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US) AppleWebKit/532.0 (KHTML, like Gecko) Chrome/3.0.195.38 Safari/532.0

Hi,

When I try to login after installation I get a MySql error saying that a certain table admin_settings doesnt exist. Do I have to enter it manually or is their some problems for tracmor to create it?

Here is the error msg:

MySqli Error: Table '224389.admin_setting' doesn't exist
Exception Type:   QMySqliDatabaseException   

Rendered Page:   Click here to view contents able to be rendered

Source File:   /home/vhosts/manhattane-com.coolpage.biz/tracmor/includes/data_classes/generated/AdminSettingGen.class.php         Line:   380   

Line 375:             * @return AdminSetting
Line 376:            */
Line 377:            public static function LoadByShortDescription($strShortDescription) {
Line 378:                return AdminSetting::QuerySingle(
Line 379:                    QQ::Equal(QQN::AdminSetting()->ShortDescription, $strShortDescription)
Line 380:                );
Line 381:            }
Line 382:   
Line 383:   
Line 384:   
Line 385:            ////////////////////////////////////////////////////

Database Error Number:  1146

Query:   Show/Hide


Call Stack:

#0 /home/vhosts/manhattane-com.coolpage.biz/tracmor/includes/data_classes/generated/AdminSettingGen.class.php(148): QMySqli5Database->Query('SELECT???`admin...')
#1 /home/vhosts/manhattane-com.coolpage.biz/tracmor/includes/data_classes/generated/AdminSettingGen.class.php(380): AdminSettingGen::QuerySingle(Object(QQConditionEqual))
#2 /home/vhosts/manhattane-com.coolpage.biz/tracmor/includes/data_classes/TracmorSettings.class.php(45): AdminSettingGen::LoadByShortDescription('company_logo')
#3 /home/vhosts/manhattane-com.coolpage.biz/tracmor/login.php(61): TracmorSettings->__get('CompanyLogo')
#4 /home/vhosts/manhattane-com.coolpage.biz/tracmor/login.php(35): LoginForm->lblLogo_Create()
#5 /home/vhosts/manhattane-com.coolpage.biz/tracmor/includes/qcodo/_core/qform/QFormBase.class.php(275): LoginForm->Form_Create()
#6 /home/vhosts/manhattane-com.coolpage.biz/tracmor/login.php(128): QFormBase::Run('LoginForm', '/home/vhosts/ma...')
#7 {main}

Variable Dump:   Show/Hide


thanx for your help!

brgds
Ayaz

  • Registered: 2010-01-31
  • Posts: 3

Re: Error after installation, database table doesn't exist?

Hi,

I solved it by running the sql-command for admin_setting manually.

Now instead I get another error:

Trying to get property of non-object
Error Type:   E_NOTICE   

Rendered Page:   Click here to view contents able to be rendered

Source File:   /home/vhosts/manhattane-com.coolpage.biz/tracmor/includes/data_classes/TracmorSettings.class.php         Line:   46   

Line 41:                    ///////////////////
Line 42:   
Line 43:                    default:
Line 44:                        try {
Line 45:                            $objAdminSetting = AdminSetting::LoadByShortDescription(QConvertNotation::UnderscoreFromCamelCase($strName));
Line 46:                            return $objAdminSetting->Value;
Line 47:                        } catch (QCallerException $objExc) {
Line 48:                            $objExc->IncrementOffset();
Line 49:                            throw $objExc;
Line 50:                        }
Line 51:                }

Call Stack:

#0 /home/vhosts/manhattane-com.coolpage.biz/tracmor/includes/data_classes/TracmorSettings.class.php(46): QcodoHandleError()
#1 /home/vhosts/manhattane-com.coolpage.biz/tracmor/login.php(61): TracmorSettings->__get()
#2 /home/vhosts/manhattane-com.coolpage.biz/tracmor/login.php(35): LoginForm->lblLogo_Create()
#3 /home/vhosts/manhattane-com.coolpage.biz/tracmor/includes/qcodo/_core/qform/QFormBase.class.php(275): LoginForm->Form_Create()
#4 /home/vhosts/manhattane-com.coolpage.biz/tracmor/login.php(128): QFormBase::Run()

Variable Dump:   Show/Hide

  HTTP_COOKIE_VARS
  HTTP_ENV_VARS
  HTTP_GET_VARS
  HTTP_POST_FILES
  HTTP_POST_VARS
  HTTP_SERVER_VARS
  HTTP_SESSION_VARS
  _COOKIE
  _ENV
  _FILES
  _GET
  _POST
  _REQUEST
  _SERVER

  • Registered: 2010-01-31
  • Posts: 3

Re: Error after installation, database table doesn't exist?

I have obiously not followed the instructions...

After running the sql commands it works and I come to the login page but with a warning about magic_qoutes_gpc...

I have tried to disable magic qoutes but it seems to be problematic. Will try to find a solution.

  • zotek
  • New member
  • Offline
  • Registered: 2011-02-17
  • Posts: 9

Re: Error after installation, database table doesn't exist?

ashukat wrote:

HP Version: 5.2.10;  Zend Engine Version: 2.2.0;  Qcodo Version: 0.3.32 (Qcodo Beta 3)
Application: Apache;  Server Name: manhattane-com.coolpage.biz
HTTP User Agent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US) AppleWebKit/532.0 (KHTML, like Gecko) Chrome/3.0.195.38 Safari/532.0

Hi,

When I try to login after installation I get a MySql error saying that a certain table admin_settings doesnt exist. Do I have to enter it manually or is their some problems for tracmor to create it?

Here is the error msg:

MySqli Error: Table '224389.admin_setting' doesn't exist
Exception Type:   QMySqliDatabaseException   

Rendered Page:   Click here to view contents able to be rendered

Source File:   /home/vhosts/manhattane-com.coolpage.biz/tracmor/includes/data_classes/generated/AdminSettingGen.class.php         Line:   380   

Line 375:             * @return AdminSetting
Line 376:            */
Line 377:            public static function LoadByShortDescription($strShortDescription) {
Line 378:                return AdminSetting::QuerySingle(
Line 379:                    QQ::Equal(QQN::AdminSetting()->ShortDescription, $strShortDescription)
Line 380:                );
Line 381:            }
Line 382:   
Line 383:   
Line 384:   
Line 385:            ////////////////////////////////////////////////////

Database Error Number:  1146

Query:   Show/Hide


Call Stack:

#0 /home/vhosts/manhattane-com.coolpage.biz/tracmor/includes/data_classes/generated/AdminSettingGen.class.php(148): QMySqli5Database->Query('SELECT???`admin...')
#1 /home/vhosts/manhattane-com.coolpage.biz/tracmor/includes/data_classes/generated/AdminSettingGen.class.php(380): AdminSettingGen::QuerySingle(Object(QQConditionEqual))
#2 /home/vhosts/manhattane-com.coolpage.biz/tracmor/includes/data_classes/TracmorSettings.class.php(45): AdminSettingGen::LoadByShortDescription('company_logo')
#3 /home/vhosts/manhattane-com.coolpage.biz/tracmor/login.php(61): TracmorSettings->__get('CompanyLogo')
#4 /home/vhosts/manhattane-com.coolpage.biz/tracmor/login.php(35): LoginForm->lblLogo_Create()
#5 /home/vhosts/manhattane-com.coolpage.biz/tracmor/includes/qcodo/_core/qform/QFormBase.class.php(275): LoginForm->Form_Create()
#6 /home/vhosts/manhattane-com.coolpage.biz/tracmor/login.php(128): QFormBase::Run('LoginForm', '/home/vhosts/ma...')
#7 {main}

Variable Dump:   Show/Hide


thanx for your help!

brgds
Ayaz


HI i get this error two..how do you run sql-command manualy??

thank you