News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

WAMP migration problem (inet_aton)

Started by Lord991, October 22, 2017, 01:21:26 PM

Previous topic - Next topic

Lord991

Hello guys, I have problem with my forum backup smf 2.0.14 on wamp. The forum shows up for a few seconds and then there is database error.

Database Error: Incorrect string value: '''' for function inet_aton
File: C:/wamp64/www/forum/Sources/Subs.php
Line: 2749


$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'],
'url' => $serialized,
'session' => $session_id,
)
);


After I do change from this topic I can access forum for few seconds and then again error showes up and locks the forum.

WAMP versions: PHP=5.6.25 ; mySQL= 5.7.14
Live forum host: PHP=5.6.30 ; mySQL= 5.5.53

Maybe its because localhost as my IP, I really don't know how to fix it, and I need backup version of my forum on my PC.
Btw on my live forum, there is no errors at all and everything works fine.

Thank you guys. :(




albertlast

Look like the different mysql version are the key to your problem,
in mysql 5.7 the default sql_mode did change.

Recommended for all mysql version is to use sql_mode ="",
for smf 2.0.x

Illori

Quote from: Illori on December 15, 2016, 07:53:32 AM
Quote from: Antes on December 07, 2016, 12:02:37 PM
it is related to IPv6 setup inside the WAMP itself. open your httpd.conf then find this and comment out;
Listen [::0]:80

Lord991


Advertisement: