Find Jobs
Hire Freelancers

318989 Add db table for CMS

N/A

In Progress
Posted almost 15 years ago

N/A

Paid on delivery
I have a website that publishes press releases (articles). The current CMS is developed in PHP and it seems that the mysql table that stores the information for the articles is getting way too big. I believe there are over 280K records. Because of this the performance of the site is extremely slow. And often times there are mysql processes that get locked and therefore crashing the mysql server. What I need is for someone to create another table in the database that will start fresh with the storing of new articles. The current releases are published on the site in the form of [login to view URL] where "12345" is the specific number of the release. So the new table needs to continue publishing the articles using that format. Basically everything needs to be working as is on the site but the only difference is that the new articles are using a new table for increased performance. I believe the job be relatively easy since we're really just creating a new table and making sure the articles get published as normal. There is also one other small issue that arises sometimes when a website user attempts to publish a press release. It seems some words when entered in the press release submission trigger an error with the PHP code. For example, I had a user submit an article that had the words "create extravagant" in the first paragraph which then returned an "Internal server error" page after submitting the form. This has happened with dozens of users. I believe it has something to do with the version of php the site is using and/or the form submission code. This would need to be fixed as well.
Project ID: 2064792

About the project

Remote project
Active 12 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

About the client

Flag of UNITED STATES
Bergenfield, United States
5.0
55
Payment method verified
Member since Sep 14, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.