keez123 Posted August 11, 2012 Share Posted August 11, 2012 Unknown column 'pass_salt' in 'field list' does anyone know how to fix this? Quote Link to comment Share on other sites More sharing options...
skooda Posted August 11, 2012 Share Posted August 11, 2012 Unknown column 'pass_salt' in 'field list' does anyone know how to fix this? Try removing it. Quote Link to comment Share on other sites More sharing options...
keez123 Posted August 11, 2012 Author Share Posted August 11, 2012 remove what from where?! Quote Link to comment Share on other sites More sharing options...
bladewolf2010 Posted August 11, 2012 Share Posted August 11, 2012 Well, you could delete it from the query, or you could add it into the database. Quote Link to comment Share on other sites More sharing options...
keez123 Posted August 11, 2012 Author Share Posted August 11, 2012 i dont know what query.. Quote Link to comment Share on other sites More sharing options...
lucky3809 Posted August 11, 2012 Share Posted August 11, 2012 the pass_salt field is not in your database table, add it, or remove that field from your query if you are not going to add that field or use it. Quote Link to comment Share on other sites More sharing options...
keez123 Posted August 11, 2012 Author Share Posted August 11, 2012 how do i add a field to my database table? Quote Link to comment Share on other sites More sharing options...
keez123 Posted August 11, 2012 Author Share Posted August 11, 2012 im learning.. slowly but learning Quote Link to comment Share on other sites More sharing options...
bladewolf2010 Posted August 11, 2012 Share Posted August 11, 2012 -.-" Usually text editors have this nice feature called "Find" which is usually ctrl + F for what I use anyways. Quote Link to comment Share on other sites More sharing options...
Djkanna Posted August 11, 2012 Share Posted August 11, 2012 There was no need for duplicate threads. The other thread has been locked/deleted, and posts from there have been moved to within this one (sorry if that screws up continuity.) Quote Link to comment Share on other sites More sharing options...
keez123 Posted August 11, 2012 Author Share Posted August 11, 2012 delete or add pass_salt? Quote Link to comment Share on other sites More sharing options...
keez123 Posted August 11, 2012 Author Share Posted August 11, 2012 There was no need for duplicate threads. The other thread has been locked/deleted, and posts from there have been moved to within this one (sorry if that screws up continuity.) thats fine, sorry for doing that Quote Link to comment Share on other sites More sharing options...
keez123 Posted August 11, 2012 Author Share Posted August 11, 2012 thats the part i dont know Quote Link to comment Share on other sites More sharing options...
Djkanna Posted August 11, 2012 Share Posted August 11, 2012 delete or add pass_salt? The delete option, probably isn't a good way to go, as the code requires it. You'll be in for a bit of modification to the code if you were to go for that one. To add it, research SQL and ways to add new fields to tables. On a side note; is this with the standard MCCodes v1, if so they should really fix that. Edit: Meh, SRB has you sorted, I'll go do something else. >_< Quote Link to comment Share on other sites More sharing options...
keez123 Posted August 11, 2012 Author Share Posted August 11, 2012 The delete option, probably isn't a good way to go, as the code requires it. You'll be in for a bit of modification to the code if you were to go for the one. To add it, research SQL and ways to add new fields to tables. On a side note; is this with the standard MCCodes v1, if so they should really fix that. Edit: Meh, SRB has you sorted, I'll go do something else. >_< i dont know what table to add it to, otherwise i know Quote Link to comment Share on other sites More sharing options...
keez123 Posted August 11, 2012 Author Share Posted August 11, 2012 Ok, so you load a page and it has that error, so the page is requesting the field name -- there's your information, it's in the page (.php file, I assume) For adding a row to a database, google will always be helpful, won't it? this error comes up while trying to install Quote Link to comment Share on other sites More sharing options...
Djkanna Posted August 11, 2012 Share Posted August 11, 2012 i dont know what table to add it to, otherwise i know I'd take a wild stab in the dark and say `users`. Find the code that's showing the error, look for the query containing `pass_salt` and then it'll tell you. //Something along the lines of; if my memory of v1 serves me correctly. mysql_query("UPDATE `users` SET `pass_salt` = '' ...); Edit: I've done it again, I'll leave this time I swear. Edit: @SRB; No make your own cuppah. Quote Link to comment Share on other sites More sharing options...
Djkanna Posted August 11, 2012 Share Posted August 11, 2012 (edited) Ok Keez, can you tell me what code and version you are using, since the last I knew, V1 of mc codes didn't have an installation file... AFAIK they added one, when they open sourced it. EDIT: https://github.com/coldblooded01/mccodefree/blob/master/upload/installer.php Edited August 12, 2012 by Djkanna Quote Link to comment Share on other sites More sharing options...
keez123 Posted August 12, 2012 Author Share Posted August 12, 2012 right, before this is what it says Writing game configuration... Unknown column 'pass_salt' in 'field list' i found "writing game configuration..." does this help me at all? Quote Link to comment Share on other sites More sharing options...
keez123 Posted August 12, 2012 Author Share Posted August 12, 2012 In that case, your SQL hasn't been added properly. The SQL has the pass_salt field in there so it's there. https://github.com/coldblooded01/mccodefree/blob/master/upload/dbdata.sql what am i doing with this exactly? Quote Link to comment Share on other sites More sharing options...
keez123 Posted August 12, 2012 Author Share Posted August 12, 2012 i think i found my problem, there isnt a users.php file or anything Quote Link to comment Share on other sites More sharing options...
lucky3809 Posted August 12, 2012 Share Posted August 12, 2012 (edited) i think i found my problem, there isnt a users.php file or anything LOL there is no need for it, the sqls go into your database not in a php file. Your missing the whole concept maybe you should go back to mysql and learn before tempting to go further. Just saying Login to your cpanel and click the "phpmyadmin" Icon and then select your database then select the sql tab and copy and paste the sqls... How hard?! Or upload dbdata.sql to your ftp and start a new installation of mccodes, apparently the dbdata.sql you have does not have the pass_salt field... Edited August 12, 2012 by lucky3809 Quote Link to comment Share on other sites More sharing options...
keez123 Posted August 12, 2012 Author Share Posted August 12, 2012 LOL there is no need for it, the sqls go into your database not in a php file. Your missing the whole concept maybe you should go back to mysql and learn before tempting to go further. Just saying Login to your cpanel and click the "phpmyadmin" Icon and then select your database then select the sql tab and copy and paste the sqls... How hard?! Or upload dbdata.sql to your ftp and start a new installation of mccodes, apparently the dbdata.sql you have does not have the pass_salt field... i realized all of that just after i posted Quote Link to comment Share on other sites More sharing options...
Newbie Posted August 24, 2012 Share Posted August 24, 2012 (edited) goto the file that is causing the error so for example lets say the error was only showing up when you go to gym.php look for the query mysql_query("UPDATE pass_salt ADD blah blah"); just a example if your using v2 should look like this kinda $db->query("UPDATE pass_salt ADD blah blah"); just remove it and make sure the error is not showing once you are done. or you could go to phpmyadmin and add the table in but would be better to just remove the query if its doing nothing. hope this helps a little. Edited August 24, 2012 by Newbie Quote Link to comment 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.