Common query jobber
...trading cards ranging from sports, to Pokemon and One Piece collectables. I'm leaning towards a design that is clean and modern. Key website features should include: - User Registration and Login: Applicants should be able to create personal profiles with ease, ensuring quick access to the trading card marketplace. This enables users to post their requests, of cards that might not be available in common markets and or post them with their desired value( Looking for X card for $$) ( Looking for X card graded with XX uploading a picture of demanded card....) - Card Posting and Searching: Users need the ability to post cards they're offering or seeking. An efficient searching mechanism is also crucial for streamlined navigation through various card categories( search ...
...user identity, common authentication methods include username and password, OAuth, two-step verification, etc. o Presence Management: Manage and display user statuses such as online, offline, busy, invisible, etc. o Message Transfer: Implement message sending and receiving between users, including text, images, audio, video, and other formats. o Data Storage: Supports more intuitive viewing of accounts under groups. o Network Communication: Manage network connections between clients and servers, usually using TCP/IP protocol, sometimes combined with technologies such as HTTP/WebSocket. o Push Notifications: Notify users of new messages when the application is not running in the foreground. o Encryption & Security: Ensure the security of message transmission,...
I'm seeking an exceptional writer to create an 800 word blog post weekly. The focus should be on business law relevant to life sciences and technology businesses. Your posts will cater to an audience ranging from startups to established companies. Key objectives: - Inform and educate on the intricacies of business law in the tech and life sciences arena - Cultivate awareness about common legal pitfalls, current legal events and regulatory changes. Ideal candidate: - A skilled writer with a solid understanding of business law - Knowledge in tech and life sciences industries is a major plus - Demonstrates the ability to distill complex legal information into relatable content. With your help, we can empower businesses using law and foresight.
I am looking for an experienced React Native developer who can develop a functional driver app for both iOS and Android platforms. I already have UI screens, however, are open to guidelines and suggestions. The Primary function of the app ...should have: - Proven experience in React Native Development - Proficiency in working with both iOS and Android platforms - Excellent understanding of GPS integration and real-time notifications - Ability to work with provided UI screens and enhance functionality - Expertise in payment processing integration. I'm excited to see how your skills and experience match this project. If you have any query or suggestion please let me know. Looking forward to collaborating with you. Note : There are 20 UI Screens and we put a 150 Rupees per s...
...integrate with Dolibarr ERP systems. Responsibilities: Develop advanced SQL queries to extract data from MLM databases. Understand and apply concepts of MLM compensation plans. Collaborate closely with the team to understand project requirements and goals. Integrate SQL solutions with Dolibarr ERP systems. Optimize query performance and ensure data integrity. Requirements: Demonstrable experience in SQL and PHP. Deep knowledge of relational databases and experience in query optimization. Previous experience working with MLM databases and familiarity with their structures and terminology. Experience with Dolibarr ERP systems or similar ERP solutions. Ability to work independently and effectively solve problems. Excellent communication skills and ability to work in a team...
I am in need of a remote medical transcriptionist to handle my gastroenterological medical transcriptions. Approximately 5 letter per day. New patient visits (about 3 pages) and follow-up visit (1-2 pages) These transcriptions are crucial for the maintenance of patient records. Sent as ...protection guidelines. The transcriptions do not need to be compatible with any specific EHR systems. The primary focus is on creating accurate and reliable transcriptions for patient records. I am a fluent English speaker and English is my native language. Please quote rates and describe experience. CAN PAY PER AUDIO MINUTE OR PER LINE. Hourly rate does not apply. Pay is per work produced as is common in transcription. Prefer US based freelancer. Must agree to US HIPAA rules for privacy and...
We have encountered a critical error across our entire WordPress site, despite not having made any recent changes or updates to plugins, themes, or WordPress itself. The expertise of an adept WordPress developer is required to troubleshoot and resolve this issue promptly. Ideal skills: - Proficient in WordPress - Skilled in Debugging and Error Resolution - Familiar with Common WordPress Errors - Experiences in Troubleshooting WordPress Websites Responsibilities Include: - Identifying the cause of the error - Fixing the error effectively - Ensuring the error doesn't occur again - Testing the entire site for seamless functionality after the fix. Please note that this issue is across all pages of the site and needs an immediate resolution. Your understanding and quick turnaro...
I need an experienced developer to build a crypto wallet application compatible with Android devices and also a website for the app. The critical functions of this application include, but are not limited to: • Display real-time prices of all types of cryptocurrencies. • Execute common wallet functions such as sending and receiving payments. • Facilitate fundraising by hosting a dedicated section for donations. Any interested developer should also ensure that users are required to create an account before they can use the wallet. Your expertise in mobile and web application development, especially with experience developing crypto wallets or similar financial apps, will be highly valued. Familiarity with blockchain technology and a deep understanding of crypto token...
It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.
...form should allow users to upload multiple files. There should be a clear indication of the allowed file types and a size limit. The uploaded files should be go to a Google Drive where a file handling automation script can be used. - Personal Details: The form should have fields for essential personal details. Although the specifics were not provided earlier, it's safe to assume this would include common fields like name, email, phone number, etc. - Payment Gateway Integration: The form should support payment via Paypal, bank transfer, and credit card. Ensure the payment process is smooth and well-integrated. - The form should first let the user upload the file without requiring a payment initially. After uploading is completed, the user will be shown a number of options for...
We have encountered a critical error across our entire WordPress site, despite not having made any recent changes or updates to plugins, themes, or WordPress itself. The expertise of an adept WordPress developer is required to troubleshoot and resolve this issue promptly. Ideal skills: - Proficient in WordPress - Skilled in Debugging and Error Resolution - Familiar with Common WordPress Errors - Experiences in Troubleshooting WordPress Websites Responsibilities Include: - Identifying the cause of the error - Fixing the error effectively - Ensuring the error doesn't occur again - Testing the entire site for seamless functionality after the fix. Please note that this issue is across all pages of the site and needs an immediate resolution. Your understanding and quick turnaro...
...open book. Closed book means you are unwilling to define a WBS for the work and you add only a price tag to the task. We are sorry we will not hire you in such a case! documentation requirements: - well structured - reproducible steps for others - spell & grammar checked coding requirements: - clean code in terms of clean code book - best practices for development (code level documentation, common patterns, OOP as possible) - best practices for agreed and choosen libs/frameworks Deliveries? - in our on premise git (access will be granted to you) - full sources - full working build (for CI and local build) - libs, need prior confirm and we prefer to use mostly latest stable versions - JDK 17 (mostly LTS) - your code is working on our end too - your code passes our CI buil...
I'm seeking a knowledgeable specialist to perform benchmarks on my Pgvector Chroma Faiss database. The key objectives for this project are: - Analyzing speed and query performance. The ideal freelancer should have: - Proficiency with Pgvector, Chroma, and Faiss. - Experience in database benchmarking, with a focus on query performance metrics. - Ability to provide detailed reports on performance metrics. - Ability to offer performance tuning recommendations based on benchmark results. As this is for personal use, the project requires a specialist who can deliver thorough insights without the need for a business-oriented approach. Your technical database expertise will be crucial for this project.
I'm looking for a skilled ethical hacker to help with security testing on my Instagram account. I'm particularly interested in identifying any security vulnerabilities and testing the existing security measures in place. Key Requirements: - Experience in ethical hacking and security testing - Familiarity with Instagram's security protocol and common vulnerabilities - Ability to work with test accounts with limited permissions Ideally, you will provide a detailed report on the security of the account, with any vulnerabilities highlighted, recommended improvements, and confirmation of the effectiveness of current security measures. Your work will be instrumental in ensuring the safety and privacy of this account.
Create a relational database for the following data in a single tables with parts store. You may use alphanumeric to represent store and use surrogate key as primary key. Bring a hard copy in class and answer two quires in class. (points Project creation 20 + two query 20) 1. Vendor 1: Low Hardware, 1200 Harding st, Pine Bluff, AR 71602, Phone 870-535-1000 Supplies screw Size Steel Size Unit Price QTY Stainless Steel QTY Unit Price 6-32 Yes ½” .02 300 Yes 100 .04 6-12 Yes 3/4” .03 300 Yes 200 .06 6-32 Yes 1” .04 400 Yes 200 .08 6-32 Yes 1 ¼” .05 300 No 0 .10 6-32 Yes 1 ½” .06 500 Yes 20 .12 8-32 Yes ½” .04 300 Yes 200 .08 8-32 Yes ½” .05 400 Yes 100 .10 8-32 Yes ¾” ...
...activate the account. - **1.2 Login** - Users must log in using their registered school email address. - The system should provide password recovery options. #### 2. User Dashboard - **2.1 Access** - Upon successful login, users are directed to their dashboard. - **2.2 Features** - A search box to look up universities by name. - A list of universities should appear based on the search query. - Users can select a university to view more details. #### 3. University and Course Interaction - **3.1 University Selection** - After selecting a university, a list of available courses is displayed. - **3.2 Course Selection** - Users can select a course to view detailed information, including existing reviews. #### 4. Review Management - **4.1 Review Actions** - User...
FOR MELBOURNE BASED FREELANCERS ONLY I am a finance professional with over 30 years experience in the investment markets. I need an experienced tutor in Microsoft Access to assist me with database creation and query design and optimization. The ideal candidate should be able to help me understand: - How to create a well-structured database in Microsoft Access - The best practices for query design and optimization to enhance the efficiency and speed of the database operations You should also be able to provide guidance on: - How to maintain a clean and minimalist design that is easy to navigate - The creation of a user-friendly interface that is intuitive and easy to interact with - The customization of templates to suit specific requirements The complet...
The main goal of this project is to improve our React applic...maybe 10 pixes on all browsers - Chrome, Firefox, Safari and Edge. 3. Header seems too crowded and needs a) a bit more spacing around icons, search field, etc. b) need to increase height equal to the height of header in About US page. 4. Radio buttons are not getting selected sometimes when you click first time. 5. Minor Styling changes: a). Set background color to f5f5f5 (should be set in a common css or scss file and reused as a variable in all pages) see screenshot. b) When you see the results in list view (one item per row) the logo for Walmart seems to go off the screen/item box, it should be within the item box and have some spacing around it. c) need a better idea to make the "Clear Filters" look mo...
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 the production 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 co...
...create 34 trademark specimens of different classes for the trademark "ALAN FOSTER". The ideal candidate would have prior experience with specimen design and a clear understanding of United States trademark registration requirements. Attached is the logo file that you will be using for the trademark specimens. The 34 classes I need trademarks for include: 001 - Chemicals 005 - Pharmaceuticals 006 - Common Metals 007 - Machines 009 - Computers and Scientific Devices 010 - Medical Supplies 011 - Appliances 012 - Vehicles 013 - Firearms 014 - Precious Metals 015 - Musical Instruments 016 - Paper Goods 020 - Furniture 021 - Household Utensils 024 - Textiles 025 - Clothing 027 - Carpets 028 - Games and Sporting Goods 029 - Meat, Fish, Poultry 030 - Coffee, Flour, Rice 031 - ...
...via the WhatsApp API. Integration with WhatsApp API: Utilize the official WhatsApp Business API to send text messages, images, files, and other supported content types. Contact Management: Develop a system to manage the list of customer contacts, allowing for adding, editing, and deleting contacts as needed. Message Templates: Create predefined message templates to facilitate the sending of common messages, such as order confirmations, appointment reminders, promotions, etc. Activity Logging: Implement an activity logging system that records all interactions performed through the application, including message sending, delivery status, etc. Technologies Used: PHP: Primary programming language for backend development of the application. MySQL: Database for storing user inform...
I am seeking a media professional to create enhanced images and engaging videos for my 53 Etsy store listings. I envision these visuals to follow a consistent, unique theme. The exact nature of the "...capturing product and lifestyle images will be a bonus as these might be required. - Explainer Videos: Ability to produce explainer videos would be beneficial. - Portfolio: A demonstrable portfolio of past work is essential to ensure you have the necessary skills and creativity I'm looking for. - Preferred Aesthetic: The preference is for themed visuals. Applicants with a certain knack for infusing common threads or storylines across different images and videos will be preferred. To make a successful bid, please provide examples of your past work, particularly those revo...
I am seeking a competent developer with experience in algorithmic trading. The main aim of this project is to connect a broker API for algo trading in the stock market using Python. The broker API to be used is not specified yet, hence, you should be adaptable and skilled with several common trading platforms such as E-Trade, TD Ameritrade, or Interactive Brokers. The task at hand involves connecting the broker API in order to carry out trading with our proprietary strategy. Ideal Skills and Experience: - Proficiency in Python - Deep understanding and experience with algorithmic trading - Familiarity with various trading platform APIs for algo trading Please include in your application a detailed proposal outlining the plan, tools, and methodologies you intend to employ for a ...
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 the Production 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 y...
...Management**: This entails handling all incoming emails from customers. The goal is to ensure timely and accurate responses, maintaining high quality customer service standards. - **Data Entry and Organization**: You would be responsible for entering and organizing data within our Shopify platform. This would include product information, customer details, and other pertinent data. - **Customer Query Resolution**: Addressing customer queries in a professional, friendly and efficient manner is crucial. You would need to have good problem-solving skills. **Daily Volume**: The expected volume of emails and queries to be handled on a daily basis typically falls within the range of 50-100. It's important to maintain a quick turnaround time while ensuring accuracy. The ideal ca...
I am in need of a proficient data entry specialist to help translate text data from PDF digital files to a more accessible format. This project requires a meticulous individual with keen attention to detail, who is capable of handling and processing large amounts of text data accurately an...processing large amounts of text data accurately and efficiently. The responsibilities for this job include: - Transferring text data from PDF files - Ensuring data is entered accurately, without errors - Organizing high volumes of digital documents Ideal skills and experience for the job: - Proven experience in data entry, particularly with PDF text - Exceptional attention to detail - Proficient in common data software - Excellent organization skills - Ability to handle multiple tasks simul...
I am ...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 criteria is small. If I pass filter for say 50 GUIDS then this query does not return any records. I think addCustomView makes rest call and pass all filters in URL. and this URL is too big. Are you able to investigate / fix thi...
I'm seeking a skilled Python developer who can handle all aspects of SNMP for my project. Key Responsibilities: - Implementing SNMP query and data retrieval - Efficiently managing SNMP trap handling and notification - Developing a robust SNMP agent Your role will be crucial in ensuring that our system effectively communicates using SNMP across multiple versions. Ideal Skills and Experience: - Proficiency in Python - Extensive experience with SNMP (versions 1, 2c, and 3) - Strong understanding of network communication - Previous work on SNMP trap handling and agent development is a major plus If you have the right skillset and experience, I look forward to seeing your proposal.
I need an editable Word template created. The document will have permanent styles, but editable sections for my team to fill in. Key Features: - The template should include common formatting options like font styles and sizes, bullet points, numbering, and page borders. - I need the following styles to be fixed in the template: Heading styles, Paragraph styles, Table styles, Font, color, alignment, Indentation. - The main body content should be the only editable section for my team. Ideal Skills: - Proficient in Microsoft Word and its advanced features. - Experience in creating editable templates. - Attention to detail to ensure that the permanent styles are consistent throughout the template.
I am looking for someone who has worked with Elementor Queries before to write a query that does the following ... Our posts have an ACF field called prsona, which is shared with the posts. When posts are created they are created with that ACF field of the creator. Now we want to display posts where the posts prsona field matches the users prsona field.
I need an editable Word template created. The document will have permanent styles, but editable sections for my team to fill in. Key Features: - The template should include common formatting options like font styles and sizes, bullet points, numbering, and page borders. - I need the following styles to be fixed in the template: Heading styles, Paragraph styles, Table styles, Font, color, alignment, Indentation. - The main body content should be the only editable section for my team. Ideal Skills: - Proficient in Microsoft Word and its advanced features. - Experience in creating editable templates. - Attention to detail to ensure that the permanent styles are consistent throughout the template.
I'm looking for someone to help me set up Zobot Zoho for my customer support team. Key Tasks: - Integrate live chat: I want my customers to be able to easily chat with our agents. - Implement automated ticketing: I need the system to efficiently create and manage support tickets. - Set up FAQ self-service: I'd like to reduce the workload on my team by having a self-service option for common queries. The ideal freelancer will have: - Proven experience in setting up Zobot Zoho - Strong understanding of customer support systems - Familiarity with integrating live chat and ticketing systems - Ability to create a user-friendly FAQ self-service interface - Excellent communication skills to ensure a smooth handover to my team. Please note that my team consists of 5-10 agent...
We are looking for a talented industrial designer to collaborate on an exciting new project in the logistics sector. The project involves creating a portable solution that addresses common challenges faced in transportation and warehouse operations. Ideal candidates will have a strong background in industrial design, with experience in product development and prototyping. The ability to think creatively and problem-solve in a dynamic environment is essential. If you're passionate about designing innovative solutions that enhance efficiency and usability, we'd love to hear from you. Please send a portfolio showcasing your previous work and a brief introduction highlighting your relevant experience.
***Only contact me if you have experience in DiaLux or AGi32. Also, send me your sample work.*** I'm looking for a skilled lighting designer to work on a small residential apartment complex and car park. The project requires an understanding of Australian standards for lighting. Key Responsibilities: - Design lighting for common areas - Individual apartment lighting - Car park lighting *All lighting to comply with Australian Standards. *Project must be designed using AGi32 or DiaLux software Skills and Experience: - Proficiency in lighting design - Knowledge of Australian standards - Should be able to use AGi32 or DiaLux Software Note: Scope of work is attached along with some Sample drawings. Deliverables: 1. Dwg & pdf drawings with lighting fixture layout along with l...
I'm seeking a skilled and innovative interior designer to breathe new life into the common areas of my home that includes the living room, bedroom, and kitchen. I'm drawn towards a modern aesthetic and want this to be the guiding principle for the redesign project. While elegance is important, the spaces must remain functional and practical for daily living. Key responsibilities: - Develop a cohesive and modern design concept for the living room, bedroom, and kitchen. - Select furniture, decor, colours, and finishes that align with the overall modern design. - Create a visually appealing, comfortable, and functional space. Ideal freelancer: - Proven experience in residential interior design - Strong portfolio, preferably with a focus on modern design - Excellent communic...
...castle is to be a minimum of 10,000 meters squared. An estimated material list for example 1 ton of cement 2 tons of steel etc. The castle is to be built on a 2-acre plot and Castle to be situated Directly in the center of the Plot. The castle should be raised up a minimum of 10 feet from ground level. The ceiling height from the floor should not be lower than 10 feet on each floor. All rooms and common areas are to have grey carpet as shown in the photos, except bathrooms and the main entrance and rear entrance of the property which should be tiled. Water is to be supplied from boreholes and water is purified and stored on the roof of the property, solar water heater, and pump, and septic tank are to be dug out for human waste, rain water harvester, and 2x waster storage tanks ...
I am looking for a professional with proficiency in Power Query and PowerBI. The key objectives are: - Data Transformation: The expert is expected to possess the skills to thoroughly transform operational data since this is primarily what's going to be handled. - Excel Proficiency: Once transformed, the data should be presented in an Excel file. A good command of Excel functionality is important. - PowerBI Reporting: The transformed data needs to be applied in creating interactive reports. Mastery of PowerBI tools is a prerequisite. - Visual Dashboard Creation: A visually engaging dashboard should be created in PowerBI. Practical knowledge of industry practices in dashboard creation is a plus. Prior experience in handling and transforming operational data and carrying out dat...
...as well as vector databases to store the index. All ingested documentation is cleaned up and divided into smaller chunks and labeled by source. We then use the GPT embedding API to generate a vector representation of each chunk and store it in the vector db index. When a user asks a question, we convert it to an embedding, and perform an advanced semantic search for closest matches to the user's query. Then we take the most relevant chunks, included them as context along with the original question, and use the ChatGPT API to generate a response in markdown format that we then convert to HTML and display to the user. This is from website. They provide a similarity percentage from the sources they use for the generated answer, we can use that similarity percentage for the r...
As a client, I'm looking for a skilled writer and PowerPoint designer with a clear understanding of critical thinking and logical fallacies. The purpose is to: - Develop a coherent and visually appealing PowerPoint presentation. - Educate readers about 10 common fallacies. - Each fallacy should include: * Definition- use the definitions included in my attachment * An example- use the examples included in my attachment * A visual. *Engage the readers Ideal freelancer would provide: - Proven experience in PowerPoint design. - A strong grasp of articulate writing. - Understanding of educational content development. - Background in philosophy, critical thinking or related fields preferred.
...of existing web projects that are unique and have potential for further development. Key Requirements: - I'm particularly interested in existing E-commerce websites, Blogging platforms, and Social networking sites. However, if you have a different type of web project that you believe is truly unique and has potential, feel free to reach out. - The projects should be distinct and not based on common templates or themes. - I'm looking for projects that have not been overused or replicated extensively by others. Ideal Freelancer: - You have a track record of creating original, unique web projects. - You have experience with redesigning and adding features to existing projects. - You understand the potential of a project and can provide suggestions on how it can be ...
I am seeking a WordPress developer who can make specific modifications to a custom query that uses Advanced Custom Fields (ACF). The project involves: - Changing the query parameters - Adding additional query conditions - Sorting the query results The purpose of these modifications is to: - Display specific custom fields - Customize the order of displayed posts In particular, the modified query should display the 'Subfield Date' (from a repeater field) in the query results. Ideal candidates for this project should have: - Proficiency in WordPress development - Extensive experience with Advanced Custom Fields (ACF) - Expertise in modifying and customizing WordPress queries - Thorough understanding of PHP and MySQL Please provide ex...
I'm in need of a publishing expert in book publishing services, specifically for non-fiction genres. I have a fully-completed manuscript and I'm looking for someone to critically fine-tune my query letter and book proposal. Your role would involve: - Review and edit query letter and book proposal for UK and US agents - Offer constructive feedback and direction on improving the overall readability and marketability of the book proposal and letter Ideal candidates should have: - Proven experience in non-fiction book publishing with traditional publishers - Significant experience in the book proposal process - Solid understanding of what works in non-fiction book proposals to secure a literary agent Overall, your expertise will play a pivotal role in the overall su...
It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.
I'm in need of an experienced Vue.js developer to assist with front-end development and implementing dynamic components. The project specifically involves working with Vue 2 and does not require integration with external APIs. Key Responsibilities: - Front-end Development: You'll be tasked with designing and developing the user-facing aspects of the application. - Dynamic Components: Implementing dynamic components to enhance user experience and application functionality. Ideal Skills and Experience: - Proficient in Vue.js: Extensive experience with Vue 2 is a must. - Front-end Expertise: Strong background in front-end development, with a focus on user interface design and development. - Dynamic Component Implementation: Proven experience in implementing dynamic components in V...
...that the specific table causing the error was not identified. Your expertise in this area will be crucial. I am using Magento 2.4.6-p4 CE and I get the following error after every order. The job indexer_update_all_views scheduled at 2024-04-15 10:31:03 failed with the following error message: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entity_id' in where clause is ambiguous, query was: SELECT `o`.`entity_id`, `o`.`increment_id`, `o`.`customer_id`, `o`.`billing_address_id`, `o`.`customer_email`, `o`.`customer_firstname`, `o`.`customer_lastname`, `o`.`status`, `o`.`created_at`, GROUP_CONCAT(oi.product_id) AS `products`, `billing_address`.`city` AS `billing_city`, `billing_address`.`company` AS `billing_company`, `billing_address`.`postcode` AS `billin...
...help to fix issues) - we pay (basically the rules of freelancer) Closed book vs open book? We work only on open book. Closed book means you are unwilling to define a WBS for the work and you add only a price tag to the task. We are sorry we will not hire you in such a case! coding requirements: - clean code in terms of clean code book - best practices for development (code level documentation, common patterns, OOP as possible) - best practices for agreed and choosen libs/frameworks Deliveries? - in our on premise git (access will be granted to you) - full sources - full working build (for CI and local build) - libs, need prior confirm and we prefer to use mostly latest stable versions - JDK 17 (mostly LTS) - your code is working on our end too - your code passes our CI build...
... Ideal skills and experience for this assignment include: - Expertise in Laravel & MySQL - Experience with high load applications - In-depth understanding of database performance optimization - Experience with online poll/voting systems The specific tasks I need assistance with are: 1. Addressing a database connection error which has arisen due to intense continuous voting. 2. Tackling the query performance problems coming up in our online polling setup. 3. Addressing the data inconsistency issues that have cropped up due to dynamic vote tallying. The votes are expected to be collected as per IP, hence, experience with IP-specific data handling is highly desirable. In summary, I need a Laravel and MySQL expert to revamp our online voting architecture for seamless perfo...
...A data archive is expected to allow users to have a space where they can share data privately to facilitate collaboration prior to publication. Such private enclaves must only last for a defined period of time before that data set is shared with the rest of the data archive will provide an interface that is accessible to anyone with a web browser. A data archive will make appropriate query tools and summary data easily will want to analyze and/or use visualization tools to interact with the data without downloading any data.A data archive is strongly encouraged to use cloud storage and computing possible, a data archive is expected to use existing infrastructures and standards. These could include persistent identifiers such as Digital Object Identifiers
