Recent Topics
  1. b2evolution CMS Support Forums
  2. b2evolution Support
  3. General Support
  4. Solved [2.0.1-alpha] Failed BD update

Solved [2.0.1-alpha] Failed BD update

1 Sep 19, 2007 11:19    

My b2evolution Version: 1.9.3

Informations additionnelles à propos de cette erreur:

MySQL error!

Table 'vajrabe2.T_item__prerendering' doesn't exist(Errno=1146)

Your query:

ALTER TABLE T_item__prerendering CHANGE COLUMN itpr_content_prerendered itpr_content_prerendered MEDIUMTEXT NULL

I have updated with no problem another instalation of B2 on the same Hosting company, for this one i was updating from 1.9.3 (should i first go to 1.10.2 ?)

now, i can't loggin, it fails to actualise the BD but still say :
Vérification de la version du schéma BD... 9340 : OK.

Any hints on what can i do ?

Back to top

2 Sep 19, 2007 11:59

*if* I recall, you need to add the table to the list in /conf/_advanced.php ( approx 210 )

$db_config['aliases'] = array(
		'T_item__prerendering' => $tableprefix.'item__prerendering',
		'T_antispam'           => $tableprefix.'antispam',
		'T_basedomains'        => $tableprefix.'basedomains',
		'T_blogs'              => $tableprefix.'blogs',
		'T_categories'         => $tableprefix.'categories',
		'T_coll_group_perms'   => $tableprefix.'bloggroups',
		'T_coll_user_perms'    => $tableprefix.'blogusers',
		'T_coll_settings'      => $tableprefix.'coll_settings',
		'T_comments'           => $tableprefix.'comments',
		'T_cron__log'           => $tableprefix.'cron__log',
		'T_cron__task'          => $tableprefix.'cron__task',
		'T_files'              => $tableprefix.'files',
		'T_filetypes'          => $tableprefix.'filetypes',
		'T_groups'             => $tableprefix.'groups',
		'T_hitlog'             => $tableprefix.'hitlog',
		'T_items__item'        => $tableprefix.'items__item',
		'T_items__itemtag'      => $tableprefix.'items__itemtag',
		'T_items__prerendering' => $tableprefix.'items__prerendering',
		'T_items__status'       => $tableprefix.'items__status',
		'T_items__tag'          => $tableprefix.'items__tag',
		'T_items__type'         => $tableprefix.'items__type',
		'T_links'              => $tableprefix.'links',
		'T_locales'            => $tableprefix.'locales',
		'T_plugins'            => $tableprefix.'plugins',
		'T_pluginevents'       => $tableprefix.'pluginevents',
		'T_pluginsettings'     => $tableprefix.'pluginsettings',
		'T_pluginusersettings' => $tableprefix.'pluginusersettings',
		'T_postcats'           => $tableprefix.'postcats',
		'T_sessions'           => $tableprefix.'sessions',
		'T_settings'           => $tableprefix.'settings',
		'T_skins__container'    => $tableprefix.'skins__container',
		'T_skins__skin'         => $tableprefix.'skins__skin',
		'T_subscriptions'      => $tableprefix.'subscriptions',
		'T_users'              => $tableprefix.'users',
		'T_useragents'         => $tableprefix.'useragents',
		'T_usersettings'       => $tableprefix.'usersettings',
		'T_widget'             => $tableprefix.'widget',
	);

¥

Back to top

3 Sep 19, 2007 13:02

Thanks, anyway i updated trough 1.10.2 first, then to 2.1 alpha and the update went perfect, like usual :)
but thanks again for your fast help !

Back to top

4 Sep 22, 2007 07:27

I had the same problem, but buzz is right...you have to upgrade to 1.10 before jumping to 2.0

Back to top

5 Sep 22, 2007 22:19

This should be fixed in 2.0.2+

Back to top


Form is loading...