[ egroupware-Support Requests-1295589 ] table phpgw_async not installed

Support Requests item #1295589, was opened at 2005-09-19 12:28
Message generated for change (Comment added) made by wanonyme
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=554339&aid=1295589&group_id=78745

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: setup
Group: 1.0.0 release branch
Status: Open
Priority: 5
Submitted By: Gerrit van Maarleveld (restrive)
Assigned to: Nobody/Anonymous (nobody)
Summary: table phpgw_async not installed

Initial Comment:
Hi

I receive the following error message when login into
egroupware

Database error: Invalid SQL: SELECT * FROM phpgw_async
WHERE
id=’##last-check-run##'
mysql Error: 1146 (Table 'egroupware.phpgw_async’
doesn’t exist)

File:
/var/www/egroupware/phpgwapi/inc/class.asyncservice.inc.php
Line: 484
Function: asyncservice::read /
asyncservice::last_check_run /
asyncservice::check_run / execmethod / common::phpgw_final

Session halted.

When installing egroupware it gives a long message
stating that it cannot create the table phpgw_async
event trying to upgrade after upgrading the database
egroupware allows me to enter but gives the error
message above I troed this on 2 seperate installations

The table could be crated manually but I don’t have the
fields

The version I installed is 1.0.0.009-2 downloaded
yesterday and was a clean installation
The process i repeated several times cleaning the
system and database and egroupware and re-installing again

I use php 4.4
mysql 5
debian os testing version
kernel 2.6.4

I have some suggestions to for egroupware where do I go to

Can I download a complete manual somewhere

Thx for your assistance

Gerrit van Maarleveld


Comment By: wan (wanonyme)

Message:
Logged In: YES
user_id=1051244

I had the same problem.
I found this:

CREATE TABLE phpgw_async (
id varchar(255) NOT NULL,
next int NOT NULL,
times varchar(255) NOT NULL,
method varchar(80) NOT NULL,
data text NOT NULL,
account_id int NOT NULL DEFAULT 0,
PRIMARY KEY NONCLUSTERED (id)
);

It seems to have worked for me. Hope this helps.


You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=554339&aid=1295589&group_id=78745


SF.Net email is sponsored by:
Tame your development challenges with Apache’s Geronimo App Server. Download
it for free - -and be entered to win a 42" plasma tv or your very own
Sony™PSP. Click here to play: http://sourceforge.net/geronimo.php


eGroupWare-tracker mailing list
eGroupWare-tracker@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-tracker