<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body text="#336666" bgcolor="#ffffff">
<small><font face="Trebuchet MS">Hello,<br>
<br>
I felt to have the problem upon installation of vTiger 5.2.1 on
a MySql 5.5.8 server, and although I changed the
DatabaseSchema.xml, I was still having the "Tables Partially
Created" error message, so I decided to take a look to the code
and I came to find the following code error:<br>
<br>
On function createTables of PearDatabase:<br>
<br>
// ADODB newly added methods<br>
function createTables($schemaFile, $dbHostName=false,
$userName=false, $userPassword=false, $dbName=false,
$dbType=false) {<br>
$this->println("ADODB createTables ".$schemaFile);<br>
if($dbHostName!=false) $this->dbHostName=$dbHostName;<br>
if($userName!=false) $this->userName=$userPassword;<br>
if($userPassword!=false)
$this->userPassword=$userPassword;<br>
if($dbName!=false) $this->dbName=$dbName;<br>
if($dbType!=false) $this->dbType=$dbType; <br>
<br>
$this->checkConnection();<br>
$db = $this->database;<br>
$schema = new adoSchema( $db );<br>
//Debug Adodb XML Schema<br>
<b><font color="#cc0000">$sehema</font></b>->XMLS_DEBUG
= TRUE;<br>
//Debug Adodb<br>
<font color="#cc0000"><b>$sehema</b></font>->debug =
true;<br>
$sql = $schema->ParseSchema( $schemaFile );<br>
<br>
$this->println("--------------Starting the table
creation------------------");<br>
$result = $schema->ExecuteSchema( $sql,
$this->continueInstallOnError );<br>
if($result) print $db->errorMsg();<br>
// needs to return in a decent way<br>
$this->println("ADODB createTables ".$schemaFile."
status=".$result);<br>
return $result;<br>
}<br>
<br>
The variable <b>$schema</b> is wrongly spelled in two lines,
although it does not affect the function completion.<br>
<br>
Regards,<br>
<br>
Xavier<br>
</font></small>
<div class="moz-signature">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta content="MSHTML 6.00.2900.5583" name="GENERATOR">
</div>
<br>
<br>
</body>
</html>