[infurl]

Hi folks,

I've been toiling away since last week to get the new server up and running. Freddy let me have a copy of the forum software and database for testing, but since we won't switch the aidreams.co.uk domain name to the new server until we're sure it's working properly, it is at https://charidge.com for now.

If you can spare a few minutes, please go to https://charidge.com and see if it's working for you, but note the following:

1. It is a copy of the database from last week so it is missing anything that has been posted since then.
2. The new mail server isn't set up yet so you can't get any email notifications from it at the moment.
3. You will have to reset your password using your secret question and answer before you can log in there.
4. Try making some test posts but remember they will be deleted when we switch to the live database.
5. Please post here if you have any problems and I'll try to fix them.

I've still got a lot to learn about this forum software and finding and fixing problems is the fastest way to learn how to manage it.

[manases]

getting
Data too long for column 'ip' at row 1
Looks like you need to make it bigint or smth

I was just about to say the website looks really amazing - wondering why the changes... I guess there is a lot to read around.

[infurl]

getting
Data too long for column 'ip' at row 1
Looks like you need to make it bigint or smth

Thank you very much for the bug report. I got that problem once as well but I hadn't been able to reproduce it again; that's why I decided to announce the test site to see if anyone else got the same problem.

From studying the logs now I believe I know what is wrong. The server is receiving a mix of requests via both the IPv4 and IPv6 internet protocols but the database is only able to store IPv4 addresses. I expect if I modify that database field so it will accept longer strings for IPv6, the problem should go away.

[ivan.moony]

Can't reset password, says I gave a wrong answer to my secret question. Then I tried other reset password by getting a reset-password mail, but I didn't receive the mail in more than ten minutes.

[infurl]

Can't reset password, says I gave a wrong answer to my secret question. Then I tried other reset password by getting a reset-password mail, but I didn't receive the mail in more than ten minutes.

You won't be able to get any email yet because I haven't got the mail server working and your secret answer and password are encrypted so I can't get them from the database. I'll keep working on it though and I'll let you know when it is worth trying again.

I've altered the database to allow storing IPv6 addresses, so if anyone else encounters that problem, please let me know and I'll "go back to the drawing board"

[Art]

Trying the Brave, Chrome, and Firefox browsers I received the same messages:
Data too long for column 'ip' at row 1

[infurl]

Trying the Brave, Chrome, and Firefox browsers I received the same messages:
Data too long for cloumn 'ip' at row 1

I've increased the size of the IP field from the original 15 characters up to 255 characters, but looking through the code I think there might be other problems. There's only one place in the forum software where it cares about IP addresses but it does all it's processing by converting the IP address to an integer. While that works fine for a 32-bit IPv4 address, it can't be made to work for a 128-bit IPv6 address.

I'll have to either rewrite that part of the forum software to use strings, find an updated version of the module, uninstall the module and hope we can live without it, or figure out how to disable IPv6 on the new server.

Thanks for giving it a whirl Art. I'll have to pick this up again tomorrow.

[HS]

I logged in to charidge without changing my password.

[infurl]

I logged in to charidge without changing my password.

That's interesting. I wonder why some passwords work and some don't. I had to reset my password using my secret question and answer. Another question to add to the list...

[manases]

Sometimes I also do programming but server configurations or software configurations, are my absolute nightmares.

I always thought that the first thing AI should pickup should be programming.
It is all repetitive with a small set of variables (problems) and with a huge return in progress.

The problem it is how to transfer knowledge, isn't it?
In Starcraft2 - they have replays and clear wind/lose conditions.

Maybe google should launch an IDE (or make a module for an existing one) where you can set the problem and then mark the problem as solved - so developers can train the AI.
This would be so amazing...

Setting the problem as fixed is easy but how do you tell google the problem?
Maybe trough voice commands?
Google - set problem - Data too long for column 'ip' at row 1
Then you monkey-code until is fixed then you mark the problem as fixed.
Actually this also involves db changes outside the IDE.. so there should be a general observer agent...

[Korrelan]

Arrived and got the usual cookie request.
Entered current username & password... and it let me straight In, made a post.

I am running XP 32bit and Firefox ATM.

Chrome works as above too.

Win7 32 & Chrome... no problems

Win 10 & Chrome... no problems
Win 10 & Edge... no problems

Win 1, 1.1, win95, win98... Failed... Lol

 

[8pla.net]

getting
Data too long for column 'ip' at row 1

This page claims to have found a solution:
https://stackoverflow.com/questions/15949038/error-code-1406-data-too-long-for-column-mysql

May be as easy as:

Code

SET @@global.sql_mode= '';

Good Luck!

[manases]

I am not sure they want to truncate the IP
or to mask the errors in any way, that is something like
https://youtu.be/9F3iBMYvQOs?t=46
It could be a fix for the mo, when installing a large application, you can disable some features in the beginning...

[infurl]

Here's a progress report. I believe that I've fixed the "getting data too long for column 'ip' at row 1" problem that some of us (me included) have been experiencing. It was caused because the new server has interfaces to both the old IPv4 internet and the new IPv6 internet. One of the modules in the forum software was unable to handle the longer addresses from the IPv6 network and if your browser tried to connect via that path, the forum would choke. Most people automatically have interfaces to both internets nowadays (even if you don't know it) so for the time being I've disabled the IPv6 interface and I'm no longer getting the error when I try to connect. I hope nobody else is either, so please let me know if it's still not working for you.

Some of us have had to reset our passwords on the test server and I'm not sure why yet. Without a working mail server the only way to reset your password is via the secret question and answer. Now would probably be a good time to review your secret question and answer in case you don't remember what it was. We should have a working mail server soon; I've completed the setup and now I'm just waiting for the hosting service to review it and (I hope) approve it so I can finish testing. It was only slightly harder than getting a loan from a bank.

[manases]

Yep - is working now