XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Modules Support forums / 
  3. Module troubleshooting 
  4.  / Soapbox:Fatal error: Using $this when not in object context in...
Register
21
wcrwcr
Re: Soapbox:Fatal error: Using $this when not in object context in...

  • 2009/11/25 13:58

  • wcrwcr

  • Home away from home

  • Posts: 1114

  • Since: 2003/12/12


I don´t reinstall yet but, just in case here follows the sql of the last version.

If i´m not wrong the "PRIMARY, columnID" is present:

le="color: #000000"><?php # phpMyAdmin SQL Dump # version 2.5.3 # http://www.phpmyadmin.net # # Host: localhost # Generation Time: Dec 12, 2003 at 06:03 AM # Server version: 3.23.56 # PHP Version: 4.3.3 # # Database : `xoops` # # -------------------------------------------------------- # # Table structure for table `sbcolumns` # CREATE TABLE `sbcolumns` ( `columnID` tinyint(4) NOT NULL auto_increment, `author` int(8) NOT NULL, `name` varchar(255) NOT NULL default '', `description` text NOT NULL, `total` int(11) NOT NULL default '0', `weight` int(11) NOT NULL default '1', `colimage` varchar(255) NOT NULL default 'blank.png', `created` int(11) NOT NULL default '1033141070', PRIMARY KEY (`columnID`), UNIQUE KEY columnID (`columnID`) ) TYPE=MyISAM COMMENT='Soapbox by hsalazar and domifara'; # # Dumping data for table `sbcolumns` # # -------------------------------------------------------- # # Table structure for table `sbarticles` # CREATE TABLE `sbarticles` ( `articleID` int(8) NOT NULL auto_increment, `columnID` tinyint(4) NOT NULL default '0', `headline` varchar(255) NOT NULL default '0', `lead` text NOT NULL, `bodytext` text NOT NULL, `teaser` text NOT NULL, `uid` int(6) default '1', `submit` int(1) NOT NULL default '0', `datesub` int(11) NOT NULL default '1033141070', `counter` int(8) unsigned NOT NULL default '0', `weight` int(11) NOT NULL default '1', `html` int(11) NOT NULL default '0', `smiley` int(11) NOT NULL default '0', `xcodes` int(11) NOT NULL default '0', `breaks` int(11) NOT NULL default '1', `block` int(11) NOT NULL default '0', `artimage` varchar(255) NOT NULL default '', `votes` int(11) NOT NULL default '0', `rating` double(6,4) NOT NULL default '0.0000', `commentable` int(11) NOT NULL default '0', `offline` int(11) NOT NULL default '0', `notifypub` int(11) NOT NULL default '0', PRIMARY KEY (`articleID`), UNIQUE KEY articleID (`articleID`), FULLTEXT KEY bodytext (`bodytext`) ) TYPE=MyISAM COMMENT='Soapbox by hsalazar and domifara'; # # Dumping data for table `sbarticles` # # -------------------------------------------------------- # # Table structure for table `sbvotedata` # CREATE TABLE `sbvotedata` ( `ratingid` int(11) unsigned NOT NULL auto_increment, `lid` int(11) unsigned NOT NULL default '0', `ratinguser` int(11) NOT NULL default '0', `rating` tinyint(3) unsigned NOT NULL default '0', `ratinghostname` varchar(60) NOT NULL default '', `ratingtimestamp` int(10) NOT NULL default '0', PRIMARY KEY (`ratingid`), KEY ratinguser (`ratinguser`), KEY ratinghostname (`ratinghostname`), KEY lid (`lid`) ) TYPE=MyISAM; # # Dumping data for table `sbvotedata` #

22
ghia
Re: Soapbox:Fatal error: Using $this when not in object context in...

  • 2009/11/25 14:14

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


It seems to be a bug. There is no point in specifying the same field twice as key. Remove
le="color: #000000"><?php , UNIQUE KEY columnID (`columnID`)
in the SQL file and the same goes for the next table.
« 1 2 (3)

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Donat-O-Meter

Stats
Goal: $15.00
Due Date: Jul 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $15.00
Make donations with PayPal!

Latest GitHub Commits