Jump to content

Phpwebsite Pulling Tables


Recommended Posts

Gidday all,

 

In my early days of installing PHPws and reinstalling and mucking around it turns out that my website is pulling tables from tables that are named things like mod_xxx and mod_mod_xxx.

 

Im wanting to set all table names with the same mod_xxx as there seem to be some contention problems.

 

I tried to just change the names of the mod_mod_xxx tables but when a call is done on the said tables (would now be named mod_xxx) I get an error saying mod_mod_xxx doesnt exist.

 

Im wondering where in PHPws I would go to tell it to just call mod_xxx? Or is there something in my database that instructs on the table name?

 

Hmmmm....

 

Wayne :rolleyes:

Link to post
Share on other sites

I'm not familiar with it wither but I'd say they probably use a table name prefix and simply prepend it to the table names. Try looking on the administration panel, if it has one. If not, try looking in some file called "config.php" or something similar and see if you can find a configuration directive named "table_prefix" or something like that.

Link to post
Share on other sites

Thanx guys for the input.

 

I have a config.php file with "$dbname = "tototon_phpws";

 

$table_prefix = "mod_";" in it.

 

That just gives the prefix for the mod_ tables. Just cant figure out why it points to the mod_mod_ prefix tables but when I change the name of the file back to mod_ it doesnt chase those tables.

 

Thanx again, Wayne

Link to post
Share on other sites

Raul, thats an interesting thought.Possibly correct.

 

Heres a copy of my tables...

 

tototon_phpws  (124)

 

  mod_branch_sites

  mod_cache

  mod_modules

  mod_mod_announce

  mod_mod_announce_seq

  mod_mod_announce_settings

  mod_mod_approval_jobs

  mod_mod_approval_jobs_seq

  mod_mod_blockmaker_data

  mod_mod_blockmaker_data_seq

  mod_mod_boost_version

  mod_mod_calendar_events

  mod_mod_calendar_events_seq

  mod_mod_calendar_repeats

  mod_mod_calendar_settings

  mod_mod_controlpanel_link

  mod_mod_controlpanel_link_seq

  mod_mod_controlpanel_tab

  mod_mod_controlpanel_tab_seq

  mod_mod_documents_docs

  mod_mod_documents_docs_seq

  mod_mod_documents_files

  mod_mod_documents_settings

  mod_mod_dyn_modules

  mod_mod_dyn_modules_seq

  mod_mod_faq_questions

  mod_mod_faq_questions_seq

  mod_mod_faq_settings

  mod_mod_fatcat_categories

  mod_mod_fatcat_categories_seq

  mod_mod_fatcat_elements

  mod_mod_fatcat_elements_seq

  mod_mod_fatcat_settings

  mod_mod_help

  mod_mod_help_reg

  mod_mod_help_reg_seq

  mod_mod_help_seq

  mod_mod_language_settings

  mod_mod_lang_EN

  mod_mod_lang_EN_seq

  mod_mod_layout_box

  mod_mod_layout_box_seq

  mod_mod_layout_config

  mod_mod_linkman_links

  mod_mod_linkman_links_seq

  mod_mod_menuman_items

  mod_mod_menuman_items_seq

  mod_mod_menuman_menus

  mod_mod_menuman_menus_seq

  mod_mod_movie_admin

  mod_mod_movie_portata

  mod_mod_movie_portata_seq

  mod_mod_movie_principale

  mod_mod_movie_principale_seq

  mod_mod_pagemaster_pages

  mod_mod_pagemaster_pages_seq

  mod_mod_pagemaster_sections

  mod_mod_pagemaster_sections_seq

  mod_mod_photoalbum_albums

  mod_mod_photoalbum_albums_seq

  mod_mod_photoalbum_photos

  mod_mod_photoalbum_photos_seq

  mod_mod_photobox_conf

  mod_mod_phpbb_attachments

  mod_mod_phpbb_attachments_config

  mod_mod_phpbb_attachments_desc

  mod_mod_phpbb_attach_quota

  mod_mod_phpbb_auth_access

  mod_mod_phpbb_banlist

  mod_mod_phpbb_categories

  mod_mod_phpbb_config

  mod_mod_phpbb_disallow

  mod_mod_phpbb_extensions

  mod_mod_phpbb_extension_groups

  mod_mod_phpbb_forbidden_extensions

  mod_mod_phpbb_forums

  mod_mod_phpbb_forum_prune

  mod_mod_phpbb_groups

  mod_mod_phpbb_posts

  mod_mod_phpbb_posts_text

  mod_mod_phpbb_privmsgs

  mod_mod_phpbb_privmsgs_text

  mod_mod_phpbb_quota_limits

  mod_mod_phpbb_ranks

  mod_mod_phpbb_search_results

  mod_mod_phpbb_search_wordlist

  mod_mod_phpbb_search_wordmatch

  mod_mod_phpbb_sessions

  mod_mod_phpbb_smilies

  mod_mod_phpbb_themes

  mod_mod_phpbb_themes_name

  mod_mod_phpbb_topics

  mod_mod_phpbb_topics_watch

  mod_mod_phpbb_users

  mod_mod_phpbb_user_group

  mod_mod_phpbb_vote_desc

  mod_mod_phpbb_vote_results

  mod_mod_phpbb_vote_voters

  mod_mod_phpbb_words

  mod_mod_phpwscontacts_contacts

  mod_mod_phpwscontacts_contacts_seq

  mod_mod_phpwscontacts_settings

  mod_mod_phpwsrssfeeds_backend

  mod_mod_phpwsrssfeeds_feeds

  mod_mod_phpwsrssfeeds_feeds_seq

  mod_mod_poll

  mod_mod_poll_seq

  mod_mod_search_register

  mod_mod_search_register_seq

  mod_mod_security_errorpage

  mod_mod_security_ipinfo

  mod_mod_security_log

  mod_mod_security_settings

  mod_mod_users

  mod_mod_users_seq

  mod_mod_user_groups

  mod_mod_user_groupvar

  mod_mod_user_settings

  mod_mod_user_uservar

  mod_translation_conf

  mod_whosonline

  mod_whosonline_conf

  mod_whosonline_flags

  mod_xoap

 

 

I also had copies of the mod_mod_ tables that were named just mod_. I deleted them carefully and all worked well so am guessing that the mod_mod_ prefix was created as there were already mod_ tables in place.

 

Hmmmmm...off to the gym, Wayne :rolleyes:

Link to post
Share on other sites
  • 3 weeks later...

Gentlemen, the answer to the problem is that config.php should show...

 

$table_prefix = "";" and not $table_prefix = "mod_";"

 

Wayne

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...