Announcement

  •  » Beta testing
  •  » 12.0rc2: Table 'piwigo_lounge' doesn't exist

#1 2021-10-15 06:18:09

Serge D
Member
US
2014-07-15
365

12.0rc2: Table 'piwigo_lounge' doesn't exist

Hi

I deployed piwigo 12 over piwigo 11
It runs but there is a message that the database requires an upgrade.
Running /upgrade.php said everything is up to date

select * from piwigo_config where param = 'piwigo_db_version'; returns 12

how to determine the cause of DB version error?

Visiting admin.php?page=configuration shows the following error

Code:

[mysql error 1146] Table 'piwigo_lounge' doesn't exist

SELECT
    image_id
  FROM pwg_lounge
;

#1  my_error /include/dblayer/functions_mysqli.inc.php(132)
#2  pwg_query /include/dblayer/functions_mysqli.inc.php(888)
#3  query2array /admin/include/functions.php(3273)
#4  get_orphans /admin.php(263)

Please advise

Last edited by Serge D (2021-10-18 06:58:17)

Offline

 

#2 2021-10-15 14:21:28

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

Re: 12.0rc2: Table 'piwigo_lounge' doesn't exist

open upgrade_feed.php instead of upgrade.php in your web browser.

But you should not "deploy" version 12 (still in beta) over version 11.

Offline

 

#3 2021-10-17 05:13:06

Serge D
Member
US
2014-07-15
365

Re: 12.0rc2: Table 'piwigo_lounge' doesn't exist

@plg thank you
looks like it did the trick


so few observations:

* copying 12rc2 over 11 is successful
* I did remove few files during extraction manually if they did not exist in new code. system may do that automatically through obsolete list, but it is a habit
* I did run upgrade.php when system shown that DB is not up to date, but upgrade_feed.php did the trick
* interestingly enough message in upgrade_feed.php was "0 upgrades to apply"
* at no point site shown that upgrade would be or was performed. Wordpress does show something for it, but I am not saying it is a must
* GreyDragon Theme and plugins I use appears to be working, but I will do further digging before certifying
* Switching on PHP 8 did not cause any issues

Overall, great job, team

PS: Most annoying "feature" in this version is requirement of SMARTY to test all variables. I do not know what genius on their team decided that undefined variables in the template must break it

Last edited by Serge D (2021-10-17 05:54:54)

Offline

 

#4 2021-10-19 08:27:59

Serge D
Member
US
2014-07-15
365

Re: 12.0rc2: Table 'piwigo_lounge' doesn't exist

unfortunately I have to turn PHP 8 off.
SMARTY started coughing and got very sick.
looks like something in last 2 days caused it to die while adding combined scripts in the footer
have to investigate further
same code in 7.4 works just fine

Last edited by Serge D (2021-10-19 08:28:15)

Offline

 

#5 2021-10-30 15:07:00

TOnin
Member
1970-01-01
64

Re: 12.0rc2: Table 'piwigo_lounge' doesn't exist

Hi,
also got a

Code:

Warning:  [mysql error 1146] Table 'piwigo.piwigo_lounge' doesn't exist

but upgrade_feed.php says

Code:

upgrade feed is not active

and the Warning remains.

Offline

 

#6 2021-11-05 21:11:43

herdivineshadow
Member
2021-11-05
3

Re: 12.0rc2: Table 'piwigo_lounge' doesn't exist

I have the same issue as TOnin :(

Offline

 

#7 2021-11-07 07:11:17

Serge D
Member
US
2014-07-15
365

Re: 12.0rc2: Table 'piwigo_lounge' doesn't exist

a) did you run UPGRADE.PHP to force core upgrade check?
b) looks like with official version upgrade_feed.php may not do much
c) if you upgraded by copying the new version over the existing installation, you need to do a file list check to make sure all redundant files are gone. Compare your installation with a pristine copy of PWG 12. Delete any files in core folders that do not exist in the new version and do not correspond to any drop-in.
d) manually delete _data/cache folder content except for index.htm
e) manually delete _data/combined folder content

Offline

 

#8 2021-11-29 22:44:00

dcrobertson01
Member
2014-02-02
4

Re: 12.0rc2: Table 'piwigo_lounge' doesn't exist

I get the same trying to do an automatic upgrade from 11 to 12. Found a french post here:

https://fr.piwigo.org/forum/viewtopic.php?pid=233802

which seems to have fixed it.

Offline

 

#9 2021-11-29 22:57:25

erAck
Only trying to help
2015-09-06
1143

Re: 12.0rc2: Table 'piwigo_lounge' doesn't exist

Maybe easier is [Forum, post 182050 by erAck in topic 31634] Admin-interface doesnt work after upgrade to 12.1.

(just in case someone comes across this again).


Running Piwigo at https://erack.net/gallery/

Offline

 
  •  » Beta testing
  •  » 12.0rc2: Table 'piwigo_lounge' doesn't exist

Board footer

Powered by FluxBB

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