Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- UPDATE won't work
September 1, 2006, 8:14 pm
rate this thread
thread, the Parent_Ancestor takes on the record ID (field called
Forum). For some reason, new threads are not inheriting the record ID,
but always receive the number 65535 in its place.
When I try to update a field in a record through PHPMyAdmin, the query
executes, but the record isn't actually updated. Here's my update
UPDATE `Forum` SET `Forum_Ancestor` = '66901' WHERE `Forum` = '66901'
LIMIT 1 ;
I want the Forum_Ancestor to be the same as the record ID. But, when I
check the record it is still 65535 (which is an erroneous number
Is there any significance to the number 65535? Why won't the record
Thanks in advance
Re: UPDATE won't work
I had the Forum_Parent field set to tinyint(5), which didn't allow any
ID's higher than 65535 to be set in Forum_Parent field. Once I set the
field to a MEDIUMINT(8), I had no problem.
Whew! What a great help you have been. Thanks again!
Your key to my success:
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum
- » ssh on command line: force using a group size (prime size) of 1024 (and no...
- — The site's Newest Thread. Posted in » Secure Shell Forum