Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Jun 2012
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Exclamation Can any one advice how can this be fixed?

    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

  • #2
    New to the CF scene
    Join Date
    Jun 2012
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thumbs up A Quick Edit to crebas.sql

    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


  •  

    Tags for this Thread

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •