bugphpGroupWare - Bugs: bug #20934, Several MySQL Tables missing

 
 

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

bug #20934: Several MySQL Tables missing

Submitter:  Matthias Stock <flashgordon>
Submitted:  Wed 29 Aug 2007 11:54:07 PM UTC
   
 
Category:  None Item Group:  0.9.16.012
Severity:  3 - Normal Priority:  6
Status:  Need Info Privacy:  Public
Assigned to:  None Open/Closed:  Open
Component Version:  ZIP Operating System:  None
Reproducibility:  Every Time Planned Release:  None
Fixed Release: 

Wed 05 Sep 2007 11:57:51 AM UTC, comment #1: 

Hi Matthias,

HUm, the table name is weird : "mstock_phpgroupware" ... try looking if the setup is not modified to add a prefix somewhere ... and perhaps try to grep the files to check where this mstock_phpgroupware is defined.

Regards,

Caeies.

Caeies <Caeies>
Group administrator
Wed 29 Aug 2007 11:54:07 PM UTC, original submission:  

After I let phpGroupWare create the tables in my DB it said:

- - - begin - - -
Es sieht so aus als benutzen Sie Version 0.9.16.000 von phpGroupWare.
Wir werden Ihre Tabellen/Einträge automatisch zu 0.9.16.012 aktualisieren [...]"
- - - end - - -
(You are using phpGroupWare 0.9.16.000, we'll update the tables to 0.9.16.012)

I let it update my tables and after I tried to create the admin account I got this error:
- - - begin - - -
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 'mstock_phpgroupware.phpgw_contact_comm_descr' doesn't exist)

File: /var/www/vhosts/mstock.de/httpdocs/tools/phpgroupware/phpgwapi/inc/class.contacts_sql.inc.php
Line: 1426

Session halted.
- - - end - - -


Here's a list of the created tables (140):
- - - begin - - -
newsgroups
news_msg
phpgw_access_log
phpgw_accounts
phpgw_acl
phpgw_anglemail
phpgw_applications
phpgw_app_sessions
phpgw_bookmarks
phpgw_cal
phpgw_cal_extra
phpgw_cal_holidays
phpgw_cal_repeats
phpgw_cal_user
phpgw_chat_channel
phpgw_chat_currentin
phpgw_chat_messages
phpgw_chat_privatechat
phpgw_chora_sites
phpgw_comic
phpgw_comic_admin
phpgw_comic_data
phpgw_config
phpgw_dj_directories
phpgw_dj_que
phpgw_dj_shows
phpgw_dj_songlist
phpgw_eldaptir_schema
phpgw_eldaptir_servers
phpgw_etemplate
phpgw_forum_body
phpgw_forum_categories
phpgw_forum_forums
phpgw_forum_threads
phpgw_fud_action_log
phpgw_fud_announce
phpgw_fud_ann_forums
phpgw_fud_attach
phpgw_fud_avatar
phpgw_fud_blocked_logins
phpgw_fud_buddy
phpgw_fud_cat
phpgw_fud_custom_tags
phpgw_fud_email_block
phpgw_fud_ext_block
phpgw_fud_fc_view
phpgw_fud_forum
phpgw_fud_forum_notify
phpgw_fud_forum_read
phpgw_fud_groups
phpgw_fud_group_cache
phpgw_fud_group_members
phpgw_fud_group_resources
phpgw_fud_index
phpgw_fud_ip_block
phpgw_fud_level
phpgw_fud_mime
phpgw_fud_mlist
phpgw_fud_mod
phpgw_fud_mod_que
phpgw_fud_msg
phpgw_fud_msg_report
phpgw_fud_nntp
phpgw_fud_pmsg
phpgw_fud_poll
phpgw_fud_poll_opt
phpgw_fud_poll_opt_track
phpgw_fud_read
phpgw_fud_replace
phpgw_fud_search
phpgw_fud_search_cache
phpgw_fud_ses
phpgw_fud_smiley
phpgw_fud_stats_cache
phpgw_fud_themes
phpgw_fud_thread
phpgw_fud_thread_notify
phpgw_fud_thread_rate_track
phpgw_fud_thread_view
phpgw_fud_thr_exchange
phpgw_fud_title_index
phpgw_fud_user_ignore
phpgw_headlines_cached
phpgw_headlines_sites
phpgw_hooks
phpgw_img
phpgw_infolog
phpgw_infolog_extra
phpgw_javassh_servers
phpgw_kb_comment
phpgw_kb_faq
phpgw_kb_questions
phpgw_languages
phpgw_links
phpgw_messenger_messages
phpgw_news
phpgw_news_export
phpgw_notes
phpgw_polls_data
phpgw_polls_desc
phpgw_polls_settings
phpgw_polls_user
phpgw_preferences
phpgw_p_activities
phpgw_p_delivery
phpgw_p_deliverypos
phpgw_p_hours
phpgw_p_invoice
phpgw_p_invoicepos
phpgw_p_mstones
phpgw_p_pcosts
phpgw_p_projectactivities
phpgw_p_projectmembers
phpgw_p_projects
phpgw_qmailldap
phpgw_reg_accounts
phpgw_reg_fields
phpgw_sessions
phpgw_sitemgr_active_modules
phpgw_sitemgr_blocks
phpgw_sitemgr_blocks_lang
phpgw_sitemgr_categories_lang
phpgw_sitemgr_categories_state
phpgw_sitemgr_content
phpgw_sitemgr_content_lang
phpgw_sitemgr_modules
phpgw_sitemgr_pages
phpgw_sitemgr_pages_lang
phpgw_sitemgr_properties
phpgw_sitemgr_sites
phpgw_skel
phpgw_todo
phpgw_tts_tickets
phpgw_tts_views
phpgw_wiki_interwiki
phpgw_wiki_links
phpgw_wiki_pages
phpgw_wiki_rate
phpgw_wiki_remote_pages
phpgw_wiki_sisterwiki
- - - end - - -

Perhaps, my webspace limits this? I haven't tried to install it via XAMPP yet.

Matthias Stock <flashgordon>

 

(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

 

Carbon-Copy List
  • -email is unavailable- added by Caeies (Posted a comment)
  • -email is unavailable- added by flashgordon (Submitted the item)
  •  

    There are 0 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 2 latest changes.

    Date Changed by Updated Field Previous Value => Replaced by
    2007-09-05 Caeies Item GroupNone 0.9.16.012
        StatusNone Need Info

    Back to the top

    Powered by Savane 3.13-3230.
    Corresponding source code