hi
I am getting some database error after members adding some content like events, sites, and I got these mails with debug trace (not posted entirely here) :
Database error in domainname
Query:
SELECT * FROM `bx_sites_main` WHERE `url` = 'http://shortwww.com/moviesbx?source=domainname.com&se=2017_04_14&keyword=M%C3%BCnchen%20Mord%20-%20Einer%20der's%20geschafft%20hat' LIMIT 1
Mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's%20geschafft%20hat' LIMIT 1' at line 1
Found error in the file '/var/www/vhosts/domainname.com/httpdocs/modules/boonex/sites/classes/BxSitesDb.php' at line 62.
Called 'getRow' function with erroneous argument #0.
Database error in domainname
Query:
SELECT * FROM `bx_sites_main` WHERE `url` = 'http://shortwww.com/moviesbx?source=domainname.com&se=2017_04_14&keyword=Meet%20Me%20At%20The%20Lindell%3A%20The%20Story%20of%20America's%20First%20Sports%20Bar' LIMIT 1
Mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's%20First%20Sports%20Bar' LIMIT 1' at line 1
Found error in the file '/var/www/vhosts/domainname.com/httpdocs/modules/boonex/sites/classes/BxSitesDb.php' at line 62.
Called 'getRow' function with erroneous argument #0.
Database error in domainname
Query:
INSERT INTO `sys_tags` (ObjID, Type, Tag, Date) VALUES ('4', 'ad', 'spongebob squarepants: sea side story 3', CURRENT_TIMESTAMP)
Mysql error: Duplicate entry 'spongebob squarepants: sea side -4-ad' for key 'PRIMARY'
Found error in the file '/var/www/vhosts/domainname.com/httpdocs/inc/classes/BxDolTags.php' at line 233.
Called 'query' function with erroneous argument #0.
Database error in domainname
Query:
INSERT INTO `sys_tags` (ObjID, Type, Tag, Date) VALUES ('7', 'ad', 'the recycled spirits of roel cabatoga', CURRENT_TIMESTAMP)
Mysql error: Duplicate entry 'the recycled spirits of roel cab-7-ad' for key 'PRIMARY'
Found error in the file '/var/www/vhosts/domainname.com/httpdocs/inc/classes/BxDolTags.php' at line 233.
Called 'query' function with erroneous argument #0.
Database error in domainname
Query:
INSERT INTO `sys_tags` (ObjID, Type, Tag, Date) VALUES ('8', 'bx_events', 'jill billcock: the art of film editing services', CURRENT_TIMESTAMP)
Mysql error: Duplicate entry 'jill billcock: the art of film e-8-bx_events' for key 'PRIMARY'
Found error in the file '/var/www/vhosts/domainname.com/httpdocs/inc/classes/BxDolTags.php' at line 233.
Called 'query' function with erroneous argument #0.
Database error in domainname
Query:
SELECT * FROM `bx_sites_main` WHERE `url` = 'http://shortwww.com/moviesbx?source=domainname.com&se=2017_04_15&keyword=C'est%20beau%20la%20vie%20quand%20on%20y%20pense' LIMIT 1
Mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'est%20beau%20la%20vie%20quand%20on%20y%20pense' LIMIT 1' at line 1
Found error in the file '/var/www/vhosts/domainname.com/httpdocs/modules/boonex/sites/classes/BxSitesDb.php' at line 62.
Called 'getRow' function with erroneous argument #0.
Database error in domainname
Query:
INSERT INTO `sys_tags` (ObjID, Type, Tag, Date) VALUES ('12', 'blog', 'raffaello - il principe delle artist', CURRENT_TIMESTAMP)
Mysql error: Duplicate entry 'raffaello - il principe delle ar-12-blog' for key 'PRIMARY'
Found error in the file '/var/www/vhosts/domainname.com/httpdocs/inc/classes/BxDolTags.php' at line 233.
Called 'query' function with erroneous argument #0.
Database error in domainname
Query:
INSERT INTO `sys_tags` (ObjID, Type, Tag, Date) VALUES ('12', 'bx_events', 'strange beasts and where to find them dvd release date', CURRENT_TIMESTAMP)
Mysql error: Duplicate entry 'strange beasts and where to find-12-bx_events' for key 'PRIMARY'
Found error in the file '/var/www/vhosts/domainname.com/httpdocs/inc/classes/BxDolTags.php' at line 233.
Called 'query' function with erroneous argument #0.
