Downgrading from Pro v1.1.0 BETA upgrade issue

[blinkster]

When i go into forum manager and select the forums i get following database error

Invalid SQL:

UPDATE forum
SET dbtech_thanks_enablethanks = '0',dbtech_thanks_enablelike = '0',dbtech_thanks_enabledislike = '0'
WHERE forumid = 193;

MySQL Error : Unknown column 'dbtech_thanks_enablethanks' in 'field list'
Error Number : 1054

 

[blinkster]

and


Invalid SQL:

SELECT
entry.contentid,
entry.entrytype,
entry.dateline,
user.userid,
user.username,
user.usergroupid,
user.infractiongroupid,
user.displaygroupid
FROM dbtech_thanks_entry AS entry
LEFT JOIN post AS post ON(post.postid = entry.contentid)
LEFT JOIN user AS user ON(user.userid = entry.userid)
WHERE post.postid IN (024494)
AND entry.contenttype = 'post'
ORDER BY entry.contentid ASC, entry.dateline DESC;

MySQL Error : Unknown column 'entry.entrytype' in 'field list'
Error Number : 1054

 

[blinkster]

Think i have thise solved but all attachments are now unhidden, i tried this

UPDATE post SET dbtech_thanks_requiredbuttons_attach = 1

to hide them all again but doesn't work but did in the beta version. Any help appreciated

 

[Fillip H.]

We do not support downgrading our mods, unfortunately

 

[blinkster]

strange not supporting your own mods down or upgrading but who am i to decide whats what. Any chance you can point me in the right direction to a query that works like this


UPDATE post SET dbtech_thanks_requiredbuttons_attach = 1

as above it works in beta but not in older one.

 

[Fillip H.]

UPDATE post SET dbtech_thanks_requirethanks_attach = 1
I think that's it.

Supporting our mods is different from supporting people attempting to reverse something that was intended to be irreversible

 

[blinkster]

lmao maybe i should have put support for my dumbass....lmao

UPDATE post SET dbtech_thanks_requirethanks_attach = 1

didn't work :-(

 

[Fillip H.]

UPDATE post SET dbtech_thanks_requirethanks_attach = '1'

Actually i think those quotes are needed due to the database column type, if the above doesn't work, try that

 

[blinkster]

UPDATE post SET dbtech_thanks_requirethanks_attach = '1' this here done the trick thank you so much. Another thread of useful tips for future people. Thankyou Fillip H., i know at times i don't come across the right way but i tend to speak as i think and not always a good combination,

 

[Fillip H.]

No worries, glad it worked