Chris van der Westhuizen

i did create an EER Diagram using MySQL Workbench's Reverse Engineer option, but it is not linking the table fields. Although the naming of the tables and sub tables and fields is self explanatory, I am not sure if I should link an id of id_value field to an appropriate table without investigation, because there is no primary foreign key relations on the diagram, thus not in the db.

Does someone have a blesta database diagram showing primary/foreign key relations etc.? It will save me time composing one for quick reference while developing modules/plugings. Kind regards Chris

Hi Blesta Addons Do you have a solution already, or should I write something to accomplish that according to your steps? Because we also sits with a lot of duplicate clients after importing from some whmcs systems which is messing up our billing and invoicing.

While Invoices generate, and staff resend a failed invoice/mail at the same time, all of those emails that went out received the correct email header and body but the wrong content in the attachment. I noticed that the datetime fields of those emails in the log_emails table with the wrong attachment sent out have exactly the same date datetime on the second. So from now on we will not resubmit mails manually for invoices that we create while the system is busy generating e.g. month-end invoices. I did not look at the programming, but would suggest that a client id or user id be incorporated while generating the temporary pdf record. If that is the problem? Kind regards Chris

I hope this can be helpful for someone else with the same problem as I had. I noticed on our servers that mailparse was only installed for cli and fpm and not for apache2, thus I had to include it for Apache too as follows: we are using apache2 with php7.0. on ubuntu 16.04 1. find path of file mailparse.ini: # cd /; find / -name *mailparse.ini /etc/php/7.0/mods-available/mailparse.ini /etc/php/7.0/fpm/conf.d/20-mailparse.ini /etc/php/7.0/cli/conf.d/20-mailparse.ini 2. I then copy mailparse.ini from cli to apache2 and needed to edit and include the full path: # cp /etc/php/7.0/cli/conf.d/20-mailparse.ini /etc/php/7.0/apache2/conf.d/20-mailparse.ini # nano /etc/php/7.0/apache2/conf.d/20-mailparse.ini and add full path as: extension=/usr/lib/php/20151012/mailparse.so the full path I got from running # find / -name *mailparse.so 3. Restart Apache: # systemctl restart apache2 4. See if apache restarted without errors: # systemctl status apache2 and now my test.php file with phpinfo(); shows mailparse support! :-)

Hi All. One of our employees decided it was happy hunting day... cancelling a lot of client's services by mistake, but does not have the option to Activate them anymore. Is there a reason they cannot/shouldn't be able to be activated again? My current solution I thought would be to edit the client's service record through mysql by changing the status to suspend and remove the canceled date, then go through the GUI and change the service's state to active again. will this do? By doing so I don't loose the valuable blissradius history if I would have created a new service. Kind regards, Chris

Okey, it seems that if I edit the products for the universal module, without changing anything, but just by opening and saving it, did the trick for me. :-) Now I get the message when saving the client's service " Domain is required. " indicating that I just need to complete the domain name field. Its working now.

using blesta 4.2.2 with PHP 7.0 and Mariadb Data was imported from WHMCS. When wanting to save a client's existing service changes under a client's service, for only some of the packages, I get the error *Something Went Wrong: Undefined property: stdClass::$service_rules

Okey, thanks. I'm always feeling excellent! :-) Just to make sure I understand correctly... My assumption and not factual: Mails created and processed gets saved in log_emails. I can leave or delete the emails records there with status as unsent, whatever I decide, and it will not have any effect. Thus, mails will not be queued in Blesta to be sent later in case the SMTP server can momentarily not be reached for what ever reason, and the mails will only be added to the logs with status "unsent", which I can leave there, or delete if it will make me feel better, thus have no effect if I leave them there? Thus I cannot rely on Blesta to make sure mails gets delivered later in case of a network or SMTP problem, like I caused intentionally for testing purposes.? Thus it will occur that clients will not receive their invoices sometimes? Excuse me if I might sound rude, I am really not and very humble.

Hi Team. We changed our smtp mail settings to a false URL to prevent them from being emailed while we are testing. Currently we have over 4000 emails (support/invoices/etc) with status Unsent. What will happen if we correctly enter the smtp address? We would like to cancel them all to prevent them from sending out if they still are to be sent. Kind Regars, Chris

I have php7.0 on ubuntu and have mbstring installed, and gcc re2c too. but no luck trying to run pecl install mailparse also getting the error The mailparse extension requires the mbstring extension but mbstring is installed. Ai, I am struggling with this one.

You are correct about the ">/dev/null 2>&1". I should have my last sentence to read " at the end, and since then and after doing all of the above my cron job problem was sorted. " I just removed momentarily the >/dev/null 2>&1 to give me visible results. :-) thanks Regarding the php.ini file for the cron job path. phpinfo from the website returns: Configuration File (php.ini) Path /etc/php/7.0/apache2 Loaded Configuration File /etc/php/7.0/apache2/php.ini whereas through ssh command: php -i | grep -i 'php.ini' returns: Configuration File (php.ini) Path => /etc/php/7.0/cli Loaded Configuration File => /etc/php/7.0/cli/php.ini when using the latter path from ssh command my cron job was running correctly.

Using apache2, php 7.0.16 on blesta 4.1.2 on Ubuntu. I also run the cron job with no results or error results although it gets executed each 5min blesta says the cron job run on the time I last ran it manually. Even when running from ssh as: /usr/bin/php -q /var/www/html/billing/index.php cron > /dev/null 2>&1 I then run it again in ssh but without the > /dev/null 2>&1 and receiving the "error: the ionCube PHP Loader needs to be installed..." although I know it is installed because blesta is working then. I remember then there is different versions of php, thus running php -i | grep -i 'php.ini' with result:Configuration File (php.ini) Path => /etc/php/7.0/cli Loaded Configuration File => /etc/php/7.0/cli/php.ini the ioncube modules is not loaded for php cli, I then added the following at the top of the php.ini file zend_extension = /usr/lib/php/20151012/ioncube_loader_lin_7.0.so Then when I ran the cron job, it actually gives me the same results as when I run it manually. I then included the > /dev/null 2>&1 at the end, and since then my cron job problem was sorted. :-)

I found that my staff had more that one record with the same name in WHMCS for some reason, although in the WHMCS front end no duplicates shows. I deleted them and tried the import again, and Voila! :-)

Good day Blesta Team I'm not used to support forums, thus don't know all the etiquette. Like posting a possible solution on a few topics (My apologies for that mistake :-) ). In this case I hope I post this here correctly instead of opening a new title? I also have the exact problem with result: decrypted 1954 values using WHMCS' custom algorithm decrypt took: 0.0649 seconds total time took: 827.9539 seconds Array ( [user_id] => Array ( [exists] => Invalid user ID. ) ) I made sure that my user with which I installed Blesta 4.2.2 is not a user in our WHMCS version 7.4.2. We do have staff that is also registered as clients, thus with the same email addresses in both. We also have different clients with contacts that are identical, thus having the same email address. I noticed in blesta.users that the username field consists of a unique username from the whmcs users, and then unique email addresses as username from the whmcs clients and/or whmcs contacts table. I assume the error is caused when the second contact whenever the same email address exists is causing the exists Invalid user ID. That is my guess. I'd like to get our system compatible or scripts in place to fix for when we have D-Day stopping WHMCS and start using Blesta. What do you suggest I do? Kind regards Chris