@WLS-ITGuy If you wanted to say that old domain is part of usernames, and you want to change only that part of the usernames, there is no single SQL statement, but I see 2 solutions:

Write SQL script that will use LOOP to iterate through all records in table users and then replace username with new username....

Use spreadsheet calculator (Excel or similar) to prepare multiple simple SQL UPDATE statements:

Export table "users" (just necessary columns) and import it to Excel or similar _ - prepare new usernames in new column (use SUBSTITUTE() function in Excel) prepare simple UPDATE command for each username (in new column in Excel) - you can use functions like SUBSTITUTE or CONCATENTE to prepare you UPDATE statements with your usernames from previous column, i.e. =CONCATENATE("UPDATE users SET username = '", .... copy UPDATE statements from Excel and execute them

I think secong approach (Excel) is much safer because you see results in spreadsheet before you execute UPDATEs.
Always use WHERE clause when you use UPDATE

If you want more exact statements/formulas, give more detailed structure of your table and usernames

@Pete-S said in WordPress Site Lost Its Mind - Ten Minutes of Maintenance Over and Over Again:

This is how you do that:
https://developer.wordpress.org/plugins/cron/hooking-wp-cron-into-the-system-task-scheduler/

Nice, good info. Thanks.

@jaredbusch said in Need to split this string in PHP:

This:
https://github.com/sorvani/freepbx-helper-scripts/commit/23ef9bd7aca3d791217aab86ddd53b30d7838563

And yes @Pete-S or @JasGot whichever one of you always yells at me to not use " I know I need to clean that code up more 🙂

@scottalanmiller said in How to Install PHP 7.3 on Ubuntu 18.04:

I hate having to do this, but sometimes it has to be done. Here is how to get this middling PHP version onto this old version of Ubuntu.

sudo add-apt-repository ppa:ondrej/php sudo apt update

I'm not sure that is the proper way to do it.
ppa are personal repositories - meaning someone put it together.

I think Ubuntu has offical backports, just like Debian.
In that case it would be better to get a the "newer" php version from the backport repository instead.

UPDATE.
It looks like the ondrej/php repository is actually maintained by a Debian developer, Ondřej Surý. He is one of the package maintainers for the official debian and ubuntu php packages.
https://deb.sury.org/

@pete-s I've never claimed to be a real PHP dev. So this is good feedback.

So one of our guys tracked it down. It was a typo in the .htaccess file that we received from the customer.

@scottalanmiller said in Installing Laravel on Ubuntu 20.04:

@Pete-S said in Installing Laravel on Ubuntu 20.04:

@Pete-S said in Installing Laravel on Ubuntu 20.04:

@scottalanmiller said in Installing Laravel on Ubuntu 20.04:

@Pete-S said in Installing Laravel on Ubuntu 20.04:

OK, if you are not running apache or nginx, you should install the php-cli package instead.

So that seems to get installed anyway as a dependency on its own.

Yes, it does. But by using the php package and not php-cli, you probably got apache installed on your system as well - by dependencies.

You could find out by running: apt list --installed | grep apache

Or systemctl status apache2 to see if it's running.

Even if it was, Laravel uses Artisan's server.

I'm guessing they are invoking php's built-in webserver.

Regardless, the point is that if you swap php to php-cli in your install guide you don't get apache and other stuff you don't need.

@Pete-S said in Apache installation - file owner & permissions?:

I was wondering what permission and owner should files like html, php etc have?

Normally you just do...

chown www-data:www-data -R /var/www/html

@Pete-S said in What PHP version does RHEL 7.7 come with?:

@scottalanmiller said in What PHP version does RHEL 7.7 come with?:

@Pete-S said in What PHP version does RHEL 7.7 come with?:

If Red Hat had more resources they could have released a major version each year and then supported it for ten years. Then you'd never have anything older than one year on a new inst

Yes, you would. If you use RHEL 7 and even if RHEL 8 came out th enext day, and RHEL 9 a week later... if you stay on RHEL 7 your code would not change.

I said "New install" Scott. You are saying the exact same thing as I did.

Oh I see what you are saying. No one does that, though, they have STS for that. Fedora, Ubuntu Current, Normal Windows 2019. They all do STS. LTS makes no sense in the real world if you are willing to use what is new at install time.

Well let's talk about fedora and updating killing a laptop lol....

FLAMP >

@Emad-R I use it with Nginx all the time, I use it with Apache too, but I couldn't tell you about performance difference because I never bothered to benchmark it.
As for separation, I do use it in separate docker containers, I think all my instances connect to Nginx. The only place I use it with Apache is on the same VPS, but I see no reason you couldn't separate them and use TCP to connect.

Thanks I will check this out

github updated. files renamed a bit. Still a work in progress, but things working much better.

0_1533163657304_1cb7dbcf-38f3-48da-a102-fc1f7348fe17-image.png

@scottalanmiller Yeah both of my webservers use mariadb for example

@emad-r

NVM the same thing still works, but cause the files changed I thought I need to put something else.

@zachary715
You can turn on debug by changing false to true in .env file, so you can see more information instead of Whoops, looks like something went wrong.

# REQUIRED: BASIC APP SETTINGS # -------------------------------------------- APP_ENV=production APP_DEBUG=true APP_KEY= APP_URL= APP_TIMEZONE=America/Denver APP_LOCALE=en