MySQL nesukūria eilutės

['Eko]

Problema yra, kad nesukūria eilutės, kai žaidėjas nusiperka biznį. Kodas eilutės kūrimui:

new i = GetFreeVersloIndex();
strins(bInfo[i][Savininkas],name,0);
orm_insert(bInfo[i][BUSINESS_ID], "OnPridejusVersla", "s", i);
orm_update(bInfo[i][BUSINESS_ID]);

stock GetFreeVersloIndex()
{
for(new i; i < MAX_VERSLAI; i++)
{
if(bInfo[i][ID] == 0) return i;
}
return -1;
}

Kadangi nesigavo su mano pačio biznio kūrimu, panaudojau dalį Justas Š. verslų sistemos kūrimo pamoką. http://www.supergames.lt/topic/142368-pamokaverslu-sistema/

 

Noriu visų galimų pastabų

Redaguota Kovo 12, 2014, nario E-Me

[bebras]

Parodyk MySQL log.

 

 

Pažiūrėkim šitą eilutę:

orm_insert(bInfo[i][BUSINESS_ID], "OnPridejusVersla", "s", i);

Užklausa grįžus iškvies "OnPridejusVersla", čia viskas gerai. Papildomų parametrų tipai "s"... String duodi, bet kintamasis "i"  tai int ... ? 

orm_insert(bInfo[i][BUSINESS_ID], "OnPridejusVersla", "s", i);
orm_update(bInfo[i][BUSINESS_ID]);

Katik įrašei naują eilutę, tai kam ją atnaujint dar? :/

Redaguota Kovo 12, 2014, nario Justas Š.

['Eko]

[19:32:11] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "sql", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[19:32:11] [DEBUG] CMySQLHandle::Create - creating new connection..
[19:32:11] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[19:32:11] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[19:32:11] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[19:32:11] [DEBUG] CMySQLConnection::Connect - connection was successful
[19:32:11] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[19:32:11] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `bizniai`", callback: "OnBizniaiLoad", format: "(null)"
[19:32:11] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[19:32:11] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[19:32:11] [DEBUG] CMySQLConnection::Connect - connection was successful
[19:32:11] [DEBUG] CMySQLConnection::Connect - connection was successful
[19:32:11] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[19:32:11] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[19:32:11] [DEBUG] CMySQLConnection::Connect - connection was successful
[19:32:11] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[19:32:11] [DEBUG] CMySQLQuery::Execute[OnBizniaiLoad] - starting query execution
[19:32:11] [DEBUG] CMySQLQuery::Execute[OnBizniaiLoad] - query was successfully executed within 0.486 milliseconds
[19:32:11] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[19:32:11] [DEBUG] Calling callback "OnBizniaiLoad"..
[19:32:11] [DEBUG] cache_get_row_count - connection: 1
[19:32:11] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[19:32:31] [DEBUG] orm_create - table: "zaidejai", connectionHandle: 1
[19:32:31] [DEBUG] COrm::Create - creating new orm object..
[19:32:31] [DEBUG] COrm::Create - orm object created (id: 1)
[19:32:31] [DEBUG] orm_addvar - orm_id: 1, var: 03897890, datatype: 0, varname: "SQL_ID", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 1, var: 03897894, datatype: 2, varname: "Vardas_Pavarde", var_maxlen: 24
[19:32:31] [DEBUG] orm_addvar - orm_id: 1, var: 038978F4, datatype: 2, varname: "Slaptazodis", var_maxlen: 129
[19:32:31] [DEBUG] orm_addvar - orm_id: 1, var: 03897954, datatype: 0, varname: "Pinigai", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 1, var: 03897958, datatype: 0, varname: "EXP", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 1, var: 0389795C, datatype: 0, varname: "Z_HP", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 1, var: 03897960, datatype: 0, varname: "Darbas", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 1, var: 03897964, datatype: 0, varname: "Pasaulis", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 1, var: 03897968, datatype: 0, varname: "Lytis", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 1, var: 0389796C, datatype: 0, varname: "Pirmaskartas", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 1, var: 03897970, datatype: 0, varname: "Adminas", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 1, var: 03897974, datatype: 0, varname: "Uniforma", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 1, var: 03897978, datatype: 0, varname: "TuriUniforma", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 1, var: 0389797C, datatype: 0, varname: "Pasalpa", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 1, var: 03897980, datatype: 0, varname: "Alga", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 1, var: 03897984, datatype: 0, varname: "Rubai", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 1, var: 03897988, datatype: 0, varname: "DeviRubus", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 1, var: 0389798C, datatype: 0, varname: "Direktorius", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 1, var: 03897990, datatype: 0, varname: "Biznis", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 1, var: 03897994, datatype: 0, varname: "Savininkas_1", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 1, var: 03897998, datatype: 0, varname: "Savininkas_2", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 1, var: 0389799C, datatype: 0, varname: "Transportas", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 1, var: 038979A0, datatype: 0, varname: "Remontas", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 1, var: 038979A4, datatype: 1, varname: "pos_x", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 1, var: 038979A8, datatype: 1, varname: "pos_y", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 1, var: 038979AC, datatype: 1, varname: "pos_z", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 1, var: 038979B0, datatype: 0, varname: "Skinas", var_maxlen: 1
[19:32:31] [DEBUG] orm_setkey - orm_id: 1, varname: "Vardas_Pavarde"
[19:32:31] [DEBUG] orm_select - orm_id: 1, callback: "OnPlayerCheck", format: "d"
[19:32:31] [DEBUG] orm_create - table: "transportas", connectionHandle: 1
[19:32:31] [DEBUG] COrm::Create - creating new orm object..
[19:32:31] [DEBUG] COrm::Create - orm object created (id: 2)
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8E80, datatype: 0, varname: "ID", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8E84, datatype: 2, varname: "Savininkas", var_maxlen: 24
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8EE4, datatype: 2, varname: "Plate", var_maxlen: 129
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8F44, datatype: 0, varname: "Model", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8F48, datatype: 0, varname: "Price", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8F4C, datatype: 1, varname: "Degalai", var_maxlen: 1
[19:32:31] [DEBUG] CMySQLQuery::Execute[OnPlayerCheck] - starting query execution
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8F50, datatype: 1, varname: "CarX", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8F54, datatype: 1, varname: "CarY", var_maxlen: 1
[19:32:31] [DEBUG] CMySQLQuery::Execute[OnPlayerCheck] - query was successfully executed within 0.628 milliseconds
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8F58, datatype: 1, varname: "CarZ", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8F5C, datatype: 1, varname: "CarRot", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8F60, datatype: 0, varname: "Locked", var_maxlen: 1
[19:32:31] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8F64, datatype: 0, varname: "mod1", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8F68, datatype: 0, varname: "mod2", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8F6C, datatype: 0, varname: "mod3", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8F70, datatype: 0, varname: "mod4", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8F74, datatype: 0, varname: "mod5", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8F78, datatype: 0, varname: "mod6", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8F7C, datatype: 0, varname: "mod7", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8F80, datatype: 0, varname: "mod8", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8F84, datatype: 0, varname: "mod9", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8F88, datatype: 0, varname: "mod10", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8F8C, datatype: 0, varname: "mod11", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8F90, datatype: 0, varname: "mod12", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8F94, datatype: 0, varname: "mod13", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8F98, datatype: 0, varname: "mod14", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8F9C, datatype: 0, varname: "mod15", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8FA0, datatype: 0, varname: "mod16", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8FA4, datatype: 0, varname: "mod17", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8FA8, datatype: 0, varname: "paintjob", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8FAC, datatype: 0, varname: "colora", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8FB0, datatype: 0, varname: "colorb", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8FB4, datatype: 1, varname: "HP", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8FB8, datatype: 0, varname: "cPanels", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8FBC, datatype: 0, varname: "cDoors", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8FC0, datatype: 0, varname: "cLights", var_maxlen: 1
[19:32:31] [DEBUG] orm_addvar - orm_id: 2, var: 038C8FC4, datatype: 0, varname: "cTires", var_maxlen: 1
[19:32:31] [DEBUG] orm_setkey - orm_id: 2, varname: "Savininkas"
[19:32:31] [DEBUG] orm_select - orm_id: 2, callback: "KuriamMasina", format: "d"
[19:32:31] [DEBUG] orm_select - orm_id: 1, callback: "(null)", format: "(null)"
[19:32:31] [DEBUG] orm_select - orm_id: 2, callback: "SukurtaMasina", format: "d"
[19:32:31] [DEBUG] CMySQLQuery::Execute[KuriamMasina] - starting query execution
[19:32:31] [DEBUG] CMySQLQuery::Execute[KuriamMasina] - query was successfully executed within 0.607 milliseconds
[19:32:31] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[19:32:31] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[19:32:31] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "5"
[19:32:31] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.466 milliseconds
[19:32:31] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '1', data: "labas"
[19:32:31] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '2', data: "39054762"
[19:32:31] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '3', data: "10"
[19:32:31] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '4', data: "95"
[19:32:31] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '5', data: "4"
[19:32:31] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '6', data: "0"
[19:32:31] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '7', data: "0"
[19:32:31] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '8', data: "0"
[19:32:31] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '9', data: "0"
[19:32:31] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '10', data: "0"
[19:32:31] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[19:32:31] [DEBUG] CMySQLQuery::Execute[SukurtaMasina] - starting query execution
[19:32:31] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '11', data: "0"
[19:32:31] [DEBUG] CMySQLQuery::Execute[SukurtaMasina] - query was successfully executed within 0.601 milliseconds
[19:32:31] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[19:32:31] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '12', data: "0"
[19:32:31] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '13', data: "0"
[19:32:31] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '14', data: "0"
[19:32:31] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '15', data: "1"
[19:32:31] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '16', data: "0"
[19:32:31] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '17', data: "0"
[19:32:31] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '18', data: "0"
[19:32:31] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '19', data: "0"
[19:32:31] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '20', data: "0"
[19:32:31] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '21', data: "0"
[19:32:31] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '22', data: "1328.89"
[19:32:31] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '23', data: "351.094"
[19:32:31] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '24', data: "19.5547"
[19:32:31] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '25', data: "188"
[19:32:31] [DEBUG] Calling callback "OnPlayerCheck"..
[19:32:31] [DEBUG] orm_errno - orm_id: 1
[19:32:31] [DEBUG] orm_setkey - orm_id: 1, varname: "SQL_ID"
[19:32:31] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[19:32:31] [DEBUG] Calling callback "KuriamMasina"..
[19:32:31] [DEBUG] orm_errno - orm_id: 2
[19:32:31] [DEBUG] orm_insert - orm_id: 2, callback: "SukurtaMasina", format: "d"
[19:32:31] [DEBUG] orm_setkey - orm_id: 2, varname: "ID"
[19:32:31] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[19:32:31] [DEBUG] Calling callback "SukurtaMasina"..
[19:32:31] [DEBUG] CMySQLQuery::Execute[SukurtaMasina] - starting query execution
[19:32:31] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[19:32:31] [DEBUG] CMySQLQuery::Execute[SukurtaMasina] - query was successfully executed within 4.112 milliseconds
[19:32:31] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[19:32:31] [DEBUG] Calling callback "SukurtaMasina"..
[19:32:31] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[19:32:34] [DEBUG] orm_select - orm_id: 1, callback: "(null)", format: "(null)"
[19:32:34] [DEBUG] orm_select - orm_id: 2, callback: "SukurtaMasina", format: "d"
[19:32:34] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[19:32:34] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.562 milliseconds
[19:32:34] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[19:32:34] [DEBUG] CMySQLQuery::Execute[SukurtaMasina] - starting query execution
[19:32:34] [DEBUG] CMySQLQuery::Execute[SukurtaMasina] - query was successfully executed within 0.578 milliseconds
[19:32:34] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: ""
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '1', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '2', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '3', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '4', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '5', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '6', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '7', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '8', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '9', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '10', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '11', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '12', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '13', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '14', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '15', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '16', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '17', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '18', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '19', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '20', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '21', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '22', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '23', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '24', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '25', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '26', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '27', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '28', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '29', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '30', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '31', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '32', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '33', data: "0"
[19:32:34] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '34', data: ""
[19:32:34] [DEBUG] Calling callback "SukurtaMasina"..
[19:32:34] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[19:32:46] [DEBUG] orm_update - orm_id: 1
[19:32:46] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[19:32:46] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 2.435 milliseconds
[19:32:46] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[19:33:25] [DEBUG] orm_update - orm_id: 1
[19:33:25] [DEBUG] orm_insert - orm_id: 0, callback: "OnPridejusVersla", format: "s"
[19:33:25] [ERROR] "orm_insert" - invalid orm id (id: 0)
[19:33:25] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[19:33:25] [DEBUG] orm_update - orm_id: 0
[19:33:25] [ERROR] "orm_update" - invalid orm id (id: 0)
[19:33:25] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 3.613 milliseconds
[19:33:25] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[19:33:47] [DEBUG] orm_update - orm_id: 1
[19:33:47] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[19:33:47] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 3.836 milliseconds
[19:33:47] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving

Dėl CAR_ID ignoruok, kadangi nesutvarkyta sistema su transportu.

['Eko]

Parodyk MySQL log.

 

 

Pažiūrėkim šitą eilutę:

orm_insert(bInfo[i][BUSINESS_ID], "OnPridejusVersla", "s", i);

Užklausa grįžus iškvies "OnPridejusVersla", čia viskas gerai. Papildomų parametrų tipai "s"... String duodi, bet kintamasis "i"  tai int ... ? 

orm_insert(bInfo[i][BUSINESS_ID], "OnPridejusVersla", "s", i);
orm_update(bInfo[i][BUSINESS_ID]);

Katik įrašei naują eilutę, tai kam ją atnaujint dar? :/

Va paaiškinimo šiokio tokio ir reikėjo. Galvojau, kad format'as kitaip naudojamas. orm_update irgi panaikinau.

 

---

Pagal mane nėra nustatyto orm_id prieš perkant verslą.

[19:43:47] [DEBUG] orm_insert - orm_id: 0, callback: "OnPridejusVersla", format: "i"[19:43:47] [ERROR] "orm_insert" - invalid orm id (id: 0)

Ką praleisti galėjau?

Redaguota Kovo 12, 2014, nario E-Me

[bebras]

Praleidai "orm_create", nes jis gražina ORM ID.

['Eko]

Turiu sukūręs po:

public OnPridejusVersla(index)
{
bInfo[index][ID] = cache_insert_id();
bInfo[index][BUSINESS_ID] = orm_create("bizniai");

ir po

public OnVerslaiLoad()
{
	for(new i; i < cache_get_row_count(); i++)
	{
		bInfo[i][BUSINESS_ID] = orm_create("bizniai");

Pats table irgi tvarkingas pagal mane: http://imgur.com/wEFXVqD

Redaguota Kovo 12, 2014, nario E-Me

['Eko]

Susitvarkiau orm_insert pakeisdamas į "format(query....)" ir mysql_tquery. Viskas veikia, užrakinkit temą, dėkui.