mariovaldez.net

MV.net forums
It is currently 14 Jul 2016, 00:40

All times are UTC - 7 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 7 posts ] 
Author Message
PostPosted: 08 Nov 2004, 09:36 
Hello,
working with PHProjekt 4.2, installed and working well.
Installing CMS 0.6 causes errors:

1. creating config: ok
2. creating tables: only error-messages, no new table created in DB

Errormessages:
error creation CONTENT3
error update CONTENT3 1/7 to 0.5.0
error update CONTENT3 2/7 to 0.5.0
error update CONTENT3 3/7 to 0.5.0
error update CONTENT3 4/7 to 0.5.0
error update CONTENT3 5/7 to 0.5.0
error update CONTENT3 6/7 to 0.5.0
error update CONTENT3 7/7 to 0.5.0
error creation CMHITS3
error creation CMCOMMENTS3
error creation CMRATING3
error creation CMRESTRICT3
error creation CMAPPLOG3
error creation CMSYND3

I have to say, this is not an update, first time installation.
What goes wrong ?

(sorry, i am not a professional programmer ....)

thanks

giovanni


Report this post
Top
  
Reply with quote  
 Post subject: Database errors...
PostPosted: 10 Nov 2004, 07:03 
User avatar

Joined: 06 Mar 2003, 03:21
Posts: 447
Location: Monterrey, NL, Mexico
Giovanni:

> Hello, working with PHProjekt 4.2, installed and working well.
> Installing CMS 0.6 causes errors:
> 1. creating config: ok
> 2. creating tables: only error-messages, no new table created in DB
> Errormessages:
> error creation CONTENT3
> error update CONTENT3 1/7 to 0.5.0... ...
> I have to say, this is not an update,
> first time installation. What goes wrong ?

Hi. What database are you using (mysql, postgres, oracle, mssql)? Please check that you have permissions to CREATE and ALTER the database tables. Check that with your database manager (for example, with phpmyadmin for mysql).

Also, you may try to enable full the error reporting:
Edit the cm/cm_lib.inc.php file, around line 27, change the line
Code:
error_reporting(E_ALL & ~E_NOTICE);

with
Code:
error_reporting(E_ALL);


This may (or may not) provide more details about the cause of the failure. (You will see additional "error" messages with a "NOTICE" tag, most are harmless).

Please let me know what you find, Giovanni.

Regards,

Mario A. Valdez-Ramirez.


Report this post
Top
 Profile  
Reply with quote  
 Post subject: RE: Creating tables
PostPosted: 10 Nov 2004, 09:00 
Hello Mario,
thank you for your reply.

I am using:
PHProjekt 4.2 default configuration,
MySQL 3.23.57 on Apache Server,
logged in as Superuser PHProjekt root, set to root1 in CM.

Step 1:
creating config: no problems
Step 2:
creating tb-tables:
a) Notice: Undefined variable: cm_createdb in /../cm/adm_createdb.php on line 40
b) after click on create:
error creation CONTENT3
error update CONTENT3 1/7 to 0.5.0
error update CONTENT3 2/7 to 0.5.0
error update CONTENT3 3/7 to 0.5.0
error update CONTENT3 4/7 to 0.5.0
error update CONTENT3 5/7 to 0.5.0
error update CONTENT3 6/7 to 0.5.0
error update CONTENT3 7/7 to 0.5.0
OK creation CMHITS3
OK creation CMCOMMENTS3
OK creation CMRATING3
OK creation CMRESTRICT3
OK creation CMAPPLOG3
OK creation CMSYND3

Step3: creating master-directory in CM:
Notice: Undefined variable: user_kurz in /.../cm/cm_constraints.inc.php on line 157

Notice: Undefined variable: user_kurz in /.../cm/cm_constraints.inc.php on line 159

Notice: Undefined variable: cm_createdir in /.../cm/adm_mkroot.php on line 41

Step 4: working in permission-table:
Notice: Undefined variable: user_kurz in /.../cm/cm_constraints.inc.php on line 157

Notice: Undefined variable: user_kurz in /.../cm/cm_constraints.inc.php on line 159

Notice: Undefined variable: cm_restore_sec in /.../cm/adm_editsec.php on line 52

Notice: Undefined variable: cm_save_sec in /.../cm/adm_editsec.php on line 56

Notice: Undefined variable: user_kurz in /.../cm/cm_constraints.inc.php on line 157

Notice: Undefined variable: user_kurz in /.../cm/cm_constraints.inc.php on line 159

After storing changes:

Notice: Undefined variable: cm_restore_sec in /.../cm/adm_editsec.php on line 52

Notice: Undefined variable: cm_sec_1_1_2 eval()'d code on line 1

same in:

Notice: Undefined variable: cm_sec_1_1_3
Notice: Undefined variable: cm_sec_1_1_4
Notice: Undefined variable: cm_sec_1_1_5
Notice: Undefined variable: cm_sec_1_1_6
Notice: Undefined variable: cm_sec_2_1_2
Notice: Undefined variable: cm_sec_2_1_3
Notice: Undefined variable: cm_sec_2_1_4
Notice: Undefined variable: cm_sec_2_1_6
Notice: Undefined variable: cm_sec_1_2_1
Notice: Undefined variable: cm_sec_1_2_2
Notice: Undefined variable: cm_sec_1_2_3
Notice: Undefined variable: cm_sec_1_2_4
Notice: Undefined variable: cm_sec_1_2_5
Notice: Undefined variable: cm_sec_1_2_6
Notice: Undefined variable: cm_sec_2_2_2
Notice: Undefined variable: cm_sec_2_2_4
Notice: Undefined variable: cm_sec_2_2_6
Notice: Undefined variable: cm_sec_1_3_1
Notice: Undefined variable: cm_sec_1_3_2
Notice: Undefined variable: cm_sec_1_3_3
Notice: Undefined variable: cm_sec_1_3_4
Notice: Undefined variable: cm_sec_1_3_5
Notice: Undefined variable: cm_sec_1_3_6
Notice: Undefined variable: cm_sec_2_3_2
Notice: Undefined variable: cm_sec_2_3_4
Notice: Undefined variable: cm_sec_2_3_6
Notice: Undefined variable: cm_sec_2_4_2
Notice: Undefined variable: cm_sec_2_4_6
Notice: Undefined variable: cm_sec_1_5_1
Notice: Undefined variable: cm_sec_1_5_2
Notice: Undefined variable: cm_sec_1_5_3
Notice: Undefined variable: cm_sec_1_5_4
Notice: Undefined variable: cm_sec_1_5_5
Notice: Undefined variable: cm_sec_1_5_6
Notice: Undefined variable: cm_sec_2_5_1
Notice: Undefined variable: cm_sec_2_5_2
Notice: Undefined variable: cm_sec_2_5_6
Notice: Undefined variable: user_kurz

There were 6 tables created in the DB.

Greetings
giovanni


Report this post
Top
  
Reply with quote  
PostPosted: 10 Nov 2004, 09:41 
User avatar

Joined: 06 Mar 2003, 03:21
Posts: 447
Location: Monterrey, NL, Mexico
> I am using: PHProjekt 4.2 default configuration,
> MySQL 3.23.57 on Apache Server, logged in as
> Superuser PHProjekt root, set to root1 in CM.
> Step 1: creating config: no problems
> Step 2: creating tb-tables: ...
> error creation CONTENT3
> error update CONTENT3 1/7 to 0.5.0
> error update CONTENT3 2/7 to 0.5.0
> error update CONTENT3 3/7 to 0.5.0
> error update CONTENT3 4/7 to 0.5.0
> error update CONTENT3 5/7 to 0.5.0
> error update CONTENT3 6/7 to 0.5.0
> error update CONTENT3 7/7 to 0.5.0
> OK creation CMHITS3
> OK creation CMCOMMENTS3
> OK creation CMRATING3
> OK creation CMRESTRICT3
> OK creation CMAPPLOG3
> OK creation CMSYND3...
> There were 6 tables created in the DB.

Hi again. This is different than the first time. This time only the first table failed (the UPDATE queries failed because the CONTENT3 table was not there, was already updated or there is no permissions to alter).

Are you sure the CONTENT3 table is not already there? Please check it out. If the table is not there, then this is very weird, because the other tables were created without problems.

I can post an SQL dump for MySQL, but the point is that we should try to find out what is the problem with your setup, Giovanni.

So, I'm running out of ideas. Delete the CMxxxxx tables and the CONTENT3 table, then try to create them again. If you still have problems, I'll post the MySQL dump so you can create them directly with your database manager.


Regards,

Mario A. Valdez-Ramirez.


Report this post
Top
 Profile  
Reply with quote  
 Post subject: Create DB
PostPosted: 10 Nov 2004, 10:50 
Hello Mario,

I delete all tables in db, delete the config-file of CM.
Create manual the table CONTENT3, no problems.
Delete all again, start setup.php again.

Nearly same result. Alle tables created without CONTENT3, errors by update of CONTENT3, error by creating CONTENT3.

I make a copy of your installation-script and create with this script tables in DB (only creating tables, not filling them with values). look there - it works !

Strange ..... maybe you sent me an sql-dump, then I try with this to create the tables/fields.
thanks

giovanni


Report this post
Top
  
Reply with quote  
 Post subject:
PostPosted: 12 Nov 2004, 19:05 
Hello,

you want to post the sql-dump.
actual installation is not working.

thanks
giovanni


Report this post
Top
  
Reply with quote  
PostPosted: 14 Nov 2004, 02:18 
User avatar

Joined: 06 Mar 2003, 03:21
Posts: 447
Location: Monterrey, NL, Mexico
Code:
# phpMyAdmin SQL Dump
# version 2.5.7
# http://www.phpmyadmin.net
#
# Servidor: wintermute
# Tiempo de generación: 14-11-2004 a las 03:11:59
# Versión del servidor: 4.0.15
# Versión de PHP: 4.3.8
#
# Base de datos : `phprojekt_old_test`
#

# --------------------------------------------------------

#
# Estructura de tabla para la tabla `cmapplog3`
#

DROP TABLE IF EXISTS `cmapplog3`;
CREATE TABLE `cmapplog3` (
  `ID` int(8) NOT NULL auto_increment,
  `cmdb_date` varchar(20) default NULL,
  `cmdb_operation` int(11) default NULL,
  `cmdb_user` varchar(20) default NULL,
  `cmdb_directory` varchar(255) default NULL,
  `cmdb_description` varchar(255) default NULL,
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;

#
# Volcar la base de datos para la tabla `cmapplog3`
#

INSERT INTO `cmapplog3` VALUES (1, '2004-11-14 03:11:22', 11, '', '', 'Cannot load incomplete restriction/permission matrix.');
INSERT INTO `cmapplog3` VALUES (2, '2004-11-14 03:11:22', 11, '', '', 'Loaded default restriction/permission matrix.');
INSERT INTO `cmapplog3` VALUES (3, '2004-11-14 03:11:22', 11, '', '', 'Cannot load incomplete restriction/permission matrix.');
INSERT INTO `cmapplog3` VALUES (4, '2004-11-14 03:11:22', 11, '', '', 'Loaded default restriction/permission matrix.');
INSERT INTO `cmapplog3` VALUES (5, '2004-11-14 03:11:26', 11, '', '', 'Cannot load incomplete restriction/permission matrix.');
INSERT INTO `cmapplog3` VALUES (6, '2004-11-14 03:11:26', 11, '', '', 'Loaded default restriction/permission matrix.');
INSERT INTO `cmapplog3` VALUES (7, '2004-11-14 03:11:26', 10, '', '', 'Saved restriction/permission matrix.');

# --------------------------------------------------------

#
# Estructura de tabla para la tabla `cmcomments3`
#

DROP TABLE IF EXISTS `cmcomments3`;
CREATE TABLE `cmcomments3` (
  `ID` int(8) NOT NULL auto_increment,
  `cmdb_type` varchar(10) default NULL,
  `cmdb_directory` varchar(255) default NULL,
  `cmdb_title` varchar(255) default NULL,
  `cmdb_author_user` varchar(20) default NULL,
  `cmdb_date_creation` varchar(20) default NULL,
  `cmdb_comment` text,
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Volcar la base de datos para la tabla `cmcomments3`
#


# --------------------------------------------------------

#
# Estructura de tabla para la tabla `cmhits3`
#

DROP TABLE IF EXISTS `cmhits3`;
CREATE TABLE `cmhits3` (
  `ID` int(8) NOT NULL auto_increment,
  `cmdb_type` varchar(10) default NULL,
  `cmdb_directory` varchar(255) default NULL,
  `cmdb_totalhits` int(11) default NULL,
  `cmdb_updatehits` int(11) default NULL,
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Volcar la base de datos para la tabla `cmhits3`
#


# --------------------------------------------------------

#
# Estructura de tabla para la tabla `cmrating3`
#

DROP TABLE IF EXISTS `cmrating3`;
CREATE TABLE `cmrating3` (
  `ID` int(8) NOT NULL auto_increment,
  `cmdb_directory` varchar(255) default NULL,
  `cmdb_rate` int(11) default NULL,
  `cmdb_author_user` varchar(20) default NULL,
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Volcar la base de datos para la tabla `cmrating3`
#


# --------------------------------------------------------

#
# Estructura de tabla para la tabla `cmrestrict3`
#

DROP TABLE IF EXISTS `cmrestrict3`;
CREATE TABLE `cmrestrict3` (
  `ID` int(8) NOT NULL auto_increment,
  `cmdb_object` int(11) default NULL,
  `cmdb_operation` int(11) default NULL,
  `cmdb_role` int(11) default NULL,
  `cmdb_permission` int(11) default NULL,
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=61 ;

#
# Volcar la base de datos para la tabla `cmrestrict3`
#

INSERT INTO `cmrestrict3` VALUES (1, 1, 1, 1, 1);
INSERT INTO `cmrestrict3` VALUES (2, 1, 1, 2, 0);
INSERT INTO `cmrestrict3` VALUES (3, 1, 1, 3, 0);
INSERT INTO `cmrestrict3` VALUES (4, 1, 1, 4, 0);
INSERT INTO `cmrestrict3` VALUES (5, 1, 1, 5, 0);
INSERT INTO `cmrestrict3` VALUES (6, 2, 1, 1, 1);
INSERT INTO `cmrestrict3` VALUES (7, 2, 1, 2, 0);
INSERT INTO `cmrestrict3` VALUES (8, 2, 1, 3, 0);
INSERT INTO `cmrestrict3` VALUES (9, 2, 1, 4, 0);
INSERT INTO `cmrestrict3` VALUES (10, 2, 1, 5, 1);
INSERT INTO `cmrestrict3` VALUES (11, 1, 2, 1, 0);
INSERT INTO `cmrestrict3` VALUES (12, 1, 2, 2, 0);
INSERT INTO `cmrestrict3` VALUES (13, 1, 2, 3, 0);
INSERT INTO `cmrestrict3` VALUES (14, 1, 2, 4, 0);
INSERT INTO `cmrestrict3` VALUES (15, 1, 2, 5, 0);
INSERT INTO `cmrestrict3` VALUES (16, 2, 2, 1, 1);
INSERT INTO `cmrestrict3` VALUES (17, 2, 2, 2, 0);
INSERT INTO `cmrestrict3` VALUES (18, 2, 2, 3, 1);
INSERT INTO `cmrestrict3` VALUES (19, 2, 2, 4, 0);
INSERT INTO `cmrestrict3` VALUES (20, 2, 2, 5, 1);
INSERT INTO `cmrestrict3` VALUES (21, 1, 3, 1, 0);
INSERT INTO `cmrestrict3` VALUES (22, 1, 3, 2, 0);
INSERT INTO `cmrestrict3` VALUES (23, 1, 3, 3, 0);
INSERT INTO `cmrestrict3` VALUES (24, 1, 3, 4, 0);
INSERT INTO `cmrestrict3` VALUES (25, 1, 3, 5, 0);
INSERT INTO `cmrestrict3` VALUES (26, 2, 3, 1, 1);
INSERT INTO `cmrestrict3` VALUES (27, 2, 3, 2, 0);
INSERT INTO `cmrestrict3` VALUES (28, 2, 3, 3, 1);
INSERT INTO `cmrestrict3` VALUES (29, 2, 3, 4, 0);
INSERT INTO `cmrestrict3` VALUES (30, 2, 3, 5, 1);
INSERT INTO `cmrestrict3` VALUES (31, 1, 4, 1, 1);
INSERT INTO `cmrestrict3` VALUES (32, 1, 4, 2, 1);
INSERT INTO `cmrestrict3` VALUES (33, 1, 4, 3, 1);
INSERT INTO `cmrestrict3` VALUES (34, 1, 4, 4, 1);
INSERT INTO `cmrestrict3` VALUES (35, 1, 4, 5, 1);
INSERT INTO `cmrestrict3` VALUES (36, 2, 4, 1, 1);
INSERT INTO `cmrestrict3` VALUES (37, 2, 4, 2, 0);
INSERT INTO `cmrestrict3` VALUES (38, 2, 4, 3, 1);
INSERT INTO `cmrestrict3` VALUES (39, 2, 4, 4, 1);
INSERT INTO `cmrestrict3` VALUES (40, 2, 4, 5, 1);
INSERT INTO `cmrestrict3` VALUES (41, 1, 5, 1, 0);
INSERT INTO `cmrestrict3` VALUES (42, 1, 5, 2, 0);
INSERT INTO `cmrestrict3` VALUES (43, 1, 5, 3, 0);
INSERT INTO `cmrestrict3` VALUES (44, 1, 5, 4, 0);
INSERT INTO `cmrestrict3` VALUES (45, 1, 5, 5, 0);
INSERT INTO `cmrestrict3` VALUES (46, 2, 5, 1, 0);
INSERT INTO `cmrestrict3` VALUES (47, 2, 5, 2, 0);
INSERT INTO `cmrestrict3` VALUES (48, 2, 5, 3, 1);
INSERT INTO `cmrestrict3` VALUES (49, 2, 5, 4, 1);
INSERT INTO `cmrestrict3` VALUES (50, 2, 5, 5, 1);
INSERT INTO `cmrestrict3` VALUES (51, 1, 1, 6, 0);
INSERT INTO `cmrestrict3` VALUES (52, 2, 1, 6, 0);
INSERT INTO `cmrestrict3` VALUES (53, 1, 2, 6, 0);
INSERT INTO `cmrestrict3` VALUES (54, 2, 2, 6, 0);
INSERT INTO `cmrestrict3` VALUES (55, 1, 3, 6, 0);
INSERT INTO `cmrestrict3` VALUES (56, 2, 3, 6, 0);
INSERT INTO `cmrestrict3` VALUES (57, 1, 4, 6, 1);
INSERT INTO `cmrestrict3` VALUES (58, 2, 4, 6, 0);
INSERT INTO `cmrestrict3` VALUES (59, 1, 5, 6, 0);
INSERT INTO `cmrestrict3` VALUES (60, 2, 5, 6, 0);

# --------------------------------------------------------

#
# Estructura de tabla para la tabla `cmsynd3`
#

DROP TABLE IF EXISTS `cmsynd3`;
CREATE TABLE `cmsynd3` (
  `ID` int(8) NOT NULL auto_increment,
  `cmdb_type` varchar(10) default NULL,
  `cmdb_uri` varchar(255) default NULL,
  `cmdb_title` varchar(255) default NULL,
  `cmdb_owner_user` varchar(20) default NULL,
  `cmdb_date_creation` varchar(20) default NULL,
  `cmdb_date_update` varchar(20) default NULL,
  `cmdb_ttl` int(11) default NULL,
  `cmdb_autodl` int(11) default NULL,
  `cmdb_inhome` int(11) default NULL,
  `cmdb_visitems` int(11) default NULL,
  `cmdb_content` text,
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Volcar la base de datos para la tabla `cmsynd3`
#

# --------------------------------------------------------

#
# Estructura de tabla para la tabla `content3`
#

DROP TABLE IF EXISTS `content3`;
CREATE TABLE `content3` (
  `ID` int(8) NOT NULL auto_increment,
  `cmdb_type` varchar(10) default NULL,
  `cmdb_directory` varchar(255) default NULL,
  `cmdb_parentdir` varchar(255) default NULL,
  `cmdb_title` varchar(255) default NULL,
  `cmdb_author_user` varchar(20) default NULL,
  `cmdb_author_group` varchar(20) default NULL,
  `cmdb_owner_user` varchar(20) default NULL,
  `cmdb_owner_group` varchar(20) default NULL,
  `cmdb_viewer_user` varchar(20) default NULL,
  `cmdb_viewer_group` varchar(20) default NULL,
  `cmdb_date_start` varchar(20) default NULL,
  `cmdb_date_finish` varchar(20) default NULL,
  `cmdb_date_creation` varchar(20) default NULL,
  `cmdb_date_update` varchar(20) default NULL,
  `cmdb_keywords` text,
  `cmdb_abstract` text,
  `cmdb_content` text,
  `cmdb_rated` int(11) default NULL,
  `cmdb_commented` int(11) default NULL,
  `cmdb_short_title` varchar(20) default NULL,
  `cmdb_logo` varchar(255) default NULL,
  `cmdb_version` int(11) default NULL,
  `cmdb_sign` varchar(255) default NULL,
  `cmdb_enable_html` int(11) default NULL,
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Volcar la base de datos para la tabla `content3`
#


Report this post
Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 7 posts ] 

All times are UTC - 7 hours


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group