Missing tables in database

[Mike-352]

Hello,
just installing the act. version on debian, php4, mysql.
installation works, but langueage-config is not possible.

The login, creating the admin+demo-users failed, because the scripts referring to table "lang".
Setup creates the tabel "language".

So I insert a new table with the correct name, but also the fieldnames changed.
So, language-Setup is not possible.
Logging into the application brings:

Database error: Invalid SQL: select message_id,content from phpgw_lang where lang = 'en' and (app_name = 'login' or app_name = 'common' or app_name = 'all') order by app_name asc
MySQL Error: 1054 (Unknown column 'message_id' in 'field list')

File: /.../phpgwapi/inc/class.translation_sql.inc.php
Line: 63
Session halted. Database error: lock(phpgw_async, write) failed.
MySQL Error: 1146 (Table 'db2030v03.phpgw_async' doesn't exist)

Session halted.

So, login is also not possible.

Is there anything I made wrong (I dont think so, but maybe...) or is the install-tableau not correct ?

Thanks for help.
Mike
Sent from the phpGroupWare forums @ http://forums.phpGroupWare.org


_______________________________________________
phpGroupWare-users mailing list
phpGroupWare-users@...
http://lists.gnu.org/mailman/listinfo/phpgroupware-users

[Chris Weiss-2]

On 8/7/07, Mike wrote:
> Hello,
> just installing the act. version on debian, php4, mysql.
> installation works, but langueage-config is not possible.

what's an "act." version? you might want to try the nightly debs from
our downloads section, they are of the "stable" branch and should be
as stable, if not more, than our releases.


_______________________________________________
phpGroupWare-users mailing list
phpGroupWare-users@...
http://lists.gnu.org/mailman/listinfo/phpgroupware-users

[Mike-352]

I'm using the 0.9.16.005.
This is not a server problem, the scripts try to use fields in database that are not existing.

The table created by install-routine is called "language", the table needed by the scripts is called "lang".

Sent from the phpGroupWare forums @ http://forums.phpGroupWare.org


_______________________________________________
phpGroupWare-users mailing list
phpGroupWare-users@...
http://lists.gnu.org/mailman/listinfo/phpgroupware-users

[Chris Weiss-2]

On 8/8/07, Mike wrote:
> I'm using the 0.9.16.005.

that's pretty old and has some serious security issues from 3rd part
libs we used.  current is 0.9.16.011

> The table created by install-routine is called "language", the table needed by the scripts is called "lang".

i understand that, but I don't know what this"via" is that you speak
of.  maybe you have an unofficial build that was done incorrectly?

since you are using debian, you can use our repo and be current all
the time.  details at http://download.phpgroupware.org/debs


_______________________________________________
phpGroupWare-users mailing list
phpGroupWare-users@...
http://lists.gnu.org/mailman/listinfo/phpgroupware-users

[Mike-352]

ok.
the 0.9.15 was a typing error of mine. I corrected these mistake, but maybe after your posting.

I download the "act" version 0.9.16.011 from this website via sorceforge.
I prepared webserver (debian AND also Suse 10) like described in manual (php.ini, permissions, mysql-database, apache).
Then I start http:/domain_to_prog/setup

Step 1: Header Setup: works without problems, file written
Step 2: Prog setup
   Item 1: Installation: works fine
   Item 2: Configuration: works fine, all datas correct
   Item 3: choose language de, option 3: add phrases
           no error message, but also no green symbol
   Item 4: Installing/deinstalling modules: works fine, except
           fud-forum: there appear a lot of db failures
Step 3: Creating Admin-User and Demo-accounts
        failed - db failures

Then I goto to login-page http://domain_to_prog -> login.php ->
error messages, no login possible (most of messages concern language/lang.

Same result on both servers (debian, suse). Using php 5.1 (suse) and php 4.3 (suse).

So I really don't know, what I can do. The software refferes to tables that are during setup-procedure not created.

I tried also older versions, same result (on debian, suse not tried).

If I use the wrong version, can you give me a direct link to location where the "correct" versions can be found ?

Thanks.
Mike
Sent from the phpGroupWare forums @ http://forums.phpGroupWare.org


_______________________________________________
phpGroupWare-users mailing list
phpGroupWare-users@...
http://lists.gnu.org/mailman/listinfo/phpgroupware-users

[Chris Weiss-2]

On 8/9/07, Mike  wrote:
> ok.
> the 0.9.15 was a typing error of mine. I corrected these mistake, but maybe after your posting.

I'm replying on the mailing list, which is sync'd with the forum.
edits do not get sent to the list.

> I download the "act" version 0.9.16.011 from this website via sorceforge.

I still don't see "act", but he 0.9.16.011 from sf.net should be fine.

> Step 1: Header Setup: works without problems, file written
> Step 2: Prog setup
>    Item 1: Installation: works fine
>    Item 2: Configuration: works fine, all datas correct
>    Item 3: choose language de, option 3: add phrases
>            no error message, but also no green symbol
>    Item 4: Installing/deinstalling modules: works fine, except
>            fud-forum: there appear a lot of db failures
> Step 3: Creating Admin-User and Demo-accounts
>         failed - db failures

what db failures.  phpgroupware.org download section has an install
howto, maybe a prerequisite or a mysql permissions issue?

> So I really don't know, what I can do. The software refferes to tables that are during setup-procedure not created.
>

One of our policies for a "dot" release of the stable version is that
there are no database changes allowed, except where security is
concerned and a table name change would not be a solution to a
security issue.  I don't think it's possible that after 11 dot
releases that the table would suddenly change names and no one notice.
 something else is at play here.


_______________________________________________
phpGroupWare-users mailing list
phpGroupWare-users@...
http://lists.gnu.org/mailman/listinfo/phpgroupware-users

[Mike-352]

act = actual.

http://domain_to_prog/setup

item 1: works
item 2: (config) works
item 2: Link Hier clicken to setup an admin account and (optionally) 3 demo accounts.* ->
form appears, after filling in datas (adminname, pw, login) ->

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 'db2030v03.phpgw_contact_comm_descr' doesn't exist)

File: /path_to_webroot/phpgwapi/inc/class.contacts_sql.inc.php
Line: 1426
Session halted.

item 3: language setup
-> selecting de, option: add phrases ->
nothing happened, no green hook, only red X

item 4: deinstalling any module (e.g. notes) -> save ->

Notes Tabellen wurden gelöscht.
Notes nicht registriert.
Notes Haken nicht mehr aktiv.Database error: Invalid SQL: SELECT COUNT(message_id) FROM phpgw_lang WHERE app_name='notes'
MySQL Error: 1146 (Table 'db2030v03.phpgw_lang' doesn't exist)

File: /path_to_webroot/phpgwapi/inc/class.setup_translation.inc.php
Line: 149Database error: next_record called with no query pending.

Notes Übersetzungen entfernt.

leaving setup, going to LOGIN-screen:
http://domain_to_prog (calls: /login.php
->
Database error: Invalid SQL: select message_id,content from phpgw_lang where lang = 'en' and (app_name = 'login' or app_name = 'common' or app_name = 'all') order by app_name asc
MySQL Error: 1146 (Table 'db2030v03.phpgw_lang' doesn't exist)

File: /path_to_webroot/phpgwapi/inc/class.translation_sql.inc.php
Line: 63
Session halted. Database error: lock(phpgw_async, write) failed.
MySQL Error: 1146 (Table 'db2030v03.phpgw_async' doesn't exist)


Session halted.

Database correct, rights and settings ok.
tried installation totally as root of server, same results.

When I go by phpMyAdmin into the database, the tables (marked in the error-messages) are really not existing.

Totally I have 140 tables in the db.

Just now I tried a local installation (win xp pro with xampp, under Administrator).
I got the same error-messages, installation also not complete performed.

what - the hell - is going wrong in this case ?
which php-script handles the creation of db ?
I made a full-text-search upon the phrase "create table" over all files. I got several hits, but in alll files only some module-specific tables are created.

On webserver I also installed as root, give 0777 permission to all files, checked access to mysql-db - and the result is equal.

.....
Mike


Sent from the phpGroupWare forums @ http://forums.phpGroupWare.org


_______________________________________________
phpGroupWare-users mailing list
phpGroupWare-users@...
http://lists.gnu.org/mailman/listinfo/phpgroupware-users

[Chris Weiss-2]

I have no idea how step 1 can not give errors and also not create these tables.

> MySQL Error: 1146 (Table 'db2030v03.phpgw_contact_comm_descr' doesn't exist)
> MySQL Error: 1146 (Table 'db2030v03.phpgw_lang' doesn't exist)


_______________________________________________
phpGroupWare-users mailing list
phpGroupWare-users@...
http://lists.gnu.org/mailman/listinfo/phpgroupware-users

[Mike-352]

I don't believe this is an error in the script(s). If so these kinds of errors should occure more often.
So there must be one or more common situations on three different hardwares.

In which user-group the software is running ?
a linux-specific (e.g. default, root), under the same as apache runs ? Under which privileges the access on mysql-db is performed ?
Is there any environment-limit at mysql that can be a problem for phpgw ?

Sent from the phpGroupWare forums @ http://forums.phpGroupWare.org


_______________________________________________
phpGroupWare-users mailing list
phpGroupWare-users@...
http://lists.gnu.org/mailman/listinfo/phpgroupware-users

[Chris Weiss-2]

On 8/9/07, Mike wrote:
> In which user-group the software is running ?

apache "runs", that's the user, whatever it uses.  as long as that
user can read the files, it will work.

> a linux-specific (e.g. default, root), under the same as apache runs ? Under which privileges the access on mysql-db is performed ?

we are not linux nor path specific, mysql needs GRANT ALL permissions,
including the LOCK which many host panels don't grant by default.

> Is there any environment-limit at mysql that can be a problem for phpgw ?

sometimes the latest and greatest changes syntax and that can be a problem.


_______________________________________________
phpGroupWare-users mailing list
phpGroupWare-users@...
http://lists.gnu.org/mailman/listinfo/phpgroupware-users

[Gene Floyd]

Hi, I am having the same issue. When I try to go to the main page, I get

Database error: Invalid SQL: select message_id,content from phpgw_lang where lang = 'en' and (app_name = 'login' or app_name = 'common' or app_name = 'all') order by app_name asc
MySQL Error: 1146 (Table 'phpgroupwaretlh.phpgw_lang' doesn't exist)

File:  /home/content/f/l/o/floridacyclist/html/phpgroupware/phpgwapi/inc/clas s.translation_sql.inc.php
Line: 63
Session halted. Database error: lock(phpgw_async, write) failed.
MySQL Error: 1146 (Table 'phpgroupwaretlh.phpgw_async' doesn't exist)


Session halted.

Additionally, it will not let me install any languages. I can select English and Spanish and choose "Only add new phrases" and it will behave, but it will still have the red X where the green check should be. If I choose delete all or install languages not in database, I get a similar error message reading:

Database error: Invalid SQL: SELECT COUNT(*) FROM phpgw_lang WHERE lang='en'
MySQL Error: 1146 (Table 'phpgroupwaretlh.phpgw_lang' doesn't exist)

File: /home/content/f/l/o/floridacyclist/html/phpgroupware/setup/lang.php
Line: 81
Session halted.
Fatal error: Call to a member function on a non-object in  /home/content/f/l/o/floridacyclist/html/phpgroupware/phpgwapi/inc/clas s.db_mysql.inc.php on line 561

Thoughts?Sent from the phpGroupWare forums @ http://forums.phpGroupWare.org


_______________________________________________
phpGroupWare-users mailing list
phpGroupWare-users@...
http://lists.gnu.org/mailman/listinfo/phpgroupware-users

[Mike-352]

Hello,

many hours and tons of documents later I am able to install the version.
In fact, in operation there are some bugs in some modules, but this I think is related to the early release (<1.0) of the software.

Maybe these hints will help you to install phpgw without the database errors:

I don't know, which environment you are using, so maybe some of the hints are not fitting your needs.

1. You should follow exactly the installation procedure beginnen with download. If possible, download the newest version directly from your webserver (console login, wget http://prdownloads.sourceforge.net/phpgroupware/phpgroupware-0.9.16.011.tar.gz).
If not possible, download from this link to your local pc.
After that unzip the package by using the original folder-structure.

2. Make the cvs-update.
I tried on local windows-machines, but its not really working. For that on webserver in works without problem.

Go into main-folder of extracted files and call
a) export CVS_RSH=ssh
b) cvs -z6 update -dP > cvs.log

3. This will update all files in the folder-structure.
4. Copy the files to the destination (where the webserver can access).
5. Create a folder /files somewhere outside the apache-access.
This is on hosting-platform a little bit tricky, because mostly nobody knows about the restrictions of apache.
I place it directly under root and give right-permission 777.

6. Change your httpd.conf-files of apache (or on vhost-environment the vhost.conf). The open_basedir-statement should be expanded with :/files (e.g. open_basedir /folder1:/tmp:/files)

7. Restart apache webserver

8. Change temporaly rights of web-basedir to 777 (mostly for apache /domain/httpdocs (or s.th. like this).

9. Now the most important part: the SQL-preparation.
Most admin-tools like plesk, confixx, webmin don't grant full rights to db-users. So this step must be performed directly on server, if the admin-tool didn't allow this action.

Caution: using plesk or confixx: the db-Master-Admin is renamed by these tools from root to admin !
You need the admin-password for sql for these steps
(plesk: the same like plesk-login, confixx: mostly root-password, otherwise: root-password or dedicated sql-root-password).

For mySql:
a) mysqladmin -u admin -p create NAMEOFYOURDATABASE
(maybe you must enter the sql-admin-pw now)

b) mysql -u root -p (login to mysql-admin)
(password)
> grant all on NAMEOFYOURDATABASE.* to mailto:GIVEAUSERNAME@localhost identified by "DEFINE_A_PW_FOR_USERNAME";
> exit

Caution: the GIVEAUSERNAME should not contain a minus-sign (causes problems).

The datas GIVEAUSERNAME, NAMEOFYOURDATABASE and PW_FOR_USER you need later for login.

10. Now you are ready.
Call in browser http://domain_of_installation/setup
(important: cookies should be enalbled for the whole session).

Now follows the header-config. Fill in all datas and then after writing that file you come back to config-login-screen.

Login as phpgw-admin (pw given in header-config).
1st Step: Installation of Modules (item 1).
This should now work without errors. After finish make confirmation and go to

2nd Step: Configuration (item 2)
There you configure needed parameters
Best results, if you after finishing this click "Demo-user-install". Choose here a admin - users not necessary, you can make own useres after login to phpgw).

3rd Step: Language
go in, choose the additional languages and perform "add phrases"

4th Step: modules
install/deinstall your needed modules

After that, go back to config-screen and choose link "back to phpgw".
There you log in as admin (from demo-user-installation).
Define a own admin and own user(s) and work.

Hope this instructions can help you and you need not lot of hours of reading docs in internet.

Mike




 

Sent from the phpGroupWare forums @ http://forums.phpGroupWare.org


_______________________________________________
phpGroupWare-users mailing list
phpGroupWare-users@...
http://lists.gnu.org/mailman/listinfo/phpgroupware-users

[Gene Floyd]

OK, it sounds like we're supposed to be running this on our own server. I have a host and as far as I know, I can not get shell access. Is there a work-around for this?

I did find out where I can go into the database and create tables manually....could I make one called lang? How many fields would I give it? I am still trying to find out how to get full/lock access to the database; according to the docs for MySql, locked_in_memory is disabled on godaddy.com. Is this what needs to be accessed? is that only needed for setup and is there a workaround for it? Any help or info would be greatly appreciated.Sent from the phpGroupWare forums @ http://forums.phpGroupWare.org


_______________________________________________
phpGroupWare-users mailing list
phpGroupWare-users@...
http://lists.gnu.org/mailman/listinfo/phpgroupware-users

[Mike-352]

the shell-access is only needed for sql.
downloading, unzipping the files can be done locally. the transfer to web-location via ftp.
changing permission for web-root temp. to 777 can be also done via ftp.
i don't know which environment (os, apache, sql, php) you are using, also good info is what kind of management-tool (plesk, confixx or whatever) you are using.

if you can create a whole database manually with full-grant-rights to this, then the problem should not occure.

in my case creating the missing tables manually and inserting the datas has no positive result. latest on login there are other tables missing or other fieldnames in existing tables recommented.

I think, creation-process of tables in db needs this full permissions (e.g. for locking db or what else).

so, if you can assign sql-admin-rights to the new database (spec. the dedicated user for this db) it should work.

maybe it helps if you post more informations about your environment on webserver.

mike
Sent from the phpGroupWare forums @ http://forums.phpGroupWare.org


_______________________________________________
phpGroupWare-users mailing list
phpGroupWare-users@...
http://lists.gnu.org/mailman/listinfo/phpgroupware-users

[Gene Floyd]

Apache 1.3, kernel 2.4.21-401elsmp

Godaddy tech support says that it is not possible to grant lock priviledges on a shared hosting account.

It seems odd that it would have trouble creating one or two tables without special priviledges after it's created hundreds of others.

I can set up a test account for you if this will help with troubleshootingSent from the phpGroupWare forums @ http://forums.phpGroupWare.org


_______________________________________________
phpGroupWare-users mailing list
phpGroupWare-users@...
http://lists.gnu.org/mailman/listinfo/phpgroupware-users

[Chris Weiss-2]

On 8/12/07, Mike wrote:
> the shell-access is only needed for sql.

actualy, for mysql the setup can do this for you too, there are fields
to fill in the root/admin login and the wanted username and database
specified in the header management will be created.  this is also all
explained in the install howto on the download page, including
everything from your previous post.  you've basically made a summary
of the howto.

> maybe it helps if you post more informations about your environment on webserver.

for one, i don't use shared hosting.  don't trust them personally and
I can afford better, lucky me I guess.  however, we have made an
effort to work on shared hosting, but not all shared hosts know how to
properly manage a php/mysql based web stack so they won't support
phpgw.  case in point are those don't allow LOCK permissions, for some
unknown reason they think that you locking a table can somehow lock
out the whole server which is just fiction.


_______________________________________________
phpGroupWare-users mailing list
phpGroupWare-users@...
http://lists.gnu.org/mailman/listinfo/phpgroupware-users

[Gene Floyd]

I know i had no trouble creating the database or setting the parameters...just that silly little lang table issue. Yes, it would be nice if we could afford dedicated hosting, but we're called a non-profit for a reason LOL

Gene
www.tallahasseecap.orgSent from the phpGroupWare forums @ http://forums.phpGroupWare.org


_______________________________________________
phpGroupWare-users mailing list
phpGroupWare-users@...
http://lists.gnu.org/mailman/listinfo/phpgroupware-users

[Chris Weiss-2]

On 8/12/07, Gene Floyd wrote:
> Godaddy tech support says that it is not possible to grant lock priviledges on a shared hosting account.

from what I have witnessed,  godaddy is one of the worst hosts out
here.  I've heard tech support horror stories in forums and in irc and
unlike many things no one chimes in to take their side.

> It seems odd that it would have trouble creating one or two tables without special priviledges after it's created hundreds of others.

this does seem odd to me as well, LOCK should not be needed to create
the tables, but will be required for phpgw to operate.  We need LOCK
due to mysql's lack of transaction support using its defaults, not
locking means a chance for inconsistent data.

I'm sure there are better affordable hosts, maybe someone else on the
list can recommend one.


_______________________________________________
phpGroupWare-users mailing list
phpGroupWare-users@...
http://lists.gnu.org/mailman/listinfo/phpgroupware-users

[Chris-615]

I've been following this because I had the same problem. I'm on Dreamhost, one of the most permissive hosts out there. The box I'm on is relatively stable. I'm getting the error:

Database error: Invalid SQL: SELECT COUNT(*) FROM phpgw_lang WHERE lang='en'
MySQL Error: 1146 (Table 'groupware.phpgw_lang' doesn't exist)

File: /home/.name/user/groupware.mydomain.com/phpgroupware/setup/lang.php
Line: 90

Session halted.
Fatal error: Call to a member function on a non-object in /home/.name/user/groupware.mydomain.us/phpgroupware/phpgwapi/inc/class.db_mysql.inc.php on line 561

I followed the directions explicitly. This is after the cvs update and doing all the other install options. Step 3 remains 'red-X'ed.Sent from the phpGroupWare forums @ http://forums.phpGroupWare.org


_______________________________________________
phpGroupWare-users mailing list
phpGroupWare-users@...
http://lists.gnu.org/mailman/listinfo/phpgroupware-users

[rotem-2]

I also have the missing tables.
I saw that because of the DB Collation encoding.

When I set it to "utf8_bin" it have a missing tables, but when I leave it as "latin1_swedish_ci" it seem to work fine,  (but then I can write in hebrew there...  :cry:  )


Rotem.Sent from the phpGroupWare forums @ http://forums.phpGroupWare.org


_______________________________________________
phpGroupWare-users mailing list
phpGroupWare-users@...
http://lists.gnu.org/mailman/listinfo/phpgroupware-users