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:

le="color: #000000"><?php -- phpMyAdmin SQL Dump -- version 2.7.0-pl1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Nov 07, 2006 at 05:04 PM -- Server version: 5.0.18 -- PHP Version: 5.1.1 -- -- Database: `xoops2015` -- -- -------------------------------------------------------- -- -- Table structure for table `xoops_tinyeditor_mimetypes` -- CREATE TABLE `xoops_tinyeditor_mimetypes` ( `tinymt_id` int(11) NOT NULL auto_increment, `tinymt_gid` int(11) NOT NULL, `tinymt_types` text collate utf8_general_ci NOT NULL, PRIMARY KEY (`tinymt_id`) ) ENGINE=MyISAM; -- -- Dumping data for table `xoops_tinyeditor_mimetypes` -- INSERT INTO `xoops_tinyeditor_mimetypes` VALUES (1, 1, 'image/jpeg , image/pjpeg , image/png , image/gif'); INSERT INTO `xoops_tinyeditor_mimetypes` VALUES (2, 2, 'image/jpeg , image/pjpeg , image/png , image/gif'); INSERT INTO `xoops_tinyeditor_mimetypes` VALUES (3, 3, 'image/jpeg , image/pjpeg , image/png , image/gif'); -- -------------------------------------------------------- -- -- Table structure for table `xoops_tinyeditor_toolset` -- CREATE TABLE `xoops_tinyeditor_toolset` ( `tinyed_id` int(11) NOT NULL auto_increment, `tinyed_gid` int(11) NOT NULL, `tinyed_row1` text collate utf8_general_ci NOT NULL, `tinyed_row2` text collate utf8_general_ci NOT NULL, `tinyed_row3` text collate utf8_general_ci NOT NULL, `imgwidth` int(4) NOT NULL, `imgheight` int(4) NOT NULL, `diskquota` int(15) NOT NULL, `activeplugs` text collate utf8_general_ci NOT NULL, `validelements` longtext collate utf8_general_ci NOT NULL, `extvalidelements` longtext collate utf8_general_ci NOT NULL, `invalidelements` longtext collate utf8_general_ci NOT NULL, PRIMARY KEY (`tinyed_id`) ) ENGINE=MyISAM; -- -- Dumping data for table `xoops_tinyeditor_toolset` -- INSERT INTO `xoops_tinyeditor_toolset` VALUES (1, 1, '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', 500, 500, 5120000, 'flash xquote xcode emotions imanager ibrowser preview xquotecode', '', '', ''); INSERT INTO `xoops_tinyeditor_toolset` VALUES (2, 2, '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', 500, 500, 5120000, 'xquotecode emotions', '', '', ''); INSERT INTO `xoops_tinyeditor_toolset` VALUES (3, 3, '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', 500, 500, 5120000, '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

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