Database Error "Incorrect string value for function inet_aton" on Subs.php

[Short_Teeth]

I ve installed smf on my web server with no errors what so ever. But there is this error "Incorrect string value: '' for function inet_aton" on Line 2653. This DB error sometimes goes away for a few seconds but comes back again. Is there a way to handle such error and it would also be helpful to explain what is causing such an issue.

[Illori]

why are you using SMF 2.1 on a production server? it is still in beta. if you really want to use SMF 2.1 you should grab it off github where it is more updated and this issue may have been resolved already.

[Short_Teeth]

I've posted in the wrong thread sorry I'm using 2.0.11

[margarett]

It seems that a certain IP address gets empty? Can you please attach Subs.php?

[Illori]

It seems that a certain IP address gets empty? Can you please attach Subs.php?

maybe an ipv6 address as SMF 2.0 does not support it?

[Short_Teeth]

The problem was that the string was empty ... Ive managed to counter the issue by adding this piece of code... Correct me if I'm doing anything wrong....

      

Code Select Expand

$smcFunc['db_query']('', '
UPDATE {db_prefix}log_online
SET log_time = {int:log_time}, ip = IFNULL(INET_ATON({string:ip}), 0), url = {string:url}
WHERE session = {string:session}',
array(
'log_time' => time(),
'ip' =>  $user_info['ip']  = ($user_info['ip']  != '' ? $user_info['ip']  : '0'),
'url' => $serialized,
'session' => $session_id,
)
);