New SQL window setting value

Posts from previous Beta sessions

New SQL window setting value

Postby 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.
I <3 /bin/bash
User avatar
PleegWat
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 1636
Joined: Tue Jul 04, 2006 1:43 pm

New SQL window setting value

Postby 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
Last edited by Subxero on Tue Jan 22, 2008 10:20 pm, edited 1 time in total.
Subxero - Priest 70 Holy - Asphelt Knight Officer - Zul'jin Horde.
User avatar
Subxero
WR.net Artisan
WR.net Artisan
 
Posts: 234
Joined: Thu Jul 06, 2006 4:08 pm
Realm: Zul'jin (PvE) - US

New SQL window setting value

Postby PleegWat » Tue Jan 22, 2008 10:22 pm

Fixed SVN 1586. Thanks.
I <3 /bin/bash
User avatar
PleegWat
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 1636
Joined: Tue Jul 04, 2006 1:43 pm

New SQL window setting value

Postby 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
Subxero - Priest 70 Holy - Asphelt Knight Officer - Zul'jin Horde.
User avatar
Subxero
WR.net Artisan
WR.net Artisan
 
Posts: 234
Joined: Thu Jul 06, 2006 4:08 pm
Realm: Zul'jin (PvE) - US


Return to Archived

Who is online

Users browsing this forum: No registered users and 0 guests

cron