Can't login to forum

joemad · March 2009

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!

joemad · March 2009

Is there anyone out there that can help me?

Dinoboff · March 2009

Can you use phpMyAdmin?

Dinoboff · March 2009

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 '')

joemad · April 2009

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.

Dinoboff · April 2009

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 ;

[...]

joemad · April 2009

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 ;

joemad · April 2009

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;

sirlancelot · 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;

joemad · 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!