06-17-2020, 08:37 AM
Dear Joe,
Many thanks.
Yes, your sql code line did produce an error in our database - the default format for 'timestamp' was wrong in the dbase (#1067 - Invalid default value for 'date_modified'). After we changed this, no more issues with the login.
However, after the login, we can't get any data from the database in coreBOS in any of the modules.
i.e. if we try opening Organizations:
Notice: Trying to get property 'EOF' of non-object in C:\xampp\htdocs\corebos-master\include\database\PearDatabase.php on line 646
Fatal error: Uncaught Error: Call to a member function FetchRow() on bool in C:\xampp\htdocs\corebos-master\include\database\PearDatabase.php:650 Stack trace: #0 C:\xampp\htdocs\corebos-master\modules\BusinessActions\BusinessActions.php(257): PearDatabase->fetch_array(false) #1 C:\xampp\htdocs\corebos-master\include\ListView\ListViewController.php(669): BusinessActions::getAllByType(6, Array, Array, '8', '5') #2 C:\xampp\htdocs\corebos-master\modules\Vtiger\ListView.php(236): ListViewController->getListViewEntries(Object(Accounts), 'Accounts', Object(ADORecordSet_mysqli), Array, false) #3 C:\xampp\htdocs\corebos-master\modules\Accounts\ListView.php(10): include_once('C:\\xampp\\htdocs...') #4 C:\xampp\htdocs\corebos-master\modules\Accounts\index.php(13): include_once('C:\\xampp\\htdocs...') #5 C:\xampp\htdocs\corebos-master\index.php(492): include_once('C:\\xampp\\htdocs...') #6 {main} thrown in C:\xampp\htdocs\corebos-master\include\database\PearDatabase.php on line 650
or Sales Orders:
Notice: Undefined index: currency_position in C:\xampp\htdocs\corebos-master\include\utils\CommonUtils.php on line 311
Notice: Trying to get property 'EOF' of non-object in C:\xampp\htdocs\corebos-master\include\database\PearDatabase.php on line 646
Fatal error: Uncaught Error: Call to a member function FetchRow() on bool in C:\xampp\htdocs\corebos-master\include\database\PearDatabase.php:650 Stack trace: #0 C:\xampp\htdocs\corebos-master\modules\BusinessActions\BusinessActions.php(257): PearDatabase->fetch_array(false) #1 C:\xampp\htdocs\corebos-master\include\ListView\ListViewController.php(669): BusinessActions::getAllByType(22, Array, Array, '8', '118') #2 C:\xampp\htdocs\corebos-master\modules\Vtiger\ListView.php(236): ListViewController->getListViewEntries(Object(SalesOrder), 'SalesOrder', Object(ADORecordSet_mysqli), Array, false) #3 C:\xampp\htdocs\corebos-master\modules\SalesOrder\ListView.php(10): include_once('C:\\xampp\\htdocs...') #4 C:\xampp\htdocs\corebos-master\modules\SalesOrder\index.php(13): include_once('C:\\xampp\\htdocs...') #5 C:\xampp\htdocs\corebos-master\index.php(492): include_once('C:\\xampp\\htdocs...') #6 {main} thrown in C:\xampp\htdocs\corebos-master\include\database\PearDatabase.php on line 650
or My Preferences:
Notice: Undefined variable: block_label in C:\xampp\htdocs\corebos-master\include\utils\CommonUtils.php on line 1311
Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\corebos-master\include\utils\DetailViewUtils.php on line 1739.
Could you help us with that as well?
Many thanks.
Yes, your sql code line did produce an error in our database - the default format for 'timestamp' was wrong in the dbase (#1067 - Invalid default value for 'date_modified'). After we changed this, no more issues with the login.
However, after the login, we can't get any data from the database in coreBOS in any of the modules.
i.e. if we try opening Organizations:
Notice: Trying to get property 'EOF' of non-object in C:\xampp\htdocs\corebos-master\include\database\PearDatabase.php on line 646
Fatal error: Uncaught Error: Call to a member function FetchRow() on bool in C:\xampp\htdocs\corebos-master\include\database\PearDatabase.php:650 Stack trace: #0 C:\xampp\htdocs\corebos-master\modules\BusinessActions\BusinessActions.php(257): PearDatabase->fetch_array(false) #1 C:\xampp\htdocs\corebos-master\include\ListView\ListViewController.php(669): BusinessActions::getAllByType(6, Array, Array, '8', '5') #2 C:\xampp\htdocs\corebos-master\modules\Vtiger\ListView.php(236): ListViewController->getListViewEntries(Object(Accounts), 'Accounts', Object(ADORecordSet_mysqli), Array, false) #3 C:\xampp\htdocs\corebos-master\modules\Accounts\ListView.php(10): include_once('C:\\xampp\\htdocs...') #4 C:\xampp\htdocs\corebos-master\modules\Accounts\index.php(13): include_once('C:\\xampp\\htdocs...') #5 C:\xampp\htdocs\corebos-master\index.php(492): include_once('C:\\xampp\\htdocs...') #6 {main} thrown in C:\xampp\htdocs\corebos-master\include\database\PearDatabase.php on line 650
or Sales Orders:
Notice: Undefined index: currency_position in C:\xampp\htdocs\corebos-master\include\utils\CommonUtils.php on line 311
Notice: Trying to get property 'EOF' of non-object in C:\xampp\htdocs\corebos-master\include\database\PearDatabase.php on line 646
Fatal error: Uncaught Error: Call to a member function FetchRow() on bool in C:\xampp\htdocs\corebos-master\include\database\PearDatabase.php:650 Stack trace: #0 C:\xampp\htdocs\corebos-master\modules\BusinessActions\BusinessActions.php(257): PearDatabase->fetch_array(false) #1 C:\xampp\htdocs\corebos-master\include\ListView\ListViewController.php(669): BusinessActions::getAllByType(22, Array, Array, '8', '118') #2 C:\xampp\htdocs\corebos-master\modules\Vtiger\ListView.php(236): ListViewController->getListViewEntries(Object(SalesOrder), 'SalesOrder', Object(ADORecordSet_mysqli), Array, false) #3 C:\xampp\htdocs\corebos-master\modules\SalesOrder\ListView.php(10): include_once('C:\\xampp\\htdocs...') #4 C:\xampp\htdocs\corebos-master\modules\SalesOrder\index.php(13): include_once('C:\\xampp\\htdocs...') #5 C:\xampp\htdocs\corebos-master\index.php(492): include_once('C:\\xampp\\htdocs...') #6 {main} thrown in C:\xampp\htdocs\corebos-master\include\database\PearDatabase.php on line 650
or My Preferences:
Notice: Undefined variable: block_label in C:\xampp\htdocs\corebos-master\include\utils\CommonUtils.php on line 1311
Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\corebos-master\include\utils\DetailViewUtils.php on line 1739.
Could you help us with that as well?