HUGE PROBLEM With Mambo Versions 4.5.1, 4.5.2, and 4.5.3! - Page 2 - Mambo

goobaka · December 2nd, 2005, 07:13

what file are we supposed to edit?

goobaka · December 2nd, 2005, 07:43

i keep trying this "fix" it does not seem to be working for me??
can anyone help?
Thanks!

muckster · December 2nd, 2005, 10:02

Is this the problem I'm suddenly seeing on my site, http://jurgenfauth.com?

I get the following error messages on top of the page:

Quote:

Warning: Cannot modify header information - headers already sent by (output started at /home/jurgen/public_html/configuration.php:66) in /home/jurgen/public_html/includes/mambo.php on line 302

Warning: Cannot modify header information - headers already sent by (output started at /home/jurgen/public_html/configuration.php:66) in /home/jurgen/public_html/includes/mambo.php on line 711

Warning: Cannot modify header information - headers already sent by (output started at /home/jurgen/public_html/configuration.php:66) in /home/jurgen/public_html/index.php on line 194

Warning: Cannot modify header information - headers already sent by (output started at /home/jurgen/public_html/configuration.php:66) in /home/jurgen/public_html/index.php on line 195

Warning: Cannot modify header information - headers already sent by (output started at /home/jurgen/public_html/configuration.php:66) in /home/jurgen/public_html/index.php on line 196

Warning: Cannot modify header information - headers already sent by (output started at /home/jurgen/public_html/configuration.php:66) in /home/jurgen/public_html/index.php on line 197

Warning: Cannot modify header information - headers already sent by (output started at /home/jurgen/public_html/configuration.php:66) in /home/jurgen/public_html/index.php on line 198

I also can't log into my administration any more. Disaster!

Edit: I should probably mention I'm using 4.5.2.

chanh · December 22nd, 2005, 07:14

Quote:

Originally Posted by stimpsy

I think he forgot the end of the first line.

The correct code is:

$query = "SELECT c.*, g.name AS groupname, cc.name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name, v.name AS author"
. "\n FROM #__content AS c" //, #__categories AS cc, #__sections AS s"
. "\n LEFT JOIN #__groups AS g ON g.id = c.access"
. "\n LEFT JOIN #__users AS u ON u.id = c.checked_out"
. "\n LEFT JOIN #__users AS v ON v.id = c.created_by"
. "\n LEFT JOIN #__content_frontpage AS f ON f.content_id = c.id"
. "\n LEFT OUTER JOIN #__categories AS cc ON c.catid=cc.id"
. "\n LEFT OUTER JOIN #__sections AS s ON cc.section=s.id"
. ( count( $where ) ? "\nWHERE " . implode( ' AND ', $where ) : '' )
. $order
. "\n LIMIT $pageNav->limitstart,$pageNav->limit"
;

The above fix effectively comment out the two tables that needed for the code to get the right result and might cause some side affect.

This is the hack that I did on my WAMP5 and it runs perfectly.

On line 203 of admin.content.php I made this change and it works.
. "\n FROM #__categories AS cc, #__sections AS s, #__content AS c "

This is due to Mysql5 is more strict on parse the code.

Enjoy!

counterpoint · December 22nd, 2005, 10:16

The correction suggested above is liable to cause problems. It suppresses the immediate problem, but changes the meaning of the SQL statement. The best solution is to change the order of the first two tables, so that the full SQL statement reads (starting from line 200 of admin.content.php):

PHP Code:


			
$query = "SELECT c.*, g.name AS groupname, cc.name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name, v.name AS author"

    . "\n FROM #__categories AS cc, #__sections AS s, #__content AS c"

    . "\n LEFT JOIN #__groups AS g ON g.id = c.access"

    . "\n LEFT JOIN #__users AS u ON u.id = c.checked_out"

    . "\n LEFT JOIN #__users AS v ON v.id = c.created_by"

    . "\n LEFT JOIN #__content_frontpage AS f ON f.content_id = c.id"

    . ( count( $where ) ? "\nWHERE " . implode( ' AND ', $where ) : '' )

    . $order

    . "\n LIMIT $pageNav->limitstart,$pageNav->limit"

    ;

The only actual change is in line 201 which has been changed to:

PHP Code:


			
. "\n FROM #__categories AS cc, #__sections AS s, #__content AS c"

with "content AS c" now the last of the group of tables rather than the first. You also need to make a similar change at line 312.

This will all be in the patch to be released around the end of the year. Please do NOT just comment out some of the tables.

menriquedigital · February 3rd, 2006, 09:56

Hello, I have the same problem. I am working whit mambo 4.5.3 and mysql 5.0.15 and I tried to replace the lines described but I can find its. I search in the code of database.php. So is in that file where I must to replace the code or in my mambo versión the code changed? So please help me.

thanks
menriquedigital

counterpoint · February 4th, 2006, 01:20

The problem is in the file /administrator/components/com_content/admin.content.php.

-ynk · May 14th, 2006, 14:12

I have this problem

Parse error: syntax error, unexpected T_AS in C:\wamp\www\web\administrator\components\com_conte nt\admin.content.php on line 211

MajorGlory · June 19th, 2006, 15:50

You guys ROCK! I' ve just spend over two days upgrading and downgrading everything on my server...and here' s a solution!

Right now I'm still a total noob....but I will not forget this help if I hear others need assistence...

As soon as i understand more, i will help out on this forum!

Greetz,

MajorGlory

inagmamboAko · June 19th, 2006, 16:19

Quote:

Originally Posted by MajorGlory

You guys ROCK! I' ve just spend over two days upgrading and downgrading everything on my server...and here' s a solution!

Right now I'm still a total noob....but I will not forget this help if I hear others need assistence...
As soon as i understand more, i will help out on this forum!
Greetz,
MajorGlory

MajorGlory you rock too!

Your promise will be bookmarked.

Thanks for your thoughtfulness.

MajorGlory · June 22nd, 2006, 06:50

Back again guys... The solution worked for the All Content Items, but it created a new problem on another level. The Archive manager is now giving an 1054 error... I searched the forum and found several solutions. they are not working however. Main problem with the given solution is that the code that needs to be changed is not in my admin.content.php. For example, I can not find the line "limit 0,10". It is part of the lines I'm supposed to change, but I just can't find it... Anybody have a clue?

(by the way, about my earlier promise, I just fixed the other problem for a new user on a general php forum) hope he doesn't get this problem too tough... That would make me feel pretty stupid (here's a solution, by the way it fixes one problem, but causes another lol).

MajorGlory · June 22nd, 2006, 07:02

Found it! Here it is for anyone still struggeling with these problems. It fixes both problems at the same time:

On mysql5 the joining of tables has other rules...
you can can change 2 lines for a working mambo :-)

file: admin.content.php line 201
old: . "\n FROM , #__content AS c, #__categories AS cc, #__sections AS s"
new: . "\n FROM #__categories AS cc, #__sections AS s, #__content AS c "

simply move the content AS c to the end.

also: Line 312
old: . "\n FROM , #__content AS c, #__categories AS cc, #__sections AS s"
new: . "\n FROM #__categories AS cc, #__sections AS s, #__content AS c "

then the content and archive works...

By the way all credit for this fix goes out to Taran! He found it, and I found his solution on this forum. It is important to first replace your admin.content.php with the original version, then apply these changes. In an already altered admin.content it does not seem to work.

Greetz,

Major Glory

flausch · September 26th, 2006, 00:59

with mysql5, the precedence of the comma operator is lower compared to JOIN, LEFT JOIN, and so forth.

in other words: just put the from-part into braces. i.e. "select * from foo, bar" becomes "select * from (foo, bar)" ... and that's it. EOF.

sirHOAX · October 10th, 2006, 05:45

Yea, was working on my website all weekend after upgrades from slackware10 to slackware11 on my local web-server. Wasn't really playing around with adding content. Then this morning I checked to see my content.

Scared the hell out of me, thought I would have to regress back to linux slackware-10 install. Thanks for the fix on the admin.content.php code. You guys are great.

Thanks again, have a great day.

Regards, SirHOAX-aLiTTLE

chrissie · November 8th, 2006, 10:31

stimpsy

thanks a lot, it helped me out just in time

you're my hero for one day

kpkp · November 28th, 2006, 02:32

Hello!
Your solusion fixed my problem with articles, but now I have problem with PhpShop. PhpShop do not show products. I run debug mode, and recive:

Code:

Unknown column 'mos_pshop_product.product_id'

If I have question to base:

Code:

#__pshop_product_price ON #__pshop_product.product_id = 
#__pshop_product_price.product_id WHERE #__pshop_product_category_xref.category_id=

script should change:

Code:

#__

for

Code:

mos

but it dos not.

It should be:

Code:

mos_pshop_product_category

Can you help me?
Thank you.

jandesbouvries · April 21st, 2007, 10:21

My provider upgraded mysql and didn't inform his clients - so i was afraid i could throw away my site since the content part didn't work any more. thnks to your elegant solution it's back in business! thank you so much!

December 22nd, 2005, 10:16	#25
counterpoint Join Date: Sep 2005 Location: Yorkshire, England Posts: 1,372	The correction suggested above is liable to cause problems. It suppresses the immediate problem, but changes the meaning of the SQL statement. The best solution is to change the order of the first two tables, so that the full SQL statement reads (starting from line 200 of admin.content.php): PHP Code: $query = "SELECT c.*, g.name AS groupname, cc.name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name, v.name AS author" . "\n FROM #__categories AS cc, #__sections AS s, #__content AS c" . "\n LEFT JOIN #__groups AS g ON g.id = c.access" . "\n LEFT JOIN #__users AS u ON u.id = c.checked_out" . "\n LEFT JOIN #__users AS v ON v.id = c.created_by" . "\n LEFT JOIN #__content_frontpage AS f ON f.content_id = c.id" . ( count( $where ) ? "\nWHERE " . implode( ' AND ', $where ) : '' ) . $order . "\n LIMIT $pageNav->limitstart,$pageNav->limit" ; The only actual change is in line 201 which has been changed to: PHP Code: `. "\n FROM #__categories AS cc, #__sections AS s, #__content AS c"` with "content AS c" now the last of the group of tables rather than the first. You also need to make a similar change at line 312. This will all be in the patch to be released around the end of the year. Please do NOT just comment out some of the tables.

February 3rd, 2006, 09:56	#26
menriquedigital Join Date: Jan 2006 Posts: 6	I did not found the lines. Hello, I have the same problem. I am working whit mambo 4.5.3 and mysql 5.0.15 and I tried to replace the lines described but I can find its. I search in the code of database.php. So is in that file where I must to replace the code or in my mambo versión the code changed? So please help me. thanks menriquedigital

September 26th, 2006, 00:59	#33
flausch Join Date: Mar 2006 Posts: 1	the magic solution .. with mysql5, the precedence of the comma operator is lower compared to JOIN, LEFT JOIN, and so forth. in other words: just put the from-part into braces. i.e. "select * from foo, bar" becomes "select * from (foo, bar)" ... and that's it. EOF.

October 10th, 2006, 05:45	#34
sirHOAX Join Date: Sep 2006 Location: LI, NY Posts: 6	Yea, was working on my website all weekend after upgrades from slackware10 to slackware11 on my local web-server. Wasn't really playing around with adding content. Then this morning I checked to see my content. Scared the hell out of me, thought I would have to regress back to linux slackware-10 install. Thanks for the fix on the admin.content.php code. You guys are great. Thanks again, have a great day. Regards, SirHOAX-aLiTTLE __________________ .. Currently Affiliated With Nextech-Inc.com (server-info) Last edited by sirHOAX : October 10th, 2006 at 05:53.

November 28th, 2006, 02:32	#36
kpkp Join Date: Nov 2006 Posts: 4	Unknown column 'mos_pshop_product.product_id' Hello! Your solusion fixed my problem with articles, but now I have problem with PhpShop. PhpShop do not show products. I run debug mode, and recive: Code: Unknown column 'mos_pshop_product.product_id' If I have question to base: Code: #__pshop_product_price ON #__pshop_product.product_id = #__pshop_product_price.product_id WHERE #__pshop_product_category_xref.category_id= script should change: Code: #__ for Code: mos but it dos not. It should be: Code: mos_pshop_product_category Can you help me? Thank you.

December 2nd, 2005, 07:13	#21
goobaka Join Date: Nov 2004 Posts: 10	what file are we supposed to edit?

December 2nd, 2005, 07:43	#22
goobaka Join Date: Nov 2004 Posts: 10	i keep trying this "fix" it does not seem to be working for me?? can anyone help? Thanks!

February 4th, 2006, 01:20	#27
counterpoint Join Date: Sep 2005 Location: Yorkshire, England Posts: 1,372	The problem is in the file /administrator/components/com_content/admin.content.php.

May 14th, 2006, 14:12	#28
-ynk Join Date: May 2006 Posts: 3	I have this problem Parse error: syntax error, unexpected T_AS in C:\wamp\www\web\administrator\components\com_conte nt\admin.content.php on line 211

June 19th, 2006, 15:50	#29
MajorGlory Join Date: Jun 2006 Location: Den Haag, the Netherlands Posts: 3	You guys ROCK! I' ve just spend over two days upgrading and downgrading everything on my server...and here' s a solution! Right now I'm still a total noob....but I will not forget this help if I hear others need assistence... As soon as i understand more, i will help out on this forum! Greetz, MajorGlory

June 22nd, 2006, 06:50	#31
MajorGlory Join Date: Jun 2006 Location: Den Haag, the Netherlands Posts: 3	Back again guys... The solution worked for the All Content Items, but it created a new problem on another level. The Archive manager is now giving an 1054 error... I searched the forum and found several solutions. they are not working however. Main problem with the given solution is that the code that needs to be changed is not in my admin.content.php. For example, I can not find the line "limit 0,10". It is part of the lines I'm supposed to change, but I just can't find it... Anybody have a clue? (by the way, about my earlier promise, I just fixed the other problem for a new user on a general php forum) hope he doesn't get this problem too tough... That would make me feel pretty stupid (here's a solution, by the way it fixes one problem, but causes another lol).

June 22nd, 2006, 07:02	#32
MajorGlory Join Date: Jun 2006 Location: Den Haag, the Netherlands Posts: 3	Found it! Here it is for anyone still struggeling with these problems. It fixes both problems at the same time: On mysql5 the joining of tables has other rules... you can can change 2 lines for a working mambo :-) file: admin.content.php line 201 old: . "\n FROM , #__content AS c, #__categories AS cc, #__sections AS s" new: . "\n FROM #__categories AS cc, #__sections AS s, #__content AS c " simply move the content AS c to the end. also: Line 312 old: . "\n FROM , #__content AS c, #__categories AS cc, #__sections AS s" new: . "\n FROM #__categories AS cc, #__sections AS s, #__content AS c " then the content and archive works... By the way all credit for this fix goes out to Taran! He found it, and I found his solution on this forum. It is important to first replace your admin.content.php with the original version, then apply these changes. In an already altered admin.content it does not seem to work. Greetz, Major Glory

November 8th, 2006, 10:31	#35
chrissie Join Date: Nov 2006 Posts: 2	stimpsy thanks a lot, it helped me out just in time you're my hero for one day

April 21st, 2007, 10:21	#37
jandesbouvries Join Date: Apr 2007 Posts: 1	Thanks MajorGlory! My provider upgraded mysql and didn't inform his clients - so i was afraid i could throw away my site since the content part didn't work any more. thnks to your elegant solution it's back in business! thank you so much!

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
4.5.2 Mambo Module Problem	kovox	Installation Questions	2	May 22nd, 2006 01:32
Atualização de segurança para Mambo 4.5.2	FaBMak	Instalação	8	June 15th, 2005 21:15
Mambo Documentation Resources	kenmcd	Documentation Resources	8	June 2nd, 2005 20:07
Copy all things in Mambo 4.5.1 to Mambo 4.5.2	rsv	Upgrading Questions	1	May 10th, 2005 12:54
Upgrade problem 4.5.1 to 4.5.2! please help	indeago	General Questions	0	March 14th, 2005 13:06