forum.webdiplomacy.net

webDip dev coordination forum / public access todo list
It is currently Sat Aug 19, 2017 4:42 pm

All times are UTC




Post new topic Reply to topic  [ 3 posts ] 
Author Message
PostPosted: Fri Jan 27, 2012 10:55 am 
Offline

Joined: Tue Nov 15, 2011 2:54 pm
Posts: 44
I made my own webdip on the local server a few months ago. First everything works fine. A few days ago I upgraded my mac to mac os x lion. Maybe there is a connection because now I loaded webdip again. When I tried to log in, I get the error message:

Quote:
Error triggered: Column 'ip' cannot be null.

This was probably caused by a software bug. The details of this error have been successfully logged and will be attended to by a developer.


There has to be a problem know with logged-in users because I can't load any site of my webdip but can't log out, too. I tried the same with another browser and everything works fine until I try to log in.
I searched in this forum and find one post about this, but this doesn't help me. It was said that this is connected with the sessions-table and I found a column named ip there. There is only one row and everything is set 'null'.

Do you have any suggestions what to do?
Where do I find the error log?
(How) Do I have to change the data in the table?


Top
 Profile  
 
PostPosted: Fri Jan 27, 2012 1:12 pm 
Offline
Site Admin

Joined: Sat Jun 28, 2008 6:24 am
Posts: 892
Ah, this is to do with ipv6 being unsupported. We have to log huge numbers of addresses at webdiplomacy.net, and the space taken up is massive, so we log them as 32-bit numbers (which is what IPv4 addresses are)

IPv6 addresses are 128-bit, so they don't fit in the same column. For now run this in your database:
Code:
ALTER TABLE `wD_Sessions` CHANGE `ip` `ip` INT( 10 ) UNSIGNED NULL;
ALTER TABLE `wD_AccessLog` CHANGE `ip` `ip` INT( 10 ) UNSIGNED NULL ;

The addresses won't be logged, but it shouldn't crash. In a future release we'll make it work with IPv6


Top
 Profile  
 
PostPosted: Fri Jan 27, 2012 6:25 pm 
Offline

Joined: Tue Nov 15, 2011 2:54 pm
Posts: 44
It works. :D

Thank you.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group