Follow us on Twitter
Joomla Components

Latest in Blog

Welcome, Guest
Please Login or Register.    Lost Password?

SQL error after Blog Roll heading
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: SQL error after Blog Roll heading
#249
SQL error after Blog Roll heading 5 Years, 4 Months ago Karma: 0
Hello,

I was able to successfully install the files.

com_blogsidebar2.4.zip
mod_blogcal1.6.zip
mod_sidebar.zip

When I select the blog component in the Main Menu, I get the mamblog displayed just fine. However, the Blog Sidebar shows the calendar followed by the Heading for the Blog Roll after which the following error message is displayed:

"Invalid query: Whole query: SELECT id FROM #__categories WHERE section="com_weblinks" AND title="blogroll" "

I suspect I have mis-configured Blog Sidebar somehow, but I've been unable to figure out what I have done wrong.

I will unpublish Blog Sidebar and await your answer. However, I am really looking forward to having it active on my blog.

Jerry Nielsen - Tea and Scones Vermont
jnnielsen
Fresh Boarder
Posts: 0
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#286
Re: SQL error after Blog Roll heading 5 Years, 1 Month ago Karma: 0
I get a similar error:Invalid query: Whole query: SELECT title, url FROM #__weblinks WHERE catid=16 AND published = 1

Installed
com_blogsidebar2.4.zip
mod_sidebar.zip
Joomla 1.0.12
mamblog 1.0

No/Few people seem to be discussing the SQL errors which seem to be pretty common. I wonder if it is related to Joomla 1.0.12?
pintobuck
Fresh Boarder
Posts: 0
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#287
Re: SQL error after Blog Roll heading 5 Years, 1 Month ago Karma: 0
Per SVtechie:
Re: BlogCal ........Problem is with your MySQL version. DAY () function is not supported in 4.0.26.
www.svtechie.com/cms/component/option,co...storder,asc/start,0/

My own MySQL is V.4.0.26. Could that be the problem with Blogroll?
pintobuck
Fresh Boarder
Posts: 0
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#325
Re: SQL error after Blog Roll heading 4 Years, 8 Months ago Karma: 0
Try to create a weblink category due to your settings and them, populate it, create a weblink entry.

It worker to me...
Diogo
Fresh Boarder
Posts: 0
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 1
Moderators: SVTechie