This blog was great and ultimately gave me enough info to get this done, however, it wasn’t for a rookie in MYSQL since the whole part about ‘deleting rows’ assumes you know how to delete a row. It looks like I also wrote a cpanel version of the same need a few years back. Also I elected to turn off…
Category: Business
How to make a Virtual Machine (VM) Visible on the LAN with Virtualbox and Ubuntu
Why this post? Some new owners took over a company. The previous owner had delivered a crm system to the new owners which ‘ran on a server upstairs’. The buyers asked for all admin passwords to the server which the Sellers provided. However, these were just user passwords and not actual root passwords or system passwords to the actual box.…
Changing or Fixing the Site URL for SuiteCRM
Recently I moved my SuiteCRM from a slow shared host over to a Digital Ocean droplet to speed things up. It worked very well, by the way. So fast, and probably I save 10 minutes per day just not waiting for server, haha. Anyways, everything went pretty well except one thing: the emails that were sent out from the Workflow…
How to Backup your Akaunting Installation
If you are like me, you were attracted to Akaunting accounting software because they are one of the first nice looking and open source accounting softwares around that operate in a similar way to the ‘friendly’ GUI systems like Quickbooks online. I was so upset about not having control of the data and / or price plans that I decided…
How to Overcome a Prestashop 500 Error on Front End
The Background I upgraded my ubuntu server last week and after I did so, the Prestashop front end went down – but not the back end! Everything seemed fine because no one was checking the front end so after someone changed something in the back and refreshed the front they thought they had killed the site (and so did I!).…
How to Change Discount Type (Amount, Percent) Default Value in SuiteCRM
Sadly this wasn’t easy. In the Quotes / Line items module, when you are entering the type of discount there are two types by default: Amount (Amt) and Percent (Pct). Someone asked me to change the default from Pct to Amt. I logged in as admin, went into Studio, went to the Line Items module, went to ‘Fields’ and, like…
How to Backup your Prestashop Shop and Database on Ubuntu Server
Frankly the prestashop documentation on this is pretty good. This whole process is much like backing up any other server with ubuntu where you need to back up two things: your site files your database If you followed my how to install prestashop on ubuntu server blog then this is a similar setup. If this isn’t your setup, consider a…
How to Print Multiple Pages to One PDF with Ubuntu and Scribus
This was one of these exercises that seemed like it would be dead easy but took me forever to figure out. My goal was simple: to take one document, and print 4 copies of it to a PDF file (not to paper for now) so that there were 4-up on the page instead of wasting the entire page for this…
How to Make a SuiteCRM Production Subdomain on Digital Ocean Ubuntu Server
I thought this specific tutorial might help others who have the same set up as me: in need of setting up a test environment for trying custom SuiteCRM code before deploying it. A developer may wish to give you some code, log in and patch it themselves for testing, etc, or, you might want to try something without breaking something.…
How to make SuiteCRM Localhost Test Environment
Somehow I got pretty far in life in age and suffering, managed to figure out how to install SuiteCRM on an ubuntu server and basically maintain it (even back it up) but one day I needed to test some custom code on a non-production machine. This is when I realized that I didn’t know (at all) how to make Apache2…