I received the following email.
Database error in vBulletin 5.4.3:
Invalid SQL:
INSERT INTO searchtowords_i (`nodeid`,`wordid`,`is_title`,`score`,`position`) VALUES (323,12249,0,10000,72)
/**searchtowords_i**/;
MySQL Error : Duplicate entry '12249-323' for key 'wordid'
Error Number : 1062
Request Date : Sunday, September 16th 2018 @ 03:37:25 AM
Error Date : Sunday, September 16th 2018 @ 03:37:25 AM
Script : https://www.spiritualita.org/create-content/Text/
Referrer : https://www.spiritualita.org/forum/d...ano-modicano-i
IP Address : 94.167.242.234
Username : Angelo Cannata
Classname : vB_Database_MySQLi
MySQL Version : 5.6.40-84.0-log
Stack Trace:
#0 vB_Database->getErrorData() called in [path]/vb/database.php on line 1188
#1 vB_Database->halt() called in [path]/vb/database/mysqli.php on line 201
#2 vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 542
#3 vB_Database->query_write() called in [path]/vb/db/query/multipleinsert.php on line 114
#4 vB_dB_Query_MultipleInsert->doMultipleInserts() called in [path]/vb/db/query/multipleinsert.php on line 89
#5 vB_dB_Query_MultipleInsert->execSQL() called in [path]/vb/db/assertor.php on line 304
#6 vB_dB_Assertor->assertQuery() called in [path]/vb/db/assertor.php on line 519
#7 vB_dB_Assertor->insertMultiple() called in [path]/packages/vbdbsearch/core.php on line 161
#8 vBDBSearch_Core->indexText() called in [path]/vb/search/core.php on line 118
#9 vB_Search_Core->index() called in [path]/vb/library/search.php on line 42
#10 vB_Library_Search->index() called in [path]/vb/library/content.php on line 2118
#11 vB_Library_Content->update() called in [path]/vb/library/content/text.php on line 473
#12 vB_Library_Content_Text->update() called in [path]/vb/api/content.php on line 422
#13 vB_Api_Content->update() called in [path]/vb/api/content/text.php on line 295
#14 vB_Api_Content_Text->update() called in [path]/vb/api/wrapper.php on line 199
#15 vB_Api_Wrapper->__call() called in /home/spirit04/public_html/includes/api/interface/collapsed.php on line 101
#16 Api_Interface_Collapsed->callApi() called in /home/spirit04/public_html/includes/vb5/frontend/controller/createcontent.php on line 337
#17 vB5_Frontend_Controller_CreateContent->updateNode() called in /home/spirit04/public_html/includes/vb5/frontend/controller/createcontent.php on line 278
#18 vB5_Frontend_Controller_CreateContent->actionTextNodeInternal() called in /home/spirit04/public_html/includes/vb5/frontend/controller/createcontent.php on line 185
#19 vB5_Frontend_Controller_CreateContent->index() called in /home/spirit04/public_html/index.php on line 74
I already tried to delete that post and created a new post with the same title, but it still gives me that error email.
Database error in vBulletin 5.4.3:
Invalid SQL:
INSERT INTO searchtowords_i (`nodeid`,`wordid`,`is_title`,`score`,`position`) VALUES (323,12249,0,10000,72)
/**searchtowords_i**/;
MySQL Error : Duplicate entry '12249-323' for key 'wordid'
Error Number : 1062
Request Date : Sunday, September 16th 2018 @ 03:37:25 AM
Error Date : Sunday, September 16th 2018 @ 03:37:25 AM
Script : https://www.spiritualita.org/create-content/Text/
Referrer : https://www.spiritualita.org/forum/d...ano-modicano-i
IP Address : 94.167.242.234
Username : Angelo Cannata
Classname : vB_Database_MySQLi
MySQL Version : 5.6.40-84.0-log
Stack Trace:
#0 vB_Database->getErrorData() called in [path]/vb/database.php on line 1188
#1 vB_Database->halt() called in [path]/vb/database/mysqli.php on line 201
#2 vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 542
#3 vB_Database->query_write() called in [path]/vb/db/query/multipleinsert.php on line 114
#4 vB_dB_Query_MultipleInsert->doMultipleInserts() called in [path]/vb/db/query/multipleinsert.php on line 89
#5 vB_dB_Query_MultipleInsert->execSQL() called in [path]/vb/db/assertor.php on line 304
#6 vB_dB_Assertor->assertQuery() called in [path]/vb/db/assertor.php on line 519
#7 vB_dB_Assertor->insertMultiple() called in [path]/packages/vbdbsearch/core.php on line 161
#8 vBDBSearch_Core->indexText() called in [path]/vb/search/core.php on line 118
#9 vB_Search_Core->index() called in [path]/vb/library/search.php on line 42
#10 vB_Library_Search->index() called in [path]/vb/library/content.php on line 2118
#11 vB_Library_Content->update() called in [path]/vb/library/content/text.php on line 473
#12 vB_Library_Content_Text->update() called in [path]/vb/api/content.php on line 422
#13 vB_Api_Content->update() called in [path]/vb/api/content/text.php on line 295
#14 vB_Api_Content_Text->update() called in [path]/vb/api/wrapper.php on line 199
#15 vB_Api_Wrapper->__call() called in /home/spirit04/public_html/includes/api/interface/collapsed.php on line 101
#16 Api_Interface_Collapsed->callApi() called in /home/spirit04/public_html/includes/vb5/frontend/controller/createcontent.php on line 337
#17 vB5_Frontend_Controller_CreateContent->updateNode() called in /home/spirit04/public_html/includes/vb5/frontend/controller/createcontent.php on line 278
#18 vB5_Frontend_Controller_CreateContent->actionTextNodeInternal() called in /home/spirit04/public_html/includes/vb5/frontend/controller/createcontent.php on line 185
#19 vB5_Frontend_Controller_CreateContent->index() called in /home/spirit04/public_html/index.php on line 74
I already tried to delete that post and created a new post with the same title, but it still gives me that error email.
Comment