SA-MP Forums Archive
MySQL Help - 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: MySQL Help (/showthread.php?tid=487330)


MySQL Help - KtotheYle - 12.01.2014

Hello everyone, so I script for a community and we are having errors with MySQL (This is my first time using it but the owner knows how to set it up just not the script wise). This is the error we get in MySQL.txt

Код:
[22:06:05] [ERROR] cache_get_row_int - invalid datatype
[22:06:05] [ERROR] cache_get_row_int - invalid datatype
[22:06:05] [ERROR] cache_get_row_int - invalid datatype
[22:06:05] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('92')
[22:06:05] [ERROR] cache_get_row_int - invalid datatype
[22:06:05] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('93')
[22:06:05] [ERROR] cache_get_row_int - invalid datatype
[22:06:05] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('94')
[22:06:05] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('95')
[22:06:05] [ERROR] cache_get_row_int - invalid datatype
[22:06:05] [ERROR] CMySQLQuery::Execute[OnPlayerLoadToys] - (error #1054) Unknown column 'owner' i
[22:06:05] [ERROR] CMySQLQuery::Execute[OnPlayerLoadToys] - (error #1054) Unknown column 'owner' i
[22:08:26] [ERROR] mysql_tquery - callback parameter count does not match format specifier length
We can see how it says

Код:
[22:06:05] [ERROR] CMySQLQuery::Execute[OnPlayerLoadToys] - (error #1054) Unknown column 'owner' i
[22:06:05] [ERROR] CMySQLQuery::Execute[OnPlayerLoadToys] - (error #1054) Unknown column 'owner' i
but we have checked in there. What we are trying to do is fix the dealership system.

Any help is very much appreciated as we have spent ages on this with no luck.

P.S. Please explain it to us or something as putting the code will help, but not help us understand our problem!

Re: MySQL Help - MatriXgaMer - 12.01.2014

Quote:
Originally Posted by KtotheYle
Посмотреть сообщение
Hello everyone, so I script for a community and we are having errors with MySQL (This is my first time using it but the owner knows how to set it up just not the script wise). This is the error we get in MySQL.txt

Код:
[22:06:05] [ERROR] cache_get_row_int - invalid datatype
[22:06:05] [ERROR] cache_get_row_int - invalid datatype
[22:06:05] [ERROR] cache_get_row_int - invalid datatype
[22:06:05] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('92')
[22:06:05] [ERROR] cache_get_row_int - invalid datatype
[22:06:05] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('93')
[22:06:05] [ERROR] cache_get_row_int - invalid datatype
[22:06:05] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('94')
[22:06:05] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('95')
[22:06:05] [ERROR] cache_get_row_int - invalid datatype
[22:06:05] [ERROR] CMySQLQuery::Execute[OnPlayerLoadToys] - (error #1054) Unknown column 'owner' i
[22:06:05] [ERROR] CMySQLQuery::Execute[OnPlayerLoadToys] - (error #1054) Unknown column 'owner' i
[22:08:26] [ERROR] mysql_tquery - callback parameter count does not match format specifier length
We can see how it says

Код:
[22:06:05] [ERROR] CMySQLQuery::Execute[OnPlayerLoadToys] - (error #1054) Unknown column 'owner' i
[22:06:05] [ERROR] CMySQLQuery::Execute[OnPlayerLoadToys] - (error #1054) Unknown column 'owner' i
but we have checked in there. What we are trying to do is fix the dealership system.

Any help is very much appreciated as we have spent ages on this with no luck.

P.S. Please explain it to us or something as putting the code will help, but not help us understand our problem!
in PHPMYADMIN make a colomn 'owner'

Re: MySQL Help - KtotheYle - 12.01.2014

Quote:
Originally Posted by MatriXgaMer
Посмотреть сообщение
in PHPMYADMIN make a colomn 'owner'
From what the owner is telling me, it is not inserting anything into the database. We use the command /v buy, buy a vehicle, we then do /v list and no vehicles come up.

Here is our error log

Код:
[22:50:35] [ERROR] cache_get_row_int - invalid datatype
[22:50:35] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('92')
[22:50:35] [ERROR] cache_get_row_int - invalid datatype
[22:50:35] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('93')
[22:50:35] [ERROR] cache_get_row_int - invalid datatype
[22:50:35] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('94')
[22:50:35] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('95')
[22:50:35] [ERROR] cache_get_row_int - invalid datatype
[22:52:26] [ERROR] mysql_tquery - callback parameter count does not match format specifier length
[22:52:45] [ERROR] mysql_tquery - callback parameter count does not match format specifier length
Also where were we to add the owner column?

Re: MySQL Help - KtotheYle - 12.01.2014

Any help much appreciated!