[adminModule]=media (/ Unknown column 'i.realname' )

[muammar]

Hi. I've just upgraded serendipity and when I try to access media module I get next warning:

Code: Select all

SELECT  i.id, '' AS orderkey, i.name, i.extension, i.mime, i.size, i.dimensions_width, i.dimensions_height, i.date, i.thumbnail_name, i.authorid, i.path, i.hotlink, i.realname,
                     a.realname AS authorname
                     FROM serendipity_images AS i
       LEFT OUTER JOIN serendipity_authors AS a
                    ON i.authorid = a.authorid
                        LEFT JOIN serendipity_authorgroups AS acl_a
                                   ON acl_a.authorid = 1
                            LEFT JOIN serendipity_access AS acl_acc
                                   ON (    acl_acc.artifact_mode = 'read'
                                       AND acl_acc.artifact_type = 'directory'
                                       AND acl_acc.artifact_index = i.path
                                      )

                       WHERE 1=1  AND     (
                                 i.path IS NULL OR
                                        acl_acc.groupid IS NULL
                                 OR ( acl_acc.groupid = acl_a.groupid OR acl_acc.groupid = 0)
                                 OR ( acl_acc.artifact_id IS NULL
                                      
                                    )
                               )
                     GROUP BY i.id
            ORDER BY i.date DESC  LIMIT 0, 8

/ Unknown column 'i.realname' in 'field list' 

I have followed some instructions which are founded in this forum [0] but I haven't had success.

I hope you can help me,

Best Regards.

[0]http://www.google.com/url?sa=t&ct=res&c ... Qb6iA[code][/code]

[garvinhicking]

Hi!

You get this message if you upgraded your s9y version the wrong way, without executing the database layout changes.

How did you upgrade? Did you read the pointers in the www.s9y.org FAQ?

Regards,
Garvin

[muammar]

Hi garvinhicking, thanks for answering so quickly.

Well, I was using version 1.1.1 and what I did was to download all the next versions to upgrade serendipity gradually. But I have to point something, I had a problem with my server and I made a backup of the database. So When I installed serendipity's version that I wrote above (1.1.1) again, I got the problem. [version 1.1.1 was the last one that I had installed when I got the problem with the server]

I read the pointers in www.s9y.org FAQ before doing the upgrade. Do you think there is a solution to this problem?

Thanks,

[garvinhicking]

Hi!

Oh, okay. s9y does not require you to do gradual updates. Only always install the latest version.

In your case, you can downgrade s9y to '1.1.1' by editing serendipity_config_local.inc.php and setting $serendipit['versionInstalled'] to that version number. Then upload all serendipity 1.2 release files to your server, and when you now go to the admin section of s9y, it should upgrade itself.

Regards,
Garvin

[muammar]

Hi garvinhicking

I did what you suggested and when the application tries to update some parts of the database it shows next error:

Code: Select all

ALTER TABLE serendipity_category ADD COLUMN sort_order int(11);

/ Duplicate column name 'sort_order'

ALTER TABLE serendipity_category ADD COLUMN hide_sub int(1);

/ Duplicate column name 'hide_sub'

CREATE INDEX categoryso_idx ON serendipity_category (sort_order);

/ Duplicate key name 'categoryso_idx'

ALTER TABLE serendipity_suppress CHANGE ip ip VARCHAR(65) NOT NULL;

/ Table 'serendipity.serendipity_suppress' doesn't exist 

This question might sound stupid but, Do you think It should be a good idea to erase that part of the database and dump a pristine one? and then to try to upgrade again following the same steps?

Thanks for all your help.

Cheers,

[garvinhicking]

Hi!

These errors areonly warnings, they should not create any trouble. DId you try if the media database now works? IT should!:)

Regards,
Garvin

[muammar]

Hi Garvin,

Unfortunately for me, I still have the same problem I do not know what to do. I am trying some stuff here but I haven't had success yet. If I find a solution I'll post it.

Greetings,

[garvinhicking]

Hi!

Do you mean you still get the SQL error from above?

Try to downgrade the version string to '1.0' instead of '1.1.1' - I think the missing table was from a different, lower s9y version.

Regards,
Garvin

[muammar]

Hi Garvin!!!


Now it works, you were right! I had to downgrade the version string to '1.0' instead of '1.1.1' Thanks a lot!


Best Regards and greetings from Venezuela.

[randulo]

Hi!

You get this message if you upgraded your s9y version the wrong way, without executing the database layout changes.

How did you upgrade? Did you read the pointers in the www.s9y.org FAQ?

Regards,
Garvin

I'm getting this problem too. I did execute the scripts properly.

[garvinhicking]

Hi!

I'm getting this problem too. I did execute the scripts
properly.

No, you can only get this if the DB upgrades were not executed.

Regards,Garvin

[randulo]

This is a semantic issue. I clicked and the thing ran the scripts. Something happened. I guess I'll have to start over unless there is a one liner you can give me to fix this. The exact version was

$serendipity['versionInstalled'] = '0.9.1';

[garvinhicking]

Hi!

Yeah, you can reset the old version like mentioned in the FAQ by changing the version string and re-running the upgrade?

Regards,
Garvin