Blue text on templates.

[Lunty]

Hi what does the blue text mean that the template is broken? none of my header template's will update, there all showing like this image.

[MattRogowski]

Your master header template has been deleted so it's being treated as custom. Run this query in phpMyAdmin:

Code:

INSERT INTO mybb_templates (title,template,sid,version) VALUES('header', '<div id="container">
        <a name="top" id="top"></a>
        <div id="header">
            <div class="logo"><a href="{$mybb->settings['bburl']}/index.php"><img src="{$theme['logo']}" alt="{$mybb->settings['bbname']}" title="{$mybb->settings['bbname']}" /></a></div>
            <div class="menu">
                <ul>
                    <li><a href="{$mybb->settings['bburl']}/search.php"><img src="{$mybb->settings['bburl']}/{$theme['imgdir']}/toplinks/search.gif" alt="" title="" />{$lang->toplinks_search}</a></li>
                    <li><a href="{$mybb->settings['bburl']}/memberlist.php"><img src="{$mybb->settings['bburl']}/{$theme['imgdir']}/toplinks/memberlist.gif" alt="" title="" />{$lang->toplinks_memberlist}</a></li>
                    <li><a href="{$mybb->settings['bburl']}/calendar.php"><img src="{$mybb->settings['bburl']}/{$theme['imgdir']}/toplinks/calendar.gif" alt="" title="" />{$lang->toplinks_calendar}</a></li>
                    <li><a href="{$mybb->settings['bburl']}/misc.php?action=help"><img src="{$mybb->settings['bburl']}/{$theme['imgdir']}/toplinks/help.gif" alt="" title="" />{$lang->toplinks_help}</a></li>
                </ul>
            </div>
            <hr class="hidden" />
            <div id="panel">
                {$welcomeblock}
            </div>
        </div>
        <hr class="hidden" />
        <br class="clear" />
        <div id="content">
            {$pm_notice}
            {$bannedwarning}
            {$bbclosedwarning}
            {$unreadreports}
            <navigation>
            <br />
', '-2', '1400');

[Lunty]

I don't use phpmyadmin or anything else to run query's I run my site on SQLite.

Any other way too fix it?

[MattRogowski]

Well, you need some sort of query to add the master template to the database again, I don't know SQLite syntax so unless someone else does, you'll need to adapt that query, or find a way to add the data in manually.

[faviouz]

Would a plugin to run queries fit? There are two if I'm not wrong.

[MattRogowski]

Possibly but I'm not sure if they would work with SQLite, they may only be built to deal with MySQL, but they're worth a try I guess.

[Lunty]

(07-08-2009 08:08 PM)faviouz Wrote:  Would a plugin to run queries fit? There are two if I'm not wrong.

Guess Mini SQL wasn't worth the try after all my site has suddenly froze straight after I ran the query.

But now im pretty darn gutted just lost 3 theme's completely that took me week's.

EDIT: Ok nvm it cameback thank god.

[MattRogowski]

You haven't lost the entire theme, just the header has a problem... doesn't your host give you access to sqlitemanager??

[Lunty]

Nope phpmyadmin is banned because it so resource intensive so a few of the high tech people made a custom SQL db manager just waiting on a reply from them now over at my host's forum.

Also i just ran the query again and now give's this error.

http://h.imagehost.org/view/0644/Mini_SQL_Query_Page

[MattRogowski]

Ah... well, I'm not sure if that's because the SQLite query structure is different from MySQL query structure, or because " and ' need to be escaped... try this, this is with " and ' escaped:

Code:

INSERT INTO mybb_templates (title,template,sid,version) VALUES('header', '<div id=\"container\">
        <a name=\"top\" id=\"top\"></a>
        <div id=\"header\">
            <div class=\"logo\"><a href=\"{$mybb->settings[\'bburl\']}/index.php\"><img src=\"{$theme[\'logo\']}\" alt=\"{$mybb->settings[\'bbname\']}\" title=\"{$mybb->settings[\'bbname\']}\" /></a></div>
            <div class=\"menu\">
                <ul>
                    <li><a href=\"{$mybb->settings[\'bburl\']}/search.php\"><img src=\"{$mybb->settings[\'bburl\']}/{$theme[\'imgdir\']}/toplinks/search.gif\" alt=\"\" title=\"\" />{$lang->toplinks_search}</a></li>
                    <li><a href=\"{$mybb->settings[\'bburl\']}/memberlist.php\"><img src=\"{$mybb->settings[\'bburl\']}/{$theme[\'imgdir\']}/toplinks/memberlist.gif\" alt=\"\" title=\"\" />{$lang->toplinks_memberlist}</a></li>
                    <li><a href=\"{$mybb->settings[\'bburl\']}/calendar.php\"><img src=\"{$mybb->settings[\'bburl\']}/{$theme[\'imgdir\']}/toplinks/calendar.gif\" alt=\"\" title=\"\" />{$lang->toplinks_calendar}</a></li>
                    <li><a href=\"{$mybb->settings[\'bburl\']}/misc.php?action=help\"><img src=\"{$mybb->settings[\'bburl\']}/{$theme[\'imgdir\']}/toplinks/help.gif\" alt=\"\" title=\"\" />{$lang->toplinks_help}</a></li>
                </ul>
            </div>
            <hr class=\"hidden\" />
            <div id=\"panel\">
                {$welcomeblock}
            </div>
        </div>
        <hr class=\"hidden\" />
        <br class=\"clear\" />
        <div id=\"content\">
            {$pm_notice}
            {$bannedwarning}
            {$bbclosedwarning}
            {$unreadreports}
            <navigation>
            <br />
', '-2', '1400');