vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Show Thread Enhancements - Thread Description (https://vborg.vbsupport.ru/showthread.php?t=131239)

Mupetz 12-21-2006 08:16 PM

Quote:

Originally Posted by Cybershaolin (Post 1142418)
There is also another bug for 3.6.4. When you want to edit a message by using the Edit (modifiy) button and if you decide to go in advance mode, you will get a DB error such as:

No error here ;)

KURTZ 12-21-2006 09:51 PM

what is the change log respect the previous version?

TrucLinh 12-22-2006 04:39 AM

vBulletin 3.6.4 dev with ERROR - NOT THIS MOD

But admin of vb.org want me to ... look at his post

I don't think he look at this... yes
http://www.vbulletin.com/forum/bugs3...iew&bugid=1218

transitbus
`completed` is it exit in vb3.6.4? If it have then we don't had this error, do you get it?

I add this in my update for 364, that why uninstall I DROP it, do you get it?

Look at MYSQL again PPPPPPPPP

Who the author here this not vb.org mod and your mod.

I Supported & FIX it ver to ver do I ?

One thing why i had to do you way?

You say "A couple of suggestions"

My MODS is ZIP or RAR ?

What are you T about?

IF!!! You are good. Why PM me, ask me for help ???

vb dev this vb364 with error why don't you go to vb dev tell they.

I want to do the best, I can!

No $$$$ here, do you get it!

TrucLinh 12-22-2006 04:53 AM

Quote:

ALTER TABLE `search` ADD `completed` SMALLINT UNSIGNED NOT NULL DEFAULT '1';
Admin vb.org tell me take it off my mod but that make the error

You G add this by your...

ERROR by vb dev

I don't want to update my mod by vb ver no more!

Now on Supported = OFF

ESL not my mom lang... don't want to say no more!

KURTZ 12-22-2006 11:22 PM

hey truclinh, unfortunately your hack has an issue :(

i've noticed that issue on vBcom ...

CHECK HERE

pls tell me if i can fix this issue (that i had with the previously version too) otherwise i must unistall your hack :(

TrucLinh 12-23-2006 07:15 AM

I make this mod by my need
I put it here for some one need it 2!
Install or Uninstall M not think to M
pls don't say thing like that with M

JohnBee 12-24-2006 03:02 AM

I also ran into this problem: MySQL Error : Unknown column 'completed' in 'where clause'
Error Number : 1054

I tried the fix posted here but it did not work:

An error occurred while attempting to execute your query. The following
Code:

information was returned.
error number: 1146
error desc: Table '364bb.search' doesn't exist


JohnBee 12-24-2006 03:11 AM

Quote:

Originally Posted by JohnBee (Post 1144298)
I also ran into this problem: MySQL Error : Unknown column 'completed' in 'where clause'
Error Number : 1054

I tried the fix posted here but it did not work:

An error occurred while attempting to execute your query. The following
Code:

information was returned.
error number: 1146
error desc: Table '364bb.search' doesn't exist


Okay It is resolved now - thx

adonfun 12-27-2006 10:13 PM

Thank you TrucLinh, I needed this one :)

transitbus 12-27-2006 10:19 PM

Instead of quoting your whole post TrucLinh, the reason I PM'd you asking for help is because at the time I was still trying to find the reason your addon caused these issues. I wass just lucky to find hte bug report on vb.com. If I had not posted back here and done the research you would still be having problems.

Long story short your mod now works as intended. You tried to modify a required field in a table used by the core aspects of vb. You have fixed your problem and your mod works now.

All is well.

KURTZ 12-30-2006 12:07 PM

unistalled too many issues on this hack :(

Brew 12-30-2006 04:28 PM

TrucLinh,

Don't give up on this mod ok?

It does have some issues but that is ok. Most mods have issues when they are first released because there is so much that can go wrong.

So stay with supporting this mod and things will get better!

Besides, if you leave this mod it could damage your reputation here at vb.org. I would hate to see that happen because you were nice enough to put this mod out for everyone.

Thanks for the mod!

Nik_s3 01-07-2007 06:12 PM

Quote:

Originally Posted by KURTZ (Post 1147483)
unistalled too many issues on this hack :(

Why?

I've installed ... and It works well.

Thank you

KURTZ 01-08-2007 02:13 AM

Quote:

Originally Posted by Nik_s3 (Post 1152795)
Why?

I've installed ... and It works well.

Thank you

READ HERE

KURTZ 01-08-2007 11:25 AM

dear Vietonline i really dont understand what you say to me ;) maybe i dont know too much the english language to understand what you say ... :)

why i must disable the plugin system?

have you see who tells me that is an error caused by this mod is PAUL M one of the Admins of THIS site ... and if you dont satisfied about this i can tell you that when i UNISTALLED this hack all runs perfectly on my board ...

however i agree with you when you tell me that i must to learn, but this not changes the fact that this hack unfortunately doesnt works correctly to me ...

Nik_s3 01-08-2007 12:03 PM

How can I modify the thread description? (after thread is posted)

KURTZ 01-08-2007 12:36 PM

Quote:

Originally Posted by Nik_s3 (Post 1153529)
How can I modify the thread description? (after thread is posted)

editing the thread :) but it's this the trouble!

TrucLinh 01-10-2007 02:17 AM

Quote:

Originally Posted by KURTZ (Post 1153553)
editing the thread :) but it's this the trouble!

Hi KURTZ!

Sorry it doesn't work on your sys.

When your sys error you not came tell me at my forum, you ask other not me, then you tell me my mod have issue!!! When this mod on my sys it work find! "Your sys not look like my sys! Please remember that!" when make mod I base on vBulletin Default.

It work find on my sys and other, alot of member dl install with out error when I 1st post here for vb361 to vb363, when vb364 "vb364 dev with error not the mod" but it fixed, I update it how many time I don't mem. (that alot of time on me) please don't make trouble here! If you are use my mod on your sys now!!!

If you don't like my mods please don't install it and please don't cont. look inside this thread for my update. Like I say Install or Uninstall M not think to M.

I need my time to do other thing!

TrucLinh

itdevil 01-13-2007 05:28 PM

Nice mod. thank You!

Cybershaolin 01-15-2007 10:16 PM

I have verified the version that I'm using and it's 1.0.0d. Now, I still have the same problem that I had before with it. I will try to explain clearly what's going on exactly with the 3.6.4 of vbulletin. I also have to say that I checked 3 times my templates editions.

When I try to modify a message in a thread which is not the first message of that thread, there is no problem at all but when I try to modify the first message of that thread this is where the trouble starts.

I'm testing in local but the same problem is reproduced with my online version of the forum.

So here are the steps I'm taking. Take note that the error happens in one case but not in another one:

Where I get an error:

If I modify the first message of the thread using the "Edit" button but then going in "Advance mode" , I get this url when I look in the browser header: (http://127.0.0.1/vb_364/forum/editpo...post&postid=87 )

Then, I click on "Save changes" and get this:

Quote:

Database error in vBulletin 3.6.4:

Invalid SQL:
UPDATE thread SET description = '' WHERE threadid = '24';

MySQL Error : The table 'vb_364.thread' doesn't exists
Error Number : 1146
Date : Wednesday, December 20th 2006 @ 04:54:03 PM
Script : http://monforum.com/forum/editpost.p...pdatepost&p=87
Referrer : http://monforum.com/forum/editpost.p...post&postid=87
Username : Netsurfer
Classname : vb_database
Where I don't get an error:

But, if I modify the first message of the thread clicking the "Edit" using my right button of the mouse and then make it open in a new window, I get this url: when I look in the browser header: (http://127.0.0.1/vb_364/forum/editpo...=editpost&p=87 ) and I don't get the error when clicking on "Save changes"

It's weird because the second time, it gives me a different url even if both options use the advance mode...

The difference between both url's is shown at the end with editpost&postid=87 which creates a bug and with editpost&p=87 which does not bug !

So why it does that, I don't know and would like to understand. How could I correct this?

I hope that you were able to understand my steps and that some other members will be able to reproduce this.

KURTZ 01-15-2007 10:22 PM

like i previously say: too many issues on this hack :(

cyber, i had the same error ... :(

TrucLinh 01-16-2007 03:40 AM

Netsurfer
Go here and Submit a New Bug ( it may be fixed => search vb.com )
http://www.vbulletin.com/forum/bugs36.php
please look inside some tutorial/book about Mysql "How to create table & column" to fix this error.
My Pa say! "I don't want TrucLinh help fix this vb dev bug. This mod do not create/call this missing table ' looking inside the file product-thread_description.xml and learn some php & Mysql before you say some thing about it! "you have ask vbviet.org your nick 'Netsurfer' you have table with table prefix 'vb_364.thread' then you'll need to prefix when you create this missing table ' You can do it , you want to be a Admin of a site you much learn some php & mysql!
DavidNg "
Quote:

Originally Posted by KURTZ (Post 1160208)
like i previously say: too many issues on this hack :(

cyber, i had the same error ... :(

Look in inside the XML "product-thread_description.xml" you see any line call this ( missing table & column + error with url links ) ??? Why you say this hack ??? Why you cont. look inside this thread for ???
When you have bug go here please (ask for right person)
Why I show you this !!! I nice with you do I? How about you ??? :)
http://www.vbulletin.com/forum/bugs36.php
You can read English please learn some php & Mysql, don't make trouble here! :)

Cybershaolin 01-16-2007 04:35 AM

If you say so. :cool: Not a way to talk to people looking for help and without having your php knowledge anyway. :p But, anyhow, I fixed it by modifying your hack! :D

In the module:

I changed this:

PHP Code:

$db->query_write("UPDATE thread SET description = '" $db->escape_string(htmlspecialchars_uni($edit['description'])) . "' WHERE threadid = '" $db->escape_string($threadinfo['threadid']) . "'"); 


for

PHP Code:

$db->query_write("UPDATE " TABLE_PREFIX "thread SET description = '" $db->escape_string(htmlspecialchars_uni($edit['description'])) . "' WHERE threadid = '" $db->escape_string($threadinfo['threadid']) . "'"); 

Now it works...

TrucLinh 01-16-2007 07:46 AM

HUM! My pa show you :)

Quote:

My Pa say! "you have table with table prefix 'vb_364.thread' then you'll need to prefix when you create this missing table ' You can do it ...
"Your sys not look like my sys! Please remember that!" when make mod I base on vBulletin Default."
You & some other install vb add prefix to it. When error all way say we are... When this mod on my/other sys it work find! :)

Other things hack db system you asking belong to tnguy3n not my, My modifications of that hack look good but it all way belong to tnguy3n of vbviet.org . I can't published without tnguy3n permission.

Devil Woman 01-23-2007 01:35 AM

Sorry to sound so dumb here but I cant find where to activate it for forum's, I have had a look through the posts and tried what it says but can't find it anywhere, any help is appreciated.

YLP1 02-04-2007 06:00 PM

Will the text in this field be searchable by vb search function? Thanks in advance.

Illustrious 03-07-2007 06:14 PM

Quote:

Originally Posted by Cybershaolin (Post 1160358)
If you say so. :cool: Not a way to talk to people looking for help and without having your php knowledge anyway. :p But, anyhow, I fixed it by modifying your hack! :D

In the module:

I changed this:

PHP Code:

$db->query_write("UPDATE thread SET description = '" $db->escape_string(htmlspecialchars_uni($edit['description'])) . "' WHERE threadid = '" $db->escape_string($threadinfo['threadid']) . "'"); 


for

PHP Code:

$db->query_write("UPDATE " TABLE_PREFIX "thread SET description = '" $db->escape_string(htmlspecialchars_uni($edit['description'])) . "' WHERE threadid = '" $db->escape_string($threadinfo['threadid']) . "'"); 

Now it works...

I had issues with the exact same error (running on vb3.6.5).

I tried your fix, and nothing happened. But the problem was that it was prefixing a period ('.') in front of the "thread" table, and thus it wasn't recognizing it in the database.

It would be nice to get it fixed.

deepak7 03-11-2007 04:51 PM

Hey

Its not working for me, nothing appears when I add/edit a thread.

I modified the 6 templates.
I uploaded the plugin.

Now, in admin cp... I seenothing about this on usergroup settings but I can see on forum manager setting (all set to YES... still not working)

2meplie 04-07-2007 09:13 PM

A couple of bugs:

1- When you type in a description and hit "preview" it does not carry the description through. So you have to remember to re-type it or it disappears.

2- When you edit a post you have the box to add/change the description but it does not update with the changes you made to that box.

DJLy5y 05-02-2007 07:45 PM

1 Attachment(s)
Adding fast change description by adming and mod ? Using moderation menu ? That will be fun :P And it will be nice to do some default description in admin pannel, and let the admin choose if simple users can change descriptions. :}

titorevolu 05-02-2007 10:58 PM

thanks, it works!!!! it works!!!

DJLy5y 05-05-2007 01:11 AM

It will be nice to add something like if thread description is "game" the thread color is red and when it's "door" the color is green ? And any chance to change thread names using the moderation options ? this one --- > https://vborg.vbsupport.ru/attachmen...9&d=1178133233

popular 07-10-2007 01:00 AM

is there a way to change font/color for the thread description?

nhatrang 08-04-2007 03:22 AM

how do we add this to replies as well? WE have it for new threads, what about a member wanting to use the title for the title of their reply, and also want a description? please help.

vspro 08-15-2007 02:22 PM

not worked at 3.6.8?

momo2 09-12-2007 03:04 PM

Installed on 3.6.8 works prefect how ever it did not show up, but after 2 times refreshing it showed up.............. Thanks

trancetopia 10-10-2007 11:31 AM

Hi, i've been having the update sql errors too. Is there an official fix planned for this mod?

I've also not been able to see the options in the forum permissions too.

This used to be so good on my older boards and need it for 3.6.8.

ps. Can't access your support link in the mod description - the forum is down so looking for support here if possible.

Thanks

inciarco 10-16-2007 03:48 AM

Quote:

Originally Posted by Cybershaolin (Post 1160358)
If you say so. :cool: Not a way to talk to people looking for help and without having your php knowledge anyway. :p But, anyhow, I fixed it by modifying your hack! :D

In the module:

I changed this:

PHP Code:

$db->query_write("UPDATE thread SET description = '" $db->escape_string(htmlspecialchars_uni($edit['description'])) . "' WHERE threadid = '" $db->escape_string($threadinfo['threadid']) . "'"); 


for

PHP Code:

$db->query_write("UPDATE " TABLE_PREFIX "thread SET description = '" $db->escape_string(htmlspecialchars_uni($edit['description'])) . "' WHERE threadid = '" $db->escape_string($threadinfo['threadid']) . "'"); 

Now it works...

Great Help Cybershaolin!! :up:

I was receiving an Error Message:

Code:

Database error in vBulletin 3.6.7:

Invalid SQL:
UPDATE thread SET description = 'Edici?n de Tema Para A?adir Descripci?n' WHERE threadid = '1973';

MySQL Error  : Table 'inciarc_foros.thread' doesn't exist
Error Number : 1146
Date        : Monday, October 15th 2007 @ 11:45:12 PM
Script      : http://zzz/editpost.php?do=updatepost&p=8980
Referrer    : http://zzz/editpost.php?do=editpost&postid=8980
IP Address  : zzz.zzz.zzz.zzz
Username    : zzz
Classname    : vb_database

According to Your Orientation, in the Admin Control Panel, in the Plugin System for the Add-Ons (Products), I've Located the "Thread Description - Update Description" Plugin and as You Said:

REPLACED:
Code:

$db->query_write("UPDATE thread SET description = '" . $db->escape_string(htmlspecialchars_uni($edit['description'])) . "' WHERE threadid = '" . $db->escape_string($threadinfo['threadid']) . "'");
WITH:
Code:

$db->query_write("UPDATE " . TABLE_PREFIX . "thread SET description = '" . $db->escape_string(htmlspecialchars_uni($edit['description'])) . "' WHERE threadid = '" . $db->escape_string($threadinfo['threadid']) . "'");
And Now The Error Message Is Not Happening, and The Edit of the Description is Successful!! ;)

Thank You very Much Again For Sharing This Excellent Solution!! :up:

My Best Regards!! ;)

:)

yoyoyoyo 11-01-2007 04:41 PM

1 Attachment(s)
Here is the XML file in TMS (Template Modification System) format, for those that have TMS installed.

I am also including the product, which is updated to avoid the error indicated in this thread, using the edits mentioned in this thread. (Note- I also changed the name of the product from ++++++ to Thread Description)

eng_matt 11-22-2007 12:08 AM

thanks


All times are GMT. The time now is 11:58 PM.

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.01543 seconds
  • Memory Usage 1,869KB
  • 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_code_printable
  • (6)bbcode_php_printable
  • (12)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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