This is a common problem when you attempt to build the trackDb tables locally with obsolete software. Please use the trackDb tables from UCSC with your new software.
--Hiram ----- Original Message ----- From: "WANG Wuqi" <[email protected]> To: "Hiram Clawson" <[email protected]> Cc: [email protected], "WANG Wuqi" <[email protected]> Sent: Sunday, March 20, 2011 10:44:29 PM Subject: RE: [Genome] Upgrade UCSC genome browser Hi Hiram, Thanks for your advice. Some new problems appear after "Click here to reset the browser user interface settings to their defaults", then go to mm8, mm9 or hg18, similar error come on for table 'mrna', error message below: --------------------mm8 Can't start query: select * from mrna where tName='chr12' and (bin=1024 or bin=127 or bin=15 or bin=1 or bin=0 or bin=4681 ) and tStart<57630019 and tEnd>57612908 mySQL error 1146: Table 'mm8.mrna' doesn't exist ---------------------mm9 Can't start query: select * from mrna where tName='chr12' and (bin>=1025 and bin<=1026 or bin=128 or bin=15 or bin=1 or bin=0 or bin=4681 ) and tStart<57815592 and tEnd>57795962 mySQL error 1146: Table 'mm9.mrna' doesn't exist --------------------hg18 Can't start query: select * from mrna where tName='chrX' and (bin>=1737 and bin<=1739 or bin=217 or bin=27 or bin=3 or bin=0 or bin=4681 ) and tStart<151383976 and tEnd>151073053 mySQL error 1146: Table 'hg18.mrna' doesn't exist I already checked database, corresponding table like '_mrna' existed, please see attachment. Please give me some advice Thanks & Regards Wuqi _______________________________________________ Genome maillist - [email protected] https://lists.soe.ucsc.edu/mailman/listinfo/genome
