V3.2.0 and V3.1.2 Installation Failure

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) {

From the top of my head, I'd say your MySQL server is a little more strict than what we expect. Can you give us more details about your configuration? (system and mysql versions)

Open the folder /other/service and look for a file ending with "-complete.sql" (mine is PHPDevShell-db-3140, yours should be the same).
Find the value "2266433229"; the second occurence should be at line 148 like this:

INSERT INTO `pds_core_menu_structure` VALUES (NULL, '2266433229', '0', '2');

Does it match yours?

In doubt you have the latest version here:
http://bazaar.launchpad.net/~phpdevshell/phpdevshell/3.2.1/view/head:/other/service/PHPDevShell-db3140-complete.sql

I also run MySQL 5.5 but I would love if you could help us solve this for the fix to be released in PHPDevShell V4.0.0

Is it the fix you tried?
https://bugs.launchpad.net/phpdevshell/+bug/1020860

Hi Greg,

I updated my copy of the _complete.sql file based on that exact link you posted. The installation now works.

However - When I try to land on the main index page, I still get that error described in the first comment. It looks like its referencing a table (_db_core_menu_access_logs) that was never created during the install on my end.

I'm running MySQL 5.5
Windows 7 x64
i7-2630QM 2.0 GHz
8 GB RAM

Mmm this iseems to be a Windows problem then, we test the installation mostly on Linux. What version of PHP are you running?

5.3.13

It is strange that it missed that table, try running this manually and trying again:

CREATE TABLE `pds_core_menu_access_logs` (
 `log_id` int(20) NOT NULL AUTO_INCREMENT,
 `menu_id` varchar(64) NOT NULL,
 `user_id` int(10) DEFAULT NULL,
 `timestamp` int(10) DEFAULT NULL,
 PRIMARY KEY (`log_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Oh ok - So that _db_core_menu_access_logs references pds_core_menu_access_logs.

Then yes, that table exists. My DB has:
* pds_core_cron
* pds_core_filter
* pds_core_logs
* pds_core_menu_access_logs
* pds_core_menu_items
* pds_core_menu_structure
* pds_core_pluging_activation
* pds_core_plugin_classes
* pds_core_registration_queue
* pds_core_registration_tokens
* pds_core_session
* pds_core_settings
* pds_core_tags
* pds_core_templates
* pds_core_upload_logs
* pds_core_users
* pds_core_user_extra_groups
* pds_core_user_extra_roles
* pds_core_user_groups
* pds_core_user_roles
* pds_core_user_role_permissions

This is very strange and not normal behavior. Did you perhaps make any changes to your MySQL configuration? I will run a few tests on a Windows 7 machine and check if I can replicate the problem. However as far as I know there should not be any problems.

Are you using WAMP or XAMPP?

I am using WAMP, but not the built in MySQL service. That service is turned off.

I haven't made any modifications to the MySQL instance outside of adding a root user.

Did you try wiping the database clean and re starting the installer?

I did - What I did was drop the DB, replace the _complete.sql file with the new one, then ran the installer again.

Each time generates that error on the index page.

I'm also using MySQL 5.5 so it's probably not the problem.

First take a look in the folder /write/logs (inside the PHPDS installation folder), there should be a few "error**.html" files.

Please send me directly (<email address hidden>) these files and also your config file (on a plain installation, it should be /config/single-site.config.php) and we'll step from there to solve the problem.

Don't post them here, since they contain your password.

This question was expired because it remained in the 'Needs information' state without activity for the last 15 days.