vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   New Posting Features - [DBTech] Advanced Post Thanks / Like v3 (vB4) [AJAX] (https://vborg.vbsupport.ru/showthread.php?t=243510)

dolomites 04-30-2016 07:06 AM

I get this error after update

Database error in vBulletin 4.2.3:

Invalid SQL:
(
SELECT COUNT(*) AS count, varname
FROM dbtech_thanks_entry AS entry,
(
SELECT postid
FROM post
WHERE threadid = 11569
AND visible IN (1,2,0)
) AS tmp
WHERE entry.contenttype = 'post'
AND entry.varname = 'thanks'
AND contentid = tmp.postid
) UNION ALL (
SELECT COUNT(*) AS count, varname
FROM dbtech_thanks_entry AS entry,
(
SELECT postid
FROM post
WHERE threadid = 11569
AND visible IN (1,2,0)
) AS tmp
WHERE entry.contenttype = 'post'
AND entry.varname = 'likes'
AND contentid = tmp.postid
) UNION ALL (
SELECT COUNT(*) AS count, varname
FROM dbtech_thanks_entry AS entry,
(
SELECT postid
FROM post
WHERE threadid = 11569
AND visible IN (1,2,0)
) AS tmp
WHERE entry.contenttype = 'post'
AND entry.varname = 'dislikes'
AND contentid = tmp.postid
);

MySQL Error : Column 'varname' cannot be null
Error Number : 1048
Request Date : Saturday, April 30th 2016 @ 11:03:18 AM
Error Date : Saturday, April 30th 2016 @ 11:03:19 AM
Script : http://---------------/showthread.php?t=11569&p=228792
Referrer : http://------------------/index.php
IP Address : 94.164.34.84
Username : Paolo
Classname : vB_Database_MySQLi
MySQL Version : 5.0.92-enterprise-gpl-log

DragonByte Tech 04-30-2016 01:48 PM

You will need to upgrade to a modern version of MySQL. MySQL 5.0 is no longer supported, please consider upgrading to 5.6.

Fillip

dolomites 04-30-2016 01:59 PM

Thank you for the quick reply!

blackwolf76 05-01-2016 06:16 AM

Quote:

Originally Posted by dolomites (Post 2569890)
I get this error after update

Database error in vBulletin 4.2.3:

Invalid SQL:
(
SELECT COUNT(*) AS count, varname
FROM dbtech_thanks_entry AS entry,
(
SELECT postid
FROM post
WHERE threadid = 11569
AND visible IN (1,2,0)
) AS tmp
WHERE entry.contenttype = 'post'
AND entry.varname = 'thanks'
AND contentid = tmp.postid
) UNION ALL (
SELECT COUNT(*) AS count, varname
FROM dbtech_thanks_entry AS entry,
(
SELECT postid
FROM post
WHERE threadid = 11569
AND visible IN (1,2,0)
) AS tmp
WHERE entry.contenttype = 'post'
AND entry.varname = 'likes'
AND contentid = tmp.postid
) UNION ALL (
SELECT COUNT(*) AS count, varname
FROM dbtech_thanks_entry AS entry,
(
SELECT postid
FROM post
WHERE threadid = 11569
AND visible IN (1,2,0)
) AS tmp
WHERE entry.contenttype = 'post'
AND entry.varname = 'dislikes'
AND contentid = tmp.postid
);

MySQL Error : Column 'varname' cannot be null
Error Number : 1048
Request Date : Saturday, April 30th 2016 @ 11:03:18 AM
Error Date : Saturday, April 30th 2016 @ 11:03:19 AM
Script : http://---------------/showthread.php?t=11569&p=228792
Referrer : http://------------------/index.php
IP Address : 94.164.34.84
Username : Paolo
Classname : vB_Database_MySQLi
MySQL Version : 5.0.92-enterprise-gpl-log

I have the same problem,

Is possible obtain an older version of this mod??

Isn't possible for me upgrade Sql version...

DragonByte Tech 05-01-2016 12:14 PM

Quote:

Originally Posted by blackwolf76 (Post 2569929)
I have the same problem,

Is possible obtain an older version of this mod??

Isn't possible for me upgrade Sql version...

If you cannot upgrade MySQL, please turn off the Forum Display and Show Thread button click lists from the vBulletin Options.


Fillip

dolomites 05-01-2016 12:19 PM

What happens with this solution? Plugin still works or buttons are hidden?

DragonByte Tech 05-01-2016 12:20 PM

Quote:

Originally Posted by dolomites (Post 2569938)
What happens with this solution? Plugin still works or buttons are hidden?

It turns off the list of buttons that have been clicked within this forum or this thread.


Fillip

dolomites 05-01-2016 12:26 PM

Practically
Quote:

Alex, Anton, Sonja liked this
John thanked this
?

DragonByte Tech 05-01-2016 12:27 PM

Quote:

Originally Posted by dolomites (Post 2569940)
Practically

?

No.

https://vborg.vbsupport.ru/external/2016/05/34.png

You could always try turning off the setting and seeing what effect it has on your forum :)


Fillip

dolomites 05-01-2016 12:31 PM

Yes, now I try; I had to uninstall the plugin last days because the forum was unusable after the update, and I can not interrupt the service


All times are GMT. The time now is 04:01 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03861 seconds
  • Memory Usage 1,746KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete