basically, permissions were changed via nginx somehow on my Vultr VPS, and now my wordpress website runs slower than normal, I've deleted all plugins and reinstalled, and also cleared cache and done everything. It must be the nginx.
Fix SQL Query Issue. What to fix: Need to fetch those records / rows that contains all keywords in any column in Name, Descr or OtherDesc Columns. See txt file for details. Important Note: Please read the txt file and prepare your queries if any before posting, otherwise the bid will be rejected.
Hi there, i need to tell you that there is a lot of anti clock wise rotation on many websites. I had 4gb ram server with 2 cpu core. As i was having this issue so i upgraded ram to 8gb and cpu core to 4 cpu core. But still the issue is there. Here is the video i just created for you to see the issue --/> [login to view URL] The domain name which i want to get fixed first is --> [login to v...
Need proper SQL Query for the following query: For E.g. there are some records in the SQL DB Table as follows: ID NAME DESCRIPTION 1 Test One This is the Test Record having test description 2 2nd Record This test record is the another one with sample text When
I need my website re-configured.I need you to build my online store. I have a few pages/ requests linked to go daddy email server. It is not sending emails. such as password reset and other requests. Please only bid if you are an expert in email handling and core PHP codeignitor framework
The solution I am after requires a data engineering development which should be able to query a postgreSQL database of 20 million records (2 crores). In the ideal scenario, the query should return 100,000 records under 5 seconds. I am looking for someone who is experienced in Apache Spark and able to show a proof of concept before developing a full
Project Duration: 1 Hour Only - You must be able to start work immediately Project Type: Wordpress Bug Fixing Number of Bugs: 2 1) RevSlider does not load, just shows loading spinner but no banner loads 2) Page takes extremely long to load in general YOU MUST BE ABLE TO START WORK IMMEDIATELY 5* FEEDBACK WILL BE LEFT FOR YOU
We have an ecommerce with Prestashop 1.6.11 and actually it's very very slow and the backend sometimes not open or gives some error (like 504 gateway timeout). We need someone skilled in Prestashop, Nginx, Cache system, Plesk and Apache to solve this and speedup the entire website.
I have script in python wheel in my imac but this very slow need help to optimize my script
When the checkout function is used i get the error WARNING : Error while sending QUERY packet. PID in /ur/www/users/xtremezepc/[login to view URL] on line 1924 This is causing high load times when i try to check out. there are sleeping queries being created. Need fixed NOW.
Using REACT, we want to pull in API results into HTML. We want to use a query string parameter to determine which results to pull using the API call and then display results. The goal is to have the query string parameter from the following URL pull into the API: [login to view URL] The “3828840” is the result ID that will
...[login to view URL] ) - Application algorithm: 1. Run a query every 30 seconds, read the records of a table with a control field = 0 2. If there are records, create two text files in a shared folder. o First file must contain some values retrieved from the query just executed. Name of file: [login to view URL] o Second File is standard (it
We have a dealer website with a login and search ability, we want to be able to have the same search ability that is always up to date to the host site minus one column of the search results.
I am looking for a product that can a.) receive texts and phone calls with an automated attendant b.) query a database and acknowledge accuracy then c.) send a call or text to another user. I will also require a simple database containing names, addresses and contact information. I would prefer to work with someone with which I can meet face to
1. The program will follow XML stream where a query will be made. 2. The query interval must be able to be determined 3. The program must work as a service (and I want to test it on command prompt or other way) 4. XML is situated in a path or address like [login to view URL] (it can also be on a different pc like 10.10.10.1234:5656 / xxxxxxxxcurrent
21 min slow speaking English Audio to be Transcribed. I will provide the MP3 file.
We need an SQL query built for a hotel group. This query will be run at any date in time, to pull historical, future or combination of both to show what segmentation is on the books [to include revenue, room nights & average daily rate] We will run the query and then the attached file is how we want the data to be exported from the Property Management
Need a little support making some queries work. This first project is for a table that I tried to put together myself but I just do not know SQL. I have pieces but not the whole. Will lead to more query projects. Hoping to find a someone that knows Open Dental tables and can accurately build reports. Sample Open Dental Queries: http://opendentalsoft
Hello, I need easy access query support, I have the set of data which is in Totals Select Query. There are bunch of users with 1 line per user and 5 attributes in column. I would like to have 5 lines per every user with those attributes in rows
...lightweight application that will allow me to schedule sql queries and email one or more contacts if the results = , < , >, <> user defined criteria. There are 4 components to the application- 1. DB connections 2. The monitor - The monitor will be a collection of sql query, schedule to run the query, contact to alert if condition is met 3. Logs show...
Part A and B Part-A. Basic SQL Dataset: ComputerStore The schema is as follows: ComputerStore manufacturers code, name products code, name, price, manufacturer The manufacturers table stores information about computer parts manufacturers as the manufacturer code and manufacturer name. The products table stores information about product as a product
[login to view URL] Is the website. Using the API key the data gets extracted every 12 hours and then it goes into database. The website should offer the functionality where i could pick the day intervals to see the change in the ranking of coins etc so the coloums on the front end would reflect the time interval i select . I could be a combination of time intervals Change in Ranking (1D,3D,7D,...
My rdp access to a Windows 2012 R2 server is very slow but it's on a fast [login to view URL] server (16gb ram, 6 cores). I've also got fast internet (1gig fiber). Can you make it fast?
Need Import Forum Tables into Kunena 2.04 (Joomla FOrum Extension) with a MySQL/PHP Query or with Kunena Importer. the process complete not properly
...Combine 5 Excel WorkSheets across 100 WorkBooks that we are trying to solve with automation and the use of the Power Query Append Command. Do not respond to this project unless you can show us some actual examples of your Excel Power Query Workbooks which are working correctly. Every 2 weeks we get between 75 and 100 individual WorkBooks named after
I am building a database for a preschool and need to calculate the children’s ages in years and months. I can work out the ages in years using the datediff function but can’t work out how to refine that to include the date as well. I have no experience with VBA codes.
We maintain approximately 100 databases in SQL 2008. We need to bill each month based on the number of records added to each database. We have been doing this manually up until now. I would like to write a SQL script that will allow my (inexperienced) user to 1) Create a table in the Billing database named by the MonthYear. 2) Set a biggining/ending
This query working SELECT DATE_FORMAT(oo.date_added, '%m/%d/%Y') as Date, ot.order_id, round([login to view URL],2) as total, round(SUM([login to view URL]*[login to view URL]),2) AS weight, round(SUM([login to view URL]*p.cost_sk),2) AS product_cost, (Select round(SUM([login to view URL]),2) from oc_order_total ot1 where [login to view URL] like 'tax' and ot1.or...
I have not done any change on system recently. But suddenly both of the order checkout on frontend and also order history/status update on backend turned very slow. I need someone to check it out and fix the problem ASAP.
Hello, I need to modify Powershell SQL query to retrieve multiple drive mappings. RIght now it maps drive fine only if user belongs to one group. But if user belongs to multiple groups mapping gets messed up.
...the layout of my homepage layout ([login to view URL]) has gotten broken, and on some browsers it is not displaying the way it should. 2. The website has become very slow, sometimes pages taking over a minute to load, especially on mobile. Sometimes I also see 500 errors. I would like it optimized so that it loads much faster to give users a
Hi Slow Cheetah studio, My name is Alberto, we have a product called metodotapscott: [login to view URL] We are interested in a promotional video about our product. If you are interested in that, please let me know
I have a Postgres table with over 90 million records and trying to build a particular query in the most efficient way. PostgreSQL experience is mandatory however Python and Django skills will be advantageous. It's probably less than one hours work and urgent. So I will be choosing some one who is currently online within the next 1 hour! PS: L
My Codeigniter web application is powered by 2 separate MySQL databases. I need a query that will query both databases individually on demand, on the fly, for each each user request, and combine the results programmatically.
I want to extract certain set of rows(lets say rows 10-30) from same sheet(lets say sheet "income statement") present in multiple excel files to create a data dump in an automated manner. Also i want to shape the data in a particular way ( basically pivoting and transposing on certain columns). I want to use powerquery (and probably M, if required) for this.