Page 1 of 1

failed install of free version on ubuntu 20.x

PostPosted: 17 Sep 2021, 05:55
by rvknow
Hi, Ive tried on 2 attempts to submit a request on your companies web site without success.

I have tried to install the free version in order to evaluate your software for purchase however the install failed.
Im trying to install the free version on Ubuntu 20.x using MySql and Apache2 and the install generates the following error.

CDbCommand failed to execute the SQL statement: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'osre.ore_xi_apartment' doesn't exist

Upon inspecting MySql, this table was not created during the install however many others were.
I dont know the params of this table so I cant create it manually.
Can you provide a solution to this issue?

here is the output of MySql DB osre

mysql> SHOW FULL TABLES FROM osre;
+---------------------------------------+------------+
| Tables_in_osre | Table_type |
+---------------------------------------+------------+
| ore_xi_apartment_city | BASE TABLE |
| ore_xi_apartment_complain | BASE TABLE |
| ore_xi_apartment_complain_reason | BASE TABLE |
| ore_xi_apartment_document | BASE TABLE |
| ore_xi_apartment_obj_type | BASE TABLE |
| ore_xi_apartment_panorama | BASE TABLE |
| ore_xi_apartment_reference | BASE TABLE |
| ore_xi_apartment_reference_categories | BASE TABLE |
| ore_xi_apartment_reference_values | BASE TABLE |
| ore_xi_apartment_statistics | BASE TABLE |
| ore_xi_apartment_times_in | BASE TABLE |
| ore_xi_apartment_times_out | BASE TABLE |
| ore_xi_apartment_video | BASE TABLE |
| ore_xi_apartment_window_to | BASE TABLE |
| ore_xi_articles | BASE TABLE |
| ore_xi_block_ip | BASE TABLE |
| ore_xi_booking_table | BASE TABLE |
| ore_xi_carousel | BASE TABLE |
| ore_xi_carousel_images | BASE TABLE |
| ore_xi_clients | BASE TABLE |
| ore_xi_comments | BASE TABLE |
| ore_xi_comparison_list | BASE TABLE |
| ore_xi_configuration | BASE TABLE |
| ore_xi_custom_html | BASE TABLE |
| ore_xi_entries | BASE TABLE |
| ore_xi_entries_all_tags | BASE TABLE |
| ore_xi_entries_category | BASE TABLE |
| ore_xi_entries_image | BASE TABLE |
| ore_xi_formdesigner | BASE TABLE |
| ore_xi_formdesigner_obj_type | BASE TABLE |
| ore_xi_images | BASE TABLE |
| ore_xi_infopages | BASE TABLE |
| ore_xi_lang | BASE TABLE |
| ore_xi_lang_widget_opt | BASE TABLE |
| ore_xi_menu | BASE TABLE |
| ore_xi_menu_list | BASE TABLE |
| ore_xi_news_product | BASE TABLE |
| ore_xi_notifier | BASE TABLE |
| ore_xi_object_image | BASE TABLE |
| ore_xi_payments_atol | BASE TABLE |
| ore_xi_reviews | BASE TABLE |
| ore_xi_search_form | BASE TABLE |
| ore_xi_seo_friendly_url_history | BASE TABLE |
| ore_xi_service | BASE TABLE |
| ore_xi_socialauth | BASE TABLE |
| ore_xi_themes | BASE TABLE |
| ore_xi_translate_message | BASE TABLE |
| ore_xi_users | BASE TABLE |
| ore_xi_users_sessions | BASE TABLE |
| ore_xi_users_social | BASE TABLE |
| ore_yd_apartment_complain | BASE TABLE |
| ore_yd_apartment_complain_reason | BASE TABLE |
| ore_yd_apartment_document | BASE TABLE |
| ore_yd_apartment_obj_type | BASE TABLE |
| ore_yd_apartment_panorama | BASE TABLE |
| ore_yd_apartment_reference | BASE TABLE |
| ore_yd_apartment_reference_categories | BASE TABLE |
| ore_yd_apartment_reference_values | BASE TABLE |
| ore_yd_apartment_statistics | BASE TABLE |
| ore_yd_apartment_times_in | BASE TABLE |
| ore_yd_apartment_times_out | BASE TABLE |
| ore_yd_apartment_video | BASE TABLE |
| ore_yd_apartment_window_to | BASE TABLE |
| ore_yd_articles | BASE TABLE |
| ore_yd_block_ip | BASE TABLE |
| ore_yd_booking_table | BASE TABLE |
| ore_yd_carousel | BASE TABLE |
| ore_yd_carousel_images | BASE TABLE |
| ore_yd_clients | BASE TABLE |
| ore_yd_comments | BASE TABLE |
| ore_yd_comparison_list | BASE TABLE |
| ore_yd_configuration | BASE TABLE |
| ore_yd_custom_html | BASE TABLE |
| ore_yd_entries | BASE TABLE |
| ore_yd_entries_all_tags | BASE TABLE |
| ore_yd_entries_category | BASE TABLE |
| ore_yd_entries_image | BASE TABLE |
| ore_yd_formdesigner | BASE TABLE |
| ore_yd_formdesigner_obj_type | BASE TABLE |
| ore_yd_images | BASE TABLE |
| ore_yd_infopages | BASE TABLE |
| ore_yd_lang | BASE TABLE |
| ore_yd_lang_widget_opt | BASE TABLE |
| ore_yd_menu | BASE TABLE |
| ore_yd_menu_list | BASE TABLE |
| ore_yd_news_product | BASE TABLE |
| ore_yd_notifier | BASE TABLE |
| ore_yd_object_image | BASE TABLE |
| ore_yd_payments_atol | BASE TABLE |
| ore_yd_reviews | BASE TABLE |
| ore_yd_search_form | BASE TABLE |
| ore_yd_seo_friendly_url_history | BASE TABLE |
| ore_yd_service | BASE TABLE |
| ore_yd_socialauth | BASE TABLE |
| ore_yd_themes | BASE TABLE |
| ore_yd_translate_message | BASE TABLE |
| ore_yd_users | BASE TABLE |
| ore_yd_users_sessions | BASE TABLE |
| ore_yd_users_social | BASE TABLE |
+---------------------------------------+------------+
99 rows in set (0.01 sec)

Re: failed install of free version on ubuntu 20.x

PostPosted: 17 Sep 2021, 10:15
by andipas
Try to download the archive with the product again and reinstall.

Re: failed install of free version on ubuntu 20.x

PostPosted: 17 Sep 2021, 12:54
by rvknow
Thanks.

I actually did the install using the suggested method of using wget to download it to my server and install after. I have now deleted the install, downloaded the version from the web site directly and uploaded that file to the server and installed again. I received an initial MySql error but after refreshing the install started and completed as normal and seems to be working now.

Thanks for your help but also I suggest you review your guide on installing on Linux as it suggest using the wget method and points to a file to download and that file fails on the install.

Regards
Ray