WampServer

Hi wampserver team


1 - Windows version Windows version 64 bit
2 - Version Wamp Server Version Wamp Server 64bit
3 - Apache Version 2.4.9
4 - PHP Version 5.5.12
5 - MySQL Version 5.6.17
6 - Wamp Server icon color is Green

I have joomla project, in one of the tables i got this alert or error message on the backend

Specified key was too long; max key length is 1000 bytes

the table contane

1 id int(11) AUTO_INCREMENT
2 datetime
3 patient_name int(11)
4 select_a_video varchar(100) utf8_unicode_ci

Patient_name is int(11) is a database-join
selecta_a_video is a file upload

i got this error after i added select a video colomun

each time i add a new row data i got "Specified key was too long; max key length is 1000 bytes" one more time
if i have 10 row data in the table i have this error 10 times
i tried to change between MYISAM and InnoDB
i tried to change between Latin1 and utf8
i tried to change between varchar(100), varchar(50) and text

the problem is here "select_a_video varchar(100) utf8_unicode_ci"

Please help
Remon Adel

Hi

This is not in any way a WAMPServer issue.

I would try taking this up with the Joomla team or the people that wrote the extension/component ect

Sorry not to be more helpful

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

RiggsFolly
Thanks for you respond