21
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.



22
maru1
Re: very newbie Q: number of visits
  • 2006/3/31 14:49

  • maru1

  • Just popping in

  • Posts: 27

  • Since: 2006/3/28


Thanks a lot, svaha!
It's so easy that I've managed to make it
Even though I'm still not too familiar with blocks.

By the way, I'm really impressed by your site's appearance. Gosh, it had to take lots lots of your time. What do you use for making it multilanguage? (if I can ask) For someday, in far future probably, I'd like to implement a multilanguage option to my site, and I don't know what to choose.



23
maru1
very newbie Q: number of visits
  • 2006/3/31 9:24

  • maru1

  • Just popping in

  • Posts: 27

  • Since: 2006/3/28


I mean a simple counter of visits, displayed as "xxx guests visited our site", which is usually an easy cgi script available at every server.

Since I've started with XOOPS (and it's just a few days), I notice that the XOOPS connected sites (like this one, or dev.xoops, etc) don't have such a thing. I couldn't also find this option in my XOOPS administration.

Searching for "counter" here gives a list of stats modules as a result, but all they are about sophisticated statistics for a webmaster, not a simple counter to put in the site.

Can I just use one of the scripts provided by my hosting server? But how could I add it to the site?



24
maru1
Re: Installation Trouble!!!!
  • 2006/3/30 9:23

  • maru1

  • Just popping in

  • Posts: 27

  • Since: 2006/3/28


I had the same problem with installing 2.0.13.2 and I found the solution here:
https://xoops.org/modules/newbb/viewtopic.php?topic_id=48193&forum=1&post_id=212018#forumpost211467



25
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...



26
maru1
Wrong displaying of some pages in administration
  • 2006/3/29 15:08

  • maru1

  • Just popping in

  • Posts: 27

  • Since: 2006/3/28


Hi all.
I've just installed XOOPS 2.0.13.2 and added some modules.
The whole thing is still almost empty, just a few testing news entries, forum threads and comments. Default skin and default templates.
After installing the PopnupBLOG module I got a strange thing: the pages in administration of this module display not properly. The main page of this module adm. consists of a upper menu and some content below. I mean, it should. But when I choose any of the possibilities (i.e. add a category, add a user, manage users, or whatever), the content displays not below the menu (in the middle of the page), but somewhere on right of it. But no horizontal scroll line in my browser window appears, so I can't see the content; only a few pixels of the tables and one or two first letters of what is written there. So I only KNOW there is something, but can't access it.
First I thought it could be this particular module problem, but then I've installed one more (a guestbook), and get the same strange behavior in its manage pages.
Other modules seem to work fine.
So it is probably some case with the global theme/template/display? But as I said, I haven't changed them from default.
I emptied template_c directory and made update of System module.
Debugger doesn't show any errors.

I have no idea what to do. Some help, please!



27
maru1
Re: Cannot install xoops
  • 2006/3/28 11:44

  • maru1

  • Just popping in

  • Posts: 27

  • Since: 2006/3/28


I had the same problem with "failed writing constant..". I tried overwriting mainfile.php manually as voite had described in his post, and it works now! Thanks, voite!




TopTop
« 1 2 (3)



Login

Who's Online

182 user(s) are online (79 user(s) are browsing Support Forums)


Members: 0


Guests: 182


more...

Donat-O-Meter

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

Latest GitHub Commits