By Saulo on

Hi!

It would like to know if it exists a number has limited for the creation of blocks (admin/block/add)?

I have perceived that after to create 127 blocks (VALUE "127") the system presents the following error:
-----------------------------------------------------------------------------------------
user error: Duplicate entry '127' for key 1 query: INSERT INTO boxes (title, body, info, format) VALUES ('', '', '', 3) em /home/shnet/public_html/guia/v2/includes/database.mysql.inc na linha 66.
-----------------------------------------------------------------------------------------

Already I read the respect of this error in other topics of forum, and say to be regarding the repetition of title or description... but I guarantee that no heading of block or its description is not repeated. I made a test in localhost with a clean system, without nothing, and created 127 blocks... but when I was to create the next one, it also it presented this exactly error. In 4.6.5 and 4.7 beta4 versions.

Somebody would know to solve this problem?

Thanks

⋅ Categories: Drupal 4.6.x

Comments

bradlis7’s picture

bradlis7 commented

This has to do with the mysql tables. If you have phpMyAdmin, or can do sql statements, you can change this. You'll need to go to the boxes table in your drupal database, and change the field 'bid' from 'tinyint' to 'smallint', or 'int' if you want to be totally sure.

If you don't have phpMyAdmin, you'll have to do a mysql statement, but I don't know exactly what it is.

--
Bradlis7.com | Churchofchristnet

Saulo’s picture

Saulo commented

Hey, bradlis7 ...

I changed 'tinyint' to 'int' in field 'bid'... the result was perfect, using
phpMyAdmin. Very good!

Thanks!
Saulo

www.sacrahome.net

bradlis7’s picture

bradlis7 commented

That's good.

I submitted a bug so that it will be fixed in the next versions hopefully.
--
Bradlis7.com | Churchofchristnet

dsnydernc’s picture

dsnydernc commented

This was driving me nuts :) Thanks very much for the tip, worked perfectly.