search

mattyhead / sql-buddy

Automatically exported from code.google.com/p/sql-buddy
MIT License
0 stars 0 forks source link

Problem with views #28

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. just create a view and look the dboverview

What is the expected output? What do you see instead?
I get this message: Notice: Undefined index: in
/var/www/mydomain/httpdocs/sqlbuddy/dboverview.php on line 216

What version of the product are you using? On what operating system?
sql-buddy 1.3.2 on xubuntu 9.04

Thanks for this great tool!

Original issue reported on code.google.com by giusep...@gmail.com on 6 Feb 2010 at 5:12

GoogleCodeExporter commented 9 years ago 
Just started using sqlbuddy and ran into the same problem, apparently it's not 
handling views in the db overview.

Till they officially fix it you can just open up dboverview.php and change line 
215 
to:

  if (isset($collationList) && array_key_exists("Collation", $infoRow) && 
array_key_exists($infoRow['Collation'],$collationList)) {

That did the trick for me.

Original comment by n.rijk...@gmail.com on 26 Mar 2010 at 7:02

GoogleCodeExporter commented 9 years ago 
I had the same issue. Thanks for posting the fix n.rijksen :) works perfectly.

Original comment by Lammert....@gmail.com on 13 Aug 2010 at 7:54

GoogleCodeExporter commented 9 years ago 
Problem still exists in July of 2013...thanks for the solution.

Original comment by yschul...@gmail.com on 23 Jul 2013 at 8:57