[OMG] Mysql Wtf? - Printable Version

[OMG] Mysql Wtf? - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: [OMG] Mysql Wtf? (/showthread.php?tid=554364)

[OMG] Mysql Wtf? - S4MSUNG - 03.01.2015

After i update my Mysql version to latest. i receive this hilarious errors

Code:

C:\Users\Cris\Desktop\Team Cyborg Cops n Robbers\gamemodes\cnr.pwn(6562) : error 035: argument type mismatch (argument 1)
C:\Users\Cris\Desktop\Team Cyborg Cops n Robbers\gamemodes\cnr.pwn(6563) : error 017: undefined symbol "mysql_store_result"
C:\Users\Cris\Desktop\Team Cyborg Cops n Robbers\gamemodes\cnr.pwn(6565) : error 017: undefined symbol "mysql_num_rows"
C:\Users\Cris\Desktop\Team Cyborg Cops n Robbers\gamemodes\cnr.pwn(6569) : error 017: undefined symbol "mysql_retrieve_row"
C:\Users\Cris\Desktop\Team Cyborg Cops n Robbers\gamemodes\cnr.pwn(6571) : error 017: undefined symbol "mysql_get_field"
C:\Users\Cris\Desktop\Team Cyborg Cops n Robbers\gamemodes\cnr.pwn(6579) : error 017: undefined symbol "mysql_free_result"
C:\Users\Cris\Desktop\Team Cyborg Cops n Robbers\gamemodes\cnr.pwn(9907) : error 035: argument type mismatch (argument 1)
C:\Users\Cris\Desktop\Team Cyborg Cops n Robbers\gamemodes\cnr.pwn(9908) : error 017: undefined symbol "mysql_store_result"
C:\Users\Cris\Desktop\Team Cyborg Cops n Robbers\gamemodes\cnr.pwn(9910) : error 017: undefined symbol "mysql_num_rows"
C:\Users\Cris\Desktop\Team Cyborg Cops n Robbers\gamemodes\cnr.pwn(9951) : error 035: argument type mismatch (argument 1)
C:\Users\Cris\Desktop\Team Cyborg Cops n Robbers\gamemodes\cnr.pwn(9952) : error 017: undefined symbol "mysql_store_result"
C:\Users\Cris\Desktop\Team Cyborg Cops n Robbers\gamemodes\cnr.pwn(9954) : error 017: undefined symbol "mysql_num_rows"
C:\Users\Cris\Desktop\Team Cyborg Cops n Robbers\gamemodes\cnr.pwn(9961) : error 017: undefined symbol "mysql_retrieve_row"
C:\Users\Cris\Desktop\Team Cyborg Cops n Robbers\gamemodes\cnr.pwn(9969) : error 017: undefined symbol "mysql_get_field"
C:\Users\Cris\Desktop\Team Cyborg Cops n Robbers\gamemodes\cnr.pwn(9971) : error 017: undefined symbol "mysql_get_field"
C:\Users\Cris\Desktop\Team Cyborg Cops n Robbers\gamemodes\cnr.pwn(9977) : error 017: undefined symbol "mysql_get_field"
C:\Users\Cris\Desktop\Team Cyborg Cops n Robbers\gamemodes\cnr.pwn(9979) : error 017: undefined symbol "mysql_get_field"
C:\Users\Cris\Desktop\Team Cyborg Cops n Robbers\gamemodes\cnr.pwn(9985) : error 017: undefined symbol "mysql_get_field"
C:\Users\Cris\Desktop\Team Cyborg Cops n Robbers\gamemodes\cnr.pwn(9987) : error 017: undefined symbol "mysql_get_field"
C:\Users\Cris\Desktop\Team Cyborg Cops n Robbers\gamemodes\cnr.pwn(10007) : error 017: undefined symbol "mysql_free_result"
C:\Users\Cris\Desktop\Team Cyborg Cops n Robbers\gamemodes\cnr.pwn(14531) : error 035: argument type mismatch (argument 1)
C:\Users\Cris\Desktop\Team Cyborg Cops n Robbers\gamemodes\cnr.pwn(14532) : error 017: undefined symbol "mysql_free_result"
C:\Users\Cris\Desktop\Team Cyborg Cops n Robbers\gamemodes\cnr.pwn(14998) : error 035: argument type mismatch (argument 1)

Compilation aborted.Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase

And also when im starting my server it shows me an error message then shut down my server like this:

Code:

[MYSQL] Could not retrive field

Im so confuse, If im just a dumb and poor kiddo or The mysql is fucked up. ?

Re: [OMG] Mysql Wtf? - Barnwell - 03.01.2015

check your mysql include version

Re: [OMG] Mysql Wtf? - S4MSUNG - 03.01.2015

Quote:

Originally Posted by Barnwell

check your mysql include version

Its mysql-r39-2winzip

Re: [OMG] Mysql Wtf? - Sledgehammer - 03.01.2015

You will have to update your script with the latest functions/ callbacks since R39-2 uses threaded quires.
- https://sampwiki.blast.hk/wiki/MySQL/R33

Re: [OMG] Mysql Wtf? - S4MSUNG - 03.01.2015

Quote:

Originally Posted by Death1300

You will have to update your script with the latest functions/ callbacks since R39-2 uses threaded quires.
- https://sampwiki.blast.hk/wiki/MySQL/R33

SHIIIT Im so confuse. Still the same problem. What do i need to do?

EDIT: Now i get it. You mean i will update my script / edit all mysql codes with the function? Hell no, My script haves million of codes........

EDIT2: When im using the old mysql, The compiler is fine. It has been compiled properly. Without errors / etc.

But when im starting my server it shows me a message:

Code:

[MYSQL] Could not retrieve field

Re: [OMG] Mysql Wtf? - S4MSUNG - 03.01.2015

Problem solved but when im uploading the sql file. This what happens:

Code:

SQL query:


--
-- Database: `tccnrdata`
--

-- --------------------------------------------------------

--
-- Table structure for table `banned`
--

CREATE TABLE IF NOT EXISTS `banned` (
  `User` varchar(24) NOT NULL,
  `Banner` varchar(24) NOT NULL,
  `IP` varchar(50) NOT NULL,
  `Date` varchar(10) NOT NULL,
  `Time` varchar(10) NOT NULL,
  `Reason` varchar(512) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
MySQL said: Documentation

#1046 - No database selected