houseoftears Posted February 28, 2003 Share Posted February 28, 2003 Has anyone had issues with MySQL errors in several spots??? I have the problem in my admin section, and my catalog section as well. It's like several of the constants being used aren't defined anywhere, such as MAX_RANDOM_SELECT_NEW. Am I missing something??? Link to comment Share on other sites More sharing options...
Guest Posted February 28, 2003 Share Posted February 28, 2003 I think you maight need to be a little more specific. Link to comment Share on other sites More sharing options...
houseoftears Posted February 28, 2003 Author Share Posted February 28, 2003 for instance, when I go to www.mydomain.com/catalog, it loads, but in column_left.php, it's saying: 1064 - You have an error in your SQL syntax 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] Link to comment Share on other sites More sharing options...
Guest Posted February 28, 2003 Share Posted February 28, 2003 I have the problem in my admin section, and my catalog section as well. It's like several of the constants being used aren't defined anywhere, such as MAX_RANDOM_SELECT_NEW. Am I missing something??? Yes, you are missing something......A define somewhere. Is this from a contribution, a fresh install???? BTW- Those aren't MySQL errors. Link to comment Share on other sites More sharing options...
houseoftears Posted February 28, 2003 Author Share Posted February 28, 2003 yes, it's fresh install from 2.2ms1, on Apache server, MySQL...... where is that constant defined, I can't seem to find it? Link to comment Share on other sites More sharing options...
Guest Posted February 28, 2003 Share Posted February 28, 2003 Ok....take a look at your catalog/includes/boxes/whats_new.php and post the first line of that file. It should look like this: if ($random_product = tep_random_select("select products_id, products_image, products_tax_class_id, products_price from " . TABLE_PRODUCTS . " where products_status = '1' order by products_date_added desc limit " . MAX_RANDOM_SELECT_NEW)) { ?> Link to comment Share on other sites More sharing options...
houseoftears Posted February 28, 2003 Author Share Posted February 28, 2003 if ($random_product = tep_random_select("select products_id, products_image, products_tax_class_id, products_price from " . TABLE_PRODUCTS . " where products_status = '1' order by products_date_added desc limit " . MAX_RANDOM_SELECT_NEW)) { ok, looks the same to me......where is that MAX_RANDOM_SELECT_NEW being set? Link to comment Share on other sites More sharing options...
Guest Posted February 28, 2003 Share Posted February 28, 2003 Also take a look at your dB configurations table. It should have a line that looks like this: 39 New Products Module MAX_DISPLAY_NEW_PRODUCTS 9 Maximum number of new products to display in a category 3 5 NULL 2003-02-20 16:31:06 NULL NULL Link to comment Share on other sites More sharing options...
houseoftears Posted February 28, 2003 Author Share Posted February 28, 2003 sorry, still somewhat new to this software... Is this a db table, or in the configuration.php file??? Link to comment Share on other sites More sharing options...
Guest Posted February 28, 2003 Share Posted February 28, 2003 In the database, configuration table. Link to comment Share on other sites More sharing options...
houseoftears Posted February 28, 2003 Author Share Posted February 28, 2003 OOOHHH OK......found it....so THAT's where all those var's are. :roll: OK, I don't even have that constant in the table, and i only have 21 rows, you seem to have more???? How many total config's should there be in that table? Link to comment Share on other sites More sharing options...
Guest Posted February 28, 2003 Share Posted February 28, 2003 Oh........there are bunches. Have you added products or anything yet? If you haven't, you might just want to rerun the install. Link to comment Share on other sites More sharing options...
houseoftears Posted February 28, 2003 Author Share Posted February 28, 2003 WOW....now that I look at this oscommerce.sql file, I'm seeing that ALOT of these items did not get inserted into the db. WEIRD. I think rather than doing the reinstall, I'm going to try rerunning this SQL file first, and see if it works..... Link to comment Share on other sites More sharing options...
Guest Posted February 28, 2003 Share Posted February 28, 2003 Ok....give that a try. Link to comment Share on other sites More sharing options...
houseoftears Posted February 28, 2003 Author Share Posted February 28, 2003 HOLY MOTHER OF GOD. I'M NOW SEEING THE LIGHT of OSCOMMERCE for the FIRST TIME.... [like stunned chimp staring at the Pantheon] thanks everyone, especially you BirdBrain!!!!! :!: :!: :!: :!: :D Link to comment Share on other sites More sharing options...
Guest Posted February 28, 2003 Share Posted February 28, 2003 Yippee! I'm glad we got you fixed up. Have fun with your shop! Link to comment Share on other sites More sharing options...
houseoftears Posted February 28, 2003 Author Share Posted February 28, 2003 Thanks so much! :idea: :D 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.