phpdevshell team mailing list archive

[Ryan Perreault <question220604@xxxxxxxxxxxxxxxxxxxxx>]

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

I'm running a clean installation of PHPDevShell (tried 3.2.0 first, then 3.1.2). During the installation on stage 2, the following error is displayed:

Starting actual installation
Database filling...
13%
Alert: The operation stopped because;.
An error occured trying to send the queries (query 74/522).
The error was: [1366]
The offending query was: " INSERT INTO `pds_core_menu_structure` VALUES ('', '2266433229', '0', '2')" 

MySQL Information:
+-------------------------+------------------------------+
| Variable_name           | Value                        |
+-------------------------+------------------------------+
| innodb_version          | 1.1.8                        |
| protocol_version        | 10                           |
| slave_type_conversions  |                              |
| version                 | 5.5.23                       |
| version_comment         | MySQL Community Server (GPL) |
| version_compile_machine | x86                          |
| version_compile_os      | Win64                        |
+-------------------------+------------------------------+

I opened up the SQL file that is in question during the installation and manually created that table and ran that insert. Error is related to the '' inserted for the ID. 

I ran a script I found on this forum to get around this issue, but when I go to index.php, I am seeing another insert error that is exactly like this one.

Is there anyway around this with my version of MySQL? Do I need to use an earlier version of MySQL (5.0.x)?

Thanks for any/all help.

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