OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
SQL Error 1054 on Frontend in Joomla V3 (0 viewing) 

BookLibary Component Support

Go to bottom Favoured: 0

SQL Error 1054 on Frontend in Joomla V3

bluesailor (Visitor)
Posts: 0
graphgraph
User Offline
SQL Error 1054 on Frontend in Joomla V3 9 Years ago
Karma: 0  
I am using Joomla V 3.3 and Booklibrary V3.1. Installation of Booklibrary went smoothly, importing books from books exported from Joomla V2.5 was also Ok. When in want to go to Booklibrary on Frontend following SQL Error is displayed :

1054 - Unknown column 'c.language' in 'field list' SQL=SELECT c.id,c.parent_id, c.language, COUNT(bc.bookid) AS books, c.title, c.image, '1' AS display FROM dfrqa_booklibrary_main_categories as c LEFT JOIN dfrqa_booklibrary_categories AS bc ON c.id=bc.catid LEFT JOIN dfrqa_booklibrary AS b ON b.id=bc.bookid AND b.published=1 AND b.approved=1 WHERE c.section='com_booklibrary' AND c.published = 1 AND ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' ) AND (c.langshow LIKE'German (DE-CH-AT)' OR c.language='' OR c.language IS NULL OR c.language='*' GROUP BY c.id ORDER BY parent_id DESC, c.ordering

Thank you very much for any suggestions and help.
Logged Logged
The administrator has disabled public write access.
Taras (User)
Platinum Boarder
Posts: 2857
graphgraph
User Offline Click here to see the profile of this user
Re:SQL Error 1054 on Frontend in Joomla V3 9 Years ago
Karma: 58  
Hello,

Give us please - link on website, FTP of your website, Your file of export from Joomla V2.5 and admin access and we will try to help you, FTP and admin access You can send to our contact form.
ordasoft.com/About-us/OrdaSoft.html
Joomla Admin

username
password


FTP

FTP host

FTP username

FTP password

Thanks,
OrdaSoft team
Logged Logged
The administrator has disabled public write access.
bluesailor (Visitor)
Posts: 0
graphgraph
User Offline
Re:SQL Error 1054 on Frontend in Joomla V3 9 Years ago
Karma: 0  
Thank you very much for your answer.
Unfortunately I am not able to giv you the requested access as the homepage is not yet online. To check the compatibilty of all components with Joomla V3 I am testing it on local machine which is not online.
If you give me any hints on who to pinpoint the error I might be able to troubleshoot it myself.
Thank you very much.
Very kind regards
Logged Logged
The administrator has disabled public write access.
Taras (User)
Platinum Boarder
Posts: 2857
graphgraph
User Offline Click here to see the profile of this user
Re:SQL Error 1054 on Frontend in Joomla V3 9 Years ago
Karma: 58  
Hello,

Your error maybe connect with importing books from Joomla V2.5.

If without importing all works, therefore we can conclude that Booklibrary V3.1 is works fine.

To help you we need access to database or ftp. Without any access we can not help you.

Aslo you can send you XML file (export from Joomla 2.5) on our contact form and we wil try to find solution special for you
ordasoft.com/About-us/OrdaSoft.html
Thanks,
OrdaSoft team.
Logged Logged
The administrator has disabled public write access.
bluesailor (Visitor)
Posts: 0
graphgraph
User Offline
Re:SQL Error 1054 on Frontend in Joomla V3 9 Years ago
Karma: 0  
Hi
I have now made som more tests.
1. Have uninstalled booklibrary and droped the booklibrary tables
2. reinstalled booklibrary 3.1
- preinstalled books showed fine on frontend
- adding new category worked ok
- adding new book with "fetch information" "on your own" worked fine and newly added book showed in frontend
- trying to add new book with fetch information "Webservice - Amazon-de" resulted in following message on a blank page:
-----------------------------------------------------------
/var/www/administrator/components/com_booklibrary/booklibrary.php: 1778
qwerty11

Array
(
[bookid] => 7
[isbn] => 9783732214754
[language] => English
[langshow] => *
[catid] => Array
(
[0] => 57
)

[informationFrom] => 3
[comment] =>
[title] =>
[authors] =>
[manufacturer] =>
[release_Date] =>
[price] =>
[priceunit] =>
[edition] =>
[numberOfPages] => 0
[imageURL] =>
[URL] =>
[owneremail] => kurt.feusi@bluewin.ch
[id] => 7
[option] => com_booklibrary
[boxchecked] => 0
[task] => save
)

qwerty11111111

----------------------------------------------------
so obviously ther has to be a problem associated with fetching the information from the amazon webpage. I have added my correct access information for amazon in the backend settings.

Can you give me a clue on what could be the error?

Thank you very much.
Logged Logged
Last Edit: 2015/03/14 20:42 By .
The administrator has disabled public write access.
bluesailor (Visitor)
Posts: 0
graphgraph
User Offline
Re:SQL Error 1054 on Frontend in Joomla V3 9 Years ago
Karma: 0  
Hi,
during installation of booklibrary message that for php5 extensions curl and xsl are missing.
Could this be the error that fetching information from amazon forces error?

Thanks
Logged Logged
Last Edit: 2015/03/14 21:16 By .
The administrator has disabled public write access.
Go to top
»