unknown column

[keez123]

Unknown column 'pass_salt' in 'field list'

does anyone know how to fix this?

[skooda]

Unknown column 'pass_salt' in 'field list'

does anyone know how to fix this?

Try removing it.

[keez123]

remove what from where?!

[bladewolf2010]

Well, you could delete it from the query, or you could add it into the database.

[keez123]

i dont know what query..

[lucky3809]

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.

[keez123]

how do i add a field to my database table?

[keez123]

im learning.. slowly but learning

[bladewolf2010]

-.-" Usually text editors have this nice feature called "Find" which is usually ctrl + F for what I use anyways.

[Djkanna]

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.)

[keez123]

delete or add pass_salt?

[keez123]

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

[keez123]

thats the part i dont know

[Djkanna]

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. >_<

[keez123]

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

[keez123]

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

[Djkanna]

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.

[Djkanna]

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

[keez123]

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?

[keez123]

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?

[keez123]

i think i found my problem, there isnt a users.php file or anything

[lucky3809]

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

[keez123]

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

[Newbie]

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