Bug Fails in Blogs

[Drahnier]

I recently updated my forum from the standard 4.2.0 to the publishing suite, 4.2.1

Thanks don't work with the blog function, bringing up this dialogue box; http://i.imgur.com/ji6fZ8J.png
I since updated the Thanks/Like plugin (I was a version old) and the problem persists

how can I fix this?

some error stuff 4 u;


Invalid SQL:

SELECT
blog_text.title AS posttitle,
blog.title AS threadtitle,
blog_text.blogtextid AS postid,
blog_text.userid,
blog_text.dbtech_thanks_disabledbuttons,
blog.firstblogtextid AS firstpostid,
blog.dbtech_thanks_disabledbuttons AS disabledbuttons_thread,
user.username,
user.userid,
user.usergroupid,
user.displaygroupid,
user.membergroupids,
user.customtitle
FROM blog_text AS blog_text
LEFT JOIN blog AS blog ON(blog.blogid = blog_text.blogid)
LEFT JOIN user AS user ON(user.userid = blog_text.userid)
WHERE blog_text.blogtextid = '6'
LIMIT 1;

MySQL Error : Unknown column 'blog_text.dbtech_thanks_disabledbuttons' in 'field list'
Error Number : 1054
Request Date : Monday, April 29th 2013 @ 07:05:54 PM
Error Date : Monday, April 29th 2013 @ 07:05:55 PM
Script : http://www.example.com/thanks.php
Referrer : http://www.example.com/entry.php/2-Hell-yeah

 

[Fillip H.]

You were upgrading from v1.0.5?

You can fix this by running

ALTER TABLE blog_text ADD dbtech_thanks_disabledbuttons int(10) unsigned not null default '0'

Also, attempt to run this (it may give you an error message, if so then ignore it):

ALTER TABLE blog ADD dbtech_thanks_disabledbuttons int(10) unsigned not null default '0'

And finally, check that the database table dbtech_thanks_button has the following column: defaultbutton_attach

If it does not, feel free to PM me with the access details for your phpMyAdmin installation so that I can synchronise your database - lacking that column would indicate random elements of the database is out of sync and mysterious issues / errors may crop up.

 

[Drahnier]

You were upgrading from v1.0.5?

from 1.0.4 to 1.0.5

I'll have a look at what you've suggested

 

[Fillip H.]

The latest version of APTL is v3.1.2

 

[Drahnier]

The latest version of APTL is v3.1.2

oh right I was looking at another plugin, getting a tad confused on things, long day

I'm on DragonByte Tech: Advanced Post Thanks / Like (Pro) 3.0.3

I'll just update and see if that fixes it


sorry for wasting your time

works fine now