Options
Can't login to forum

I'm getting this error...
'A fatal, non-recoverable error has occurred
Technical information (for support personel):
Error Message
An error occurred while logging your IP address.
Affected Elements
UserManager.AddUserIP();
The error occurred on or near: Unknown column 'RemoteIp' in 'field list'
For additional support documentation, visit the Lussumo Documentation website at: lussumo.com/docs"
I did delete a couple of tables by accident and I was told how to rebuild one. How would I rebuild this 'RemoteIp' table?
http://lussumo.com/community/discussion/9353/rebuilding-vanilla-database-tables/#Item_3
http://lussumo.com/community/discussion/9340/please-help-me-with-my-fatal-error/#Item_5
Thanks!
0
Comments
Using phpMyAdmin add the column that you removed. There are the RemoteIp fields in...
- LUM_user (`RemoteIp` varchar(100) NOT NULL default ''),
- LUM_UserRoleHistory (`RemoteIp` varchar(100) default NULL,),
- LUM_Comment (`RemoteIp` varchar(100) default '',) and,
- LUM_IpHistory (`RemoteIp` varchar(30) NOT NULL default '')
CREATE TABLE IF NONE EXISTS `LUM_IpHistory` ( `IpHistoryID` int(11) NOT NULL auto_increment, `RemoteIp` varchar(30) NOT NULL default '', `UserID` int(11) NOT NULL default '0', `DateLogged` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`IpHistoryID`) ) DEFAULT CHARACTER SET utf8;
I entered the same code for 'LUM_user', 'LUM_UserRoleHistory', 'LUM_Comment', and 'LUM_IpHistory' but I still can not log in and get the same error.
-- phpMyAdmin SQL Dump -- version 2.11.9.2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Apr 01, 2009 at 09:23 PM -- Server version: 5.0.67 -- PHP Version: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `vanilla_dev` -- -- -------------------------------------------------------- -- -- Table structure for table `lum_category` -- CREATE TABLE IF NOT EXISTS `lum_category` ( `CategoryID` int(2) NOT NULL auto_increment, `Name` varchar(100) NOT NULL default '', `Description` text, `Priority` int(11) NOT NULL default '0', PRIMARY KEY (`CategoryID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; [...]
-- phpMyAdmin SQL Dump -- version 2.6.4-pl3 -- http://www.phpmyadmin.net -- -- Host: db520.perfora.net -- Generation Time: Apr 10, 2009 at 01:52 PM -- Server version: 4.0.27 -- PHP Version: 4.3.10-200.schlund.1 -- -- Database: `db197856405` -- CREATE DATABASE `db197856405`; USE db197856405; -- -------------------------------------------------------- -- -- Table structure for table `LUM_Attachment` -- CREATE TABLE `LUM_Attachment` ( `AttachmentID` int(11) NOT NULL auto_increment, `UserID` int(11) NOT NULL default '0', `DiscussionID` int(11) NOT NULL default '0', `CommentID` int(11) NOT NULL default '0', `Title` varchar(200) NOT NULL default '', `Description` text NOT NULL, `Name` varchar(200) NOT NULL default '', `Path` text NOT NULL, `Size` int(11) NOT NULL default '0', `MimeType` varchar(200) NOT NULL default '', `DateCreated` datetime NOT NULL default '0000-00-00 00:00:00', `DateModified` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`AttachmentID`) ) TYPE=MyISAM AUTO_INCREMENT=6 ; -- -------------------------------------------------------- -- -- Table structure for table `LUM_Category` -- CREATE TABLE `LUM_Category` ( `CategoryID` int(2) NOT NULL auto_increment, `Name` varchar(100) NOT NULL default '', `Description` text, `Priority` int(11) NOT NULL default '0', `Subscribeable` int(1) NOT NULL default '0', PRIMARY KEY (`CategoryID`) ) TYPE=MyISAM AUTO_INCREMENT=14 ; -- -------------------------------------------------------- -- -- Table structure for table `LUM_CategoryBlock` -- CREATE TABLE `LUM_CategoryBlock` ( `CategoryID` int(11) NOT NULL default '0', `UserID` int(11) NOT NULL default '0', `Blocked` enum('1','0') NOT NULL default '1', PRIMARY KEY (`CategoryID`,`UserID`), KEY `cat_block_user` (`UserID`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `LUM_CategoryRoleBlock` -- CREATE TABLE `LUM_CategoryRoleBlock` ( `CategoryID` int(11) NOT NULL default '0', `RoleID` int(11) NOT NULL default '0', `Blocked` enum('1','0') NOT NULL default '0', KEY `cat_roleblock_cat` (`CategoryID`), KEY `cat_roleblock_role` (`RoleID`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `LUM_Comment` -- CREATE TABLE `LUM_Comment` ( `CommentID` int(8) NOT NULL auto_increment, `DiscussionID` int(8) NOT NULL default '0', `AuthUserID` int(10) NOT NULL default '0', `DateCreated` datetime default NULL, `EditUserID` int(10) default NULL, `DateEdited` datetime default NULL, `WhisperUserID` int(11) default NULL, `Body` text, `FormatType` varchar(20) default NULL, `Deleted` enum('1','0') NOT NULL default '0', `DateDeleted` datetime default NULL, `DeleteUserID` int(10) NOT NULL default '0', `RemoteIp` varchar(100) default '', PRIMARY KEY (`CommentID`,`DiscussionID`), KEY `comment_user` (`AuthUserID`), KEY `comment_whisper` (`WhisperUserID`), KEY `comment_discussion` (`DiscussionID`) ) TYPE=MyISAM AUTO_INCREMENT=865 ; -- -------------------------------------------------------- -- -- Table structure for table `LUM_Discussion` -- CREATE TABLE `LUM_Discussion` ( `DiscussionID` int(8) NOT NULL auto_increment, `AuthUserID` int(10) NOT NULL default '0', `WhisperUserID` int(11) NOT NULL default '0', `FirstCommentID` int(11) NOT NULL default '0', `LastUserID` int(11) NOT NULL default '0', `Active` enum('1','0') NOT NULL default '1', `Closed` enum('1','0') NOT NULL default '0', `Sticky` enum('1','0') NOT NULL default '0', `Sink` enum('1','0') NOT NULL default '0', `Name` varchar(100) NOT NULL default '', `DateCreated` datetime NOT NULL default '0000-00-00 00:00:00', `DateLastActive` datetime NOT NULL default '0000-00-00 00:00:00', `CountComments` int(4) NOT NULL default '1', `CategoryID` int(11) default NULL, `WhisperToLastUserID` int(11) default NULL, `WhisperFromLastUserID` int(11) default NULL, `DateLastWhisper` datetime default NULL, `TotalWhisperCount` int(11) NOT NULL default '0', PRIMARY KEY (`DiscussionID`), KEY `discussion_user` (`AuthUserID`), KEY `discussion_whisperuser` (`WhisperUserID`), KEY `discussion_first` (`FirstCommentID`), KEY `discussion_last` (`LastUserID`), KEY `discussion_category` (`CategoryID`), KEY `discussion_dateactive` (`DateLastActive`) ) TYPE=MyISAM AUTO_INCREMENT=241 ;
-- -------------------------------------------------------- -- -- Table structure for table `LUM_DiscussionUserWhisperFrom` -- CREATE TABLE `LUM_DiscussionUserWhisperFrom` ( `DiscussionID` int(11) NOT NULL default '0', `WhisperFromUserID` int(11) NOT NULL default '0', `LastUserID` int(11) NOT NULL default '0', `CountWhispers` int(11) NOT NULL default '0', `DateLastActive` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`DiscussionID`,`WhisperFromUserID`), KEY `discussion_user_whisper_lastuser` (`LastUserID`), KEY `discussion_user_whisper_lastactive` (`DateLastActive`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `LUM_DiscussionUserWhisperTo` -- CREATE TABLE `LUM_DiscussionUserWhisperTo` ( `DiscussionID` int(11) NOT NULL default '0', `WhisperToUserID` int(11) NOT NULL default '0', `LastUserID` int(11) NOT NULL default '0', `CountWhispers` int(11) NOT NULL default '0', `DateLastActive` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`DiscussionID`,`WhisperToUserID`), KEY `discussion_user_whisperto_lastuser` (`LastUserID`), KEY `discussion_user_whisperto_lastactive` (`DateLastActive`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `LUM_IpHistory` -- CREATE TABLE `LUM_IpHistory` ( `UserID` int(11) NOT NULL default '0', `DateLogged` datetime NOT NULL default '0000-00-00 00:00:00' ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `LUM_Notify` -- CREATE TABLE `LUM_Notify` ( `NotifyID` int(11) NOT NULL auto_increment, `UserID` int(11) NOT NULL default '0', `Method` varchar(10) NOT NULL default '', `SelectID` int(11) NOT NULL default '0', PRIMARY KEY (`NotifyID`) ) TYPE=MyISAM AUTO_INCREMENT=110 ; -- -------------------------------------------------------- -- -- Table structure for table `LUM_Poll` -- CREATE TABLE `LUM_Poll` ( `PollID` int(11) NOT NULL auto_increment, `DiscussionID` int(11) NOT NULL default '0', `UserID` int(11) NOT NULL default '0', `Name` varchar(200) NOT NULL default '', `DateCreated` datetime NOT NULL default '0000-00-00 00:00:00', `DateStart` datetime NOT NULL default '0000-00-00 00:00:00', `DateEnd` datetime NOT NULL default '0000-00-00 00:00:00', `TotalVotes` int(11) NOT NULL default '0', `Priority` int(11) NOT NULL default '0', PRIMARY KEY (`PollID`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `LUM_PollBlock` -- CREATE TABLE `LUM_PollBlock` ( `PollID` int(11) NOT NULL default '0', `UserID` int(11) NOT NULL default '0', `Blocked` enum('1','0') NOT NULL default '1', `RemoteIP` varchar(30) NOT NULL default '', `DateCreated` datetime NOT NULL default '0000-00-00 00:00:00', KEY `PollID` (`PollID`,`UserID`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `LUM_PollData` -- CREATE TABLE `LUM_PollData` ( `PollDataID` int(11) NOT NULL auto_increment, `PollID` int(11) NOT NULL default '0', `Name` varchar(200) NOT NULL default '', `Votes` int(11) NOT NULL default '0', PRIMARY KEY (`PollDataID`), KEY `PollID` (`PollID`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `LUM_PollRoleBlock` -- CREATE TABLE `LUM_PollRoleBlock` ( `PollID` int(11) NOT NULL default '0', `RoleID` int(11) NOT NULL default '0', `Blocked` enum('1','0') NOT NULL default '1', KEY `PollID` (`PollID`), KEY `RollID` (`RoleID`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `LUM_Role` -- CREATE TABLE `LUM_Role` ( `RoleID` int(2) NOT NULL auto_increment, `Name` varchar(100) NOT NULL default '', `Icon` varchar(155) NOT NULL default '', `Description` varchar(200) NOT NULL default '', `Active` enum('1','0') NOT NULL default '1', `PERMISSION_SIGN_IN` enum('1','0') NOT NULL default '0', `PERMISSION_HTML_ALLOWED` enum('0','1') NOT NULL default '0', `PERMISSION_RECEIVE_APPLICATION_NOTIFICATION` enum('1','0') NOT NULL default '0', `Permissions` text, `Priority` int(11) NOT NULL default '0', `UnAuthenticated` enum('1','0') NOT NULL default '0', PRIMARY KEY (`RoleID`) ) TYPE=MyISAM AUTO_INCREMENT=6 ; -- -------------------------------------------------------- -- -- Table structure for table `LUM_ShortStat` -- CREATE TABLE `LUM_ShortStat` ( `ShortStatID` int(11) NOT NULL auto_increment, `RemoteIP` varchar(15) NOT NULL default '', `Country` varchar(50) NOT NULL default '', `Language` varchar(5) NOT NULL default '', `Domain` varchar(255) NOT NULL default '', `Referer` varchar(255) NOT NULL default '', `Resource` varchar(255) NOT NULL default '', `UserAgent` varchar(255) NOT NULL default '', `Platform` varchar(50) NOT NULL default '', `Browser` varchar(50) NOT NULL default '', `Version` varchar(15) NOT NULL default '', `DateCreated` int(10) NOT NULL default '0', PRIMARY KEY (`ShortStatID`) ) TYPE=MyISAM AUTO_INCREMENT=351426 ; -- -------------------------------------------------------- -- -- Table structure for table `LUM_ShortStatSearch` -- CREATE TABLE `LUM_ShortStatSearch` ( `ShortStatID` int(11) NOT NULL auto_increment, `SearchTerms` varchar(255) NOT NULL default '', `SearchCount` int(10) NOT NULL default '0', PRIMARY KEY (`ShortStatID`) ) TYPE=MyISAM AUTO_INCREMENT=2769 ; -- -------------------------------------------------------- -- -- Table structure for table `LUM_Style` -- CREATE TABLE `LUM_Style` ( `StyleID` int(3) NOT NULL auto_increment, `AuthUserID` int(11) NOT NULL default '0', `Name` varchar(50) NOT NULL default '', `Url` varchar(255) NOT NULL default '', `PreviewImage` varchar(20) NOT NULL default '', PRIMARY KEY (`StyleID`) ) TYPE=MyISAM AUTO_INCREMENT=5 ; -- -------------------------------------------------------- -- -- Table structure for table `LUM_ThankfulPeople` -- CREATE TABLE `LUM_ThankfulPeople` ( `CommentID` int(11) NOT NULL default '0', `UserID` int(11) NOT NULL default '0', KEY `ThankfulPeople_Key` (`CommentID`,`UserID`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `LUM_User` -- CREATE TABLE `LUM_User` ( `UserID` int(10) NOT NULL auto_increment, `RoleID` int(2) NOT NULL default '0', `StyleID` int(3) NOT NULL default '1', `CustomStyle` varchar(255) default NULL, `FirstName` varchar(50) NOT NULL default '', `LastName` varchar(50) NOT NULL default '', `Name` varchar(20) NOT NULL default '', `Password` varchar(34) binary default NULL, `VerificationKey` varchar(50) NOT NULL default '', `EmailVerificationKey` varchar(50) default NULL, `Email` varchar(200) NOT NULL default '', `UtilizeEmail` enum('1','0') NOT NULL default '0', `ShowName` enum('1','0') NOT NULL default '1', `Icon` varchar(255) default NULL, `Picture` varchar(255) default NULL, `Attributes` text, `CountVisit` int(8) NOT NULL default '0', `CountDiscussions` int(8) NOT NULL default '0', `CountComments` int(8) NOT NULL default '0', `DateFirstVisit` datetime NOT NULL default '0000-00-00 00:00:00', `DateLastActive` datetime NOT NULL default '0000-00-00 00:00:00', `RemoteIp` varchar(100) NOT NULL default '', `LastDiscussionPost` datetime default NULL, `DiscussionSpamCheck` int(11) NOT NULL default '0', `LastCommentPost` datetime default NULL, `CommentSpamCheck` int(11) NOT NULL default '0', `UserBlocksCategories` enum('1','0') NOT NULL default '0', `DefaultFormatType` varchar(20) default NULL, `Discovery` text, `Preferences` text, `SendNewApplicantNotifications` enum('1','0') NOT NULL default '0', `latitude` float NOT NULL default '0', `longitude` float NOT NULL default '0', `SubscribeOwn` tinyint(1) NOT NULL default '0', `Notified` tinyint(1) NOT NULL default '0', PRIMARY KEY (`UserID`), KEY `user_role` (`RoleID`), KEY `user_style` (`StyleID`), KEY `user_name` (`Name`) ) TYPE=MyISAM AUTO_INCREMENT=184 ; -- -------------------------------------------------------- -- -- Table structure for table `LUM_UserBookmark` -- CREATE TABLE `LUM_UserBookmark` ( `UserID` int(10) NOT NULL default '0', `DiscussionID` int(8) NOT NULL default '0', PRIMARY KEY (`UserID`,`DiscussionID`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `LUM_UserDiscussionWatch` -- CREATE TABLE `LUM_UserDiscussionWatch` ( `UserID` int(10) NOT NULL default '0', `DiscussionID` int(8) NOT NULL default '0', `CountComments` int(11) NOT NULL default '0', `LastViewed` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`UserID`,`DiscussionID`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Table structure for table `LUM_UserRoleHistory` -- CREATE TABLE `LUM_UserRoleHistory` ( `UserID` int(10) NOT NULL default '0', `RoleID` int(2) NOT NULL default '0', `Date` datetime NOT NULL default '0000-00-00 00:00:00', `AdminUserID` int(10) NOT NULL default '0', `Notes` varchar(200) default NULL, `RemoteIp` varchar(100) default NULL, KEY `UserID` (`UserID`) ) TYPE=MyISAM;
IpHistory
table is incorrect. Delete it by running the SQL query:DROP TABLE LUM_IpHistory
and then re-add it using the SQL query found in the
.sql
file in the install folder:CREATE TABLE IF NONE EXISTS `LUM_IpHistory` ( `IpHistoryID` int(11) NOT NULL auto_increment, `RemoteIp` varchar(30) NOT NULL default '', `UserID` int(11) NOT NULL default '0', `DateLogged` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`IpHistoryID`) ) DEFAULT CHARACTER SET utf8;
CREATE TABLE `LUM_IpHistory` ( `IpHistoryID` int(11) NOT NULL auto_increment, `RemoteIp` varchar(30) NOT NULL default '', `UserID` int(11) NOT NULL default '0', `DateLogged` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`IpHistoryID`) )
I'm back into my forum after 2 weeks of being shut down. THANKS!