phpdevshell team mailing list archive

[Ryan Perreault <question220604@xxxxxxxxxxxxxxxxxxxxx>]

Question #220604 on PHPDevShell changed:
https://answers.launchpad.net/phpdevshell/+question/220604

Ryan Perreault gave more information on the question:
This is the error that I get after manually installing the database with
the fix documented in the other bug/topic.

>From localhost/phpdev/

This page will try to provide as much information as possible so you can track down (and hopefully fix) the problem.
The error

The message of the error is as follow:

    Incorrect integer value: '' for column 'log_id' at row 1

    The MySQL database engine returned with an error (code 1366 -
Incorrect integer value: '' for column 'log_id' at row 1

    The faulty query REAL SQL was:

    		INSERT INTO
    			_db_core_menu_access_logs (log_id, menu_id, user_id, timestamp)
    		VALUES
    			('', '2266433229', '0', '1359579949')
    		


    The faulty query source sql is:

    		INSERT INTO
    			_db_core_menu_access_logs (log_id, menu_id, user_id, timestamp)
    		VALUES
    			('', '%s', '%u', '%s')
    		


    The parameters were:

        [ 0 ] => 2266433229
        [ 1 ] => 0
        [ 2 ] => 1359579949

The error occurred in file
C:\Dev\wamp\www\phpdev\includes\PHPDS_legacyConnector.class.php at line
107

    101               if (!empty($real_sql)) {
    102                   // Count Queries Used...
    103                   $this->db->countQueries ++;
    104                   $this->_log($real_sql);
    105                   $this->result = mysql_query($real_sql, $this->link);// or $template->stopScript = $this->returnSqlError($real_sql);
    106                   if (!$this->result) {
    107                       throw new PHPDS_databaseException(mysql_error($this->link), mysql_errno($this->link));
    108                   }
    109                   return $this->result;
    110               } else {
    111                   return false;
    112               }
    113               // TODO: check result validity for non-select requests
    114           } catch (Exception $e) {

-- 
You received this question notification because you are a member of
PHPDevShell, which is an answer contact for PHPDevShell.