Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
Can't login to forum
joemad
New
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!