1
kurak_bu
In which table are the module preferences keept ?
  • 2007/6/7 10:09

  • kurak_bu

  • Quite a regular

  • Posts: 342

  • Since: 2005/9/5 1


Hello, my admin panel had broken down, and I would like to change some things from preferences of module (for example news) directly form phpMyAdmin, I cant find the MySQL table that keeps this informations. What's the name of this table ?

2
stefan88
Re: In which table are the module preferences keept ?
  • 2007/6/7 10:47

  • stefan88

  • Community Support Member

  • Posts: 1086

  • Since: 2004/9/20


Hi,

PREFIX_configoption table where PREFIX is the prefix from installation ...
..

3
kurak_bu
Re: In which table are the module preferences keept ?
  • 2007/6/7 11:17

  • kurak_bu

  • Quite a regular

  • Posts: 342

  • Since: 2005/9/5 1


Here are my tables, I can't see it

[prefix]_articles_cat
[prefix]_articles_main
[prefix]_articles_rating
[prefix]_avatar
[prefix]_avatar_user_link
[prefix]_banner
[prefix]_bannerclient
[prefix]_bannerfinish
[prefix]_bb_archive
[prefix]_bb_attachments
[prefix]_bb_categories
[prefix]_bb_digest
[prefix]_bb_forums
[prefix]_bb_moderates
[prefix]_bb_online
[prefix]_bb_posts
[prefix]_bb_posts_text
[prefix]_bb_reads_forum
[prefix]_bb_reads_topic
[prefix]_bb_report
[prefix]_bb_topics
[prefix]_bb_votedata
[prefix]_block_module_link
[prefix]_config
[prefix]_configcategory
[prefix]_groups
[prefix]_groups_users_link
[prefix]_group_permission
[prefix]_image
[prefix]_imagebody
[prefix]_imagecategory
[prefix]_imgset
[prefix]_imgsetimg
[prefix]_imgset_tplset_link
[prefix]_iptoc
[prefix]_mgo_go2_go2
[prefix]_mgo_sec_section
[prefix]_modules
[prefix]_myalbum_cat
[prefix]_myalbum_photos
[prefix]_myalbum_text
[prefix]_myalbum_votedata
[prefix]_mydownloads_broken
[prefix]_mydownloads_cat
[prefix]_mydownloads_downloads
[prefix]_mydownloads_mod
[prefix]_mydownloads_text
[prefix]_mydownloads_votedata
[prefix]_mylinks_broken
[prefix]_mylinks_cat
[prefix]_mylinks_links
[prefix]_mylinks_mod
[prefix]_mylinks_text
[prefix]_mylinks_votedata
[prefix]_newblocks
[prefix]_online
[prefix]_priv_msgs
[prefix]_protector_access
[prefix]_protector_log
[prefix]_ranks
[prefix]_session
[prefix]_smartfaq_answers
[prefix]_smartfaq_categories
[prefix]_smartfaq_faq
[prefix]_smiles
[prefix]_stories
[prefix]_stories_files
[prefix]_stories_votedata
[prefix]_topics
[prefix]_tplfile
[prefix]_tplset
[prefix]_tplsource
[prefix]_users
[prefix]_wfschannel
[prefix]_wfslinktous
[prefix]_wfsrefer
[prefix]_xoopscomments
[prefix]_xoopsnotifications
[prefix]_xoopspoll_desc
[prefix]_xoopspoll_log
[prefix]_xoopspoll_option


hm...I think now I know why my admin panel is broken:
Here is my thread about it


So I need to re-create table configoption...but what next ?
Do I need to reinstall XOOPS to back admin panel to work ?

4
stefan88
Re: In which table are the module preferences keept ?
  • 2007/6/7 11:34

  • stefan88

  • Community Support Member

  • Posts: 1086

  • Since: 2004/9/20


Hi,

the actual settings are in prefix_config.
configoption holds the possible values. Maybe you can recreate it by making local copy of XOOPS and installing modules in the same order ...
..

5
kurak_bu
Re: In which table are the module preferences keept ?
  • 2007/6/7 13:43

  • kurak_bu

  • Quite a regular

  • Posts: 342

  • Since: 2005/9/5 1


now im doing like this:
-mysql dump of module table (mylinks, news, ...)
-uninstall module
-install again
-update db from back-up

Login

Who's Online

286 user(s) are online (47 user(s) are browsing Support Forums)


Members: 0


Guests: 286


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Sep 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits