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!