Announcement

  •  » Extensions
  •  » Pwigio prepaid credits not showing users

#1 2022-04-04 12:52:02

osianSmith
Member
2022-03-31
4

Pwigio prepaid credits not showing users

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

 

#2 2022-04-04 21:37:06

osianSmith
Member
2022-03-31
4

Re: Pwigio prepaid credits not showing users

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

 
  •  » Extensions
  •  » Pwigio prepaid credits not showing users

Board footer

Powered by FluxBB

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