waynemac Posted November 15, 2004 Posted November 15, 2004 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 Quote
TCH-Don Posted November 15, 2004 Posted November 15, 2004 I am not familiar with that script. Moving to the Installing Scripts forum that may get you better exposure. Quote
borfast Posted November 15, 2004 Posted November 15, 2004 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. Quote
waynemac Posted November 15, 2004 Author Posted November 15, 2004 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 Quote
borfast Posted November 15, 2004 Posted November 15, 2004 Perhaps some of the tables are really supposed to be named "<prefix>_mod_<tablename>"? Quote
waynemac Posted November 15, 2004 Author Posted November 15, 2004 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 Quote
waynemac Posted December 2, 2004 Author Posted December 2, 2004 Gentlemen, the answer to the problem is that config.php should show... $table_prefix = "";" and not $table_prefix = "mod_";" Wayne Quote
borfast Posted December 2, 2004 Posted December 2, 2004 (edited) Does that mean you hadn't solved the problem when you posted that last message? I thought ou did. Well, I'm glad you did it this time Edited December 2, 2004 by TCH-Raul Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.