Thiết kế website giá rẻ

Question

Question:
I am working on a PHP project that inserts data into a MySQL database using the mysqli extension. However, I am encountering the following error during execution:

Fatal error: Uncaught mysqli_sql_exception: Duplicate entry '0-472-michalina-ludmi-a-musielakv-erh-lt-den-meistersch-ler-i...' for key 'idx_client_id_parent_id_alias_language' in /var/www/html/Database/Write_DB_PressArticles.php:198

This is the code segment in question (starting at line 196):

                // Variables for workflow_associations table
            $pressItem_ID = $currentPressID; // Overwrite during insert
            $pressStage_ID = 1;
            $pressExtension = 'com_content.article';

            // Variables for menu table
            $pressMenuType = 'main-menu-de';
            //$pressTitle = ...;
            //$pressAlias = ...;
            $pressPath = 'newsportal/' . $pressAlias . '/';
            $pressLink = '';
            $pressType = 'component';
            //$pressPublished = ...;
            $pressMenuParentID = 472;
            $pressMenuLevel = 2;
            $pressComponentID = 22;
            $pressCheckedOut = 88;
            $pressCheckedOutTime = $now;
            $pressBrowseNav = 0;
            $pressMenuAccess = 1;
            $pressMenuImg = '';
            $pressTemplateStyleID = 0;
            $pressMenuParams = '{"layout_type":"blog","show_category_title":"","show_description":"","show_description_image":"","maxLevel":"","show_empty_categories":"","show_no_articles":"","show_category_heading_title_text":"","show_subcat_desc":"","show_cat_num_articles":"","show_cat_tags":"","num_leading_articles":"","blog_class_leading":"","num_intro_articles":"","blog_class":"","num_columns":"","multi_column_order":"","num_links":"","show_featured":"","link_intro_image":"","show_subcategory_content":"","orderby_pri":"","orderby_sec":"","order_date":"","show_pagination":"","show_pagination_results":"","article_layout":"_:default","show_title":"","link_titles":"","show_intro":"","info_block_position":"","info_block_show_title":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_associations":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_readmore":"","show_readmore_title":"","show_hits":"","show_tags":"","show_noauth":"","show_feed_link":"","feed_summary":"","menu-anchor_title":"","menu-anchor_css":"","menu_icon_css":"","menu_image":"","menu_image_css":"","menu_text":1,"menu_show":1,"page_title":"","show_page_heading":"","page_heading":"","pageclass_sfx":"","menu-meta_description":"","robots":"","astroid_menu_options":{"megamenu":"0","showtitle":"0","subtitle":"","icon":"","customclass":"","width":"250px","megamenu_width":"980px","alignment":"right","megamenu_direction":"right","rows":"[]","badge":"0","badge_text":"","badge_color":"#FFF","badge_bgcolor":"#000"},"astroid_banner_enabled":"0","astroid_banner_title_enabled":"1","astroid_banner_title":"","astroid_banner_subtitle":"","astroid_banner_buttons":[],"astroid_banner_textcolor":"","astroid_banner_subtextcolor":"","astroid_banner_bgcolor":"","astroid_banner_bgimage":"","astroid_banner_bgimage_position":"","astroid_banner_bgimage_position_x":"","astroid_banner_bgimage_position_y":"","astroid_banner_bgimage_repeat":"","astroid_banner_bgimage_size":"","astroid_banner_bgimage_width":"","astroid_banner_bgimage_attachment":"","astroid_banner_overlay_color":"","astroid_banner_title_tag":"h3","astroid_banner_subtitle_tag":"span","astroid_banner_class":"","astroid_banner_height":"","astroid_banner_wrapper":"container","astroid_banner_visibility":"allPage","astroid_opengraph_menuitem":"0","astroid_og_title_menuitem":"","astroid_og_desc_menuitem":"","astroid_og_image_menuitem":"","astroid_og_visibility":"currentPage","astroid_trackingcode":"","astroid_beforehead":"","astroid_beforebody":"","astroid_customcss":"","astroid_customcssfiles":"","astroid_customjs":"","astroid_customjsfiles":"","astroid_posttype":"","astroid_readtime":"","astroid_badge":""}';
            $pressLft = $currentLft;
            $pressRgt = $currentRgt;
            $pressHome = 0;
            //$pressLanguage = ...;
            $pressClientID = 0;

            // Variables for slider
            $pressSlider = '11';
            $pressPublished = '1';
            $pressFirst = '0';
            // Max length for text in slide
            $maxlength = 350;
            $pressSlide = '[{"type":"content","pm":"default","desktopportraitfontsize":100,"desktopportraitverticalalign":"center","desktopportraitmaxwidth":0,"desktopportraitinneralign":"left","desktopportraitpadding":"10|*|10|*|10|*|10|*|px","desktopportraitselfalign":"left","mobileportraitpadding":"10|*|10|*|10|*|10|*|px","opened":1,"id":"","uniqueclass":"n-uc-HXhRpGY7BrbB","generatorvisible":"","zindex":2,"class":"","crop":"visible","rotation":0,"parallax":0,"desktopportrait":1,"desktoplandscape":1,"tabletportrait":1,"tabletlandscape":1,"mobileportrait":1,"mobilelandscape":1,"bgimage":"","bgimagex":50,"bgimagey":50,"bgcolor":"ffffff00","bgcolorgradient":"off","bgcolorgradientend":"00000000","layers":[{"type":"row","pm":"normal","desktopportraitfontsize":100,"desktopportraitinneralign":"inherit","desktopportraitpadding":"35|*|30|*|35|*|30|*|px","desktopportraitgutter":20,"desktopportraitwrapafter":"0","desktopportraitmargin":"0|*|0|*|0|*|0|*|px","desktopportraitheight":0,"desktopportraitmaxwidth":450,"desktopportraitselfalign":"inherit","mobileportraitpadding":"15|*|10|*|15|*|10|*|px","mobileportraitwrapafter":1,"mobilelandscapewrapafter":1,"opened":1,"id":"","uniqueclass":"n-uc-f8IPabEEkXFo","generatorvisible":"","zindex":2,"class":"","crop":"visible","rotation":0,"parallax":0,"desktopportrait":1,"desktoplandscape":1,"tabletportrait":1,"tabletlandscape":1,"mobileportrait":1,"mobilelandscape":1,"href":"#","href-target":"_self","aria-label":"","bgimage":"","bgimagex":50,"bgimagey":50,"bgcolor":"ffffffff","bgcolorgradient":"off","bgcolorgradientend":"00000000","borderwidth":"1|*|1|*|1|*|1","borderstyle":"none","bordercolor":"FFFFFFFF","borderradius":0,"boxshadow":"0|*|1|*|10|*|0|*|00000038","fullwidth":"1","stretch":"1","name":"Row","namesynced":1,"cols":[{"type":"col","pm":"default","desktopportraitfontsize":100,"desktopportraitverticalalign":"flex-start","desktopportraitmaxwidth":0,"desktopportraitinneralign":"inherit","desktopportraitpadding":"10|*|10|*|10|*|10|*|px","desktopportraitorder":0,"opened":1,"id":"","uniqueclass":"n-uc-yXsmrzks62ak","generatorvisible":"","zindex":2,"class":"","crop":"visible","rotation":0,"parallax":0,"desktopportrait":1,"desktoplandscape":1,"tabletportrait":1,"tabletlandscape":1,"mobileportrait":1,"mobilelandscape":1,"bgimage":"","bgimagex":50,"bgimagey":50,"bgcolor":"00000000","bgcolorgradient":"off","bgcolorgradientend":"00000000","colwidth":1,"href":"#","href-target":"_self","aria-label":"","borderradius":0,"boxshadow":"0|*|0|*|0|*|0|*|00000080","borderwidth":"1|*|1|*|1|*|1","borderstyle":"none","bordercolor":"ffffffff","name":"Col","namesynced":1,"layers":[{"type":"layer","pm":"normal","desktopportraitfontsize":100,"desktopportraitmargin":"0|*|0|*|0|*|0|*|px","desktopportraitheight":0,"desktopportraitmaxwidth":0,"desktopportraitselfalign":"inherit","id":"","uniqueclass":"n-uc-s07ZIkoY4TB4","generatorvisible":"","zindex":2,"class":"","crop":"visible","rotation":0,"parallax":0,"desktopportrait":1,"desktoplandscape":1,"tabletportrait":1,"tabletlandscape":1,"mobileportrait":1,"mobilelandscape":1,"name":"","namesynced":1,"item":{"type":"text","values":{"content":"' . $pressCreated_Slide . '","font":"{"data":[{"extra":"","color":"8c8c8cff","size":"16||px","tshadow":"0|*|0|*|0|*|000000ff","afont":"Arial","lineheight":"1.5","weight":400,"italic":0,"underline":0,"align":"inherit","letterspacing":"normal","wordspacing":"normal","texttransform":"none"},{"extra":"","color":"16b7ccff"},{"extra":""}]}","style":"","content-tablet-enabled":"0","contenttablet":"","content-mobile-enabled":"0","contentmobile":""}}},{"type":"layer","pm":"normal","desktopportraitfontsize":100,"desktopportraitmargin":"0|*|0|*|20|*|0|*|px","desktopportraitheight":0,"desktopportraitmaxwidth":0,"desktopportraitselfalign":"inherit","tabletportraitfontsize":80,"mobileportraitfontsize":60,"id":"","uniqueclass":"n-uc-7QSpX96PgTQ6","generatorvisible":"","zindex":2,"class":"","crop":"visible","rotation":0,"parallax":0,"desktopportrait":1,"desktoplandscape":1,"tabletportrait":1,"tabletlandscape":1,"mobileportrait":1,"mobilelandscape":1,"name":"Day Twenty Eight: The First Mountai","namesynced":1,"item":{"type":"heading","values":{"font":"{"data":[{"extra":"","color":"1a1a1aff","size":"30||px","tshadow":"0|*|0|*|0|*|000000ff","afont":"Arial","lineheight":"1.3","weight":400,"italic":0,"underline":0,"align":"inherit","letterspacing":"normal","wordspacing":"normal","texttransform":"none"},{"extra":""}]}","style":"","priority":"div","fullwidth":"1","nowrap":"0","heading":"' . $pressTitle . '","title":"","href":"#","href-target":"_self","href-rel":"","split-text-transform-origin":"50|*|50|*|0","split-text-backface-visibility":1,"split-text-animation-in":"","split-text-delay-in":0,"split-text-animation-out":"","split-text-delay-out":0,"class":""}}},{"type":"layer","pm":"normal","desktopportraitfontsize":100,"desktopportraitmargin":"0|*|0|*|0|*|0|*|px","desktopportraitheight":0,"desktopportraitmaxwidth":0,"desktopportraitselfalign":"inherit","id":"","uniqueclass":"n-uc-PRiYDIyNDMZs","generatorvisible":"","zindex":2,"class":"","crop":"visible","rotation":0,"parallax":0,"desktopportrait":1,"desktoplandscape":1,"tabletportrait":1,"tabletlandscape":1,"mobileportrait":1,"mobilelandscape":1,"name":"zigzag-1.png","namesynced":1,"item":{"type":"image","values":{"style":"","image":"$/images/slider6/zigzag-1.png","alt":"Image is not available","title":"","href":"#","href-target":"_self","href-rel":"","href-class":"","size":"auto|*|auto","cssclass":"","image-optimize":"1"}}},{"type":"layer","pm":"normal","desktopportraitfontsize":100,"desktopportraitmargin":"20|*|0|*|25|*|0|*|px","desktopportraitheight":0,"desktopportraitmaxwidth":0,"desktopportraitselfalign":"inherit","mobileportraitfontsize":80,"id":"","uniqueclass":"n-uc-nN9SY2E2fpqq","generatorvisible":"","zindex":2,"class":"","crop":"visible","rotation":0,"parallax":0,"desktopportrait":1,"desktoplandscape":1,"tabletportrait":1,"tabletlandscape":1,"mobileportrait":1,"mobilelandscape":1,"name":"Lorem ipsum dolor sit amet, consect","namesynced":1,"item":{"type":"text","values":{"font":"{"data":[{"extra":"","color":"8c8c8cff","size":"16||px","tshadow":"0|*|0|*|0|*|000000ff","afont":"Arial","lineheight":"1.8","weight":400,"italic":0,"underline":0,"align":"inherit","letterspacing":"normal","wordspacing":"normal","texttransform":"none"},{"extra":"","color":"16b7ccff"},{"extra":""}]}","style":"","content":"' . substr($pressIntrotext, 0, $maxlength) . " ..." . '","content-tablet-enabled":"0","contenttablet":"","content-mobile-enabled":"0","contentmobile":""}}},{"type":"layer","pm":"normal","desktopportraitfontsize":100,"desktopportraitmargin":"0|*|0|*|0|*|0|*|px","desktopportraitheight":0,"desktopportraitmaxwidth":0,"desktopportraitselfalign":"inherit","mobileportraitfontsize":80,"id":"","uniqueclass":"n-uc-RTjJ4dnBd5D4","generatorvisible":"","zindex":2,"class":"","crop":"visible","rotation":0,"parallax":0,"desktopportrait":1,"desktoplandscape":1,"tabletportrait":1,"tabletlandscape":1,"mobileportrait":1,"mobilelandscape":1,"name":"READ MORE","namesynced":1,"item":{"type":"button","values":{"font":"{"data":[{"extra":"","color":"ffffffff","size":"14||px","tshadow":"1|*|1|*|0|*|0000002b","afont":"Arial","lineheight":"1.5","weight":0,"italic":0,"underline":0,"align":"center","letterspacing":"1px","wordspacing":"normal","texttransform":"none"},{"extra":""}]}","style":"{"data":[{"extra":"","backgroundcolor":"054490ff","opacity":100,"padding":"10|*|18|*|10|*|18|*|px","boxshadow":"0|*|0|*|0|*|0|*|000000ff","border":"0|*|solid|*|000000ff","borderradius":"3"},{"extra":"","backgroundcolor":"139fb1ff"}]}","content":"READ MORE","nowrap":"1","fullwidth":"0","href":"http://localhost:8080/index.php/de-de/newsportal/' . $pressAlias . '","href-target":"_self","href-rel":"","class":"","icon":"","iconsize":"100","iconspacing":"30","iconplacement":"left"}}}]}]}]}]';
            $pressDescription = $pressIntrotext;
            $pressThumbnail = '';
            $pressParams = '{"type":"slide","desktopportraitfontsize":"100","desktopportraitpadding":"20|*|70|*|60|*|70","tabletportraitpadding":"20|*|70|*|60|*|70","mobileportraitpadding":"20|*|10|*|60|*|10","record-slides":"1","thumbnailAlt":"","thumbnailType":"default","static-slide":"0","slide-duration":"0","ligthboxImage":"","background-animation":"","background-animation-color":"333333ff","background-animation-speed":"default","desktopportrait":"1","desktoplandscape":"1","tabletportrait":"1","tabletlandscape":"1","mobileportrait":"1","mobilelandscape":"1","href":"","href-target":"_self","aria-label":"","background-type":"image","backgroundColor":"ffffff00","backgroundGradient":"off","backgroundColorEnd":"ffffff00","backgroundColorOverlay":"0","backgroundImage":"https://images.pexels.com/photos/417074/pexels-photo-417074.jpeg?auto=compress&cs=tinysrgb&w=800","backgroundFocusX":"50","backgroundFocusY":"50","backgroundImageOpacity":"100","backgroundImageBlur":"0","backgroundAlt":"","backgroundTitle":"","backgroundMode":"default","backgroundBlurFit":"7","guides":"eyJob3Jpem9udGFsIjpbXSwidmVydGljYWwiOltdfQ==","version":"3.5.1.14"}';
            $pressGenerator_id = 1;

            //english version
            $pressTitleTranslation = $article["titleTranslation"] ?? "";
            $pressContentTranslation = $article["contentTranslation"] ?? "";              
            
            // Create a PressArticle object for each article
            $pressArticle = new PressArticle($pressAssetID, $pressTitle, $pressAlias, $pressIntrotext, $pressFulltext, $pressState, $pressCatid, $pressCreated, $pressCreated_by, $pressModified, $pressModified_by, $pressImages, $pressUrls, $pressAttribs, $pressVersion, $pressOrdering, $pressMetakey, $pressMetadesc, $pressHits, $pressPublish_up, $pressAccess, $pressMetadata, $pressFeatured, $pressLanguage, $pressNote, $pressIsTopNews, $pressItem_ID, $pressStage_ID, $pressExtension, $pressMenuType, $pressPath, $pressLink, $pressType, $pressMenuParentID, $pressMenuLevel, $pressComponentID, $pressCheckedOut, $pressCheckedOutTime, $pressBrowseNav, $pressMenuAccess, $pressMenuImg, $pressTemplateStyleID, $pressMenuParams, $pressLft, $pressRgt, $pressHome, $pressClientID, $pressSlider, $pressPublished, $pressFirst, $pressSlide, $pressDescription, $pressThumbnail, $pressParams, $pressGenerator_id, $fullArticleUrl, $pressTitleTranslation, $pressContentTranslation);
            $pressArticles[] = $pressArticle;
            if($pressIsTopNews){       
                echo "adding english versionn"; // Debugging line    
                $pressArticleEnglish = new PressArticle($pressAssetID, $pressTitleTranslation, $pressAlias . " -en", $pressContentTranslation, "", $pressState, 32, $pressCreated, $pressCreated_by, $pressModified, $pressModified_by, $pressImages, $pressUrls, $pressAttribs, $pressVersion, $pressOrdering, $pressMetakey, $pressMetadesc, $pressHits, $pressPublish_up, $pressAccess, $pressMetadata, $pressFeatured, "en-GB", $pressNote, $pressIsTopNews, $pressItem_ID, $pressStage_ID, $pressExtension, $pressMenuType, $pressPath, $pressLink, $pressType, $pressMenuParentID, $pressMenuLevel, $pressComponentID, $pressCheckedOut, $pressCheckedOutTime, $pressBrowseNav, $pressMenuAccess, $pressMenuImg, $pressTemplateStyleID, $pressMenuParams, $pressLft, $pressRgt, $pressHome, $pressClientID, '12', $pressPublished, $pressFirst, $pressSlide, $pressDescription, $pressThumbnail, $pressParams, $pressGenerator_id, $fullArticleUrl, $pressTitleTranslation, $pressContentTranslation);
                $pressArticles[] = $pressArticleEnglish;
            }

            // Increment $currentPressID for the next article
            $currentPressID++;
            $currentLft++;
            $currentRgt++;
        }
    }

    return $pressArticles;

The data being inserted into the database comes from a web scraper and is not manually entered. Each scraped article creates a PressArticle object, which is then processed and stored in the database. Here’s a simplified workflow:
Data is scraped from external sources.
A PressArticle object is created for each article.
The object is inserted into the database.

What I’ve Tried:

Manually checking the database for existing entries with the same key combination.
Adding a suffix to the alias field to ensure uniqueness, but it doesn’t completely resolve the issue.

I am not actually sure what causes the error, but I also suspect the “lft” and “rgt” indices, which joomla uses. But I am really not sure about the purpose of these both indices

Any help would be greatly appreciated!

Thiết kế website giá rẻ

Danh mục

PHP MySQL Error: Duplicate entry for key ‘idx_client_id_parent_id_alias_language’ – Troubleshooting