Пожалуйста помогите.

VuTuV

Участник
Автор темы
51
1
Что за ошибки и как их решить?
[20:54:24 07/29/19] [ERROR] CMySQLQuery::Execute[] - (error #1062) Duplicate entry '14' for key 'PRIMARY' (Query: "INSERT INTO house (id,hEntrx,hEntry,hEntrz,carx,cary,carz,carfa,hClass,hPrice,hInt,hDays,hGarage)VALUES (14,'2771.173828','-290.335144','3.578125','2771.183105','-294.251892','3.231199','272.484100',0,200000,0,1,0)")
[21:01:30 07/29/19] [ERROR] CMySQLQuery::Execute[] - (error #1062) Duplicate entry '13' for key 'PRIMARY' (Query: "INSERT INTO biz (id,x,y,z,xt,yt,zt,menux,menuy,menuz,vint,virt,owner,name,price,product,type,icon,bDays) VALUES (13,'2533.296142','-230.004653','2.574687','-2352.112548','515.544128','1720.939941','-2355.864990','511.384613','1720.939941',6,13,'None','Магазин 24/7 "Деревский магазин',540000,5000,1,56,1)")
[22:02:09 07/29/19] [ERROR] CMySQLQuery::Execute - (error #1146) Table 'gs2313.fullaccess' doesn't exist (Query: "SELECT * FROM fullaccess")
[22:02:09 07/29/19] [WARNING] cache_get_row_count - no active cache
[22:02:54 07/29/19] [ERROR] CMySQLQuery::Execute[@OnAdminGetFullaccess] - (error #1146) Table 'gs2313.fullaccess' doesn't exist (Query: "SELECT * FROM fullaccess WHERE name = 'Kevin_Marvin'")
[22:22:13 07/29/19] [ERROR] CMySQLQuery::Execute[] - (error #1062) Duplicate entry '16' for key 'PRIMARY' (Query: "INSERT INTO biz (id,x,y,z,xt,yt,zt,menux,menuy,menuz,vint,virt,owner,name,price,product,type,icon,bDays) VALUES (16,'629.036193','504.153869','12.205274','-2352.112548','515.544128','1720.939941','-2355.864990','511.384613','1720.939941',6,16,'None','Магазин 24/7 "Ежедвевник"',540000,5000,1,56,1)")
[22:46:45 07/29/19] [ERROR] CMySQLQuery::Execute[] - (error #1062) Duplicate entry '78' for key 'PRIMARY' (Query: "INSERT INTO house (id,hEntrx,hEntry,hEntrz,carx,cary,carz,carfa,hClass,hPrice,hInt,hDays,hGarage)VALUES (78,'1752.545654','2224.718017','16.046312','0.000000','0.000000','0.000000','0.000000',1,300000,0,1,0)")
[23:09:42 07/29/19] [ERROR] CMySQLQuery::Execute[] - (error #1062) Duplicate entry '20' for key 'PRIMARY' (Query: "INSERT INTO biz (id,x,y,z,xt,yt,zt,menux,menuy,menuz,vint,virt,owner,name,price,product,type,icon,bDays) VALUES (20,'2573.230957','-1726.588012','21.499017','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000',0,20,'None','АЗС "Лесная"',500000,20000,2,47,1)")
[06:15:19 07/30/19] [ERROR] CMySQLQuery::Execute[CheckPromo] - (error #1146) Table 'gs2313.promo_activations' doesn't exist (Query: "SELECT * FROM promo_activations WHERE account_id = '6' AND name_promo='VIP'")
[11:11:40 07/30/19] [ERROR] CMySQLQuery::Execute[] - (error #1062) Duplicate entry '82' for key 'PRIMARY' (Query: "INSERT INTO house (id,hEntrx,hEntry,hEntrz,carx,cary,carz,carfa,hClass,hPrice,hInt,hDays,hGarage)VALUES (82,'2567.289062','-952.616333','2.968199','0.000000','0.000000','0.000000','0.000000',3,1500000,0,1,0)")
[11:48:53 07/30/19] [ERROR] CMySQLQuery::Execute[] - (error #1062) Duplicate entry '20' for key 'PRIMARY' (Query: "INSERT INTO biz (id,x,y,z,xt,yt,zt,menux,menuy,menuz,vint,virt,owner,name,price,product,type,icon,bDays) VALUES (20,'2522.590087','-1074.577514','2.994687','-2352.112548','515.544128','1720.939941','-2355.864990','511.384613','1720.939941',6,20,'None','Магазин 24/7 "Ночной"',540000,5000,1,56,1)")
[12:35:38 07/30/19] [ERROR] CMySQLQuery::Execute[] - (error #1062) Duplicate entry '23' for key 'PRIMARY' (Query: "INSERT INTO biz (id,x,y,z,xt,yt,zt,menux,menuy,menuz,vint,virt,owner,name,price,product,type,icon,bDays) VALUES (23,'1451.218872','-363.413757','3.574005','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000',0,23,'None','Заправка "Новый Арзамас"',500000,20000,2,47,1)")
[12:48:06 07/30/19] [ERROR] CMySQLQuery::Execute[] - (error #1062) Duplicate entry '87' for key 'PRIMARY' (Query: "INSERT INTO house (id,hEntrx,hEntry,hEntrz,carx,cary,carz,carfa,hClass,hPrice,hInt,hDays,hGarage)VALUES (87,'394.823364','702.120971','12.758321','409.099822','704.319152','12.085023','342.878326',1,330000,0,1,1)")
[15:04:42 07/30/19] [ERROR] CMySQLQuery::Execute[] - (error #1062) Duplicate entry '34' for key 'PRIMARY' (Query: "INSERT INTO biz (id,x,y,z,xt,yt,zt,menux,menuy,menuz,vint,virt,owner,name,price,product,type,icon,bDays) VALUES (34,'1950.773925','1912.653442','15.465499','473.412506','872.761779','-6.927199','471.903411','882.193115','-6.927199',5,34,'None','Пиццерия ',340000,3000,3,29,1)")
[15:09:19 07/30/19] [ERROR] CMySQLQuery::Execute[] - (error #1062) Duplicate entry '35' for key 'PRIMARY' (Query: "INSERT INTO biz (id,x,y,z,xt,yt,zt,menux,menuy,menuz,vint,virt,owner,name,price,product,type,icon,bDays) VALUES (35,'1951.497680','1899.296508','15.512374','-2352.112548','515.544128','1720.939941','-2355.864990','511.384613','1720.939941',6,35,'None','Магазин 24/7 "Батыревский"',540000,5000,1,56,1)")
[20:45:22 07/30/19] [ERROR] CMySQLQuery::Execute[] - (error #1062) Duplicate entry '97' for key 'PRIMARY' (Query: "INSERT INTO house (id,hEntrx,hEntry,hEntrz,carx,cary,carz,carfa,hClass,hPrice,hInt,hDays,hGarage)VALUES (97,'-2812.219482','-670.952209','9.055128','0.000000','0.000000','0.000000','0.000000',1,500000,0,1,0)")
[21:14:08 07/30/19] [ERROR] CMySQLQuery::Execute[] - (error #1062) Duplicate entry '97' for key 'PRIMARY' (Query: "INSERT INTO house (id,hEntrx,hEntry,hEntrz,carx,cary,carz,carfa,hClass,hPrice,hInt,hDays,hGarage)VALUES (97,'-2812.233154','-670.847961','9.055128','0.000000','0.000000','0.000000','0.000000',1,500000,0,1,0)")
[21:39:00 07/30/19] [ERROR] CMySQLQuery::Execute[] - (error #1062) Duplicate entry '35' for key 'PRIMARY' (Query: "INSERT INTO biz (id,x,y,z,xt,yt,zt,menux,menuy,menuz,vint,virt,owner,name,price,product,type,icon,bDays) VALUES (35,'-2156.997802','115.476463','26.224990','-1772.714843','1773.980712','2377.416015','-1779.501220','1774.663330','2377.416015',5,35,'None','Магазин одежды "Секонд Хенд"',410000,50000,8,45,1)")
[21:39:20 07/30/19] [ERROR] CMySQLQuery::Execute[] - (error #1062) Duplicate entry '36' for key 'PRIMARY' (Query: "INSERT INTO biz (id,x,y,z,xt,yt,zt,menux,menuy,menuz,vint,virt,owner,name,price,product,type,icon,bDays) VALUES (36,'-2167.832763','142.339782','25.752828','-1501.502563','-296.583801','1762.790039','-1498.678100','-301.748687','1762.790039',11,36,'None','Бар "Навигатор"',240000,7000,5,49,1)")
[09:04:59 07/31/19] [ERROR] CMySQLQuery::Execute[] - (error #1062) Duplicate entry '98' for key 'PRIMARY' (Query: "INSERT INTO house (id,hEntrx,hEntry,hEntrz,carx,cary,carz,carfa,hClass,hPrice,hInt,hDays,hGarage)VALUES (98,'2415.277587','-1005.707458','2.948199','2428.614746','-1008.959045','2.991605','352.347412',3,220000,0,1,1)")
[12:27:01 07/31/19] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'veh_reg' in 'field list' (Query: "UPDATE accounts SET veh_reg = 0, veh_number = 'None' WHERE id = 29")
[15:24:35 07/31/19] [ERROR] CMySQLQuery::Execute[] - (error #1062) Duplicate entry '98' for key 'PRIMARY' (Query: "INSERT INTO house (id,hEntrx,hEntry,hEntrz,carx,cary,carz,carfa,hClass,hPrice,hInt,hDays,hGarage)VALUES (98,'-2812.226806','-670.886657','9.055128','0.000000','0.000000','0.000000','0.000000',1,300000,0,1,0)")
 

Gravitos

Активный
397
78
в большинстве: ты пытаешься создать записи, ключи которых уже где-то используются. либо удали те, либо смени ключи на новых.
[12:27:01 07/31/19] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'veh_reg' in 'field list' (Query: "UPDATE accounts SET veh_reg = 0, veh_number = 'None' WHERE id = 29")
670.886657','9.055128','0.000000','0.000000','0.000000','0.000000',1,300000,0,1,0)")
это - ты пытаешься записать данные в несуществующее поле (создать поле или выбрать другое поле для записи)
[06:15:19 07/30/19] [ERROR] CMySQLQuery::Execute[CheckPromo] - (error #1146) Table 'gs2313.promo_activations' doesn't exist (Query: "SELECT * FROM promo_activations WHERE account_id = '6' AND name_promo='VIP'")
[22:02:09 07/29/19] [ERROR] CMySQLQuery::Execute - (error #1146) Table 'gs2313.fullaccess' doesn't exist (Query: "SELECT * FROM fullaccess")
[22:02:09 07/29/19] [WARNING] cache_get_row_count - no active cache
[22:02:54 07/29/19] [ERROR] CMySQLQuery::Execute[@OnAdminGetFullaccess] - (error #1146) Table 'gs2313.fullaccess' doesn't exist (Query: "SELECT * FROM fullaccess WHERE name = 'Kevin_Marvin'")
а здесь ты пишешь в несуществующую таблицу. создай таблицу или пиши в другую.