DB function failed with error number 1054 - Mambo

vist · November 14th, 2005, 13:54

Hello,

i got this eror in mambo admin: content->allcontent items

DB function failed with error number 1054
Unknown column 'c.access' in 'on clause' SQL=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 FROM mos_content AS c, mos_categories AS cc, mos_sections AS s LEFT JOIN mos_groups AS g ON g.id = c.access LEFT JOIN mos_users AS u ON u.id = c.checked_out LEFT JOIN mos_users AS v ON v.id = c.created_by LEFT JOIN mos_content_frontpage AS f ON f.content_id = c.id WHERE c.state >= 0 AND c.catid=cc.id AND cc.section=s.id AND s.scope='content' ORDER BY s.title, c.catid, cc.ordering, cc.title, c.ordering LIMIT 0,10

counterpoint · November 15th, 2005, 14:36

Are you running MySQL 5? If so, I'm afraid that Mambo is not compatible with it, and cannot be quickly made compatible. The issue will be resolved as part of the Mambo project to achieve multi-platform database support.

taran · December 6th, 2005, 01:23

Quote:

Originally Posted by counterpoint

Are you running MySQL 5? If so, I'm afraid that Mambo is not compatible with it, and cannot be quickly made compatible. The issue will be resolved as part of the Mambo project to achieve multi-platform database support.

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 works...

I´ve found another error, same type:
/administrator/components/com_events/
admin.events.main.php Line 227
change to:
. "\nFROM #__categories AS cc, #__events AS a "

(Simple reorder the '__events AS a' what is used in the next join to the end)

dchai · December 6th, 2005, 02:30

I encountered the same error and the solution helps resolve my issue.

thanks

hazman · January 7th, 2006, 02:53

Hello,

Ok, this seems to be a fix for this problem and I'm going to include a link to this thread in the WAMP5 installation thread.

Thanks Taran

counterpoint · January 7th, 2006, 03:14

This has also been discussed in a lot of other places, with more information given about the problem - and the problem was fixed in the 4.5.3h patch.

hazman · January 7th, 2006, 04:11

Quote:

Originally Posted by counterpoint

- and the problem was fixed in the 4.5.3h patch.

I installed Mambo v4.5.3h and still had this problem.

counterpoint · January 7th, 2006, 09:52

Not sure what has happened - I will discuss this with Chad. Revision 65 of admin.content.php had the error corrected, but the next time it was changed, the error was back in again. So the patch in the end did NOT have the corrections, unfortunately.

hazman · January 7th, 2006, 09:57

Just try and get them corrected, and when you do this, let me know so I can make the appropriate changes in the WAMP thread.

Thank you.

PersonalMode · January 7th, 2006, 10:11

Quote:

Originally Posted by taran

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 works...

I´ve found another error, same type:
/administrator/components/com_events/
admin.events.main.php Line 227
change to:
. "\nFROM #__categories AS cc, #__events AS a "

(Simple reorder the '__events AS a' what is used in the next join to the end)

This is for mambo 4.5.2 or 4.5.3 ??? Perhaps the two versions....

counterpoint · January 10th, 2006, 11:17

Sorry for all the confusion. There was a communication problem, and the fix got knocked out of the patch release. It will be in the next release.

In the mean time, the suggestion by taran is indeed sound.

doncorso · January 11th, 2006, 09:53

Thanks a lot! Editing these 2 lines is easy and it works great!
mambo 453h
mySQL 5.0.15

DC

PersonalMode · January 14th, 2006, 17:58

Quote:

Originally Posted by taran

I´ve found another error, same type:
/administrator/components/com_events/
admin.events.main.php Line 227
change to:
. "\nFROM #__categories AS cc, #__events AS a "

(Simple reorder the '__events AS a' what is used in the next join to the end)

I don't have this file in the version 4.5.3h ...

hazman · January 14th, 2006, 23:03

Quote:

Originally Posted by taran

I´ve found another error, same type:
/administrator/components/com_events/
admin.events.main.php Line 227
change to:
. "\nFROM #__categories AS cc, #__events AS a "

(Simple reorder the '__events AS a' what is used in the next join to the end)

Isn't this file form the 3rd party Events Component? It doesn't come with Mambo by default.

PersonalMode · January 15th, 2006, 05:19

There is an other problem

And I think, it's about MySQL 5

When I upgrade my mambo 4.5.2 to 4.5.3h on MySQL 4;x, it's ok

But when I upload my database on MySQL 5.x, I have an error on my page "contact"

126) ) { // always encode "\t", which is *not* required $h2 = floor($dec/16); $h1 = floor($dec%16); $c = $escape.$hex["$h2"].$hex["$h1"]; } if ( (strlen($newline) + strlen($c)) >= $line_max ) { // CRLF is not counted $output .= $newline.$escape.$eol; // soft line break; " =\r\n" is okay $newline = " "; } $newline .= $c; } // end of for $output .= $newline; if ($jproperties[$key] = quoted_printable_encode($number); } // UNTESTED !!! function setPhoto($type, $photo) { // $type = "GIF" | "JPEG" $this->properties["PHOTO;TYPE=$type;ENCODING=BASE64"] = base64_encode($photo); } function setFormattedName($name) { $this->properties["FN"] = quoted_printable_encode($name); } function setName($family="", $first="", $additional="", $prefix="", $suffix="") { $this->properties["N"] = "$family;$first;$additional;$prefix;$suffix"; $this->filename = "$first%20$family.vcf"; if ($this->properties["FN"]=="") $this->setFormattedName(trim("$prefix $first $additional $family $suffix")); } function setBirthday($date) { // $date format is YYYY-MM-DD $this->properties["BDAY"] = $date; } function setAddress($postoffice="", $extended="", $street="", $city="", $region="", $zip="", $country="", $type="HOME;POSTAL") { // $type may be DOM | INTL | POSTAL | PARCEL | HOME | WORK or any combination of these: e.g. "WORK;PARCEL;POSTAL" $key = "ADR"; if ($type!="") $key.= ";$type"; $key.= ";ENCODING=QUOTED-PRINTABLE"; $this->properties[$key] = encode($name).";".encode($extended).";".encode($st reet).";".encode($city).";".encode($region).";".en code($zip).";".encode($country); if ($this->properties["LABEL;$type;ENCODING=QUOTED-PRINTABLE"] == "") { //$this->setLabel($postoffice, $extended, $street, $city, $region, $zip, $country, $type); } } function setLabel($postoffice="", $extended="", $street="", $city="", $region="", $zip="", $country="", $type="HOME;POSTAL") { $label = ""; if ($postoffice!="") $label.= "$postoffice\r\n"; if ($extended!="") $label.= "$extended\r\n"; if ($street!="") $label.= "$street\r\n"; if ($zip!="") $label.= "$zip "; if ($city!="") $label.= "$city\r\n"; if ($region!="") $label.= "$region\r\n"; if ($country!="") $country.= "$country\r\n"; $this->properties["LABEL;$type;ENCODING=QUOTED-PRINTABLE"] = quoted_printable_encode($label); } function setEmail($address) { $this->properties["EMAIL;INTERNET"] = $address; } function setNote($note) { $this->properties["NOTE;ENCODING=QUOTED-PRINTABLE"] = quoted_printable_encode($note); } function setURL($url, $type="") { // $type may be WORK | HOME $key = "URL"; if ($type!="") $key.= ";$type"; $this->properties[$key] = $url; } function getVCard() { $text = "BEGIN:VCARD\r\n"; $text.= "VERSION:2.1\r\n"; foreach($this->properties as $key => $value) { $text.= "$key:$value\r\n"; } $text.= "REV:".date("Y-m-d")."T".date("H:i:s")."Z\r\n"; $text.= "MAILER:PHP vCard class by Kai Blankenhorn\r\n"; $text.= "END:VCARD\r\n"; return $text; } function getFileName() { return $this->filename; } } // USAGE EXAMPLE /* $v = new vCard(); $v->setPhoneNumber("+49 23 456789", "PREF;HOME;VOICE"); $v->setName("Mustermann", "Thomas", "", "Herr"); $v->setBirthday("1960-07-31"); $v->setAddress("", "", "Musterstrasse 20", "Musterstadt", "", "98765", "Deutschland"); $v->setEmail("thomas.mustermann@thomas-mustermann.de"); $v->setNote("You can take some notes here.\r\nMultiple lines are supported via \\r\\n."); $v->setURL("http://www.thomas-mustermann.de", "WORK"); $output = $v->getVCard(); $filename = $v->getFileName(); Header("Content-Disposition: attachment; filename=$filename"); Header("Content-Length: ".strlen($output)); Header("Connection: close"); Header("Content-Type: text/x-vCard; name=$filename"); echo $output; */ ?>
Fatal error: Class 'vCard' not found in C:\wamp\www\mambo\components\com_contact\contact.c lass.php on line 86

counterpoint · January 15th, 2006, 05:43

I've never seen that one before! Is it possible for me to see it happening on your site? It is a bit confusing without more context and the ability to poke around a little.

PersonalMode · January 15th, 2006, 09:46

No because I have upgrade in local, with EasyPHP.

Probably I've made a mistake to upgrade mambo, I try again.

Thank You

counterpoint · January 15th, 2006, 10:03

OK. If you get stuck again, and the error messages are complicated, it would be helpful to see screen shots if the site is not accessible. They give more feel for what is going on

PersonalMode · January 15th, 2006, 10:44

http://users.skynet.be/sb144360/error.jpg

PersonalMode · January 16th, 2006, 05:52

ok, the upgrade of 4.5.2.3 to 4.5.3h is ok on MySQL 4.x

But when I install mambo 4.5.3h on MySQL 5 and I upload my database the page "contact" failed, and there is a error message...

http://users.skynet.be/sb144360/error.jpg

November 14th, 2005, 13:54	#1
vist Join Date: Apr 2005 Posts: 1	DB function failed with error number 1054 Hello, i got this eror in mambo admin: content->allcontent items DB function failed with error number 1054 Unknown column 'c.access' in 'on clause' SQL=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 FROM mos_content AS c, mos_categories AS cc, mos_sections AS s LEFT JOIN mos_groups AS g ON g.id = c.access LEFT JOIN mos_users AS u ON u.id = c.checked_out LEFT JOIN mos_users AS v ON v.id = c.created_by LEFT JOIN mos_content_frontpage AS f ON f.content_id = c.id WHERE c.state >= 0 AND c.catid=cc.id AND cc.section=s.id AND s.scope='content' ORDER BY s.title, c.catid, cc.ordering, cc.title, c.ordering LIMIT 0,10 __________________ www.e-akva.info

January 7th, 2006, 02:53	#5
hazman Join Date: Dec 2004 Location: Israel Posts: 6,212	Hello, Ok, this seems to be a fix for this problem and I'm going to include a link to this thread in the WAMP5 installation thread. Thanks Taran __________________ All Open Source http://www.xtremeopensource.org Last edited by hazman : January 7th, 2006 at 03:12.

January 7th, 2006, 09:57	#9
hazman Join Date: Dec 2004 Location: Israel Posts: 6,212	Just try and get them corrected, and when you do this, let me know so I can make the appropriate changes in the WAMP thread. Thank you. __________________ All Open Source http://www.xtremeopensource.org

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
problem with admin section	sarmiento	General Questions	16	July 19th, 2006 23:21
DB function failed with error number 1054	dave1966uk	General Questions	35	May 31st, 2006 16:20
MA DB function failed with error number 1054	emfglobal	Installation Questions	2	April 10th, 2005 15:50
DB function failed with error number 1054	ennovdv	General Questions	0	January 3rd, 2005 09:35
Error bei jeder Art von Installation	XontaX	German Forum	14	April 14th, 2004 11:09

November 15th, 2005, 14:36	#2
counterpoint Join Date: Sep 2005 Location: Yorkshire, England Posts: 1,372	Are you running MySQL 5? If so, I'm afraid that Mambo is not compatible with it, and cannot be quickly made compatible. The issue will be resolved as part of the Mambo project to achieve multi-platform database support.

December 6th, 2005, 02:30	#4
dchai Join Date: Dec 2005 Posts: 7	I encountered the same error and the solution helps resolve my issue. thanks

January 7th, 2006, 03:14	#6
counterpoint Join Date: Sep 2005 Location: Yorkshire, England Posts: 1,372	This has also been discussed in a lot of other places, with more information given about the problem - and the problem was fixed in the 4.5.3h patch.

January 7th, 2006, 09:52	#8
counterpoint Join Date: Sep 2005 Location: Yorkshire, England Posts: 1,372	Not sure what has happened - I will discuss this with Chad. Revision 65 of admin.content.php had the error corrected, but the next time it was changed, the error was back in again. So the patch in the end did NOT have the corrections, unfortunately.

January 10th, 2006, 11:17	#11
counterpoint Join Date: Sep 2005 Location: Yorkshire, England Posts: 1,372	Sorry for all the confusion. There was a communication problem, and the fix got knocked out of the patch release. It will be in the next release. In the mean time, the suggestion by taran is indeed sound.

January 11th, 2006, 09:53	#12
doncorso Join Date: Nov 2005 Posts: 4	Thanks a lot! Editing these 2 lines is easy and it works great! mambo 453h mySQL 5.0.15 DC

January 15th, 2006, 05:19	#15
PersonalMode Join Date: Jul 2005 Posts: 18	There is an other problem And I think, it's about MySQL 5 When I upgrade my mambo 4.5.2 to 4.5.3h on MySQL 4;x, it's ok But when I upload my database on MySQL 5.x, I have an error on my page "contact" 126) ) { // always encode "\t", which is not required $h2 = floor($dec/16); $h1 = floor($dec%16); $c = $escape.$hex["$h2"].$hex["$h1"]; } if ( (strlen($newline) + strlen($c)) >= $line_max ) { // CRLF is not counted $output .= $newline.$escape.$eol; // soft line break; " =\r\n" is okay $newline = " "; } $newline .= $c; } // end of for $output .= $newline; if ($jproperties[$key] = quoted_printable_encode($number); } // UNTESTED !!! function setPhoto($type, $photo) { // $type = "GIF" \| "JPEG" $this->properties["PHOTO;TYPE=$type;ENCODING=BASE64"] = base64_encode($photo); } function setFormattedName($name) { $this->properties["FN"] = quoted_printable_encode($name); } function setName($family="", $first="", $additional="", $prefix="", $suffix="") { $this->properties["N"] = "$family;$first;$additional;$prefix;$suffix"; $this->filename = "$first%20$family.vcf"; if ($this->properties["FN"]=="") $this->setFormattedName(trim("$prefix $first $additional $family $suffix")); } function setBirthday($date) { // $date format is YYYY-MM-DD $this->properties["BDAY"] = $date; } function setAddress($postoffice="", $extended="", $street="", $city="", $region="", $zip="", $country="", $type="HOME;POSTAL") { // $type may be DOM \| INTL \| POSTAL \| PARCEL \| HOME \| WORK or any combination of these: e.g. "WORK;PARCEL;POSTAL" $key = "ADR"; if ($type!="") $key.= ";$type"; $key.= ";ENCODING=QUOTED-PRINTABLE"; $this->properties[$key] = encode($name).";".encode($extended).";".encode($st reet).";".encode($city).";".encode($region).";".en code($zip).";".encode($country); if ($this->properties["LABEL;$type;ENCODING=QUOTED-PRINTABLE"] == "") { //$this->setLabel($postoffice, $extended, $street, $city, $region, $zip, $country, $type); } } function setLabel($postoffice="", $extended="", $street="", $city="", $region="", $zip="", $country="", $type="HOME;POSTAL") { $label = ""; if ($postoffice!="") $label.= "$postoffice\r\n"; if ($extended!="") $label.= "$extended\r\n"; if ($street!="") $label.= "$street\r\n"; if ($zip!="") $label.= "$zip "; if ($city!="") $label.= "$city\r\n"; if ($region!="") $label.= "$region\r\n"; if ($country!="") $country.= "$country\r\n"; $this->properties["LABEL;$type;ENCODING=QUOTED-PRINTABLE"] = quoted_printable_encode($label); } function setEmail($address) { $this->properties["EMAIL;INTERNET"] = $address; } function setNote($note) { $this->properties["NOTE;ENCODING=QUOTED-PRINTABLE"] = quoted_printable_encode($note); } function setURL($url, $type="") { // $type may be WORK \| HOME $key = "URL"; if ($type!="") $key.= ";$type"; $this->properties[$key] = $url; } function getVCard() { $text = "BEGIN:VCARD\r\n"; $text.= "VERSION:2.1\r\n"; foreach($this->properties as $key => $value) { $text.= "$key:$value\r\n"; } $text.= "REV:".date("Y-m-d")."T".date("H:i:s")."Z\r\n"; $text.= "MAILER:PHP vCard class by Kai Blankenhorn\r\n"; $text.= "END:VCARD\r\n"; return $text; } function getFileName() { return $this->filename; } } // USAGE EXAMPLE /* $v = new vCard(); $v->setPhoneNumber("+49 23 456789", "PREF;HOME;VOICE"); $v->setName("Mustermann", "Thomas", "", "Herr"); $v->setBirthday("1960-07-31"); $v->setAddress("", "", "Musterstrasse 20", "Musterstadt", "", "98765", "Deutschland"); $v->setEmail("thomas.mustermann@thomas-mustermann.de"); $v->setNote("You can take some notes here.\r\nMultiple lines are supported via \\r\\n."); $v->setURL("http://www.thomas-mustermann.de", "WORK"); $output = $v->getVCard(); $filename = $v->getFileName(); Header("Content-Disposition: attachment; filename=$filename"); Header("Content-Length: ".strlen($output)); Header("Connection: close"); Header("Content-Type: text/x-vCard; name=$filename"); echo $output; */ ?> Fatal error: Class 'vCard' not found in C:\wamp\www\mambo\components\com_contact\contact.c lass.php on line 86

January 15th, 2006, 05:43	#16
counterpoint Join Date: Sep 2005 Location: Yorkshire, England Posts: 1,372	I've never seen that one before! Is it possible for me to see it happening on your site? It is a bit confusing without more context and the ability to poke around a little.

January 15th, 2006, 09:46	#17
PersonalMode Join Date: Jul 2005 Posts: 18	No because I have upgrade in local, with EasyPHP. Probably I've made a mistake to upgrade mambo, I try again. Thank You

January 15th, 2006, 10:03	#18
counterpoint Join Date: Sep 2005 Location: Yorkshire, England Posts: 1,372	OK. If you get stuck again, and the error messages are complicated, it would be helpful to see screen shots if the site is not accessible. They give more feel for what is going on

January 15th, 2006, 10:44	#19
PersonalMode Join Date: Jul 2005 Posts: 18	http://users.skynet.be/sb144360/error.jpg

January 16th, 2006, 05:52	#20
PersonalMode Join Date: Jul 2005 Posts: 18	ok, the upgrade of 4.5.2.3 to 4.5.3h is ok on MySQL 4.x But when I install mambo 4.5.3h on MySQL 5 and I upload my database the page "contact" failed, and there is a error message... http://users.skynet.be/sb144360/error.jpg