Can't create the database structure. Error number: 1214

@leraat
Make sure to use latest MySQL version, ideally 5.7+ (8.0)

Hi!

First, thanks for a great Classifieds Script!

I am also having the same problem as the poster, error code 1214, can't creat database structure when trying to install the CMS.

I have tried with every compatible PHP version from 5.7, 7.1, 7.3, 7.4 and 8.0 etc., it doesn't work.

My server is Linux based (hosting) and runs well with all other CMS-systems.

Do you have any suggestions?

Thanks in advance.

Best regards,

@CARS
Make sure your database user has all available privileges.

Hi,

Thanks for your reply.

Yes, everything is setup correct, all the privileges.

I have installed every other CMS with the same database settings.

I have no idea why it doesn't work, the exact same database can install for example Wordpress, etc.

Thanks in advance.

Best regards,

https://stackoverflow.com/questions/20964269/1214-the-used-table-type-doesnt-support-fulltext-indexes

It looks you are using old MySQL version.
Try to use 5.7 or 8.0

Hi,

I checked and my hosting company is using the latest version.

I have no idea why this is happening, every other CMS works.

Best regards,

I guess this problem is because t_item_description table use InnoDB engine and full-text search index.
Previously it was using myisam because innodb did not supported it.
You can update oc-includes/osclass/install/struct.sql and change InnoDB to MyISAM for this one table before installation.

Btw. which one is latest version? Is your database created using latest version as well?

Hi again,

Many thanks for your replies, appreciate it.

I checked again, with phpMyAdmin, and the MySQL has version 5.5.52 mariaDB-cll-lve.

I am running this on a hosting with Linux server php 8.0.

Everything checks "green" if I visit to the install folder URL, but end up with error 1214.

Also, if I go directly to the root folder / URL, where I put OS Classifieds, I get the following error: Fatal error: Uncaught Error: Undefined constant "OC_ADMIN-FOLDER" in...



Best regards,

@CARS

I checked and my hosting company is using the latest version.

MySQL has version 5.5.52

MySQL      5.5   3 December 2010   Dec 2018

Latest?
... udpate your MySQL and do not try to re-invent wheel

Hi,

They were using it before, but reverted back it seems, and wont update for some while.

Is it impossible to run OS Class on the forked version om MySQL = mariaDB, in this case version 5.5.52?

Also, do you know why I receive the error message while visiting the root folder URL, before installation?

Thanks again, have a great day.

@CARS
Why would you install brand new osclass on MySQL 5.5? Does not make sense at all.
You have to go to file:
oc-includes/osclass/installer/struct.sql

Find this section:
CREATE TABLE /*TABLE_PREFIX*/t_item_description (
  fk_i_item_id INT(10) UNSIGNED NOT NULL,
  fk_c_locale_code CHAR(5) NOT NULL,
  s_title VARCHAR(100) NOT NULL,
  s_description MEDIUMTEXT NOT NULL,
  PRIMARY KEY (fk_i_item_id, fk_c_locale_code),
  FULLTEXT s_description (s_description, s_title)
) ENGINE=InnoDB DEFAULT CHARACTER SET 'UTF8' COLLATE 'UTF8_GENERAL_CI';

And change it to:
CREATE TABLE /*TABLE_PREFIX*/t_item_description (
  fk_i_item_id INT(10) UNSIGNED NOT NULL,
  fk_c_locale_code CHAR(5) NOT NULL,
  s_title VARCHAR(100) NOT NULL,
  s_description MEDIUMTEXT NOT NULL,
  PRIMARY KEY (fk_i_item_id, fk_c_locale_code),
  FULLTEXT s_description (s_description, s_title)
) ENGINE=MyISAM DEFAULT CHARACTER SET 'UTF8' COLLATE 'UTF8_GENERAL_CI';

Then you can initiate installation.

Hi,

My hosting only has mariaDB 5.5.52 for the moment, I don't know why exactly, they didn't specify.

PHP version is of version 8.0

Will this change in code affect future versions/updates?

PS, many thanks for the info.

Best regards,

@CARS
If your hosting has only MySQL 5.5, it is not hosting, just some crap... change it, instantly, you are wasting your time.
Database issues are not related to PHP version.

If you install Osclass 8.0.0 with this change, it will not be a problem anymore.

Hi,

Believe it or not, but they are actually one of the largest hosting companies here, not some cheap hosting. :O

It is very strange that they only offer mariaDB 5.5.52 (for the moment), I have pointed this out to them.

Yes of course, I just wanted to clarify the PHP version.

I am receiving the error message I wrote about above, when visiting the root folder / URL, before installing, what could cause that?

Best regards and many thanks for your support.