- Posts: 11
- Thank you received: 0
Error: Notice: Undefined offset: 1
- mosquito12
- Topic Author
- Offline
- New Member
Less
More
11 years 11 months ago #1122
by mosquito12
Error: Notice: Undefined offset: 1 was created by 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....
Please Log in or Create an account to join the conversation.
- andrea_4g
- Offline
- Administrator
Less
More
- Posts: 1122
- Thank you received: 163
11 years 11 months ago #1126
by andrea_4g
Replied by andrea_4g on 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?
Please Log in or Create an account to join the conversation.
- mosquito12
- Topic Author
- Offline
- New Member
Less
More
- Posts: 11
- Thank you received: 0
11 years 11 months ago - 11 years 11 months ago #1130
by mosquito12
Replied by mosquito12 on 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
Last edit: 11 years 11 months ago by mosquito12.
Please Log in or Create an account to join the conversation.
- mosquito12
- Topic Author
- Offline
- New Member
Less
More
- Posts: 11
- Thank you received: 0
11 years 11 months ago #1131
by mosquito12
Replied by mosquito12 on 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
Please Log in or Create an account to join the conversation.
- andrea_4g
- Offline
- Administrator
Less
More
- Posts: 1122
- Thank you received: 163
11 years 11 months ago - 11 years 11 months ago #1135
by 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.
Replied by andrea_4g on 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.
Last edit: 11 years 11 months ago by andrea_4g. Reason: spelling
Please Log in or Create an account to join the conversation.
- andrea_4g
- Offline
- Administrator
Less
More
- Posts: 1122
- Thank you received: 163
11 years 11 months ago #1138
by andrea_4g
Replied by andrea_4g on 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)
Please Log in or Create an account to join the conversation.
Time to create page: 0.184 seconds