Web Hosting Talk







View Full Version : [OFFER] SQL Database Recovery Problem. Expert Needed! $15.


frankiee
01-26-2005, 09:04 PM
Hi,

I need help recovering my sql database. Everytime I do it in phpmyadmin, this is the error that comes up:

#1064 - 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 'desc varchar(255) NOT NULL default '',

However can fix this, I will pay $15 USD. Please do not contact me, unless you know exactly what you're doing.

I need this up asap.

Contact:
AIM: fnaiuf
Email: fxhost@gmail.com

Thanks

Voxxit
01-26-2005, 09:43 PM
I can complete this for you. Please contact me with information about your server, and we can discuss payment as well.

Cheers,
Josh

frankiee
01-26-2005, 11:45 PM
Job is filled.

Thanks to all those who applied.

superprogram
01-27-2005, 03:56 AM
Would you mind telling us how the problem was solved?
Thanks

xachen
01-27-2005, 01:19 PM
It seems that DESC was in there. If I remember correctly DESC is a keyword meaning you can't use it. As such all you have to do is replace DESC with description and it should work just fine.

DWS
01-27-2005, 02:15 PM
Originally posted by xachen
It seems that DESC was in there. If I remember correctly DESC is a keyword meaning you can't use it. As such all you have to do is replace DESC with description and it should work just fine.

You're right. "Desc" was used as a field for a table to store "Description" of something. Since it's a reserved word, it spit out an error. There were some other reserved words also used such as Type, From, Check, etc. as a field name that had to be renamed.

Thanks fortress for the prompt payment. :agree: