Setup problem blank database.

babynus
Offline
Administrator
Moderator

23 Mar 2013 15:45 #7 by babynus

Replied by babynus on topic Re: Setup problem blank database.

It looks like you cannot get a connection.

Can you add a var_dump for connection on Sql.php, line 244. It should look like :

try {
    	$dsn = self::$dbType.':host='.self::$dbHost.';dbname='.self::$dbName; 	    
    	self::$connexion = new PDO($dsn, self::$dbUser, self::$dbPassword);
var_dump(self::$connexion);
    	self::$connexion->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    }
    catch (PDOException $e) {
    	echo htmlGetErrorMessage($e->getMessage( )).'<br />';
    }

and report here displayed content.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

jaynarol
Topic Author
Offline
New Member

23 Mar 2013 15:56 - 23 Mar 2013 16:01 #8 by jaynarol

Replied by jaynarol on topic Re: Setup problem blank database.

I think it error before var_dump().

This is a Full HTML code in page.

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" 
  "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
  <meta http-equiv="content-type" content="text/html; charset=UTF-8" />
  <title>Project'Or RIA</title>
  <link rel="shortcut icon" href="img/logo.ico" type="image/x-icon" />
  <link rel="icon" href="img/logo.ico" type="image/x-icon" />
  <link rel="stylesheet" type="text/css" href="css/projector.css" />
  <script type="text/javascript" src="js/projector.js" ></script>
  <script type="text/javascript" src="js/projectorDialog.js" ></script>
  <script type="text/javascript" src="../external/dojo/dojo.js"
    djConfig='modulePaths: {i18n: "../../tool/i18n"},
              parseOnLoad: true, 
              isDebug: <span class="messageERROR" >SQLSTATE[HY000] [2002] A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
</span><input type="hidden" id="lastSaveId" value="" /><input type="hidden" id="lastOperation" value="control" /><input type="hidden" id="lastOperationStatus" value="ERROR" /><br /><br />
<font size='1'><table class='xdebug-error xe-fatal-error' dir='ltr' border='1' cellspacing='0' cellpadding='1'>
<tr><th align='left' bgcolor='#f57900' colspan="5"><span style='background-color: #cc0000; color: #fce94f; font-size: x-large;'>( ! )</span> Fatal error: Call to a member function query() on a non-object in D:\Web\NotAllowedScript663b2da9edc59web.com\pmi\model\persistence\Sql.php on line <i>58</i></th></tr>
<tr><th align='left' bgcolor='#e9b96e' colspan='5'>Call Stack</th></tr>
<tr><th align='center' bgcolor='#eeeeec'>#</th><th align='left' bgcolor='#eeeeec'>Time</th><th align='left' bgcolor='#eeeeec'>Memory</th><th align='left' bgcolor='#eeeeec'>Function</th><th align='left' bgcolor='#eeeeec'>Location</th></tr>
<tr><td bgcolor='#eeeeec' align='center'>1</td><td bgcolor='#eeeeec' align='center'>0.0016</td><td bgcolor='#eeeeec' align='right'>397824</td><td bgcolor='#eeeeec'>{main}(  )</td><td title='D:\Web\NotAllowedScript663b2da9edc59web.com\pmi\view\main.php' bgcolor='#eeeeec'>..\main.php<b>:</b>0</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>2</td><td bgcolor='#eeeeec' align='center'>0.0047</td><td bgcolor='#eeeeec' align='right'>664264</td><td bgcolor='#eeeeec'>require_once( <font color='#00bb00'>'D:\Web\NotAllowedScript663b2da9edc59web.com\pmi\tool\projector.php'</font> )</td><td title='D:\Web\NotAllowedScript663b2da9edc59web.com\pmi\view\main.php' bgcolor='#eeeeec'>..\main.php<b>:</b>10</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>3</td><td bgcolor='#eeeeec' align='center'>0.0280</td><td bgcolor='#eeeeec' align='right'>1679096</td><td bgcolor='#eeeeec'>include( <font color='#00bb00'>'D:\Web\NotAllowedScript663b2da9edc59web.com\pmi\view\login.php'</font> )</td><td title='D:\Web\NotAllowedScript663b2da9edc59web.com\pmi\tool\projector.php' bgcolor='#eeeeec'>..\projector.php<b>:</b>121</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>4</td><td bgcolor='#eeeeec' align='center'>0.0286</td><td bgcolor='#eeeeec' align='right'>1679408</td><td bgcolor='#eeeeec'>Parameter::getGlobalParameter(  )</td><td title='D:\Web\NotAllowedScript663b2da9edc59web.com\pmi\view\login.php' bgcolor='#eeeeec'>..\login.php<b>:</b>24</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>5</td><td bgcolor='#eeeeec' align='center'>0.0287</td><td bgcolor='#eeeeec' align='right'>1681048</td><td bgcolor='#eeeeec'>SqlElement->getSqlElementsFromCriteria(  )</td><td title='D:\Web\NotAllowedScript663b2da9edc59web.com\pmi\model\Parameter.php' bgcolor='#eeeeec'>..\Parameter.php<b>:</b>471</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>6</td><td bgcolor='#eeeeec' align='center'>0.0296</td><td bgcolor='#eeeeec' align='right'>1739592</td><td bgcolor='#eeeeec'>Sql::query(  )</td><td title='D:\Web\NotAllowedScript663b2da9edc59web.com\pmi\model\persistence\SqlElement.php' bgcolor='#eeeeec'>..\SqlElement.php<b>:</b>1163</td></tr>
</table></font>

Last edit: 23 Mar 2013 16:01 by jaynarol.

Please Log in or Create an account to join the conversation.

jaynarol
Topic Author
Offline
New Member

23 Mar 2013 16:11 - 23 Mar 2013 16:13 #9 by jaynarol

Replied by jaynarol on topic Re: Setup problem blank database.

OK i can FIX it! :woohoo:

Insert Port in to Line 219

217    if (!self::$dbType or !self::$dbHost or !self::$dbName) {
218      self::$dbType=Parameter::getGlobalParameter('paramDbType');
219      self::$dbHost=Parameter::getGlobalParameter('paramDbHost').':'.Parameter::getGlobalParameter('paramDbPort');
220      self::$dbUser=Parameter::getGlobalParameter('paramDbUser');
221      self::$dbPassword=Parameter::getGlobalParameter('paramDbPassword');
222      self::$dbName=Parameter::getGlobalParameter('paramDbName');     
223    }

Thank you so much :lol:

Last edit: 23 Mar 2013 16:13 by jaynarol.

Please Log in or Create an account to join the conversation.

babynus
Offline
Administrator
Moderator

23 Mar 2013 16:35 #10 by babynus

Replied by babynus on topic Re: Setup problem blank database.

You're right !

Code only worked for default port (3306).
I'll include this fix in next version.

Thanks for your contribution.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

pfernandez
Offline
New Member

28 Mar 2013 15:19 - 28 Mar 2013 15:22 #11 by pfernandez

Replied by pfernandez on topic Re: Setup problem blank database.

Hi,

Your patch doesn't work.
The DSN is not corretly set.
I suggest :

class Sql {
[...]
  private static $dbPort;
[...]
  private static function getConnection() {
[...]
      if (isset($paramDbPort) and $paramDbPort) { self::$dbPort = $paramDbPort; }
[...]
        $dsn = self::$dbType.':host='.self::$dbHost.';port='.self::$dbPort.';dbname='.self::$dbName;
[...]

Last edit: 28 Mar 2013 15:22 by pfernandez.

Please Log in or Create an account to join the conversation.

babynus
Offline
Administrator
Moderator

28 Mar 2013 15:36 #12 by babynus

Replied by babynus on topic Re: Setup problem blank database.

It is this syntax for DSN that is implement in V3.2.2.
Did you test it ?

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

Moderators: babynus, protion

Time to create page: 0.045 seconds

Setup problem blank database.

Cookies settings

Functional Cookies

Session

Other cookies

Setup problem blank database.

Cookies settings

Functional Cookies

Session

Other cookies

Login Form