I Have mySQL debian 10.2 and PHP 7.2.34
But get ERROR IN INSTALL TINE ON create -db ""504 Gateway Time-out""
[SE5] SocialEngine - 5.3.3 [Maintenance Release] ((₦ulled by Mis✞er₩izard))
Started by Les, Nov 27 2020 12:58 PM
35 replies to this topic
#31
vladben
-
- Members
-
Level 4
-
Level
-
56 points
-
106 posts
- Gender:Male
- Location:Toronto
- Software:SE 5.x
Posted 27 December 2020 - 05:08 PM
#32
Les
-
- Moderators
-
Blue Team Lima 1
-
Level
-
5,156 points
-
3,447 posts
- Gender:Male
- Location:Westland, Michigan U.S.A.
- Software:SE 5.x
Posted 28 December 2020 - 05:54 AM
after save change in General Settings I get Error
We're sorry!
We are currently experiencing some technical issues. Please try again or report this to your site administrator using the contact form.
Administrator: Please check the error log in your admin panel for more information regarding this error.
Error Code: e65c99
2020-12-24T18:40:49+00:00 CRIT (2):
Error Code: cdaa32
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Column 'value' cannot be null in /var/www/emk0lbaskic/data/www/emkolbaski.com/application/libraries/Zend/Db/Statement/Mysqli.php:214
Stack trace:
#0 /var/www/emk0lbaskic/data/www/emkolbaski.com/application/libraries/Zend/Db/Statement.php(303): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /var/www/emk0lbaskic/data/www/emkolbaski.com/application/libraries/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#2 /var/www/emk0lbaskic/data/www/emkolbaski.com/application/libraries/Zend/Db/Adapter/Abstract.php(576): Zend_Db_Adapter_Abstract->query('INSERT INTO `en...', Array)
#3 /var/www/emk0lbaskic/data/www/emkolbaski.com/application/libraries/Zend/Db/Table/Abstract.php(1076): Zend_Db_Adapter_Abstract->insert('engine4_core_se...', Array)
#4 /var/www/emk0lbaskic/data/www/emkolbaski.com/application/libraries/Engine/Db/Table.php(146): Zend_Db_Table_Abstract->insert(Array)
#5 /var/www/emk0lbaskic/data/www/emkolbaski.com/application/modules/Core/Model/DbTable/Settings.php(155): Engine_Db_Table->insert(Array)
#6 /var/www/emk0lbaskic/data/www/emkolbaski.com/application/modules/Core/Model/DbTable/Settings.php(109): Core_Model_DbTable_Settings->setSetting('core.general.si...', NULL)
#7 /var/www/emk0lbaskic/data/www/emkolbaski.com/application/modules/Core/Api/Settings.php(35): Core_Model_DbTable_Settings->setSetting('core.general', Array)
#8 /var/www/emk0lbaskic/data/www/emkolbaski.com/application/modules/Core/controllers/AdminSettingsController.php(67): Core_Api_Settings->__set('core_general', Array)
#9 /var/www/emk0lbaskic/data/www/emkolbaski.com/application/libraries/Zend/Controller/Action.php(516): Core_AdminSettingsController->generalAction()
#10 /var/www/emk0lbaskic/data/www/emkolbaski.com/application/libraries/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('generalAction')
#11 /var/www/emk0lbaskic/data/www/emkolbaski.com/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#12 /var/www/emk0lbaskic/data/www/emkolbaski.com/application/modules/Core/Bootstrap.php(86): Zend_Controller_Front->dispatch()
#13 /var/www/emk0lbaskic/data/www/emkolbaski.com/application/libraries/Engine/Application.php(160): Core_Bootstrap->run()
#14 /var/www/emk0lbaskic/data/www/emkolbaski.com/application/index.php(223): Engine_Application->run()
#15 /var/www/emk0lbaskic/data/www/emkolbaski.com/boot.php(47): include('/var/www/emk0lb...')
#16 /var/www/emk0lbaskic/data/www/emkolbaski.com/index.php(24): Engine_Boot->boot()
#17 {main}
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Column 'value' cannot be null in /var/www/emk0lbaskic/data/www/emkolbaski.com/application/libraries/Zend/Db/Statement/Mysqli.php:214
Check your database for this error. Apparently you have the column 'value' set to null.
Please don't forget to "LIKE" if you like this post or if it is helpful to you. This is a way to show gratitude for the help that you received. After all, the "LIKE" costs you nothing. Don't you agree? Also, any and all modules, plug-ins, themes, widgets, or DB entries that are shared or posted by me are for educational purposes. Please visit the developers websites and purchase legitimately, if you like them. Thanks, Les
#33
vladben
-
- Members
-
Level 4
-
Level
-
56 points
-
106 posts
- Gender:Male
- Location:Toronto
- Software:SE 5.x
Posted 28 December 2020 - 05:10 PM
~/www/emkolbaski.com/application/libraries/Zend/Db/Statement/Mysqli/Unprepared.php=======NO HERE Mysqli.php:214
2 FILES ONLY IN FOLDER /www/emkolbaski.com/application/libraries/Zend/Db/Statement/Mysqli/
Unprepared.php AND Exception.php
<?php
/**
* ENGINE
*
* @category Zend
* @package Zend_Db
* @subpackage Statement
*/
/**
* @see Zend_Db_Statement_Mysqli
*/
// // require_once 'Zend/Db/Statement/Mysqli.php';
/**
* Extends for Mysqli (unprepared)
*
* @category Zend
* @package Zend_Db
* @subpackage Statement
*/
class Zend_Db_Statement_Mysqli_Unprepared extends Zend_Db_Statement_Mysqli
{
/**
* The unprepared sql string.
*
* @var string
*/
protected $_sql_unprepared;
/**
* @param string $sql
* @return void
*/
public function _prepare($sql)
{
// @todo this will not cause an error here since its not being prepared
$this->_sql_unprepared = $sql;
$this->_stmt = null;
/*
$mysqli = $this->_adapter->getConnection();
$this->_stmt = $mysqli->prepare($sql);
if ($this->_stmt === false || $mysqli->errno) {
// // require_once 'Zend/Db/Statement/Mysqli/Exception.php';
throw new Zend_Db_Statement_Mysqli_Exception("Mysqli prepare error: " . $mysqli->error);
}
*/
}
/**
* Closes the cursor and the statement.
*
* @return bool
*/
public function close()
{
if( $this->_meta )
{
$r = $this->_meta->close();
$this->_meta = null;
return $r;
}
return false;
}
/**
* Closes the cursor, allowing the statement to be executed again.
*
* @return bool
*/
public function closeCursor()
{
if( $this->_meta )
{
$r = $this->_meta->close();
$this->_meta = null;
return $r;
}
return false;
}
/**
* Returns the number of columns in the result set.
* Returns null if the statement has no result set metadata.
*
* @return int The number of columns.
*/
public function columnCount()
{
if (isset($this->_meta) && $this->_meta) {
return $this->_meta->field_count;
}
return 0;
}
/**
* Retrieves the error code, if any, associated with the last operation on
* the statement handle.
*
* @return string error code.
*/
public function errorCode()
{
// Does not affect unprepared statements
return false;
}
/**
* Retrieves an array of error information, if any, associated with the
* last operation on the statement handle.
*
* @return array
*/
public function errorInfo()
{
if (!$this->_meta) {
return false;
}
$mysqli = $this->_adapter->getConnection();
return array(
null,
$mysqli->errno,
$mysqli->error,
);
}
/**
* Executes a prepared statement.
*
* @param array $params OPTIONAL Values to bind to parameter placeholders.
* @return bool
* @throws Zend_Db_Statement_Mysqli_Exception
*/
public function _execute(array $params = null)
{
$mysqli = $this->_adapter->getConnection();
$sql = $this->_sql_unprepared;
// if no params were given as an argument to execute(),
// then default to the _bindParam array
if ($params === null) {
$params = $this->_bindParam;
}
// send $params as input parameters to the statement
if ($params) {
// @todo force typing using param junk?
//array_unshift($params, str_repeat('s', count($params)));
//array_unshift($params);
//var_dump($params);
$sql = $this->_adapter->quoteInto($sql, $params);
}
// execute the statement
$retval = $mysqli->real_query($sql);
if ($retval === false) {
/**
* @see Zend_Db_Statement_Mysqli_Exception
*/
// // require_once 'Zend/Db/Statement/Mysqli/Exception.php';
throw new Zend_Db_Statement_Mysqli_Exception("Mysqli statement (unprepared) execute error : " . $mysqli->error);
}
// store metadata (note this also contains the result set for unprepared statements unfortunately)
$this->_meta = $mysqli->store_result();
// statements that have no result set do not return metadata
if ($this->_meta !== false) {
// get the column names that will result
// @todo make sure we don't need this
$this->_keys = array();
foreach ($this->_meta->fetch_fields() as $col) {
$this->_keys[] = $this->_adapter->foldCase($col->name);
}
// set up a binding space for result variables
$this->_values = array_fill(0, count($this->_keys), null);
}
return $retval;
}
/**
* Fetches a row from the result set.
*
* @param int $style OPTIONAL Fetch mode for this fetch operation.
* @param int $cursor OPTIONAL Absolute, relative, or other.
* @param int $offset OPTIONAL Number for absolute or relative cursors.
* @return mixed Array, object, or scalar depending on fetch mode.
* @throws Zend_Db_Statement_Mysqli_Exception
*/
public function fetch($style = null, $cursor = null, $offset = null)
{
if( !$this->_meta ) {
return false;
}
// make sure we have a fetch mode
if ($style === null) {
$style = $this->_fetchMode;
}
// Get the next result
$row = false;
switch ($style) {
case Zend_Db::FETCH_NUM:
$row = $this->_meta->fetch_row();
break;
case Zend_Db::FETCH_ASSOC:
$row = $this->_meta->fetch_assoc();
break;
case Zend_Db::FETCH_BOTH:
$row = $this->_meta->fetch_array();
break;
case Zend_Db::FETCH_OBJ:
$row = $this->_meta->fetch_object();
break;
case Zend_Db::FETCH_BOUND:
// Basically the same as fetch_both for now
$row = $this->_meta->fetch_array();
break;
default:
/**
* @see Zend_Db_Statement_Mysqli_Exception
*/
// // require_once 'Zend/Db/Statement/Mysqli/Exception.php';
throw new Zend_Db_Statement_Mysqli_Exception("Invalid fetch mode '$style' specified");
break;
}
// End of data (or error)
if( !$row ) {
return $row;
}
// Special case for FETCH_BOUND
if( $style==Zend_Db::FETCH_BOUND ) {
return $this->_fetchBound($row);
}
return $row;
}
}
?>
#34
Les
-
- Moderators
-
Blue Team Lima 1
-
Level
-
5,156 points
-
3,447 posts
- Gender:Male
- Location:Westland, Michigan U.S.A.
- Software:SE 5.x
Posted 28 December 2020 - 06:16 PM
This is just the script to connect to database. There is a column in your database called 'value'. The script error is saying it is set to 'null' and it needs to be set to un-null or unticked, if that's the case.
[214] throw new Zend_Db_Statement_Mysqli_Exception("Mysqli statement execute error : " . $this->_stmt->error, $this->_stmt->errno);
~This line above [214] is what prompts the error message you are getting. It told you what the problem was at the beginning... column named value in database is set to 'null'... unset it.
Edited by Les, 28 December 2020 - 06:31 PM.
Please don't forget to "LIKE" if you like this post or if it is helpful to you. This is a way to show gratitude for the help that you received. After all, the "LIKE" costs you nothing. Don't you agree? Also, any and all modules, plug-ins, themes, widgets, or DB entries that are shared or posted by me are for educational purposes. Please visit the developers websites and purchase legitimately, if you like them. Thanks, Les
#35
vladben
-
- Members
-
Level 4
-
Level
-
56 points
-
106 posts
- Gender:Male
- Location:Toronto
- Software:SE 5.x
Posted 29 December 2020 - 01:58 PM
This is just the script to connect to database. There is a column in your database called 'value'. The script error is saying it is set to 'null' and it needs to be set to un-null or unticked, if that's the case.
[214] throw new Zend_Db_Statement_Mysqli_Exception("Mysqli statement execute error : " . $this->_stmt->error, $this->_stmt->errno);~This line above [214] is what prompts the error message you are getting. It told you what the problem was at the beginning... column named value in database is set to 'null'... unset it.
Th..you for help But you don't understand me. I get ""504 Gateway Time-out"" in install time SE-5.3.3 . AFTER DB INFORMATION. ITS 4 STEP ON INSTALLATION TIME
Edited by vladben, 29 December 2020 - 02:00 PM.
#36
Alemantico
-
- Members
-
Level 1
-
Level
-
3 points
-
18 posts
Posted 08 January 2021 - 04:28 PM
The installation of the upgrade package is throwing an error, sayin: "Query failed with error: Mysqli statement execute error : Duplicate column name 'main_package_id'" (screenshot: https://ibb.co/9wkGWxv) It that mean, that I have to rename that column manually like ; 'main_package_id1' ?
Thank you in advance!
Edited by Alemantico, 08 January 2021 - 04:30 PM.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users