square Posted December 27, 2009 Posted December 27, 2009 Hello everyone, I'm new to using oscommerce. I just recently installed it by going through all three steps, but I can't access the "catalog" to get things going. I get a reply saying that there's an error. I am currently at the part of my installation in setting the security for the install files and etc. I did all three or four of these things required by the manual on my files, but no give. I am currently using a linux ubuntu server with a mysql database, but I can't figure out what's wrong. If anyone can please give me some input, it would mean a lot. -square
Jan Zonjee Posted December 27, 2009 Posted December 27, 2009 I am currently using a linux ubuntu server with a mysql database, but I can't figure out what's wrong. We can't either since we don't even know what the error is.
square Posted December 28, 2009 Author Posted December 28, 2009 We can't either since we don't even know what the error is. Sorry about that. The feedback was something like this with an error of: "1142" - SELECT command denied to user '..........' for table 'configuration' select configuration_key as cfgkey, Configuration_value as cfg value from configuration. I'm not sure that this feedback means. Thank you.
Jan Zonjee Posted December 28, 2009 Posted December 28, 2009 "1142" - SELECT command denied to user '..........' for table 'configuration' select configuration_key as cfgkey, Configuration_value as cfg value from configuration. I'm not sure that this feedback means. At least that is a very original error. I don't remember ever having seen that one. It looks like the user account you use for MySQL was granted access to add tables and insert data into it, but not retrieve data from those tables. Very weird. Better ask your hosting provider about this. I think they made an error setting up your user account for MySQL.
square Posted December 28, 2009 Author Posted December 28, 2009 At least that is a very original error. I don't remember ever having seen that one. It looks like the user account you use for MySQL was granted access to add tables and insert data into it, but not retrieve data from those tables. Very weird. Better ask your hosting provider about this. I think they made an error setting up your user account for MySQL. Well, I'm the one actually setting up the mysql database. I would get this warning after completion in addition to the previous error mentioned earlier. Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/catalog/install/includes/functions/database.php on line 39 I am wondering if you might know what may be wrong with my mysql database. Thank you for your time.
Jan Zonjee Posted December 28, 2009 Posted December 28, 2009 Well, I'm the one actually setting up the mysql database. I would get this warning after completion in addition to the previous error mentioned earlier. Then you will have to grant the database user a few more rights (simplest of course grant all to etcetera). Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/catalog/install/includes/functions/database.php on line 39 I am wondering if you might know what may be wrong with my mysql database. Thank you for your time. That is a typical code error where you have a tep_db_fetch_array before a tep_db_query has been done.
square Posted December 28, 2009 Author Posted December 28, 2009 That is a typical code error where you have a tep_db_fetch_array before a tep_db_query has been done. I grant myself privileges to my designated database; so, that's ok. Are you saying I may have to adjust the php code on the "database.php" file or do I have create something I may be missing on my database?
Jan Zonjee Posted December 28, 2009 Posted December 28, 2009 I grant myself privileges to my designated database; so, that's ok. Are you saying I may have to adjust the php code on the "database.php" file or do I have create something I may be missing on my database? Perhaps you didn't grant yourself SELECT priviliges, so the query wouldn't be done. Don't know if that shows up as an error because it is not a normal scenario. Then retrieving the results would give an error if the query hadn't been done. Maybe it is that.
square Posted December 28, 2009 Author Posted December 28, 2009 Perhaps you didn't grant yourself SELECT priviliges, so the query wouldn't be done. Don't know if that shows up as an error because it is not a normal scenario. Then retrieving the results would give an error if the query hadn't been done. Maybe it is that. I granted ALL privileges to myself. Also, I redid the installation by following your protocol on this forum, and I got a new error: Warning: require(includes/configure.php) [function.require]: failed to open stream: No such file or directory in /var/www/catalog/includes/application_top.php on line 28 Fatal error: require() [function.require]: Failed opening required 'includes/configure.php' (include_path='.:/usr/share/php:/usr/share/pear') in /var/www/catalog/includes/application_top.php on line 28 I'm wondering what this may mean. Thank you for your time. -square
Jan Zonjee Posted December 28, 2009 Posted December 28, 2009 I'm wondering what this may mean. Thank you for your time. It could be that the file is not there, or there is an error in your configure.php file. See for example this topic.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.