Hey guys.

First of all, thank you Jaza (and everyone else) for updating the module. I downloaded the new version, and tried to install it on a fresh 5.0rc1 drupal install. However, when I installed the category module (only the actual category.module), I got this error:

user warning: BLOB/TEXT column 'description' can't have a default value query: CREATE TABLE category ( cid int(10) unsigned NOT NULL default '0', cnid int(10) unsigned NOT NULL default '0', description longtext NOT NULL default '', weight tinyint(4) NOT NULL default '0', depth tinyint(4) NOT NULL default '0', PRIMARY KEY (cid), KEY tid (cnid), KEY weight (weight) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\includes\database.mysql.inc on line 167.

What exactly is going on here? Is anyone else getting this problem?

Comments

DayShallCome’s picture

DayShallCome commented

Further, when I try to create a container, I get this error:

user warning: Table 'dportal1.category' doesn't exist query: SELECT cn.*, n.title FROM category_cont cn INNER JOIN category_cont_node_types cnt ON cn.cid = cnt.cid INNER JOIN category c ON cn.cid = c.cid INNER JOIN node n ON cn.cid = n.nid WHERE cnt.type = 'page' AND n.status = 1 ORDER BY c.weight, n.title in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\includes\database.mysql.inc on line 167.

DayShallCome’s picture

DayShallCome commented

Yeah, after messing around with it some more, it is broken. It doesn't seem to be writing anything to the db.

Eric Cosky’s picture

Eric Cosky commented

I tried installing this and I am getting errors also. At the modules page, by installing only the basic category module, I get an error that says it can't copy 'taxonomy.module.copyme'.

Also, when I tried to create a category or container content type, I get the following error (two of them actually):

warning: Invalid argument supplied for foreach() in [snip]/modules/cck/content.module on line 559.

Obviously it is a problem with CCK and not Categories but it seems related at least. I corrected this problem by inserting the line:
if (count($type['fields']) == 0) return $return;

..right before the foreach on 559 of cck/content,module, and the error went away. The fix is similar to other code in the cck module that checks this value for contents before using.

I'm new to this module so I'm not yet sure if it actually works yet but this much I can say helped me out already.
Thanks for your continued efforts, this seems like a very useful module and I look forward to getting it to work.

Permanently Undecided’s picture

Permanently Undecided commented

On a fresh install of Drupal 5.0-rc1, with the official new release of category, and no other contributed modules except category, I can't seem to reproduce the error, everything worked smoothly for me. I enabled Category, Category bulk, Category display, Category export, Category legacy, Category menu, Category outliner, Category transform and Taxonomy (wrapper), and it installed the database tables correctly and all. I can create categories and contaners without problems.
I'm running php 5.1.6, MySql 5.0.19 and Apache 2.0.59.

On a new fresh install, I installed first cck-5.x-1.x-dev, and then the newest category module. No problems again. Tables install cleanly, can create containers and categories without errors. I have not tried 5.x-1.0-beta, because it's an old release (20 Nov) and I know many cck bugs have been fixed in the meanwhile. Perhaps those who are having problems can try a fresh install, and then using the cck dev version to see if the problems disappear?

DayShallCome’s picture

DayShallCome commented

Well something weird is going on, as I can't seem to install the 4.7 Category on 4.7.5 - i get the same error.

I'm using Apache 2.2.3 with php 5.2 and mysql 5.0.27... I wonder if php 5.2 is the problem.

spjsche’s picture

spjsche commented

I have just done a clean install of 5.0rc1 with the the following

Apache/2.2.3 (Win32) mod_ssl/2.2.3 OpenSSL/0.9.8d mod_auth_sspi/1.0.4 PHP/5.2.0

using MySQL 5.0.22 and have not had any problems.

DayShallCome’s picture

DayShallCome commented

Okay, I've figured out the issue. When MySQL db's are now set to Strict mode, db writes with the "default" command won't work.

http://drupal.org/node/54702
http://drupal.org/node/97510
http://drupal.org/node/98981

I've turned my DB off of strict mode (doesn't really matter to me). I'm assuming that category.install needs to deal with this somehow?

lias’s picture

lias commented

I'm having the same issue, the wrappers for book.copy.module/taxonomy.copyme.module can't be installed. If it's an issue of permissions would it be a problem to manually install the wrappers? Or is that asking for trouble?
thanks
lsabug

DayShallCome’s picture

DayShallCome commented

No, the failure of the automated script is usually due to file write permission issues. There is no problem with installing the wrapper yourself. Make sure to backup (just in case).

hectorplus’s picture

hectorplus commented
Title: 5.0 version does not install cleanly. » File permissions

Agree, i had the same problem before when trying to install the wrapper. I found out that by giving my modules folder the right permission, the wrapper worked flawlessly.

lias’s picture

lias commented

I'll second that, on Windows 2003 giving the apache user modify and write permissions got rid of the error. I'm going to try this on my unix installment next.
Many thanks.
Lsabug

JirkaRybka’s picture

JirkaRybka commented
Status: Active » Closed (fixed)

- More than 2 years of silence here.
- Install problems were most probably fixed later, as no-one added to this issue, and it was some early version. I had no problems like that (later) on 4.7.x, nor 5.x
- 4.7.x no more supported
- Filesystem permissions are not a bug in Category module.

So closing this issue.