Announcement

#1 2012-06-22 16:35:53

yjb
Member
2012-03-16
3

After upgrade to 2.4 sql failure: Table 'piwigo.users' doesn't exist

Hi,

I've upgraded to 2.4 and get the following message (followed by a whole range which might be related):

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

SELECT id AS id
     , username AS username
     , password AS password
     , mail_address AS email
  FROM users
  WHERE id = '2' in /data/www/piwigo/include/dblayer/functions_mysql.inc.php on line 770

The table is actually called piwigo.piwigo_users and this did work in the previous version.

What should I adjust?

<< UPDATE >>

I found the following entry to be wrong:

local/config/config.inc.php

line 505

$conf['users_table'] = $prefixeTable.'users';

and changed it to:

$conf['users_table'] = $prefixeTable.'piwigo_users';

No clue why it was changed during the upgrade

Thanks,

Ysbrand

Last edited by yjb (2012-06-22 17:18:44)

Offline

 

#2 2012-06-22 17:19:48

mistic100
Former Piwigo Team
Lyon (FR)
2008-09-27
3277

Re: After upgrade to 2.4 sql failure: Table 'piwigo.users' doesn't exist

Hi,
do you have any plugin activated ? and so can you try activting theme one-by-one

or perhaps you redefined the constant USERS_TABLE for a reason or another ?

Offline

 

#3 2012-06-22 17:22:55

mistic100
Former Piwigo Team
Lyon (FR)
2008-09-27
3277

Re: After upgrade to 2.4 sql failure: Table 'piwigo.users' doesn't exist

actually Piwigo never write this file itself
had to say that only you could have write that :)


If I can give you an advice only redefine in your local configuration file values you have to, if you use the default value, remove it from the local file
Thus it's easier to know what you customize

Offline

 

#4 2012-06-22 17:31:00

yjb
Member
2012-03-16
3

Re: After upgrade to 2.4 sql failure: Table 'piwigo.users' doesn't exist

Thanks for your comments.

The funny thing is that I never changed t file myself; I did install piwigo (2.3) with the original installer.

As far as I remember it asked me a databasename (piwigo) and a prefix (piwigo_). Beyond that I've not done any customization.

Offline

 

#5 2012-06-22 17:40:27

laurent.duretz
Piwigo Team
22 France
2004-06-29
582

Re: After upgrade to 2.4 sql failure: Table 'piwigo.users' doesn't exist

I analysed this problem for the french forum.

Take a look in the /local/config/config.inc.php and search a line like:

Code:

$conf['users_table'] = $prefixTable.'users';

If this line exists comment (prefix with //) or remove it.


« Entre Ce que je pense, Ce que je veux dire, Ce que je crois dire, Ce que je dis, Ce que vous avez envie d'entendre, Ce que vous entendez, Ce que vous comprenez... il y a dix possibilités qu'on ait des difficultés à communiquer. Mais essayons quand même... »
[ Bernard Werber ]
This is more difficult if you don't understand French !
[ Laurent ]

Offline

 

#6 2012-06-22 21:58:30

yjb
Member
2012-03-16
3

Re: After upgrade to 2.4 sql failure: Table 'piwigo.users' doesn't exist

Perfect, that works as well!

Merci Beacoup,

Ysbrand

Offline

 

Board footer

Powered by FluxBB

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