Jason L. Froebe – Tech tips and How Tos for Fellow Techies

Tips & Tricks for Databases (Sybase, Oracle, MySQL, PostgreSQL, SQLite), Windows, Linux, Solaris, Perl, Java, Bash and so much much more

Thievery in Flossmoor, Illinois School District 161.. Where your money is really going to

by Jason L Froebe on October 1, 2009, one comment

Please email the Flossmoor School District 161 School Board and let them know what you think!

Share Button

WordPress, MySQL and a bit of corruption caused the tags & categories to disappear

by Jason L Froebe on May 1, 2008, no comments

Sometime early this afternoon, the categories & tags of my blog disappeared. After a little bit of investigation (I was working quite heavily at the time), I discovered that the wp_term_taxonomy table in MySQL contained minor corruption. I ran repair table ‘wp_term_taxonomy’ and it was corrected.

Share Button

Duplicate rows in sysusers??

by Jason L Froebe on December 11, 2007, no comments

If you’re like me, you’ve run into lots of different issues with the Sybase ASE DBMS over the years. Today, Drew Montgomery looked at what happens when the 12.5.x -> 12.5.4 upgrade goes bad: If you receive the 8419 error on sysusers after applying ASE 12.5.4 (or any other upgrade for that matter) such as [...]

Share Button

Finding suspect indexes in Sybase ASE

by Jason L Froebe on September 21, 2006, no comments

Problem: ASE does not use an index on a table because it is marked suspect Index id 2 on table id 864003078 cannot be used in the optimization of a query as it is SUSPECT. Please have the SA run DBCC REINDEX on the specified table. Index id 2 on table id 864003078 cannot be [...]

Share Button
Facebook login by WP-FB-AutoConnect