ghmercado

thank you so much!

hi the Domain Synchronisation Cron Report can become a really long list and as such is not a good reference if for example a domain lapses, especially if domains do not sync with the registrar as in my case. so wouldn'y it be better if it was a numbered list? If it was, i'd get a daily summary of how many domains are active, and if that number changes the next day i can then check can this be done? tia

this was fixed by executing this line to add the missing dir in phpmyadmin ALTER TABLE `tblhostingaddons` ADD `subscriptionid` VARCHAR(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' AFTER `notes`;

i am trying to update my whmcs installation from 8.11.2 to 8.12.0 after downloading a copy of my db via phpmyadmin i run the install process, the System Requirements Check Results says I pass all requirements, then i get Unable to complete incremental updates: Unable to import the 8.12.0 database file. Unable to import /home/wpgahm/public_html/clients/resources/sql/upgrade8120release1.sql: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'subscriptionid' any help please thank you

i have found the issue, it so happened the Billing Cycle wasn't set on that client's hosting package, ergo the message.

i set up diskspace as a 'configurable option' i made my table for 1gb (default), 5, 10, 15, 20, 50, 100, 200gb each diskspace option has pricing for one time / monthly, semi-annual and annual, except 1gb because each plan comes with 1gb free. I see it on the configuration options when someone orders a hosting plan, so that works. Ok now an existing client is running out of space on his 15gb. I want to email him how much it would cost if i upgrade his account to 20, 50, 100, etc. so while Logged in i go this client account, products/services, then More > Upgrade / Downgrade > Configurable options, and when i click diskspace i get Upgrade Summary "Error: Invalid Billing Cycle Requested" also when logged in as client, I go to Actions > Upgrade / Downgrade Options, I see the options to add Diskspace for 5, 10, 20 and so on, but at Php0.00 price each. (Php is Philippine Peso). Please advise, thank you

However, it is available in SANDBOX mode only. I had already set it up but i wanted to redo it, but now since Philippines is not an optional country I cannot. I try to login my account via the small Paypal Window that appears during setup but there's no option for Philippines. is Paypal Basic another option? is there a way around country not being an option? any help appreciated thank you i am using Version: 8.10.1

I wanted to try Site Builder on one of my domains. on whmcs, i went to my domain > products/services > + new addon > i chose the correct domain, i click Predefined Addon > Site Builder Free Trial Custom name: sitebuilder Status: active I get this: Oops! Something went wrong and we couldn't process your request. Please go back to the previous page and try again. If the problem persists, please contact us. « Back to Homepage For additional assistance, please reference the WHMCS TroubleShooting Guide » PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'subscriptionid' in 'field list' in /home/wpghm/public_html/clients/vendor/illuminate/database/Connection.php:458 Stack trace: #0 /home/wpghm/public_html/clients/vendor/illuminate/database/Connection.php(458): PDO->prepare('insert into `tb...') #1 /home/wpghm/public_html/clients/vendor/illuminate/database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}('insert into `tb...', Array) #2 /home/wpghm/public_html/clients/vendor/illuminate/database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback('insert into `tb...', Array, Object(Closure)) #3 /home/wpghm/public_html/clients/vendor/illuminate/database/Connection.php(465): Illuminate\Database\Connection->run('insert into `tb...', Array, Object(Closure)) #4 /home/wpghm/public_html/clients/vendor/illuminate/database/Connection.php(417): Illuminate\Database\Connection->statement('insert into `tb...', Array) #5 /home/wpghm/public_html/clients/vendor/illuminate/database/Query/Processors/Processor.php(32): Illuminate\Database\Connection->insert('insert into `tb...', Array) #6 /home/wpghm/public_html/clients/vendor/illuminate/database/Query/Builder.php(2771): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `tb...', Array, 'id') #7 /home/wpghm/public_html/clients/vendor/illuminate/database/Eloquent/Builder.php(1403): Illuminate\Database\Query\Builder->insertGetId(Array, 'id') #8 /home/wpghm/public_html/clients/vendor/illuminate/database/Eloquent/Model.php(900): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array) #9 /home/wpghm/public_html/clients/vendor/illuminate/database/Eloquent/Model.php(865): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array) #10 /home/wpghm/public_html/clients/vendor/illuminate/database/Eloquent/Model.php(728): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder)) #11 /home/wpghm/public_html/clients/x/clientsservices.php(0): Illuminate\Database\Eloquent\Model->save() #12 {main} Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'subscriptionid' in 'field list' (SQL: insert into `tblhostingaddons` (`hostingid`, `addonid`, `userid`, `name`, `setupfee`, `qty`, `firstpaymentamount`, `recurring`, `billingcycle`, `status`, `regdate`, `nextduedate`, `nextinvoicedate`, `termination_date`, `paymentmethod`, `tax`, `notes`, `subscriptionid`, `updated_at`, `created_at`) values (72, 38, 40, , 0, 1, 0, 0, Free Account, Pending, 2024-05-13, 0000-00-00, 0000-00-00, 0000-00-00, banktransfer, 1, , , 2024-05-13 09:06:25, 2024-05-13 09:06:25)) in /home/wpghm/public_html/clients/vendor/illuminate/database/Connection.php:671 Stack trace: #0 /home/wpghm/public_html/clients/vendor/illuminate/database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback('insert into `tb...', Array, Object(Closure)) #1 /home/wpghm/public_html/clients/vendor/illuminate/database/Connection.php(465): Illuminate\Database\Connection->run('insert into `tb...', Array, Object(Closure)) #2 /home/wpghm/public_html/clients/vendor/illuminate/database/Connection.php(417): Illuminate\Database\Connection->statement('insert into `tb...', Array) #3 /home/wpghm/public_html/clients/vendor/illuminate/database/Query/Processors/Processor.php(32): Illuminate\Database\Connection->insert('insert into `tb...', Array) #4 /home/wpghm/public_html/clients/vendor/illuminate/database/Query/Builder.php(2771): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `tb...', Array, 'id') #5 /home/wpghm/public_html/clients/vendor/illuminate/database/Eloquent/Builder.php(1403): Illuminate\Database\Query\Builder->insertGetId(Array, 'id') #6 /home/wpghm/public_html/clients/vendor/illuminate/database/Eloquent/Model.php(900): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array) #7 /home/wpghm/public_html/clients/vendor/illuminate/database/Eloquent/Model.php(865): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array) #8 /home/wpghm/public_html/clients/vendor/illuminate/database/Eloquent/Model.php(728): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder)) #9 /home/wpghm/public_html/clients/x/clientsservices.php(0): Illuminate\Database\Eloquent\Model->save() #10 {main} I figure the install didnt push through and missed a column? id appreciate phpmyadmin command to add missing column please many many thanks in advance i just want to try site builder

fixed it, i forgot to change the whmcs system url in General > Settings to 'domain/clients' after i transferred whmcs to a subdirectory.

my wordpress blog is at https://domain.com my whmcs is at https://domain.com/client admin is at https://domain.com/client/x the link to my hosting packages is working fine at https://domain.com/clients/index.php?rp=/store/managed-wordpress-hosting my created product link is also working https://domain.com/clients/index.php?rp=/store/qboxmail but when i click on ORDER NOW, it goes to https://domain.com/cart.php?a=confproduct&i=1 and this produces a wordpress 404 page. It was working bef ore i put in the wordpress blog. if its any help, here's my wordpress htaccess: # BEGIN WordPress # The directives (lines) between "BEGIN WordPress" and "END WordPress" are # dynamically generated, and should only be modified via WordPress filters. # Any changes to the directives between these markers will be overwritten. <IfModule mod_rewrite.c> RewriteEngine On RewriteRule .* - [E=HTTP_AUTHORIZATION:%{HTTP:Authorization}] RewriteBase / RewriteRule ^index\.php$ - [L] RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule . /index.php [L] </IfModule> # END WordPress here's my whmcs configuration file <?php $license = ' Leased-b502e97aaf23fdba0fc1'; $db_host = 'localhost'; $db_username = 'somedir_whmadasdbuser'; $db_password = 'asdasdasda3f'; $db_name = 'wpasdasdasdhmdb'; $cc_encryption_hash = 'Jp2asdasdasdsdasdasdkOOf189MOylvMxTBQB0n'; $templates_compiledir = '/home/somedir/templates_d/'; $mysql_charset = 'utf8'; $templates_compiledir = "/home/somedir/templates_d/"; $attachments_dir = "/home/somedir/attchments/"; $downloads_dir = "/home/somedir/ddwnloads/"; $customadminpath = "x"; date_default_timezone_set('Asia/Manila'); $display_errors = false; $whmcspath = '/home/somedir/public_html/clients/x/'; ?> any help appreciated!!

Hi i'd like to revisit this. I am using twenty-one, and i do not have configureproduct.tpl. I'd like to either delete "Have questions? Contact our sales team for assistance. Click here" OR change the link of 'CLICK HERE' to another contact page. Help appreciated thanks so much. >> a few moments later << oops i found this: and now it redirects to a form. issue resolved!

ok i fixed it. The issue was I couldn't find the 'advanced settings' on the product module's page. Instead it's a small link at the bottom titled 'switch to advanced mode' I then had to add values to the bandwidth, email accounts, space and so on. This used to work flawlessly before i had to do this and is likely due to an update. I worry now what else might not be working due to updates.

hi this same issue has me stumped. I just updated to 8.5.1 it had been working fine a week or so previous. I went to Systems Settings > Products and Services, then the tab 'Module Settings' Module name is CPanel I then configured Metric Billing > Disk Space, Bandwidth and Email accounts, then kept the rest at OFF I put values at each I still get the same error. I tried Re - saving the Packages in WHM and re-syncing / refresh the Server with WHMCS, still same error. any help appreciated thank you very much

hi i followed the ff. instructions to route outgoing email to spamexperts: To Configure Spam Experts Outgoing Filter, Login to your account and click "Services" then find Outgoing Email Filtering Service and click on active button, or the row not the domain name. Once the page loads, click on "Login to SpamExperts Control Panel". Spam Experts outgoing filter service can be configured using two methods; Outbound SMTP Server (Basic Mathod) This method uses Spam Experts as your outbound SMTP server and will require that you configure user authentication on Spam Experts dashboard. Webmail will not show sent items in this case, because all outbound Emails were not sent through the cPanel server. The first thing you will need to do, is to create an outgoing user. Click "Manage users" under the Outgoing section. Locate the "Add a user" section. Select the "Authenticating User" tab. Enter the desired username/email prefix and password and click "Add" to create the account Configuring your Email Client Mail Hostname: smtp.antispamcloud.com Mail Username: the full email address you created above Mail Password: the password you specified above Outgoing Port Number: 587 (Supports STARTTLS) Smart Host Setup (Advanced Method) This is the recommended method. It Re-routes all outgoing traffic through the system and Webmail can see all the sent Emails normally. You need to add your dedicated IP address to SpamExperts control panel. Click "Manage users" under the Outgoing section. Locate the "Add a user" section. Select the "Authenticating IP or range" tab. Enter the desired dedicated IP and click "Add". If you do not have a dedicated IP, you may purchase one from within your account for any active web hosting service. Create a technical support ticket and request support to activate Smart Host Setup for your desired domain name. when i use the outbound smtp server basic method, it works ok, although I do get the error 'your message was sent but a copy was not placed in your sent folder (sent) due to network or file access errors. You can retry or save the message locally to local folders' I also see the outgoing logs on the spamexperts dashboard. HOWEVER When I try the 'smart host setup (advanced method)', i notice no changes whatsoever. No logs appear on the dashboard and i am not assured it is working. any insight appreciated

im so sorry can you be more specific? do you mean delete this '{WHMCS Root}/templates/six/store/ssl/index.tpl'? i made the custom template years ago I've forgotten how templating works and I just want to stop this error.