autefrum
Posts: 9
|
Posted: 08/24/2017, 5:56 PM |
|
I specified port 3306 as the MySql port in the connections area of the project settings, and it created the following:
//Connection Settings @0-51FF0F87
$CCConnectionSettings = array (
"connMySQL_myConnectionName" => array(
"Type" => "MySQL",
"DBLib" => "MySQLi",
"Database" => "myDbName",
"Host" => "localhost",
"Port" => "3306;Database=myDbName",
"User" => "root",
"Password" => "",
"Persistent" => false,
"DateFormat" => array("yyyy", "-", "mm", "-", "dd", " ", "HH", ":", "nn", ":", "ss"),
"BooleanFormat" => array(1, 0, ""),
"Uppercase" => false
)
);
//End Connection Settings
This cause a notification to be logged by PHP, as the 'port' value is not a well formed numeric expression, which is fair enough.
I tried removing the port and leaving that blank and republishing, but when I reopened the database connection window, it had populated the port box with "Database=myDbName".
Is there some delimiter I am meant to put around the port number? Is this a known bug?
|
|
|
laneoc
Posts: 154
|
Posted: 08/24/2017, 8:17 PM |
|
It should read:
$CCConnectionSettings = array (
"connMySQL_myConnectionName" => array(
"Type" => "MySQL",
"DBLib" => "MySQLi",
"Database" => "myDbName",
"Host" => "localhost",
"Port" => "3306"
"Database" => "myDbName",
"User" => "root",
"Password" => "",
"Persistent" => false,
"DateFormat" => array("yyyy", "-", "mm", "-", "dd", " ", "HH", ":", "nn", ":", "ss"),
"BooleanFormat" => array(1, 0, ""),
"Uppercase" => false
)
);
_________________
Lane |
|
|
autefrum
Posts: 9
|
Posted: 08/24/2017, 8:22 PM |
|
Thanks Lane - I agree that's what it should be.
But when I put 3306 in the port number box, or leave it blank, it comes out as above -
"Port" => "3306;Database=myDbName",
I need to edit the Common.php file to make it just
"Port" => "3306"
but next time I publish the project, Code Charge puts the
"Port" => "3306;Database=myDbName",
back in.
I am wondering if anyone else has this problem, and how do I fix it?
|
|
|
DataDoIT
|
Posted: 08/25/2017, 2:12 PM |
|
If the port is left as blank, then it should actually show as:
"Port" => "0",
Go ahead and just put in 0 in the port field to see what you get.
|
|
|
autefrum
Posts: 9
|
Posted: 08/29/2017, 1:10 AM |
|
I tried placing 0 in the port field, and it still places
"Port" => "0;Database=myDbName",
In my Common.php
For me, this is a reproducible bug.
The fix I have found is to over-write the line in Common.php to remove the ;Database-myDbName
Can CodeCharge or anyone else reproduce this bug?
|
|
|
sabolc
Posts: 8
|
Posted: 11/07/2017, 9:08 PM |
|
It happened to me, too, but the solution was to go Project Settings (Alt-F7) and delete THERE the wrong parameter.
|
|
|
sabolc
Posts: 8
|
Posted: 11/07/2017, 9:09 PM |
|
It happened to me, too, but the solution was to go to Project Settings (Alt-F7) and delete THERE the wrong parameter.
|
|
|
sabolc
Posts: 8
|
Posted: 11/07/2017, 9:09 PM |
|
It happened to me, too, but the solution was to go to Project Settings (Alt-F7) and delete THERE the wrong parameter.
|
|
|
|
|
|
|
|