Skip to Content Skip to Menu

PHP Exception

3 years 7 months ago #324118 by silverman1
PHP Exception was created by silverman1
I have enabled a feature in Admin tools that sends me a email if it finds a PHP exception. I have been getting a few emails with this message lately:

A PHP Exception occurred on your site. Here you can find the stack trace:

Exception Type: JDatabaseExceptionExecuting
File: public_html/libraries/joomla/database/driver/mysqli.php
Line: 665
Message: Duplicate entry '1070-1331' for key 'read'

From what I can see in the rest of the stack trace it has something to do with a message (1331) that has been sent within CB. Not sure what this means, but maybe the same message has been sent twice? Is this something to worry about? I can show the rest of the code if you need to see it.

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • OFFLINE
  • Posts: 48541
  • Thanks: 8290
  • Karma: 1445
3 years 7 months ago #324119 by krileon
Replied by krileon on topic PHP Exception
Sounds like a duplicate entry is trying to be stored in _comprofiler_plugin_messages_read database table. Can you provide the full stack trace so I can see where that store is coming from?

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

3 years 7 months ago #324120 by silverman1
Replied by silverman1 on topic PHP Exception
Code:
#0/public_html/libraries/joomla/database/driver.php(1421): JDatabaseDriverMysqli->execute() #1/public_html/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php(523): JDatabaseDriver->insertObject('#__comprofiler_...', Object(CB\Plugin\PMS\Table\ReadTable), 'id') #2/public_html/libraries/CBLib/CBLib/Database/Table/Table.php(160): CBLib\Database\Driver\CmsDatabaseDriver->insertObject('#__comprofiler_...', Object(CB\Plugin\PMS\Table\ReadTable), 'id') #3/public_html/components/com_comprofiler/plugin/user/plug_pms_mypmspro/library/Table/ReadTable.php(87): CBLib\Database\Table\Table->store(false) #4/public_html/components/com_comprofiler/plugin/user/plug_pms_mypmspro/library/Table/MessageTable.php(482): CB\Plugin\PMS\Table\ReadTable->store() #5/public_html/components/com_comprofiler/plugin/user/plug_pms_mypmspro/component.pms.mypmspro.php(445): CB\Plugin\PMS\Table\MessageTable->setRead(1070, 1) #6/public_html/components/com_comprofiler/plugin/user/plug_pms_mypmspro/component.pms.mypmspro.php(105): CBplug_pmsmypmspro->showMessage(1331, Object(CB\Database\Table\UserTable)) #7/public_html/libraries/CBLib/CB/Legacy/cbPluginHandler.php(885): CBplug_pmsmypmspro->getCBpluginComponent(NULL, Object(CB\Database\Table\UserTable), 1, Array, NULL) #8/public_html/libraries/CBLib/CB/Legacy/cbTabs.php(1442): cbPluginHandler->call(15, 'getCBpluginComp...', 'CBplug_pmsmypms...', Array, NULL) #9/public_html/libraries/CBLib/CB/Legacy/cbTabs.php(1556): cbTabs->_callTabPlugin(NULL, Object(CB\Database\Table\UserTable), 'CBplug_pmsmypms...', 'getCBpluginComp...', '15', Array) #10/public_html/components/com_comprofiler/comprofiler.php(719): cbTabs->tabClassPluginTabs(Object(CB\Database\Table\UserTable), Array, 'pms.mypmspro', 'CBplug_pmsmypms...', 'getCBpluginComp...') #11/public_html/components/com_comprofiler/comprofiler.php(274): tabClass('com_comprofiler', 'pluginclass', 1070) #12/public_html/libraries/src/Component/ComponentHelper.php(402): require_once('/home/u19760082...') #13/public_html/libraries/src/Component/ComponentHelper.php(377): Joomla\CMS\Component\ComponentHelper::executeComponent('/home/u19760082...') #14/public_html/libraries/src/Application/SiteApplication.php(194): Joomla\CMS\Component\ComponentHelper::renderComponent('com_comprofiler') #15/public_html/libraries/src/Application/SiteApplication.php(233): Joomla\CMS\Application\SiteApplication->dispatch() #16/public_html/libraries/src/Application/CMSApplication.php(196): Joomla\CMS\Application\SiteApplication->doExecute() #17/public_html/index.php(49): Joomla\CMS\Application\CMSApplication->execute() #18 {main} Request information GET variables Array ( [return] => aHR0cHM6Ly93d3cucGFudGllbG92ZS5jb20vcHJvZmlsZS9tZXNzYWdlcw== [Itemid] => 183 [option] => com_comprofiler [view] => pluginclass [plugin] => pms.mypmspro [action] => message [func] => show [id] => 1331 [task] => pluginclass ) POST variables Array ( ) COOKIE variables Array ( [reDimCookieHint] => 1 [_ga] => GA1.1.1381247993.1617102044 [__cfduid] => d2490be9d6bb78bdd79d0b0bacbbb613e1617117103 [99547323dbb5efb391105412420017e7] => 24f2e0a48d91d1244b1ea80495c495eb [joomla_user_state] => logged_in [_ga_9QSB3ZGZM0] => GS1.1.1617197240.6.1.1617197365.0 ) REQUEST variables Array ( [return] => aHR0cHM6Ly93d3cucGFudGllbG92ZS5jb20vcHJvZmlsZS9tZXNzYWdlcw== [reDimCookieHint] => 1 [_ga] => GA1.1.1381247993.1617102044 [__cfduid] => d2490be9d6bb78bdd79d0b0bacbbb613e1617117103 [99547323dbb5efb391105412420017e7] => 24f2e0a48d91d1244b1ea80495c495eb [joomla_user_state] => logged_in [_ga_9QSB3ZGZM0] => GS1.1.1617197240.6.1.1617197365.0 [Itemid] => 183 [option] => com_comprofiler [view] => pluginclass [plugin] => pms.mypmspro [action] => message [func] => show [id] => 1331 [task] => pluginclass ) SERVER variables Array ( [LSPHP_ProcessGroup] => on [PATH] => /usr/local/bin:/bin:/usr/bin [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9 [HTTP_ACCEPT_ENCODING] => gzip [HTTP_ACCEPT_LANGUAGE] => sk-SK,sk;q=0.9,cs;q=0.8,en-US;q=0.7,en;q=0.6 [HTTP_CONNECTION] => Keep-Alive [HTTP_COOKIE] => reDimCookieHint=1; _ga=GA1.1.1381247993.1617102044; __cfduid=d2490be9d6bb78bdd79d0b0bacbbb613e1617117103; 99547323dbb5efb391105412420017e7=24f2e0a48d91d1244b1ea80495c495eb; joomla_user_state=logged_in; _ga_9QSB3ZGZM0=GS1.1.1617197240.6.1.1617197365.0 [HTTP_HOST] => www.site.com [HTTP_REFERER] => https://www.site.com/profile/messages [HTTP_USER_AGENT] => Mozilla/5.0 (Linux; Android 10; Redmi Note 7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.105 Mobile Safari/537.36 [HTTP_X_FORWARDED_FOR] => 15.29.18.4 [HTTP_CF_IPCOUNTRY] => SK [HTTP_CF_RAY] => 6389ed4cb9ff4126-PRG [HTTP_X_FORWARDED_PROTO] => https [HTTP_CF_VISITOR] => {"scheme":"https"} [HTTP_SEC_CH_UA] => "Google Chrome";v="89", "Chromium";v="89", ";Not A Brand";v="99" [HTTP_SEC_CH_UA_MOBILE] => ?1 [HTTP_UPGRADE_INSECURE_REQUESTS] => 1 [HTTP_SEC_FETCH_SITE] => same-origin [HTTP_SEC_FETCH_MODE] => navigate [HTTP_SEC_FETCH_USER] => ?1 [HTTP_SEC_FETCH_DEST] => document [HTTP_CF_CONNECTING_IP] => 15.22.18.48 [HTTP_CDN_LOOP] => cloudflare [HTTP_CF_REQUEST_ID] => 092a12a3f7000041269a0e8000000001 [DOCUMENT_ROOT] =>/public_html [REMOTE_ADDR] => 15.22.18.48 [REMOTE_PORT] => 21118 [SERVER_ADDR] => 15.24.18.15 [SERVER_NAME] => www.site.com [SERVER_ADMIN] => [SERVER_PORT] => 443 [REQUEST_SCHEME] => https [REQUEST_URI] => /profile/messages/message/1331?return=aHR0cHM6Ly93d3cucGFudGllbG92ZS5jb20vcHJvZmlsZS9tZXNzYWdlcw== [REDIRECT_URL] => /profile/messages/message/1331 [REDIRECT_QUERY_STRING] => return=aHR0cHM6Ly93d3cucGFudGllbG92ZS5jb20vcHJvZmlsZS9tZXNzYWdlcw== [PROXY_REMOTE_ADDR] => 14.10.96.38 [HTTPS] => on [HTTP_AUTHORIZATION] => [REDIRECT_STATUS] => 200 [SSL_PROTOCOL] => TLSv1.3 [SSL_CIPHER] => TLS_AES_128_GCM_SHA256 [SSL_CIPHER_USEKEYSIZE] => 128 [SSL_CIPHER_ALGKEYSIZE] => 128 [SCRIPT_FILENAME] =>/public_html/index.php [QUERY_STRING] => return=aHR0cHM6Ly93d3cucGFudGllbG92ZS5jb20vcHJvZmlsZS9tZXNzYWdlcw== [SCRIPT_URI] => https://www.site.com/profile/messages/message/1331 [SCRIPT_URL] => /profile/messages/message/1331 [SCRIPT_NAME] => /index.php [SERVER_PROTOCOL] => HTTP/1.1 [SERVER_SOFTWARE] => LiteSpeed [REQUEST_METHOD] => GET [X-LSCACHE] => on [PHP_SELF] => /index.php [REQUEST_TIME_FLOAT] => 1617197370.4336 [REQUEST_TIME] => 1617197370 )

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • OFFLINE
  • Posts: 48541
  • Thanks: 8290
  • Karma: 1445
3 years 7 months ago #324121 by krileon
Replied by krileon on topic PHP Exception
Very strange, that shouldn't be possible. The load behavior checks if a row exists already before creating one. Did you migrate from UddeIM to CBs built in PMS or is this a fresh install? If you migrated it could be an issue caused by migration.

Within the _comprofiler_plugin_messages_read database table find the row with a to_user of 1070 and message of 1331 then delete it and see if that'll resolve your issue. If there's more than 1 row delete all of them matching that criteria.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

3 years 7 months ago #324122 by silverman1
Replied by silverman1 on topic PHP Exception
No, this is a fresh install. I have never used Uddeim or CB before.

I don't know how big issue it is, does it affect the site in any way? Does it mean that the receiving user does not receive his message? The last time it happened it was a different user and a different message id. So maybe it doesn't help if I only delete this specific message.

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • OFFLINE
  • Posts: 48541
  • Thanks: 8290
  • Karma: 1445
3 years 7 months ago #324124 by krileon
Replied by krileon on topic PHP Exception
It doesn't impact any actual major operations. It's just the behavior called when logging the read status of a private message. I am not able to confirm the issue though so I'm unsure why it's happening for you specifically. There have been no other reports of such an issue as well. Please be sure you've the latest CB build installed then within CB > Tools run through the database fix tools and apply any fixes they propose as there could be a problem with that database table on your site.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

Moderators: beat, nant, krileon
Powered by Kunena Forum