Yesterday all servers in the U.S. went out on strike in a bid to get more RAM and better CPUs. A spokes person said that the need for better RAM was due to some fool increasing the front-side bus speed. In future, busses will be told to slow down in residential motherboards.
 

Main Menu

Home
Articles
SVTechie Blog
Links
Download
Discussion Forum
Photo Gallery
Quick Bites
FAQs

Login






Lost Password?
No account yet? Register

Statistics

We have 1 guest online

SVTechie Recommends


powered_by.png, 1 kB

Text Links


Home arrow Discussion Forum
SVTechie
Welcome, Guest
Please Login or Register.    Lost Password?
SQL error after Blog Roll heading (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: SQL error after Blog Roll heading
#249
jnnielsen (User)
Fresh Boarder
Posts: 0
graphgraph
User Offline Click here to see the profile of this user
SQL error after Blog Roll heading 1 Year, 8 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
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#286
pintobuck (User)
Fresh Boarder
Posts: 0
graphgraph
User Offline Click here to see the profile of this user
Re: SQL error after Blog Roll heading 1 Year, 4 Months ago Karma: 0  
I get a similar error:
QUOTE:
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?
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#287
pintobuck (User)
Fresh Boarder
Posts: 0
graphgraph
User Offline Click here to see the profile of this user
Re: SQL error after Blog Roll heading 1 Year, 4 Months ago Karma: 0  
Per SVtechie:
Re: BlogCal
QUOTE:
........Problem is with your MySQL version. DAY () function is not supported in 4.0.26.
http://www.svtechie.com/cms/component/option,com_forum/Itemid,33/page,viewtopic/t,25/postdays,0/postorder,asc/start,0/

My own MySQL is V.4.0.26. Could that be the problem with Blogroll?
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#325
Diogo (User)
Fresh Boarder
Posts: 0
graphgraph
User Offline Click here to see the profile of this user
Re: SQL error after Blog Roll heading 12 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...
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoard
Homeowner Loans | Arturo perez reverte | Credit Cards | Loan | Secured Loan
© 2008 SVTechie :: Online Resources For Techies BY Techies
Joomla! is Free Software released under the GNU/GPL License.