SEO

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.

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';

$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?

Garry Jones
Sweden

GarryJones 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.
>
> 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';
>
> $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?
>
> Garry Jones
> Sweden
>

echo mysql_errno().': '.mysql_error();

to see what the problem is.

Norm

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
================================================== =========================