On Fri, 03 Aug 2007 01:11:18 -0700, GarryJones <morack@algonet.se>
wrote:

>Yesterday a row of code suddenly stopped working. The file on the
>server has not been updated for months and it has been okay until now.
>I know for a fact it worked yesterday morning and by the evening was
>not working.

Aside from printing out the error message returned (if there is one)
you could check the tables for consistancy and possibly try selecting
a single row from each table manually.


>
>I am using these two strings to collect data that I then display.
>
>$ml_collect1='SELECT * FROM ml_lopp LEFT JOIN scfmforening ON
>(scfmforening.scfmnum=ml_lopp.scfmnum) LEFT JOIN ml_newtidplats ON
>(ml_newtidplats.loppnum=ml_lopp.loppnum) LEFT JOIN ml_mainkon ON
>(ml_mainkon.loppnum=ml_lopp.loppnum) WHERE ml_lopp.sank2006="ja" ORDER
>BY date1, ml_lopp.loppnum';
>
>$ml_collect2='SELECT * FROM ml_lopp LEFT JOIN scfmforening ON
>(scfmforening.scfmnum=ml_lopp.scfmnum) LEFT JOIN ml_newtidplats ON
>(ml_newtidplats.loppnum=ml_lopp.loppnum) LEFT JOIN ml_anm ON
>(ml_anm.loppnum=ml_lopp.loppnum) WHERE ml_lopp.sank2006="ja" ORDER BY
>date1, ml_lopp.loppnum';

Just a guess ... there's now nothing to join on ml_amm.

>
>$ml_collect1 now returns no values, but $ml_collect2 is still finding
>all 97 rows of data.
>
>As my code is static I can only summise that a user edit or user
>additon of data or possivbly a server side software upgrade has caused
>the sudden error. How else can a sudden malfunction of code be
>explained? However, I can not see any strange user data and the host
>company host ensures me nothing has been changed.
>
>The difference in the two rows of code are the reference to the tables
>"ml_mainkon" and "ml_anm".
>
>Any ideas?

Worst case: restore the tables from backup and, if it works, diff the
old tables with the current tables to see what's different. (You DO
do backups, right?)

--
gburnore at DataBasix dot Com
---------------------------------------------------------------------------
How you look depends on where you go.
---------------------------------------------------------------------------
Gary L. Burnore | ÝÛ³ºÝ³Þ³ºÝ³³Ýۺݳ޳ºÝ³Ý³Þ³ºÝ³ÝÝÛ³
| ÝÛ³ºÝ³Þ³ºÝ³³Ýۺݳ޳ºÝ³Ý³Þ³ºÝ³ÝÝÛ³
Official .sig, Accept no substitutes. | ÝÛ³ºÝ³Þ³ºÝ³³Ýۺݳ޳ºÝ³Ý³Þ³ºÝ³ÝÝÛ³
| ÝÛ 0 1 7 2 3 / Ý³Þ 3 7 4 9 3 0 Û³
Black Helicopter Repair Services, Ltd.| Official Proof of Purchase
================================================== =========================