Right-click for options

Right-click for options

Right-click for options

Right-click for options

Right-click for options

BuilderEngine Web Engine - Open Source CMS Platform

Right-click options

Right-click for options

Right-click for options

Right-click for options

Right-click options

Right-click for options

Right-click for options

Right-click options

Right-click for options

Right-click for options

Right-click for options

database error - cannot access admin screen

Right-click on block content for options

Right-click for options

Right-click for options

  • Member
    Stef Be Author (edited) 4 months ago

    I managed to install BuilderEngine, but when I hit "return to admin page" it hit me back with this error: 

    A Database Error Occurred

    Error Number: 1054

    Unknown column 'user_id' in 'where clause'

    SELECT * FROM `be_alerts` WHERE `user_id` = 13 AND `be_alerts`.`text` = 'Website Update is available.'

    Filename: libraries/Datamapper.php

    Line Number: 1346

     

    I have no idea what to do with this. I searched through files, but I'm not a php developer and couldn't find anything useful, and phpmyadmin doesn't give me any privileges, if that's the case. I can do anything else though, as far as i know. From my google searches, I understand that a "user_id" column is missing? only "id" is present when viewing be_alerts. 

     

    /public_html/builderengine/libraries/Datamapper.php lines 1317 to 1351 [1346 in BOLD] :  

            if ($this->_validated && empty($this->parent))
            {
                // Reset validated
                $this->_validated = FALSE;

                // Use this objects properties
                $data = $this->_to_array(TRUE);

                if ( ! empty($data))
                {
                    // Clear this object to make way for new data
                    $this->clear();

                    // Set up default order by (if available)
                    $this->_handle_default_order_by();

                    // Get by objects properties
                    $query = $this->db->get_where($this->table, $data, $limit, $offset);
                } // FIXME: notify user if nothing was set?
            }
            else
            {
                // Clear this object to make way for new data
                $this->clear();

                // Set up default order by (if available)
                $this->_handle_default_order_by();

                // Get by built up query  // LINE 1346 BELOW
                $query = $this->db->get($this->table, $limit, $offset);
            }

            // Convert the query result into DataMapper objects
            if($query)
            {
                $this->_process_query($query);
            }

            // For method chaining
            return $this;
        }

     

     

    other reparations made to get this far:   https://builderengine.org/forum/topic/Install%20Issues/category/18#vadimkr-vadim-5c15c878dff4b/1545460209/64 [screenshot included]

     

    Using Hostinger   with php 5.6

     

  • Member
    Stef Be Author 4 months ago

  • Member
    Stef Be Author 3 months ago

    anyone?

Posting to the forum is only allowed for members with active accounts. Please sign in or sign up to post.

Right-click on block content for options