Jump to content

netnow

Senior Member
  • Content count

    44
  • Joined

  • Last visited

Community Reputation

0 Neutral

About netnow

  • Rank
    Newbie

Recent Profile Visitors

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

  1. Out of the box, it appears that the client email address must be a valid single email address, and that address is paired with the imported cPnale password and is used for authentication in WHMCS client are - correct? - putting a second email address in this field with break the WHMCS cleint login sustem? Correct? - changing the client's password (using WHMCS admin system), will only change it for WHMCS client area, (not cPanel access).Correct? -N
  2. We have successfully used the 7.8.3 sync tool to get all the users loaded into the WHMCS database. As I am sure you all know, the firstname Lastname fileds in the WHMCS will now have the unix user name as first name, and admin as the last name. We are currently working an a spreadsheet that will is very close to being saved as a flat text csv file. Before I embark on authoring a a php script to update the WHMCS tblClients from the csv file, I am reaching out to see of one already exists somewhere. The idea of the script would be to: read the unix_user field from the csv and find the exact match in the firstname column of the WHMCS_tblclient. If found, move the firstname data (in tblcliennts) to the NOTES field. then update the firstname, lastname, email, address1 address2, etc. etc. etc. fields in tblsclients from the csv file. Anyone? -N
  3. netnow

    Sync Tool - Resellers

    Using the server sync tool to clean up the clients info this morning. Hundreds of clients synced fine, but have about 50 'pink' ones showing they do not exist on server (WHM/CPanel) . a few of them dont exists so I will delete client account. But many of them do exist, but are not owned as root in WHM but are showing owned as a re seller name. We still bill these clients therefor need them in our WHMCS client database. Is there a way to force or trick the import? Example below, he green strikeouts below in the pink result area DO exist on the WHM server.
  4. OK, thanks Chris. I have set the caching to: MariaDB [(none)]> SHOW VARIABLES LIKE '%query_cache%'; +------------------------------+----------+ | Variable_name | Value | +------------------------------+----------+ | have_query_cache | YES | | query_cache_limit | 1048576 | | query_cache_min_res_unit | 4096 | | query_cache_size | 16777216 | | query_cache_strip_comments | OFF | | query_cache_type | ON | | query_cache_wlock_invalidate | OFF | +------------------------------+----------+ We'll see if this helps at all. -N
  5. Is there a script or command somewhere that actually checks data base and table structure to ensure its correct for the version of WHMCS installed?
  6. A moderate amount of research indicates that increasing MariaDB query_cache_size should solve or severely lessen the frequency of the failures. All things being equal, and the system being "Live" we are getting ave of 2 emails a day indicating the the failure shown in the original post. Does anyone here recommend setting the query cache size? (Currently at 0) if so, to what value? A side question is: Are these failures causing any damage, or, just failing and not doing anything? And is the 'work' that they should have done being caught up later? i.e. can we simply ignore these errors? -N
  7. Still getting fails. Interesting that they seem to happen when things (domains, payment portal) are live and not in test mode, -N
  8. netnow

    Ticketing Emails

    Yup, Was able to confirm that if I am adding a ticket as a client in the portal and have WHMCS admin or cookies left over, the email wont be sent to me. -N
  9. netnow

    Ticketing Emails

    Nope, we use a third party mail scanning service with a quarantine area not there either. Seems that I cant submit a ticket from the portal on a machine that uses the same IP as a machine used to be in admin site. Make sense? -N
  10. I have 3 admin users setup. Each of them set to valid off site email addresses, and have the "enable Ticket Notifications" button checked on all three. One account however is NOT getting ticket notification emails. I was wondering if there are other areas of WHMCS/WHM that need to be checked to specifically allow the notification emails to flow? -N
  11. Checking email and errors... The last fail email and error_log entry was at 4:30 PM yesterday. At 5:30 PM ish I added the localhost IP and all the other ifconfig is to the /admin/ directory .htacces allow from statement. No errors since. I am hoping this is fixed ... time will tell. -N
  12. Chris, When I request version from the command line, I get: [root@<SERVER> ~]# mysql -V mysql Ver 15.1 Distrib 10.0.38-MariaDB, for Linux (x86_64) using readline 5.1
  13. Well, in the root users error log I was able to find this, which I suppose is the same ish as the original post. Certainly an sql error, but why? [11-Nov-2019 16:30:01 America/Toronto] [WHMCS Application] ERROR: PDOException: SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared in /home/<REDACTED>/public_html/portal/vendor/illuminate/database/Connection.php:335 Stack trace: #0 /home/<REDACTED>/public_html/portal/vendor/illuminate/database/Connection.php(335): PDOStatement->execute(Array) #1 /home/<REDACTED>/public_html/portal/vendor/illuminate/database/Connection.php(706): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'select * from `...', Array) #2 /home/<REDACTED>/public_html/portal/vendor/illuminate/database/Connection.php(669): Illuminate\Database\Connection->runQueryCallback('select * from `...', Array, Object(Closure)) #3 /home/<REDACTED>/public_html/portal/vendor/illuminate/database/Connection.php(342): Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure)) #4 /home/<REDACTED>/public_html/portal/vendor/illuminate/database/Query/Builder.php(1583): Illuminate\Database\Connection->select('select * from `...', Array, true) #5 /home/<REDACTED>/public_html/portal/vendor/illuminate/database/Query/Builder.php(1569): Illuminate\Database\Query\Builder->runSelect() #6 /home/<REDACTED>/public_html/portal/vendor/illuminate/database/Eloquent/Builder.php(624): Illuminate\Database\Query\Builder->get(Array) #7 /home/<REDACTED>/public_html/portal/vendor/illuminate/database/Eloquent/Builder.php(316): Illuminate\Database\Eloquent\Builder->getModels(Array) #8 /home/<REDACTED>/public_html/portal/vendor/illuminate/database/Eloquent/Model.php(642): Illuminate\Database\Eloquent\Builder->get(Array) #9 /home/<REDACTED>/public_html/portal/vendor/whmcs/whmcs-foundation/lib/Cron/Task/UpdateDomainExpiryStatus.php(0): Illuminate\Database\Eloquent\Model::all() #10 /home/<REDACTED>/public_html/portal/vendor/illuminate/database/Eloquent/Model.php(497): WHMCS\Cron\Task\UpdateDomainExpiryStatus->__construct(Array) #11 /home/<REDACTED>/public_html/portal/vendor/whmcs/whmcs-foundation/lib/Scheduling/Task/Collection.php(0): Illuminate\Database\Eloquent\Model->newInstance(Array, true) #12 /home/<REDACTED>/public_html/portal/vendor/whmcs/whmcs-foundation/lib/Scheduling/Task/Collection.php(0): WHMCS\Scheduling\Task\Collection->filterToTasks(Array) #13 /home/<REDACTED>/public_html/portal/vendor/whmcs/whmcs-foundation/lib/Scheduling/Task/AbstractTask.php(0): WHMCS\Scheduling\Task\Collection->__construct(Array) #14 /home/<REDACTED>/public_html/portal/vendor/illuminate/database/Eloquent/Builder.php(325): WHMCS\Scheduling\Task\AbstractTask->newCollection(Array) #15 /home/<REDACTED>/public_html/portal/vendor/illuminate/database/Eloquent/Model.php(642): Illuminate\Database\Eloquent\Builder->get(Array) #16 /home/<REDACTED>/public_html/portal/vendor/whmcs/whmcs-foundation/lib/Cron/Console/Helper/TaskCollectionHelper.php(0): Illuminate\Database\Eloquent\Model::all() #17 /home/<REDACTED>/public_html/portal/vendor/whmcs/whmcs-foundation/lib/Cron/Console/Helper/TaskCollectionHelper.php(0): WHMCS\Cron\Console\Helper\TaskCollectionHelper->allTasks() #18 /home/<REDACTED>/public_html/portal/vendor/whmcs/whmcs-foundation/lib/Cron/Console/Application.php(0): WHMCS\Cron\Console\Helper\TaskCollectionHelper->addTasksAsOptions(Object(WHMCS\Cron\Console\Command\DoCommand)) #19 /home/<REDACTED>/public_html/portal/vendor/symfony/console/Application.php(90): WHMCS\Cron\Console\Application->getDefaultCommands() #20 /home/<REDACTED>/portaldata/crons/cron.php(0): Symfony\Component\Console\Application->__construct('WHMCS Automatio...', '7.8.3-release.1') #21 {main} Next Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared (SQL: select * from `tbldomainpricing` order by `tbldomainpricing`.`order` asc, `tbldomainpricing`.`id` asc) in /home/<REDACTED>/public_html/portal/vendor/illuminate/database/Connection.php:713 Stack trace: #0 /home/<REDACTED>/public_html/portal/vendor/illuminate/database/Connection.php(669): Illuminate\Database\Connection->runQueryCallback('select * from `...', Array, Object(Closure)) #1 /home/<REDACTED>/public_html/portal/vendor/illuminate/database/Connection.php(342): Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure)) #2 /home/<REDACTED>/public_html/portal/vendor/illuminate/database/Query/Builder.php(1583): Illuminate\Database\Connection->select('select * from `...', Array, true) #3 /home/<REDACTED>/public_html/portal/vendor/illuminate/database/Query/Builder.php(1569): Illuminate\Database\Query\Builder->runSelect() #4 /home/<REDACTED>/public_html/portal/vendor/illuminate/database/Eloquent/Builder.php(624): Illuminate\Database\Query\Builder->get(Array) #5 /home/<REDACTED>/public_html/portal/vendor/illuminate/database/Eloquent/Builder.php(316): Illuminate\Database\Eloquent\Builder->getModels(Array) #6 /home/<REDACTED>/public_html/portal/vendor/illuminate/database/Eloquent/Model.php(642): Illuminate\Database\Eloquent\Builder->get(Array) #7 /home/<REDACTED>/public_html/portal/vendor/whmcs/whmcs-foundation/lib/Cron/Task/UpdateDomainExpiryStatus.php(0): Illuminate\Database\Eloquent\Model::all() #8 /home/<REDACTED>/public_html/portal/vendor/illuminate/database/Eloquent/Model.php(497): WHMCS\Cron\Task\UpdateDomainExpiryStatus->__construct(Array) #9 /home/<REDACTED>/public_html/portal/vendor/whmcs/whmcs-foundation/lib/Scheduling/Task/Collection.php(0): Illuminate\Database\Eloquent\Model->newInstance(Array, true) #10 /home/<REDACTED>/public_html/portal/vendor/whmcs/whmcs-foundation/lib/Scheduling/Task/Collection.php(0): WHMCS\Scheduling\Task\Collection->filterToTasks(Array) #11 /home/<REDACTED>/public_html/portal/vendor/whmcs/whmcs-foundation/lib/Scheduling/Task/AbstractTask.php(0): WHMCS\Scheduling\Task\Collection->__construct(Array) #12 /home/<REDACTED>/public_html/portal/vendor/illuminate/database/Eloquent/Builder.php(325): WHMCS\Scheduling\Task\AbstractTask->newCollection(Array) #13 /home/<REDACTED>/public_html/portal/vendor/illuminate/database/Eloquent/Model.php(642): Illuminate\Database\Eloquent\Builder->get(Array) #14 /home/<REDACTED>/public_html/portal/vendor/whmcs/whmcs-foundation/lib/Cron/Console/Helper/TaskCollectionHelper.php(0): Illuminate\Database\Eloquent\Model::all() #15 /home/<REDACTED>/public_html/portal/vendor/whmcs/whmcs-foundation/lib/Cron/Console/Helper/TaskCollectionHelper.php(0): WHMCS\Cron\Console\Helper\TaskCollectionHelper->allTasks() #16 /home/<REDACTED>/public_html/portal/vendor/whmcs/whmcs-foundation/lib/Cron/Console/Application.php(0): WHMCS\Cron\Console\Helper\TaskCollectionHelper->addTasksAsOptions(Object(WHMCS\Cron\Console\Command\DoCommand)) #17 /home/<REDACTED>/public_html/portal/vendor/symfony/console/Application.php(90): WHMCS\Cron\Console\Application->getDefaultCommands() #18 /home/<REDACTED>/portaldata/crons/cron.php(0): Symfony\Component\Console\Application->__construct('WHMCS Automatio...', '7.8.3-release.1') #19 {main} {"exception":"[object] (Illuminate\\Database\\QueryException(code: HY000): SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared (SQL: select * from `tbldomainpricing` order by `tbldomainpricing`.`order` asc, `tbldomainpricing`.`id` asc) at /home/<REDACTED>/public_html/portal/vendor/illuminate/database/Connection.php:713, PDOException(code: HY000): SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared at /home/<REDACTED>/public_html/portal/vendor/illuminate/database/Connection.php:335)"} []
  14. Nope, The daily run isn't whats causing the failed html output emails. I am getting the daily emails no problem, identical to the ones above. I still suspect it has something to do with domain status updates.... In case I haven't mentioned, PAYMENT and DOMAIN modules are both in test mode. -N
×

Important Information

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