Replicate postgres sql server仕事
Please to recover the 500 Internal Server Error that occurred in the construction sites in Magento. 500 Internal Server Error is now displayed in normal operation to have a site that has been built with magento. I do not remember such as changes to the file. Only the 500 Internal Server Error front end of the site is displayed. Back office is normal operation and normally displayed. Also with reference to the existing DB by installing a new magento files become 500 Internal Server Error. I will be get 500 Internal Server Error in DB creation time when I try to fresh installation with the new DB and file. I tried it. Change permissions using the magento-cleanup.php. Installation condition confirmation using the magento-check.php. Delete of .h...
This is rosemarylaw office, lawyer in Japan. We are searching freelancer of PHP, SSIS, SSRS programer. We are continue to develop CS system, MS SQL +SSIS ,SSRS of server side and PHP front with IIS. All MS solution based. We have Server side engineer in house. and test server with dummy data, you can try from remote. development can do english based with skype, github,mail and so on. We hope to good offshore appications. Thanks now we are searching below project enginner. 1 upgrade SQL server SSIS import program 2005 to 2012 SSIS side is improt form exel to dbo and job lancher is C# based exe. Req Skill C# 2000, SSIS, SQL prototype, ex- version will remained Documets also you need to upgarede customizing and version...
...CS system, MS SQL +SSIS ,SSRS of server side and PHP front with IIS. All MS solution based. We have Server side engineer in house. we have test server with dummy data, you can try from remote. development can do english based with skype, github,mail and so on. We hope to good offshore appications. Thanks now we are searching below project enginner. 1 upgrade SQL server SSIS import program2005 to 2012 SSIS side is improt form CSV to DB, job lancher is C# based. Req Skill C# 2000, SSIS, SQL 2 upgarde SSRS program 2005 to 2012 small customizing upgarde checking. over 100 report should upgarde 3 php with sql add new searching view etc stored exec, view,dbo, will be made by server side so you only made f...
...サービス要件 1. 特定のゲームタイトルに関連する記事を取得すること 2. プログラムの特定の一か所に記述されたゲームタイトルパラメーターを変更するだけで対応したデータが取得できること 3. 海外ゲームタイトルであっても取得可能であること 4. 1日に1回バッチを回した際、以前に取得したことがない記事をリストとして取得できること 5. 記事のタイトル・サムネイル・記事本文の一部を取得すること ■ システム要件 1. PHP + MySQLで構築すること 2. PHP5.3で推奨されていない表現を用いないこと 3. Cronによって動作すること 4. プログラムを動かすサーバー OR dbサーバーに対して必要以上の負荷をかけないこと ■ 納品物については以下の通りとなります 1. プログラム本体の納品(PHP) 2. データの格納先DB-Tableの納品(SQLクエリ) ■ 応募条件 1. 応募時にどのような方法で実現する予定なのかを簡潔に明記してください (Ex. TwitterSerch API と Bing Serch APIを用いて実現します、など) ▽参考Webサイト サイト名:スマートニュース/newspicksなどのバックエンド ▽使用するプログラミング言語/ツール/特殊技術(テクノロジー) ・PHP(5.3) ・MySQL ▽注意点・禁止事項 ※ 他で登録されているデザインや商標の転用など、他社の知的財産権を侵すこと ※ 商用利用できないライセンスのプログラムを用いること ※ ▽その他コメント ※実際のWebサイト開発/アプリケーション開発の進め方・別途詳細は、 クラウドワークスのメッセージでやりとりして決められればと思...
Fix a magento error SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction MagentoのSQLをバックアップ後に管理画面にログインしようとすると以下のエラーが表示されてログインできない。 SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction 希望: 問題の解決と原因の究明と説明、今後への対処の説明と実行をお願いします。 緊急です。 重要視する項目:金額、スピード、作業内容及び方法の説明 予想される作業内容:(あくまでも予想です) 未実行クエリの再実行または未実行クエリの削除 innodb_lock_wait_timeoutの値変更 50秒->180秒
Amazonの在庫、価格更新システムのインストールを2カ国分、注文管理システムの機能追加を希望します。
...Painting Artist to Recreate & Modify a Traditional Artwork Description: We are looking for a skilled digital painting artist to create a high-quality digital version of an existing painting while modifying its background. The original artwork depicts a Hindu deity, so familiarity with South Indian gods’ color schemes and traditional aesthetics is preferred. Requirements: • Ability to closely replicate the style and details of the original painting. • Experience in digital painting and illustration with a strong portfolio showcasing similar work. • Creativity in modifying the background while maintaining the integrity of the artwork. • Knowledge or understanding of South Indian religious art styles and color palettes is a plus. Project Details...
I'm seeking a talented video editor to help me edit a series of educational videos, similar in style to Dhruv Rathee. Ideal Skills: - Proficient in video editing software - Experience editing educational content - Able to replicate Dhruv Rathee's style Please note that while the specific tone and visual elements have not been determined yet, a casual and engaging style with a mix of professional and friendly tones is likely.
I want a news paper app for my newspaper EidsvollPuls. The newspaper is made in ASP. NET and the database is SQL server.
I'm looking for an expert in Power BI and SQL Server who can assist with data integration and transformation. Key Responsibilities: - Integrate various data sources into SQL Server - Transform and prepare data for analysis Ideal Skills: - Proficiency in Power BI and SQL Server - Experience in data integration and transformation - Strong analytical skills Please note that specific data sources and transformation tasks may be discussed further. Your ability to handle and manipulate complex datasets will be crucial for success in this project.
I'm seeking a seasoned Flutter Flow developer to create a custom widget for image cropping within the platform. The goal is to replicate a user-friendly cropping interface similar to those found in Facebook, Instagram, or WhatsApp. Key Requirements: 1. Develop a custom code that allows for image cropping and re-uploading to the server, mimicking standard functionalities found in popular social media apps. 2. Ensure the cropping tool is user-friendly and maintains the quality of the uploaded image while minimizing upload size. The cropping should not be circular. 3. The functionality should be compatible across Web, Android, and iOS platforms, and work seamlessly with the latest version of Flutter Flow. 4. Provide a preview of the cropped image before finalizing the crop...
...need of a seasoned DevOps professional to assist with setting up a DigitalOcean server for my web application. Key Responsibilities: 1. Server Setup: Configure a new DigitalOcean server, deploy the application code and database backups, while Dockerizing the application. 2. Integration: Fix the web server to eliminate 502 errors, ensuring seamless interaction with Cloudflare (already configured). 3. Security: Eliminate unauthorized access, fortify the server’s security, and set up necessary backups and monitoring systems. The ideal candidate for this job should have: • Extensive experience with DigitalOcean and Docker. • Proficiency in server management and security. • Ability to troubleshoot and resolve server error...
I need a professional freelancer to create a Chainsaw Man mask for cosplay purposes. The mask should be an original design and made of durable plastic material. Key Requirements: - Expertise in mask design and production, particularly for cosplay - Ability to replicate original designs accurately - Proficiency in working with plastic to ensure durability and comfort - Experience with anime-style cosplay design - Knowledge in painting and finishing cosplay props to achieve a professional look Your creativity and attention to detail will help create an impressive piece that stands out at any cosplay event. The mask should incorporate traditional colors from the Chainsaw Man series for authenticity. The mask should feature movable parts like the jaw to enhance realism. Please ensur...
I'm seeking a professional to configure an email server on RHEL 9. This server will be integral for my Robot Framework automation scripts, facilitating both the sending and receiving of emails, as well as validating the content of these emails, including various types of attachments. Key Responsibilities: 1. Robot Framework Integration - Seamlessly integrate the email server with Robot Framework on a Windows VM. - Ensure the server supports automation scripts for sending and receiving emails for validation purposes. 2. Email Content Validation - Enable the parsing and validation of email bodies and attachments within Robot Framework. - Attachments will include XML files, GZ files containing JSON, and ZIP files containing text files. - Ensur...
...must detect the controller, request permission, open the serial port, and handle re-plugging. You may use the Android USB Host API directly or a library like felHR85/UsbSerial. 2. App Layout / Tabs A. Configure Tab Show all configurable settings (auto mode, debug, beep, motor counts, limit switch type, etc.). A prominent “Start Setup Wizard” button launches a guided workflow. The workflow must replicate the existing wizard logic from the firmware (which prints multi-step prompts). Instead of raw text prompts, the app should have a friendly GUI (next, back, instructions) that sends the correct serial commands (set limit up, C, etc.) in each step and reads the device’s responses. B. Control Tab Real-time status (motor positions, voltage, etc. if available). Butt...
I need help fixing various SQL triggers and stored procedures that have stopped executing. The issue arose unexpectedly, and I need an experienced professional to diagnose and rectify the problem efficiently.
The objective of this project is to produce an instructional video utilizing Kali Linux to transmit an observer file to a WhatsApp number. This endeavor is intended solely for educational purposes. The following requirements must be met: 1. Kali Linux must be accessed via Oracle Virtual Machine. 2. Th...the file by you acting as the WhatsApp user. 2.5 The observation of the Android device's photos or videos by you as a programmer or designer or tester. Note: Any method in showing this video, including the use of dual monitors or a combination of a monitor and an Android device, is acceptable as long as the visual narration is clear and easily comprehensible. 3. The viewer must be able to replicate all procedures demonstrated in the video. Thank you, and best of luck ...
...talented graphic designer who specializes in designing [mention specific material, e.g., packaging, posters, social media content] similar to the style in this video: [ ] Requirements: Experience in [] design. Proficiency in Adobe Photoshop, Illustrator, or other relevant design tools. Ability to replicate or enhance the style shown in the video. Strong attention to detail and creativity. Project Scope: Create [mention the number of designs needed]. Ensure high-quality, print-ready, and digital-friendly designs. Deliver files in the required formats (PSD, AI, PNG, etc.). Potential for long-term collaboration if work meets expectations. If you have experience with this type of design, please send:
I'm looking for an experienced SQL database specialist to help me design a robust database for my e-commerce platform. Key Responsibilities: - Design a comprehensive SQL database tailored for e-commerce. - Ensure the database can handle high traffic and large volumes of data. Ideal Skills and Experience: - Proven experience in SQL database design, particularly for e-commerce. - Strong understanding of e-commerce data requirements. - Ability to create scalable and efficient database systems.
I need a professional who can customize my WordPress header to replicate exactly the style, design, and functionalities of the menu and mega menu found on Key requirements: - Implement an identical style on a personalized header. - Utilize the theme I already have, which is the same as the reference site. - Ensure all customizations can be executed via the theme's personalization options. I do not need any additional functionalities in the header, nor do I need assistance with theme installation and configuration. The ideal candidate for this project should have extensive experience with Shopify customization, particularly with creating bespoke headers. A keen attention to detail is crucial to ensure an exact replica of the reference site.
I'm seeking a proficient SQL developer with extensive experience in Sage X3 ERP. The task is to craft a query that compiles an Inventory Valuation by Date across multiple warehouses. The valuation method is FIFO. Key Requirements: - Expert in SQL with a focus on writing complex queries within Sage X3. - Deep understanding of Sage X3's data structure, particularly inventory and valuation data. - Ability to retrieve accurate inventory valuation details broken down by date. - Skill in referencing the correct tables and fields, and applying all necessary joins and conditions. The query should accurately reflect FIFO inventory valuation across multiple locations. Experience with this ERP system is crucial for success in this role.
Overview I am hosting a competitive Rust server and need a professional, feature-rich website to support the community. The website should have a clean and immersive Rust-themed design (radiation, snow, forest, desert biomes) and be user-friendly for both players and admins. Key Features 1. Landing Page A banner titled Rust Competitive Servers (RCS) with a simple, professional design that reflects Rust’s aesthetic. Navigation links to all core pages. Social media links to connect with the community. 2. About Page Editable free-text section for admins to modify. 3. Community Section Free message board available to all users. Subscriber-only message board for exclusive discussions. Admins can create categories (e.g., "Searching for a Team"). Players’ subscri...
I need a freelancer to convert a photo into a vector file suitable for laser cutting. The vector needs to be saved as a .dxf file. Requirements: - Medium detail: The vector should not be overly intricate but should still capture enough detail for a successful laser cut. - Inclusion of text and shapes: The conversion should encompass both text and shapes from th...still capture enough detail for a successful laser cut. - Inclusion of text and shapes: The conversion should encompass both text and shapes from the original photo. Skills & Experience: - Proficient in graphic design software capable of vector conversion (e.g., Adobe Illustrator, CorelDRAW). - Previous experience in creating vector files for laser cutting. - Attention to detail and ability to replicate text and shap...
I'm currently facing an execution error with my SQL Server. Specifically, I'm receiving incorrect results from my queries. This issue seems to stem from a problem with a particular table. As such, I'm reaching out to seek assistance in identifying and resolving the underlying problem. Ideal skills for this project include: - Proficiency in SQL Server - Experience with troubleshooting execution errors - Ability to diagnose and fix table errors - Strong problem-solving skills and attention to detail I appreciate your expertise in helping me get to the bottom of this issue.
... and manage relational (SQL) and non-relational databases for data storage and retrieval. Cloud Technologies: Leverage cloud platforms such as AWS, GCP, or Azure to deploy and manage data infrastructure. Collaboration: Work closely with data scientists, analysts, and software engineers to support analytical and machine learning projects. Data Quality & Performance Optimization: Ensure data accuracy, consistency, and security while optimizing performance. Monitoring & Troubleshooting: Identify and resolve data pipeline performance bottlenecks and failures. Required Work Experience: 2+ years of experience in data engineering or a related field. Proven experience developing ETL pipelines and data processing workflows. Hands-on experience with PySpark, Pandas, and SQL...
Freelance Developer Needed: .NET Blazor Server Application with WhatsApp Integration I'm looking for a skilled freelance developer to build a robust and secure .NET Blazor Server application with comprehensive WhatsApp integration and API capabilities. The ideal candidate should have extensive experience with Blazor Server, .NET development, SQL Server, secure coding practices, and DevOps principles. Full source code sharing without any locks or time-based restrictions is mandatory. Project Overview: This application will serve as a platform for sending WhatsApp messages (both template and non-template), managing WhatsApp numbers, and providing API access to third-party applications. Security is paramount, and all development must adhere to best pr...
I'm looking for a professional with a keen eye for detail and experience in Photoshop to help me add some minor text to an image. The text needs to be placed at the top of the image in a handwritten or script style, specifically in black. Ideal Skills: - Proficiency in Photoshop - Experience with graphic design - Attention to detail - Ability to replicate a specific style Please ensure to provide examples of similar work you've completed in the past.
I'm seeking a skilled developer to modify the layout and functionality of our Shopify 'Flex' theme template. Summar...Duplicate the ‘custom’ product page features from current theme (live website) to the new Flex theme under development (using shopify 2.0). There are 4 product page custom features which need to be duplicated from current theme/website to new theme/website: 1. Truncated ‘full description’ 2. Safety & Privacy buttons 3. Tabs (expandable) 4. Show me in 3D button Simply duplicate exist code and replicate to ‘Default’ product page in new 'Flex' theme (shopify 2.0). Ideal candidates MUST have: - Extensive experience with Shopify 2.0 and editing theme templates - Strong skills in HTML/CSS and Liquid (Sh...
I need a professional to replicate my existing website and create a new one under the domain plasticsconsent.com. This project includes updating the content and making specific modifications to the body map. Key tasks include: - Exact replication of to , with the necessary content updates. - Modifying the body map to include breasts, abdomen, neck, and face, while retaining existing body parts. Ideal candidates for this project should have: - Proven experience in website replication and content updating. - Strong understanding of body map modification. - Excellent attention to detail to ensure the new site mirrors the original accurately. - SEO and content development experience preferred for the content updates.
...6️⃣ Communication Between Website and Desktop Application Develop an API or WebService to allow the desktop application to check the user’s license status. If the license is active, grant access to the application. If the license expires, the login must be automatically blocked. 7️⃣ Security Encrypt user data, especially passwords and payment information. Implement protection against attacks like SQL Injection and XSS. Use SSL certificates to secure transactions. Implement a method to prevent multiple simultaneous logins with the same account. 8️⃣ Additional Monetization - Google Ads Set up the website to sell an advertising space for Google Ads. 9️⃣ Extras in the Desktop Application Add a Disclaimer module in the application. Encapsulate the code to prevent reverse enginee...
Estou procurando um desenvolvedor para acessar remotamente meu computador e configurar um ambiente de trabalho de um OT 7.4 estável. Basicamente é realizar uma instalação limpa para que eu possa começar a estudar criação de áreas, itens, scripts e etc.
I'm in need of a skilled professional to set up a VPN server in China. The primary purpose of this server will be to secure remote work connections. Key Requirements: - Proficient in OpenVPN protocol, as this is the preferred VPN protocol for the server. - Extensive experience with Windows operating system, since the VPN server will be installed on a Windows platform. - Previous experience in setting up VPN servers, particularly in China, would be a significant advantage. - Strong understanding of network security and remote work needs. Please bid if you have the required skills and experience. Looking forward to your proposals.
I'm looking for a skilled professional who can convert my existing Excel/Numbers order form into an online order entry system. This project will involve creating both a basic version and a database-driven version of the order form. Key Requirements: - The online order form should be integrated with a custom Order Entry System. - It would need to replicate the tabs on the excel and the basic formulas - It should have the capacity to store customer data, specifically contact information and details pertaining to my business clients and schools. Ideal Skills and Experience: - Proficiency in Excel and Numbers - Experience in developing online order systems - Knowledge of database management - Understanding of customer data storage solutions Please note that the or...
We have an existing Telegram Payment Plugin developed for WordPress, and we need a skilled developer to convert it into an OpenCart plugin with the same functionality. The plugin integrates the checkout process with a Telegram bot, allowing real-time notifications and manual ...confirmed. If the OTP is incorrect, an error message is displayed. Custom Pages & Admin Interface: Redirect the user to a custom OTP entry page after payment authorization. Develop an admin panel in OpenCart to configure the Telegram bot, bot token, and customize notifications. Requirements: Strong experience in OpenCart plugin development. Experience with Telegram bot integration. Ability to replicate the WordPress plugin’s functionality in OpenCart. Clear documentation and structured code for ea...
I'm seeking an experienced developer proficient in React and SQL for a web application project. The ideal candidate will have a strong portfolio demonstrating their expertise in these technologies. Please include your portfolio with your proposal.
I'm an emerging streetwear brand seeking a talented graphic designer to help me bring my vision to life. My brand encompasses various apparel, including shirts, jogger pants, and beanies, all of which will incorporate graphic design with a distressed vintage style. Key res...for shirts, jogger pants, and beanies. - Incorporate elements such as logos, typography, and illustrations into the designs. - Emulate a faded and worn look that aligns with the distressed vintage style of the brand. Ideal candidate: - Proven experience in streetwear graphic design. - Strong skills in creating and integrating logos, typography, and illustrations. - Ability to understand and replicate a specific distressed vintage style. - Creative, innovative, and able to work collaboratively to bring my ...
I'm looking for an experienced textile designer to create 3 separate realistic all-over sublimation print patterns for t-shirts. The patterns should be based on images I have of 1. cottonseed, 2. corn, protein & cottonseed & 3. Sky & Clouds. Key Requirements: - Create 3 patterns that closely resemble the images of corn and protein pellets. - The size of the corn, prote...patterns that closely resemble the images of corn and protein pellets. - The size of the corn, protein and cottonseed should be to scale, as in real life. - Use natural colors that match the corn and protein pellets for the patterns. Ideal Skills: - Expertise in textile design and pattern creation. - Experience with all-over sublimation print patterns. - Strong attention to detail and ability to repli...
DotNet developers required for "#Improvement work and Errors removal" in thenafter Host on server. Developers should also have knowledge about Merger of sourcecode and database of his done-work with other developer's done-work on GitHub. Website Address - User emailid- userany303@gmail.c Password- kaspersky Technology - .Net Languages - C# Video link of 'Improvement work and Errors removal' which needs to be done will be given in messaging.
I am seeking a seasoned developer with vast experience, particularly in Angular, HTML, CSS and SQL for a critical business project that requires prompt execution. Key Responsibilities: - Building a fully functional web interface - Designing efficient databases - Ensuring seamless integration across multiple platforms Ideal Skills: - Proven competence in Angular, HTML, CSS and SQL - A solid background in web development for businesses - Ability to work under tight deadlines Freelancers interested in this project should, in their application, highlight their experience especially in the mentioned languages. Please, remember that this task needs to be executed ASAP. Therefore, readiness to start work immediately will be an added advantage.
I need a simple landing page website for my street food stall, designed in Wix. The site should be in English, German, and Italian. It should closely replicate the structure and features of the example site (), incorporating: - Home page layout - Menu section - Contact form - A layout where everything is on the landing page An added functionality will be a direct contact form that links to WhatsApp. Ideal candidates should have experience with Wix, web design, and multilingual sites. Please provide examples of similar projects you've completed.
I need an experienced server administrator and DevOps engineer to configure my Ubuntu VPS for a specific version of Laravel. The project includes: - Installation and configuration of Laravel - Setting up MySQL, Redis, and PHP-FPM - Creating a CI/CD pipeline from GitHub to my VPS using Github actions and Secrets - Ensuring the server is ready for Crons The ideal candidate should have: - Advanced skills in PHP, Laravel, MySQL, Redis, and PHP-FPM - Proficiency in setting up and managing Ubuntu servers - Extensive experience with Github actions and Secrets for CI/CD - Previous experience with setting up servers for Laravel applications - Knowledge of configuring Crons on a server Please ensure to include relevant examples of your previous work when bidding.
I need a skilled developer to create a Canvas app in Power Apps for data entry and management. Key Responsibilities: - Design and implement a user-friendly Canvas app. - Ensure the app is efficient for data entry and management tasks. - Potential for future work to integrate different data sources such as SharePoint, SQL Server, or Excel. Ideal Skills and Experience: - Proven experience in developing Canvas apps in Power Apps. - Strong understanding of data entry and management processes. - Ability to create intuitive, user-friendly interfaces. - Experience integrating various data sources into Power Apps.
We are looking for an experienced Shopify Developer with expertise in the Focal theme and the ability to replicate its search functionality in the Broadcast theme. The ideal candidate should have a strong understanding of Shopify’s Liquid framework, custom theme development, and front-end technologies to ensure a seamless user experience. Key Responsibilities: Analyze the search functionality of the Focal theme and replicate it within the Broadcast theme. Customize and optimize Shopify themes using Liquid, JavaScript, HTML, and CSS. Ensure seamless integration of search functionality while maintaining theme performance. Troubleshoot and debug any theme-related issues. Collaborate with designers and stakeholders to ensure a visually and functionally refined end product....
I'm seeking a skilled mobile app developer to convert my existing HTML prototype into a fully functional native iOS and Android app. The current version has been converted to an APK, but I need a more robust, native solution that leverages the full power of smartphone capabilities. Background knowledge in Golf is a plus Key Req...Proven track record in developing native iOS and Android applications. - Proficiency with GPS and mapping APIs is a plus. - Previous experience implementing offline functionality in apps. - Strong understanding of user interface design for mobile apps. Please note, I am not looking to add any complex features like push notifications or advanced user analytics at this stage. The priority is to replicate the existing functionality in a more efficient,...
I'm looking for assistance converting a PDF document to a Word document. It's crucial that the converted document maintains the original formatting exactly. Ideal Skills and Experience: - Proficiency in PDF conversion - Excellent attention to detail - Strong knowledge of Microsoft Word - Ability to replicate complex formatting
...seasoned PHP Laravel developer who can maintain and modify our VPS server. The developer should have profound knowledge of the complete PHP Laravel framework and be capable of managing the server independently. Key Responsibilities: - Code maintenance and updates: Regularly review the codebase for bugs and inefficiencies, implementing necessary updates to improve performance and ensure smooth operation. - Server management and optimization: Oversee the performance of our VPS, making necessary adjustments to optimize speed and efficiency. - Implementing new features: Develop and integrate new features based on our evolving needs and specifications. Security Measures: - Regular security updates and patches: Ensure the server and codebase are protected against...
Se intentó implementar un cluster de SQL Server en maquinas virtuales en Azure, pero no funcionó. El proveedor actual ha indicado que se necesita un recovery site, se busca asesoría técnica y estratégica para entender la situación actual, evaluar las opciones disponibles y proponer una solución rentable y escalable. Objetivos del Proyecto: *Realizar un diagnóstico técnico del cluster de SQL Server y el recovery site propuesto. *Evaluar las razones por las cuales el cluster no funcionó correctamente. *Identificar alternativas viables y rentables para implementar un recovery site. *Apoyar en la comunicación con los líderes del proyecto para explicar la situación y las recom...
I need a developer who can host my project on my server. I have my VPS server on actually one of my developer was trying to host but he is not able to host there he did all the setup there like DNS, create subdomain and all...