[shadaddy]

Along the same lines, SQLyog could have an entire preferences section in which users could change several features such as always showing results in text.

[shadaddy]

Here is my output. The first is from setting a value to 0 and it changes all of the others to 0. The second output is when I press Alt-N on a field to set it to NULL.

[6:19:41 AM][ 10 ms] show databases

[8:45:36 AM][ 901 ms] show table status from `Potlines`

[8:45:54 AM][ 350 ms] select * from `Potlines`.`dailyreductionsummarygoalstable` limit 0,5000

[8:46:03 AM][ 0 ms] show fields from `Potlines`.`dailyreductionsummarygoalstable`

[8:46:03 AM][ 0 ms] show keys from `Potlines`.`dailyreductionsummarygoalstable`

[8:46:03 AM][ 10 ms] select * from `Potlines`.`dailyreductionsummarygoalstable` limit 0, 5000

[8:46:09 AM][ 0 ms] update `Potlines`.`dailyreductionsummarygoalstable` set `Date`='2003-12-01', `Name`='craig hall', `GrossAlLbs`='40000000', `MetalAdjust`='0', `NetAlLbs`='', `LbsPotDay`='', `ColdAdjust`='', `Rodding`='', `OperCells`='', `AvgAmps`='0', `AvgVolts`='0', `GrossVolts`='0', `KwCell`='0', `KwhLbAl`='0', `MinPwrOff`='0', `PerCurrEff`='0', `AdjPerCurrEff`='0', `AcDcEff`='0', `AvgTotalAE`='0', `AvgAEMin`='0', `AEPotDay`='0', `AvgMinPerAE`='0', `AvgPerAl`='0', `PerAl9985`='0', `PerAl9990`='0', `AvgPerFe`='0', `AvgPerSi`='0', `BathDepth`='0', `MetalDepth`='0', `Temperature`='0', `AvgPerExsAlF3`='0', `AvgPerSpar`='0', `AnodesReceived`='0', `GrossTonsC`='0', `TonsButts`='0', `LbsPerAnode`='0', `LbsPerButt`='0', `GrossCPerLbAl`='0', `NetCPerLbAl`='0', `TonsCry`='0', `TonsAlF3`='0', `TonsLithium`='0' where Date='2003-12-01'

[8:46:10 AM][ 10 ms] select * from `Potlines`.`dailyreductionsummarygoalstable` limit 0,5000

[8:46:38 AM][ 0 ms] show fields from `Potlines`.`dailyreductionsummarygoalstable`

[8:46:38 AM][ 0 ms] show keys from `Potlines`.`dailyreductionsummarygoalstable`

[8:46:38 AM][ 10 ms] select * from `Potlines`.`dailyreductionsummarygoalstable` limit 0, 5000

[8:46:45 AM][ 0 ms] update `Potlines`.`dailyreductionsummarygoalstable` set `Date`='2003-12-01', `Name`='craig hall', `GrossAlLbs`='40000000', `MetalAdjust`=NULL, `NetAlLbs`='0', `LbsPotDay`='0', `ColdAdjust`='0', `Rodding`='0', `OperCells`='0', `AvgAmps`='0', `AvgVolts`='0', `GrossVolts`='0', `KwCell`='0', `KwhLbAl`='0', `MinPwrOff`='0', `PerCurrEff`='0', `AdjPerCurrEff`='0', `AcDcEff`='0', `AvgTotalAE`='0', `AvgAEMin`='0', `AEPotDay`='0', `AvgMinPerAE`='0', `AvgPerAl`='0', `PerAl9985`='0', `PerAl9990`='0', `AvgPerFe`='0', `AvgPerSi`='0', `BathDepth`='0', `MetalDepth`='0', `Temperature`='0', `AvgPerExsAlF3`='0', `AvgPerSpar`='0', `AnodesReceived`='0', `GrossTonsC`='0', `TonsButts`='0', `LbsPerAnode`='0', `LbsPerButt`='0', `GrossCPerLbAl`='0', `NetCPerLbAl`='0', `TonsCry`='0', `TonsAlF3`='0', `TonsLithium`='0' where Date='2003-12-01'

[8:46:47 AM][ 0 ms] select * from `Potlines`.`dailyreductionsummarygoalstable` limit 0,5000

[shadaddy]

Seems that way. Hopefully that's the only command that has changed. I've been messing around with it all day and that's the only thing I've noticed so far. Again thanks for the help, and I look forward to the fix on the GUI.

[shadaddy]

Thanks for all the help. Just as a final note, I ran the following query from yog:

check table `Carbon`.`vibratortable` extended

And that worked. Also tried it from php. Seemed to work there as well.

But still the built in tools, table diagnostics, check {none,quick,fast,medium,extended,changed} did not work.

[shadaddy]

All tables are MyISAM. This problem did not occurr until I upgraded MySQL.

[shadaddy]

CalEvans wrote on Feb 6 2003, 07:16 PM:

Can you paste the check statement into the mysql command line tool on the server? Does it work?

Can you cehck 1 or 2 tables instead of all of them? Does it work?

=C=

Tried pasting into the command line tool. Same error.

Tried just one table. Same error.

[shadaddy]

History window for table diagnostic type=extended

[10:19:56 AM][ 0 ms] show tables from `Carbon`

[10:19:59 AM][ 0 ms] check table `Carbon`.`vibratortable`, `Carbon`.`sodiumfractionstable`, `Carbon`.`sodiumbuttcrushertable`, `Carbon`.`rejecttable`, `Carbon`.`pittable`, `Carbon`.`pitchtable`, `Carbon`.`passgen`, `Carbon`.`oxytable`, `Carbon`.`liquidgraphitetable`, `Carbon`.`grndaystable`, `Carbon`.`greensievetable`, `Carbon`.`greendensitytable`, `Carbon`.`greendensityentrytable`, `Carbon`.`gascontable`, `Carbon`.`fluehistorytable`, `Carbon`.`fluehistoryinttable`, `Carbon`.`fluehistoryexttable`, `Carbon`.`fluehistory_fluhis`, `Carbon`.`fluehistory_flueint`, `Carbon`.`fluehistory_flueext`, `Carbon`.`coretechtable`, `Carbon`.`coredataentrytable`, `Carbon`.`castirontable`, `Carbon`.`carriertable`, `Carbon`.`butttable`, `Carbon`.`bakedscrapentrytable`, `Carbon`.`bakedensitytable`, `Carbon`.`bakedensityentrytable`, `Carbon`.`anod_hdl_table` type=Extended

[Author]

Posts