chrometweaks.org

My iPage page is not displaying?

Click Here To View All Answers...


My question is My iPage page is not displaying? Many thanks for any response. Another question I got... Hi.

I have installed a new OsCommerce iPage site and have the folowing problem .....

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 '-9, 9' at line 1.

Select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added DESC limit -9, 9.

[TEP STOP].

I have looked online and in these forums, but cant find a fix for it..

The above error message appears when loading up the Specials page..

I have made adjustments to the split_page_results.php file, but the error still remains.

Can anyone solve this for me?.

Thanks.

Darren..

Comments (78)

Good question... I dunno what is the answer. I'll do some poking around and get back to you if I got an decent answer. You should email the people at iPage as they probably could give you help..

Comment #1

I have the same issue with my template I just installed. The template was supposed to be completely compatible with newest 2.x version and that is what I have installed. I cannot find how to fix this issue either. Some guidance on how to fix this would be appreciated..

Thanks,.

Kevin..

Comment #2

The patches file in my signature block should help..

Http://svn.oscommerce.com/jira/browse/OSC-...rator=printable.

This post has been edited by.

Geoffreywalton.

: 22 March 2009, 07:27..

Comment #3

Hi.

I have looked at your signatures but cant find the fix. Can you post it for me?.

Thanks.

Darren..

Comment #4

I thought the limit -20, 20 might be similar..

G..

Comment #5

That worked perfect for my site. Thanks. I only had to use half the fix since the I didn't find this line in my split_page_results.php.

Line 38 in catalog/admin/includes/classes/split_page_results.php must be changed from:.

$sql_query .= " limit "$offset", "$max_rows_per_page;.

I tried using only the first half of the fix since it was part of my templates makeup and it worked out perfect..

Thank you again for that quick fix and that is a great link you have in your sig for those types of issues..

Kevin..

Comment #6

This is the page his link refers to it is the one in his sig that says mysql fixes and patches..

Http://www.oscommerc...te-20060817.txt.

Kevin..

Comment #7

Hi.

I have installed a new OsCommerce iPage site and have the folowing problem .....

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 '-9, 9' at line 1.

Select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added DESC limit -9, 9.

[TEP STOP].

I have looked online and in these forums, but cant find a fix for it..

The above error message appears when loading up the Specials page..

I have made adjustments to the split_page_results.php file, but the error still remains.

Can anyone solve this for me?.

Thanks.

Darren..

Comment #8

It appears you've installed an older version that has a problem in the code. Be sure you have installed the latest version. Ccheck my signature to see how to do that..

Jack..

Comment #9


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