Announcement

  •  » Beta testing
  •  » MySQL error 1054 after upgrading to 2.6.0beta1

#1 2013-07-26 14:40:03

bob
Member
2013-07-26
6

MySQL error 1054 after upgrading to 2.6.0beta1

Hey there,

after upgrading from 2.5.2 to 2.6.0beta1 for reasons, I receive this error message (not for admin.php, though):

[mysql error 1054] Unknown column 'nb_categories' in 'field list'

I tried to run upgrade.php serveral times, but received this message:

No upgrade required, the database structure is up to date

Edit: Forgot to mention that I followed the upgrade manual.

Can anyone help me with this?

Bob

Last edited by bob (2013-07-26 14:42:11)

Offline

 

#2 2013-07-26 14:44:37

flop25
Piwigo Team
2006-07-06
7037

Re: MySQL error 1054 after upgrading to 2.6.0beta1

you shouldn't do this! This is a beta and if I remember well, the admin part is buggy in that one
but you could try to run upgrade_feed.php after you put $conf['check_upgrade_feed'] = true; as a local configuration


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#3 2013-07-26 14:55:29

bob
Member
2013-07-26
6

Re: MySQL error 1054 after upgrading to 2.6.0beta1

Yes, I shouldn't have done that. Running upgrade_feed.php gave me this:

2 upgrades to apply

=== upgrade 135

add nb available comments/tags

=== upgrade 136

add nb direct child categories

The MySQL error is gone, but there are three more errors now:

Warning: include(/themeconf.inc.php): failed to open stream: No such file or directory in /kunden/0123456789/webseiten/piwigo/include/template.class.php on line 894

Warning: include(): Failed opening '/themeconf.inc.php' for inclusion (include_path='.:/usr/local/lib/php') in /kunden/0123456789/webseiten/piwigo/include/template.class.php on line 894

Fatal error: Uncaught exception 'SmartyException' with message 'Unable to load template file 'menubar.tpl'' in /kunden/0123456789/webseiten/piwigo/include/smarty/libs/sysplugins/smarty_internal_templatebase.php:127 Stack trace: #0 /kunden/0123456789/webseiten/piwigo/include/template.class.php(370): Smarty_Internal_TemplateBase->fetch('menubar.tpl') #1 /kunden/0123456789/webseiten/piwigo/include/template.class.php(314): Template->parse('menubar', true) #2 /kunden/0123456789/webseiten/piwigo/include/block.class.php(148): Template->assign_var_from_handle('MENUBAR', 'menubar') #3 /kunden/0123456789/webseiten/piwigo/include/menubar.inc.php(330): BlockManager->apply('MENUBAR', 'menubar.tpl') #4 /kunden/0123456789/webseiten/piwigo/include/menubar.inc.php(31): initialize_menu() #5 /kunden/0123456789/webseiten/piwigo/index.php(120): include('/kunden/0123456789...') #6 {main} thrown in /kunden/0123456789/webseiten/piwigo/include/smarty/libs/sysplugins/smarty_internal_templatebase.php on line 127

Did I mention I hate myself?

Bob

Offline

 

#4 2013-07-26 15:08:02

flop25
Piwigo Team
2006-07-06
7037

Re: MySQL error 1054 after upgrading to 2.6.0beta1

^^

did you used a theme downloaded? You can re install manually it, or go in the database and change your theme in the *_users table


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#5 2013-07-26 15:18:51

bob
Member
2013-07-26
6

Re: MySQL error 1054 after upgrading to 2.6.0beta1

Thanks a lot, deleting the themes from the database solved the problems! But the favorites filter must have been in beta 2, then? Can't find it.

Offline

 

#6 2013-07-26 15:21:22

flop25
Piwigo Team
2006-07-06
7037

Re: MySQL error 1054 after upgrading to 2.6.0beta1

It's in trunk
http://piwigo.org/dev/changeset/23746/trunk
and will be released fisrt in the next beta2


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 
  •  » Beta testing
  •  » MySQL error 1054 after upgrading to 2.6.0beta1

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact