sql problem

[ildar sl，修改在8 年前。]

Hi all!

Im use
windows 10 (64)
mariadb 10.0.22 (64)
liferay 6.2.3 (ga4)

I do as instructed https://www.liferay.com/web/zsolt.berki/blog/-/blogs/setting-up-valamis-from-github

....
15:04:16,523 WARN [ContainerBackgroundProcessor[StandardEngine[Catalina]]][BaseDB:457] Specified key was too long; max key length is 767 bytes: create index IX_89828F72 on Learn_LFTincanPackage (title, courseID);_ [Sanitized]
15:04:16,524 ERROR [ContainerBackgroundProcessor[StandardEngine[Catalina]]][BaseDB:464] create index IX_89828F72 on Learn_LFTincanPackage (title, courseID);
15:04:16,529 WARN [ContainerBackgroundProcessor[StandardEngine[Catalina]]][BaseDB:457] Specified key was too long; max key length is 767 bytes: create index IX_B6F136A5 on Learn_LFTincanURI (objID, objType);_ [Sanitized]
15:04:16,529 ERROR [ContainerBackgroundProcessor[StandardEngine[Catalina]]][BaseDB:464] create index IX_B6F136A5 on Learn_LFTincanURI (objID, objType);
Loading file:/D:/6.2.3/bundles/tomcat-7.0.42/work/Catalina/localhost/learn-portlet/loader/portlet.properties
ноя 01, 2015 3:04:18 PM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
Loading file:/D:/6.2.3/bundles/tomcat-7.0.42/work/Catalina/localhost/learn-portlet/loader/service.properties
Loading file:/D:/6.2.3/bundles/tomcat-7.0.42/work/Catalina/localhost/learn-portlet/loader/service.properties
47 [ContainerBackgroundProcessor[StandardEngine[Catalina]]] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
50 [ContainerBackgroundProcessor[StandardEngine[Catalina]]] INFO org.quartz.simpl.SimpleThreadPool - Job execution threads will use class loader of thread: ContainerBackgroundProcessor[StandardEngine[Catalina]]
64 [ContainerBackgroundProcessor[StandardEngine[Catalina]]] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
64 [ContainerBackgroundProcessor[StandardEngine[Catalina]]] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.2.1 created.
65 [ContainerBackgroundProcessor[StandardEngine[Catalina]]] INFO org.quartz.simpl.RAMJobStore - RAMJobStore initialized.
65 [ContainerBackgroundProcessor[StandardEngine[Catalina]]] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.2.1) 'DefaultQuartzScheduler' with instanceId 'NON_CLUSTERED'
Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
NOT STARTED.
Currently in standby mode.
Number of jobs executed: 0
Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 threads.
Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support persistence. and is not clustered.

65 [ContainerBackgroundProcessor[StandardEngine[Catalina]]] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'DefaultQuartzScheduler' initialized from default resource file in Quartz package: 'quartz.properties'
65 [ContainerBackgroundProcessor[StandardEngine[Catalina]]] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.2.1
71 [ContainerBackgroundProcessor[StandardEngine[Catalina]]] INFO org.quartz.core.QuartzScheduler - Scheduler DefaultQuartzScheduler_$_NON_CLUSTERED started.

Whence mistakes in sql query?

[Bijan Vakili，修改在8 年前。]

Issue with key size is discussed here:

http://stackoverflow.com/questions/1814532/1071-specified-key-was-too-long-max-key-length-is-767-bytes

So in your case, it'd be something like this:

ALTER TABLE `Learn_LFTincanPackage)` ADD UNIQUE ( title(255), courseID(255) );

Or whatever the actual names are; and the actual lengths you want them be.