Wordpress website database to SQL errors need repairs
Budget: $30 – $250 USD
Project Title: Wordpress website database to SQL errors repair
I am currently experiencing data corruption errors on my Wordpress website database and I need immediate repairs within 24 hours. The errors are occurring constantly and are affecting the functionality of my website.
This is the error i get when i use the property search fields on my website
WordPress database error: [Unknown column 'nopost' in 'where clause']
select count(p.ID) from eb6vcsbldx_posts p where p.post_status='publish' and p.post_type='property' and p.ID in (nopost) AND (p.ID in (select eb6vcsbldx_postmeta.post_id from eb6vcsbldx_postmeta where p.ID = eb6vcsbldx_postmeta.post_id and eb6vcsbldx_postmeta.meta_key='property_city' and (eb6vcsbldx_postmeta.meta_value like "%%" )))
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1]
select * from eb6vcsbldx_posts p,eb6vcsbldx_postmeta pm where p.ID = pm.post_id and p.post_status='publish' and p.post_type='property' and p.ID in (nopost) AND (p.ID in (select eb6vcsbldx_postmeta.post_id from eb6vcsbldx_postmeta where p.ID = eb6vcsbldx_postmeta.post_id and eb6vcsbldx_postmeta.meta_key='property_city' and (eb6vcsbldx_postmeta.meta_value like "%%" ))) group by p.ID order by p.ID desc limit 0 ,
my theme is highly changed and updated over the last 10 years so it cannot be updated.
the host is bluehost they were useless in support
i can give full access to my website and bluehost backend control panel file manager etc
i need this done within a few hours i have attached screen shots so you can see what happens and also test yourself by doing a search for property just click any field and choose any item then press search and you will see the errors.
The issue is being caused by my SEO squirrely plugin i deactivated it and all is okay but the problem needs fixing.
my site also had search issues when I updated to wordpress 6.3 so i had to roll it back to 6.2.2 this needs to be fixed as it delivered a blank white page.
Also there are various issues to be fixed when you look at the site health in the dashboard
An active PHP session was detected
Performance
A PHP session was created by a session_start() function call. This interferes with REST API and loopback requests. The session should be closed by session_write_close() before making any HTTP requests.
The REST API encountered an error
Performance
The REST API is one way that WordPress and other applications communicate with the server. For example, the block editor screen relies on the REST API to display and save your posts and pages.
When testing the REST API, an error was encountered:
REST API Endpoint: https://beachtownproperty.com/wp-json/wp/v2/types/post?context=edit
REST API Response: (http_request_failed) cURL error 28: Operation timed out after 10001 milliseconds with 0 bytes received
Vulnerabilities detected
Security
1 vulnerability has been detected. Please check the vulnerabilities overview for more information and take appropriate action.
View vulnerabilities
Skills and experience required:
- Strong knowledge of SQL and database management
- Proficiency in Wordpress and its database structure
- Experience in troubleshooting and resolving data corruption errors
- Attention to detail and ability to identify and fix syntax errors
- Familiarity with connection errors and how to resolve them
If you have the expertise and can complete the repairs within the specified timeframe, please submit your proposal.
I am currently experiencing data corruption errors on my Wordpress website database and I need immediate repairs within 24 hours. The errors are occurring constantly and are affecting the functionality of my website.
This is the error i get when i use the property search fields on my website
WordPress database error: [Unknown column 'nopost' in 'where clause']
select count(p.ID) from eb6vcsbldx_posts p where p.post_status='publish' and p.post_type='property' and p.ID in (nopost) AND (p.ID in (select eb6vcsbldx_postmeta.post_id from eb6vcsbldx_postmeta where p.ID = eb6vcsbldx_postmeta.post_id and eb6vcsbldx_postmeta.meta_key='property_city' and (eb6vcsbldx_postmeta.meta_value like "%%" )))
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1]
select * from eb6vcsbldx_posts p,eb6vcsbldx_postmeta pm where p.ID = pm.post_id and p.post_status='publish' and p.post_type='property' and p.ID in (nopost) AND (p.ID in (select eb6vcsbldx_postmeta.post_id from eb6vcsbldx_postmeta where p.ID = eb6vcsbldx_postmeta.post_id and eb6vcsbldx_postmeta.meta_key='property_city' and (eb6vcsbldx_postmeta.meta_value like "%%" ))) group by p.ID order by p.ID desc limit 0 ,
my theme is highly changed and updated over the last 10 years so it cannot be updated.
the host is bluehost they were useless in support
i can give full access to my website and bluehost backend control panel file manager etc
i need this done within a few hours i have attached screen shots so you can see what happens and also test yourself by doing a search for property just click any field and choose any item then press search and you will see the errors.
The issue is being caused by my SEO squirrely plugin i deactivated it and all is okay but the problem needs fixing.
my site also had search issues when I updated to wordpress 6.3 so i had to roll it back to 6.2.2 this needs to be fixed as it delivered a blank white page.
Also there are various issues to be fixed when you look at the site health in the dashboard
An active PHP session was detected
Performance
A PHP session was created by a session_start() function call. This interferes with REST API and loopback requests. The session should be closed by session_write_close() before making any HTTP requests.
The REST API encountered an error
Performance
The REST API is one way that WordPress and other applications communicate with the server. For example, the block editor screen relies on the REST API to display and save your posts and pages.
When testing the REST API, an error was encountered:
REST API Endpoint: https://beachtownproperty.com/wp-json/wp/v2/types/post?context=edit
REST API Response: (http_request_failed) cURL error 28: Operation timed out after 10001 milliseconds with 0 bytes received
Vulnerabilities detected
Security
1 vulnerability has been detected. Please check the vulnerabilities overview for more information and take appropriate action.
View vulnerabilities
Skills and experience required:
- Strong knowledge of SQL and database management
- Proficiency in Wordpress and its database structure
- Experience in troubleshooting and resolving data corruption errors
- Attention to detail and ability to identify and fix syntax errors
- Familiarity with connection errors and how to resolve them
If you have the expertise and can complete the repairs within the specified timeframe, please submit your proposal.