Solid Snake Posted February 13, 2007 Share Posted February 13, 2007 i need some help with doing mysql can anyone help Quote Link to comment Share on other sites More sharing options...
spellbyte ® Posted February 13, 2007 Share Posted February 13, 2007 Re: i need some help can you be more specific as per your needs Quote Link to comment Share on other sites More sharing options...
Solid Snake Posted February 13, 2007 Author Share Posted February 13, 2007 Re: i need some help can you be more specific as per your needs I need my mods put into mysql but im not that good at placing them in the game and i think i might some errors fixed in my scripts Quote Link to comment Share on other sites More sharing options...
spellbyte ® Posted February 13, 2007 Share Posted February 13, 2007 Re: i need some help did the mods not come with instructions on how to install them Quote Link to comment Share on other sites More sharing options...
Solid Snake Posted February 13, 2007 Author Share Posted February 13, 2007 Re: i need some help did the mods not come with instructions on how to install them i have uploaded them to the database but i dont know MySQL Quote Link to comment Share on other sites More sharing options...
UCC Posted February 13, 2007 Share Posted February 13, 2007 Re: i need some help anyone else as confused as I am? Quote Link to comment Share on other sites More sharing options...
Decepti0n Posted February 13, 2007 Share Posted February 13, 2007 Re: i need some help me me me Quote Link to comment Share on other sites More sharing options...
spellbyte ® Posted February 14, 2007 Share Posted February 14, 2007 Re: i need some help i think what we have here is yet another person who knows absolutely jack about programming or how to setup a DB, either that or he has got some bum mods without the SQL queries, or BOTH Quote Link to comment Share on other sites More sharing options...
Solid Snake Posted February 14, 2007 Author Share Posted February 14, 2007 Re: i need some help i think what we have here is yet another person who knows absolutely jack about programming or how to setup a DB, either that or he has got some bum mods without the SQL queries, or BOTH no i know a bit about programming but i have never tried this sort of programming the only bit know is how to put them onto the database its just the quarries i dont get Quote Link to comment Share on other sites More sharing options...
lem0n Posted February 14, 2007 Share Posted February 14, 2007 Re: i need some help have you got the queries? Quote Link to comment Share on other sites More sharing options...
Solid Snake Posted February 14, 2007 Author Share Posted February 14, 2007 Re: i need some help have you got the queries? Yes i got them Quote Link to comment Share on other sites More sharing options...
Vorlen Posted February 14, 2007 Share Posted February 14, 2007 Re: i need some help i think what we have here is yet another person who knows absolutely jack about programming or how to setup a DB, either that or he has got some bum mods without the SQL queries, or BOTH no i know a bit about programming but i have never tried this sort of programming the only bit know is how to put them onto the database its just the quarries i dont get I presume you mean you know how to upload the files, but not update the DATABASE (A database is the mySQL Database, not the file folder.) Take the queries that you have, open phpmyadmin and find your database. Click on it. Click SQL and put the queries there. Hit GO. If there is an error, report it here. Even then, you probably want to learn alot more about coding before actually opening a site. No, I'm not insulting you. I had to do the same when I started. :P Quote Link to comment Share on other sites More sharing options...
Solid Snake Posted February 14, 2007 Author Share Posted February 14, 2007 Re: i need some help i have tried mate could anyone show me an example of creating one Quote Link to comment Share on other sites More sharing options...
Solid Snake Posted February 14, 2007 Author Share Posted February 14, 2007 Re: i need some help ok what have i done wrong here Error SQL query: CREATE TABLE `adminlogs` ( ```adID``` INT( 11 ) NOT NULL AUTO_INCREMENT , ```adUSER``` INT( 11 ) NOT NULL DEFAULT 'default', ```adPOST``` LONGTEXT NOT NULL , ```adGET``` LONGTEXT NOT NULL , ```adTIME``` INT( 11 ) NOT NULL DEFAULT 'default' ) ENGINE = MYISAM MySQL said: Documentation #1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key Quote Link to comment Share on other sites More sharing options...
Solid Snake Posted February 14, 2007 Author Share Posted February 14, 2007 Re: i need some help ok what have i done wrong here Error SQL query: CREATE TABLE `adminlogs` ( ```adID``` INT( 11 ) NOT NULL AUTO_INCREMENT , ```adUSER``` INT( 11 ) NOT NULL DEFAULT 'default', ```adPOST``` LONGTEXT NOT NULL , ```adGET``` LONGTEXT NOT NULL , ```adTIME``` INT( 11 ) NOT NULL DEFAULT 'default' ) ENGINE = MYISAM MySQL said: Documentation #1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key i need to know what i did wrong Quote Link to comment Share on other sites More sharing options...
UCC Posted February 14, 2007 Share Posted February 14, 2007 Re: i need some help In order to use auto_increment, the field must be defined as a primary key Quote Link to comment Share on other sites More sharing options...
Solid Snake Posted February 14, 2007 Author Share Posted February 14, 2007 Re: i need some help In order to use auto_increment, the field must be defined as a primary key i figured that out a very long time ago, now im stuck on users `gender` is the one im stuck on in the users SQL i cant seem to get the default bit right tell me how please Quote Link to comment Share on other sites More sharing options...
Solid Snake Posted February 15, 2007 Author Share Posted February 15, 2007 Re: i need some help i keep getting this message whats wrong Unknown column 'userid' in 'field list' Quote Link to comment Share on other sites More sharing options...
spellbyte ® Posted February 15, 2007 Share Posted February 15, 2007 Re: i need some help well it would appear that you are missing the userid field from your table, post the entire table here and i'll tell u if ur missing anything else Quote Link to comment Share on other sites More sharing options...
Solid Snake Posted February 16, 2007 Author Share Posted February 16, 2007 Re: i need some help well it would appear that you are missing the userid field from your table, post the entire table here and i'll tell u if ur missing anything else Field Type Collation Attributes Null Default Extra Action `userid` int(11) No auto_increment Quote Link to comment Share on other sites More sharing options...
Solid Snake Posted February 16, 2007 Author Share Posted February 16, 2007 Re: i need some help new error Warning: main(global_func.php) [function.main]: failed to open stream: No such file or directory in /home/maddogda/public_html/loggedin.php on line 22 Fatal error: main() [function.require]: Failed opening required 'global_func.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/maddogda/public_html/loggedin.php on line 22 but when i take out the _ from global_func the errors says uknown us_userid` on `on_clause` whats that Quote Link to comment Share on other sites More sharing options...
Solid Snake Posted February 18, 2007 Author Share Posted February 18, 2007 Re: i need some help new error Warning: main(global_func.php) [function.main]: failed to open stream: No such file or directory in /home/maddogda/public_html/loggedin.php on line 22 Fatal error: main() [function.require]: Failed opening required 'global_func.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/maddogda/public_html/loggedin.php on line 22 but when i take out the _ from global_func the errors says uknown us_userid` on `on_clause` whats that that error has gone the bit left is Unknown column 'us.userid' in 'on clause' 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.