[ROL-1251] roller.weblogentry table doesn't exists - apache-roller-2.3 - mysql/createdb.sql

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.3
• Fix Version/s: 3.0
• Component/s: Data Model & JPA Backend
• Environment: OS: debian-31r3-i386 Virtualized on Parallels Desktop ; MySQL: mysql-server-5.0_5.0.21 i386; hibernate-3.1.2
• Browser Version: --
• Database: mysql-server-5.0_5.0.21 i386
• JDK Version: jdk-1_5_0_09-linux-i586
• Level of effort: 0 - I've posted the solution, just modify the db script.
• O/S Version: debian-31r3-i386
• Assignee: David Johnson
• Reporter: Guido Angelo Ingenito
• Created: 01/Oct/06 21:28
• Updated: 05/Jan/13 20:46
• Resolved: 04/Oct/06 19:07

Description

The db script called createdb.sql placed under $ROLLER/WEB-INF/dbscripts/mysql/createdb.sql doesn't create the db table called weblogentry avoiding roller users to create entryes.

CAUSE:
create table weblogentry (
.....
tableattribute....
......
content_src varchar(512) default null
);

SHOULD BE CHANGED IN ( content_src varchar(255) default null OR content_src text default null):
eg.:
create table weblogentry (
.....
tableattribute....
......
content_src varchar(255) default null
);

because of the ERROR:

"ERROR 1074: Too big column length for column 'content_src' (mac = 255). Use BLOB instead"

produced silently by MySQL during the db creation.