Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

1 Neutral

About artaweb

  • Rank

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Hello, Recently I started getting "No invoice Due" on many orders. Oddly most of the invoices goes through, even when I tested with different variations, everything goes smoothly. After enabling debug mode and waiting for the next error to show up, I got this error: SQL Error: No values to SET - Full Query: UPDATE tblclients SET WHERE id='8177' Can't related to anything. Haven't made any changes recently. Any ideas?
  2. We receive registration from two places register.php cart.php?a=checkout In this scenario I needed to remove entire billing info along with telephone number. I went ahead with Brian's suggestion. Lack of paying attention got me here. I assumed the check boxes in Optional_Client_Profile_Fields means that it shouldn't be checked and that is why I ended up here. Grrrrr I hid everything with CSS. A noteworthy tip for whoever wants to do this is to just use CSS. If you comment the HTML, it cause incorrect data being sent to your database which causes error. So what you want is to hide the fields using CSS so upon submission, it can pass the empty strings as well. I think this should be a part of whmcs core. WHMCS is a powerful selling platform and while they are focused on Hosting, it can be used for almost anything digital. So flexibility on matters like this can certainly be added value.
  3. Hello, This question might've been asked several times before, however, I did not find a genuine solution for what I am seeking. We need to disable the Billing Information entirely from the registration page. Some might say what about the domain name contact details, well in our country we use HANDLE-NIC for every single individual or companies, they don't actively register via our platform. Customers register on the nic of our country, then use their handle-nic-id to register their domain name. So we are basically asking for the billing information for nothing. Even the invoice information is irrelevant. By default we don't need any billing info to process payments since payments are done externally, if a user need to have their info on the bill, they can always fill in their details later. We recently started using Hotjar, we noticed 7.5% of conversions drops because of the long registration page. So we decided to remove it but we can't because its mandatory. Have anyone ever done this before? What we need to remove the followings: Entire Billing Section Telephone Number (we already ask for mobile number via a Custom Field) The goal is to remove anything unnecessary and make the process of registration faster. I would appreciate if you could share your experience. Thank you
  4. Defend what exactly? When they declare their module as "Compatible" with version 8+, then this means they've tested and verified its functionality. I remember it was just a year ago, their domain name expired and the entire licensing system went down which cause all our whmcs instances go down as well. What I learned during years working with whmcs, spend money on real developers to have open source code. Also, prevent adding too many module to prevent incompatibilities issues in the future.
  5. I figured it was caused by the module clientverification. What I noticed is most of the modules provided by whmcsservices/com are poorly coded. Yesterday removed all their modules.
  6. I will go with your recommendation. You are truly a gem to this community. Thank you Brian!
  7. Hello, On our registration page, the input for security question input is in password format. When our users are registering, their keyboard is always switched to another language which is not English friendly. We have this case almost everyday that someone cant get their security question right. Thanks to removing the ability to change security questions by admin, It is further complicated for us as it prolongs the support procedures. I really hope that WHMCS can see reason into questioning the user via feedback before making decisions on how the system works. WHMCS is a vital tool to our business, you can't make decisions on that alone on your own. When you do, provide an alternative as well. Anyways, what I need is to change the input for security question answer from password to text so user can see what they are typing. I know this can be done by modifying clientregister.tpl but this gets replaced every time we update the theme. Thank you
  8. This is truly annoying. Sometimes customer's keyboard is switched to another language but they type what they have in mind. Later on, on recovery we have to go through hell to reset their passwords.! Why can't we be in control? Now whmcs wants to decide how we should handle our business? We should be able to at least remove the security question.
  9. This is the full error, apparently its something with the security question Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'usedhook' in 'field list' (SQL: update `tblusers` set `usedhook` = Login, `userid` = 17807, `security_question_id` = 1, `security_question_answer` = PWyQHJ3GNahoExBZoESppWUngBb9DwfhCj/ITFM=, `tblusers`.`updated_at` = 2021-02-06 15:56:32 where `id` = 17807) in /home/username/public_html/vendor/illuminate/database/Connection.php:67 Stack trace: #0 /home/username/public_html/vendor/illuminate/database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback('update `tbluser...', Array, Object(Closure)) #1 /home/username/public_html/vendor/illuminate/database/Connection.php(496): Illuminate\Database\Connection->run('update `tbluser...', Array, Object(Closure)) #2 /home/username/public_html/vendor/illuminate/database/Connection.php(429): Illuminate\Database\Connection->affectingStatement('update `tbluser...', Array) #3 /home/username/public_html/vendor/illuminate/database/Query/Builder.php(2802): Illuminate\Database\Connection->update('update `tbluser...', Array) #4 /home/username/public_html/vendor/illuminate/database/Eloquent/Builder.php(792): Illuminate\Database\Query\Builder->update(Array) #5 /home/username/public_html/vendor/illuminate/database/Eloquent/Model.php(806): Illuminate\Database\Eloquent\Builder->update(Array) #6 /home/username/public_html/vendor/illuminate/database/Eloquent/Model.php(721): Illuminate\Database\Eloquent\Model->performUpdate(Object(Illuminate\Database\Eloquent\Builder)) #7 /home/username/public_html/vendor/whmcs/whmcs-foundation/lib/User/Traits/SecurityQuestions.php(0): Illuminate\Database\Eloquent\Model->save() #8 /home/username/public_html/register.php(0): WHMCS\User\User->setSecurityQuestion('1', 'sdfsdfsdf') #9 {main}
  10. Hello, We upgraded to version 8 (latest version) about a month ago. Apparently since then everyone signed up had this issue registering. PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'usedhook' in 'field list' in /home/crmseven/public_html/vendor/illuminate/database/Connection.php:48 Now, when user registers, their account gets created but they land on the error page, if they enter the url manually, it takes them to client area. But this error is being produced every time someone registers a new account. I've read about this issue on this forums but didn't find anything about "usedhook" issue. Please advice
  11. Hello Kian, Thank you for your response. I will update this thread once I fully tested it.
  12. Hello, Thank you for your response I am unsure how to achieve this, anyone can write me the relevant hook? I don't mind paying for the development fee. Thank you
  13. Hello, We have around 9K customers. One of the greatest features of our system that attracts lots of developers is our high paid affiliate. High paid affiliate brings lots of people who want to manipulate our system for earning more. By our terms of use, our existing customers cannot be counted as a sale for an affiliate. Let me put it in a scenario, We have an existing customer who is registered with us since 2012. Today I saw he purchased a new service but using someone else's affiliate link who registered an account only for affiliate. While he is our existing customer, this makes no sense for his future purchases, someone else get the commission. Affiliate means to bring new customers and not take credit for existing customers. While I believe this is a bad function for WHMCs affiliate system, is there any way to exempt existing customers from being counted as an affiliate sale of someone else? I hope I explained it well. I would appreciate your valuable insights. Thank you
  14. Hello, Sorry for bumping this old topic. How can the bid for product bundles get excluded from this code? (cart.php?a=add&bid=2) I am making a product bundle and its getting redirected to homepage. THis is my current code: <?php add_hook("ClientAreaPage",1,function($vars){ if (!empty($_GET['cartshare'])) { return; } # Product Groups Excluded From The Redirection $excludedGroups = array(8, 10, 11, 12, 13, 15, 6, addons, renewals); if ($vars['filename']=="cart" && in_array($_REQUEST['gid'], $excludedGroups)){ return; } if ($vars['filename']=="cart" && !isset($_REQUEST['a'])){ header("Location: index.php"); exit; } });
  15. Hi, I am trying to download this file. There is a problem with this file. Can you please attach it again?
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated