Mysql php plugin jobs

...need my WordPress website updated to run on PHP 8.3. Key Issues: - Plugin compatibility: My site is currently experiencing issues with compatibility of various plugins. - Theme compatibility: The current theme also poses compatibility issues. - Deprecated functions: There are several deprecated functions that need addressing. The entire website needs to be checked for compatibility with PHP 8.3, including: - SEO plugin - Security plugin - E-commerce plugin - All other plugins currently in use I suspect there may be some custom-coded features or functionalities on the site, but I'm not entirely sure. Therefore, I would appreciate a thorough review of the site. Ideal Skills: - Expertise in WordPress and PHP - Experience with tro...

...description: Introduction This proposal outlines the development plan for a comprehensive Nursery Management Web Application. The application is designed to meet the needs of nursery owners, parents, and administrators by providing essential functionalities such as child management, attendance tracking, billing, and more. Technology Stack** • Front-end: React and • Backend: PHP (Laravel framework) • Database: MySQL Deliverables 1. Main Application Account • Dashboard • Customizable with widgets and graphical elements. • Client Account Management • Create, suspend, delete client accounts. • Access Control • Give access rights to certain features. • Billing with Deposits and Discounts • Implement basic functionality ...

...to generate commissions for pickups. - A seller dashboard for managing pickups. - Configure the above with the Dokan plugin. - Allow sellers to process multiple orders in bulk for shipping. - Enable sellers to print shipping labels directly from their dashboard. - Automate shipment tracking updates for both sellers and buyers. - Add options for sellers to import and export shipment data via CSV files. - Integrate real-time shipping rate calculation based on package dimensions and destination. - Implement notification system to alert sellers of shipment statuses and issues. - Set up a system for managing shipment returns seamlessly. Ideal Skills: - Experience with Dokan plugin and its integration. - Familiarity with Shiprocket courier service. - Web development skills for...

I need an experienced WordPress developer to customize my WholesaleX plugin. The goal is to display product images from my WordPress media library next to the product names in the Bulk Order form, and list all the items in a table by default with pagination. when you click the thumbnail, the full size image will be displayed. The list should be as attached screenshot and dynamic values should come like if the discount applied to any product, there will be displays prev price and discount price. Minimum and maximum feature should work. Requirements: - Expertise in WordPress and plugin customization - Familiarity with the WholesaleX plugin - Ability to fetch and display images from the WordPress media library - Skills to use wordpress queries. Please refer to the attac...

I'm experiencing issues with my WordPress site. Specifically, the email notifications that should be triggered by the PhonePay gateway API are not being sent upon payment success or failure. I need an experienced PHP developer who can: - Debug the custom code in the PhonePay gateway integration - Identify and fix the email sending issues Skills and experience: - Proficient in PHP and WordPress - Prior experience with payment gateway integrations, particularly PhonePay is a plus - Strong debugging skills - Good understanding of email integration in PHP/WordPress Please note that the specific email service being used has not been identified, so adaptability and broad knowledge of email services is essential.

1) If a user Renew an existing listing via user panel - that has expired and the price package is no longer active, then No Paytraq invoice is not generated if the Basic paid price of €29.00 is selected. E.g. this path - existing listing via user panel - that has expired and the price package is no longer active, then No Paytraq invoice is not generated if the Basic paid price of €29.00 is selected. E.g. this path - ... 2) Paytrac plugin with PaydMembershipPro - is no phone number in the recurring invoices.

...multiple tabs are open. Restarting the database resolves the issue, and everything works fine afterward. Currently, everything is functioning properly About hosting: We have a droplet on digital ocean, we manage it through SSH Here is the description: Responsibilities: 1. Diagnose Issues: -Investigate and resolve crashes and MySQL errors. -Analyze server logs and pinpoint the root causes of instability. 2. Optimize Server Configuration: -Tune Apache, MySQL, and PHP configurations for high-performance WordPress operations. -Recommend and implement caching mechanisms (e.g., object cache, database caching). 3. WordPress Optimization: -Audit WordPress setup (plugins, themes, bulk editing processes). -Optimize database queries and reduce load during bulk operations. 4...

I need a Shopify plugin that works as per the following my PDF requirements attached

To enhance our deployment process, we want to introduce a feature in Jenkins. This feature wi...issue occur, we can quickly revert to a previous successful deployment by simply selecting an image from our deployment history. Key Requirements: - Implement a Jenkins feature to store images of the last 5 deployments. - Ensure the feature allows easy selection and redeployment of previous successful deployments. Ideal Skills: - Extensive experience with Jenkins, particularly with the Pipeline plugin. - Familiarity with deployment processes in Staging and Production environments. - Knowledge of version control systems (though this project does not currently specify one). This project aims to streamline our deployment process, minimize downtime, and ultimately improve our operational e...

Project Duration: 1 Hour Only Project Type: WordPress CSS Project Level: Standard Project Overview We have a simple WordPress quiz plugin that requires two mobile responsive design improvements. Changes should apply to mobile devices only Changes should be made directly to the plugin’s css style sheet 5* FEEDBACK WILL BE LEFT FOR YOU

...• Implement a countdown timer for each quiz session. • Track and store answers in real-time. • Implement logic to prevent showing answers until the quiz is complete. • Calculate final score and display results after submission. 3. Backend Development: • REST API to manage user accounts, quiz data, payments, and certificate generation. • Secure database to store user data and quiz results (MySQL, MongoDB). • Integration with payment gateway in stripe for subscription and certification fees. • PDF generation library to create downloadable certificates. 4. Security: • Use HTTPS for secure communication. • Implement user authentication for account management. • Ensure secure handling of payment information (compliance...

I'm looking for a skilled developer to create a WordPress plugin for my Abacus and Vedic Maths website. This plugin should provide interactive, timed challenges aimed at children aged 6-12 years. Key Requirements: - The plugin should deliver interactive exercises in the form of timed challenges. - The challenges should be suited for children (6-12 years), engaging and educational. - Strong proficiency in WordPress plugin development is essential. - Prior experience with creating educational plugins or games will be a significant advantage. - Understanding of Abacus and Vedic Maths is a plus. - Ability to deliver a user-friendly, bug-free plugin on time. The goal of this project is to enhance the interactivity of my website and make learning more f...

I need code source php to get direct link from Ex: Direct link: !Tj9l0PlYvR0DVGDtKgcFLUZY2ZpM_tjTZudnQwr4y8rK9gFIQz4ndFDeOSUiFbfj7XL09AUbIgxAqj1kD1AM8VkpmeMgApYXRGWPUonEDPryyVbhq18Bh5kP8UQ-qFynbgCgFYqtGfhf2lYR3UjX4QNLtf-tI2iHNvUa6V7kJgaS8D0JnroAf0PEpTqj1cGdPVieIHMqjrYGCbCAjt_TVbStWlrn16ZNv8vfk4qQI84gup9FWESeQ7qw0NWzVYcusITayiJsnsJpGught3wB71AYcKuFsANBISjXm-P2tytV5vOf45whBRJPXuPAzDTZBon6jFIzKz4l_mpQLvh9N38rr3XOCcKr1J0GkvKfKWyXL8_Jzaaf9HZvnSLcvkzs6XgXcARkkjDeV7AfiQT1JLZl9YNeg0wRySJNlkVqw8hBrFLwVcDvJLsm8tX5utVKK9hUXzJJN1dy1M17FeUSTUbpR-KHD6FLB_vLjPXlm0iz4qEl34whfrGC9LDOoRABHYOKmWCGk3v2x01KG9Nz-_a7cd49KfUVD69yrIjUiEQ_q_8RHh69nQ9CQ-06AbNWeawKT4a6jdvzKbiTnlaTifkk8lAZXPLjZecz9larviy19sl-cdO-28LB0xfcd

Hi I had a designer improve the page of a back-end web app (a list of orders) and now I need to merge back those changes to the php file (and css and js) I'll provide you the new html file and ftp access to the php file. I'm using the adminlte template. Max bid 50 euros. Thank you.

...Participate in on-call rotations and provide after-hours support as needed. Required Skills and Experience • 5+ years of experience in Java application development and support. • Strong proficiency in Core Java, including multithreading, collections, and exception handling. • Hands-on experience with frameworks such as Spring and Hibernate. • Proficiency in working with relational databases like MySQL, Oracle, or PostgreSQL, including writing complex queries. • Strong understanding of web services (SOAP/REST) and API integrations. • Experience with debugging tools (e.g., JDB, VisualVM) and logging frameworks like Log4j or SLF4J. • Familiarity with application servers (e.g., Apache Tomcat, JBoss, WebLogic). • Knowledge of version co...

...pages using the existing WordPress theme and template. Design and optimize graphics to align with the website’s theme and branding. Configure plugins as needed to enhance functionality. Ensure the website is user-friendly, responsive, and optimized for SEO. Provide recommendations for additional improvements. Requirements: Proven experience with WordPress development, including customizations and plugin usage. Strong graphic design skills and familiarity with Photoshop, Canva, or similar tools. Knowledge of SEO best practices....

Currently, my old WordPress site has been uploaded to the host and requires comprehensive management and enhanc...site has been uploaded to the host and requires comprehensive management and enhancement. Specifically: someone in Melbourne Australia because f-f meetings may happen down the track. Key Tasks: - Oversee seamless WordPress and plugin updates, specifically focusing on the SEO and Security plugins. - Redesign existing plugins to enhance user interface. Additionally, I'm seeking a professional who can: - Develop a new SEO strategy as my current one is ineffective. Ideal Skills and Experience: - Proficient in WordPress management. - Extensive experience with plugin design and updates. - SEO expertise with a proven track record. - Strong skills in creating enh...

...especially those capable of display advertising integration. Experience in creating location-targeted and vertical-specific display ads, particularly for sports and restaurant promotions. Mobile app development experience (native Android, iOS, or cross-platform apps using React Native/Flutter). Proven experience in deploying apps to Google Play Store and iOS App Store. Strong knowledge of REST APIs, MySQL, and/or MongoDB for database management. Ability to handle data synchronization across multiple platforms and ensure a seamless user experience. Strong communication skills and the ability to work in a team with a Project Manager. Ability to meet deadlines and deliver the project within the allocated timeline of 2 months. Payment Terms: 20% Escrow Deposit: 20% of the total proje...

I need to generate an MFA system using TOTP, with existing users. The process is as follows: they enter the LOGIN page with username and password, then I need two-factor so they can continue if everything is correct. The system is developed in PHP/MYSQL without any type of framework. I only require MFA/TWO-FACTOR to validate as a second step, otherwise they will not be able to enter. Third-Party applications can be used. I need the system to be secure for validation The budget can be variable and we could adapt if we have a good proposal, if you have a demo, send it

I need a WordPress and WooCommerce expert to help me with my live website. I need a few quick modifications that should take a couple of hours. Specifically, I need: - Functionality updates related to product customization options. - Adjustments and updates using the "Extra Product Options & Add-Ons for WooCommerce" plugin. - Help with adding new product options, modifying existing ones, and fixing issues with current options. If you're available to work in the next 2-3 hours, please get in touch.

I'm in need of a skilled Craft CMS developer who can assist in updating my Craft CMS version and plugins. The ideal candidate will also be able to troubleshoot and fix current errors and bugs. Key responsibilities...Craft CMS version and plugins. The ideal candidate will also be able to troubleshoot and fix current errors and bugs. Key responsibilities: - Update Craft CMS and plugins - Diagnose and fix performance issues - Resolve compatibility problems - Repair functionality errors - Troubleshoot issues with the Redactor plugin The developer should be familiar with working with custom themes, as I have several in use. Experience with Craft CMS is a must, and previous work with the Redactor plugin will be a plus. I need someone reliable who can help me get my site r...

I'm looking for a skilled developer who can help me integrate my PHP application with the Microsoft Graph API. The primary goal of this project is to automate workflows specifically related to Device Management and Enrollment services in Office 365. Key tasks include: - Automating device enrollment processes by providing a php script that will allow us to automate enrolment into customer tenancies and also remove devices from customer tenancies. Ideal candidates should have: - Proficiency in PHP - Experience with Microsoft Graph API - Ability to create an application to make sure this works. - Understanding of Office 365 Device Management services - Skills in workflow automation

I'm looking for a C# plugin for Power BI Desktop that can help me optimize my reports. The plugin should: - Detect unused columns in tables and create M queries to remove them. - Scan all open Power BI reports and list them in a combo box for selection. - Identify all measures in the selected report and provide optimized DAX code for each. A list of these measures should also be in a combo box. My primary data sources are SQL DB and Excel, so experience with these is crucial. The plugin needs to work with both imported data and DirectQuery modes.

I'm looking for an experienced PHP developer to create a secure, performance-optimized user management system within a PHP MVC framework. This system should encompass features such as: - User registration with email activation using PHP Mailer - User login - 'Forgot Password' functionality - Bootstrap 5.3 for responsive design - Server-based validation - User-friendly notifications via session on every action Security is paramount in this project. The application must be robust against various types of attacks, specifically Cross-Site Scripting (XSS), Cross-Site Request Forgery (CSRF), and SQL Injection. Additionally, a configuration file should be created with BASE_PATH and BASE_URL for easy management. Forms must be secure, implemented with CSRF an...

I need a skilled PHP developer to create a system that exports data from my MySQL database into PDF/A-1a formatted documents. The PDF/A-1a will need to incorporate text, images, and tables from the database. Key requirements: - Proficiency in PHP and MySQL - Experience with PDF/A-1a format - Ability to create structured layouts with sections - Understanding of exporting diverse data types (text, images, and tables) The ideal candidate will have a strong portfolio that demonstrates their ability to deliver high-quality, accurately formatted PDF/A-1a documents. The project involves creating a system that formats the PDF/A-1a in a structured manner with clear sections. Please include relevant examples from your past work in your application.

...cloud deployments and microservices approach to build the application. - Proficient in planning, designing and implementing SPAs using Angular and developing REST APIs using Node JS. - Created Typescript reusable components and services to consume REST APIs using Component-based architecture. TECHNOLOGIES: Node.js | Angular | React.js | | Java script | TypeScript DATABASE SQL | PL/SQL| MySQL | PostgreSQL | MongoDB | Amazon DynamoDB PM TOOLS: GIT | SVN | JIRA Monthly Remuneration: INR 75-80K Duration : 3 Months with very high possibility for extension. You should be open for an interview with a highly technical CTO. Please apply with your complete profile & examples of your best work. This position is ONLY for Full-time freelancers based in India. Agencies please don&#...

...sensor: Moisture sensor against a reference meter. Load cell using known reference weights. Color sensor with good and bad grain samples. Test the entire system with paddy samples to validate the accuracy and precision of the readings. Provide documentation or a guide on how to use the equipment and adjust the system. 4. Optional Enhancements (if applicable): Responsibilities: Add a database (SQLite/MySQL) to log test results for future reference and analysis. Create a simple dashboard or GUI to visualize and track paddy quality over time. This could be a web-based interface or a desktop application (e.g., Flask, Tkinter). Implement IoT features, such as cloud data storage or remote monitoring capabilities. Skills and Experience Required: Proficiency in electronics and hardware s...

I'm experiencing layout issues on the product pages of my website. The problems include irregular colors, double elements, and misaligned items. Ideal skills and experience for the job: - Proficiency in web design, particularly in fixing layout problems on LifterLMS plugin - Experience with e-commerce platforms and product page design - Strong attention to detail to identify and rectify color inconsistencies - Ability to troubleshoot and resolve issues with overlapping content and misaligned elements - Good understanding of UX/UI principles to ensure a seamless navigation experience

I'm looking to enhance my WordPress site with a custom plugin that adds specific features. The main function of this plugin is to create custom forms. The plugin must be simple to configure and use, and it should come with clear setup and usage instructions. Key requirements: - Develop a straightforward WordPress plugin that integrates custom forms - Ensure the plugin is reliable and enhances website functionality - Deliver within a short timeframe, ideally one to two weeks - Provide clear setup and usage instructions Ideal skills and experience for the job: - Extensive experience in WordPress plugin development - Proficiency in PHP, HTML, CSS, and JavaScript - Prior experience creating custom forms plugins - Ability to deliver withi...

I need a professional to integrate the MyFatoorah payment gateway plugin into my NopCommerce 4.70 store. The project requirements are straightforward: - Basic Payment Processing: The plugin should seamlessly handle standard payment processing tasks. - Single Currency Transactions: Multi-currency support is not necessary; the gateway only needs to process payments in a single currency. - Standard UI Elements: The integration should use the default user interface elements provided by the payment gateway, without the need for custom design. Ideal candidates should have proven expertise in NopCommerce and experience with integrating payment gateways.

I need assistance with installing Flutter and the Dart plugin on my Mac running macOS Monterey.

I have stock market candle data stored in a MySQL database, including open, high, low, close, volume, and time. I need a PHP script that generates order blocks after breakouts and breakdowns, and stores this data in the database. Key Requirements: - The script needs to identify whether the stock is reaching an order block after a breakout or breakdown, with volume is shrinking or not. - The analysis should be based on technical analysis principles. - Data should be updated in the database automatically, in real-time. - I will run this script after every candle close to analyze. Ideal Skills and Experience: - Proficiency in PHP and MySQL. - Strong understanding of technical analysis and stock market dynamics. - Experience with real-time data processing.

...Options**: - Ability to change the website's language (optional, depending on the target market). --- #### 4. Proposed Technologies 1. **Frontend**: - HTML5, CSS3, and JavaScript. - Frameworks like React or Vue.js to enhance the user experience. 2. **Backend**: - Node.js with Express or Django (Python). - RESTful API for frontend and backend interconnection. 3. **Database**: - MySQL, PostgreSQL, or MongoDB (depending on needs). 4. **Hosting**: - Amazon Web Services (AWS), Google Cloud, or services like Vercel for frontend. 5. **Payment Platforms**: - Integration with Stripe, PayPal, or similar platforms. --- #### 5. Interface Customization 1. **Visual Design**: - Use of corporate colors and company logo. - Smooth animations for transit...

I'm experiencing issues with my MySQL ADX formula. The calculations are producing incorrect data output, specifically wrong values. The issue seems to occur during the calculations phase. Ideal skills for this project include: - Proficiency in MySQL and data analysis - Strong understanding of ADX formula mechanics - Experience in troubleshooting and fixing data calculation issues I need a freelancer who can quickly identify the problem and provide a solution.

...results from the indexed data. • Features: • Simple, user-friendly interface for searching indexed data. • Fast and relevant search results. • Results should be displayed with the most relevant information at the top (based on keyword match, ranking, etc.). 5. Database Integration: • Purpose: Set up a database to store and manage crawled data and indexes. • Features: • Use a scalable database like MySQL, PostgreSQL, or MongoDB. • Efficient query handling to fetch search results quickly. 6. Scalability & Performance: • Goal: Ensure the entire system is optimized for performance, scalability, and reliability. • Details: The search engine should handle a large volume of data and multiple simultaneous users. Deliverables: •...

...status of deliveries. Reports and analytics should be available for sales data, with an option to download reports in CSV format. Additionally, a mobile-friendly delivery agent portal should be created to let agents view their assigned orders and mark them as delivered. For the technical specifications, I prefer using PHP for the backend, with Laravel or CodeIgniter as the framework. The frontend can be developed using HTML, CSS, and JavaScript, with Bootstrap for responsiveness. MySQL should be used for the database. I already have hosting with Hostinger, so the system should be compatible with their services. Integration with Razorpay or Paytm is required for secure online payments....

Web Developer – Repair Email Registration Function for Download Buttons Description: We are looking for an experienced web developer to repair and implement a function that allows users to download free sheet music after registering via a pop-up form. The pop-up form should collect user details and ensure the visitor is added to the mailing list via the Arigato Pro plugin, but only if the visitor is not already registered. The issue is currently present on certain pages of our website, , including the page “A Minor Indulgence – Free Sheet Music for the Flute.” Key Responsibilities: -Repair Existing Function: Replicate the working functionality of the download button from the page Free Sheet Music for the Flute – A Minor Indulgence to the page A Minor ...

Looking to get a php api that takes a postcode. goes too my database and brings back customer details for that post code. A similar api is written like this so most of code can be copied. Simple project and i need this done today public function geteircode(){ if(isset($_POST['eircode']) && !empty($_POST['eircode'])){ $code = strtr($_POST['eircode'],[' '=>'']); $ir_identifiser = array("A41","A42","A45","A63","A67","A75","A81","A82","A83","A84","A85","A86","A91","A92","A94","A96","A98","C15","D01","D02",...

I'm a recent high school graduate seeking assistance with data entry into my SQL-based database. Ideal Skills: - Proficient in manual data entry - Experienced with SQL databases (e.g., MySQL, PostgreSQL) - Strong attention to detail and accuracy - Good communication skills - Problem-solving abilities

I'm encountering issues with my MySQL ADX formula which is yielding incorrect values. This formula is being used for trend analysis on sales data. Ideal Skills & Experience: - Extensive experience with MySQL - Proficiency in crafting and troubleshooting ADX formulas - Background in data analysis, specifically sales data - Ability to deliver accurate results in a timely manner.

I'm experiencing issues with the ADX formulas in MySQL. The results I'm getting from the built-in SQL functions are incorrect. Specifically, I'm trying to calculate the directional movement, but the output doesn't align with my expectations. Skills and experience that would be ideal for this job include: - Extensive knowledge of MySQL - Proficiency with SQL's built-in functions - Experience troubleshooting formula-related issues - Understanding of directional movement calculations

I need an advanced PHP script that displays updated content in real-time on basic HTML without having to reload/refresh the site. Those data is mostly in JSON format from .log-files. -no fixed intervals (update when there are new logs) -no leaking endpoint -web server should not log when the content is updating

I need a professional to integrate the MyFatoorah payment gateway plugin into my NopCommerce 4.70 store. The project requirements are straightforward: - Basic Payment Processing: The plugin should seamlessly handle standard payment processing tasks. - Single Currency Transactions: Multi-currency support is not necessary; the gateway only needs to process payments in a single currency. - Standard UI Elements: The integration should use the default user interface elements provided by the payment gateway, without the need for custom design. Ideal candidates should have proven expertise in NopCommerce and experience with integrating payment gateways.

I need a MySQL expert to help me compute compound interest on a daily basis. Details: - Perform daily compound interest calculations using MySQL. - Debug any errors related to financial computation procedures. - Ensure accuracy and efficiency of computations. Ideal Skills: - Proficient in MySQL. - Experience in financial computations. - Strong problem-solving skills.

I'm looking for an experienced PHP developer to install a PHP script on my shared hosting server. The installation does not require any modifications to the script, so the ideal freelancer would be someone who can handle the installation process smoothly and efficiently. Key Requirements: - Proven experience with PHP - Familiarity with shared hosting environments - Ability to install scripts without modifications Please note that the exact directory for the installation hasn't been decided yet, so some flexibility is appreciated.

...of a skilled WordPress developer who can create a plugin for my wedding photography business. The plugin should facilitate an efficient booking system, align resources for each event, and manage payments. Additionally, a calendar view to keep track of bookings is essential. Key Features: - A client booking form integrated within the plugin - An intelligent system to align resources for each event - Payment management capability The candidate should have: - Extensive experience with WordPress plugin development - Prior work with booking systems - An understanding of resource management for events - Knowledge of secure and reliable payment management systems Please note that I have not specified the payment methods yet. However, the plugin should ha...

I'm seeking a skilled developer to make modifications to my SaaS School Management System. The primary tasks involve: - Implementing both percentage-based and fixed amount disco...seeking a skilled developer to make modifications to my SaaS School Management System. The primary tasks involve: - Implementing both percentage-based and fixed amount discounts in already existing functionality , which should only be applicable by school administrators. - Making changes in installement fee module like making it flexible. Ideal candidates should have a strong understanding of PHP, Laravel , SaaS platforms and school management systems, with proven experience in implementing discount systems and flexible payment modules. Please provide examples of similar projects you have successf...

I have the frontend part of a website ready and need a skilled developer to work on the project and complete the backend. Key Requirements: - Set up a MySQL database to handle signup and login credentials using Email and Password authentication mechanisms. - Establish a connection with Node.js. - Implement a buy and sell feature, including product listing and payment gateway integration. - Create a database for the buy and sell feature. - Develop a system for listing all available products for potential buyers. Timeframe: The project needs to be completed within 2 days.

...results from the indexed data. • Features: • Simple, user-friendly interface for searching indexed data. • Fast and relevant search results. • Results should be displayed with the most relevant information at the top (based on keyword match, ranking, etc.). 5. Database Integration: • Purpose: Set up a database to store and manage crawled data and indexes. • Features: • Use a scalable database like MySQL, PostgreSQL, or MongoDB. • Efficient query handling to fetch search results quickly. 6. Scalability & Performance: • Goal: Ensure the entire system is optimized for performance, scalability, and reliability. • Details: The search engine should handle a large volume of data and multiple simultaneous users. Deliverables: •...

Hi, Need some one who is expart in Woocommerce Custom Plugin, This will be a urgent requirement and need to fix asap.