Jump to content

DennisHermannsen

Senior Member
  • Content Count

    477
  • Joined

  • Last visited

  • Days Won

    11

DennisHermannsen last won the day on March 11

DennisHermannsen had the most liked content!

Community Reputation

45 Excellent

1 Follower

About DennisHermannsen

  • Rank
    Level 2 Member

Recent Profile Visitors

1899 profile views
  1. Nevermind. I was wrong about the update dates. We had already updated on April 22nd. We had another issue, and WHMCS took a look at it. One of the supporters made a lot of changes and moved our current installation to a new directory on the exact date we started experiencing issue. I guess there's a possibility something went wrong when he was investigating. The site was completely offline for more than an hour, and sometimes it gave an error where the database connection could not be established. I'm starting to think he may have taken a backup of the database (just in case), done something that messed everything up and imported a backup of the database - but somehow the backup must've not include indexes for that one table.
  2. See this: (72866, 'admin', '2020-04-27 12:46:23', '2020-04-27 12:46:23', 'xx.xx.xxx.xxx', 'xxxxxxxxxxxx', '2020-04-27 12:46:23'), (0, 'admin', '2020-04-27 13:09:24', '2020-04-27 13:09:24', 'xx.xx.xxx.xxx', 'yyyyyyyyyyyy', '2020-04-27 13:09:24'), After logging in on April 27th, I initiated the upgrade. I don't know the exact time, but it was before 12:00. Logging in after this is logged as id 0.
  3. It definately was the update. I don't know how, though. The last visible admin log in WHMCS was a few minutes before upgrading WHMCS.
  4. Figured I would post in this community, despite we've fixed the issue. On 27th of April, we upgraded to WHMCS 7.10.1. I didn't notice anything immediately, but a few days after my boss said the backend had been loading really slow for a couple of days. With that in mind, I started navigating the WHMCS backend, and it was incredibly slow. Loading the front page took between 5-7 seconds. Just today I was able to dump all MySQL trafic and saw something that started like this: UPDATE tbladminlog SET logouttime = lastvisit WHERE adminusername='admin' AND lastvisit < '2020-05.... This ran for seconds. I couldn't reproduce on our other installations. Checking the table, I could see it no longer had any indexes, primary key or AUTO INCREMENT. A lot of rows had id 0. Deleting all rows with id 0 and setting indexes, primary key and auto increment fixed the issue. I'm really interested if anyone else has had this issue?
  5. According to the Eloquent documentation, I would be able to run the refresh() or fresh() function to refresh my database query: https://laravel.com/docs/7.x/eloquent#retrieving-models This doesn't seem to be possible in WHMCS though. Is there any other way to do it?
  6. When will 3.0.3 be released? I can't download it from your client area 🙂
  7. We're also seeing this. WHMCS sees the invoice as paid, but the transaction hasn't been captured in Stripe. Would be nice if WHMCS would share some words about this.
  8. file_put_contents into a file and save as PDF - that's what we do
  9. We thought about that as well. We just need the exported invoice in PDF, not an email with the PDF attached.
  10. It is related to accounting. We could just export them manually but a) it's manual work and b) all of the invoices are exported in the same file.
  11. If that could've been done automatically, yes. We need something that exports every invoice automatically once it's generated. We managed to get it working using curl with COOKIEJAR option set, though.
  12. I'm trying to setup a way to download invoices to a directory as soon as they're generated (and there's no functionality in the API for this), but I'm just stuck. I haven't figured out a way to log in as an admin yet. I need to authenticate as an admin to have access to all invoices, and then call dl.php to get the specific invoice. Has anyone had any success with this before?
  13. In ticket ID #ECE-874862, I reported an issue (last year) and was told that WHMCS requires strict mode disabled.
  14. It still boggles me how WHMCS can't run properly with strict mode enabled. Strict mode just controls how MySQL handles invalid queries. Instead of fixing them, you just advise that strict mode should be disabled. It doesn't feel right.
  15. You can just open the .sql file and copy the SQL for the templates that you need to restore.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated