vb.org Archive - Show Thread Enhancements - [AJAX] Post Thank You Hack

Hi Team Today i got this message Please check and give me a idea what i do

Database error in vBulletin 4.1.5:

Invalid SQL:

REPLACE INTO vb3search (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)
VALUES (1, '122.162.214.235', 1, 'dheeraj.db99', '', 'post.dateline', 'DESC', 0.02775, 1, '2832', 1420530220, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{} s:6:\"common\";a:0:{}s:5:\"users\";a:1:{i:33821;s: 12:\"dheeraj.db99\";}s:6:\"forums\";i:0;s:7:\"opti ons\";a:3:{s:11:\"starteronly\";i:0;s:11:\"childfo rums\";i:1;s:6:\"action\";s:7:\"process\";}}', 'e315927dbcd262523c9bda9990e88942');

MySQL Error : Table 'databasename.vb3search' doesn't exist
Error Number : 1146
Request Date : Tuesday, January 6th 2015 @ 01:13:40 PM
Error Date : Tuesday, January 6th 2015 @ 01:13:40 PM
Script : http://www.faadooengineers.com/post_...r_gave&u=33821
Referrer :
IP Address : 122.162.214.235
Username : FaaDoO-Engineer
Classname : vB_Database
MySQL Version : 5.1.73-cll

ForceHSS

01-06-2015 06:08 AM

Quote:

Originally Posted by boffin_adi (Post 2530711)

Dont double post the same problem and not in vb3 when you are using vb4 version

Gman2004

02-11-2015 01:29 PM

Could anyone help me walk through the install process?

Z@Zmaster

02-25-2015 02:04 AM

Hello! I have error:

Quote:

Database error in vBulletin 3.8.*:

Invalid SQL:
SELECT * FROM post_thanks AS post_thanks INNER JOIN user AS user USING (userid) WHERE post_thanks.postid IN () ORDER BY post_thanks.username ASC;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY post_thanks.username ASC' at line 1
Error Number : 1064
Request Date : Thursday, February 19th 2015 @ 06:23:48 PM
Error Date : Thursday, February 19th 2015 @ 06:23:48 PM
Script : http://www.*********.ru/post_thanks.php
Referrer : http://www.*********.ru/showthread.php?t=109155
IP Address : ***********
Username : Незарегистрированный
Classname : vB_Database_MySQLi
MySQL Version :

How fix it?

ForceHSS

02-25-2015 02:44 AM

Quote:

Originally Posted by Z@Zmaster (Post 2538645)

Hello! I have error:

How fix it?

Search fix has only been done in vb4 version

BirdOPrey5

02-25-2015 10:01 AM

Quote:

Originally Posted by ForceHSS (Post 2538648)

Search fix has only been done in vb4 version

This isn't the search bug.

The error is because there are no numbers between the parentheses...

Code:

... WHERE post_thanks.postid IN () ...

Unfortunately I do not know why it is happening or how to fix it- make sure there are some liked posts.

ForceHSS

02-25-2015 02:08 PM

Quote:

Originally Posted by BirdOPrey5 (Post 2538667)

This isn't the search bug.

Was looking at my old post above got it mixed up with his :)

mdawg

04-03-2015 04:28 AM

How about making this for vb 5 - vb5 is the wave of the future!

I was stuck in vb3 for years but now that I've upgraded to vb5 over all I am glad I made the move.

BirdOPrey5

04-03-2015 12:25 PM

VB5 has a built in likes system.

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

Page 235 of 240

235

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03580 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 (1)bbcode_code_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)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
Messages: