Piwigo.org

yjb · 2012-06-22 16:35:53

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)

mistic100 · 2012-06-22 17:19:48

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 ?

mistic100 · 2012-06-22 17:22:55

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

yjb · 2012-06-22 17:31:00

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.

laurent.duretz · 2012-06-22 17:40:27

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.

yjb · 2012-06-22 21:58:30

Perfect, that works as well!

Merci Beacoup,

Ysbrand

Piwigo.org

Announcement

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

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

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

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

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

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

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

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

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

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

Code:

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

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

Board footer