·
Added a discussion

hello,

since i use una 13 b3, have some troubles with deleting profiles with content and send messages.

if i try to delete profile with content, i can start the action and the una symbol is moving (see on screenshot), but then nothing happens, if i reload the page, i can see, that the profile was removed, but the content not, all is on my site, but without a username.

if i try to send a message, the same, the action starts and the una symbol is moving but then nothing happens, if i reload the page, i can see, that the message was sent.

saw also, that i get database errors ,when i try to delete a profile with content and then try to add this profile again and suspend it (because that are a scammer profile).

db error:

Query:

INSERT INTO `sys_accounts` SET `name` = 'Blocked',`email` = 'xxx@gmail.com',`email_confirmed` = '1',`receive_updates` = '0',`password` = 'fa366b52b6edc861a0e642343bd62e4580b3c2db',`salt` = '5j3r.iGM',`added` = '1662047109',`changed` = '1662047109',`ip` = '62.240.134.77',`referred` = 'https://domain.com/studio/module.php?name=bx_accounts&page=manage',`phone` = ''

Mysql error:

Duplicate entry 'xxx@gmail.com' for key 'email'

collation_connection:

utf8mb4_unicode_ci

Query:
INSERT INTO `sys_accounts` SET `name` = 'Blocked',`email` = '@gmail.com',`email_confirmed` = '1',`receive_updates` = '0',`password` = '',`salt` = 'RFNUswzd',`added` = '1662046956',`changed` = '1662046956',`ip` = '62.240.134.77',`referred` = 'https://domain.com/studio/module.php?name=bx_accounts&page=manage',`phone` = ''

Mysql error:
Duplicate entry 'xxx@gmail.com' for key 'email'

collation_connection:
utf8mb4_unicode_ci

Debug backtrace:
Array
(
    [0] => Array
        (
            [file] => /var/www/vhosts/domain.com/httpdocs/inc/classes/BxDolDb.php
            [line] => 1206
            [function] => execute
            [class] => PDOStatement
            [type] => ->
        )

    [1] => Array
        (
            [file] => /var/www/vhosts/domain.com/httpdocs/inc/classes/BxDolDb.php
            [line] => 1189
            [function] => executeStatementException
            [class] => BxDolDb
            [type] => ->
        )

    [2] => Array
        (
            [file] => /var/www/vhosts/domain.com/httpdocs/inc/classes/BxDolDb.php
            [line] => 541
            [function] => executeStatement
            [class] => BxDolDb
            [type] => ->
        )

    [3] => Array
        (
            [file] => /var/www/vhosts/domain.com/httpdocs/inc/classes/BxDolDb.php
            [line] => 515
            [function] => res
            [class] => BxDolDb
            [type] => ->
        )

    [4] => Array
        (
            [file] => /var/www/vhosts/domain.com/httpdocs/inc/classes/BxDolForm.php
            [line] => 889
            [function] => query
            [class] => BxDolDb
            [type] => ->
        )

    [5] => Array
        (
            [file] => /var/www/vhosts/domain.com/httpdocs/template/scripts/BxBaseFormAccount.php
            [line] => 169
            [function] => insert
            [class] => BxDolForm
            [type] => ->
        )

    [6] => Array
        (
            [file] => /var/www/vhosts/domain.com/httpdocs/modules/boonex/accounts/classes/BxAccntGridAdministration.php
            [line] => 214
            [function] => insert
            [class] => BxBaseFormAccount
            [type] => ->
        )

    [7] => Array
        (
            [file] => /var/www/vhosts/domain.com/httpdocs/grid.php
            [line] => 35
            [function] => performActionAdd
            [class] => BxAccntGridAdministration
            [type] => ->
        )

)

Settings:

Query:

SELECT `cmt_id`, `cmt_parent_id` FROM bx_snipcart_cmts_notes WHERE `cmt_author_id` = ? AND `cmt_replies` = 0

Mysql error:

Table 'una_domain.bx_snipcart_cmts_notes' doesn't exist

collation_connection:

utf8mb4_unicode_ci

Debug backtrace:

Query:
SELECT `cmt_id`, `cmt_parent_id` FROM bx_snipcart_cmts_notes WHERE `cmt_author_id` = ? AND `cmt_replies` = 0

Mysql error:
Table 'una_domain.bx_snipcart_cmts_notes' doesn't exist

collation_connection:
utf8mb4_unicode_ci

Debug backtrace:
Array
(
    [0] => Array
        (
            [file] => /var/www/vhosts/domain.com/httpdocs/inc/classes/BxDolDb.php
            [line] => 1206
            [function] => execute
            [class] => PDOStatement
            [type] => ->
        )

    [1] => Array
        (
            [file] => /var/www/vhosts/domain.com/httpdocs/inc/classes/BxDolDb.php
            [line] => 1189
            [function] => executeStatementException
            [class] => BxDolDb
            [type] => ->
        )

    [2] => Array
        (
            [file] => /var/www/vhosts/domain.com/httpdocs/inc/classes/BxDolDb.php
            [line] => 541
            [function] => executeStatement
            [class] => BxDolDb
            [type] => ->
        )

    [3] => Array
        (
            [file] => /var/www/vhosts/domain.com/httpdocs/inc/classes/BxDolDb.php
            [line] => 413
            [function] => res
            [class] => BxDolDb
            [type] => ->
        )

    [4] => Array
        (
            [file] => /var/www/vhosts/domain.com/httpdocs/inc/classes/BxDolCmtsQuery.php
            [line] => 737
            [function] => getAll
            [class] => BxDolDb
            [type] => ->
        )

    [5] => Array
        (
            [file] => /var/www/vhosts/domain.com/httpdocs/inc/classes/BxDolCmts.php
            [line] => 832
            [function] => deleteAuthorComments
            [class] => BxDolCmtsQuery
            [type] => ->
        )

    [6] => Array
        (
            [file] => /var/www/vhosts/domain.com/httpdocs/inc/classes/BxDolProfile.php
            [line] => 436
            [function] => onAuthorDelete
            [class] => BxDolCmts
            [type] => ::
        )

    [7] => Array
        (
            [file] => /var/www/vhosts/domain.com/httpdocs/inc/classes/BxDolAccount.php
            [line] => 647
            [function] => delete
            [class] => BxDolProfile
            [type] => ->
        )

    [8] => Array
        (
            [file] => /var/www/vhosts/domain.com/httpdocs/modules/boonex/accounts/classes/BxAccntGridAdministration.php
            [line] => 642
            [function] => delete
            [class] => BxDolAccount
            [type] => ->
        )

    [9] => Array
        (
            [file] => /var/www/vhosts/domain.com/httpdocs/modules/base/general/classes/BxBaseModGeneralGridAdministration.php
            [line] => 60
            [function] => _doDelete
            [class] => BxAccntGridAdministration
            [type] => ->
        )

    [10] => Array
        (
            [file] => /var/www/vhosts/domain.com/httpdocs/modules/base/profile/classes/BxBaseModProfileGridAdministration.php
            [line] => 129
            [function] => performActionDelete
            [class] => BxBaseModGeneralGridAdministration
            [type] => ->
        )

    [11] => Array
        (
            [file] => /var/www/vhosts/domain.com/httpdocs/grid.php
            [line] => 35
            [function] => performActionDeleteWithContent
            [class] => BxBaseModProfileGridAdministration
            [type] => ->
        )

)

Settings:
  • 557
Comments
    • Hello @Someone07 !

      This error (delete the profile with query and try to add it again with error) means that removal hasn't been completed. So you need to check the server's error log to detect the thing(s) which breaks (break) the proper finish of this delete procedure.

      Login or Join to comment.