chrometweaks.org

Can I make a dedicated iPage server into a FMS?

Click Here To View All Answers...


Got a question... Can I make a dedicated iPage server into a FMS? Thanks in advance for any response. My 2nd question... Hello..

In the Admin area, when clicking on:.

Reports/Products Purchased or Customer Orders-Total.

I get the following 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 '-20, 20' at line 1.

Select p.products_id, p.products_ordered, pd.products_name from products p, products_description pd where pd.products_id = p.products_id and pd.language_id = '1' and p.products_ordered > 0 group by pd.products_id order by p.products_ordered DESC, pd.products_name limit -20, 20.

[TEP STOP].

Further info:.

-mysql Ver 14.3 Distrib 4.1.1-alpha, for pc-linux (i686).

OsC (latest).

PHP Version 4.3.2.

Uname -a: 2.4.20-28.7 #1.

Installed contributions: advanced search, categories box with bullets and lines..

Thanks to anyone that will help...

Comments (58)

Yes sir! however you might want to make sure and wait for someone else to confirm this as I am not very confident. Better yet, why don't you email the iPage guys because they can give you an answer better...

Comment #1

Mm, you have an error here as well:.

Products_description pd..

Comment #2

-20 should be 0 or a positive number I believe - try 0...

Comment #3

These are okay, I believe, they are just aliases for the table names..

This post has been edited by.

Yesudo.

: 12 June 2004, 14:16..

Comment #4

Got the problem: mysqld Ver 4.1.1-alpha-standard for pc-linux on i686 (Official MySQL RPM).

I downgraded the mysql version and it works just fine..

Thanks for your help anyways..

Comment #5

Hello..

In the Admin area, when clicking on:.

Reports/Products Purchased or Customer Orders-Total.

I get the following 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 '-20, 20' at line 1.

Select p.products_id, p.products_ordered, pd.products_name from products p, products_description pd where pd.products_id = p.products_id and pd.language_id = '1' and p.products_ordered > 0 group by pd.products_id order by p.products_ordered DESC, pd.products_name limit -20, 20.

[TEP STOP].

Further info:.

-mysql Ver 14.3 Distrib 4.1.1-alpha, for pc-linux (i686).

OsC (latest).

PHP Version 4.3.2.

Uname -a: 2.4.20-28.7 #1.

Installed contributions: advanced search, categories box with bullets and lines..

Thanks to anyone that will help...

Comment #6

Typo/error in the code:.

From products p.

I don't know what should go there, but I know it's not that..

You need to enter the proper table name for those fields it's selecting from..

W/o looking at the tables, I believe it should simply be 'products' (w/o the quotes).

This post has been edited by.

Acheron.

: 12 June 2004, 14:11..

Comment #7


This question was taken from a support group/message board and re-posted here so others can learn from it.