1
Blixer
Wiwimod Installation Issue
  • 2007/3/21 3:43

  • Blixer

  • Just popping in

  • Posts: 21

  • Since: 2007/3/3 1


I'm trying to install Wiwimod as the suggested wiki by skenow in his Starting a New XOOPS Site thread. I'm using Apache/2.2.4 (Win32) PHP/5.2.1 and MySQL version 5.0.27-community-nt. When I try to install the Wiwimod module the installation fails and I get an error that says:

Installing Wiwi

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

Unable to install wiwimod. Error(s):

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

Anyone have a idea to solve this issue?

Thanks!

2
skenow
Re: Wiwimod Installation Issue
  • 2007/3/21 3:57

  • skenow

  • Home away from home

  • Posts: 993

  • Since: 2004/11/17


What is the version of Wiwimod you are installing? I have been using 0.8.3 from here

3
Anonymous
Re: Wiwimod Installation Issue
  • 2007/3/21 7:46

  • Anonymous

  • Posts: 0

  • Since:


Quote:
skenow wrote:

What is the version of Wiwimod you are installing? I have been using 0.8.3 from here


Me too, and it works fine.

What version of XOOPS are you using?

4
Blixer
Re: Wiwimod Installation Issue
  • 2007/3/21 12:21

  • Blixer

  • Just popping in

  • Posts: 21

  • Since: 2007/3/3 1


I'm trying to install Wiwimod 0.8.3
I'm running XOOPS 2.0.16
Apache 2.2
mysql 5.0.27-community-nt

I've got the following modules installed and working:
system ver. 1.02
xoops db backup and restore 3.00
xoops info 2.12
protector 3.01

In some of my searches I've found a similar error that refers to this potentially being something to do with MySQL version 5. A similar error was mentioned in this thread about MySQL http://bugs.mysql.com/bug.php?id=24276

I'm at a total loss as to how to proceed though.

Any thoughts? I'm trying to work day by day through your S"tarting a New XOOPS Site thread." skenow.

Thanks!

5
skenow
Re: Wiwimod Installation Issue
  • 2007/3/21 13:12

  • skenow

  • Home away from home

  • Posts: 993

  • Since: 2004/11/17


It sounds to me like you got a modified version of 0.8.3 - the error you are reporting indicates a problem with the database definitions for the wiwimod tables, specifically the 'body' column. The version I have does not have a default value for 'body', nor does the module I just downloaded from the wiwimod site (http://www.zonatim.com). I, too, am using MySQL version 5.x.

If you look in /modules/wiwimod/sql and open mysql.sql with a text editor. The top of the file should look like this -

#
# Table structure for wiwimod 0.7
#

CREATE TABLE wiwimod (
  
id int(10NOT NULL auto_increment,
  
keyword varchar(255NOT NULL default '',
  
title varchar(255NOT NULL default '',
  [
color=ff0000]body text NOT NULL default '',[/color]
  
lastmodified datetime NOT NULL default '0000-00-00 00:00:00',
  
u_id int(10NOT NULL default '0',
  
visible int(3) default '0',
  
contextBlock varchar(255) default '',
  
parent varchar(255) default '',
  
pageid int(10) default '0',
  
prid integer default '0',
  
PRIMARY KEY (id)
TYPE=MyISAM;


If your file looks the same as this, I would try removing the default '' from the file, saving it, then trying the install again.

Let us know how this turns out.

I am glad you have been able to follow the startup guide to this point.

6
Blixer
Re: Wiwimod Installation Issue
  • 2007/3/21 23:14

  • Blixer

  • Just popping in

  • Posts: 21

  • Since: 2007/3/3 1


Steve,
My mysql.sql file looked exactly like the segment you posted.

When I got rid of the default "" the installation seemed to proceed although there was one error. The process said that the module was installed.

The module seems to function and I can get the blocks to show up on my site.

Now I'm having issues with editing. Maybe I just don't understand but I have installed the XOOPS editors package. It is my understanding that I should be able to edit the wiwi pages directly and then when I update, the changes should be saved. But I can't seem to get it to allow me to make any changes. It as if I don't have an editor. Maybe I just don't understand the editor installation / function or how to activate the editors.

Login

Who's Online

476 user(s) are online (414 user(s) are browsing Support Forums)


Members: 0


Guests: 476


more...

Donat-O-Meter

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

Latest GitHub Commits