mysql error with the comments for the blog
Permalink
here is what is showing up on the site when we fill in the form.
mysqlt error: [1054: Unknown column 'user_website' in 'field list'] in EXECUTE("INSERT INTO btGuestBookEntries (bID, cID, uID, user_name, user_email, user_website, commentText, approved) VALUES ('498', '222', 3, 'test', 'demo@optious.com', 'www.optious.com', 'TEST', 0)")
Can't find exactly where the error occurring. require a little guidance.
mysqlt error: [1054: Unknown column 'user_website' in 'field list'] in EXECUTE("INSERT INTO btGuestBookEntries (bID, cID, uID, user_name, user_email, user_website, commentText, approved) VALUES ('498', '222', 3, 'test', 'demo@optious.com', 'www.optious.com', 'TEST', 0)")
Can't find exactly where the error occurring. require a little guidance.
What this error is saying is that you are trying to save some data to the database. One of your fields is called user_website. That field can't be saved because the table btGuestBookEntries where you are trying to save doesn't have a user_website field to save that data.
First thing you should do is check your table