Announcement

#1 2019-10-09 06:05:16

Jan Becket
Member
2015-01-17
41

Puzzling 2.10 upgrade issue

Hello/Hi/Greetings,

I am running three separate installations of Piwigo - one on my primary site (janbecket.net) and two on add-on domains. All three are set up with the same themes and plugins. The upgrade to 2.10 went ok on two of the installations but on one of my add-on domains -www.thebookofparis.com- the home page now begins with a list of error messages.

Yes, I do back up the site and could do a global restore of everything, but would prefer to fix that one installation, and to figure out what causes the problem there but not on the other two Piwogo installations. Very puzzling. The error messages now appearing at the top of the home page:

Notice: Undefined index: display_fromto in /home/xxxxxx/public_html/thebookofparis.com/piwigo/include/category_cats.inc.php on line 119

Notice: Undefined index: display_fromto in /home/xxxxxx/public_html/thebookofparis.com/piwigo/include/category_cats.inc.php on line 315

Notice: Undefined index: display_fromto in /home/xxxxxx/public_html/thebookofparis.com/piwigo/include/category_cats.inc.php on line 315

Warning: Cannot modify header information - headers already sent by (output started at /home/xxxxxx/public_html/thebookofparis.com/piwigo/include/category_cats.inc.php:119) in /home/xxxxxx/public_html/thebookofparis.com/piwigo/include/page_header.php on line 86

Thanks!

Piwigo version: 2.10
PHP version: 7.3
MySQL version: 10.2.25
Piwigo URL: http://www.thebookofparis.com

Offline

 

#2 2019-10-09 12:04:35

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13786

Re: Puzzling 2.10 upgrade issue

Hi Jan Becket,

Can you go in your database manager and give us the result of these 2 SQL queries :

Code:

select * from piwigo_config where param = 'display_fromto';

and

Code:

select * from piwigo_upgrade order by applied desc limit 5;

Offline

 

#3 2019-10-09 19:15:34

Jan Becket
Member
2015-01-17
41

Re: Puzzling 2.10 upgrade issue

Thanks - will do that today.

By the way, when I log in as admin on that same Piwigo installation, I also get this error message right before the page redirects in Firefox:

Warning:  [mysql error 1146] Table 'xxxxxx_piwi723.piwisx_activity' doesn't exist

INSERT  INTO `piwisx_activity`
  (`object`,`object_id`,`action`,`performed_by`,`session_idx`,`ip_address`,`details`)
  VALUES('user','1','login','1','68499c12732ad89dace5c70b83f1605d','98.125.220.101','a:2:{s:6:\"script\";s:14:\"identification\";s:5:\"agent\";s:82:\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:69.0) Gecko/20100101 Firefox/69.0\";}') in /home/xxxxxxx/public_html/thebookofparis.com/piwigo/include/dblayer/functions_mysqli.inc.php on line 856


Warning: Cannot modify header information - headers already sent by (output started at /home/xxxxxxx/public_html/thebookofparis.com/piwigo/include/dblayer/functions_mysqli.inc.php:855) in /home/xxxxxxx/public_html/thebookofparis.com/piwigo/include/page_header.php on line 86

Offline

 

#4 2019-10-09 20:02:40

Jan Becket
Member
2015-01-17
41

Re: Puzzling 2.10 upgrade issue

When I check the MySQL database for that installation (with PHPMyAdmin) I run the queries and am told that piwigo_config and piwigo_upgrade do not exist. I can see that myself in the list of files in the database. All of them begin with piwisx, not piwigo.

Offline

 

#5 2019-10-09 20:23:46

Jan Becket
Member
2015-01-17
41

Re: Puzzling 2.10 upgrade issue

OK, I think I am beginning to see the problem.

I have a primary Piwigo installation at janbecket.net. That site has a front page I made myself and then some links to a Wordpress site and a Piwigo site. They all function nicely as one rather complex website.

My web host allows me to create unlimited sub domains, of which I have three. One is only a Wordpress site and is not relevant here, but the other two are Piwigo sites. Each of them has a front-end page I made myself which contains links to the Piwigo galleries on the back side.

In order to distinguish among the different Piwigo databases, each line in the MySQL database for each installation begins with a different designation. In my primary / home directory for janbecket.net, all lines in the database begin with "piwigo." However, in the database for thebookofparis.com, each line begins with "piwisx." In the database connected with my other Piwigo installation (abookofstones.com), each line in the database begins with "piwick."

If this upgrade issue occurred on one Piwigo sub-domain I do not understand why it did not occur on the other one but I am still hopeful that there is an easy fix.

Thanks!

Offline

 

#6 2019-10-13 06:39:19

Jan Becket
Member
2015-01-17
41

Re: Puzzling 2.10 upgrade issue

Hello Pig

I executed the two queries you suggested but changed "piwigo" to "piwisx." The first query came up empty but the second query came up with these results. What should I do at this point?

Showing rows 0 -  4 (5 total, Query took 0.0007 seconds.) [applied: 2017-05-04 05:57:54... - 2016-05-18 23:34:56...]

select * from piwisx_upgrade order by applied desc limit 5


id    applied       description   
149    2017-05-04 05:57:54    [migration from 2.8.0 to 2.9.0, 0.006 s] add last_...   
150    2017-05-04 05:57:54    [migration from 2.8.0 to 2.9.0, 0.004 s] add histo...   
151    2017-05-04 05:57:54    [migration from 2.8.0 to 2.9.0, 0.000 s] add "pict...   
152    2017-05-04 05:57:54    [migration from 2.8.0 to 2.9.0, 0.001 s] add 5 par...   
99    2016-05-18 23:34:56    upgrade included in installation

Offline

 

#7 2019-10-14 21:22:41

Jan Becket
Member
2015-01-17
41

Re: Puzzling 2.10 upgrade issue

Hello,

I just installed the upgrade to 2.10.1 and unfortunately this same issue persists. The error messages are only at the top of the home page, not on the album pages.

Iʻd very much appreciate suggestions.

Thanks
Jan

Offline

 

#8 2019-10-15 09:32:55

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13786

Re: Puzzling 2.10 upgrade issue

You don't have the latest database upgrades. In your web browser, open page upgrade.php (instead of admin.php in the URL)

Offline

 

#9 2019-10-19 03:45:34

Jan Becket
Member
2015-01-17
41

Re: Puzzling 2.10 upgrade issue

OK, my web host did some editing of my .htaccess file and added this line:
suPHP_ConfigPath /home/username/public_html

This is supposed to make my php.ini file recursive and to force my add-on domains to use the current php version. As far as I can tell, my site thebookofparis.com is now using the current version of php: 7.3.

However, the error messages still persist at the top of the home page.

So, the question now: is there a support article that will walk me though re-installing Piwigo in that directory? I can rename the current Piwigo folder and do a clean install, but it would be great to have a list of which files and folders to port over from the old installation - so that I do not have to recreate the site from scratch.

Unless of course there is a better option.

Thanks for all of help!

Offline

 

#10 2019-10-19 04:16:00

Nigel-Aves
Member
2015-09-22
63

Re: Puzzling 2.10 upgrade issue

Jan,

I ran into exactly the same issue.  PHP versions     7.2.10

Today I started to investigate. To cut a long story short I run VirtualMin to help admin my server. Through Virtualmin it is easy to change PHP versions, strip out a web site and re-install from backup. I went back to PHP version PHP 7.0.27 / PIWIGO 2.9.0

The upgrade worked.

If possible I would recommend going back to PIWIGO 2.9.0, and try using PHP 7.0.27

I think something changed in PHP from 7.0 to at least 7.2 ...

Nigel.

Offline

 

Board footer

Powered by FluxBB

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