Hello/Hi/Greetings,
Hello, I am trying to get prepaid credits to work, however, when I go into the prepaid credits setting I have no uses that I can select from. I simply see this page with nothing available in the drop-down: https://i.imgur.com/ZqcvQjp.png
I have multiple users which do not show up.
How would I get users to show up here?
Thank you
Osian
Environment
Piwigo 12.2.0 Check for upgrade
Operating system: Linux
PHP: 7.4.3 (Show info) [2022-04-04 10:50:55]
MySQL: 8.0.28-0ubuntu0.20.04.3 [2022-04-04 10:50:55]
Graphics Library: External ImageMagick 6.9.10-23
Cache size 302.32 Mo calculated 3 days ago Refresh
Activated plugin list 14
Admin Tools
Check Files Integrity
Check Uploads
Custom Download Link
Download Counter
gdThumb
GThumb+
LocalFiles Editor
PHP Captcha for Piwigo
Prepaid Credits
Protect Notification
Rotate Image
Statistics
Stop Spammers
Piwigo URL: http://photos.osiansmith.com
Offline
This might be of use:
[9]
SELECT *
FROM piwigo_user_infos
WHERE user_id = 2
;
(this query time : 0.000 s)
(total SQL time : 0.003 s)
(total time : 0.005 s)
(num rows : 1 )
[10]
SELECT COUNT(*)
FROM piwigo_caddie
WHERE user_id = 1
;
(this query time : 0.000 s)
(total SQL time : 0.003 s)
(total time : 0.007 s)
(num rows : 1 )
[11]
SELECT
image_id
FROM piwigo_lounge
;
(this query time : 0.000 s)
(total SQL time : 0.003 s)
(total time : 0.007 s)
(num rows : 0 )
[12]
SELECT
id
FROM piwigo_images
LEFT JOIN piwigo_image_category ON id = image_id
WHERE category_id is null
ORDER BY id ASC
;
(this query time : 0.001 s)
(total SQL time : 0.005 s)
(total time : 0.009 s)
(num rows : 0 )
[13]
SELECT
DISTINCT(`user_id`)
FROM piwigo_ppcredits_spent
;
(this query time : 0.000 s)
(total SQL time : 0.005 s)
(total time : 0.010 s)
(num rows : 0 )
[14]
SELECT
DISTINCT(`user_id`)
FROM piwigo_ppcredits_paid
;
(this query time : 0.000 s)
(total SQL time : 0.005 s)
(total time : 0.010 s)
(num rows : 0 )
[15]
SELECT
*,
validated_on AS occured_on
FROM piwigo_ppcredits_paid
WHERE validated_on IS NOT NULL
AND 1=1
;
(this query time : 0.000 s)
(total SQL time : 0.006 s)
(total time : 0.010 s)
(num rows : 0 )
[16]
SELECT
*,
used_on AS occured_on
FROM piwigo_ppcredits_spent
LEFT JOIN piwigo_images AS i ON image_id = i.id
WHERE 1=1
;
(this query time : 0.000 s)
(total SQL time : 0.006 s)
(total time : 0.011 s)
(num rows : 0 )
[17]
SELECT mail_address
FROM piwigo_users
WHERE id = 1
;
(this query time : 0.000 s)
(total SQL time : 0.006 s)
(total time : 0.012
Offline