Reply to thread

Message

The biggest problem is actually:

CREATE INDEX _dta_index_TuningDetail_7_709577566__K2_1_3_4_5_6_7_8_9_10_11_12_13_14_15_16_17_18_19_20_21_22_23_24_25_26 ON TuningDetail
(
idChannel ASC
)
INCLUDE ( idTuning,
name,
provider,
channelType,
channelNumber,
frequency,
countryId,
isRadio,
isTv,
networkId,
transportId,
serviceId,
pmtPid,
freeToAir,
modulation,
polarisation,
symbolrate,
diseqc,
switchingFrequency,
bandwidth,
majorChannel,
minorChannel,
pcrPid,
videoSource,
tuningSource)

And MySQL doesn't support INCLUDE among others.
I've tried to make an universal setupdatabaseform which converts the database.sql into MySQL friendly SQL.
But if people are satisfied with changing the database.sql themselves you can just make the changes samposoft proposes.

<blockquote data-quote="dunkstar" data-source="post: 108602" data-attributes="member: 28804">The biggest problem is actually:CREATE INDEX _dta_index_TuningDetail_7_709577566__K2_1_3_4_5_6_7_8_9_10_11_12_13_14_15_16_17_18_19_20_21_22_23_24_25_26 ON TuningDetail (&nbsp; &nbsp; idChannel ASC)INCLUDE ( idTuning,name,provider,channelType,channelNumber,frequency,countryId,isRadio,isTv,networkId,transportId,serviceId,pmtPid,freeToAir,modulation,polarisation,symbolrate,diseqc,switchingFrequency,bandwidth,majorChannel,minorChannel,pcrPid,videoSource,tuningSource)And MySQL doesn't support INCLUDE among others.I've tried to make an universal setupdatabaseform which converts the database.sql into MySQL friendly SQL.But if people are satisfied with changing the database.sql themselves you can just make the changes samposoft proposes.</blockquote>

[QUOTE="dunkstar, post: 108602, member: 28804"] The biggest problem is actually: CREATE INDEX _dta_index_TuningDetail_7_709577566__K2_1_3_4_5_6_7_8_9_10_11_12_13_14_15_16_17_18_19_20_21_22_23_24_25_26 ON TuningDetail ( idChannel ASC ) INCLUDE ( idTuning, name, provider, channelType, channelNumber, frequency, countryId, isRadio, isTv, networkId, transportId, serviceId, pmtPid, freeToAir, modulation, polarisation, symbolrate, diseqc, switchingFrequency, bandwidth, majorChannel, minorChannel, pcrPid, videoSource, tuningSource) And MySQL doesn't support INCLUDE among others. I've tried to make an universal setupdatabaseform which converts the database.sql into MySQL friendly SQL. But if people are satisfied with changing the database.sql themselves you can just make the changes samposoft proposes. [/QUOTE]