vb.org Archive - New Posting Features - [DBTech] Advanced Post Thanks / Like v3 (vB4) [AJAX]

Hi ForceHSS

Erro

Query SQL:

ALTER TABLE `language`
ADD COLUMN `phrasegroup_dbtech_thanks` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL AFTER `phrasegroup_dbtech_vbshout`

Mensagem do MySQL: Documenta??o
#1054 - Unknown column 'phrasegroup_dbtech_vbshout' in 'language'

From your admincp run these querys

Code:

ALTER TABLE `language`

  DROP `phrasegroup_dbtech_thanks`;

This will add the line in the table pick whatever one you need

Code:

ALTER TABLE `language`

ADD COLUMN `phrasegroup_dbtech_thanks`  mediumtext CHARACTER SET utf8  COLLATE utf8_unicode_ci NOT NULL AFTER `phrasegroup_dbtech_vbshout`;

Both have been tested and will work for your admincp/Maintenance/Execute SQL Query

louva-a-Deus

04-03-2014 08:51 PM

Hi ForceHSS

C?digo do erro: 1091
Descri??o do erro: Can't DROP 'phrasegroup_dbtech_thanks'; check that column/key exists

Powered by vBulletin™ Version 4.2.2 Patch Level 1 Copyright ? 2014 vBulletin Solutions, Inc. All rights reserved.

doogie88

04-03-2014 09:49 PM

Swear I asked this before but it appears I have no posts in this thread.
How do I fix this error. Get about 100 per day.

Database error in vBulletin 4.2.1:

Invalid SQL:

REPLACE INTO search (userid, ipaddress, personal, searchuser, forumchoice,
sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms,
searchhash)
VALUES (0, '66.249.75.34', 1, 'Rotator', '', 'post.dateline', 'DESC', 0.00062, 1,
'150517,150480', 1386700209,
'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{} s:6:\"common\";a:0:{}s:5:\"users\";a:1:{i:684;s:7: \"Rotator\";}s:6:\"forums\";i:0;s:7:\"options\";a: 3:{s:11:\"starteronly\";i:0;s:11:\"childforums\";i :1;s:6:\"action\";s:7:\"process\";}}',
'5b2dbcc6a301bea5afb8a7fce3c08fbf');

MySQL Error : Table 'wxxw_xxx.search' doesn't exist
Error Number : 1146
Request Date : Tuesday, December 10th 2013 @ 12:30:09 PM
Error Date : Tuesday, December 10th 2013 @ 12:30:09 PM
Script : http://www.xxx.com/post_thanks.php?do=findthanks&u=684
Referrer :
IP Address : 66.249.xxx
Username : Unregistered
Classname : vB_Database
MySQL Version :

ForceHSS

04-03-2014 09:56 PM

That table was removed some time ago in vb4 but the info seems to be stored in some of your tables. The table is now called searchlog from what I remember

ForceHSS

04-03-2014 09:58 PM

Quote:

Originally Posted by louva-a-Deus (Post 2491263)

Hi ForceHSS

C?digo do erro: 1091
Descri??o do erro: Can't DROP 'phrasegroup_dbtech_thanks'; check that column/key exists

Powered by vBulletin? Version 4.2.2 Patch Level 1 Copyright ? 2014 vBulletin Solutions, Inc. All rights reserved.

You can't drop what you don't have run the other query

doogie88

04-03-2014 10:05 PM

Quote:

Originally Posted by ForceHSS (Post 2491276)

That table was removed some time ago in vb4 but the info seems to be stored in some of your tables. The table is now called searchlog from what I remember

Are you replying to me?
if so how do I fix it?

sovatoli

04-03-2014 10:18 PM

Thank's

ForceHSS

04-03-2014 11:19 PM

Quote:

Originally Posted by doogie88 (Post 2491278)

Are you replying to me?
if so how do I fix it?

Try posting in unpaid section if that does not work try paid section

doogie88

04-04-2014 12:05 AM

Sorry I don't come here often, what do you mean by unpaid section? I thought this is where I was?

ForceHSS

04-04-2014 12:19 AM

Quote:

Originally Posted by doogie88 (Post 2491322)

Sorry I don't come here often, what do you mean by unpaid section? I thought this is where I was?

No this is where the plugin is unpaid section is here and paid section is here but before you post there can you post all plugins being used and if possible a link to each one. If you have ever used this plugin I posted a fix for it sometime ago here

All times are GMT. The time now is 07:38 PM.

Page 214 of 277

214

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02959 seconds Memory Usage 1,747KB 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 (2)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 (5)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: