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.  / xoopspoll installation problem
Register
1
tsdebs
xoopspoll installation problem

  • 2009/2/17 16:56

  • tsdebs

  • Just popping in

  • Posts: 1

  • Since: 2009/2/17


I downloaded and wanted to use the Xoopspoll 1.2 which was supposed to work with XOOPS 2.3, but when I wanted to install the module, I received the following error: Unable to install xoopspoll. Error(s):

Installing Polls

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

How can one rectify this issue?

thanks for any suggestions...
2
Anonymous
Re: xoopspoll installation problem

  • 2009/2/17 18:23

  • Anonymous

  • Posts: 0

  • Since:


Sounds like an error in the .sql file used in the installation process. I'll download the module and take a look..... but if someone else gets there before me, please feel free to post the solution
3
Anonymous
Re: xoopspoll installation problem

  • 2009/2/17 19:01

  • Anonymous

  • Posts: 0

  • Since:


Hmm... so far as I can see, the MySQL.sql files for v1.1 (which I know works/installs) is the same as for the new v1.2

So that's my idea gone.

Are you doing a fresh install or an upgrade?

Oh, and are you running PHP5?
4
ghia
Re: xoopspoll installation problem

  • 2009/2/17 21:57

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


It's probably the MySql version. Remove the
default ''
in the /sql/mysql.sql in the line with description.
Change from
description tinytext NOT NULL default '',

to
description tinytext NOT NULL,
and retry the install.
5
zyspec
Re: xoopspoll installation problem

  • 2009/2/17 21:59

  • zyspec

  • Module Developer

  • Posts: 1095

  • Since: 2004/9/21


You're right John. This is a MySQL 5 change. Text and Blob types cannot have a default value. You should be able to change line 40 in ./sql/mysql.sql from:
description tinytext NOT NULL default '',

to:
description tinytext NOT NULL,
6
Anonymous
Re: xoopspoll installation problem

  • 2009/2/18 9:32

  • Anonymous

  • Posts: 0

  • Since:


Quote:
zyspec wrote:

You're right John. This is a MySQL 5 change.


Ah - no wonder I didn't spot it.... i'm still on an earlier version of MySQL on my live site

Thanks guys.

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

343 user(s) are online (265 user(s) are browsing Support Forums)

Members: 0

Guests: 343

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