Rooboi Posted June 8, 2007 Share Posted June 8, 2007 Yes i am a newbie on here, and with php, The past 7 months i have been learning about Html, and php. Well i have been running a phpfox site, Good site i may add. Well, I brought a K-rate script here a few months back, And i am just now installing the k-rate script onto a site domain that i own. Well the installing went fine, But i have found an error that i have no idea where to look for this nor do i know much about php or mysql. I will post the error in a second. This error i get each time i go and update my preferences. Everything else works just when updating the preferences i get this error. I have submitted an ticket for help with Krate, but this was two days ago. And i still haven't heard from them. This is a pretty serious matter cause, I need to get this problem fix, So i can move on to other things that i need to do with the site. Any help would be great. I have looked in the manual and everything is right. I am not sure why i get this error. 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 'WHERE q_required=1' at line 1 Failed query: SELECT * FROM WHERE q_required=1 Thanks for your support and help on this. (Sorry if i posted this in the wrong post) Rooboi Quote Link to comment https://forums.phpfreaks.com/topic/54702-i-need-help-with-php-problem/ Share on other sites More sharing options...
btherl Posted June 8, 2007 Share Posted June 8, 2007 The table name is missing from that query. Is there somewhere where you should have configured a table name for mysql? For context, mysql organizes all data into "tables". For example, you might have one table for customers, one for orders, one for products, etc etc Quote Link to comment https://forums.phpfreaks.com/topic/54702-i-need-help-with-php-problem/#findComment-270524 Share on other sites More sharing options...
Rooboi Posted June 8, 2007 Author Share Posted June 8, 2007 there was nothing else it was showing to do on the install no adding more tables or anything.. thats what i dont understand Quote Link to comment https://forums.phpfreaks.com/topic/54702-i-need-help-with-php-problem/#findComment-270531 Share on other sites More sharing options...
Rooboi Posted June 8, 2007 Author Share Posted June 8, 2007 any one? Quote Link to comment https://forums.phpfreaks.com/topic/54702-i-need-help-with-php-problem/#findComment-270541 Share on other sites More sharing options...
jaikar Posted June 8, 2007 Share Posted June 8, 2007 i too agree with btherl... look at this.. Failed query: SELECT * FROM WHERE q_required=1 ... you have to check why the table is missing.... that variable should be dynamic and must be empty for some reason... you have to check that out.. Quote Link to comment https://forums.phpfreaks.com/topic/54702-i-need-help-with-php-problem/#findComment-270580 Share on other sites More sharing options...
navjak Posted June 8, 2007 Share Posted June 8, 2007 And i am just now installing the k-rate script onto a site domain that i own....This error i get each time i go and update my preferences. Everything else works just when updating the preferences i get this error. I understand that you are trying to set some preferences to your site using the K-rate. I think the script needs some kind of parameters or values that you need to give before you run the K-rate script. That value is missed in the sql query and throwed an error. Run the script again and make sure you give all the values that need to run the script. Quote Link to comment https://forums.phpfreaks.com/topic/54702-i-need-help-with-php-problem/#findComment-270645 Share on other sites More sharing options...
Dragen Posted June 8, 2007 Share Posted June 8, 2007 Why don't you just open the file where the error is happening and put in the name of the table here: <?php SELECT * FROM /*table name goes here*/ WHERE q_required=1 ?> Quote Link to comment https://forums.phpfreaks.com/topic/54702-i-need-help-with-php-problem/#findComment-270648 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.