Help: upgrade from 1.2x to 1.4.1 problem

[hgoor]

Hi,

I tried an upgrade from 1.21 to 1.4.1 but now I get the following error:

Fatal error: Call to undefined function serendipity_checkcommenttokenmoderation() in /home/vandegoo/public_html/index.php on line 60

Can anyone help please?

Edit: I can access my admin module but it has no styling or CSS. I get several errors there as well.... The config (paths etc..) seems to look ok?

Edit 2: i get the following errors now when accessing my page:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'Henk van de Goor'@'localhost' (using password: YES) in /home/vandegoo/public_html/include/db/mysql.inc.php on line 270

Warning: mysql_select_db() [function.mysql-select-db]: Access denied for user 'vandegoo'@'localhost' (using password: NO) in /home/vandegoo/public_html/include/db/mysql.inc.php on line 271

Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in /home/vandegoo/public_html/include/db/mysql.inc.php on line 271

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/vandegoo/public_html/include/db/mysql.inc.php on line 281

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/vandegoo/public_html/include/db/mysql.inc.php on line 281
serendipity error: unable to connect to database - exiting.

edit 3: I don't get it!!! This driving me nuts: according to the upgrade it was successful, but still NOTHING!!!

Serendipity Installation

Logged in as Henk van de Goor (Administrator)
Your Serendipity installation is now upgraded to version 1.4.1

You can return to your blog by clicking here

Powered by Serendipity 1.2 and PHP 5.2.1

edit 4 Ok here is a weird thing: when accessing the Admin (which I still can) and looking at configuration, the admin module show a DIFFERENT database USERname than the serendipity_config_local.inc.php

Maybe that has to do with it. When I change the name to the right database user-name it says it was save OK, when I re-open the config module (in my browser) it show the WRONG name again?????

[garvinhicking]

Hi!

Seems your firefox has auto-remembered soem password and thus is showing it inside your configuration screen.

What counts is the input in serendipity_config_local.inc.php - you can reset your firefox saved passwords, then it should show up properly again.

Regards,
Garvin

[hgoor]

Hi!

Seems your firefox has auto-remembered soem password and thus is showing it inside your configuration screen.

What counts is the input in serendipity_config_local.inc.php - you can reset your firefox saved passwords, then it should show up properly again.

Regards,
Garvin

Hi Garvin,

Thanks for the input. After the upgrade I messed up my install so much (trying to solve everything) that I had to have a backup restored... Unfortunately they restored the WRONG backup...

[judebert]

Sorry you're having so many troubles with this. We're constantly trying to improve the upgrade experience; that's one reason we recently added the "Verify Installation Integrity" feature. We decided long ago not to automatically push updates, but to require users to upgrade manually. In part, this was due to security concerns. Perhaps it's time for us to re-examine this decision.

Pretty much everything you report above was likely caused by an incorrect auto-saved password, like Garvin mentioned. I hope you're not too put off to try again. Now that the weekend is over, we should be available to help you more quickly.

[hgoor]

Sorry you're having so many troubles with this. We're constantly trying to improve the upgrade experience; that's one reason we recently added the "Verify Installation Integrity" feature. We decided long ago not to automatically push updates, but to require users to upgrade manually. In part, this was due to security concerns. Perhaps it's time for us to re-examine this decision.

Pretty much everything you report above was likely caused by an incorrect auto-saved password, like Garvin mentioned. I hope you're not too put off to try again. Now that the weekend is over, we should be available to help you more quickly.

Yeah, it was so weird. The whole upgrading said: Everything OK but the result still was that my blog was completely FUBU.

At the moment my provider is trying to restore a backup of Friday (when all was 100% well) but so far is seems it's making things worse.. (see www.vandegoor.com maybe you can tell what the problem is: it looks like the wrong database)

I'm praying they can restore it: after that I am NOT going to try an upgrade unless someone can assist me in making sure it will work..

All I did was a wget on serendipity 1.41, unzip it in a temp dir, made a backup of my serendipity_config_local.inc.php (and some other files), then copied all files over my current install, ran the update/upgrade process which told me ALL OK....

Then went to my homepage with the result described in my opening post....

Btw: I saw that "Verify Installation Integrity" option but it said something about missing checksums or something?


It has been a nightmare so far... Almost 4 years of blogging down the drain

[hgoor]

Ok, my provider has put a backup from Friday back on my server, but now I get the following errors:

Warning: include_once(/home/vandegoo/public.htmlplugins/serendipity_plugin_remoterss/serendipity_plugin_remoterss.php) [function.include-once]: failed to open stream: No such file or directory in /home/vandegoo/public_html/plugins/serendipity_event_backendrss/serendipity_event_backendrss.php on line 5

Warning: include_once() [function.include]: Failed opening '/home/vandegoo/public.htmlplugins/serendipity_plugin_remoterss/serendipity_plugin_remoterss.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php:/home/vandegoo/public_html/bundled-libs/:/home/vandegoo/public_html/bundled-libs/Smarty/libs/:/home/vandegoo/public_html/:') in /home/vandegoo/public_html/plugins/serendipity_event_backendrss/serendipity_event_backendrss.php on line 5
Query failed:
SELECT


e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,

a.realname AS author,
a.username AS loginname,
a.email
, e.body, e.extended

FROM
serendipity_entries AS e
LEFT JOIN serendipity_authors a
ON e.authorid = a.authorid
LEFT JOIN serendipity_entrycat ec
ON e.id = ec.entryid
LEFT JOIN serendipity_category c
ON ec.categoryid = c.categoryid

WHERE isdraft = 'false' AND e.timestamp <= 1232982000
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 7
/ Got error 127 from storage engine

Is this maybe because the MySQL database is the wrong one? I.e. the new structure?

[judebert]

Wow, what a mess. Didn't they restore the old database, too?

The backendrss plugin requires the remoterss plugin. It looks like you had remoterss installed, but that it's been lost now. (It's normally included along with Serendipity, even the 1.2 version, so it should still be in your directory.) Can you check to see if it's still there?

Alternatively, you can remove the serendipity_event_backendrss directory altogether. (Make a backup, of course.)

The mySQL database errors might be related to that. According to this discussion, the problem is a mySQL problem that might be fixed using "REPAIR TABLE serendipity_entries".

[hgoor]

Wow, what a mess. Didn't they restore the old database, too?

The backendrss plugin requires the remoterss plugin. It looks like you had remoterss installed, but that it's been lost now. (It's normally included along with Serendipity, even the 1.2 version, so it should still be in your directory.) Can you check to see if it's still there?

Alternatively, you can remove the serendipity_event_backendrss directory altogether. (Make a backup, of course.)

The mySQL database errors might be related to that. According to this discussion, the problem is a mySQL problem that might be fixed using "REPAIR TABLE serendipity_entries".

Yeah tell me about it Is there a way for me to tell what version database (i.e. 1.4.1 or 1.2.1) I am using? I have direct access with MySQL admin.

EDIT
Ok, I did a check and repair on the tables and it seems now to be showing my site again...

Weird!

It is too early to say all is well, but I will keep you updated.

EDIT 2:
Ok, my front-end is loading but now I get the following error at the bottom of the page:

Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/vandegoo/public_html/include/db/mysql.inc.php on line 84

What can that be?

[judebert]

Glad it's working!

Well, perhaps I'm interpreting this incorrectly, but it doesn't look like there have been any database updates since 1.2_alpha4. That changed the IP of the comments and suppress tables to VARCHAR(64) and VARCHAR(65), respectively.

Before that, we added a sort_order and hide_sub column to the category table.

Other than checking for fields like that, I don't think there's any way to determine the version of a s9y database.

[hgoor]

Glad it's working!

Well, perhaps I'm interpreting this incorrectly, but it doesn't look like there have been any database updates since 1.2_alpha4. That changed the IP of the comments and suppress tables to VARCHAR(64) and VARCHAR(65), respectively.

Before that, we added a sort_order and hide_sub column to the category table.

Other than checking for fields like that, I don't think there's any way to determine the version of a s9y database.

Well working... That one error at the bottom is scary... (see edit 2)

EDIT
Man this is costing me 20yrs of my life ;-( Just did another repair and now that error is gone...

Now I am afraid to touch anything and/or upgrade

[judebert]

Odd... it's the same error you were getting before the repair. Try it again, maybe?

At least one discussion claimed that error occurred when the system disk was full. Maybe your hosting service has a problem.

Definitely a database error of some sort.

Say, it's gone away while I was writing this.

[hgoor]

Odd... it's the same error you were getting before the repair. Try it again, maybe?

At least one discussion claimed that error occurred when the system disk was full. Maybe your hosting service has a problem.

Definitely a database error of some sort.

Say, it's gone away while I was writing this.

Correct: I ran another repair ..... Dodgy though...

I am afraid to do anything now Just feel luck it's up again...

[hgoor]

Odd... it's the same error you were getting before the repair. Try it again, maybe?

At least one discussion claimed that error occurred when the system disk was full. Maybe your hosting service has a problem.

Definitely a database error of some sort.

Say, it's gone away while I was writing this.

Something else ODD! You posted a comment: I got the mail for it that it needs apporval: however: there is no comment for me to approve???

A new comment has been posted on your blog "Henk van de Goor's Bloggers@large", to the entry entitled "It ain't easy pimpin' your desktop".
Link to entry: http://www.vandegoor.com/archives/666-I ... sktop.html

Requires review: Yes
User IP-address: 216.242.XXX.XXX
User Name: Judebert
User Email: nobody@nowhere.com
User Homepage: http://judebert.com/

Comments:
Nice. I like the "transporter" transitions. I've got to find those for myself.

[judebert]

You mean, you visited your admin "Comments" link, and the comment I made isn't listed at all?

[hgoor]

You mean, you visited your admin "Comments" link, and the comment I made isn't listed at all?

Yup. Maybe it got truncated the moment I did the second DB repair?

I made a comment myself and I both got the mail and it also showed up in the backend..

I better stop now as I am getting paranoid

Also I just saw that the post you replied to was (drumroll) the 666th post! Maybe that had to do with everything