Faulty query

    Date: 11/06/07 (MySQL Communtiy)    Keywords: no keywords

    My host is telling me this query is the one that's blocking the server and that is wrong, but for the life of me I don't know why:

    UPDATE ncis_stories SET hits = hits+1, story_date = story_date WHERE id = 00960

    Do you have any idea? Many thanks in advance.

    Source: http://community.livejournal.com/mysql/121198.html

« SELECT multiple occurances... || COUNTing total GROUPed rows »


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home