markc

Is there a gui option or even a SQL query that would allow me to get a list of upcoming invoices? For instance, I need to MANUALLY update the storage quota for the next batch of invoices going out, and it would obviously help if I had a list of invoices that are about to be generated at the beginning of the next month, so I could apply these changes before they go out (I only do 12 month billing).

Yes, I suspect it's a PayPal issue too. The CC checkout page changed slightly a month or so ago as they added an extra option to sign up for an account just above the Submit button. Anyway, thanks for the prompt to sign up to Stripe. Pure laziness on my behalf that I have not already done so. I have, thanks to you, so now there is a new "Pay Now" option on client invoices.

Yes, up until that point it also works for me. It's when I fill in the CC details, select the right State and the "I am over 18" option and click on Submit THEN I get the "We're sorry, something seems to have gone wrong. Try again." error. I have indeed tried again a few times, and unfortunately the error is so generically useless I have no idea what the problem might be. The only response from PayPal is to clear the browser cache (done that a few times) and/or use a different browser (done that too). I've done this probably 1000s of times over the last 3 years without this error, up until earlier this year. As I say, I am waiting for another client to call in with their CC details so I can test another submission when using a Private window to eliminate whether it really is a local browser cache/cookie issue on my end, or not.

It's so long ago I've forgotten exactly how I imported them, but there were nearly 1000 customers previously managed in Excel (for nearly 2 decades), so I guess I massaged the fields and exported them as CSV to fill most of the client fields in WHMCS. I've never noticed the "Access Denied - Forbidden" error before when using "Login as Owner" up until recently. The other, more generic "something went wrong, try again" error when trying to submit a CC payment at PayPal is a PayPal error. I'll keep an eye on the Network tab in my browser and see if I can find some indication of why I am getting that error.

Yes, I started to use the reset password feature but that just sends an email to the customer which I then have to find and view (via secret sauce), then respond to that email and add misc random password, and then I can go back to the admin screen and Login as owner. Back in the early v7 days, an admin could actually set or change the clients password directly in one step. Now it involves going via the email reset method. Way too many steps for 100s of client accounts. As for viewing invoices as admin. I used to simply go to the Invoices tab for the particular customer, click on the unpaid invoice, then on that page there is a "View as Client" button up next to the Print and Download buttons. Once looking at the actual invoice I'd click on the yellow Paypal button then when I get to the PayPal login page I'd select "Pay with a Card" and the next page is for a Credit Card payment with the customer details already filled in (except the State/Territory field because WHMCS sends the full state name whereas PayPal expects the short state name, so it can't auto present the right State value). I've been using this method for probably 3 years up until about the 1st Jan 2022. I'm still waiting for a customer to call me for a CC payment so I can test whether using a Private window in either Firefox or Chrome will work.

All of my clients were imported from a legacy system, so none of them originally signed up with a plan. A lot of them are now over 80 years old (we've been going for nearly 25 years), so even the idea of clicking on "Forgot password" to get a new password for the billing system is all too much. Heh, it has even been a battle to get some of them to stop surface mailing us cheques and cash! Anyway, only about 20% of them actually log in and pay via their Paypal account (or CC) and offering a Subscription option has caused us more grief than it was worth when we first started using WHMCS. We only have annual plans, so it's not the end of the world to do manual CC payments and gives me a chance to be in touch with some clients. Thank you (yet again) but I have yet to try using Private mode in either of my browsers so if that still fails I will definitely take you up on your gracious offer of help.

I still have the "We're sorry, something seems to have gone wrong" error when trying to make a CC payment on behalf of a client either via the admin area, by clicking their invoice link, or when using "Login as owner" and then going to their client invoice link using either Firefox or Chromium. The one thing I have not tried yet is to use a Private window and see if it truly is related to browser caching and/or cookies. As mentioned, I have had zero problems making CC payments on behalf of clients while they are on the phone for the last 2 or 3 years until this year. Anyway, my second issue of "Access Denied - Forbidden" when using "Login as owner" seems to be only related to clients who have never logged in to WHMCS. It's annoying, but not yet another sign that my WHMCS installation is completely falling apart.

That is embarrassingly obvious when I got to the right area, but it's nothing like any Google hits or the PayPal support advice I tried to follow. Thank you!

I know, this should be a question for the folks at PayPal, but they are hopeless and surely someone here has already had to do this before. I'm using PayPal Basic and simply want to update my old logo on the PayPal payment page to my new logo. All the Google results and PayPal support advice seem to refer to links and pages that no longer exist (I presume) so would some kind soul here take pity on me and provide me with some exact steps to be able to update my logo at PayPal please?

Good point, I just disabled the other PayPal option too. Now using only the PayPal Basic. I can't remember when the 8.3.2 update arrived, but I never had any issues, for many years, up until about the 1st Jan. About half my payments are as the admin user via their invoice link in the admin area. I often do manual CC payments for them while they are on the phone. Since this problem started, I have now tried clicking on "Login as Owner" and going to their invoice via the client area and continue with a CC payment that way. That worked a couple of times, but now even that method is throwing the same useless generic error message when I submit the PayPal cart page. Yes, my difficulty is me (as admin) paying on behalf of a client using the "Pay with a card" option on the PayPal login screen. So if you have never done that, then you may not be bumping into the same issue.

Argh, now I am also getting this error when I try to "Login as Owner" in an attempt to avoid the above error when making a payment for a client directly from the admin area. I got this for another client yesterday (but some misc clients I checked were okay) and the only way I could solve it was to completely delete the client's account and re-add it after jotting down their profile details. Of course, I then lose that client's payment history, but in this case I could then use "Login as Owner" without the error below. As far as I can tell, some clients are still using PayPal successfully when they log into WHMCS themselves, otherwise I'd be out of business in a month or two if I can't make PayPal CC payments on behalf of most of my clients. Most of my income is by using PayPal as my CC merchant and taking the customer details over the phone, so now that I can't do that anymore and can't find a way to fix both of my problems, I'm kinda up the creek without a paddle. The only changes I have made is to update to 8.3.2 whenever that update became available.

Thanks for your response. I just got this again now when using the invoice Paypal button from the admin section for a CC payment, which had been working fine for many years up until a few weeks ago. There is nothing in the Gateway Logs page about this failed transaction. If I use "Login as client" and then go to invoice then that works sometimes but I have also seen the attached error there as well. Just now I removed the "Paypal" payment option leaving only Paypal Basic. I have double checked my Paypal settings and reconfirmed my business status and found that the language encoding was not set to UTF-8.

I was getting a weird permissions error when trying to switch to a normal user, so I went to the admin roles area and ended up deleting ALL the full admin permissions now I can't do anything such as undo the mistake I just made. I've had a look in the database tables with PhpMyAdmin, but I can't seem to find where I can toggle all the permissions back on. I suspect this change has affected the database itself, so even if I did a fresh reinstallation of WHMCS and imported a SQL dump then I'd still have the same problem. If I try to import a SQL backup from yesterday, then I will be missing entries from today. How can I re-add all the full administrator permission roles again?

Thanks for your response. I'm using 8.3.2 and fortunately when clients go to Paypal via their invoice Paypal (basic I think) button it seems to work, according to my Gateway logs. My problem is specifically when I try to make a credit card payment on behalf of the client, which used to work up until, hmm, about Dec 31st.

Nope, I still have this error after updating my Paypal business details. Is it possible that Paypal Basic is now deprecated by Paypal, or somehow changed? Should I perhaps change to just Paypal (Checkout)? What would be the best approach to try and figure out what is actually wrong so I have some chance of fixing this Paypal problem?

I just started getting this error too and I think it's because my Paypal details were incomplete. Maybe they updated their site with slightly more stringent identity requirements because when I checked my details I had to re-add some fields again and got a page that said "all good, you can now use paypal for your business".

Hmm, "not using off-the-shelf solutions". I'd argue that taking advantage of my domain registrars ability to auto update the list of TLDs (400+) along with updated pricing either up or DOWN (because of our AUD exchange rate fluctuations) is pretty well off-the-shelf. Also my use of Configurable Option Groups for about 30 bulk price tiers per websites, mailboxes and 1GB storage selections is arguably off-the-shelf too because it's part of the basic functionality WHMCS offers, and which I am grateful to take advantage of compared to 27,000 separate plans (30 x 30 x 30 possible combinations) to do the same thing versus essentially one single pay-as-you-grow plan. Anyway I thought I'd be smart and try to at least update my domains by leaving the price at 0.00 but no, I get a popup saying there MUST BE some price or percentage INCREASE across selected domains. So that can't work, at all, because half my wholesale domain prices have decreased. There was also no way to autoselect all 400+ domains at once (no Select All option) so I wasn't too keen on risking RSI to click on 400 buttons anyway. I also thought maybe I could copy the Bulk Updater addon module and hack away the 90% of it I don't need... nope, it's encrypted! 😞

Thanks brian! (again), I looked at some docs and examples and fighting my way through trial by fire I got to this decade old search result... The localAPI has to be used within a WHMCS script like a hook, addon or module, you cannot create standalone files using the localAPI function. So is this still a thing in 2021? Is there no way to write a "simple" external standalone PHP script to interact with the WHMCS API? If not would you be aware of the right database fields I could directly twiddle to simply tell WHMCS to auto update the price to whatever is the pricing tables? I probably have to do this once or twice a year so it's worth trying to create a script/whatever compared to logging into 1000 users accounts and manually clicking on Save for every product and domain they might have. I'm rather shocked something so simple is going to this hard to achieve!

Hi, I use Configurable Option Groups for my pricing structure and my registrar has an included price update for all TLD so the prices for my products and domains have been adjusted but how to I automatically apply these price changes to all my customers without having to click Save on every client product and domain as the admin user? Note: I cannot use the included Bulk Pricing Updater module because it has it's own non-optional pricing adjustments. I can't use that method because it would completely mess up my Configurable Options pricing (or ignore them, I haven't been game enough to try the Updater module) and my domain prices have already been updated (some lowered, some increased) by the domain registrars module. All I want to do is mass update all users current pricing to whatever values are in the pricing tables without manually clicking Save on every clients product and domain page.

In my case the extra /store part of the URL was preventing new users from accessing the products altogether. I partly solved it in nginx but rewriting the URL to completely remove "/strore"... rewrite ^/store(.*)$ $1 last;

"subaccounts converted to users?" Not that I am aware of. I might be missing some conceptual change regarding users vs owners in the v8 update. I have triple checked that my Full Administrator user has everything checked in the Roles section. A difference is that clicking on Login as Owner for the users with an error goes to https://xxxxx/admin/client/548/login whereas the ones that work go to https://xxxxx/clientarea.php as I would expect. Hmm, perhaps a session error.

Apologies for necrobumping this issue but in 8.0.4 (and since 8.0) I can't "Login as Owner" for some users and can't figure out any pattern and I don't use Reseller club. There is something about how some of my users have been added that must be different and I suspect a direct database twiddle would fix it... but what might that twiddle be?

Hi, I want to assign some hosting plans and domains to myself (as the site admin) so that they are registered in WHMCS to keep track of them but I do not want to be invoiced for my own plans and domains. I could muddle through some settings but surely it's something other folks have worked out already. What is the best approach for this?

Thanks for posting their reply. That workaround certainly works for me.

And a link to the ticket please?