ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Template Group Issue (only one redirects to homepage)

June 16, 2008 2:27am

Subscribe [3]
  • #16 / Jun 16, 2008 1:52pm

    Joey Trimmer

    128 posts

    Second half:

    13
    UPDATE exp_templates SET hits = '133' WHERE template_id = '16'
    14
    SELECT module_version, module_name FROM exp_modules
    15
    SELECT field_id, field_type, field_name, exp_weblog_fields.site_id FROM exp_weblog_fields, exp_weblogs WHERE exp_weblogs.field_group = exp_weblog_fields.group_id AND exp_weblogs.is_user_blog = 'n'
    16
    SELECT weblog_id FROM exp_weblogs WHERE blog_name = 'news'
    17
    SELECT t.entry_id FROM exp_weblog_titles AS t LEFT JOIN exp_weblogs ON t.weblog_id = exp_weblogs.weblog_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1213660128 AND (t.expiration_date = 0 || t.expiration_date > 1213660128) AND t.entry_id = '2' AND exp_weblogs.is_user_blog = 'n' AND t.weblog_id = '2' AND t.status = 'open' ORDER BY t.sticky desc, t.entry_date desc LIMIT 0, 100
    18
    SELECT exp_templates.template_name, exp_templates.template_id, exp_templates.template_data, exp_templates.template_type, exp_templates.edit_date, exp_templates.save_template_file, exp_templates.cache, exp_templates.refresh, exp_templates.no_auth_bounce, exp_templates.enable_http_auth, exp_templates.allow_php, exp_templates.php_parse_location, exp_templates.hits, exp_template_groups.group_name FROM exp_template_groups, exp_templates WHERE exp_template_groups.group_id = exp_templates.group_id AND exp_template_groups.site_id = '1' AND exp_templates.template_name = 'style' AND exp_template_groups.group_name = 'includes'
    19
    SELECT exp_templates.template_name, exp_templates.template_id, exp_templates.template_data, exp_templates.template_type, exp_templates.edit_date, exp_templates.save_template_file, exp_templates.cache, exp_templates.refresh, exp_templates.no_auth_bounce, exp_templates.enable_http_auth, exp_templates.allow_php, exp_templates.php_parse_location, exp_templates.hits, exp_template_groups.group_name FROM exp_template_groups, exp_templates WHERE exp_template_groups.group_id = exp_templates.group_id AND exp_template_groups.site_id = '1' AND exp_templates.template_name = 'js' AND exp_template_groups.group_name = 'includes'
    20
    SELECT exp_templates.template_name, exp_templates.template_id, exp_templates.template_data, exp_templates.template_type, exp_templates.edit_date, exp_templates.save_template_file, exp_templates.cache, exp_templates.refresh, exp_templates.no_auth_bounce, exp_templates.enable_http_auth, exp_templates.allow_php, exp_templates.php_parse_location, exp_templates.hits, exp_template_groups.group_name FROM exp_template_groups, exp_templates WHERE exp_template_groups.group_id = exp_templates.group_id AND exp_template_groups.site_id = '1' AND exp_templates.template_name = 'header' AND exp_template_groups.group_name = 'includes'
    21
    SELECT exp_templates.template_name, exp_templates.template_id, exp_templates.template_data, exp_templates.template_type, exp_templates.edit_date, exp_templates.save_template_file, exp_templates.cache, exp_templates.refresh, exp_templates.no_auth_bounce, exp_templates.enable_http_auth, exp_templates.allow_php, exp_templates.php_parse_location, exp_templates.hits, exp_template_groups.group_name FROM exp_template_groups, exp_templates WHERE exp_template_groups.group_id = exp_templates.group_id AND exp_template_groups.site_id = '1' AND exp_templates.template_name = 'nav' AND exp_template_groups.group_name = 'includes'
    22
    SELECT variable_name, variable_data FROM exp_global_variables WHERE site_id = '1' AND user_blog_id = '0'
  • #17 / Jun 16, 2008 2:09pm

    Robin Sowell

    13255 posts

    OK- in ‘Admin- Utilities- SQL Manager- DB Query Form’- run this and let me know the results:

    SELECT t.template_name, tg.group_name FROM exp_templates t, exp_template_groups tg WHERE t.group_id = tg.group_id AND t.template_id = '16'
  • #18 / Jun 16, 2008 2:23pm

    Joey Trimmer

    128 posts

    Okay, the results
    template_name: index, group_name: home

  • #19 / Jun 16, 2008 2:29pm

    Robin Sowell

    13255 posts

    Heh- ok, stick w/me.  Do you have the pages module installed?  If so- go there- any pages named bio?

  • #20 / Jun 16, 2008 2:40pm

    Joey Trimmer

    128 posts

    Robin, I feel like the biggest idiot!!! I can’t believe that I did that. I apparently didn’t change the template used for the bio page (and forgot to mention it was a static page to begin with.).

    Uuuuuuuugh. Well, that problem is solved.

  • #21 / Jun 16, 2008 2:43pm

    Joey Trimmer

    128 posts

    I think after this site, and the 5 or so more I’m working on, I need a vacation!!!

    Well, that stupidness aside, I should be able to backup the DB now, should I do that so I can fix the news template_group that’s in hiding?

  • #22 / Jun 16, 2008 2:46pm

    Robin Sowell

    13255 posts

    Hee- well, I should have thought of it too.  I did consider it being a reserved word, but couldn’t figure out how that was possible, so didn’t pursue that line of thought.  Should have- it would have lead to ‘pages’ next.

    Yep- go ahead and backup.  I’ll probably turn you over to next shift to square it away, though.  Gots to hit some other work on my end.

  • #23 / Jun 16, 2008 2:59pm

    Joey Trimmer

    128 posts

    Haha, thanks so much for putting up with me Robin 😊 Will backup and post back here when ready.

  • #24 / Jun 16, 2008 4:01pm

    Ingmar

    29245 posts

    Sure, just let us know how it goes, thanks.

  • #25 / Jun 23, 2008 6:08pm

    Joey Trimmer

    128 posts

    Hi folks, sorry for the delay…finally got the DB backed up. Had to jump through the hoops to get it.

  • #26 / Jun 23, 2008 8:36pm

    Sue Crocker

    26054 posts

    Hi, Joey. Let us know what happens!

  • #27 / Jun 24, 2008 2:06pm

    Joey Trimmer

    128 posts

    Hi Sue, got it working. Just removed the “invisible” template_group and was able to recreate it. Thanks for everyone’s help of course! This is resolved.

    Any idea why this would happen when trying to create template files while creating the weblog? Just a fluke? I suppose I can try again as a test, just curious. Thanks again!

  • #28 / Jun 25, 2008 11:33pm

    Sue Crocker

    26054 posts

    At this point, things are working. I’m going to go ahead and close it, but if you find other issues, please create a related post.

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases