Strange Database Error

[matritte]

Hey all, when I run routine maintenance I am getting this error: "Undefined type used in the database query. (inet:poster_ip)"
Routine maintenance doesn't fix the errors. They keep reappearing over and over no matter how many times I run it.

Do you have any idea why this would happen? It started after I updated my PHP files on the hosts' server.

Thanks!

[live627]

Can you please post the backtrace?

[matritte]

Can you please post the backtrace?

How do I do that?

Sorry if it's a stupid question.

[Oldiesmann]

Click on "Backtrace information" in the error log entry (to the right of the URL)

[GL700Wing]

Related to this maybe?

[matritte]

Click on "Backtrace information" in the error log entry (to the right of the URL)

For some reason I don't see that option. But I did find this in the error log:

https://(site).com/index.php?action=admin;area=repairboards;fixErrors;a871b60=10cc087e2195cd781dba77aa02bc97e7
Apply Filter: Only show the errors with the same message
Undefined type used in the database query. (inet:poster_ip)
Function: {closure}
Apply Filter: Only show the errors from this file
File: /home2/(site)/public_html/(site).com/Sources/RepairBoards.php
Line: 407

Does this mean the error is with file repairboards.php?

[shawnb61]

When you say you updated the php files on the host's server... 

What exactly did you do?

[matritte]

When you say you updated the php files on the host's server... 

What exactly did you do?

I downloaded the SM latest files, unpacked the files, and then copy/pasted them onto the server.

[Illori]

which version of SMF are you running?

[shawnb61]

^^^  What version were you moving from? 

What version were you trying to move to?

Did you run the upgrader?

[matritte]

^^^  What version were you moving from? 

What version were you trying to move to?

Did you run the upgrader?

Thanks for the help so far.

It was 2.0.17 to 2.0.18.

I just copied and pasted the files. Is this the problem?
Can you link me to the upgrader if that's the way to properly install the files?

[Kindred]

Typically one would use thenpackage manager patch to go from one version to the next...    doing it like you did, by replacing all files will remove all mods....

The error you note is related to ipv6 ip addresses.

[matritte]

Typically one would use thenpackage manager patch to go from one version to the next...    doing it like you did, by replacing all files will remove all mods....

The error you note is related to ipv6 ip addresses.

Thanks. Do you know how to fix the IPV6 issue?

I don't use any mods, so that part isn't an issue. But I wonder if an old mod's code is lingering and causing this problem? How would I manually delete mods on my server?

Thanks!

[matritte]

Does anyone think they can fix this for me? I'm willing to pay a few bucks. PM me what you'd charge to go into the database and resolve the issues.
Thank you.

[Illori]

SMF 2.0 does not officially support ipv6. there is a mod you can install but i dont know if it is up to date and if it still works.

[Steve]

If you want to try the mod Illori mentioned, it's this one:

https://custom.simplemachines.org/mods/index.php?mod=3051

[matritte]

Thanks, guys. I'm afraid to install that as it might break my forum.

I think I would like to hire someone to look into the issue and fix it. Is there a forum section to do that?

[Steve]

Yep.

Help Wanted (not for support)

[m4z]

I downloaded the SM latest files, unpacked the files, and then copy/pasted them onto the server.

What exactly do you mean by this? FTP/SSH? Or does your hosting provider offer some kind of web-based "file editor"?

[matritte]

I downloaded the SM latest files, unpacked the files, and then copy/pasted them onto the server.

What exactly do you mean by this? FTP/SSH? Or does your hosting provider offer some kind of web-based "file editor"?

The forum files are all in a folder. So I just deleted the old ones that were in there except for one (I think settings.php I left on someone's recommendation), and then pasted the new ones.

[m4z]

Ok, so you are not pasting file contents; you're talking about some kind of graphical/web-based (Windows-Explorer-like) file transfer client, where you ctrl-v'ed the files into?

[matritte]

Ok, so you are not pasting file contents; you're talking about some kind of graphical/web-based (Windows-Explorer-like) file transfer client, where you ctrl-v'ed the files into?

Yes, exactly.

You can upload them to the server via FTP, or you can just copy and paste the files. Someone told me not to paste one of the files (I think it was settings.php), so I'm wondering if there is something in that file causing this issue.

[m4z]

You can upload them to the server via FTP, or you can just copy and paste the files.

Thanks for clarifying; I'd just call that "copying" because "pasting" always has a ring of "text in a file" to me.

Someone told me not to paste one of the files (I think it was settings.php), so I'm wondering if there is something in that file causing this issue.

The main reason is that this is part of your forum config, and the one from the archive is a generic one, without your forum's settings. (The settings file stores your database connection details, for example.)
It might still be that your problem might be related to config problems, but currently it sounds more like a code bug.

Edit: If I understand correctly, this was confirmed as a bug in our internal bug tracker, so a fix will probably be in the next release.