lil problem with mysql - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: lil problem with mysql (/showthread.php?tid=647187)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: lil problem with mysql (/showthread.php?tid=647187)
lil problem with mysql - Jumberi - 31.12.2017
I just wanted to test this gamemode http://forum.sa-mp.com/showthread.ph...28#post3973628
so basically i just did everything good, but when i registered character script doesn't saved it so and i checked the mysql logs and these errors popped up if you guys know solution and want to help me reply on this thread
PHP код:
[13:59:19 12/31/17] [ERROR] cache_get_field_content_int - invalid datatype
[13:59:19 12/31/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("SetupInfo") (Query: "SELECT * FROM characters WHERE char_name = 'Jay_Douglas'")
[13:59:19 12/31/17] [ERROR] cache_get_field_content_int - invalid datatype
[13:59:19 12/31/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Gender") (Query: "SELECT * FROM characters WHERE char_name = 'Jay_Douglas'")
[13:59:19 12/31/17] [ERROR] cache_get_field_content_int - invalid datatype
[13:59:19 12/31/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("RentAt") (Query: "SELECT * FROM characters WHERE char_name = 'Jay_Douglas'")
[13:59:19 12/31/17] [ERROR] cache_get_field_content_int - invalid datatype
Re: lil problem with mysql - MEW273 - 31.12.2017
The column names do not match. In your query response callback you are trying to get content from fields SetupInfo, Gender and RentAt - these should be pSetupInfo, pGender and pRentAt as per your screenshot from phpMyAdmin.
Re: lil problem with mysql - 0x88 - 02.01.2018
Add SetupInfo, Gender, RentAt into `characters`, they should be interval and 6 length
Re: lil problem with mysql - Jumberi - 02.01.2018
Quote:
|
Originally Posted by 0x88
 Add SetupInfo, Gender, RentAt into `characters`, they should be interval and 6 length
|
PHP код:
[ERROR] cache_get_field_content_int - invalid datatype
Re: lil problem with mysql - Jumberi - 03.01.2018
can you guys help mee?