1064 - You have an error in your SQL syntax

[daena76]

HELP PLEASE! I am having this error and don't know what to do.

 

 

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 'order by pd.products_name' at line 1

 

select count(p.products_id) as total order by pd.products_name

[♥Vger]

You can do one of two things:

 

1. Read the "1064" link below my signature

2. Go to the forum homepage, locate the "Latest News" link at the top of the page and follow it to download the updated/patched version of osCommerce MS2. This will cure the problem and provide a lot of security patches also.

 

Vger

[Jan Zonjee]

You can do one of two things:

I think it is a bit more than that (although good advice): select count(p.products_id) as total from table_name order by pd.products_name. "from whatever_table(s)" is missing.

[daena76]

I think it is a bit more than that (although good advice): select count(p.products_id) as total from table_name order by pd.products_name. "from whatever_table(s)" is missing.

 

I am a klutz when it comes to explaining problems..so pardon me...below is where my problem appears and maybe someone can actually explain where I can pinpoint the problem

 

>>>> Problem Link <<< , and just click on ANY Category and there shows the error.

 

For some reason it only shows in Categories. Even so, I don't know where to go after..you have to hold my hand and walk me through it?

 

I appreciate your effort in advance...I am desperate and losing customers by the minute

 

Help!

 

daena

[♥Vger]

Try uploading an unedited includes/boxes/categories.php file - unless you have edited it while installing contributions, in which case you will have to compare the code in your edited version against the default code to track down the problem.

 

Vger

[Jan Zonjee]

just click on ANY Category and there shows the error.

Did you add a contribution that uses "FROM" in a query on the index.php page instead of "from". Looks like the class split_page_results gets confused IMHO.

[daena76]

Did you add a contribution that uses "FROM" in a query on the index.php page instead of "from". Looks like the class split_page_results gets confused IMHO.

 

I checked out the "from" solution and no prob there. I replaced the categories.php with a fresh one. Prob is still there :-(

 

I still haven't compared...where can i find a comparison tool for free?

 

If there are still loopholes or tricks I am open to try to get this website running.

 

Thanks!

 

daena

[♥Vger]

Both Text Pad and Crimson Editor have a Compare Files utility. They are both available as free downloads.

 

Vger

[daena76]

Both Text Pad and Crimson Editor have a Compare Files utility. They are both available as free downloads.

 

Vger

 

Thank you guys for all the ideas and help! I really appreciate it. Although suggestions came in handy the prob was somehow at index.php. I replaced the file with a new one and apparently it did it. All fixed! Just the little corrupt image besides the "Let's see what we have here" is all i'm going to figure out.

 

Kudos to all brainy and helpful people here esp. Vger & JanZ. :thumbsup: