COsborne Posted October 30, 2002 Share Posted October 30, 2002 I tried going to products attributes and got this error: 1064 - You have an error in your SQL syntax near 'MAX_ROW_LISTS_OPTIONS' at line 1 select * from products_options where language_id = '1' order by products_options_id LIMIT 0, MAX_ROW_LISTS_OPTIONS [TEP STOP] its at www.illstreet.com/catalog thanks! Link to comment Share on other sites More sharing options...
Ajeh Posted October 30, 2002 Share Posted October 30, 2002 That error is from your admin section and you gave your catalog address :shock: Look in /admin/products_attributes.php and find: MAX_ROW_LISTS_OPTIONS Check and see if you are missing a ; or something. The select and the MAX_ROW_LISTS_OPTIONS are on seperate lines and different commands. They shouldn't be linked I wouldn't think unless you have some type of add on that is utilizing the MAX_ROW_LISTS_OPTIONS in some manner. The definition for this is in /admin/includes/languages/english/products_attributes.php define('MAX_ROW_LISTS_OPTIONS', 10); You could also check that for some weird error in the definition. Link to comment Share on other sites More sharing options...
COsborne Posted October 30, 2002 Author Share Posted October 30, 2002 Sorry about the link. I think the problem is more along the lines of something that would cause the variables not to be replaced in the text shouldnt MAX_ROW_LISTS_OPTIONS in my error "select * from products_options where language_id = '1' order by products_options_name LIMIT 0, MAX_ROW_LISTS_OPTIONS" be replaced with an integer? the admin link is www.illstreet.com/c4t4dm1n no password yet Link to comment Share on other sites More sharing options...
Ajeh Posted October 30, 2002 Share Posted October 30, 2002 I know your Admin section is missing a lot of definitions. These missing language files could contribute to alot of the errors especially where the MAX_ROWS_LIST_OPTIONS comes from a language file. Link to comment Share on other sites More sharing options...
COsborne Posted October 30, 2002 Author Share Posted October 30, 2002 I dont think I understand. What do I need to do to rectify the problem? I cant edit my products outside of mysqlman. I'll email my details to you and see if you can help me out pls. Thank you. Link to comment Share on other sites More sharing options...
Ajeh Posted October 30, 2002 Share Posted October 30, 2002 In your /c4t4dm1n/includes/languages/english folder you have most of the programs loaded there rather than the english definitions. I do not know if you have changed any definitions but you need to delete the folder /c4t4dm1n/includes/languages/english and reload the /admin/includes/languages/english folder Link to comment Share on other sites More sharing options...
COsborne Posted October 30, 2002 Author Share Posted October 30, 2002 I did as you said and has not rectified the problem. I even downloaded it again from oscommerce.com Is there anyone else who can help? Link to comment Share on other sites More sharing options...
Ajeh Posted October 30, 2002 Share Posted October 30, 2002 There has to be something then with the configure.php Right now, you have the correct language files loaded. But, the programs are not seeing most of them. The program can see some of them, but not all of them. Because of this, you are getting bad page loads as the code is trying to perform calculations with constants that have no value. Example: 12/APPLE is not a valid calculation it expects APPLE to be a value not the word APPLE and that is what is happening on your site. Link to comment Share on other sites More sharing options...
COsborne Posted October 30, 2002 Author Share Posted October 30, 2002 I set up a completely new installation of the admin directory. I downloaded vers. 2.2 again and everything. Im still getting the error even with the oscommerce default database. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.