SA-MP Forums Archive
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)



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] [ERRORcache_get_field_content_int invalid datatype
[13:59:19 12/31/17] [WARNINGCMySQLResult::GetRowDataByName field not found ("SetupInfo") (Query"SELECT * FROM characters WHERE char_name = 'Jay_Douglas'")
[
13:59:19 12/31/17] [ERRORcache_get_field_content_int invalid datatype
[13:59:19 12/31/17] [WARNINGCMySQLResult::GetRowDataByName field not found ("Gender") (Query"SELECT * FROM characters WHERE char_name = 'Jay_Douglas'")
[
13:59:19 12/31/17] [ERRORcache_get_field_content_int invalid datatype
[13:59:19 12/31/17] [WARNINGCMySQLResult::GetRowDataByName field not found ("RentAt") (Query"SELECT * FROM characters WHERE char_name = 'Jay_Douglas'")
[
13:59:19 12/31/17] [ERRORcache_get_field_content_int invalid datatype 
And yeah these columns exists



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 код:
[ERRORcache_get_field_content_int invalid datatype 



Re: lil problem with mysql - Jumberi - 03.01.2018

can you guys help mee?