Kapalı

Quick fix to sql code

Hi all

A freelancer knocked up a php/mysql job for me last year which has been working fine - until today.

I've recently moved to a new hosting company and had no problems until today when we tried to add some new content via the admin backend and received an error saying something about it not being compa tible with the version of sql.

The frontend of the system can be seen at [url removed, login to view]

Adding new episodes and images works fine but the problem occurs when trying to enter the text captions.

The error message is "Unable to query database: 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 't beat a plateful of cholesterol to set you up for the day.' where epdId = '258' at line 1

I'm assuming it would be a relatibely simple fix for someone who knows what they are doing.

Also, if it is possible, I am wondering if the code could be amanded so it generates a unique url for each episode. At the moment, everything is pulled into the one php page.

Beceriler: MySQL, PHP

Daha fazlasını görün: php fix sql code, works at freelancer, when to use freelancer, updates freelancer, t sql freelancer, quick text, quick freelancer, php works at freelancer, near freelancer, mysql job freelancer, manual freelancer, job near me, frontend freelancer, freelancer sql database, freelancer sql c#, freelancer server set up, freelancer server not working, freelancer problem, freelancer of the year, freelancer of frontend, freelancer new version, freelancer near you, freelancer job system admin, freelancer it sql, freelancer error

İşveren Hakkında:
( 1 değerlendirme ) Earl Shilton, United Kingdom

Proje NO: #691858

23 freelancer bu iş için ortalamada 34$ teklif veriyor

eperfections

Please see PMB

in 0 gün içinde30$ USD
(192 Değerlendirme)
6.9
kernelbd

Could be fix within an hour. Thanks.

in 0 gün içinde30$ USD
(111 Değerlendirme)
6.8
yunuscse

Please view my PM for more details.

in 0 gün içinde30$ USD
(100 Değerlendirme)
6.7
webn

WITHIN HOUR I CAN FIX.

in 0 gün içinde30$ USD
(100 Değerlendirme)
6.6
asarfraz

Ready to start now. Please provide FTP access so I can resolve the issue. Escrow required up front.

1 gün içinde 30$ USD
(77 Değerlendirme)
6.5
websoftinfo

Have a look on these portfolio.... Latest Projects [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] Daha fazlası

1 gün içinde 30$ USD
(67 Değerlendirme)
6.4
kopila123

please view pm

1 gün içinde 30$ USD
(107 Değerlendirme)
6.3
webmagics

Hi, We can do [url removed, login to view] see PMB for details. Thanks

in 0 gün içinde30$ USD
(47 Değerlendirme)
6.2
h114

Please have a look at the PMB.

1 gün içinde 30$ USD
(22 Değerlendirme)
6.0
MustafaSR

Hello Sir, Please check PMB

1 gün içinde 30$ USD
(77 Değerlendirme)
5.8
NeoWebSoftware

Easy job. Ready to fix it any time :)

in 0 gün içinde30$ USD
(56 Değerlendirme)
5.7
servicebenq

hi See pm please.

in 0 gün içinde30$ USD
(31 Değerlendirme)
4.8
albariconsulting

please check PMB for details

1 gün içinde 50$ USD
(3 Değerlendirme)
4.5
BIOSTALL

Hi there, From the information you have provided I already know what the problem is. Please allow me to do the job and I will have it fixed within a couple of hours! Hope to hear from you soon, Steve

in 0 gün içinde30$ USD
(15 Değerlendirme)
4.1
arbalet

let's start

1 gün içinde 30$ USD
(9 Değerlendirme)
3.3
digitalwebavenu

I know where is the problem. This problem is not due to the new server. I can fix it right now if you choose me now. Waiting for your reply.

1 gün içinde 30$ USD
(3 Değerlendirme)
3.0
freelancefoo

I am a new freelancer from USA with 13 years of MySQL exp - should be a breeze + I'm looking for my 1st job so help a brother out :) Thank you, Dan

1 gün içinde 40$ USD
(1 Değerlendirme)
1.0
programmerdelhi

Hi, Please discuss through Pmb

in 6 gün içinde120$ USD
(1 Değerlendirme)
0.0
cmckni3

I can fix this easily.

in 0 gün içinde30$ USD
(0 Değerlendirme)
0.0
Dijkstra

I can fix your code within few hours, i can make changes in functionality if you want. Let me know when to start. Thanks

in 0 gün içinde31.89$ USD
(0 Değerlendirme)
0.0