1064 error sql syntaxJobb

Hej Amr S., jag la märke till din profil och skulle vilja erbjuda dig mitt projekt. Vi kan diskutera detaljerna över chatten.

Till en nygrundade företag inom social entrepreneurship behövs det skaffas en SQL databas samt back-end mask till data query och entry, och en mindre front-end sökmask. Detailerad lista på databas-råder och egenskaper såväl som mockups på aller masker finns. Webspace med möjlighet till SQL databas finns. Detta är prototyp-stadien till en större projekt och rätt programmerare kan blir anlitad även till vidare arbeten med databasen, back- och front-end maskarna, samt senare utveckling av sökmask i app-form och enkelt web-shop kopplad till databasen.

Jag behöver en databas (SQL script) som håller reda på Medlemmar och dess Vänner, samt Kontakt/Meddelanden som skickas mellan dem: - Medlemmar (Namn, Mail, Lösen, Mobilnr., inloggningssätt (Facebook, Google, ösen)) - Medlemmars olika relationer till Vänner (mobilnr., mail, namn, adress) - Tabell över kontakter/meddelanden som tagits med Vänner (GUID skapas för varje gång). - Möjligheter för Vänner att logga in med hjälp av GUID för att se meddelanden - Meddelande skall kopplas mellan Medlem och Vänner. - Medlemmarna skall kunna ha en elektronisk plånbok

Project 1av 2(sql fler fields) skickar den andra projektet under dagen Har ändrat pattern1&pattern2 columnerna i databasen till kundnr&country, id till uid, verkar fungera. Sedan har jag ändrat field1&2 till flera columner i results.html. Så här ser columerna ut i databasen. id, kundnr, country, searchstring, tiff, checked, vat_number, company_name, company_adress, invoice_date, invoice_nr, valuta, summa_netto, summa_moms, varukod, varu_underkod, sprak_kod, beskrivning, fakturatyp, skattenummer

Mac PHP Har byggt en första version av en sajt som låter användare logga in och ange/ladda upp data. PHP/Mysql är använt idag. Skulle i dagsläget behöva primärt ett bollplank kring databasstruktur och koden principiellt men även hjälp med faktisk programmering för vidareutveckling av tjänsten. säkerhetsaspekter är också viktiga i nuläget

Söker back end utvecklare med erfarenhet från skräddaranpassade CMS hemsidor. Du bör vara kunnig inom PHP, Web 2.0, XHTML, SQL, Cross-browser optimering. Utvecklingen av hemsidan bör göras med stor anpassning. Då majoriteten av publiceringen görs av redaktörer måste backend vara anpassad för exempelvis skapande av artiklar. Du kan utgå från ett open-source alternativ och vidareutveckla den enligt våra specifikationer. Integrering mellan hemsidan och databas måste göras av dig. Analytics program erfordras. Interaktion görs möjligt med commenting, threads och forum. Erfarenhet från schemaläggning av aktiviteter bör du kunna göra. Caching även. Säke...

Programmering av ett Iphone och Android telefonapplikation kopplat mot telefonväxel MS SQL och winows server. Funktion och design ingår. Erfarenhet av applikation som contact center, callcenter. Samtalsstryning och design. Lång erfarenhet och stor förståelse krävs.

Programmering av ett Iphone och Android telefonapplikation kopplat mot telefonväxel MS SQL och winows server. Funktion och design ingår. Erfarenhet av applikation som contact center, callcenter. Samtalsstryning och design. Lång erfarenhet och stor förståelse krävs.

...är sakerna vi först behöver rätta till, det är betydligt fler men dessa är akuta. Mood company () sells ready-made and custommade party products to companies and individuals. We can deliver small or large orders quickly and efficiently. The platform used is Magento. What I need help with immediately are: -to make an order for a customer does not work … they get a error message as the attached file. We can not receive orders normally over the website -the customer don’t get any confirmation email neither do we -we sell both to companies and individuals and it must be clear that the prizes are excluding VAT and then what the price including VAT is also (25% on all our products is the VAT in Sweden) - The cart and the chec...

Fix opencart 1.5.6.1 small error

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...

As the developer of an existing project written in Python, SQL Server, and MongoDB, I am currently facing a challenge. A logical error in the code is causing a bug, and I need an expert to fix it. High-level summary of the code- 1. Fetch records from SQL server ( total 680000 records) 2. Apply face recognition on each record 3. Insert the response from step 2 in MongoDB along with other data from the SQL server Issue- The existing code is currently doing steps 1 & 2 and performing step 3 at last when face recognition is applied on all records. Due to this it step 3 is waiting to complete the step 1 & 2. Expectation- After fetching each record from SQL server, the code should apply face recognition and then store the data in MongoDB immediately....

...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...

...ETL tools. * Experience in SQL Server, T-SQL, and SSIS Job Responsibilities: Data Extraction: * Extract data from various source systems, including flat files, spreadsheets, legacy databases, and external APIs. * Develop and optimize SQL queries and scripts for efficient data retrieval. Data Transformation: * Perform data cleansing, validation, and transformation to ensure data quality. * Convert data from source formats to Oracle-compatible formats. * Apply business rules and data mapping for aligning source data with target data structures. ETL Development: * Develop and maintain ETL (Extract, Transform, Load) processes using standard tools. * Handle data integration tasks, including aggregation, enrichment, and consolidation. Error Handling: * Implement ...

...need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in ...

...need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in ...

I'm looking to upgrade my current system, perhaps keeping the current Opencart (V1.52) system and working with it where possible... unless its deemed a rebuild is cost effective. The opencart system we use has been added and modified over time, hence it is not possible to simply upgrade to a newer opencart v...  4. Any other 3rd party systems (including internally) that the website communicates with (sending data either way) and any data grabs.    NO 5. Confirmation of payment gateways used. Realex (redirect to payment interface), PayPal   6. How the databases (products, customers, orders) are stored and if the data can be exported. Standard OC table structure… yes it can be exported as SQL data dump and all the products to stock link via the export featur...

I'm facing issues with the websockets implementation in Kite Zerodha, where the connection frequently drops. It shows closing handshake error. And sometimes it does not give me quotes and sometimes it does. Please refer to my python file. This problem is specific to zerodha api websockets.

I'm here because I recently migrated my website to AWS and I'm now encountering some issues. My WordPress website, currently on version 5.4, is presenting a 404 error and deprecated warnings. Sadly, I do not have access to the original server the site was hosted on before migration, and I'm unable to specifically point out if any plugins or themes may be causing these warnings. This project requires a skillful WordPress expert who is familiar with: 1. AWS migration 2. Troubleshooting for WordPress version 5.4 3. Identifying and resolving 404 errors and deprecated warnings 4. Investigating possible plugins or themes issues Ideal candidates should have proven experience in troubleshooting WordPress issues, specifically in a post-migration context. AWS proficiency is ...

Need help with a simple task that involves writing simple SQL statements and completion of the relevant ER diagrams. This task is in the context of simple data analysis. To be completed within 2-3 days.

I have a running Python file, who parse data from xml and insert it into sql server. Currently it isnt working. need an expert in python, who can fix it and upgrade few things as well.

I'm in urgent need of skilled professionals with experience in MySQL and Digital Ocean recovery console. My MySQL server is locked and I require assistance in exporting a SQL file. The exact cause of the server lock is not currently known but it might be due to server resource overload or a potential security breach. Required Skills: - MySQL - Knowledge of Digital Ocean's recovery console - Server management The main objective of the task is: - Successfully export the locked SQL file for further analysis and resolution - Provide insights on the potential cause of the server lock for future prevention. Experience in server management, specifically in handling locked servers, will be a great plus. Thanks.

I am seeking a skilled database developer to convert my .frm and .idb files into a SQL file. The original files are in MySQL format. Key tasks will include: - Conversion of .frm and .idb files to SQL format. - Exporting these converted files to mysql server. I did not specify any special properties or features of the .frm and .idb files that need to be preserved, but will appreciate a careful and diligent conversion to ensure no data loss. The ideal candidate for this job would have: - Extensive experience with MySQL 5.7. - Proficiency in SQL file conversion. - Strong knowledge of database export practices. - Keen attention to detail to ensure data integrity.

I'm currently having a problem with nodemailer sending email via Gmail using OAuth2. Attached is my test script. I have checked every setting possible to check, but still get the error below. Can you fix this for me? The error is (even though I use OAuth2 and not password): "535-5.7.8 Username and Password not accepted."

...calculate the hourly rate and the time needed to complete different task documents, on an agreed fixed price. The best offers with the right experience will have the opportunity to work with us on a long-term basis. Also, Good prospects for the right developers, based on the performances evaluated over a period of time, once you established your skills. Need to provide the changed code details and sql queries if any at the end of each sub-task, with the changed code line numbers. Unlimited Revisions are needed. Any bugs created due to your own developments are to be fixed on free of Charge. Recruitment is for a long-term big project as such, all the developers are subject to practical skill test for which not paid. Please send your details for the below-mentioned questions....

Currently, we're in need of a specialist to come in and assist us with some unspecified issues plaguing our website. Our ideal candidate is a freelancer with a strong background in both front and backend development. Key Requirements: - Carryout a comprehensive audit to identify and understand issues - Fix identified issues that maybe causing broken links or error messages - Ensure optimal website performance While we appreciate freelancers with examples of past work and effective project proposals, what's most important to us is your experience. More specifically, we are seeking someone with notable experience in database optimization. This will be vital to ensuring our website runs efficiently and effectively. If you meet these qualifications, we'd love to hea...

...plugin should replicate the functionality of the Shopify code editor, offering Syntax Highlighting, Auto Complete, Error Detection, and supporting both HTML/CSS and PHP languages (PHP support is optional). The plugin is intended to be a standalone component, not embedded or replacing any existing editor. the editor should include a file search (to search through templates) - similar to shopify but as well as searching filenems it shoudl also search in contents The editor shoudl work with a master theme/child theme style system such that when a template is modified its auto-copied to the child theme Key requirements: - Develop a code editor plugin similar to Shopify's - Implement Syntax Highlighting, Auto Complete, Error Detection - Support both HTML/C...

Vänligen Vänligen Registrera dig eller Logga in för att se mer information.

...dynamics to ensure our content stays relevant. - Translating complex jargon into clear, easy-to-read language that our clients can connect with. Ideal skills and experience: - Proven experience in writing high-quality content for websites. - Excellent research and editing skills. - Familiarity with the corporate law, registration, and incorporation sector. - Ability to deliver well-structured and error-free content on time. - Strong grasp of English language and grammar. The ideal candidate has an extensive background in writing about the following: - Incorporation of Sole Proprietorship, Partnership, and Company Startups - Registration of GST, MSME, DPIIT Recognition - Annual Compliance MGT 7, MGT 14 submission - Additional Services such as ISO Certification, Insurance, HR ...

...table. This will make it easier for me to work with the data in Excel. - Error Detection: It's important to me that the tool can automatically detect and correct errors in the text. Nevertheless, I also want to have the ability to manually review and correct the text to ensure its accuracy. - Language: In this case, the tool only needs to handle English language texts. You don't need to worry about incorporating multi-language support. Ideal Skills and Experience: - Proficiency in PDF extraction and conversion tools - Strong knowledge of Excel and text formatting - Experience in developing error detection and correction features - Attention to detail for accurate text conversion - Fluent in the English language for error-free translation. Attached PDF ...

I need a ...time, drop off location - Every day 3 buses are departing to airport. Say morning 8am, 1pm and 8pm. We need to get auto emails based on this bus timings of scheduled pax list and they take manually report with date/time filter. Ideal Skills: - Strong background in web application development - Experience in booking system or related is a huge plus - Fluency in database management, preferably SQL - Proficiency in PHP or a similar back-end programming language - Strategic problem-solving skills and attention to detail The success of this project requires not just technical expertise, but also a clear understanding of travel agency operations and the importance of efficient booking management. If you have relevant experience and the right skill set, I look forward to...

We're in need of an advanced Python programmer well-versed in creating PDF reports from MYSQL and InfluxDB, capable of not only capturing numerical data but transforming it into Graphical Trends and Text-Based Analysis. Key Role: * Develop logics for data interpretation and representation * Create a Professional and Formal UI/UX design for the report generator * Deliver finalized, error-free reports Ideal Experience: * Python expertise * In-depth knowledge of MYSQL and InfluxDB * Proven experience in creating dynamic PDF reports * A keen eye for formal and professional UI/UX design * Strong abilities in abstract reasoning and complex logic writing. Your role will translate our complex database information into understandable, well-structured and professional-looking report...

Hello Freelancers, I have successfully installed PowerMTA for IPv6, and the setup was completed without encountering any errors. However, when testing emails using the Gmass SMTP tester, I encountered an error stating "ERROR: Invalid URI: Invalid port specified." I suspect that this issue may be related to the configuration file and possibly the network settings as well. I am attaching my configuration file for analysis.

...Python 3 code for our JFrog Artifactory setup. It currently handles the basic tasks of downloading, uploading, and moving our libraries, but unfortunately, it leaves quite a bit to be desired in swift performance, overall stability, and error handling. Here's what I am ideally anticipating: - Speed up Performance: We need our code to execute operations at a faster clip. - Enhance Stability: The code needs to run reliably without crashing or running into instability issues. - Improved Error Handling: The implementation of stronger, more effective error handling is a must to solve unexpected incidents. Your proficiency in Python, especially Python 3, is crucial, and prior experience in tweaking JFrog Artifactory is going to be billed as a huge plus. Your...

I'm currently in need of an experienced full stack developer who is proficient in both JavaScript and PHP. Key requirements: - Strong skills in front-end development, specifically using JavaScript. - Proven experience in handling backend development with PHP. - Knowledge of SQL is also important. - While not a strict requirement, familiarity with JavaScript frameworks such as React, Angular, or Vue and PHP frameworks like Laravel or CodeIgniter would be a big plus. - Experience with SSL implementation is a must, but there are no strict preferences as to the type of SSL to be used (Wildcard or EV SSL). Being able to pick the right SSL depending on the project’s needs will be part of your responsibility. If you're the kind of developer who is adept at managing the f...

I am facing a recurring issue where PrivateGPT, which used to run smoothly on Ubuntu 22.04.4 LTS on Windows 11, is now crashing repeatedly. This problem began after a series of file ingestions and proves persistent as it happens every time I now attempt to start up the software. Specifically, a Runtime Error is delivered, preventing the program from carrying on. I am looking for a freelancer with: - Exceptional problem-solving skills - Extensive experience with Ubuntu and Windows 11 - Advanced understanding of PrivateGPT In your application, I am particularly interested in your past experiences related to diagnosing and repairing similar technical issues. Looking forward to your assistance in resolving this issue. Thank you.

We manufacture shade sails which may be 3, 4, 5 or 6 sided shapes, mounted on poles of varying height. These are difficult to measure accurately so we need a measurement verification program where we can input the perimeter measurements of the shape, the pole heights and the diagonals. The program needs to mathematically check the entered measurements and indicate the % of error and which measurement(S) are most likely incorrect. There are two parts to the project: 1. A JavaScript or similar program created to run in an ecommerce website which has a product configurator interface which will be used to input the measurements. The interface will be built by another supplier. 2. A stand-alone app able to run on Android, iOS and Windows PC. ADDITIONAL INFO The minimum meas...

I'm in search of a MATLAB expert with a strong background in control engineering. Your main task will be debugging my current model predictive control code. Requirements: - Proven experience in MATLAB, especially in the context of control engineering. - Expertise in debugging code, particularly in fixing the issues related to code running and error messages. - Ability to work independently and efficiently. Your proposal should include: - Relevant past work in MATLAB, particularly in control engineering. - Details on how you usually debug code and your approach to dealing with issues. - Your understanding of model predictive control and examples from your past work that demonstrate this. Your application will be a key part of my decision-making process.

I am in need of a skilled MATLAB developer with a background in control engineering or related fields. The project involves debugging my existing code on model predictive control. Key Responsibilities: - Collaborate with me using a collaborative coding platform to resolve the error messages and incorrect results in the code. - Ensure the code provides accurate predictions as expected. Ideal Freelancer: - Proficient in MATLAB with a strong understanding of model predictive control. - Experience with debugging complex mathematical algorithms. - Strong communication skills and a willingness to collaborate through a shared coding platform.

...time a change is detected. Freelancers with experience in creating similar systems or possessing a deep understanding of the workings of Windows OS will be preferred. Additional Details: Monitor Regedit for the changes related to the policies applied through Service. Send notification to server, send mail to a group, in case of change not applied through Service. 7. Logs needs to be updated to SQL via a API POST call (this endpoint is developed you need to call this Only) and keep a backup at local database. POST JSON - { "Username": "", "MachineName": "ABC", "Timestamp": "", "appliedPolicies": [ { "Policy1": "0", "Policy2": "2" } ], "removedPolicies": [ { ...

I'm currently experiencing functionality issues with my PDF plugin where I'm confronting this odd error: "file origin does not match viewer's". This is not just associated with a single file but multiple PDFs are demonstrating the same behavior. For this project, I need an expert who can: - Identify and rectify the source of these unexpected PDF plugin errors - Ensure a smooth and correct functionality of the PDF viewer Your expertise should include proficiency in handling PDF/plugin issues and a deep understanding of similar software issues. Should you resolve this issue, more similar work might follow.

I'm having a problem starting Strapi on my EC2 instance. The error message I receive is: "The port 1337 is already used by another application." I managed to kill the process on this port. However, it still doesn't work I need an experienced freelancer to troubleshoot and fix this issue remotely via AnyDesk. Your application should demonstrate relevant experience in Strapi, AWS EC2, and Linux (Ubuntu).

I am looking for expert assistance to fix my Word document's table of contents. The document extends beyond 50 pages, requiring experienced navigation. To successfully complete this task, the ideal freelancer should focus on: - Depth of Experience: Applicants should detail their past experiences, particularly with Wor...Applicants should detail their past experiences, particularly with Word document formatting and table of contents set up. - Specific Formatting: Only certain heading levels need to be included in the revised table of contents, highlighting the need for a meticulous and detail-oriented worker. With your experienced proficiency in Word formatting, we can ensure this document's table of contents is error-free and accurately represents the content. Let'...

I am looking for a developer to help me integrate an API that tracks shares transactions. The integration must be in PHP and support real-time data processing. Key requirements: - PHP API Integration: I need someone with strong experience in integrating APIs using PHP. The integration should be smooth and error-free. - Real-time Data Processing: The API should be able to process data in real-time, helping me to track shares transactions instantly.

...every time you register/deregister. Create, without a plugin, a daily newsletter of advertisements to users according to the categories entered during registration, the last 10 advertisements at a certain time of day. It should be possible to enable/disable this newsletter from the admin panel * Create in the admin panel the ability to enable/disable automatic sending of invoices * Change the error text when entering incorrect login information on the site * Configure sending an email to the user after granting access to the site * Add a function for automatic publication of advertisements with a check for the presence of contact information in the advertisement. There should be an option to enable/disable this function in the admin panel. * Set a password on the accounts pa...

I'm currently experiencing some technical difficulties with my website's reservation page. When attempting to make a reservation, the page remains unchanged after submission, displaying no updates or error messages, leaving me unsure of the specific problem. Ideal candidate would: - Have significant experience with troubleshooting and fixing malfunctions on websites. - Be able to identify, explain, and rectify the issue at hand. - Be available for potential future maintenance needs. Having familiarity with rental car businesses may also be beneficial. Please ensure that you're comfortable with these requirements before bidding.

...for jobs, and managing profiles and portfolios. - Build an admin portal with role-based access for monitoring user activity, managing complaints, and generating reports on job listings and user satisfaction. Preferred Tech Stack: - Front End: TypeScript framework with Server Side Rendering (React.js or Vue.js for web, React Native or Flutter for mobile) - Back End: Utilize GCP services (Cloud SQL, Cloud Functions, etc.) - Payment Gateway: Midtrans Indonesia. This work is going to be divided into 6 major stages, corresponding to 6 milestones: 1. Planning 2. Designing (Software design) 3. Developing 4. Testing 5. Implementation & Integration 6. Maintenance Details upon each stage will be discussed through online meeting If you're passionate about creating innovati...

Social media icons links are not working, the image gallery on the homepage stopped scrolling and google maps shows an error. These are easy fixes an I would like you tofix them. If everything is fixed successfully, we can then discuss for full projects. Thanks

I need to integrate Tableau with my SQL database, and I'm looking for a skilled freelancer to handle this. Key Responsibilities: - Setup Tableau integration with SQL database - Ensure seamless connection and data flow between the two - Deliver a functional, user-friendly interface for data visualization Ideal Skills: - Strong experience with Tableau and SQL - Excellent understanding of database management and integration - Ability to create interactive dashboards - Proficiency in optimizing data for Tableau visualization This project will require a keen eye for detail and a commitment to delivering a quality, tailored solution.

I have an existing Pytho...Python script that automates data processing tasks. Unfortunately, I'm encountering a runtime error when running it. I need an experienced Python developer who can help me troubleshoot and fix this issue so that the script runs smoothly again. Key Responsibilities: - Identify the source of the runtime error and fix it without impacting the functionality of the script. - Ensure the script can successfully automate the data processing tasks as intended. Ideal Candidate: - Proficient in Python programming with experience in debugging and troubleshooting. - Familiar with automating tasks in Python. - Strong understanding of data processing. Your help is crucial to keep my workflow efficient and error-free. Looking forward to working wit...