New SQL window setting value

by **PleegWat** » Tue Jan 22, 2008 3:32 pm

Apart from 'on' or 'off' you can now also set the SQL window setting to 'extended'. The default stays 'on'. Addon developers looking to increase performance can set this to 'extended' to show SQL DESCRIBE information in the query window.

This setting includes a performance hit, and should be turned off again after use.

by **Subxero** » Tue Jan 22, 2008 9:58 pm

Now I get these error... when i disable extended sql window still asign text to 'DESCRIBE' but not exist because its disable, on line 97 of footer.php you need check if its extended or not .. to assign or ignore.

With SQL on:
footer.php on line 97: Undefined index: describe
footer.php on line 97: Undefined index: describe
footer.php on line 97: Undefined index: describe
footer.php on line 97: Undefined index: describe

With SQL extended:
lib/dbal/mysql.php
Warning line 63: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource
Warning line 64: mysql_free_result(): supplied argument is not a valid MySQL result resource

by **PleegWat** » Tue Jan 22, 2008 10:22 pm

Fixed SVN 1586. Thanks.

by **Subxero** » Tue Jan 22, 2008 10:39 pm

Well now i get the error only on CP page (you need change the mode and refresh manually the page or move to another CP panel to see the error)
./roster/index.php?p=rostercp&a=g:1
At rest of pages works perfect

With Debug SQL Extended:
lib/dbal/mysql.php
Warning line 63: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource
Warning line 64: mysql_free_result(): supplied argument is not a valid MySQL result resource