[mySQL] UPDATE problem - possible timeout - HELP!

[adosidos]

Hi,

I have a problem with the following code:

UPDATE History JOIN Kinos
SET History.KinoID=Kinos.id
WHERE History.Kino=Kinos.Kino;

when it's executed phpmyadmin shows only a white page (the left frame is still there) or
this:

"Proxy Error
The proxy server received an invalid response from an upstream server.

The proxy server could not handle the request POST /phpMyAdmin/import.php.

Reason: Document contains no data

Apache/1.3.37 Server at m.uttx.net Port 80"

I have no idea why this doesn't work.

Some specs:
mySQL Server Version: 5.0.22-max
History table:
22017 entries
884,1 KiB
Kinos table:
245 entries
21,2 KiB

Both are optimized. They are not very large. I don't get it.
Thanks in advance for any tips.

 

[TonyGroves]

You need to use an ON condition with the JOIN:
[tt]
UPDATE History JOIN Kinos ON History.Kino=Kinos.Kino
SET History.KinoID=Kinos.id
[/tt]