SQL Buddy bug

195 views
Skip to first unread message

daniels

unread,
Jun 10, 2011, 5:10:06 PM6/10/11
to SQL Buddy
SQL Buddy is awesome but it seems i found a bug.
If my database has views SQL Buddy gives errors.

One place where i get errors would be when i click on the database,
where the listing of the tables in that database are.
-------------------
Notice: Undefined index: in C:\Xampp\sqlbuddy\dboverview.php on line
216
viw_contacts
1
------------------

And another place is when i click on a view:
------------------
Notice: Undefined index: in C:\Xampp\sqlbuddy\structure.php on line
536
------------------

daniels

unread,
Jun 10, 2011, 5:30:18 PM6/10/11
to SQL Buddy
I kind of fixed the errors with this:
dboverview.php at 216
------------------
if (isset($collationList) && array_key_exists('Collation', $infoRow)
&& array_key_exists($infoRow['Collation'], $collationList)) {
echo '<td><div class="item column3">' .
$collationList[$infoRow['Collation']] . '</div></td>';
echo '<td><div class="item column4">' . $formattedOverhead . '</
div></td>';
} else if ($conn->getAdapter() == "mysql") {
echo '<td><div class="item column3">&nbsp;</div></td>';
echo '<td><div class="item column4">' . $formattedOverhead . '</
div></td>';
}
------------------

and structure.php at 536
---------------------------
if (array_key_exists('Collation', $infoRow) && isset($collationList)
&& array_key_exists($infoRow['Collation'], $collationList)) {
echo '<dt>' . ("Charset") . ':</dt><dd>' .
$collationList[$infoRow['Collation']] . '</dd>';
}
---------------------------

Bilbo

unread,
May 9, 2012, 1:25:58 PM5/9/12
to sql-...@googlegroups.com
Daniels' changes worked for me, as far as suppressing the error messages.

rawand rawand

unread,
May 13, 2012, 8:29:15 AM5/13/12
to sql-...@googlegroups.com
Ok

rawand rawand

unread,
May 31, 2012, 4:07:30 AM5/31/12
to sql-...@googlegroups.com
Thanks
Reply all
Reply to author
Forward
0 new messages