1
Antoine
TinyEditor 1.0, Xoops 1.0.15 and MySQL 5.0
  • 2006/11/7 15:14

  • Antoine

  • Friend of XOOPS

  • Posts: 112

  • Since: 2004/11/14


Hi,

When trying to install TinyEditor 1.0 beta in XOOPS 1.0.15 I am getting the following error:

Quote:

BLOB/TEXT column 'tinyed_row1' can't have a default value


So I am guessing that the sql script installing this module isn't compatible with MySQL 5.0, huh? Can anyone think of a workaround for this? I would really like to give it a spin but cannot downgrade my database just for that purpose only.

Regards

2
McDonald
Re: TinyEditor 1.0, Xoops 1.0.15 and MySQL 5.0
  • 2006/11/7 15:47

  • McDonald

  • Home away from home

  • Posts: 1072

  • Since: 2005/8/15


Make a backup of the file /modules/tinyeditor/sql/mysql.sql and than replace it with the following sql-script:

-- phpMyAdmin SQL Dump
-- version 2.7.0-pl1
-- http://www.phpmyadmin.net
-- 
-- 
Hostlocalhost
-- Generation TimeNov 072006 at 05:04 PM
-- Server version5.0.18
-- PHP Version5.1.1
-- 
-- 
Database: `xoops2015`
-- 

-- --------------------------------------------------------

-- 
-- 
Table structure for table `xoops_tinyeditor_mimetypes`
-- 

CREATE TABLE `xoops_tinyeditor_mimetypes` (
  `
tinymt_idint(11NOT NULL auto_increment,
  `
tinymt_gidint(11NOT NULL,
  `
tinymt_typestext collate utf8_general_ci NOT NULL,
  
PRIMARY KEY  (`tinymt_id`)
ENGINE=MyISAM;

-- 
-- 
Dumping data for table `xoops_tinyeditor_mimetypes`
-- 

INSERT INTO `xoops_tinyeditor_mimetypesVALUES (11'image/jpeg , image/pjpeg , image/png , image/gif');
INSERT INTO `xoops_tinyeditor_mimetypesVALUES (22'image/jpeg , image/pjpeg , image/png , image/gif');
INSERT INTO `xoops_tinyeditor_mimetypesVALUES (33'image/jpeg , image/pjpeg , image/png , image/gif');

-- --------------------------------------------------------

-- 
-- 
Table structure for table `xoops_tinyeditor_toolset`
-- 

CREATE TABLE `xoops_tinyeditor_toolset` (
  `
tinyed_idint(11NOT NULL auto_increment,
  `
tinyed_gidint(11NOT NULL,
  `
tinyed_row1text collate utf8_general_ci NOT NULL,
  `
tinyed_row2text collate utf8_general_ci NOT NULL,
  `
tinyed_row3text collate utf8_general_ci NOT NULL,
  `
imgwidthint(4NOT NULL,
  `
imgheightint(4NOT NULL,
  `
diskquotaint(15NOT NULL,
  `
activeplugstext collate utf8_general_ci NOT NULL,
  `
validelementslongtext collate utf8_general_ci NOT NULL,
  `
extvalidelementslongtext collate utf8_general_ci NOT NULL,
  `
invalidelementslongtext collate utf8_general_ci NOT NULL,
  
PRIMARY KEY  (`tinyed_id`)
ENGINE=MyISAM;

-- 
-- 
Dumping data for table `xoops_tinyeditor_toolset`
-- 

INSERT INTO `xoops_tinyeditor_toolsetVALUES (11'fontselect fontsizeselect formatselect styleselect''bold italic underline strikethrough separator justifyleft justifycenter justifyright justifyfull separator cut copy paste bullist numlist indent outdent''flash undo redo separator sub sup forecolor backcolor removeformat separator link unlink anchor image cleanup hr charmap separator visualaid code xquote xcode emotions imanager ibrowser preview'5005005120000'flash xquote xcode emotions imanager ibrowser preview xquotecode''''''');
INSERT INTO `xoops_tinyeditor_toolsetVALUES (22'fontselect fontsizeselect formatselect styleselect''bold italic underline strikethrough separator justifyleft justifycenter justifyright justifyfull separator cut copy paste bullist numlist indent outdent''undo redo separator sub sup forecolor backcolor removeformat separator link unlink anchor image cleanup hr charmap separator visualaid code xquote xcode emotions'5005005120000'xquotecode emotions''''''');
INSERT INTO `xoops_tinyeditor_toolsetVALUES (33'fontselect fontsizeselect formatselect styleselect''bold italic underline strikethrough separator justifyleft justifycenter justifyright justifyfull separator cut copy paste bullist numlist indent outdent''undo redo separator sub sup forecolor backcolor removeformat separator link unlink anchor image cleanup hr charmap separator visualaid code xquote xcode emotions'5005005120000'xquotecode emotions''''''');


Hopefully this works.

3
Antoine
Re: TinyEditor 1.0, Xoops 1.0.15 and MySQL 5.0
  • 2006/11/8 8:39

  • Antoine

  • Friend of XOOPS

  • Posts: 112

  • Since: 2004/11/14


Seems to work. Installation does work fine now. Cheers.

Login

Who's Online

170 user(s) are online (131 user(s) are browsing Support Forums)


Members: 0


Guests: 170


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits