Piwigo.org

You are not logged in. (Register / Login)

Announcement

#1 2011-11-24 15:37:24

joshermens1
Guest

Upgrade errors

Hi After an Update from 2.2.x to the last version  i got the following errors:

Notice: Undefined index: nb_image_page in E:\HostingSpaces\Hermens1\foto.hermenswetzels.nl\wwwroot\include\section_init.inc.php on line 173 Notice: Undefined index: order_by_inside_category in E:\HostingSpaces\Hermens1\foto.hermenswetzels.nl\wwwroot\include\section_init.inc.php on line 180 Notice: Undefined index: index_new_icon in E:\HostingSpaces\Hermens1\foto.hermenswetzels.nl\wwwroot\include\functions_category.inc.php on line 127 Notice: Undefined index: high_width in E:\HostingSpaces\Hermens1\foto.hermenswetzels.nl\wwwroot\include\category_cats.inc.php on line 349 Notice: Undefined index: high_height in E:\HostingSpaces\Hermens1\foto.hermenswetzels.nl\wwwroot\include\category_cats.inc.php on line 350 Notice: Undefined index: rating_score in E:\HostingSpaces\Hermens1\foto.hermenswetzels.nl\wwwroot\include\category_cats.inc.php on line 352 Notice: Undefined index: index_new_icon in E:\HostingSpaces\Hermens1\foto.hermenswetzels.nl\wwwroot\include\category_cats.inc.php on line 354

How can i rebuild the index

#2 2011-11-24 15:39:16

plg
Piwigo Team
Location: Paris, France, Europe
Registered: 2002-04-05
Posts: 11717
Website

Re: Upgrade errors

Hi joshermens1,

Can you go into your database manager (like PhpMyAdmin) and tell what's inside your "piwigo_upgrade" table?


Latest blog post on Piwigo.com: Piwigo 2.5 on Piwigo.com (March 7th, 2013)

Offline

#3 2011-11-24 15:48:49

joshermens1
Guest

Re: Upgrade errors

Hi,

There are several id's from 61 to 97.

#4 2011-11-24 15:58:20

joshermens1
Guest

Re: Upgrade errors

Here's a sample:

ID             61
Applied     2011-08-15 13:37:49
Discription  upgrade included in installation

#5 2011-11-24 15:58:54

plg
Piwigo Team
Location: Paris, France, Europe
Registered: 2002-04-05
Posts: 11717
Website

Re: Upgrade errors

OK, please do the following : in your MySQL manager, perform this request

Code:

delete from piwigo_config where param = 'piwigo_db_version';

Then open your Piwigo in your web browser and you'll be redirected to upgrade.php automatically (if not, tell us)


Latest blog post on Piwigo.com: Piwigo 2.5 on Piwigo.com (March 7th, 2013)

Offline

#6 2011-11-24 16:01:41

joshermens1
Guest

Re: Upgrade errors

Oke.

I did an than I get the following message

No upgrade required, the database structure is up to date

#7 2011-11-24 16:07:38

plg
Piwigo Team
Location: Paris, France, Europe
Registered: 2002-04-05
Posts: 11717
Website

Re: Upgrade errors

1) currently, what does:

Code:

select param, value from piwigo_config where param = 'piwigo_db_version';

give you?


2) do you have a column "rating_score" in table piwigo_images?


Latest blog post on Piwigo.com: Piwigo 2.5 on Piwigo.com (March 7th, 2013)

Offline

#8 2011-11-24 16:18:43

joshermens1
Guest

Re: Upgrade errors

Question 1)

  I get an sintax error on:   select param, value piwigo_config where param = 'piwigo_db_version';



Questeion 2) How can i see it.

#9 2011-11-24 16:21:39

joshermens1
Guest

Re: Upgrade errors

Question 2:   I have no ratings

#10 2011-11-24 16:26:40

plg
Piwigo Team
Location: Paris, France, Europe
Registered: 2002-04-05
Posts: 11717
Website

Re: Upgrade errors

joshermens1 wrote:

Question 1)

  I get an sintax error on:   select param, value piwigo_config where param = 'piwigo_db_version';

sorry, I have updated the request. Please retry.


Latest blog post on Piwigo.com: Piwigo 2.5 on Piwigo.com (March 7th, 2013)

Offline

#11 2011-11-24 16:36:27

joshermens1
Guest

Re: Upgrade errors

On Question 1 :

There are zero results after the execution of the statement.

#12 2011-11-24 16:46:01

plg
Piwigo Team
Location: Paris, France, Europe
Registered: 2002-04-05
Posts: 11717
Website

Re: Upgrade errors

Are you really 100% sure you have no "rating_score" column in table piwigo_images? (I mean the column, not the values in the column)


Latest blog post on Piwigo.com: Piwigo 2.5 on Piwigo.com (March 7th, 2013)

Offline

#13 2011-11-24 16:55:57

joshermens1
Guest

Re: Upgrade errors

In table Piwigo_images there is no collum rating_score

#14 2011-11-29 21:59:28

plg
Piwigo Team
Location: Paris, France, Europe
Registered: 2002-04-05
Posts: 11717
Website

Re: Upgrade errors

Sorry for the late reply joshermens1. It seems your gallery is OK right now.

I really wonder what the problem was and how you fixed it.


Latest blog post on Piwigo.com: Piwigo 2.5 on Piwigo.com (March 7th, 2013)

Offline

Board footer

Powered by FluxBB

About this website · Donate · Contact Piwigo project © 2002-2013