[Bill Thebert]

Let me start by saying I'm really new at this, and I'm working on my very first [tiny] hack of my own -- not just applying someone else's hack by means of the cookbook instructions.

I want to write an additional piece of information (from a custom profile field) to the 'thread' table when a new thread is created.

I've created the new column in the 'thread' table; it's present and has the same properties as the source field (field9) in the 'userfield' table.

I've located the following code in /includes/functions_newpost.php :

PHP Code:

                INSERT INTO " . TABLE_PREFIX . "thread(title, lastpost, forumid, open, replycount, postusername, postuserid, lastposter, dateline,
                     iconid, visible, attach, similar)
                VALUES
                    ('" . addslashes($post['title']) . "', " . TIMENOW . ", " . intval($foruminfo['forumid']) . ",
                     1, 0, '" . addslashes($post['postusername']) . "', $bbuserinfo[userid],
                     '" . addslashes($post['postusername']) . "', " . TIMENOW . ", $post[iconid], $post[visible],
                     $totalattachments, '" . addslashes($similarthreads) . "') 


and I've changed it to:

PHP Code:

                INSERT INTO " . TABLE_PREFIX . "thread(title, lastpost, forumid, open, replycount, postusername, postuserid, lastposter, dateline,
                     iconid, visible, attach, similar, field9)
                VALUES
                    ('" . addslashes($post['title']) . "', " . TIMENOW . ", " . intval($foruminfo['forumid']) . ",
                     1, 0, '" . addslashes($post['postusername']) . "', $bbuserinfo[userid],
                     '" . addslashes($post['postusername']) . "', " . TIMENOW . ", $post[iconid], $post[visible],
                     $totalattachments, '" . addslashes($similarthreads) . "', $bbuserinfo[field9]) 


All I've done is added the new field name to be filled in, and the new source field from which the data is to be grabbed.

When I execute the code by submitting a new post (creating a new thread), this is the SQL error message I see:

Invalid SQL: 
				INSERT INTO thread(title, lastpost, forumid, open, replycount, postusername, postuserid, lastposter, dateline,
					 iconid, visible, attach, similar, field9)
				VALUES
					('Test', 1079310282, 2,
					 1, 0, 'Bill Thebert', 1,
					 'Bill Thebert', 1079310282, 0, 1,
					 0, '', AK)
			
mysql error: Unknown column 'AK' in 'field list'

mysql error number: 2000

Date: Sunday 14th of March 2004 06:24:42 PM
Username: Bill Thebert

Can someone please spare a moment to explain to me what this error message is trying to tell me?

The data in 'field9' of my user profile *is* the two-character string "AK"; so it appears that the $bbuserinfo[field9] variable is correct, and the data is being retrieved properly.

The new column in the 'thread' table *is* entitled 'field9'.

I just can't figure out what Unknown column 'AK' in 'field list' is trying to tell me.

Thanks,

Bill