URGENT! Major template problems - not loading modified ones, some disappearing!

[X-Fan]

Originally Posted by Erwin

Did you backup to an SQL file?

Yes.

If so, you can import specific tables in SSH using the command line.

But how? What command(s) do I need to enter?

The way I do it is using phpmyadmin, and importing the whole backup database into a NEW database, the exporting the TEMPLATES table as an SQL file, then importing that into the OLD database.

I don't have permission to create a new database - I'll check with my site host and see if they can set me up a temp one.

[Lesane]

Install vbulletin on your local drive:
https://vborg.vbsupport.ru/showthread.php?t=39482

Import the .sql file (also explained in above thread), then go to the admin and export the template table (see screenshot).

Also, wich 'templatesetid' has your templates? (check the content of the table 'template'). And what's the content of the table ' templateset'?

[X-Fan]

Originally Posted by Lesane

Import the .sql file (also explained in above thread), then go to the admin and export the template table (see screenshot).

Unfortunately I can't download a 300 meg SQL file as I have a download cap with my 'net account.

Also, wich 'templatesetid' has your templates? (check the content of the table 'template').

If you mean my modified templates, currently it's 3.

And what's the content of the table ' templateset'?

templatesetid = 3
title = Default
importtemplatesetid = 0

[X-Fan]

Originally Posted by Erwin

Did you backup to an SQL file?

If so, you can import specific tables in SSH using the command line.

The way I do it is using phpmyadmin, and importing the whole backup database into a NEW database, the exporting the TEMPLATES table as an SQL file, then importing that into the OLD database.

Erwin, what do I need to enter on the command line to import a backup of a specific table?

[X-Fan]

It worked! My site's back up and running!

I just need to modify a few templates I'd changed since last week's backup, but it's online again with all content intact!

Thanks very much to all who helped me out! Your suggestions and advice were invaluable.

[X-Fan]

Okay, a tad early on the celebrations there. Whilst the majority of the site appears to be working, some templates are still not loading.

For example, I've had Chen's "Change style of first post" hack installed for ages, and it was working fine until now. Take a look at this thread:

http://www.comixfan.com/xfan/forums/...threadid=22721

It's meant to be using the postbit_first template but it's not. Heck, it's not even showing the first post at all!

But on threads in forums which I didn't set for the change first post, all is mostly fine, eg:

http://www.comixfan.com/xfan/forums/...threadid=22637

Several other modified templates aren't showing either, such as forumhome, getinfo, etc.

Any ideas as to how I can fix that?

[X-Fan]

Okay, just a quick update. Any existing templates that I've modified aren't being displayed. The master is being displayed instead.

Any new templates that I've added aren't being displayed either, unless I set their templatesetid to -1, the master set. If I do that, then the new templates are displayed.

Also odd is that some templates from hacks that were installed with templatesetid -1, such as the Warning Systems Hack and vBHome, have now reverted back to templatesetid 1.

What could be causing these things to happen?

[Erwin]

Hacks are reverted from default to custom when you upgrade vB. Just run the installation php files for the hack to put them back to default.

[X-Fan]

This wasn't an upgrade, though, this was a straight import of the templates table from my back-up into my current DB.

I hadn't added any new hacks since the database was backed up last week, so all templates added by hacks are still in the templates table.

What I meant, was, that after I imported the backed-up templates table, templates started disappearing after that. As I was going through the templates, I noticed some of the Warning Systems hack and Store hack templates were missing, even though they were there when I imported the backed-up templates table!

Also, what about any existing templates that I've modified not being displayed?

As I mentioned before, any new templates that I've added aren't being displayed either, unless I set their templatesetid to -1, the master set. If I do that, then the new templates are displayed.

[X-Fan]

Huh, well there you go... I just tried importing the settings, template, and templateset tables again, but was frustrated because only the master templateset was being displayed, none of my modifications.

So I checked in the styles section, and the master templateset was coming up for header, footer etc. I went to my SQL table, looked in the style table, and noticed that the templateset there wasn't 1, so I changed it and voila, things look back to normal!