• Welcome to Simple Machines Community Forum. Please login or sign up.
December 02, 2021, 06:29:13 PM

News:

Check out the SMF Function DB!


IPv6 support

Started by SleePy, June 29, 2011, 03:25:36 PM

Previous topic - Next topic

OSSGeek

I installed the mod on SMF 2.0.8 without any issues but get this error in logs:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BETWEEN bi.ip_low2 AND bi.ip_high2)
AND ( BETWEEN bi.ip_low3 AND bi.ip_hi' at line 7
File:  Security.php
Line: 343


MySQL version: 5.1.37

Any ideas?

Mr. Jinx

This mod is broken. Tried to fix some things (check http://www.simplemachines.org/community/index.php?topic=440357.msg3750120#msg3750120) , but there is too much to be done.

OSSGeek

How can I uninstall it? I have Backup of my "Sources" folder. I need to rollback the DB changes to what was before installing this MOD...

musicus

can not install that mod, if I install, this Error comes

Quote
Package upload failed due to the following error:
"Although the package was downloaded to the server it appears to be empty. Please check the Packages directory, and the "temp" sub-directory are both writable. If you continue to experience this problem you should try extracting the package on your PC and uploading the extracted files into a subdirectory in your Packages directory and try again. For example, if the package was called shout.tar.gz you should:
1) Download the package to your local PC and extract it into files.
2) Using an FTP client create a new directory in your "Packages" folder, in this example you may call it "shout".
3) Upload all the files from the extracted package to this directory.
4) Go back to the package manager browse page and the package will be automatically found by SMF."


When I decompress this in packages, nothing happens :(

in the package I found only this file, see attachment

Deprecated

I just love Arantor's comment about "by the end of the year." Noting he didn't say which year! LOL!

Like it or not we are going to be dragged into the IPV6 world kicking and screaming. It would behoove the SMF developers to consider this in the SMF 2.1 design.

I am getting more and more IPV6 traffic and it just fails, fails, fails on 2.0.11. I can't even view IP addresses of posts as admin. It blew me away when I discovered one of my members is using an IPV6 address, and his IPV4 address (like in the smf_messages table) just shows up as blank, empty.

I thought I had my forum config messed up until I traced it to the real source of the problem IPV6.

Deprecated

Does anybody know about the status of making SMF 2.1 fully IPV6 capable?

This problem is getting steadily worse, with some features in SMF not working because of the IPV6 addresses.

And yet worse, 2.1 is not likely to be released before the end of the year. Note I didn't say which year! :D

SleePy

It is being worked on.  This mod was built in mind to keep existing ipv4 setup in SMF working properly and the ability to uninstall it and still have things working, so I didn't expand things too much.  2.1 is/has expanded it and working on making it working fully.  You can check out SMF 2.1's development progress if you want to know more: https://github.com/simplemachines/SMF2.1
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

live627

QuoteDoes anybody know about the status of making SMF 2.1 fully IPV6 capable?
Our goal is to support it fully.

Deprecated

That's good to know. I don't want to follow the progress because it begs the question, "When will 2.1 stable be ready?" And I been around long enough you don't ask that question. Not without annoying developers, who are better left to develop code than swat away the pesky questions like this one.

Anyway I know the answer. It will be done when it will be done and not a minute sooner. And we'll receive announcements when it's done anyway. I don't have anything to offer the developers except to leave them alone, and I'm doing my best I can.

I think I'll pass on the mod at the present time because the caveats are more than I'm willing to accept. I'm currently building a production forum I expect to grow big, and I want to keep the code base clean and stable.

BTW I have run a few non-production 2.1 forums (2- or 3-man forums to coordinate jobs, etc.) and 2.1 looks really fine! I'll adopt it as soon as there's a production rated release, and I have upgraded my mods for the new forum if any upgrades are required.

At least we know one thing: one day it will be released. All we can do is patiently wait for that day.

Superion

Hi.
I'm trying to use your mod in order to fix an error I'm getting, probably due to IPv6. I modified the files listed according to the instructions, however, database_install.php gives me a HTML 500 error. In the error log:
PHP Fatal error:  Uncaught Error: Function name must be a string in [path]/database_install.php:40\nStack trace:\n#0 {main}\n  thrown in [path]/database_install.php on line 40
Any idea what's wrong?
Also, isn't there a ?> missing from the file's end?

Superion

Seeing how I can't modify my previous post anymore, pardon me for the second post in a row. I am silly and just noticed that the aforementioned error has a "partner" before it. So the full error message reads

PHP Notice:  Undefined index: db_list_columns in [path]/database_install.php on line 40
PHP Fatal error:  Uncaught Error: Function name must be a string in [path]/database_install.php:40\nStack trace:\n#0 {main}\n  thrown in [path]/database_install.php on line 40


(Provided that a moderator comes by, would it be possible to merge this post with my previous? Thoinks in advance!)

SleePy

This modification requires SMF 2.0.  It doesn't support 1.1
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

Superion


SleePy

It should work then.  You can extract the database_install.php upload this to the root of your SMF installation and run that manually.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

Superion

I extracted it, uploaded it, and every time I try to run it the browser gives "HTTP ERROR 500", and the error.log has the aforementioned entries in it. One per reload.

These:
PHP Notice:  Undefined index: db_list_columns in [path]/database_install.php on line 40
PHP Fatal error:  Uncaught Error: Function name must be a string in [path]/database_install.php:40\nStack trace:\n#0 {main}\n  thrown in [path]/database_install.php on line 40

SleePy

Open database_install.php and find:

// Fields to add


Add before:

db_extend('packages');


See if that fixes this.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

Superion

Now it ran seemingly properly, giving me
If no errors, Success!
afterwards. However, looking in the error.log I found these:
[Wed Dec 21 03:07:10.718680 2016] (..) PHP Warning:  Missing argument 3 for smf_db_change_column(), called in [path]/database_install.php on line 50 and defined in [path]/Sources/DbPackages-mysql.php on line 285
[Wed Dec 21 03:07:10.719168 2016] (..) PHP Warning:  Missing argument 3 for smf_db_change_column(), called in [path]/database_install.php on line 50 and defined in [path]/Sources/DbPackages-mysql.php on line 285
[Wed Dec 21 03:07:10.719516 2016] (..) PHP Warning:  Missing argument 3 for smf_db_change_column(), called in [path]/database_install.php on line 50 and defined in [path]/Sources/DbPackages-mysql.php on line 285
[Wed Dec 21 03:07:10.719849 2016] (..) PHP Warning:  Missing argument 3 for smf_db_change_column(), called in [path]/database_install.php on line 50 and defined in [path]/Sources/DbPackages-mysql.php on line 285
[Wed Dec 21 03:07:10.720175 2016] (..) PHP Warning:  Missing argument 3 for smf_db_change_column(), called in [path]/database_install.php on line 50 and defined in [path]/Sources/DbPackages-mysql.php on line 285
[Wed Dec 21 03:07:10.720498 2016] (..) PHP Warning:  Missing argument 3 for smf_db_change_column(), called in [path]/database_install.php on line 50 and defined in [path]/Sources/DbPackages-mysql.php on line 285
[Wed Dec 21 03:07:10.720818 2016] (..) PHP Warning:  Missing argument 3 for smf_db_change_column(), called in [path]/database_install.php on line 50 and defined in [path]/Sources/DbPackages-mysql.php on line 285
[Wed Dec 21 03:07:10.721146 2016] (..) PHP Warning:  Missing argument 3 for smf_db_change_column(), called in [path]/database_install.php on line 50 and defined in [path]/Sources/DbPackages-mysql.php on line 285
[Wed Dec 21 03:07:10.721557 2016] (..) PHP Notice:  Undefined variable: request in [path]/database_install.php on line 65
[Wed Dec 21 03:07:10.721581 2016] (..) PHP Warning:  mysql_fetch_assoc() expects parameter 1 to be resource, null given in [path]/database_install.php on line 65

landyvlad

I'm confused. Mod is in a .gz format rather than zip.
Package manager (SMF2.0.13) states that .gz is not supported ?!

Is there an automated way to install?
Please do not PM, IM or Email me with questions on astrophysics or theology.  You will get better and faster responses by asking homeless people in the street. Thank you.

To paraphrase Kindred: "There are no technical solutions to social problems."

Kindred

rename the extension to .tar.gz

it then works just fine
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.<br /><br />"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

SugarD-x

Quote from: Kindred on February 01, 2017, 09:34:59 AM
rename the extension to .tar.gz

it then works just fine

Sorry for the bump, but this user brings up a good point. This needs to be fixed on the SMF downloads section too. The file downloads corrupted otherwise. Many unknowing users are going to get confused by this.

Advertisement: