Now that is a major problem.
Unless you can read the database changes and do manual edits of your databse from 9407 to 9350, there is no possible way to downgrade.

As with any other software, especially for production sites, always make backups if it is a major version upgrade :)

Or at least, test it out first on your test-environment :) That's what I did when I upgraded from v1.10.2 to v2.0.0-alpha.

Your only option is to upgrade again. That's the only path I can see.

You haven't mentioned what does not work with 1.10.0 to 2.1.0. Is it the Skin? The upgrade proces failed? Or something else?

Just make sure you have uploaded all the files, and I mean all :)
Make sure you check your "conf" folder as I got the same message simply because of one file in that folder that wasn't updated.

John wrote:

Just make sure you have uploaded all the files, and I mean all :)
Make sure you check your "conf" folder as I got the same message simply because of one file in that folder that wasn't updated.

I've upload all the file, but it doesnt work...

and if i manually change the DB version, error message...

Do you know what part of the db can i restaure into a news insallation to have my post + comment + user again?

Downgrading is never done before, so don't go that way. In stead try to upgrade to the version you intended. Tell us where that goes wrong.

Good luck

I cant update my b2evo version.
My blog in B2evo "Miami" dont still work yet, i believe its make a half update so my DB is corrupted.

When i try to make new install, i cant restaure only my post and comment....

To see my site : http://pouark.free.fr

I don't see anything in the folder of your blog.

Normally the database doesn't get corrupted. It keeps track of the changes it has made.
Do try to finish the upgrade to 2.1. There is no reason why that shouldn't work if you had a 1.10 blog running.

Good luck

With my 1.10 Miami ->
I've only access to admin panel with this error message:

Notice: Undefined property: blog_default_skin in /mnt/152/sda/7/3/pouark/inc/MODEL/collections/_blog.class.php on line 170

Notice: Undefined property: blog_force_skin in /mnt/152/sda/7/3/pouark/inc/MODEL/collections/_blog.class.php on line 171

Notice: Undefined property: blog_default_skin in /mnt/152/sda/7/3/pouark/inc/MODEL/collections/_blog.class.php on line 170

Notice: Undefined property: blog_force_skin in /mnt/152/sda/7/3/pouark/inc/MODEL/collections/_blog.class.php on line 171

Notice: Undefined property: blog_default_skin in /mnt/152/sda/7/3/pouark/inc/MODEL/collections/_blog.class.php on line 170

Notice: Undefined property: blog_force_skin in /mnt/152/sda/7/3/pouark/inc/MODEL/collections/_blog.class.php on line 171

Warning: Cannot modify header information - headers already sent by (output started at /mnt/152/sda/7/3/pouark/inc/MODEL/collections/_blog.class.php:170) in /mnt/152/sda/7/3/pouark/inc/VIEW/_menutop.php on line 39

And when i try to access to my B2evo (not admin), i've this one :

Notice: Undefined property: blog_default_skin in /mnt/152/sda/7/3/pouark/inc/MODEL/collections/_blog.class.php on line 170

Notice: Undefined property: blog_force_skin in /mnt/152/sda/7/3/pouark/inc/MODEL/collections/_blog.class.php on line 171
L'habillage par défaut [] affecté au blog [=Pk Blog !=] n'existe pas. Il doit être correctement configuré dans les propriétés du blog ou dans le fichier stub. Contactez le webmaster...

I'll try to update to 2.1 and report the error message.

Thx a lot!

When i want to update from 1.10 to 2.1

I've this error message:

Vérification de la version du schéma BD... 9350 : OK.
Updating chapter url names...
Une erreur inattendue est survenue!

Si cette erreur persiste, merci de la signaler à l'administrateur.

Retourner à la page d'accueil
Informations additionnelles à propos de cette erreur:

MySQL error!

Duplicate column name 'cat_urlname'(Errno=1060)

Your query:

      ALTER TABLE evo_categories
        ADD COLUMN cat_urlname VARCHAR(255) NOT NULL

So i cant update...

And if i just retry (relaunch my url), i've this one:

Database schema is not up to date!

You have schema version «9350», but we would need «9500».

Thx in advance

Goto the cPanel or equivalent of your host and start phpMyAdmin (most likely to be found under MySQL databases). There find the column 'cat_urlname' under 'categories' and delete it.

or

Open ../blogs/install/_functions_evoupgrade.php and find lines 1692-1694:

$DB->query( '
ALTER TABLE T_categories
ADD UNIQUE cat_urlname ( cat_urlname )' );

and coment them out like:

/* $DB->query( '
ALTER TABLE T_categories
ADD UNIQUE cat_urlname ( cat_urlname )' ); */

upload the file and try again.

If you feel this is beyond your knowledge, you can PM (personal mail, see button under this post) me with login details of your acount (ftp or cPanel).

Good luck

Thx:

Still have :

Database schema is not up to date!

You have schema version «9350», but we would need «9500».

and now i have :

Vérification de la version du schéma BD... 9350 : OK.
Updating chapter url names... OK.
Updating Settings... OK.
Creating DB schema version checkpoint at 9406... OK. (Elapsed upgrade time: 0 seconds)
Moving general settings to blog settings... OK.
Upgrading blogs table...
Une erreur inattendue est survenue!

Si cette erreur persiste, merci de la signaler à l'administrateur.

Retourner à la page d'accueil
Informations additionnelles à propos de cette erreur:

MySQL error!

Can't DROP 'blog_force_skin'; check that column/key exists(Errno=1091)

Your query:

ALTER TABLE evo_blogs
              DROP COLUMN blog_force_skin

I must delete "blog_force_skin"?

It probably is dropped already, so it can't find it. Comment out the lines in ../blogs/install/_functions_evoupgrade.php 1730 - 1732:

$query = "ALTER TABLE T_blogs
DROP COLUMN blog_force_skin";
$DB->query( $query );

Good luck

Thx for all
But i've another one... :

MySQL error!

Can't DROP 'blog_default_skin'; check that column/key exists(Errno=1091)

Your query:

ALTER TABLE evo_blogs
                 ALTER COLUMN blog_allowtrackbacks SET DEFAULT 0,
                  DROP COLUMN blog_default_skin,
                   ADD COLUMN blog_owner_user_ID   int(11) unsigned NOT NULL default 1 AFTER blog_name,
                   ADD COLUMN blog_skin_ID INT(10) UNSIGNED NOT NULL DEFAULT 1 AFTER blog_allowusercss

Hi pouark,

You are nearly there. There means a new checkpoint and from there everything should run smooth. But you needed to go through this part because here it hanged on your previous install, so probably it didn't do everything before the next checkpoint.

Comment out line 1807 in _functions_evoupgrade.php:

// DROP COLUMN blog_default_skin,

The column probably was dropped already.

The checkpoint is nearing:

DROP COLUMN blog_default_skin,
	ADD COLUMN blog_owner_user_ID   int(11) unsigned NOT NULL default 1 AFTER blog_name,
	ADD COLUMN blog_skin_ID INT(10) UNSIGNED NOT NULL DEFAULT 1 AFTER blog_allowusercss' );
		echo "OK.<br />\n";

		install_basic_widgets();
		set_upgrade_checkpoint( '9408' );
	}

The two commands ADD COLUMN may give problems also (if they already exist). Comment them out, but only if they give an error.

Good luck

Afwas wrote:

Hi pouark,

You are nearly there. There means a new checkpoint and from there everything should run smooth. But you needed to go through this part because here it hanged on your previous install, so probably it didn't do everything before the next checkpoint.

Comment out line 1807 in _functions_evoupgrade.php:

// DROP COLUMN blog_default_skin,

The column probably was dropped already.

Thx but how to comment out this line ?
/* dont work

Comment out by placing

//

before the line or

/* some text to comment out */

Good luck

Afwas wrote:

Comment out by placing

//

before the line or

/* some text to comment out */

Good luck

Yes but i can't just comment ligne 1807:

like this :
/* DROP COLUMN blog_default_skin, */

Or like this:
// DROP COLUMN blog_default_skin,

I can just comment out the entire :

		echo 'Updating blogs table... ';
		$DB->query( 'ALTER TABLE T_blogs
								 ALTER COLUMN blog_allowtrackbacks SET DEFAULT 0,
									DROP COLUMN blog_default_skin,
									 ADD COLUMN blog_owner_user_ID   int(11) unsigned NOT NULL default 1 AFTER blog_name,
									 ADD COLUMN blog_skin_ID INT(10) UNSIGNED NOT NULL DEFAULT 1 AFTER blog_allowusercss' );
		echo "OK.<br />\n";


		install_basic_widgets();

		set_upgrade_checkpoint( '9408' );

Hi....

I've just delete the ligne 1807 and now :

MySQL error!

Table 'evo_skins__skin' already exists(Errno=1050)

Your query:

CREATE TABLE evo_skins__skin (
              skin_ID      int(10) unsigned      NOT NULL auto_increment,
              skin_name    varchar(32)           NOT NULL,
              skin_type    enum('normal','feed') NOT NULL default 'normal',
              skin_folder  varchar(32)           NOT NULL,
              PRIMARY KEY skin_ID (skin_ID),
              UNIQUE skin_folder( skin_folder ),
              KEY skin_name( skin_name )
            )

When that's will finish????

This will finish when there are no more errors :'(

I do not understand why you can't comment out a piece of the code.
For the time being you should continue with what you were doing: comment out or delete the pieces that give errors and try again.This *will* stop at one point and then you can happily blog ever after.

Good luck

but for this error, can i delete "evo_skins__skin" on database?

Yes you can.

There seem to be two kinds of errors:
1) CREATE a table when the table already exists -> comment out / delete the code to CREATE the table *or* delete the table from the database (and let the script create the table again).
2) DROP a table that is already deleted -> comment out / delete the code that DROPs the table.

Good luck

Ok i've make all you tell me
and finally, i've the default error message :

Vérification de la version du schéma BD... 9407 : OK.
Creating skins table... OK.
Creating skin containers table... OK.
Installing default skins... OK.
Creating widgets table... OK.
Updating blogs table... Installing default widgets...
Fatal error: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/152/sda/7/3/pouark/inc/_core/model/db/_db.class.php on line 793

This is a test. I am not sure if it works.
Coment out or delete line 1813:

install_basic_widgets();

If it doesn't give an error, that's fine, else I have another idea.

The same error message :(

pouark wrote:

Ok i've make all you tell me
and finally, i've the default error message :

Vérification de la version du schéma BD... 9407 : OK.
Creating skins table... OK.
Creating skin containers table... OK.
Installing default skins... OK.
Creating widgets table... OK.
Updating blogs table... Installing default widgets...
Fatal error: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/152/sda/7/3/pouark/inc/_core/model/db/_db.class.php on line 793

The good news is, it's stuck at set_upgrade_checkpoint. That's good because if you solve this problem, the rest of the upgrade script *should* run flawlessly.

You can manually set the new checkpoint in phpMyAdmin. In your database find evo_setting -> db_version. Set the content of that field (set_value) to 9408 and run the install script again.
Please let me know what the old value was.

Good luck

My DB version is 9409

I've change it to 9408
and i've another error message :

MySQL error!

Unknown column 'blog_stub' in 'field list'(Errno=1054)

Your query:

UPDATE evo_blogs
                    SET blog_access_type = "relative",
                        blog_siteurl = CONCAT( blog_siteurl, blog_stub )
                  

WHERE blog_access_type = "stub"

Hi pouark,

Something happened that I cannot explain, but never mind that. Change the database version (back) to 9409 and try again.

Good luck

I've replace db version to 9409

And now :

Vérification de la version du schéma BD... 9412 : OK.
Renaming tables...
Une erreur inattendue est survenue!

Si cette erreur persiste, merci de la signaler à l'administrateur.

Retourner à la page d'accueil
Informations additionnelles à propos de cette erreur:

MySQL error!

Can't find file: './pouark/evo_item__prerendering.frm' (errno: 2)(Errno=1017)

Your query:

RENAME TABLE evo_item__prerendering TO evo_items__prerendering,
                              evo_poststatuses TO evo_items__status,
                              evo_posttypes TO evo_items__type,
                              evo_posts TO evo_items__item

Hi pouark,

Can you have a look? Does the table evo_items__prerendering exist? The same with the other three. If they are already renamed, then I will give you some code to skip this part, else you want some code to create these entries.

Good luck

evo_items__prerendering doesnt exist anymore
and i can't rename the others...

Hi pouark,

This is going a bit slow ;)
Can you make a backup of your databse in phpMyAdmin and make it available online (put it on your server and send me a link to it, you may PM me if you prefer).
I will correct the problems.

Good luck

I have updated your database. All is working smooth now. If you have any questions left, please ask.

Happy blogging