Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1064 - You have an error in your SQL syntax


wibisono

Recommended Posts

i got the problem as below!! When i was upgrde mysql to versin 5!

 

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 'MAX_RANDOM_SELECT_NEW' at line 1

 

select products_id, products_image, products_tax_class_id, products_price from products where products_status = '1' order by products_date_added desc limit MAX_RANDOM_SELECT_NEW

 

[TEP STOP]

could any one help me to solve this problem

 

Thank you in advance.

 

Wibisono :blush:

Link to comment
Share on other sites

MAX_RANDOM_SELECT_NEW

Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Link to comment
Share on other sites

limis may not be negative or null in sql 5

Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Link to comment
Share on other sites

Where i get to start to correct the script that was false??

which file php on package oscomerce would be must be change??

I'm really need your guide sam,

You know that error message make the main index only show the header and left box appear,

for the middle and right box are disappear. it's really make headache.

So please please your kindly advise.

 

Thank you!

Wibisono :(

Link to comment
Share on other sites

Where i get to start to correct the script that was false??

which file php on package oscomerce would be must be change??

I'm really need your guide sam,

You know that error message make the main index only show the header and left box appear,

for the middle and right box are disappear. it's really make headache.

So please please your kindly advise.

WHENEVER YOU SEE SOMETHING WITH CAPITALS it usually means it is a CONSTANT, a special variable in PHP (not meant to be changed, therefore the "constant").

 

MAX_RANDOM_SELECT_NEW is no different. It's it found in your database, table configuration and can be changed in the admin. Configuration->Maximum values->Selection of Random New Products. Should be a number like 10.

 

If you can't find that, you messed up by deleting that from the table configuration.

Link to comment
Share on other sites

WHENEVER YOU SEE SOMETHING WITH CAPITALS it usually means it is a CONSTANT, a special variable in PHP (not meant to be changed, therefore the "constant").

 

MAX_RANDOM_SELECT_NEW is no different. It's it found in your database, table configuration and can be changed in the admin. Configuration->Maximum values->Selection of Random New Products. Should be a number like 10.

 

If you can't find that, you messed up by deleting that from the table configuration.

 

 

Unfortunately, in my admin also got trouble in table configuration. There can not access

but i got the error message

 

1146 - Table 'tryweb.configuration_group' doesn't exist

 

select configuration_group_title from configuration_group where configuration_group_id = '1'

 

[TEP STOP]

 

so what suppose i do ? by deleting that from the table configuration, which one that will be deleting on it?

so the way i should do edit them by msql browser, isn't??

yes actually in my Maximum values->Selection of Random New Products there set up 16( when i used mysql 4 )

and after i upgrade mysql to 5, they gone!!

Could you assist me?

 

thank you

wibisono

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...