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
TOPIC: SQL Error 1054 on Frontend in Joomla V3
#14830
bluesailor (User)
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
SQL Error 1054 on Frontend in Joomla V3 1 Year, 7 Months 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.
#14835
Taras (Admin)
Admin
Posts: 2637
graphgraph
User Offline Click here to see the profile of this user
Re:SQL Error 1054 on Frontend in Joomla V3 1 Year, 7 Months ago Karma: 53  
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.
#14865
bluesailor (User)
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
Re:SQL Error 1054 on Frontend in Joomla V3 1 Year, 6 Months 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.
#14869
Taras (Admin)
Admin
Posts: 2637
graphgraph
User Offline Click here to see the profile of this user
Re:SQL Error 1054 on Frontend in Joomla V3 1 Year, 6 Months ago Karma: 53  
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.
#14897
bluesailor (User)
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
Re:SQL Error 1054 on Frontend in Joomla V3 1 Year, 6 Months 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 bluesailor.
  The administrator has disabled public write access.
#14898
bluesailor (User)
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
Re:SQL Error 1054 on Frontend in Joomla V3 1 Year, 6 Months 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 bluesailor.
  The administrator has disabled public write access.
Go to top
What are you looking for?
Anti-spam question: How many eyes has a typical person?