Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Reply
error in your SQL syntax; check the manual ...
Old 11-16-2009, 02:33 AM error in your SQL syntax; check the manual ...
Junior Talker

Posts: 1
Name: Anshuman
Trades: 0
Hello:

I have recently shifted my database from one host to another. While I have managed to import all the database tables, I keep on encountering error messages - some that I could take care of and some I couldn't. Below is the example of the latter type:


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 'order ASC' at line 1 for query SELECT t.*, tt.* FROM tip0705_terms AS t INNER JOIN tip0705_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') AND ( t.term_id <> 9 AND t.term_id <> 1 AND t.term_id <> 3 AND t.term_id <> 5 AND t.term_id <> 6 AND t.term_id <> 7 AND t.term_id <> 8 AND t.term_id <> 10 AND t.term_id <> 12 AND t.term_id <> 13 AND t.term_id <> 14 AND t.term_id <> 15 AND t.term_id <> 16 AND t.term_id <> 17 AND t.term_id <> 18 AND t.term_id <> 22 AND t.term_id <> 23 AND t.term_id <> 24 AND t.term_id <> 28 AND t.term_id <> 29 AND t.term_id <> 30 AND t.term_id <> 31 AND t.term_id <> 32 AND t.term_id <> 33 AND t.term_id <> 34 AND t.term_id <> 35 AND t.term_id <> 36 AND t.term_id <> 40 AND t.term_id <> 41 AND t.term_id <> 42 AND t.term_id <> 43 AND t.term_id <> 44 AND t.term_id <> 45 AND t.term_id <> 46 AND t.term_id <> 47 AND t.term_id <> 48 AND t.term_id <> 53 AND t.term_id <> 54 AND t.term_id <> 55 AND t.term_id <> 58 AND t.term_id <> 62 AND t.term_id <> 63 AND t.term_id <> 64 AND t.term_id <> 65 AND t.term_id <> 66 AND t.term_id <> 67 AND t.term_id <> 68 AND t.term_id <> 69 AND t.term_id <> 70 AND t.term_id <> 74 AND t.term_id <> 77 AND t.term_id <> 79 AND t.term_id <> 80 ) ORDER BY order ASC made by require, require_once, include, get_sidebar, locate_template, load_template, require_once, wp_list_categories, get_categories, get_terms

Can you guide me as to what changes I should make in the above?

Thanks,
Anshuman
Anshuman09 is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 11-16-2009, 04:31 AM Re: error in your SQL syntax; check the manual ...
chrishirst's Avatar
Missing! presumed drunk.

Posts: 41,519
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
order is a reserved word in MySQL so should NOT be used for column names
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?
chrishirst is offline
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 11-16-2009, 05:06 AM Re: error in your SQL syntax; check the manual ...
tripy's Avatar
Do not try this at home!

Posts: 3,621
Name: Thierry
Location: I'm the uber Spaminator !
Trades: 0
and if you have used it in a query, I believe you can surround it with back quotes to escape it.
Code:
...
ORDER BY `order`
__________________
Only a biker knows why a dog sticks his head out the window.
tripy is offline
Reply With Quote
View Public Profile Visit tripy's homepage!
 
Reply     « Reply to error in your SQL syntax; check the manual ...
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.41510 seconds with 12 queries