- Messaggi: 11
- Ringraziamenti ricevuti 0
Error: Notice: Undefined offset: 1
- mosquito12
- Autore della discussione
- Offline
- Nuovo Utente
Less
Di più
11 Anni 11 Mesi fa #1122
da mosquito12
Error: Notice: Undefined offset: 1 è stato creato da mosquito12
Notice: Undefined offset: 1 in /domains/happy-doggy.si/public_html/components/com_customproperties/helper.php on line 332
Can you resolve this....
Can you resolve this....
Si prega Accesso o Crea un account a partecipare alla conversazione.
- andrea_4g
- Offline
- Amministratore
Less
Di più
- Messaggi: 1122
- Ringraziamenti ricevuti 163
11 Anni 11 Mesi fa #1126
da andrea_4g
Risposta da andrea_4g al topic Re: Error: Notice: Undefined offset: 1
The current version of Custom Properties has no instruction at line 332 of that file that is able to throw that error message.
Which version are you using?
Which version are you using?
Si prega Accesso o Crea un account a partecipare alla conversazione.
- mosquito12
- Autore della discussione
- Offline
- Nuovo Utente
Less
Di più
- Messaggi: 11
- Ringraziamenti ricevuti 0
11 Anni 11 Mesi fa - 11 Anni 11 Mesi fa #1130
da mosquito12
Risposta da mosquito12 al topic Re: Error: Notice: Undefined offset: 1
I.m using Version 2.2.2 (2012-04-29). I have installed latest version and this is the error:
Notice: Undefined offset: 1 in /domains/happy-doggy.si/public_html/components/com_customproperties/helper.php on line 434
Bernski planšarski pes
Notice: Undefined offset: 1 in /domains/happy-doggy.si/public_html/components/com_customproperties/helper.php on line 434
Bernski planšarski pes
Ultima Modifica 11 Anni 11 Mesi fa da mosquito12.
Si prega Accesso o Crea un account a partecipare alla conversazione.
- mosquito12
- Autore della discussione
- Offline
- Nuovo Utente
Less
Di più
- Messaggi: 11
- Ringraziamenti ricevuti 0
11 Anni 11 Mesi fa #1131
da mosquito12
Risposta da mosquito12 al topic Re: Error: Notice: Undefined offset: 1
Also, my hosting provider alert me for using to much ram,Cpu,etc.. for the following reason:
Can you help resolve this?
SELECT DISTINCT 'content' AS content_element ,c.id AS id,c.title AS title,c.alias AS title_alias,c.catid AS catid ,c.introtext AS introtext,CONCAT('index.php?option=com_content&view=article','&catid=',
c.catid,':',cat.alias, '&id=', c.id,':',c.alias) AS href,c.created AS created,c.`fulltext` AS `fulltext`,c.images AS images,c.ordering AS ordering,cat.title AS category ,cat.alias AS cat_alias ,cat.lft AS cat_ordering ,c.publish_up AS publish_up,c.publish_down AS publish_down FROM j25_content AS c LEFT JOIN j25_categories AS cat ON(c.catid = cat.id) INNER JOIN j25_custom_properties AS cp0
ON(c.id =
cp0.content_id)
INNER JOIN
j25_custom_properties_values AS v0
ON (cp0.value_id =
v0.id )
INNER JOIN
j25_custom_properties_fields AS f0
ON (v0.field_id =
f0.id )
INNER JOIN j25_custom_properties AS cp1
ON(c.id =
cp1.content_id)
INNER JOIN
j25_custom_properties_values AS v1
ON (cp1.value_id =
v1.id )
INNER JOIN
j25_custom_properties_fields AS f1
ON (v1.field_id =
f1.id )
INNER JOIN j25_custom_properties AS cp2
ON(c.id =
cp2.content_id)
INNER JOIN
j25_custom_properties_values AS v2
ON (cp2.value_id =
v2.id )
INNER JOIN
j25_custom_properties_fields AS f2
ON (v2.field_id =
f2.id )
INNER JOIN j25_custom_properties AS cp3
ON(c.id =
cp3.content_id)
INNER JOIN
j25_custom_properties_values AS v3
ON (cp3.value_id =
v3.id )
INNER JOIN
j25_custom_properties_fields AS f3
ON (v3.field_id =
f3.id )
INNER JOIN j25_custom_properties AS cp4
ON(c.id =
cp4.content_id)
INNER JOIN
j25_custom_properties_values AS v4
ON (cp4.value_id =
v4.id )
INNER JOIN
j25_custom_properties_fields AS f4
ON (v4.field_id =
f4.id )
INNER JOIN j25_custom_properties AS cp5
ON(c.id =
cp5.content_id)
INNER JOIN
j25_custom_properties_values AS v5
ON (cp5.value_id =
v5.id )
INNER JOIN
j25_custom_properties_fields AS f5
ON (v5.field_id =
f5.id )
INNER JOIN j25_custom_properties AS cp6
ON(c.id =
cp6.content_id)
INNER JOIN
j25_custom_properties_values AS v6
ON (cp6.value_id =
v6.id )
INNER JOIN
j25_custom_properties_fields AS f6
ON (v6.field_id =
f6.id )
INNER JOIN j25_custom_properties AS cp7
ON(c.id =
cp7.content_id)
INNER JOIN
j25_custom_properties_values AS v7
ON (cp7.value_id =
v7.id )
INNER JOIN
j25_custom_properties_fields AS f7
ON (v7.field_id =
f7.id )
INNER JOIN j25_custom_properties AS cp8
ON(c.id =
cp8.content_id)
INNER JOIN
j25_custom_properties_values AS v8
ON (cp8.value_id =
v8.id )
INNER JOIN
j25_custom_properties_fields AS f8
ON (v8.field_id =
f8.id )
INNER JOIN j25_custom_properties AS cp9
ON(c.id =
cp9.content_id)
INNER JOIN
j25_custom_properties_values AS v9
ON (cp9.value_id =
v9.id )
INNER JOIN
j25_custom_properties_fields AS f9
ON (v9.field_id =
f9.id )
INNER JOIN j25_custom_properties AS cp10
ON(c.id =
cp10.content_id)
INNER JOIN
j25_custom_properties_values AS v10
ON (cp10.value_id =
v10.id )
INNER JOIN
j25_custom_properties_fields AS f10
ON (v10.field_id =
f10.id )
WHERE (cat.published = '1' OR cat.published IS NULL) AND c.state = '1'
AND c.access in (1,1,
AND cp0.ref_table = 'content'
AND ((f0.name = 'izkusenost_lastnika' AND v0.name = 'prvic_lastnik' AND f0.published='1' AND f0.access IN (1,1, )) AND cp1.ref_table = 'content'
AND ((f1.name = 'kako_velikega_psa_si_zelite' AND v1.name = 'majhnega' AND f1.published='1' AND f1.access IN (1,1, )) AND cp2.ref_table = 'content'
AND ((f2.name = 'tip_dlake_pri_psih' AND v2.name = 'dolga' AND f2.published='1' AND f2.access IN (1,1, ) OR (f2.name = 'tip_dlake_pri_psih' AND v2.name = 'srednje_dolga_dlaka' AND f2.published='1' AND f2.access IN (1,1, ) OR (f2.name = 'tip_dlake_pri_psih' AND v2.name = 'kratka_dlaka' AND f2.published='1' AND f2.access IN (1,1, )) AND cp3.ref_table = 'content'
AND ((f3.name = 'vas_moti_odpadanje_dlak' AND v3.name = 'da' AND f3.published='1' AND f3.access IN (1,1, )) AND cp4.ref_table = 'content'
AND ((f4.name = 'koliko_casa_ste_pripravljeni_posvetiti_negi' AND v4.name = 'vseeno' AND f4.published='1' AND f4.access IN (1,1, )) AND cp5.ref_table = 'content'
AND ((f5.name = 'ste_astmatik_ali_alergik_iscete_hipoalergenega_psa' AND v5.name = 'da' AND f5.published='1' AND f5.access IN (1,1, )) AND cp6.ref_table = 'content'
AND ((f6.name = 'iz_katerega_razloga_si_zelite_psa' AND v6.name = 'prijatelj_v_druzini_z_otroki' AND f6.published='1' AND f6.access IN (1,1,
)) AND cp7.ref_table = 'content'
AND ((f7.name = 'ste_bolj_ali_manj_portno_aktivni_in_hodite_v_n' AND v7.name = 'srednje' AND f7.published='1' AND f7.access IN (1,1, )) AND cp8.ref_table = 'content'
AND ((f8.name = 'na_kako_zahtevno_pasmo_ste_pripravljeni' AND v8.name = 'nezahtevno' AND f8.published='1' AND f8.access IN (1,1, ) OR (f8.name = 'na_kako_zahtevno_pasmo_ste_pripravljeni' AND v8.name = 'srednje_zahtevno'
AND f8.published='1' AND f8.access IN (1,1, ) OR (f8.name = 'na_kako_zahtevno_pasmo_ste_pripravljeni' AND v8.name = 'zahtevno' AND f8.published='1' AND f8.access IN (1,1, )) AND cp9.ref_table = 'content'
AND ((f9.name = 'kje_bo_pes_prenoceval' AND v9.name = 'notri' AND f9.published='1' AND f9.access IN (1,1, )) AND cp10.ref_table = 'content'
AND ((f10.name = 'ze_imate_hisnega_ljubljencka' AND v10.name = 'ne' AND f10.published='1' AND f10.access IN (1,1, )) AND ( c.publish_up =
'0000-00-00 00:00:00' OR c.publish_up <= '2012-12-03 10:26:50' ) AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2012-12-03 10:26:50' ) AND c.catid IN (9) ORDER BY c.title
Can you help resolve this?
SELECT DISTINCT 'content' AS content_element ,c.id AS id,c.title AS title,c.alias AS title_alias,c.catid AS catid ,c.introtext AS introtext,CONCAT('index.php?option=com_content&view=article','&catid=',
c.catid,':',cat.alias, '&id=', c.id,':',c.alias) AS href,c.created AS created,c.`fulltext` AS `fulltext`,c.images AS images,c.ordering AS ordering,cat.title AS category ,cat.alias AS cat_alias ,cat.lft AS cat_ordering ,c.publish_up AS publish_up,c.publish_down AS publish_down FROM j25_content AS c LEFT JOIN j25_categories AS cat ON(c.catid = cat.id) INNER JOIN j25_custom_properties AS cp0
ON(c.id =
cp0.content_id)
INNER JOIN
j25_custom_properties_values AS v0
ON (cp0.value_id =
v0.id )
INNER JOIN
j25_custom_properties_fields AS f0
ON (v0.field_id =
f0.id )
INNER JOIN j25_custom_properties AS cp1
ON(c.id =
cp1.content_id)
INNER JOIN
j25_custom_properties_values AS v1
ON (cp1.value_id =
v1.id )
INNER JOIN
j25_custom_properties_fields AS f1
ON (v1.field_id =
f1.id )
INNER JOIN j25_custom_properties AS cp2
ON(c.id =
cp2.content_id)
INNER JOIN
j25_custom_properties_values AS v2
ON (cp2.value_id =
v2.id )
INNER JOIN
j25_custom_properties_fields AS f2
ON (v2.field_id =
f2.id )
INNER JOIN j25_custom_properties AS cp3
ON(c.id =
cp3.content_id)
INNER JOIN
j25_custom_properties_values AS v3
ON (cp3.value_id =
v3.id )
INNER JOIN
j25_custom_properties_fields AS f3
ON (v3.field_id =
f3.id )
INNER JOIN j25_custom_properties AS cp4
ON(c.id =
cp4.content_id)
INNER JOIN
j25_custom_properties_values AS v4
ON (cp4.value_id =
v4.id )
INNER JOIN
j25_custom_properties_fields AS f4
ON (v4.field_id =
f4.id )
INNER JOIN j25_custom_properties AS cp5
ON(c.id =
cp5.content_id)
INNER JOIN
j25_custom_properties_values AS v5
ON (cp5.value_id =
v5.id )
INNER JOIN
j25_custom_properties_fields AS f5
ON (v5.field_id =
f5.id )
INNER JOIN j25_custom_properties AS cp6
ON(c.id =
cp6.content_id)
INNER JOIN
j25_custom_properties_values AS v6
ON (cp6.value_id =
v6.id )
INNER JOIN
j25_custom_properties_fields AS f6
ON (v6.field_id =
f6.id )
INNER JOIN j25_custom_properties AS cp7
ON(c.id =
cp7.content_id)
INNER JOIN
j25_custom_properties_values AS v7
ON (cp7.value_id =
v7.id )
INNER JOIN
j25_custom_properties_fields AS f7
ON (v7.field_id =
f7.id )
INNER JOIN j25_custom_properties AS cp8
ON(c.id =
cp8.content_id)
INNER JOIN
j25_custom_properties_values AS v8
ON (cp8.value_id =
v8.id )
INNER JOIN
j25_custom_properties_fields AS f8
ON (v8.field_id =
f8.id )
INNER JOIN j25_custom_properties AS cp9
ON(c.id =
cp9.content_id)
INNER JOIN
j25_custom_properties_values AS v9
ON (cp9.value_id =
v9.id )
INNER JOIN
j25_custom_properties_fields AS f9
ON (v9.field_id =
f9.id )
INNER JOIN j25_custom_properties AS cp10
ON(c.id =
cp10.content_id)
INNER JOIN
j25_custom_properties_values AS v10
ON (cp10.value_id =
v10.id )
INNER JOIN
j25_custom_properties_fields AS f10
ON (v10.field_id =
f10.id )
WHERE (cat.published = '1' OR cat.published IS NULL) AND c.state = '1'
AND c.access in (1,1,
AND cp0.ref_table = 'content'
AND ((f0.name = 'izkusenost_lastnika' AND v0.name = 'prvic_lastnik' AND f0.published='1' AND f0.access IN (1,1, )) AND cp1.ref_table = 'content'
AND ((f1.name = 'kako_velikega_psa_si_zelite' AND v1.name = 'majhnega' AND f1.published='1' AND f1.access IN (1,1, )) AND cp2.ref_table = 'content'
AND ((f2.name = 'tip_dlake_pri_psih' AND v2.name = 'dolga' AND f2.published='1' AND f2.access IN (1,1, ) OR (f2.name = 'tip_dlake_pri_psih' AND v2.name = 'srednje_dolga_dlaka' AND f2.published='1' AND f2.access IN (1,1, ) OR (f2.name = 'tip_dlake_pri_psih' AND v2.name = 'kratka_dlaka' AND f2.published='1' AND f2.access IN (1,1, )) AND cp3.ref_table = 'content'
AND ((f3.name = 'vas_moti_odpadanje_dlak' AND v3.name = 'da' AND f3.published='1' AND f3.access IN (1,1, )) AND cp4.ref_table = 'content'
AND ((f4.name = 'koliko_casa_ste_pripravljeni_posvetiti_negi' AND v4.name = 'vseeno' AND f4.published='1' AND f4.access IN (1,1, )) AND cp5.ref_table = 'content'
AND ((f5.name = 'ste_astmatik_ali_alergik_iscete_hipoalergenega_psa' AND v5.name = 'da' AND f5.published='1' AND f5.access IN (1,1, )) AND cp6.ref_table = 'content'
AND ((f6.name = 'iz_katerega_razloga_si_zelite_psa' AND v6.name = 'prijatelj_v_druzini_z_otroki' AND f6.published='1' AND f6.access IN (1,1,
)) AND cp7.ref_table = 'content'
AND ((f7.name = 'ste_bolj_ali_manj_portno_aktivni_in_hodite_v_n' AND v7.name = 'srednje' AND f7.published='1' AND f7.access IN (1,1, )) AND cp8.ref_table = 'content'
AND ((f8.name = 'na_kako_zahtevno_pasmo_ste_pripravljeni' AND v8.name = 'nezahtevno' AND f8.published='1' AND f8.access IN (1,1, ) OR (f8.name = 'na_kako_zahtevno_pasmo_ste_pripravljeni' AND v8.name = 'srednje_zahtevno'
AND f8.published='1' AND f8.access IN (1,1, ) OR (f8.name = 'na_kako_zahtevno_pasmo_ste_pripravljeni' AND v8.name = 'zahtevno' AND f8.published='1' AND f8.access IN (1,1, )) AND cp9.ref_table = 'content'
AND ((f9.name = 'kje_bo_pes_prenoceval' AND v9.name = 'notri' AND f9.published='1' AND f9.access IN (1,1, )) AND cp10.ref_table = 'content'
AND ((f10.name = 'ze_imate_hisnega_ljubljencka' AND v10.name = 'ne' AND f10.published='1' AND f10.access IN (1,1, )) AND ( c.publish_up =
'0000-00-00 00:00:00' OR c.publish_up <= '2012-12-03 10:26:50' ) AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2012-12-03 10:26:50' ) AND c.catid IN (9) ORDER BY c.title
Si prega Accesso o Crea un account a partecipare alla conversazione.
- andrea_4g
- Offline
- Amministratore
Less
Di più
- Messaggi: 1122
- Ringraziamenti ricevuti 163
11 Anni 11 Mesi fa - 11 Anni 11 Mesi fa #1135
da andrea_4g
About you provider complaints, he's right: that query, with a dozen joins and conditions, is heavy. You can either move to a bigger rig or simplify your search engine. Tertium non datur.
Risposta da andrea_4g al topic Re: Error: Notice: Undefined offset: 1
Thanks. That makes sense. We are trying to figure out what could be causing the error. We should be through in a couple of hours.Notice: Undefined offset: 1 in /domains/happy-doggy.si/public_html/components/com_customproperties/helper.php on line 434
About you provider complaints, he's right: that query, with a dozen joins and conditions, is heavy. You can either move to a bigger rig or simplify your search engine. Tertium non datur.
Ultima Modifica 11 Anni 11 Mesi fa da andrea_4g. Motivo: spelling
Si prega Accesso o Crea un account a partecipare alla conversazione.
- andrea_4g
- Offline
- Amministratore
Less
Di più
- Messaggi: 1122
- Ringraziamenti ricevuti 163
11 Anni 11 Mesi fa #1138
da andrea_4g
Risposta da andrea_4g al topic Re: Error: Notice: Undefined offset: 1
Not sure we totally nailed it, because this error is triggered on in some corner cases.
Anyway, here's a patched helper.php file to be unzipped and placed into components/com_customproperties dir.
(Please let us have some feedback)
Anyway, here's a patched helper.php file to be unzipped and placed into components/com_customproperties dir.
(Please let us have some feedback)
Si prega Accesso o Crea un account a partecipare alla conversazione.
Tempo creazione pagina: 0.182 secondi