Jump to content

Photo

[SE5] SocialEngine - 5.3.3 [Maintenance Release] ((₦ulled by Mis✞er₩izard))


  • Please log in to reply
35 replies to this topic

#31 vladben

vladben

    Level 4

  • Members
  • Level
  • 56 points
  • 105 posts
    • Gender:Male
    • Location:Toronto
    • Software:Older SE

Posted 27 December 2020 - 05:08 PM

I Have  mySQL debian 10.2 and PHP 7.2.34

But get ERROR IN INSTALL TINE ON create -db   ""504 Gateway Time-out""



#32 Les

Les

    Blue Team Lima 1

  • Moderators
  • Level
  • 5,138 points
  • 3,438 posts
    • Gender:Male
    • Location:Westland, Michigan U.S.A.
    • Software:SE 4.8.x


Users Awards

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.


:emo: Please don't forget to  27-AwardsImgIcon.png "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

socialengine-experts.png

 

 


#33 vladben

vladben

    Level 4

  • Members
  • Level
  • 56 points
  • 105 posts
    • Gender:Male
    • Location:Toronto
    • Software:Older SE

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

Les

    Blue Team Lima 1

  • Moderators
  • Level
  • 5,138 points
  • 3,438 posts
    • Gender:Male
    • Location:Westland, Michigan U.S.A.
    • Software:SE 4.8.x


Users Awards

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.

:emo: Please don't forget to  27-AwardsImgIcon.png "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

socialengine-experts.png

 

 


#35 vladben

vladben

    Level 4

  • Members
  • Level
  • 56 points
  • 105 posts
    • Gender:Male
    • Location:Toronto
    • Software:Older SE

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

Alemantico

    Level 1

  • Members
  • 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


All the resources listed here are just for testing purpose and they shouldn't be used at any commercial environment without a valid license.
Those are for users who wants to try them before buy. Help the developer to build it better by purchasing them from original authors.