[TYPO3-project-realty] Install Problem - CREATE TABLE tx_ralty_objects fails

[Christophe Stadler]

Hi,

I tried several times to install the extension via Extension Manager from
repository and via upload. I made sure the database was clean and didn't
have any rmnants from previous install attempts. I always get the same
problem, during the install the following code fails:

CREATE TABLE tx_realty_objects (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) NOT NULL default '0',
tstamp int(11) NOT NULL default '0',
crdate int(11) NOT NULL default '0',
cruser_id int(11) NOT NULL default '0',
t3ver_oid int(11) NOT NULL default '0',
t3ver_id int(11) NOT NULL default '0',
t3ver_wsid int(11) NOT NULL default '0',
t3ver_label varchar(30) NOT NULL default '',
t3ver_state tinyint(4) NOT NULL default '0',
t3ver_stage tinyint(4) NOT NULL default '0',
t3ver_count int(11) NOT NULL default '0',
t3ver_tstamp int(11) NOT NULL default '0',
t3_origuid int(11) NOT NULL default '0',
sys_language_uid int(11) NOT NULL default '0',
l18n_parent int(11) NOT NULL default '0',
l18n_diffsource mediumblob NOT NULL,
deleted tinyint(4) NOT NULL default '0',
hidden tinyint(4) NOT NULL default '0',
is_dummy_record tinyint(1) unsigned NOT NULL default '0',
starttime int(11) NOT NULL default '0',
endtime int(11) NOT NULL default '0',
object_number tinytext NOT NULL,
object_type int(11) NOT NULL default '0',
title tinytext NOT NULL,
emphasized tinyint(3) NOT NULL default '0',
street tinytext NOT NULL,
zip tinytext NOT NULL,
city int(11) NOT NULL default '0',
district int(11) NOT NULL default '0',
number_of_rooms tinytext NOT NULL,
living_area tinytext NOT NULL,
total_area tinytext NOT NULL,
rent_excluding_bills tinytext NOT NULL,
extra_charges tinytext NOT NULL,
heating_included tinyint(3) NOT NULL default '0',
deposit tinytext NOT NULL,
provision tinytext NOT NULL,
usable_from tinytext NOT NULL,
buying_price tinytext NOT NULL,
year_rent tinytext NOT NULL,
rented tinyint(3) NOT NULL default '0',
apartment_type int(11) NOT NULL default '0',
house_type int(11) NOT NULL default '0',
floor int(11) NOT NULL default '0',
floors int(11) NOT NULL default '0',
bedrooms int(11) NOT NULL default '0',
bathrooms int(11) NOT NULL default '0',
heating_type int(11) NOT NULL default '0',
garage_type int(11) NOT NULL default '0',
garage_rent tinytext NOT NULL,
garage_price tinytext NOT NULL,
pets int(11) NOT NULL default '0',
construction_year int(11) NOT NULL default '0',
state int(11) NOT NULL default '0',
balcony tinyint(3) NOT NULL default '0',
garden tinyint(3) NOT NULL default '0',
elevator tinyint(3) NOT NULL default '0',
accessible tinyint(3) NOT NULL default '0',
assisted_living tinyint(3) NOT NULL default '0',
fitted_kitchen tinyint(3) NOT NULL default '0',
description text NOT NULL,
equipment text NOT NULL,
layout tinytext NOT NULL,
location text NOT NULL,
misc text NOT NULL,
details_page tinytext,
images int(11) NOT NULL default '0',
employer text NOT NULL,
openimmo_anid text NOT NULL,
openimmo_obid text NOT NULL,
utilization text NOT NULL,
contact_person text NOT NULL,
contact_email text NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);

I also tried injecting this directly into the database via phpmyadmin but i
get loads of syntax erros. As a result i cannot create any realty object,
the rest of the system works fine.

I am using oelib 0.4.1, the server is running MYSQL 5.1.25-rc, PHP 5.2.6 and
Typo3 4.2.1.

Thx for any help with this ...
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.netfielders.de/pipermail/typo3-project-realty/attachments/20080716/c07a05f8/attachment.htm