...

View Full Version : Can any one advice how can this be fixed?



devportguru
06-06-2012, 09:09 AM
ReOS

Error while executing installation SQL statements

This means that the your MySQL database installation doesn't execute ReOS installation SQL scripts.

If you're unsure what these terms mean you should probably contact your host. If you still need help you can always visit the ReOS Support Site.

1411 errors found !

Database error: Invalid SQL: /* ReOS is a vertical software for real estates. */ /* Copyright 2010 IT ELAZOS S.L. */ /* This file is part of ReOS v2.x.x. */ /* ReOS is free software: you can redistribute it and/or modify */ /* it under the terms of the GNU Affero General Public License as published by */ /* the Free Software Foundation, either version 3 of the License, or */ /* (at your option) any later version. */ /* ReOS is distributed in the hope that it will be useful, */ /* but WITHOUT ANY WARRANTY, without even the implied warranty of */ /* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the */ /* GNU General Public License for more details. */ /* You should have received a copy of the GNU Affero General Public License */ /* along with ReOS. If not, see . */ /*==============================================================*/ /* Database name: ReOS 2.0.5 */ /* DBMS name: MySQL 5.0 */ /* Created on: 01/03/2010 18:16:47 */ /*==============================================================*/ /*==============================================================*/ /* Table: _acc_perfil */ /*==============================================================*/ create table _acc_perfil ( id_account integer not null, dt_create date, ind_active tinyint, tp_servicio set('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20'), tp_propiedad set('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20'), set_properties set('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20'), ind_piscina tinyint, num_parking smallint, num_wc smallint, num_dormitorios smallint, int_superficie_const smallint, int_superficie smallint, precio_alquiler decimal(10,0), precio_compra decimal(10,0), txt_comment varchar(255), primary key (id_account) ) type = innodb character set = utf8
MySQL Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'type = innodb character set = utf8' at line 47

Database error: Invalid SQL: insert into _perms (id_perm,nm_profile,txt_obsrv) values (1,'_ADMIN','Administrator');
MySQL Error: 1146 Table 'sr._perms' doesn't exist

Database error: Invalid SQL: insert into _perms (id_perm,nm_profile,txt_obsrv) values (2,'_SUPPORT','Customer Service');
MySQL Error: 1146 Table 'sr._perms' doesn't exist

Database error: Invalid SQL: insert into _perms (id_perm,nm_profile,txt_obsrv) values (3,'_UNKOWN','No Definido');
MySQL Error: 1146 Table 'sr._perms' doesn't exist

Database error: Invalid SQL: insert into _perms (id_perm,nm_profile,txt_obsrv) values (4,'_REOS_TEAM_MANAGER','ReOS Team Manager');
MySQL Error: 1146 Table 'sr._perms' doesn't exist

Database error: Invalid SQL: insert into _perms (id_perm,nm_profile,txt_obsrv) values (5,'_REOS_TEAM_MEMBER','ReOS Team Member');
MySQL Error: 1146 Table 'sr._perms' doesn't exist

Database error: Invalid SQL: insert into _perms (id_perm,nm_profile,txt_obsrv) values (6,'_REOS_MANAGER','ReOS Manager');
MySQL Error: 1146 Table 'sr._perms' doesn't exist

Database error: Invalid SQL: insert into _perms (id_perm,nm_profile,txt_obsrv) values (7,'_REOS_ADMIN','ReOS Administrator');
MySQL Error: 1146 Table 'sr._perms' doesn't exist

Database error: Invalid SQL: insert into _screens (id_screen,nm_screen,txt_obsrv,app_file) values (1,'_ADMIN','Administration','home');
MySQL Error: 1146 Table 'sr._screens' doesn't exist

Database error: Invalid SQL: insert into _screens (id_screen,nm_screen,txt_obsrv,app_file) values (2,'_MY_PROFILE','My Profile','home');
MySQL Error: 1146 Table 'sr._screens' doesn't exist

Database error: Invalid SQL: insert into _screens (id_screen,nm_screen,txt_obsrv,app_file) values (3,'_PREFERE','Preferences','home');
MySQL Error: 1146 Table 'sr._screens' doesn't exist

Database error: Invalid SQL: insert into _screens (id_screen,nm_screen,txt_obsrv,app_file) values (4,'_MKT','Mailings','home');
MySQL Error: 1146 Table 'sr._screens' doesn't exist



The errors goes on and on i have attached a file with error

you can download this cms from here
here (http://sourceforge.net/projects/reosrealestate/files/reosrealestate/ReOS%202.0.5/ReOS_v2_0_5_elazos.zip/download)

chris-brueck
06-24-2012, 09:46 PM
It's not an issue with ReOS.

I solved this for myself, but I'm not sure about your MySQL version. I have MySQL version 5.5.24 running on Linux. It's a ridiculous MySQL error. It occurs, because MySQL (for whatever reason) doesn't support "type" variable anymore when creating tables. It's been replaced with "engine" in the more recent MySQL versions.

For the sake of backward compatibility, I'm not sure why they'd completely remove that. I've seen a lot of mySQL issues regarding this out there.

So, here's how I fixed the ReOS Setup for myself (a quick minor hack):

1) Open cresbas.sql file from the install/ directory with your favorite text editor
2) Replace ALL the "type = innodb" strings with "engine = innodb"

Or, if you're running linux, you can simply run this shell command in the install/ directory:

sed -i 's/type = innodb/engine = innodb/g' crebas.sql

Note: don't simply replace "type" with "engine". Replace the entire string, so as not to affect any other part of the sql script.

Then just rerun your ReOS setup from the start...

I hope this helped. Please reply to this post if this solved your issue...and which mySQL version and OS you're running. Thanks!

Chris Brueck



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum