moved to new host and this error---

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 'limit 15' at line 1
in:
[ limit 15]

how do i go about fixing this please?

I find it when I click on the link for the Featured Products

moved to new host following the instructions given in docs here

DarkAngel:

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 'limit 15' at line 1
in:
[ limit 15]

how do i go about fixing this please?

I find it when I click on the link for the Featured Products

moved to new host following the instructions given in docs here

You didn't edit any files did you?

retched:

You didn't edit any files did you?

edit files? for the move? nope reinstalled store software fresh like instructions said then moved the files over from the old host that I downloaded to my comp.

it does not do this in the test store though...just the live one

DarkAngel:

edit files? for the move? nope reinstalled store software fresh like instructions said then moved the files over from the old host that I downloaded to my comp.

it does not do this in the test store though...just the live one

did you have any modifications done to your store? Where exactly are you receiving this error? On the Featured Products Page or on the index? Are you receiving the white page or is this shown?

retched:

did you have any modifications done to your store? Where exactly are you receiving this error? On the Featured Products Page or on the index? Are you receiving the white page or is this shown?

no mods after turning off for maintenence nor before

go to the realms link in my signature and try the link yourself to see it in action

what i typed for error is all of it

Remove all existing products from your Admin > Catalog > Featured section; then the feated page should load but with a message of there being no featured products. Then add a product to your featred to see itbthat arreas correctly.

Let us know how you get on.

JSWeb:

Remove all existing products from your Admin > Catalog > Featured section; then the feated page should load but with a message of there being no featured products. Then add a product to your featred to see itbthat arreas correctly.

Let us know how you get on.

ok, that is one that I did not think of...it has been fun---NOT moving and since the move ATT decided to block our emails to all their subsidaries too and there has been no problem since birth of store just after the move.

will let you know

ok removed all products from the featured list...still the error message and I even opened in a different browser

maybe there is an old file lurking about? I will try re-uploading the files again if have to

DarkAngel:

ok removed all products from the featured list...still the error message and I even opened in a different browser

maybe there is an old file lurking about? I will try re-uploading the files again if have to

I can see the Featured Products Page fine at this moment.

retched:

I can see the Featured Products Page fine at this moment.

yes what i finally did was just remove the files and reup them to the new serve and then they behaved.

possibly one or two of the single-listing template mod was left out---how i have no clue when i upped the entire folder but it did...now all seems to be back to normal

thanks