LukeDouglas

I have used WHMCS for about 10 years and I am still amazed that on the Reports list there is NOT a past due invoice report with an option for 30, 60, 90 days past due. I have a one-man website firm with about 70 clients who pay me in multiple ways, most NOT automatic. I've searched the forums but have been unable to find a solution. Has someone created a report or have a way they use the 'Aging Invoice' report to obtain this information? I've struck out. 😞

I uploaded the file to the WHMCS root and opened it via a browser. I get the same message: "404 Category not found" I checked the file via a command line from my computer and got this message: 'https:' is not recognized as an internal or external command, operable program or batch file. I changed the https to http in the command line and go this message: 'http:' is not recognized as an internal or external command, operable program or batch file. So I went to my WHM server admin Terminal and open the file and got this message: Permission denied So I am 'assuming' that the 'Permission denied' is a good result. Am I correct?

I put the code in the WHMCS core folder HTACCESS file. Also, my server is running Apache/2.4.41. Again, the security article is a bit cryptic, at least to me.

So can someone explain if the '404 Category Not Found' message is good or bad! From what I read, if you don't get a directory listing of the 'vendor' folder, then that is good thus a '404 Category Not Found' message is good. However, if this is incorrect, I would appreciate some clarification. Honestly, WHMCS should have listed what is a good result and what is a bad result when you went to that URL link. FYI, the code below blocks me from access the WHMCS application. <Location "/vendor/"> Require all denied </Location>

I checked the link https://www.example.com/path/to/whmcs/vendor/composer/LICENSE , but with my billing url link + vendor/composer/LICENSE, that was recommended by an email I received today to view the 'license' document but it returned a 404 Category Not Found message. So I assume that means my system is not affected by this issue described in the link below. If that is correct, I would 'highly' recommend that the security advisory page be updated to include the results if there is no issue. However, if this response 404 Category Not Found display means my billing has an issue, please let me know. https://docs.whmcs.com/Security_Advisory_2020-01-28

My confusion is the field in the "tblemailtemplates.schema.sql." is shown as 'blind_copy_to' yet the previous recommendation was to add the field 'blindcopyto'. Once I added the field 'blindcopyto', I was able to edit the template normally without any errors. This was in reference to 'Brian!' response concerning the error: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'blindcopyto' in 'field list' in /home/XXXXXXXX/public_html/billing/vendor/illuminate/database/Connection.php:462 Then a WHMCS support person sent me an update to a ticket with the comment "I found that the "blind_copy_to" field was missing from your tblemailtemplates database table. I have created this for you now." When I checked the table, the 'blindcopyto' field name was now replaced by 'blind_copy_to'. So I edited a template and it saved normally without any errors. Now I have done application development for about 30+ years of my life and I'm pretty darn sure that 'blindcopyto' and 'blind_copy_to' would be viewed as two completely different fields in code. So how in the heck does both work without one of them throwing an error?

ChrisD, I downloaded the 7.6.1 version, extracted to a folder and looked at the 'install.sql'. Here is the tblemailtemplates table setup. There is NO "blindcopyto" field. I checked the entire install.sql file and there is no 'blindcopyto' field at all in any table. 🙂 I added the field, edited a template and it saved the changes. -- -- Table structure for table `tblemailtemplates` -- CREATE TABLE IF NOT EXISTS `tblemailtemplates` ( `id` int(1) unsigned zerofill NOT NULL auto_increment, `type` text COLLATE utf8_unicode_ci NOT NULL, `name` text COLLATE utf8_unicode_ci NOT NULL, `subject` text COLLATE utf8_unicode_ci NOT NULL, `message` text COLLATE utf8_unicode_ci NOT NULL, `fromname` text COLLATE utf8_unicode_ci NOT NULL, `fromemail` text COLLATE utf8_unicode_ci NOT NULL, `disabled` text COLLATE utf8_unicode_ci NOT NULL, `custom` text COLLATE utf8_unicode_ci NOT NULL, `language` text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Well, it's pretty darn impossible to undo what has been done. As far as restoring the table from a previous backup, I'm not sure exactly what that would accomplish as the table structure hasn't changed. I'll open a ticket with support.

So I made a change to the description of an email template but when I went to save the change, I got the following error. Anyone have a clue what went wrong? PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'blindcopyto' in 'field list' in /home/XXXXXXXX/public_html/billing/vendor/illuminate/database/Connection.php:462 Stack trace: #0 /home/XXXXXXXX/public_html/billing/vendor/illuminate/database/Connection.php(462): PDO->prepare('update `tblemai...') #1 /home/XXXXXXXX/public_html/billing/vendor/illuminate/database/Connection.php(706): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'update `tblemai...', Array) #2 /home/XXXXXXXX/public_html/billing/vendor/illuminate/database/Connection.php(669): Illuminate\Database\Connection->runQueryCallback('update `tblemai...', Array, Object(Closure)) #3 /home/XXXXXXXX/public_html/billing/vendor/illuminate/database/Connection.php(467): Illuminate\Database\Connection->run('update `tblemai...', Array, Object(Closure)) #4 /home/XXXXXXXX/public_html/billing/vendor/illuminate/database/Connection.php(410): Illuminate\Database\Connection->affectingStatement('update `tblemai...', Array) #5 /home/XXXXXXXX/public_html/billing/vendor/illuminate/database/Query/Builder.php(2071): Illuminate\Database\Connection->update('update `tblemai...', Array) #6 /home/XXXXXXXX/public_html/billing/vendor/illuminate/database/Eloquent/Builder.php(531): Illuminate\Database\Query\Builder->update(Array) #7 /home/XXXXXXXX/public_html/billing/vendor/illuminate/database/Eloquent/Model.php(1551): Illuminate\Database\Eloquent\Builder->update(Array) #8 /home/XXXXXXXX/public_html/billing/vendor/illuminate/database/Eloquent/Model.php(1470): Illuminate\Database\Eloquent\Model->performUpdate(Object(Illuminate\Database\Eloquent\Builder), Array) #9 /home/XXXXXXXX/public_html/billing/administrator/configemailtemplates.php(0): Illuminate\Database\Eloquent\Model->save() #10 {main} Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'blindcopyto' in 'field list' (SQL: update `tblemailtemplates` set `updated_at` = 2019-01-19 00:19:43, `blindcopyto` = where `id` = 29) in /home/XXXXXXXX/public_html/billing/vendor/illuminate/database/Connection.php:713 Stack trace: #0 /home/XXXXXXXX/public_html/billing/vendor/illuminate/database/Connection.php(669): Illuminate\Database\Connection->runQueryCallback('update `tblemai...', Array, Object(Closure)) #1 /home/XXXXXXXX/public_html/billing/vendor/illuminate/database/Connection.php(467): Illuminate\Database\Connection->run('update `tblemai...', Array, Object(Closure)) #2 /home/XXXXXXXX/public_html/billing/vendor/illuminate/database/Connection.php(410): Illuminate\Database\Connection->affectingStatement('update `tblemai...', Array) #3 /home/XXXXXXXX/public_html/billing/vendor/illuminate/database/Query/Builder.php(2071): Illuminate\Database\Connection->update('update `tblemai...', Array) #4 /home/XXXXXXXX/public_html/billing/vendor/illuminate/database/Eloquent/Builder.php(531): Illuminate\Database\Query\Builder->update(Array) #5 /home/XXXXXXXX/public_html/billing/vendor/illuminate/database/Eloquent/Model.php(1551): Illuminate\Database\Eloquent\Builder->update(Array) #6 /home/XXXXXXXX/public_html/billing/vendor/illuminate/database/Eloquent/Model.php(1470): Illuminate\Database\Eloquent\Model->performUpdate(Object(Illuminate\Database\Eloquent\Builder), Array) #7 /home/XXXXXXXX/public_html/billing/administrator/configemailtemplates.php(0): Illuminate\Database\Eloquent\Model->save() #8 {main}

On the Products & Services, there is a "Subscription ID" location which I understand is where PayPal will return a "Subscription ID" if the customer agrees to having subscriptions paid automatically. However, can this be used with the PayPal Payments Standard or must I upgrade to PayPal Payments Pro and/or subscribe to PayPal's Enhanced Recurring Payments service? If a customer logs into their billing account, clicks on an invoice and clicks on the payment button, when they get to PayPal, will PayPal ask them if they want to setup a subscription for this service that they are paying for? If so, then I 'assume' a "Subscription ID" is returned and the product record is updated to store this ID. Then the next month when the next invoice is generated, the WHMCS system will automatically contact PayPal to have the 'invoice' paid by the customer payment source? I appreciate any feedback anyone can give. Thanks. Luke

John, Thanks. Once I renamed that module by prefixing the filename with "LEGACY_CAN_BE_REMOVED_", I was able to access the Addon Modules. None of the Addon's including the 'ip_monitor' and 'ip_manager' were activated. So I have renamed those folders using the prefix 'LEGACY_CAN_BE_REMOVED_'. After a month or two, I'll actually remove the folders. I know it sounds I'm paranoid but I've been in this game too long to delete something outright.

Here is the display errors: Whoops\Exception\ErrorException: The file /home/webbcom/public_html/billing/modules/addons/enomnewtlds/enomnewtlds.php was encoded by the ionCube Encoder for PHP 5.0 and cannot run under PHP 7.0.Please ask the provider of the script to provide a version encoded with the ionCube Encoder for PHP 5.6. in Unknown:0Stack trace:#0 /home/webbcom/public_html/billing/vendor/whmcs/whmcs-foundation/lib/Utility/Error/Run.php(0): WHMCS\Utility\Error\Run->handleError(16, 'The file /home/...', 'Unknown', 0)#1 [internal function]: WHMCS\Utility\Error\Run->handleShutdown()#2 {main} Now when I attempted to upgrade to 7.5.0, it gave me an ionCube Encoder error message indicating that I needed ionCube Encoder 10.0 for the upgrade. I had the server admin to install it and the 7.5.0 upgrade went smoothly. The site is running under PHP 7.0 and according to the server admin, that version of ionCube loader required PHP 7.0 or higher. Which begs the question why I am getting this message? Am I going to have to switch back to PHP 5.6, have the server admin to restsore the ionCube Encoder for PHP 5.6, then go to the AddOn Modules (if it will load), just to disable these two modules, then swtich back to PHP 7.0 and have the server admin's restore the ionCube Loader for PHP 7.0? That is a hell of a lot of work to do for removing some legacy modules.

John, I restored the filenames but when I went to the Setup > Addon Modules page, I get the warning below. I went to the previous page, tried again but same thing. I logged out. Shut down browser. Opened browser, clean cache and tried again. Same thing. Any other ideas? Oops! Something went wrong and we couldn't process your request. Please go back to the previous page and try again.

After updating to 7.5, I got an email which warned: One or more legacy modules were found to be in use and were not attempted to be deleted: ip_manager, ip_monitor I searched the forums but could find nothing for ip_manager or ip_monitor. So I did a general internet search and got this page which states: URL: http://help.whmcs.com/m/75601/l/850628-troubleshooting-a-failed-to-remove-legacy-modules-error Solution The recommendation is to manually delete the module files from your WHMCS directory via FTP. They are located within the /modules folder. I searched and found the two folders in public_html/billing/modules/admin folder. Instead of deleting the folders, I added the prefix 'LEGACY-' to the folder names so they wouldn't be found. Should I just go ahead and delete these folders and will it be safe to do so?

Brian, It is confirmed. I'm blind. Changed to Six! thanks. Luke

Brian, Thanks for responding. I guess my biggest issue is that I have been all over the Setup area and cannot find the 'Six' template setting anywhere. I did a search on the WHMCS for 'template' and all it gave me was the section on how to customize a template. I found no documentation that indicated how to change the default template. I did change the Ordering template to 'Boxes' as that indicated it was still supported. I've never changed the original template as I have used WHMCS just as it was originally installed well over 6-7 years ago. If you can tell me how I can change the default template to 'Six' or point me to the documentation link that explains how to do this, I would appreciate it.

Can anyone help?

When attempting to upgrade WHMCS 7.0.1 to 7.4.2, I get this error message: Update Failed An error occurred that prevented the update from completing successfully. Unable to complete incremental updates: Unable to import the 7.1.0 Beta1 database file. Unable to import /home/xxxxxxxx/public_html/billing/resources/sql/upgrade710beta1.sql: SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'xxxxxxxx_xxxxxxx'@'localhost' to database 'xxxxxxxx_whmcs_xxxxxxxxxx' Please try again and if the issue persists, please contact support. If I click the Configure Settings on the update page, I get this error: An error occurred while communicating with the server. Please try again. PHPINFO - core: Core PHP Version 7.0.27 Directive Local Value Master Value allow_url_fopen On On allow_url_include On On arg_separator.input & & arg_separator.output & & auto_append_file no value no value auto_globals_jit On On auto_prepend_file no value no value browscap no value no value default_charset UTF-8 UTF-8 default_mimetype text/html text/html disable_classes no value no value disable_functions no value no value display_errors On Off display_startup_errors Off Off doc_root no value no value docref_ext no value no value docref_root no value no value enable_dl Off Off enable_post_data_reading On On error_append_string no value no value error_log error_log error_log error_prepend_string no value no value error_reporting 32759 32759 exit_on_timeout Off Off expose_php Off Off extension_dir /opt/cpanel/ea-php70/root/usr/lib64/php/modules /opt/cpanel/ea-php70/root/usr/lib64/php/modules file_uploads On On highlight.comment #FF8000 #FF8000 highlight.default #0000BB #0000BB highlight.html #000000 #000000 highlight.keyword #007700 #007700 highlight.string #DD0000 #DD0000 html_errors On On ignore_repeated_errors Off Off ignore_repeated_source Off Off ignore_user_abort Off Off implicit_flush Off Off include_path .:/opt/cpanel/ea-php70/root/usr/share/pear .:/opt/cpanel/ea-php70/root/usr/share/pear input_encoding no value no value internal_encoding no value no value log_errors On On log_errors_max_len 1024 1024 mail.add_x_header On On mail.force_extra_parameters no value no value mail.log no value no value max_execution_time 90 30 max_file_uploads 20 20 max_input_nesting_level 64 64 max_input_time 60 60 max_input_vars 1000 1000 memory_limit 384M 64M open_basedir no value no value output_buffering no value no value output_encoding no value no value output_handler no value no value post_max_size 64M 10M precision 14 14 realpath_cache_size 4096K 4096K realpath_cache_ttl 120 120 register_argc_argv On On report_memleaks On On report_zend_debug On On request_order GP GP sendmail_from no value no value sendmail_path /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i serialize_precision 100 100 short_open_tag On On SMTP localhost localhost smtp_port 25 25 sql.safe_mode Off Off sys_temp_dir no value no value track_errors Off Off unserialize_callback_func no value no value upload_max_filesize 63M 10M upload_tmp_dir no value no value user_dir no value no value user_ini.cache_ttl 300 300 user_ini.filename .user.ini .user.ini variables_order GPCS GPCS xmlrpc_error_number 0 0 xmlrpc_errors Off Off zend.assertions -1 -1 zend.detect_unicode On On zend.enable_gc On On zend.multibyte Off Off zend.script_encoding no value no value This is an AutoSSL secured site. I'm not sure if that is the issue. I need some feedback on what is the issue.

Chris, Thanks for the prompt response. I did check and the Force One Time Payments is unchecked as well as the Force Subscriptions is unchecked. While I would prefer for clients to setup subscriptions, I do want them to have the ability to pay one invoice at a time, at least for the time being. So I was going to create a new Product Name and clicked Continued, I get a complete blank page now. Note this was after the activation of the SSL but I commented out the SSL redirect and tried as HTTP but got the same results. The URL is https://www.webbering.com/billing/XXXXXXXX/configproducts.php?action=edit&id=26 (note the XXXXXXX is the custom admin folder. It's been a few months since I actually added a new product so I really don't know if this is something current or been an undiscovered issue. Any suggestions?

Chris, Thanks...That was the issue. Once I set that, it immediately marked the invoice as paid upon payment completion and it did return to the invoice showing it was paid. Now, on to setting up automatic payments. Is there a way to have the invoice automatically paid when it is generated by the nightly cron job?

I checked the gateway log and this is what it has (NOTE: I have replace some private data with 'XXXXX'): mc_gross => 1.00 protection_eligibility => Ineligible payer_id => XXXXXXXXXXXXXXXXXXXX tax => 0.00 payment_date => 10:53:08 Feb 03, 2018 PST payment_status => Completed charset => windows-1252 first_name => Lucius mc_fee => 0.33 notify_version => 3.8 custom => 204253 payer_status => unverified business => webbering@gmail.com quantity => 1 verify_sign => AfspwrgT-XXXXXXXXXXXXXXXXXXXX.9LYz3Ytc5 payer_email => lukedouglas@gmail.com txn_id => XXXXXXXXXXXXXXXXXXXX payment_type => instant last_name => Douglas receiver_email => webbering@gmail.com payment_fee => 0.33 shipping_discount => 0.00 receiver_id => XXXXXXXXXXXXXXXXXXXX insurance_amount => 0.00 txn_type => web_accept item_name => Webbering - Invoice #204253 discount => 0.00 mc_currency => USD item_number => residence_country => US receipt_id => 0142-XXXXXXXXXXXXXXXXXXXX-1841 shipping_method => Default transaction_subject => payment_gross => 1.00 ipn_track_id => XXXXXXXXXXXXXXXXXXXX

I have setup a PayPal gateway with the correct API settings. I setup a test account with a $1.00 invoice. I logged into the test account name, select the invoice, clicked the Pay Selected. It sent me to the invoice with the PayPal link at the top right as follows: UnpaidPayPal I clicked on it, it took me to PayPal, I selected the Pay with Credit/Debit card, and paid the invoice. The payment transaction completed normally and the funds were put into my PayPal account. However, when it returned me to the billing website, it displayed the invoice which was still showing as 'Unpaid'. I went back to the Client Area Home Page and the invoice is still showing as unpaid. So how do I ensure that if a valid payment is made via PayPal that the invoice will be updated with the payment information including the PayPal Transaction ID?

Brian, Thanks for the clarification! I've bookmarked that location.

I lease a server with HostGator and I install updates to my WHMCS panel as soon as I see them. However, when I go to the release notes, it has all release information for version 66 but does not list what changes or updates were included in specific updates such as v66.0.26. Is there any page I can go to that can show what specifically was included in an individual update or is this information simply not available in this format?

It's enabled for me also so that isn't the issue.