Results 1 to 3 of 3

Thread: updating problem

  1. #1
    Join Date
    Aug 2007
    Location
    selangor
    Posts
    14
    Rep Power
    0

    updating problem

    Insufficient key column for updating and refreshing?
    i'm getting this error when i try to update my records... what does it mean and how could i solve this problem? please help.... (-;

    i'm use mySql database..

  2. #2
    Join Date
    Nov 2001
    Location
    Johor
    Posts
    772
    Rep Power
    227
    hi jaszyler,

    please paste your current php/mysql code here



    Quote Originally Posted by jaszyler View Post
    Insufficient key column for updating and refreshing?
    i'm getting this error when i try to update my records... what does it mean and how could i solve this problem? please help.... (-;

    i'm use mySql database..
    I hate when:

    vBulletin Message:
    Sorry! The administrator has specified that users can only post one message every 60 seconds

  3. #3
    Join Date
    Mar 2008
    Location
    pd
    Posts
    497
    Rep Power
    144
    That error usually means you're trying to update a row in a query when the query didn't include enough columns to uniquely identify the row - the database engine doesn't know which row in the underlying table to apply the update to, or even which table rows are represented by the query rows for 'refresh'. To fix, you can usually just include an 'id' column in your query, or make the columns you're querying keys that can uniquely identify your records.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. problem with id
    By nur_kasih in forum Website Programming
    Replies: 6
    Last Post: 20-08-2011, 03:27 PM
  2. Does anyone get the same problem?
    By thousandlingers in forum Website Design
    Replies: 4
    Last Post: 27-03-2008, 02:22 PM
  3. PR updating now
    By tansks in forum Mamak Stall
    Replies: 8
    Last Post: 15-01-2007, 08:00 AM
  4. ISP problem lately?
    By Hunz in forum Mamak Stall
    Replies: 2
    Last Post: 05-12-2004, 04:08 PM
  5. Any way to get around this problem
    By philin in forum Revenue and Monetization
    Replies: 18
    Last Post: 09-10-2004, 11:56 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Search Engine Optimization by vBSEO 3.5.0 RC1 PL1

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112