Reports SSL Problem

[rj122458]

I've dug around the site and tried searching for this error but I haven't found any fix as yet.

If I've posted this in the wrong forum let me know.

This is new install and about the last of my problems before I put in a ssl cert and go live.

 

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

 

Server Info: Any other info needed let me know.

mysql-server-4.1.14-1.FC4.1

php-5.0.4-10.4

httpd-2.0.54-10.2

[Guest]

search tips and tricks for the resolution, this is a common problem with a version of mysql which is newer than what osCommerce uses.

[rj122458]

search tips and tricks for the resolution, this is a common problem with a version of mysql which is newer than what osCommerce uses.

 

 

I have searched Tips and Tricks before and I searched them again tonight for anything new. So far nothing.

I did make a mistake in the title. I'm having a MySQL issue not an SSL problem, at least not yet.

Sorry for the mistake. ;-(

 

If you have ideas as to where to look I'd appreciate it. Thanks.

[AlanR]

Here's a link to a fix:

 

http://www.oscommerce.com/forums/index.php?sho...53entry654653

 

This is also addressed in the update released today:

 

http://www.oscommerce.com/ext/update-20051...l#_Toc119473690

 

I suggest you follow through the update and make all the changes.

[AlanR]

Here's the link to the package:

 

http://www.oscommerce.com/solutions/downloads

 

and the link to the discussion thread:

 

http://www.oscommerce.com/forums/index.php?showtopic=180289

[rj122458]

Here's the link to the package:

 

http://www.oscommerce.com/solutions/downloads

 

and the link to the discussion thread:

 

http://www.oscommerce.com/forums/index.php?showtopic=180289

 

Thanks for the info. That fixed the problem -'20-20'. Stupid qusetion, of all the fixes on that page I only need to worry about the -'20-20' one don't I? Or should I go through them all on that page?

[AlanR]

Stupid question, of all the fixes on that page I only need to worry about the -'20-20' one don't I? Or should I go through them all on that page?

 

I'd go through the entire list and apply all the fixes. Sooner or later you'll run into a problem if you don't. Hosting companies upgrade all the time.

[rj122458]

I'd go through the entire list and apply all the fixes. Sooner or later you'll run into a problem if you don't. Hosting companies upgrade all the time.

 

One more dumb question I hope. I've installed all the updates but stopped short of the MySQL 5.0 compatibility patches as I'm not running 5.0, I have 4.1.14-1.FC4.1

Do I go ahead with those patches or stop there in case it breaks something?

 

I really appreciate your help, as I'm new to oscommerce.

[AlanR]

One more dumb question I hope. I've installed all the updates but stopped short of the MySQL 5.0 compatibility patches as I'm not running 5.0, I have 4.1.14-1.FC4.1

Do I go ahead with those patches or stop there in case it breaks something?

 

I really appreciate your help, as I'm new to oscommerce.

 

I've not done them yet, it'll be later today but I'll do them all. From what I've seen they're just a stricter implementation of the mySQL syntax and backwards compatible. Remember that Harald has pulled the prior downloads so all anyone will find in future is the new one. So he/they must be confident that the changes won't break pre 5.0 setups.

 

I run a test store that I try things on all the time so I'm not afraid to break it. I did make the changes to the databases already (yesterday).

[rj122458]

I've not done them yet, it'll be later today but I'll do them all. From what I've seen they're just a stricter implementation of the mySQL syntax and backwards compatible. Remember that Harald has pulled the prior downloads so all anyone will find in future is the new one. So he/they must be confident that the changes won't break pre 5.0 setups.

 

I run a test store that I try things on all the time so I'm not afraid to break it. I did make the changes to the databases already (yesterday).

Well, I'll go ahead and put them in. Since this is a new install and if it breaks I'll start all over again.

Thanks again for you help. ;-)

[rj122458]

Well, I'll go ahead and put them in. Since this is a new install and if it breaks I'll start all over again.

Thanks again for you help. ;-)

I put the MySQL updates in and near as I can tell it didn't bust anything.

The one thing I don't understand is what do they mean by the following SQL queries need to be performed

 

ALTER TABLE whos_online MODIFY COLUMN last_page_url VARCHAR(255) NOT NULL;

ALTER TABLE customers MODIFY COLUMN customers_default_address_id INTEGER;

ALTER TABLE customers_basket MODIFY COLUMN final_price DECIMAL(15,4);

 

And how do I do that. New to MySQL too.

[AlanR]

I put the MySQL updates in and near as I can tell it didn't bust anything.

The one thing I don't understand is what do they mean by the following SQL queries need to be performed

 

ALTER TABLE whos_online MODIFY COLUMN last_page_url VARCHAR(255) NOT NULL;

ALTER TABLE customers MODIFY COLUMN customers_default_address_id INTEGER;

ALTER TABLE customers_basket MODIFY COLUMN final_price DECIMAL(15,4);

 

And how do I do that. New to MySQL too.

 

You do those using phpMyAdmin. Is it available on your server? It usually is.

 

Open it up and look at the tables in the left column.

 

Select who's_online near the bottom and it will open a new window. At the bottom of that window is a text field.

 

paste ALTER TABLE whos_online MODIFY COLUMN last_page_url VARCHAR(255) NOT NULL;

 

into that text area clearing anything that might already be in there. Click Go.

 

Repeat the same procedure for the next two queries.

[rj122458]

You do those using phpMyAdmin. Is it available on your server? It usually is.

 

Open it up and look at the tables in the left column.

 

Select who's_online near the bottom and it will open a new window. At the bottom of that window is a text field.

 

paste ALTER TABLE whos_online MODIFY COLUMN last_page_url VARCHAR(255) NOT NULL;

 

into that text area clearing anything that might already be in there. Click Go.

 

Repeat the same procedure for the next two queries.

Got it. I think I'm on my way now. Appreciate your help. And quick responses!!