Go Back   Pligg CMS Forum > Pligg Development > Pligg Templates > Template Support > Old Templates > "Mollio-Beat"

Reply
 
LinkBack Thread Tools Display Modes
  #21 (permalink)  
Old 05-25-2006, 01:59 AM
New Pligger
 
Join Date: Dec 2005
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
It worked fine for me. It just seems that there are a few of the features that are not included in the template yet.
Reply With Quote
  #22 (permalink)  
Old 05-27-2006, 12:50 AM
Casual Pligger
 
Join Date: May 2006
Posts: 92
Thanks: 3
Thanked 7 Times in 6 Posts
I installed this theme on 7.2.

When any tag link is clicked in the tag cloud, I get this:

Quote:
SQL/DB Error -- [Unknown column 'tag_words' in 'where clause']

SQL/DB Error -- [Unknown column 'tag_words' in 'where clause']
Ex.: The error can be seen at http://pligg.sridhareena.com/index.p...press&tag=true

Any way to fix this?
Reply With Quote
  #23 (permalink)  
Old 05-27-2006, 09:04 AM
beatniak's Avatar
Pligg Donor
 
Join Date: Apr 2006
Location: NL - 52.100863;5.108356
Posts: 310
Thanks: 14
Thanked 77 Times in 48 Posts
In index.php (line 73) it asks for searching the column tag_words:

Code:
$from_where = "FROM links, tags WHERE tag_words='$mysearch' AND link_id=tag_link_id ORDER BY `link_votes` DESC ";
Somehow you don't have that column in your database. That has nothing to do with the template, but with your install. But the weird thing is that you DO have tags in the linkbox of your stories.

I haven't got pligg 7.2 installed, because i read about a lot of problems with it in the forums. So i don't know whether or not this is a pligg 7.2 problem or a bad install problem.

Anyone?
__________________
Like my work? Donations are welcome if you would like to support my work!
Finger pliggin' good sites of mine: receptencocktail.nl / numarketing.nl / goboz.com
Reply With Quote
  #24 (permalink)  
Old 05-27-2006, 10:34 AM
Casual Pligger
 
Join Date: Jan 2006
Posts: 77
Thanks: 0
Thanked 1 Time in 1 Post
hmm i am using template 1.1 with pligg 7.2 and i am getting the same error. I used the dbase from my 7.1 site. But, I also tried with a fresh install/new database added story and get the same error also. Maybe it is with the pligg 7.2 code. I've disabled the tags until it gets figured out.. oh well..

Last edited by can8dn; 05-27-2006 at 10:37 AM..
Reply With Quote
  #25 (permalink)  
Old 05-27-2006, 02:29 PM
Constant Pligger
 
Join Date: Apr 2006
Posts: 122
Thanks: 1
Thanked 1 Time in 1 Post
Quote:
Originally Posted by beatniak
In index.php (line 73) it asks for searching the column tag_words:

Code:
$from_where = "FROM links, tags WHERE tag_words='$mysearch' AND link_id=tag_link_id ORDER BY `link_votes` DESC ";
Somehow you don't have that column in your database. That has nothing to do with the template, but with your install. But the weird thing is that you DO have tags in the linkbox of your stories.

I haven't got pligg 7.2 installed, because i read about a lot of problems with it in the forums. So i don't know whether or not this is a pligg 7.2 problem or a bad install problem.

Anyone?
Yeah, this is definitely a problem with the pligg install script. The table isn't being created. I just ran a totally fresh install into a blank database and I get this same error when clicking on any tag.
Reply With Quote
  #26 (permalink)  
Old 05-28-2006, 12:01 AM
Div Div is offline
Casual Pligger
 
Join Date: May 2006
Posts: 60
Thanks: 0
Thanked 7 Times in 4 Posts
Same sql/db error. I had to remove the tag menu items till someone figures it out. If I knew what the parameters for the table was, I'd add it via mysql admin. Not sure if the data would be added to the table if I don't get any other errors than when it's called. Hmmm. Shouldn't we be getting errors when it tries to write the tag words to a table that isn't there?

Anyways, still hoping for a solution.
Reply With Quote
  #27 (permalink)  
Old 05-28-2006, 12:24 AM
AshDigg's Avatar
Coder
 
Join Date: Dec 2005
Posts: 1,574
Thanks: 235
Thanked 345 Times in 206 Posts
Quote:
Originally Posted by Div
Shouldn't we be getting errors when it tries to write the tag words to a table that isn't there?


Try replacing your /libs/utils.php with this one...
Attached Files
File Type: php utils.php (6.3 KB, 154 views)
__________________
- Ash
Reply With Quote
  #28 (permalink)  
Old 05-28-2006, 08:48 AM
beatniak's Avatar
Pligg Donor
 
Join Date: Apr 2006
Location: NL - 52.100863;5.108356
Posts: 310
Thanks: 14
Thanked 77 Times in 48 Posts
thanks for resolving that issue ash.
__________________
Like my work? Donations are welcome if you would like to support my work!
Finger pliggin' good sites of mine: receptencocktail.nl / numarketing.nl / goboz.com
Reply With Quote
The Following User Says Thank You to beatniak For This Useful Post:
  #29 (permalink)  
Old 05-28-2006, 10:09 AM
Div Div is offline
Casual Pligger
 
Join Date: May 2006
Posts: 60
Thanks: 0
Thanked 7 Times in 4 Posts
Thank you, fixed the error. I'm still having a little issue with it bringing back results I would have hoped for, but I read somewhere else that that was a tag word issue, and it was being worked on.

Thanks again for resolving that sql/db error.

One last thing, maybe it's something I did, but the top left links for home and login, etc. move to the top of the header and cover the site name in IE. Works fine in FF, but in IE they cover the name. I'm sure it's a css issue and I did a little tweaking and probably did it to myself. But thought I'd ask incase it was something that others have had issues with. DivGamer
Reply With Quote
  #30 (permalink)  
Old 05-28-2006, 11:19 AM
Constant Pligger
 
Join Date: Apr 2006
Posts: 122
Thanks: 1
Thanked 1 Time in 1 Post
Yeah, that got rid of the errors but there are no actual results when clicking on a tag.
Reply With Quote
Reply

Thread Tools
Display Modes
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Similar Threads
Thread Thread Starter Forum Replies Last Post
MacBlue Free Pligg Template by Yankidank Yankidank Pligg Templates 13 11-10-2008 05:37 PM
Release: Mollio-Beat Template 1.3 beatniak "Mollio-Beat" 51 01-14-2008 06:42 AM
How to upgrade modified mollio beat from beta8 to bet9 lauris "Mollio-Beat" 4 01-28-2007 02:07 AM
Cannot vote with Pligg B7.2 and Mollio Beat template. luckyclover Installation and Upgrade Help 8 09-06-2006 11:50 PM
Release: Mollio-Beat Template 1.0 beatniak "Mollio-Beat" 60 05-10-2006 10:17 PM


Search Engine Friendly URLs by vBSEO 3.2.0