[HELP] [GCPHONE] Im having some problems with my gcphone

[GamingNation1]

Hello, I am having problems with my gcphone, when I try to call someone or write a text message, I get this error. Help please!

[script: mysql-async] [MySQL] [ERROR] [gcphone] An error happens for query "INSERT INTO phone_calls ( owner, num, incoming, accepts) VALUES (@owner,?,? ,?): [“taxi”, 1, false] ": ER_BAD_NULL_ERROR: Column ‘owner’ cannot be null

[statkar]

import properly included .sql becouse you are missing a TABLE owner in your database

[GamingNation1]

this is the sql

---

– Hôte : 127.0.0.1

– Version du serveur: 10.3.7-MariaDB - mariadb.org binary distribution

– SE du serveur: Win64

– HeidiSQL Version: 9.5.0.5196

---

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET NAMES utf8 */;

/*!50503 SET NAMES utf8mb4 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=‘NO_AUTO_VALUE_ON_ZERO’ */;

ALTER TABLE users ADD COLUMN phone_number VARCHAR(10) NULL;

– Export de la structure de la table gtarp. phone_app_chat

CREATE TABLE IF NOT EXISTS phone_app_chat (

id int(11) NOT NULL AUTO_INCREMENT,

channel varchar(20) NOT NULL,

message varchar(255) NOT NULL,

time timestamp NOT NULL DEFAULT current_timestamp(),

PRIMARY KEY (id)

) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;

– Les données exportées n’étaient pas sélectionnées.

– Export de la structure de la table gtarp. phone_calls

CREATE TABLE IF NOT EXISTS phone_calls (

id int(11) NOT NULL AUTO_INCREMENT,

owner varchar(10) NOT NULL COMMENT ‘Num tel proprio’,

num varchar(10) NOT NULL COMMENT ‘Num reférence du contact’,

incoming int(11) NOT NULL COMMENT ‘Défini si on est à l’‘origine de l’‘appels’,

time timestamp NOT NULL DEFAULT current_timestamp(),

accepts int(11) NOT NULL COMMENT ‘Appels accepter ou pas’,

PRIMARY KEY (id)

) ENGINE=InnoDB AUTO_INCREMENT=122 DEFAULT CHARSET=utf8;

– Les données exportées n’étaient pas sélectionnées.

– Export de la structure de la table gtarp. phone_messages

CREATE TABLE IF NOT EXISTS phone_messages (

id int(11) NOT NULL AUTO_INCREMENT,

transmitter varchar(10) NOT NULL,

receiver varchar(10) NOT NULL,

message varchar(255) NOT NULL DEFAULT ‘0’,

time timestamp NOT NULL DEFAULT current_timestamp(),

isRead int(11) NOT NULL DEFAULT 0,

owner int(11) NOT NULL DEFAULT 0,

PRIMARY KEY (id)

) ENGINE=MyISAM AUTO_INCREMENT=106 DEFAULT CHARSET=utf8;

– Les données exportées n’étaient pas sélectionnées.

– Export de la structure de la table gtarp. phone_users_contacts

CREATE TABLE IF NOT EXISTS phone_users_contacts (

id int(11) NOT NULL AUTO_INCREMENT,

identifier varchar(60) CHARACTER SET utf8mb4 DEFAULT NULL,

number varchar(10) CHARACTER SET utf8mb4 DEFAULT NULL,

display varchar(64) CHARACTER SET utf8mb4 NOT NULL DEFAULT ‘-1’,

PRIMARY KEY (id)

) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

– Les données exportées n’étaient pas sélectionnées.

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, ‘’) */;

/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

[statkar]

import lookc OK you must check it in your tables, phone_callse are maybe wrong installed check if you have in phone_calls line named OWNER