BBCodes Limit?

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Suggested Hosts
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
ham1299
Registered User
Posts: 613
Joined: Mon Sep 11, 2006 2:12 am
Location: USA
Contact:

BBCodes Limit?

Post by ham1299 »

Is there a limit on the number of custom BBCodes we can have?
Heather

User avatar
karlsemple
Former Team Member
Posts: 39802
Joined: Mon Nov 01, 2004 8:54 am
Location: Hereford, UK
Contact:

Re: BBCodes Limit?

Post by karlsemple »

ham1299 wrote:Is there a limit on the number of custom BBCodes we can have?

There used to be back in BETA, not sure if there still is, but it was in the thousands back in beta and I am sure the value was increased, so not sure you are going to hit the limit any time soon :)
Image

ham1299
Registered User
Posts: 613
Joined: Mon Sep 11, 2006 2:12 am
Location: USA
Contact:

Re: BBCodes Limit?

Post by ham1299 »

Hey, Karl! How are you? :D

Thanks. I'm getting an error message when I try to add some codes (for affiliates so I can list them in a post). Here's the error:

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Out of range value adjusted for column 'bbcode_id' at row 1 [1264]

SQL

INSERT INTO phpbb_bbcodes (bbcode_tag, bbcode_match, bbcode_tpl, display_on_posting, bbcode_helpline, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace, bbcode_id) VALUES ('Re', '[re][/re]', '<a href=\"http://www.kqzyfj.com/click-2722914-876227\" target=\"_blank\">ResumeEdge.com</a>\n<img src=\"http://www.lduhtrp.net/image-2722914-876227\" width=\"1\" height=\"1\" border=\"0\"/>', 0, '', '!\\[re\\]\\[/re\\]!i', '[re:$uid][/re:$uid]', '[re:$uid][/re:$uid]', '', 128)

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: includes/acp/acp_bbcodes.php
LINE: 215
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 471
CALL: acp_bbcodes->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
I'm making the tags so I can use the HTML for text links (like you showed me with PayPal). I've tried it with a few of my affiliates to see if it was the particular code, but I get the same error with each. :(
Heather

User avatar
karlsemple
Former Team Member
Posts: 39802
Joined: Mon Nov 01, 2004 8:54 am
Location: Hereford, UK
Contact:

Re: BBCodes Limit?

Post by karlsemple »

Via the Admin control panel go to the section to make a backup, then for the options select "structure only", "text", "download" and then select just the phpbb_bbcodes table and then post the resulting backup text here, this will show my just the structure of the bbcode database table :)
Image

ham1299
Registered User
Posts: 613
Joined: Mon Sep 11, 2006 2:12 am
Location: USA
Contact:

Re: BBCodes Limit?

Post by ham1299 »

Here it is:

Code: Select all

#
# phpBB Backup Script
# Dump of tables for phpbb_
# DATE : 27-01-2008 19:21:39 GMT
#
# Table: phpbb_bbcodes
DROP TABLE IF EXISTS phpbb_bbcodes;
CREATE TABLE `phpbb_bbcodes` (
  `bbcode_id` tinyint(3) NOT NULL default '0',
  `bbcode_tag` varchar(16) collate utf8_bin NOT NULL default '',
  `bbcode_helpline` varchar(255) collate utf8_bin NOT NULL default '',
  `display_on_posting` tinyint(1) unsigned NOT NULL default '0',
  `bbcode_match` text collate utf8_bin NOT NULL,
  `bbcode_tpl` mediumtext collate utf8_bin NOT NULL,
  `first_pass_match` mediumtext collate utf8_bin NOT NULL,
  `first_pass_replace` mediumtext collate utf8_bin NOT NULL,
  `second_pass_match` mediumtext collate utf8_bin NOT NULL,
  `second_pass_replace` mediumtext collate utf8_bin NOT NULL,
  PRIMARY KEY  (`bbcode_id`),
  KEY `display_on_post` (`display_on_posting`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
I had installed the MOD to make the first character of the BBCode buttons uppercase, in case that might be causing some issues.
Heather

User avatar
karlsemple
Former Team Member
Posts: 39802
Joined: Mon Nov 01, 2004 8:54 am
Location: Hereford, UK
Contact:

Re: BBCodes Limit?

Post by karlsemple »

had? Does that mean you have since removed it.... you might want to try removing it if not and then test just to rule it out.
Image

ham1299
Registered User
Posts: 613
Joined: Mon Sep 11, 2006 2:12 am
Location: USA
Contact:

Re: BBCodes Limit?

Post by ham1299 »

No, I haven't since removed it. But there weren't any SQL changes. I'll try it, though, just to check.
Heather

ham1299
Registered User
Posts: 613
Joined: Mon Sep 11, 2006 2:12 am
Location: USA
Contact:

Re: BBCodes Limit?

Post by ham1299 »

OK. I tried it, and that didn't work. I still get the error! :(
Heather

User avatar
karlsemple
Former Team Member
Posts: 39802
Joined: Mon Nov 01, 2004 8:54 am
Location: Hereford, UK
Contact:

Re: BBCodes Limit?

Post by karlsemple »

ham1299 wrote:OK. I tried it, and that didn't work. I still get the error! :(

Try running this Sql query

Code: Select all

 ALTER TABLE `phpbb_bbcodes` CHANGE `bbcode_id` `bbcode_id` SMALLINT( 3 ) NOT NULL DEFAULT '0'
although be sure to back everything up first :)
Image

ham1299
Registered User
Posts: 613
Joined: Mon Sep 11, 2006 2:12 am
Location: USA
Contact:

Re: BBCodes Limit?

Post by ham1299 »

Back everything up? You mean my whole database, or just the bbcodes part?
Heather

User avatar
karlsemple
Former Team Member
Posts: 39802
Joined: Mon Nov 01, 2004 8:54 am
Location: Hereford, UK
Contact:

Re: BBCodes Limit?

Post by karlsemple »

ham1299 wrote:Back everything up? You mean my whole database, or just the bbcodes part?
Well when making a change like this you should always make complete backups in case somegoes wrong so you can revert back...it is a safety thing. So before editing the database as I have asked you backup up everything, files and database so you have a complete backup of your board before making the changes :)
Image

ham1299
Registered User
Posts: 613
Joined: Mon Sep 11, 2006 2:12 am
Location: USA
Contact:

Re: BBCodes Limit?

Post by ham1299 »

OK. That's done. So, here goes ... now to check my site. BRB
Heather

ham1299
Registered User
Posts: 613
Joined: Mon Sep 11, 2006 2:12 am
Location: USA
Contact:

Re: BBCodes Limit?

Post by ham1299 »

That worked perfectly! :D Thanks so much!
Heather

User avatar
karlsemple
Former Team Member
Posts: 39802
Joined: Mon Nov 01, 2004 8:54 am
Location: Hereford, UK
Contact:

Re: BBCodes Limit?

Post by karlsemple »

ham1299 wrote:That worked perfectly! :D Thanks so much!

Appears the bbcode system may not be limited to a small number but as the column was a tinyint type of column in the database that forced a limit of 127, you have just changed the column type to smallint which will allow a higher value and thus more bbcodes.
Image

ham1299
Registered User
Posts: 613
Joined: Mon Sep 11, 2006 2:12 am
Location: USA
Contact:

Re: BBCodes Limit?

Post by ham1299 »

I wish I understood all of that! LOL But, it works - so I'm happy! :D Thanks again.
Heather

Locked

Return to “[3.0.x] Support Forum”