Fix 37000 mysql error sql syntax server version jobs

I'm seeking a proficient Excel expert to create an interactive mark sheet specifically designe... Key Features: - Implementation of essential calculation formulas: This will include automated calculations for grades, averages, and other relevant metrics. Delivery: - The final sheet is expected to be shared through a link to an online version that can be edited. This will ensure easy access for students and real-time updates as needed. Ideal Candidate: - Proficient in Excel and experienced in creating interactive and user-friendly sheets. - Knowledgeable about education-related metrics and formulas. - Ability to deliver a reliable online version for easy access and editing. Please note that the primary users of this mark sheet will be students, so simplicity and ease...

Seeking a freelancer to revamp a WordPress webshop plagued by malware. Priority on simplicity in design, ensuring fast loading and security. Need existing products migrated to the new version seamlessly. Requirements: Malware removal & security enhancement Simple, elegant design Optimize for speed Seamless product migration WordPress expertise Timeline & Budget: Please propose timeline and budget. Previous WordPress experience required. If you're ready to tackle this project efficiently and deliver a sleek, secure WordPress webshop, send your proposal with relevant experience. Let's revamp this shop together!

As a business user, I need assistance with the configuration of SSRS Reporting Service on a staging environment. I have configured the WebPortal using Report Server Configuration manager and I am able to run SSRS reports from the Web UI. The project requires the following: 1. Automatically Scheduling of SSRS reports with default parameters. 2. Exporting the outcome of SSRS reports in a given folder every time a scheduled report runs I am experiencing the following issue while scheduling: Error: The SQL Agent service is not running. This operation requires the SQL Agent Service. You will need to help get rid of this error and set up scheduling and exporting of reports as mentioned. You will be required to get on a video call and help me set up the a...

I'm looking for an expert in Ionic framework to upgrade all node modules in my app to their latest versions. I am not certain what the current Ionic version is so I need someone experienced in identifying and working with all versions. Here's what I need: - Identification of the current Ionic version - Node modules upgraded to the latest versions - Ensure the app is fully functional post-upgrade Ideally, you will have: - Extensive experience with Ionic frameworks - A detailed understanding and experience working with node modules - Strong problem-solving skills Please include your past work and a detailed proposal to be considered for this contract.

I will fix the bug for his website and change the banner.

Hi Mohammad, You did for me a Realestate site (https://www.freelancer.com/projects/php/Website-for-selling-properties/reviews) some time ago. May we chat for a new project? I would need: - Exactly the same structure, but with some new content and for another domain. - Fix the old site, as after a server migration it does not work anymore.

... we're seeking a talented freelancer who can design an effective Power BI Dashboard to integrate various data sources including Excel spreadsheets, CSV files, and SQL databases. The ideal freelancer would: - Have extensive experience with Power BI and DAX language integration. - Demonstrate an excellent grasp of designing dashboards that report on KPIs. - Be well-versed with creating DAX calculations in the Power BI environment. We require the dashboard to focus on specific metrics, therefore, a strong understanding of reporting on KPIs using DAX language is a must. Additional Skills: - Proficient in Microsoft Excel and SQL databases. - Understanding of data integration and reporting. - High attention to detail. We're excited to collaborate with a dedicate...

I am urgently looking for a professional with experience in troubleshooting and fixing Wordpress website issues. The search function is not working for our client's therapy website. The search function isn’t working properly services and specialties - it’s bringing up wellness and other posts but not all the ones that include the term being searched. So searching “anxiety” brings up posts like hypnotherapy for anxiety but does not show the main anxiety page. Same with searching CBT. When the search function is used we want it to show all posts and pages that are relevant to the searched term.

...issue is with my navigation menu, it's non-responsive and this presents a significant user experience problem. - Specific Problem: The problem lies with the menu items. When these are clicked, they fail to respond appropriately which affects the usability of the website. - Need: The project thus requires an expert in web development, especially in areas of JavaScript and HTML, to troubleshoot and fix this unresponsiveness. - Skills Required: I'm especially looking for somebody proficient in website development and debugging, with a deep understanding of navigation elements and menu functionality. The chosen freelancer for this job should have demonstrable experience with similar projects and the ability to solve this problem promptly. Your knowledge in browser compat...

Update Wordpress Child theme to work with latest version of X-Pro theme and PHP 8.2 First I would like you to estimate the work using the WPEngine credentials I supplied. Environment is: volleyball2stg From the ticket: I have tried again to update the staging site with the latest copy of the production and update the plugins and theme as well as the PHP version and here is the result. Updating the Pro theme have broken the existing layout of the pages and will need an overhaul of the child theme to match the new parent theme version when it comes to the structure. Updating the PHP version to 8.2 have generated and error on the WooCommerce collapsing categories pro plugin. I am not sure if this plugin is still maintained for the only review that it h...

I need someone expert in restoring a SUITE CRM (SugarCRM) system precedent installed on a different domain. i have done backup of files and db but expanding on new domain it give an error (maybe many files to configure or something else to do i don't know. Al system is under plesk so i give a plesk customer containing files zipped and db zipped

First task is below 1) 1200 Youtube video link of recipes will be provided in google spreadsheet. for e.g each link with be 2) the person ne...video link of recipes will be provided in google spreadsheet. for e.g each link with be 2) the person need to paste the link at 3) Cut and paste 3 windows record and 1 recipe image screenshot (from youtube) and then upload in a software ( a paid version will be provided) 4) expect to finish 1200 recipes in 60-100 hours. Please quote following if you want to try this project 1) how much for updating 1200 recipes as whole project? 2) How much is per hr rate?

I need a Power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: - Retrieve Product ID, Quantity and Location. - Gather Specific Production Data including t...number. Ideal Skills: - Proficient in DAX query language - Comprehensive experience with Power BI - Excellent attention to detail - Previous experience in inventory data management will be a plus What to do: I need to get a query in DAX (Power BI) that gives me the same result as what I show in the excel file ( table (column in yellow)). The Excel file was obtained from the attached SQL query ( ) The two screenshots show the Power BI tables. I need to get a new column in Power BI that shows me the results like in the yellow column in Excel.

I'm currently in need of a skilled professional versed in CSS3, HTML5, PHP, and MYSQL. My primary requirement consists of creating minimalist and clean CSS styles for specific pages, namely the products page, product view, and checkout page. In addition to this, there will be some light PHP work involved. The ideal candidate should have demonstrable experience in these areas and a good eye for clean and minimalist design. Efficiency and attention to detail are key.

...customization and optimization - Strong understanding of Gitlab - version control !* - Strong understanding of web development principles and best practices - Ability to work on a large-scale project and deliver high-quality results - Excellent problem-solving skills and attention to detail - Database Design & Management: The ability to design and manage a highly organized, efficient database is crucial. - API Integration: We expect the team to integrate various APIs appropriately for a seamless integration of different platforms !!!*** Skills that would be beneficial: - Thorough Laravel expertise - Proven track record in creating reporting and analytics solutions !!!*** - Understanding of API integrations !!!*** - Understanding of Git version control - Proven track r...

NO NEGOCIATION PRICE - NO NEW FREELANCERS I need a small billboard picture to be upscaled to a larger version, to fit a billboard less than 6 meters wide. The primary use of this image will be for outdoor advertising. Key responsibilities: - Upscale the small picture to a size suitable for a billboard - Maintain the image quality and resolution during the upscaling process - Ensure the image is suitable for outdoor advertising - Deliver the final image in the appropriate format Skills and expertise required: - Experience with image upscaling and editing for large-scale prints - Understanding of color, resolution, and image quality in print materials - Knowledge of outdoor advertising specifications - Attention to detail and an eye for design. Please provide examples of similar...

I'm in need of a developer who can compile a Windows Exe file for the Real-ESRGAN GitHub project. The Exe file should operate on CPU, and accept command-line. Currently, the GitHub project offers only a GPU exe file, hence the need for a CPU version. GitHub link for Real-ESRGAN:

...rebuild it entirely from the ground up while retaining its core functionalities. Project Overview: We are seeking to develop a modern web application using cutting-edge technologies: - Frontend: React.js for dynamic and responsive user interfaces. - Backend: Laravel for robust and scalable server-side logic and API development. To begin, we can provide you with access to a working instance of the current application, which you can run locally using XAMPP or WAMPP. Please ensure that PHP version 5.6 is installed to ensure compatibility and functionality. If you are interested in this exciting project and would like to discuss further details, including access to the existing application and specific requirements, please let us know. Thank you for considerin...

...for the Snipepay Payment Plugin: WooCommerce Integration: Develop a payment plugin to integrate Snipepay into WooCommerce, allowing users to choose Snipepay along with existing options like PayPal and GoUrl for payments. Deliverables: A fully functional WordPress plugin for hosting management. A Snipepay payment gateway plugin for WooCommerce. Skills Required: Proficient in PHP, JavaScript, and SQL. Experience with WordPress and WooCommerce plugin development. Strong understanding of RESTful API integration. Knowledge in payment gateway integration, specifically Snipepay, PayPal, and GoUrl. Excellent problem-solving skills and attention to detail. Project Timeline: Please provide an estimated timeline for completion with your bid. Budget: Your bid should include the total cos...

Please Sign Up or Login to see details.

Hi Yasar W., I noticed you posted a following project ( https://www.freelancer.com/projects/sql/SQL-Expert-Needed-for-Data/details )

I'm in need of a custom SCCM report that's focused on software inventory. Key Details: - The report should specifically list all the software installed on the devices. Only installed software, not the default software installed by the operating system. - I only need a list of the installed software, without any additional usage statistics or version/license information. - It's essential that the report is filtered by operating system (Windows, macOS), as I need to have insights specific to these platforms. This is a crucial piece for our system management. The ideal freelancer for this project should have: - Deep knowledge of SCCM and experience in creating custom reports. - Solid understanding of software inventory and how it can be effectively reported. - Ability ...

Hi Muhammad A., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I need an expert to migrate my products from an Excel file to my WooCommerce store. Key Requirements: - Migrate products from an Excel file to WooCommerce - Use attributes to define variations within a single product - Update existing product descriptions during the migration Ideal Skills and Experience: - Strong experience with WooCommerce and product migration - Pro...- Update existing product descriptions during the migration Ideal Skills and Experience: - Strong experience with WooCommerce and product migration - Proficiency in handling product variations using attributes - Attention to detail for updating and modifying product descriptions - Excellent knowledge of data import/export and product management on WooCommerce. - Ability to ensure a smooth and error-free migratio...

...professional experience, skills, and achievements. The ideal candidate will have a keen eye for detail, excellent writing skills, and a strong understanding of various industries and job markets. Requirements: -Proven experience as a resume writer or similar role, with a portfolio of successfully crafted resumes. -Excellent written communication skills and a strong command of grammar, punctuation, and syntax. -Proficiency in Microsoft Word or other word processing software for resume creation and formatting. -Knowledge of ATS principles and strategies for optimizing resumes for keyword relevance. -Ability to conduct thorough consultations and effectively communicate with clients to understand their needs and preferences. -Attention to detail and a commitment to delivering high-...

I'm facing an error that says "Call to undefined method Url::forceScheme()" in Laravel. This error occurs when I attempt to log in, showing the message "Error: Login failed". Key Requirements: - Resolve 'Call to undefined method Url::forceScheme()' error - Ensure successful login functionality Ideal Skills: - Proficiency in Laravel framework - In-depth understanding of Laravel authentication methods - Experience in troubleshooting Laravel errors - Strong problem-solving skills to identify and fix the root cause of the issue

We have an existing PHP/QuickBooks Online application designed to sync QuickBooks invoices to a MySQL database. The application works correctly when executed but we have an issue where the security token needs to be refreshed manually every 24 hours. We need to devise a way for this application to run with no requirement for refreshing the token manually. The program syncs orders in real-time so manual token refresh is not an acceptable way to do this. A developer is required with experience working with QBO applications and working with the QBO token refresh system so this refresh is done automatically.

...tables. The script should be optimized to avoid system slowdowns and long processing times. Script to Parse Product XML Files: The second script. This script will run continuously and parse XML product files located in a specified folder and its subfolders. Mapping of data: Correct mapping between products and relevant categories will be established using XML data and existing PrestaShop MySQL tables. As we have large amount of products and the feature data. We dont want the filter to read all the data while loading. for example TV category filter should only load and read filter data where products belongs to TV categoeiry. This will speed up filter load. Adding Filter Button for Mobile Display: This task involves modifying the mobile layout to include a filter ...

I need a script to automate server updates. It should be able to handle operating system updates, software updates, and security patches. Key Requirements: - The script should be able to automate server updates - It needs to handle operating system updates, software updates, and security patches Ideal Skills: - Proficiency in scripting languages - Experience with server management and updates - Understanding of cybersecurity and best practices - Strong problem-solving skills and attention to detail.

...to greatly enhance our landing page and web application, with a deadline of this very day. I'm eager to find someone who can: - Update our landing page's layout: I want our page to be sleek, modern, and easy to navigate. - Add fresh, engaging content to our landing page: The new contents need to be captivating, relevant to our services, and add value to our website. - Implement new features and fix prevailing bugs in our web app: I want our web application to be free of errors and add new functions that make it more user-friendly and efficient. The main goal of the landing page and the web app updates is to cater to 'software customizing’. I'm striving to make the entire user experience on both platforms smooth and seamless. Efficiency, speed, and an e...

I'm in search of an experienced translator to convert my novel from French to English. The book is over 100,000 words long, and I would like this task completed within a month....French and English, with a strong grasp of the nuances and subtleties of both languages. - Have previous experience translating novels, with a focus on literary translation. - Be able to work within a strict time frame without compromising the quality of the translation. It's crucial that the translator can convey the emotions, tone, and style of the original work accurately in the translated version. I'm looking for someone who is not only linguistically skilled but also has a passion for literature and storytelling. A sample of previous translation work would be greatly appreciated during...

My Android app isn't displaying AdMob a...Android app isn't displaying AdMob ads despite using the latest SDK and ensuring compliance with AdMob policies. Key Points: - The app is built for Android, and I am using the latest version of the AdMob SDK. - I have also checked my AdMob account, and there are no policy violations or restrictions. I need a skilled developer to troubleshoot and fix the issue. You should have experience in AdMob integration, be familiar with the latest SDK features, and be able to identify and resolve any potential obstacles that might be preventing the ads from appearing. Your task will be to identify the root cause, and provide a fix that ensures the ads are correctly displayed in the app. Please provide a brief overview of your ...

You must work through anydesk I have mandrill transaction email. you must help me set it up in my laravel and make emails send. Also fix laravel default reset password function. Must work through anydesk

I'm in need of a Coppeliasim expert who can support me in creating and simulating robotic arms models in Coppeliasim. The professional should be able to write control code for the robot, and also troubleshoot and fix any simulation errors that may arise. The key responsibilities for this project are: - Develop and simulate robotic arms models in Coppeliasim - Proficient in programming languages required for the task, particularly Python and lua - Write efficient control code for the robotic arms - Identify, troubleshoot, and fix any simulation errors that may arise Ideal candidates should have: - Proven experience in working with Coppeliasim - Proficiency in Python and lua - Strong understanding of robotic arms and their control mechanisms - Ability to troubleshoot an...

I'm seeking a highly skilled system administrator capable of installing CloudLinux with LVE and cPanel support on my server. - Purpose: The key goal behind this project is to optimize resource allocation for my server. I intend to host multiple websites on this server, making resource optimization crucial to seamless performance. - Websites: The server will host a diverse range of websites including e-commerce, blogging, and corporate websites. - Volume: The server should comfortably accommodate between 10 to 50 websites simultaneously. The ideal candidate for this project should have strong CloudLinux and cPanel working knowledge. An in-depth understanding of server management, specifically for resource management in high-traffic env...

...Starter. This project involves: - Moving over 12,000 Accounts and Opportunties - Several custom fields need to be replicated in Opportunties - Total of three users - Migrate Notes, Reports, and Attachments This process demands careful handling of data to ensure smooth transition with no data loss. The data currently exists in the Salesforce Classic version. Experience with Salesforce Classic and the newer Lightning Starter version is necessary. Perks for the job: - Salesforce certification or proven experience in Salesforce data migration - Familiarity with data sets (10,000+ records) - Ability to mitigate risks involved in data migration and ensure full data integrity - Good problem-solving skills and a keen attention to details Bidders without significant exp...

I'm in need of a skilled content writer with specialization in technology. Your role will be to create engaging blog posts ranging from 500 to 1000 words each that thoroughly explore tech topics. Key Responsibilities: - you have to re write content - redablity and error should come grean in eyost plugin test . - price should be for 5 Article My preffered is 250 for per 5 blog , 600 for 12 Blog Skills Desired: - Strong understanding and interest in technology. - Experience writing technology-focused blog posts. - Excellent research and writing skills. - Ability to consistently meet deadlines. If you meet these requirements and have a passion for technology and writing, I’d love to hear from you! This project could be your chance to share your tech expertise with a ...

...database backend, namely (but not exclusively), data inconsistency and significant performance issues. • Data Inconsistency: There's a rampant issue of missing and incorrect data circulating within the system. This issue impacts the integrity of the entire project and lowers its efficiency. I am seeking a professional who can help identify the source of the inconsistency and implement a permanent fix. • Performance Issues: I am dealing with certain performance issues, specifically very long database queries. Additionally, the task reassignment isn't functioning as it should, and data entry is also compromised. Ideally, I'm looking to enlist the services of a professional who possesses a strong background in database management and Spring Boot. Proficie...

...database backend, namely (but not exclusively), data inconsistency and significant performance issues. • Data Inconsistency: There's a rampant issue of missing and incorrect data circulating within the system. This issue impacts the integrity of the entire project and lowers its efficiency. I am seeking a professional who can help identify the source of the inconsistency and implement a permanent fix. • Performance Issues: I am dealing with certain performance issues, specifically very long database queries. Additionally, the task reassignment isn't functioning as it should, and data entry is also compromised. Ideally, I'm looking to enlist the services of a professional who possesses a strong background in database management and Spring Boot. Proficie...

I am currently facing an issue with the packaging of my Streamlit app, specifically error messages related to dependencies. My app does RAG or Retrieval Augmented Generation. However, I am stuck with this bug. Any freelancer planning to undertake this project should be: - Skilled in Python programming - Familiar with Packaging methodologies like PyInstaller, PyIodide, Stlite - Experienced in debugging dependency issues The main tasks will include: - Understand existing errors in the packaging process - Debug the dependency-related issues - Ensure the final version of the packaged app works seamlessly with no errors in multiple hosts I invite freelancers with prior experience in handling similar tasks to place their bids. This project has the potential for future maintena...

I am experiencing a problematic error with my Excel sheet. An error message keeps popping up and the sheet becomes protected every time I enter a price. Ideally, instead of locking the entire sheet, only specific columns should be locked when a password is triggered by clicking a button. Key issues: - Error message arising upon entering a price - Automatic sheet protection following action Work Required: - Identify and fix the error triggering the message pop-up - Adjust VBA codes to lock specific columns upon password entry: - Columns A to L - Columns Y, Z to AK - Columns CW to DH - Columns DO to DS - Columns DT, DV, DX, DZ, EB, ED For this task, I need a freelancer proficient in VBA and Excel, specifically with experience with sheet prote...

My website has an error 500, I got this “fixed” with the help from someone from Fiverr, however lots of important plugins were deactivated unnecessarily, so I used a backup to take it from when it was working fine. Even though the back up should have taken my website to when it worked ok, the error 500 persists, I need a hand fixing that to have my website intact, and improving the site speed overall.

...from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and have to do some sql sql command to change the Admin name , Instance name -- now i do manually 7. env file need to be updated 50% mile stone will be created at the time of awarding the project, All payment will be released as soon as satisfied with your work and fit to my requirements. If you are interested, please send me a message so that we can discuss... Thanks...

I am seeking a knowledgeable AWS specialist to provide server support including the maintenance of an Application Load Balancer. The project also uses Git CD/CI, and support on GIt is required as well. Ideal freelancer skills and experience: - Deep knowledge of AWS services, particularly EC2 and RDS - Experience in setting up and managing Application Load Balancer - Familiarity with Git & CD/CI To make a successful application, please include: - Details of past work experience particularly related to AWS EC2, RDS and load balancer configurations. Looking forward to your applications.

I'm seeking a professional with deep experience in MySQL and Linux OS to carry out an installation. * Desired Proficiency and Experience: - Linux Operating System: You need to be familiar with Linux as the installation has to happen on this platform. - MySQl 5.7: The installation is specifically for MySQL 5.7 and you should have experience with this exact version. * Task Overview: - Install MySQL 5.7 on my Linux machine following the Development Machine Settings. * Configuration: - MySQL should be configured to run optimally on a development machine setting. - Your skills should extend to understanding the unique configuration needs of a development system and apply those effectively. Looking forward to your bids, please fee...

A...several separate issues that need resolving. Here's what's happening: - Cron jobs on my site are not running as they should. - I'm facing errors with cURL 7. - The REST API is malfunctioning. I'm seeking a professional WordPress developer who can tackle these problems. Given these are separate issues, a deep understanding of all three areas (cron jobs, cURL 7, and REST API) is crucial. ****** FIX THE ISSUE USING ANYDESK IS MANDATORY ******* By the end of this project, I expect: - Cron jobs working to schedule flawlessly. - cURL 7 operating without any errors. - The REST API functioning correctly. The task requires working via AnyDesk Remote Desktop, so experience with remote troubleshooting is necessary. Please only apply if you're comfort...

I'm seeking a skilled illustrator to help me craft a children's book centered around the theme of friendship. The target audience for this book is children aged 0-10. The illustrations should be in a fun and engaging cartoon style. Key Requirements: - Exper...balance creativity with the specific needs of a children's book, ensuring that the illustrations are not only visually appealing but also support the narrative and engage young readers. I have a children's book. I have the content ready. I want you to create the book for me including illustrations. Below is the list of things I am looking for: 1. Ebook verion, ready to publish 2. Print friendly version, ready to publish. 3. Copyright/Disclaimer Page 4. Blurb Writing 5. Author Profile Editing 6. Barcode...

I'm looking for a developer who's proficient in C#, MS SQL Server, Dot Net, and XAMARIN to work on an already existing application. Need to improvise and add amend few things. Pls note we can pay maximum INR 4,000 for the work.

I require an expert in Asterisk and FreeSWITCH development, along with experienced system engineering skills. Specifically, I need help with: - Asterisk and FreeSWITCH development - Integrating VoIP - Setting up Call routing and IVR (Interactive Voi...system engineering skills. Specifically, I need help with: - Asterisk and FreeSWITCH development - Integrating VoIP - Setting up Call routing and IVR (Interactive Voice Response) - CTI - Skill group base call routing to agents. Apart from these, the implementation of Asterisk and FreeSWITCH clustering as well as Call Center Reporting is required. The technology stack should be Linux, PHP, MySQL along with postgresql and API knowledge. The freelancer should have considerable experience in these to meet the project's specifi...

I am seeking an experienced Dynamics CRM 365 developer with Virtual Entity expirence. I have got few virtual entity tables link to Azure SQL database. One table has got 1:M relationship with another. In my form, I am trying to populate custom view in lookup field of this virtual entity lookup. I tried it in two different ways but it doesn't work. Method 1: I created fetchXML and link two tables, I get the result but issue is records don't filter in query. I tried this method with advance find as well, and again records don't filter according to criteria for virtual entity. in Advance find, if I try to select the columns from second table then I get error. Methos 2: I tried to create Fetch XML query and use addCustomView method. This method works if filter...