Strange Database error again

Not sure if this is telling me there is a duplicate event or someone trying an injection again.

Database error in NE FL World AIDS Day Committee 

Query:

INSERT INTO `sys_categories` (ID, Type, Category, Owner, Status, Date) VALUES ('128', 'bx_events', 'HIV testing', '1', 'active', CURRENT_TIMESTAMP), ('128', 'bx_events', 'HIV Testing', '1', 'active', CURRENT_TIMESTAMP)

Mysql error: Duplicate entry 'HIV Testing-128-bx_events' for key 'PRIMARY'

Found error in the file '/home/neflwad/public_html/inc/classes/BxDolCategories.php' at line 199.
Called 'query' function with erroneous argument #0.


Debug backtrace:

Array
(
    [1] => Array
        (
            [file] => /home/neflwad/public_html/inc/classes/BxDolDb.php
            [line] => 237
            [function] => error
            [class] => BxDolDb
            [object] => BxDolDb Object
                (
                    [error_checking] => 1
                    [error_message] => Duplicate entry 'HIV Testing-128-bx_events' for key 'PRIMARY'
                    [host] => localhost
                    [port] => 
                    [socket] => 
                    [dbname] => neflwad_website
                    [user] => *****
                    [password] => *****
                    [link] => Resource id #26
                    [current_res] => 
                    [current_arr_type] => 1
                    [oParams] => BxDolParams Object
                        (
                            [_oDb] => BxDolDb Object
                                (
                                    [error_checking] => 1
                                    [error_message] => 
                                    [host] => localhost
                                    [port] => 
                                    [socket] => 
                                    [dbname] => neflwad_website
                                    [user] => *****
                                    [password] => *****
                                    [link] => Resource id #26
                                    [current_res] => 
                                    [current_arr_type] => 1
                                    [oParams] => BxDolParams Object
 *RECURSION*
ManOfTeal.COM a Proud UNA site, six years running strong!
Quote · 7 Jul 2015

Not sure how that query was formed, but it contains two sets of values with identical IDs. ID has to be unique

My opinions expressed on this site, in no way represent those of Boonex or Boonex employees.
Quote · 7 Jul 2015

 

Not sure how that query was formed, but it contains two sets of values with identical IDs. ID has to be unique

 Thanks.

Can this be done by someone posting an event?

ManOfTeal.COM a Proud UNA site, six years running strong!
Quote · 7 Jul 2015

 

Can this be done by someone posting an event?

 According to the query, the owner id is '1'   That's probably you. You should be careful what buttons you click

My opinions expressed on this site, in no way represent those of Boonex or Boonex employees.
Quote · 7 Jul 2015

 

 

Can this be done by someone posting an event?

 According to the query, the owner id is '1'   That's probably you. You should be careful what buttons you click

 Yes it would be the site admin, private system, no members.

They stated during normal event entries the site did give the error, refreshing reveals the event posted.

Event being entered is not a duplicate and the poster stated it's happened before.

I guess it was a database glitch or something.

Thanks.

ManOfTeal.COM a Proud UNA site, six years running strong!
Quote · 7 Jul 2015

 

I guess it was a database glitch or something.

 Maybe someone else can explain it, but I can't.  I just don't know what sort of circumstances it would take to put two identical sets of values in a single sql query.  I doubt it's a bug in the script, else it would happen frequently.

My opinions expressed on this site, in no way represent those of Boonex or Boonex employees.
Quote · 7 Jul 2015

I wonder if, while creating a new category, the form was submitted twice, i.e. the form was submitted then the page was reloaded... thus resubmitting the same 'new' category.  Maybe run a test to see if that produces the same error.

http://pkforum.dolphinhelp.com
Quote · 7 Jul 2015
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.