Options

Can't login to forum

joemadjoemad New
edited April 2009 in Vanilla 1.0 Help
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!

Comments

  • Is there anyone out there that can help me?
  • Can you use phpMyAdmin?
  • Here is the schema of vanilla: http://lussumo-vanilla.googlecode.com/svn/trunk/src/setup/mysql.sql

    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 '')
  • I can use phpmyadmin. I tried to enter the various tables by entering SQL code as I was advised by sirlancealot...

    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.
  • In phpMyAdmin, go to export (or back-up). Untick the data option and only export the structure. Post it here. eg:
    -- 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 ; [...]
  • Thanks!

    -- 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 ;
  • Continued...
    -- -------------------------------------------------------- -- -- 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;
  • edited April 2009
    Your 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;
  • joemadjoemad New
    edited April 2009
    Thanks you sirlancealot! My knight in vanilla armor! Your code to delete the 'LUM_IpHistory' table was correct. Your rebuild code gave me an error. I grabbed the code from the .sql file...
    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!
Sign In or Register to comment.