CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> PHP

 Common.php "Port" => "3306;Database=myDbName", should be just 3306

Print topic Send  topic

Author Message
autefrum

Posts: 9
Posted: 08/24/2017, 5:56 PM Quote message

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?
View profile  Send private message
laneoc

Posts: 130
Posted: 08/24/2017, 8:17 PM Quote message

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
View profile  Send private message
autefrum

Posts: 9
Posted: 08/24/2017, 8:22 PM Quote message

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?
View profile  Send private message
DataDoIT
Posted: 08/25/2017, 2:12 PM Quote message

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 Quote message

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?
View profile  Send private message
sabolc

Posts: 8
Posted: 11/07/2017, 9:08 PM Quote message

It happened to me, too, but the solution was to go Project Settings (Alt-F7) and delete THERE the wrong parameter.
View profile  Send private message
sabolc

Posts: 8
Posted: 11/07/2017, 9:09 PM Quote message

It happened to me, too, but the solution was to go to Project Settings (Alt-F7) and delete THERE the wrong parameter.
View profile  Send private message
sabolc

Posts: 8
Posted: 11/07/2017, 9:09 PM Quote message

It happened to me, too, but the solution was to go to Project Settings (Alt-F7) and delete THERE the wrong parameter.
View profile  Send private message

Add new topic Reply to topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.