Thread: Blog Error in Dolphin 5.5

Hello,

When I post into my blog I get an database error:

HTML Code:

Error in /blog.php: Column 'IP' in field list is ambiguous
Query: '
SELECT 
`commentID`,
`blogID`,
`senderID`,
`commentText`,
`replyTo`,
`IP`,
DATE_FORMAT(`date`, '%d-%m-%y %H:%i') AS date,
`Profiles`.`ID`,
`Profiles`.`NickName`

FROM
`BlogComments`
INNER JOIN `Profiles` ON `Profiles`.`ID` = `BlogComments`.`senderID`
WHERE
`blogID` = '1'
ORDER BY `replyTo`, `date` DESC
'

Hello

General untested comment follows:

Column IP in field list is ambiguous because probably the IP fields exists in more than one table which is queried in ther statement. You should put the name of the table first and then your field name. For example:

BlogComments.IP

Smoge