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.  / Installing ARMS gives Errors (Invalid default value for 'cat_id')
Register
1
punivers
Installing ARMS gives Errors (Invalid default value for 'cat_id')

  • 2005/1/23 17:18

  • punivers

  • Just popping in

  • Posts: 23

  • Since: 2004/4/4 1


When I install the module ArMS the I get the error:
------------------------------------------------------
Invalid default value for 'cat_id'
Can not Install ArMS
------------------------------------------------------

Can not find anything on the web and the Site of the maker is down

Does anybody know hot to install ArMS
2
CN-Techniker
Re: Installing ARMS gives Errors (Invalid default value for 'cat_id')

Hi,

I have the same error. I can't find the case for this error.
3
hplsbyufan
Re: Installing ARMS gives Errors (Invalid default value for 'cat_id')

  • 2005/8/9 6:49

  • hplsbyufan

  • Just popping in

  • Posts: 1

  • Since: 2005/8/9 6


I'm also getting this error. I'm just testing XOOPS for possible deployment, and this would probably be my first choice module.
4
nintender
Re: Installing ARMS gives Errors (Invalid default value for 'cat_id')

  • 2005/8/10 4:06

  • nintender

  • Just popping in

  • Posts: 19

  • Since: 2005/6/29


While I've noticed other quirks, this one installed fairly well.
Trick was I had to create a folder named AMS (in caps) under the module directory, then move all files there.

Seems to be working well, though the dates for submission are off for some reason. Also, can go to a blank Article page yet. It might be me and not a bug.
I'm using Xoops2.2 and AMS 2.41
5
adam7979
Re: Installing ARMS gives Errors (Invalid default value for 'cat_id')

  • 2005/10/7 9:40

  • adam7979

  • Just popping in

  • Posts: 4

  • Since: 2005/10/7


remove the default value for each table's primary key solved the problem.

edit arms/sql/arms_mysql.sql solves the problem for me.


good luck.
6
byu_xj
Re: Installing ARMS gives Errors (Invalid default value for 'cat_id')

  • 2006/1/13 16:59

  • byu_xj

  • Just popping in

  • Posts: 13

  • Since: 2006/1/11


Can you elaborate more on this solution? Did you edit the MySQL database or simply the sql install file?
7
maru1
Re: Installing ARMS gives Errors (Invalid default value for 'cat_id')

  • 2006/3/29 20:48

  • maru1

  • Just popping in

  • Posts: 27

  • Since: 2006/3/28


I encounter the same problem while trying to install ArMS (version 0.4).

So I second byu_xj's question:

adam7979 (or maybe anyone else, if wishes), could you explain a little clearer, what do you mean by "removing the default value for each table's primary key"?
Should I just edit arms_mysql.sql and then remove the line
PRIMARY KEY (something)
in every "create table" block? Or only clear what is in the brackets after the phrase "primary key"?
Or do something in the database itself?

Sorry if that question is silly, but I really don't have knowledge about these things...
8
maru1
Re: Installing ARMS gives Errors (Invalid default value for 'cat_id')

  • 2006/4/1 12:39

  • maru1

  • Just popping in

  • Posts: 27

  • Since: 2006/3/28


Nobody wished to help, so I started the try & error procedure in order to install this module. Finally I did it, so I'd like to share - maybe someone would find it useful.
Here's what I did:
Edited the file arms/sql/arms_mysql.sql
And deleted things in red:
Quote:
# ==============================================================================
# Table arms_categories added in ArMS 0.3
# ==============================================================================

CREATE TABLE arms_categories (
cat_id smallint(3) unsigned default "0" NOT NULL auto_increment,
cat_title varchar(100) default "" NOT NULL,
cat_desc text default "" NOT NULL,
cat_order smallint(3) unsigned default "" NOT NULL,
PRIMARY KEY (cat_id)
) TYPE = MyISAM;

# ==============================================================================
# ArMS 0.3 addons
# ---------------
# cat_id - category id
# sec_image - section image
# ==============================================================================

CREATE TABLE arms_sections (
sec_id smallint(3) unsigned default "0" NOT NULL auto_increment,
cat_id smallint(3) unsigned default "0" NOT NULL,
sec_order smallint(3) unsigned default "1" NOT NULL,
sec_title varchar(100) default "" NOT NULL,
sec_desc text default "" NOT NULL,
sec_image varchar(255) default "" NOT NULL,
PRIMARY KEY (sec_id)
) TYPE = MyISAM;

CREATE TABLE arms_articals_levels (
level_id smallint(3) unsigned default "" NOT NULL auto_increment,
level_name varchar(100) default "" NOT NULL,
level_desc text default "" NOT NULL,
level_image varchar(100) default "" NOT NULL,
PRIMARY KEY (level_id)
) TYPE = MyISAM;

# ==============================================================================
# ArMS 0.3 Addons
# ---------------
# art_onhold - while art_onhold is 1 only admin and author can see this artical
# ==============================================================================

CREATE TABLE arms_articals (
art_id int(5) unsigned default "0" NOT NULL auto_increment,
sec_id smallint(3) unsigned default "0" NOT NULL,
level_id smallint(3) unsigned default "0" NOT NULL,
uid int(5) unsigned default "0" NOT NULL,
uip varchar(15) default "" NOT NULL,

art_title varchar(255) default "" NOT NULL,
art_desc text default "" NOT NULL,

art_updatecount smallint(3) unsigned default "0" NOT NULL,
art_posttime int(11) unsigned default "0" NOT NULL,
art_lastupdate int(11) unsigned default "0" NOT NULL,
art_lastupdateby int(5) unsigned default "0" NOT NULL,
art_lastupdatebyip varchar(15) default "" NOT NULL,

art_ratetotal mediumint(8) unsigned default "0" NOT NULL,
art_ratecount mediumint(8) unsigned default "1" NOT NULL,

art_views int(11) unsigned default "0" NOT NULL,
art_activated tinyint(1) default "0" NOT NULL,
art_onhold tinyint(1) default "1" NOT NULL,
PRIMARY KEY (art_id)
) TYPE = MyISAM;

CREATE TABLE arms_pages (
page_id int(6) unsigned default "0" NOT NULL auto_increment,
page_order smallint(3) unsigned default "1" NOT NULL,

art_id int(5) unsigned default "0" NOT NULL,
level_id smallint(3) unsigned default "0" NOT NULL,
uid int(5) unsigned default "0" NOT NULL,
uip varchar(15) default "" NOT NULL,

page_title varchar(255) default "" NOT NULL,
page_desc text default "" NOT NULL,
page_text text default "" NOT NULL,

page_allow_html tinyint(1) default "0" NOT NULL,
page_allow_emotions tinyint(1) default "0" NOT NULL,
page_allow_bbcode tinyint(1) default "1" NOT NULL,

page_updatecount smallint(3) unsigned default "0" NOT NULL,
page_posttime int(11) unsigned default "0" NOT NULL,
page_lastupdate int(11) unsigned default "0" NOT NULL,
page_lastupdateby int(5) unsigned default "0" NOT NULL,
page_lastupdatebyip varchar(15) default "" NOT NULL,

page_views int(11) unsigned default "0" NOT NULL,
PRIMARY KEY (page_id)
) TYPE = MyISAM;

CREATE TABLE arms_votelog (
vote_id int(5) unsigned default "0" NOT NULL auto_increment,
vote_time int(11) unsigned default "0" NOT NULL,
art_id int(5) unsigned default "0" NOT NULL,
uid int(5) unsigned default "0" NOT NULL,
uip varchar(15) default "" NOT NULL,
PRIMARY KEY (vote_id)
) TYPE = MyISAM;

CREATE TABLE arms_moderators(
mod_id smallint(3) unsigned default "0" NOT NULL auto_increment,
uid int(5) unsigned default "0" NOT NULL,
sec_id smallint(3) unsigned default "0" NOT NULL,
PRIMARY KEY (mod_id)
) TYPE = MyISAM;

# ==============================================================================
# Table arms_permissions added in ArMS 0.3
# Note: fiels can_add_files and can_delete_files not implemented in ArMS 0.3
# please wait ArMS 0.4 for file attachments...
# ==============================================================================

CREATE TABLE arms_permissions(
p_id int(6) unsigned default "0" NOT NULL auto_increment,
art_id int(6) unsigned default "0" NOT NULL,
uid int(5) unsigned default "0" NOT NULL,
added_by int(5) unsigned default "0" NOT NULL,
can_edit_pages tinyint(1) default "1" NOT NULL,
can_add_pages tinyint(1) default "0" NOT NULL,
can_delete_pages tinyint(1) default "0" NOT NULL,

can_add_files tinyint(1) default "0" NOT NULL,
can_delete_files tinyint(1) default "0" NOT NULL,
PRIMARY KEY (p_id)
) TYPE = MyISAM;

# ==============================================================================
# Table arms_cross_section added in ArMS 0.3
# ==============================================================================

CREATE TABLE arms_cross_section (
cs_id int(9) unsigned default "0" NOT NULL auto_increment,
art_id int(6) unsigned default "0" NOT NULL,
sec_id smallint(3) unsigned default "0" NOT NULL,
PRIMARY KEY (cs_id)
) TYPE = MyISAM;


Warning: My knowledge about sql stuff is absolutely NONE, so I can't even say what my changes did.
But the module has installed successfully. All options seem to work fine as for now.

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

333 user(s) are online (271 user(s) are browsing Support Forums)

Members: 0

Guests: 333

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