Esx_phone3 problem ! SQL

Abdelhadi_Clips · October 4, 2019, 1:49pm

Any Help Please ?? i need a Sql base for number phone i think !!

TheIndra · October 4, 2019, 2:02pm

Did you import the sql file of your “phone resource”, mostly that one adds a phone_number column to your table

Abdelhadi_Clips · October 4, 2019, 2:11pm

where can i found this resource please ?

TheIndra · October 4, 2019, 2:11pm

Looks like you use esx_phone3, so look in that resource

Abdelhadi_Clips · October 4, 2019, 2:15pm

i can’t found anything !!

TheIndra · October 4, 2019, 2:16pm

If you are encountering that error that means you are running the resource esx_phone3, it’s trying to look for a column “phone_number” but it doesn’t exist that’s why the resource ships with a SQL file which you can import to your database

github.com

ESX-Org/esx_phone/blob/master/esx_phone.sql#L14


	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`identifier` VARCHAR(22) NOT NULL,
	`name` VARCHAR(100) NOT NULL,
	`number` INT(11) NOT NULL,


	PRIMARY KEY (`id`),
	INDEX `index_user_contacts_identifier_name_number` (`identifier`, `name`, `number`)
);


ALTER TABLE `users`
	ADD COLUMN `phone_number` INT(11) NULL,
	ADD UNIQUE INDEX `index_users_phone_number` (`phone_number`);

Abdelhadi_Clips · October 4, 2019, 2:19pm

Thank youuu !!

system · November 3, 2019, 2:20pm

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.