Having a issue (not sure if it is my fault) about re-ignited-phone HOT 7 CLOSED

https://stackoverflow.com/questions/5773570/how-to-fix-variable-sql-mode-cant-be-set-to-the-value-of-null-error Can look at this.

I guess the top part of the sql is from someone dumping it from their database initially. Can try removing it i guess.

ALTER TABLE usersADD COLUMNphone_number` VARCHAR(10) NULL;

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)
)

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)
)

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)
)

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)
)`

from re-ignited-phone.

Yea that didn't seem to fix it RIP but I appreciate the help ill just haft to find a alternative.

from re-ignited-phone.

1. Which verision of MariaDB are you on?
2. How does your connection in the server.cfg look like?

from re-ignited-phone.

@WolfoTheWolf Status?

from re-ignited-phone.

Couldn't get it to work even after that so I just didnt use it

from re-ignited-phone.

Solution:

CREATE TABLE `twitter_accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '0',
  `password` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '0',
  `avatar_url` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

CREATE TABLE `twitter_tweets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `authorId` int(11) NOT NULL,
  `realUser` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL,
  `time` timestamp NOT NULL DEFAULT current_timestamp(),
  `likes` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `FK_twitter_tweets_twitter_accounts` (`authorId`),
  CONSTRAINT `FK_twitter_tweets_twitter_accounts` FOREIGN KEY (`authorId`) REFERENCES `twitter_accounts` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=170 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `twitter_likes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `authorId` int(11) DEFAULT NULL,
  `tweetId` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_twitter_likes_twitter_accounts` (`authorId`),
  KEY `FK_twitter_likes_twitter_tweets` (`tweetId`),
  CONSTRAINT `FK_twitter_likes_twitter_accounts` FOREIGN KEY (`authorId`) REFERENCES `twitter_accounts` (`id`),
  CONSTRAINT `FK_twitter_likes_twitter_tweets` FOREIGN KEY (`tweetId`) REFERENCES `twitter_tweets` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

from re-ignited-phone.

Keep in mind that this will still error out if the tables twitter_accounts, twitter_tweets, or twitter_likes exist in the database. Make sure those do not exist.

from re-ignited-phone.