*

MB Themes

Re: create the database structure. Error number: 1214
« Reply #15 on: November 24, 2021, 06:57:41 PM »
@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:
Code: [Select]
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:
Code: [Select]
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.
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

CARS

  • ***
  • 33 posts
Re: create the database structure. Error number: 1214
« Reply #16 on: November 24, 2021, 07:07:51 PM »
Hi,

Thanks, that works fine. :)

I also receive this before the installation:

Fatal error: Uncaught Error: Undefined constant "OC_ADMIN-FOLDER" in...

Best regards,

*

MB Themes

Re: create the database structure. Error number: 1214
« Reply #17 on: November 24, 2021, 07:09:43 PM »
Provide full message with file and line reference
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

CARS

  • ***
  • 33 posts
Re: create the database structure. Error number: 1214
« Reply #18 on: November 25, 2021, 02:28:09 AM »
Hi,

This is the error message:

Fatal error: Uncaught Error: Undefined constant "OC_ADMIN_FOLDER" in /public_html/oc-includes/osclass/helpers/hErrors.php:108 Stack trace: #0 /public_html/oc-load.php(42): osc_get_absolute_url() #1 /public_html/index.php(25): require_once('/storage/conten...') #2 {main} thrown in /public_html/oc-includes/osclass/helpers/hErrors.php on line 108

Thanks in advance, have a great day.

*

MB Themes

Re: create the database structure. Error number: 1214
« Reply #19 on: November 25, 2021, 08:10:14 AM »
@CARS
Thank you, this notice does not represent issue, but you can fix it in file oc-includes/osclass/install-location.php by adding after this line (line #11):
Code: [Select]
define('LIB_PATH', ABS_PATH . 'oc-includes/');
Following line:
Code: [Select]
define('OC_ADMIN_FOLDER', 'oc-admin');
Will be also fixed in 8.0.1
Thanks ;)
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

CARS

  • ***
  • 33 posts
Re: create the database structure. Error number: 1214
« Reply #20 on: November 25, 2021, 02:27:53 PM »
Thanks! =)

One last question, when I change from InnoDB tables to MyISAM, what will happen when my hosting releases MySQL 5.7 and future versions? Can I "upgrade" somehow to InnoDB? Will I also be able to update OS Class just like normal?

Thanks again, have a nice day.

*

MB Themes

Re: create the database structure. Error number: 1214
« Reply #21 on: November 25, 2021, 02:45:14 PM »
@Cars
Nothing will happen and I am not sure if they could upgrade your DB without your knowledge.
You can change engine anytime later on.
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

CARS

  • ***
  • 33 posts
Re: create the database structure. Error number: 1214
« Reply #22 on: November 25, 2021, 03:41:21 PM »
Hi,

Thanks. :)

They will update in about 3 months or so, they told me.

How may I update it afterwards? :) Will everything still work when they update to for example 5.7 and I haven't updated the tables? :)

Best regards,

*

MB Themes

Re: create the database structure. Error number: 1214
« Reply #23 on: November 25, 2021, 04:26:02 PM »
Yes it will work ok after update, currently is osclass tested up to MySQL 8.0
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

CARS

  • ***
  • 33 posts
Re: create the database structure. Error number: 1214
« Reply #24 on: December 01, 2021, 07:46:19 AM »
Hi,

Many thanks.

I decided to buy another hosting/server, this one installed with php 8.0 and MySQL 5.7/mariaDB 10.2.

To my surprise I still couldn't install OS Class without the error 1214? :O

I don't know why, now I have the latest database etc.?

Also, when uploading all of the files to the root-folder and visit the URL, I receive 500 error with php 8.0, I have to go to the install folder manually. I am redirected though with php 7.4.

But still, the database structure cannot be created even with MySQL 5.7... :( :(

Best regards,

*

MB Themes

Re: create the database structure. Error number: 1214
« Reply #25 on: December 01, 2021, 08:57:48 AM »
@CARS
You are checking probably weird hosting companies.
If you received error 500, take a look into logs and provide details.
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

CARS

  • ***
  • 33 posts
Re: create the database structure. Error number: 1214
« Reply #26 on: December 01, 2021, 04:38:13 PM »
Hi, thanks, I understand what you mean, but no, this is a premium hosting dedicated server, it is not cheap at all. :(

I have tried with three hosting companies now, the two latest all have MySQL 5.7.

For notice, I haven't tried these just for OS Class, but for other CMS I'm running.

It cannot create the database structure resulting in error 1214.

Anyone else having these problems?

Best regards,

*

MB Themes

Re: create the database structure. Error number: 1214
« Reply #27 on: December 01, 2021, 05:30:55 PM »
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

CARS

  • ***
  • 33 posts
Re: create the database structure. Error number: 1214
« Reply #28 on: December 01, 2021, 05:39:45 PM »
Hi,

I am checking phpMyAdmin and it says mariaDB 10.2 fully compliant with MySQL 5.7. :(

I don't know what to do now. :(

Best regards,

*

CARS

  • ***
  • 33 posts
Re: create the database structure. Error number: 1214
« Reply #29 on: December 01, 2021, 05:46:40 PM »
For the 500 error on the server, I only receive it with php version 8.0, not with 7.4.

And it is only if I visit the root folder before installation, it won't redirect me with php 8.0, to the install folder/page.

Best regards,