Legacy Keywords and Descriptions for Forums

[Mick]

Hi,

I really like the way that I can edit threads to have my own Keywords and Descriptions for individual threads.

I wondered if you could add the ability to have your own keywords and descriptions on a per forum basis?

Is this something that is already possible? have I missed something?

Thanks for looking

Mick

 

[Fillip H.]

We'll take it into consideration for future versions

 

[Fillip H.]

Update: This will be implemented in v1.3.2, currently scheduled for release Monday

 

[Mick]

Thanks allot Fillip H., where will we edit these from admincp?

 

[Fillip H.]

vBulletin's Forum Manager.

 

[Mick]

Hi Fillip H.,

I have edited one of my forums here.

https://www.digitalworldz.co.uk/satellite-forums-539/

These are the keywords:
Digitalworldz, Satellite Forums, Satellite, forums, Dreambox, Technomate, Receivers, plugins, vu+, help, support, enigma, discussion, topics, emus, cams, shares, card, sky, uk, dish, linux, football, fixtures, feeds, astra, downloads, sat, boxes.

But when I view source they are not there?

view-source:https://www.digitalworldz.co.uk/satellite-forums-539/

Thank you.

Mick

 

[Fillip H.]

This should now be resolved, if you re-download v1.3.2 and re-upload /dbtech/dbseo/includes/class_core.php

 

[Mick]

HI Fillip H.,

I can only get 9 keywords to show:

Digitalworldz, Satellite Forums, Satellite, forums, Dreambox, Technomate, Receivers, plugins, vu+, help, support, enigma, discussion, topics, emus, cams, shares, card, sky, uk, dish, linux, football, fixtures, feeds, astra, downloads, sat, boxes.

It cuts it off here:

Digitalworldz, Satellite Forums, Satellite, forums, Dreambox, Technomate, Receivers, plugins, vu+,


Is there a set limit of 9 keywords or characters?

Regards
Mick

 

[Fillip H.]

The character limit is 255, as search engines tend to snip entries longer than 150-160 characters.


EDIT: Apparently it's even lower now: New Title Tag & Meta Description Character Limits

 

[Mick]

That is for the TITLE and the Description

I was talking about keywords:

and this is 98 anyway not 255?

Digitalworldz, Satellite Forums, Satellite, forums, Dreambox, Technomate, Receivers, plugins, vu+,

Regards
Mick

 

[Fillip H.]

Hmm, I'm unable to replicate any cut-off issues, I can save the full list of keywords you posted without issue. What's the character set in your database?

 

[Mick]

Hmm, I'm unable to replicate any cut-off issues, I can save the full list of keywords you posted without issue. What's the character set in your database?

Thanks for getting back to me Fillip H.,

Can you jog my memory what is the command for that in ssh mysql...

Cheers
Mick

 

[Fillip H.]

SHOW FULL COLUMNS FROM table_name;

 

[Mick]

Thank you

See below

##############################

+----------------------------------+--------------------------------+-------------------+------+-----+----------+----------------+---------------------------------+---------+
| Field                            | Type                           | Collation         | Null | Key | Default  | Extra          | Privileges                      | Comment |
+----------------------------------+--------------------------------+-------------------+------+-----+----------+----------------+---------------------------------+---------+
| forumid                          | smallint(5) unsigned           | NULL              | NO   | PRI | NULL     | auto_increment | select,insert,update,references |         |
| styleid                          | smallint(5) unsigned           | NULL              | NO   |     | 0        |                | select,insert,update,references |         |
| title                            | varchar(100)                   | latin1_swedish_ci | NO   |     |          |                | select,insert,update,references |         |
| title_clean                      | varchar(100)                   | latin1_swedish_ci | NO   |     |          |                | select,insert,update,references |         |
| description                      | text                           | latin1_swedish_ci | YES  |     | NULL     |                | select,insert,update,references |         |
| description_clean                | text                           | latin1_swedish_ci | YES  |     | NULL     |                | select,insert,update,references |         |
| options                          | int(10) unsigned               | NULL              | NO   |     | 0        |                | select,insert,update,references |         |
| displayorder                     | smallint(6)                    | NULL              | NO   |     | 0        |                | select,insert,update,references |         |
| replycount                       | int(10) unsigned               | NULL              | NO   |     | 0        |                | select,insert,update,references |         |
| lastpost                         | int(11)                        | NULL              | NO   |     | 0        |                | select,insert,update,references |         |
| lastposter                       | varchar(100)                   | latin1_swedish_ci | NO   |     |          |                | select,insert,update,references |         |
| lastthread                       | varchar(250)                   | latin1_swedish_ci | NO   |     |          |                | select,insert,update,references |         |
| lastthreadid                     | int(10) unsigned               | NULL              | NO   |     | 0        |                | select,insert,update,references |         |
| lasticonid                       | smallint(6)                    | NULL              | NO   |     | 0        |                | select,insert,update,references |         |
| threadcount                      | mediumint(8) unsigned          | NULL              | NO   |     | 0        |                | select,insert,update,references |         |
| daysprune                        | smallint(6)                    | NULL              | NO   |     | 0        |                | select,insert,update,references |         |
| newpostemail                     | text                           | latin1_swedish_ci | YES  |     | NULL     |                | select,insert,update,references |         |
| newthreademail                   | text                           | latin1_swedish_ci | YES  |     | NULL     |                | select,insert,update,references |         |
| parentid                         | smallint(6)                    | NULL              | NO   |     | 0        |                | select,insert,update,references |         |
| parentlist                       | varchar(250)                   | latin1_swedish_ci | NO   |     |          |                | select,insert,update,references |         |
| password                         | varchar(50)                    | latin1_swedish_ci | NO   |     |          |                | select,insert,update,references |         |
| link                             | varchar(200)                   | latin1_swedish_ci | NO   |     |          |                | select,insert,update,references |         |
| childlist                        | text                           | latin1_swedish_ci | YES  |     | NULL     |                | select,insert,update,references |         |
| importforumid                    | bigint(20)                     | NULL              | NO   |     | 0        |                | select,insert,update,references |         |
| importcategoryid                 | bigint(20)                     | NULL              | NO   |     | 0        |                | select,insert,update,references |         |
| lastpostid                       | int(10) unsigned               | NULL              | NO   |     | NULL     |                | select,insert,update,references |         |
| showprivate                      | tinyint(3) unsigned            | NULL              | NO   |     | NULL     |                | select,insert,update,references |         |
| defaultsortfield                 | varchar(50)                    | latin1_swedish_ci | NO   |     | lastpost |                | select,insert,update,references |         |
| defaultsortorder                 | enum('asc','desc')             | latin1_swedish_ci | NO   |     | desc     |                | select,insert,update,references |         |
| seo_videos_bar                   | set('enabled','disabled')      | latin1_swedish_ci | NO   |     | disabled |                | select,insert,update,references |         |
| seo_videos_bar_source            | set('google','youtube','both') | latin1_swedish_ci | NO   |     | both     |                | select,insert,update,references |         |
| seo_videos_bar_videos            | int(3)                         | NULL              | NO   |     | 4        |                | select,insert,update,references |         |
| lastprefixid                     | varchar(25)                    | latin1_swedish_ci | NO   |     |          |                | select,insert,update,references |         |
| imageprefix                      | varchar(100)                   | latin1_swedish_ci | NO   |     |          |                | select,insert,update,references |         |
| fbtarget_id                      | varchar(255)                   | latin1_swedish_ci | NO   |     |          |                | select,insert,update,references |         |
| fbuid                            | varchar(255)                   | latin1_swedish_ci | NO   |     |          |                | select,insert,update,references |         |
| fbtarget_id_permission_granted   | varchar(255)                   | latin1_swedish_ci | NO   |     |          |                | select,insert,update,references |         |
| vbseo_moderatepingbacks          | int(10) unsigned               | NULL              | NO   |     | 1        |                | select,insert,update,references |         |
| vbseo_moderatetrackbacks         | int(10) unsigned               | NULL              | NO   |     | 1        |                | select,insert,update,references |         |
| vbseo_moderaterefbacks           | int(10) unsigned               | NULL              | NO   |     | 1        |                | select,insert,update,references |         |
| lastposterid                     | int(10) unsigned               | NULL              | NO   |     | 0        |                | select,insert,update,references |         |
| vbseo_enable_likes               | int(10) unsigned               | NULL              | NO   |     | 1        |                | select,insert,update,references |         |
| dbtech_thanks_firstpostonly      | int(10) unsigned               | NULL              | NO   |     | 0        |                | select,insert,update,references |         |
| dbtech_vbanswers_solution        | int(10) unsigned               | NULL              | NO   |     | 20       |                | select,insert,update,references |         |
| dbtech_vbanswers_bestanswer      | int(10) unsigned               | NULL              | NO   |     | 10       |                | select,insert,update,references |         |
| dbtech_vbanswers_goodanswer      | int(10) unsigned               | NULL              | NO   |     | 5        |                | select,insert,update,references |         |
| dbtech_vbanswers_show            | tinyint(1) unsigned            | NULL              | NO   |     | 0        |                | select,insert,update,references |         |
| dbtech_usertag_enabletag         | tinyint(1) unsigned            | NULL              | NO   |     | 1        |                | select,insert,update,references |         |
| dbtech_usertag_enablemention     | tinyint(1) unsigned            | NULL              | NO   |     | 1        |                | select,insert,update,references |         |
| dbtech_usertag_enablequote       | tinyint(1) unsigned            | NULL              | NO   |     | 1        |                | select,insert,update,references |         |
| dbtech_usertag_enablehash        | tinyint(1) unsigned            | NULL              | NO   |     | 1        |                | select,insert,update,references |         |
| dbtech_thanks_disabledbuttons    | int(10) unsigned               | NULL              | NO   |     | 0        |                | select,insert,update,references |         |
| dbtech_thanks_hide_threshold     | int(10) unsigned               | NULL              | NO   |     | 10       |                | select,insert,update,references |         |
| forumiconimg                     | varchar(100)                   | latin1_swedish_ci | NO   |     |          |                | select,insert,update,references |         |
| forumiconimg_forum_width         | smallint(3) unsigned           | NULL              | NO   |     | 48       |                | select,insert,update,references |         |
| forumiconimg_forum_height        | smallint(3) unsigned           | NULL              | NO   |     | 48       |                | select,insert,update,references |         |
| excludable                       | int(10) unsigned               | NULL              | NO   |     | 0        |                | select,insert,update,references |         |
| dbtech_dbforms_enabledcategories | int(10) unsigned               | NULL              | NO   |     | 0        |                | select,insert,update,references |         |
| dbtech_dbseo_keywords            | varchar(255)                   | latin1_swedish_ci | NO   |     |          |                | select,insert,update,references |         |
| dbtech_dbseo_description         | varchar(255)                   | latin1_swedish_ci | NO   |     |          |                | select,insert,update,references |         |
| dbtech_dbforms_defaultcategoryid | int(10) unsigned               | NULL              | NO   |     | 0        |                | select,insert,update,references |         |
+----------------------------------+--------------------------------+-------------------+------+-----+----------+----------------+---------------------------------+---------+
61 rows in set (0.00 sec)

If that looks untidy check this image



##############################

 

[Fillip H.]

Can you try manually setting the keywords in the DB and see if that works? You'll have to edit and save any random forum (except for the one you're editing) in order for the changes to take effect.