bugphpGroupWare - Bugs: bug #15660, Installation procedure fails to...

 
 

You are not allowed to post comments on this tracker with your current authentication level.

bug #15660: Installation procedure fails to create all tables

Submitter:  Pascal Dupuis <cdemills>
Submitted:  Wed 08 Feb 2006 01:56:21 PM UTC
Votes: 101
 
Category:  None Item Group:  None
Severity:  3 - Normal Priority:  6
Status:  Invalid Privacy:  Public
Assigned to:  skwashd Open/Closed:  Closed
Component Version:  DEB Operating System:  GNU/Linux - Debian
Reproducibility:  Every Time Planned Release:  None
Fixed Release: 

Jump to the original submission

Thu 14 Sep 2006 12:15:02 PM UTC, comment #7: 

It was fixed in cvs well before the  0.9.16.011 release, it just took some time for us to do the release.

Dave Hall <skwashd>
Group administrator
Thu 14 Sep 2006 12:12:37 PM UTC, comment #6: 

FYI Debian's unstable packages of 0.9.16.011 seem to have corrected these issues, AFAICT

Olivier Berger <olberger>
Mon 17 Jul 2006 11:30:12 AM UTC, comment #5: 

note 0.9.16.010 with a cvs update supports mysql 5

Dave Hall <skwashd>
Group administrator
Fri 10 Feb 2006 09:17:02 AM UTC, comment #4: 

mysql 5 is not supported by phpgw 0.9.16.  It should be supported in 0.9.18

Dave Hall <skwashd>
Group administrator
Fri 10 Feb 2006 01:34:04 AM UTC, comment #3: 

By downgrading to MySQL 4.1 The issue was fixed.

Grant Thomas <gthomas>
Fri 10 Feb 2006 01:31:15 AM UTC, comment #2: 

I am having the same issue:

I have tried the Debian packages, as well as the tarball provided by phpgroupware.org

The error I get is:

Database error: Invalid SQL: SELECT contact_comm_descr.comm_descr_id AS comm_descr_id, contact_comm_descr.descr AS comm_description, contact_comm_descr.comm_type_id AS comm_type FROM phpgw_contact_comm_descr AS contact_comm_descr
MySQL Error: 1146 (Table 'phpgroupware.phpgw_contact_comm_descr' doesn't exist)

File: /var/www/phpgroupware/phpgwapi/inc/class.contacts_sql.inc.php
Line: 1426

platform:
i386 linux, kernel 2.6.12 debian etch
Apache 2
php4
mysql 5.0.16

HOWEVER

By downgrading to MySQL

Grant Thomas <gthomas>
Wed 08 Feb 2006 09:58:31 PM UTC, comment #1: 

I got the same problem!
it's not even possible to create an admin account!

maybe the problem is that we both run MySQL 5 - i had many problems with my own scripts after the upate, too.

my config:
WinXP SP2
Apache 2.2.0
MySQL 5.0.18
PHP 5.1.1

Claudius Hagen <jch2k>
Wed 08 Feb 2006 01:56:21 PM UTC, original submission:  

Hello,

I installed phpgroupware from the deb packages. After the setup steps, I went to http://localhost/phpgroupware/setup, logged in, and created the tables. Afterward, I went to http://localhost/phpgroupware/,and then got:
Database error: lock(phpgw_async, write) failed.
MySQL Error: 1146 (Table 'phpgroupware.phpgw_async' doesn't exist)

If I follow the script /usr/share/phpgroupware/phpgwapi/setup/tables_current.inc.php,
each table up to line 329 (phpgw_vfs) is created, all the rest is (phpgw_history_log, phpgw_async, phpgw_contact, ...). I tried a few times, deleting the DB and re-generating one. I also modified php4.ini as explained in the Readme

Is it a known problem ? Is there a simple fix ?

Platform:
- i386 linux, kernel 2.6.15, debian etch
- Apache/2.0.55
- php4: 4.4.2
- mysql Distrib 5.0.18

TIA

CdM

Pascal Dupuis <cdemills>

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

There are 101 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

 

Follow 5 latest changes.

Date Changed by Updated Field Previous Value => Replaced by
2006-02-10 skwashd StatusNone Invalid
    Assigned toNone skwashd
    Open/ClosedOpen Closed
2006-02-10 gthomas Carbon-Copy- Added gthomas
2006-02-08 jch2k Carbon-Copy- Added jch2k

Back to the top

Powered by Savane 3.13-f8d8.
Corresponding source code