By ggarron on

Hi,

I have upgrade my site

http://www.go2linux.org using a mirror site, http://www.go2linux.net, using this approach:

http://drupal.org/node/311442

now I am having this problem: All posts have undefined "input format" so, no full-html nor "filtered html" is set, can anybody please tell me where in the database drupal store that information, so I can copy from my old database to the new one that info?

thanks a lot in advance.
best regards,
Guillermo Garron

⋅ Categories: Drupal 6.x

Comments

cog.rusty’s picture

cog.rusty commented

It is in the "node_revisions" table, "format" column. Usually 1 = "Filtered HTML", 2 = "Full HTML", 3+ = "PHP code" or other user defined input formats (figure it out or look at the "filters" table of the same database).

You may need to clear the cache tables after setting those.

ggarron’s picture

ggarron commented

Thanks, I will try this tomorrow...
regards.
Guillermo.

ggarron’s picture

ggarron commented

Hi,
I have info on that table/column, but still does not show anything.
If I set now from the http://www.go2linux.net/node/#/edit and set it to full or filtered, it start working, I have 500+ posts, so it seems a lot of work to have it all wokring :(
This is resulting hard, thanks God I do not have CCK installed, or it could have been even harder.
regards,
Guillermo.

cog.rusty’s picture

cog.rusty commented

Did you clear the cache tables?

Also, what exactly do you mean "does not show anything"? Missing HTML code? Blank full node views? Blank teaser lists?

Any specific URL example?

ggarron’s picture

ggarron commented

Hi,
Thanks for your quick response, I cleared the cache blocks here:
admin/settings/performance

Do not know if there is where I should do it.

I mean with "does not show anything" that when I go to "imput format" in the edit section of a post, none of the options are selected, both globes are empty, I was assuming there was no info in the database, but there is info in the table you earlier menthiod.

cog.rusty’s picture

cog.rusty commented

Does this problem occur only with the existing posts but not with the new ones? Is a default input format
selected in the admin/settings/filters page?

Also, do your input formats exist in the "filters" table? Do they have the same numeric IDs that you see in the "node_revisions" table?

ggarron’s picture

ggarron commented

Yes, only with existing posts, and as soon as I assign a new value it works, so It seem it is because of different values in filter and node_revisions.

Here are the values of my new database filters table

Full Texts fid format module delta weight
Edit Delete 1 1 filter 2 0
Edit Delete 2 1 filter 0 1
Edit Delete 3 1 filter 1 2
Edit Delete 4 1 filter 3 10
Edit Delete 5 2 filter 2 0
Edit Delete 6 2 filter 1 1
Edit Delete 7 2 filter 3 10

and here is that table in the old database.

Full Texts format module delta weight
Edit Delete 1 filter 3 0
Edit Delete 1 filter 0 1
Edit Delete 1 filter 2 2
Edit Delete 2 filter 1 0
Edit Delete 3 filter 3 0
Edit Delete 3 filter 2 1

What do you think I should do, now that the IMHO the problem is identified, just copy the values from the old one to the new one? replacing or adding?

thanks a lot for your kind help.

regards.
Guillermo.

cog.rusty’s picture

cog.rusty commented

No, don't copy it without giving it some though. It may make a mess.

The contents of the "filters" table, which you printed out, specifies what filters are used by each input format and in what order. This may be relevant or not. But your new site seems to have 2 input formats (1 and 2) while your old site seems to have an additional input format, 3.

You can see what these input formats are in the "filter_formats" table. They must be (1, Filtered HTML), (2, Full HTML), and your old site has one more which I don't know what its is.

So, the questions are:
- What input format do your posts have in the revisions table? 1, 2, or 3? And do they exist in the "filter_formats" table? (Obviously format 3 is missing from the new site).
- Each input format contains some filters. Do your input formats contain the same filters in both sites? Some of the filters may depend on contributed modules in the old site, and also they may be applied in different order (you can examine and configure the filters in admin/settings/filters)

I still don't understand in what way the your problem affects your site, because I can see everything fine when browsing. The resulting behavior of your site may be important for identifying the problem (or not).

By the way, there is no chance that I would ever trust the upgrade method which you used.

ggarron’s picture

ggarron commented

first of all, I really want to thank you for your help, I know you are dedicating a lot of time to me and I appreciate it.

Well we now know that there is a missing format 3. I have in revisions table 1, 2 and 3 posts, the ones with 1 or 2 are working, the one with 3, is not (obviously).
When I enter to edit a node with format 3, and select Full-HTML it appears as I want to, so the solution seems to be, to change all 3 to 2 in revisions tables, or create a 3, and make full-html.

I do not remember in my old site having more than two options in the edit page, it was only filtered and full html.

This is affecting my site, this way.
I have css injection module, and I have added a class
.codigo
which makes the code appear in a small box, and I use it like this

ls -lh

so I need full-html for this css to work.
Which way do you think is the best way to solve this? to change all 3 to 2 in revisions table, or create a 3 format?

if the first, which is the best way to do it, I am not too good at SQL.

thanks

Guillermo.

cog.rusty’s picture

cog.rusty commented

There may be a reason that you had a 3rd input format. Doesn't your old site still exist? You could go to the admin/settings/filters page and see what the 3rd input format is, what filters it contains, and whether these filters depend on any modules.

ggarron’s picture

ggarron commented

Hi,
Yes you are right, but I have this problem with my old, site, just because I have changed the DNS records.

www.go2linux.org to www.go2linux.net and viceversa, the old site, which is now at www.go2linux.net
stopped working.

they are on different servers, as I did not want to work on live sites, I worked on a mirror site, under www.go2linux.net name, once I thought it was ok, I switched DNS info.

check please
www.go2linux.net and you will see it is no up anymore :(
regards,
Guillermo.

cog.rusty’s picture

cog.rusty commented

Doesn't the name of the mysterious input format 3 in the filter_formats table of the old database give any hint about what it was?

If not, you could take a look at the content in the node_revisions table of the old database to see if it is just HTML code (and not PHP code, BBcode, wiki tags or something else), and then change all occurrences of the input format 3 to 2 in the node_revisions table of the new database.

Or, if you want to investigate it further, set up a subdomain old.go2linux.org, copy your old drupal installation there including any additional modules, set up a database for it and load a backup of your old database, set the $db_url line in its settins.php file, and you should be able to access your old site at http://old.go2linux.org and see what the mysterious input format 3 was and what filters it contained so that you can reproduce it.

ggarron’s picture

ggarron commented

Yes, it gives a hint, :)

It was PHP, but that was 2, and three was full-html

Full Texts format name roles cache
Edit Delete 1 Filtered HTML ,1,2, 1
Edit Delete 2 PHP code 0
Edit Delete 3 Full HTML 1

I do not remember switching this, also I do not have posts using php, at least not know that, I have check my old database node_revisions table, and I only could find formats 1 or 3, so filtered or full-html.

ggarron’s picture

ggarron commented

Hi,
Thanks for all your help, I finally decided to change all '3' in format column on node_revisions database to '2' as full-HTML was what I wanted, and those three were meaning that.
There was not 2s so, this operation should have not affected anything in my site.

Thanks again, I have learned a lot about how drupal works.

regards,

Guillermo.