I am getting this error during installation. Please, help. Migrating: 2020_04_16_000300_drop_stale_unused_columns In Connection.php line 669: SQLSTATE[42000]: Syntax error or access violation: 1072 Key column ‘type’ doesn’t exist in table (SQL: alter table ti_extensions drop type , drop data , drop serialized , drop status , drop title ) In PDOStatement.php line 107: SQLSTATE[42000]: Syntax error or access violation: 1072 Key column ‘type’ doesn’t exist in table In PDOStatement.php line 105: SQLSTATE[42000]: Syntax error or access violation: 1072 Key column ‘type’ doesn’t exist in table

prasun Update your cart extension

This error is on a new installation. There is nothing installed to update. Isn’t this an issue with the install script? And, if not, how do we update our cart extension when the site is not even completely installed. BTW, the admin pages do not load because the setup has not completed enough to create the necessary code or references.

roydeanjr ya, you are right. This error occurred during the installation.

I ran chmod 777 -R on my installation directory and tried php artisan igniter:install again and got a different error: In Connection.php line 669: SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘rdqti_mail_layouts’ already exists (SQL: rename table ‘rdqti_mailtemplates’ to ‘rdqti_mail_layouts’) In PDOStatement.php line 107: SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘rdqti_mail_layouts’ already exists In PDOStatement.php line 105: SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘rdqti_mail_layouts’ already exists

roydeanjr thank you for the extra info but still unable to reproduce the error on my end.

Ok, so the type column does exist in the extensions table. It is a part of an index though and as such it does not allow direct dropping of that column without first dropping the index. The SQL command is ALTER TABLE rdqti_extensions DROP INDEX type ; Where is the create table code for the extensions table? Maybe I can alter that so the index does not get created until after the table migrations take place?

Ok, I modified the 2015_03_25_000001_create_tables.php script and commented out this line: /* $table->unique([‘type’, ‘name’], ‘type’); in the _create_extensions() function. That allowed the installation to continue to a successful end. However, for whatever reason, the admin pages do not display. All I get is an Object not found error for the admin pages. The site displays the new Getting Started page just fine, but no admin pages.

Ok, latest is that I moved the backup.htaccess file to .htaccess. Then restarted xampp on my linux box. Now the site works without issue.

And, on a final note (I think), I was able to log into the admin pages and download and install all the extensions that I plan to use. I also downloaded the Orange theme, activated and the site does work as I had hoped.

1072 Key column 'type' doesn't exist in tableSQL: alter table `ti_extensions`

eko

I did check the install. So it will display a frontpage and even the admin login page (with .htaccess edited). However, it does not allow any login as it did not populate the user database (compared to the April Install). Although it created all tables it did not copy any data into them, hence not working.

eko

roydeanjr I managed to install using command line and as you still got the error message. You advised to comment out the tables_php line 252 but can you please tell me where to find this ..tables.php file. Many thanks

eko

Found it

eko

is in app/admin/database/migrations

eko

However, there is no file 2015_03_25_000001_create_tables.php in that folder

eko

ONLY HAS:
2017_08_25_000300_create_location_areas_table.php
2017_08_25_000300_create_menu_categories_table.php
2018_01_19_000300_add_hash_columns_on_orders_reservations_table.php
2018_04_06_000300_drop_unique_on_order_totals_table.php
2018_04_12_000300_modify_columns_on_orders_reservations_table.php
2018_05_21_000300_drop_redundant_columns_on_kitchen_tables.php
2018_05_29_000300_add_columns_on_location_areas_table.php
2018_06_12_000300_create_locationables_table.php
2018_07_04_000300_create_user_preferences_table.php
2018_10_09_000300_auto_increment_on_order_totals_table.php
2019_04_09_000300_auto_increment_on_user_preferences_table.php
2019_07_02_000300_add_columns_on_menu_specials_table.php
2019_07_16_000300_create_reservation_tables_table.php
2019_07_21_000300_change_sort_value_ratings_to_config_on_settings_table.php
2019_11_08_000300_add_selected_columns_to_menu_options_table.php
2020_02_18_000400_create_staffs_groups_and_locations_table.php
2020_02_21_000400_create_staff_roles_table.php
2020_02_22_000300_remove_add_columns_on_staff_staff_groups_table.php
2020_02_25_000300_create_assignable_logs_table.php
2020_03_18_000300_add_quantity_column_to_order_menu_options_table.php
2020_04_05_000300_create_payment_profiles_table.php
2020_04_16_000300_drop_stale_unused_columns.php
2020_05_31_000300_drop_more_unused_columns.php
2020_06_11_000300_create_menu_mealtimes_table.php

eko

Ah file is in /app/system/database/migrations/2015_03_25_000001_create_tables.php

eko

commented it out. Changed the .htacces to ensure it points to the folder, only for admin to not start in that folder…

roydeanjr

eko And that worked for you?

eshetudesalegn

roydeanjr i tried the new bug fixes and appears to have similar error when using the setup wizard.
i tried commenting that line and turns out it re downloads the file and replace the commented line with the same code.
the solution should be to remove the line from the source code on github.. by the owner.

is there a way that you were able to comment/remove that line and somehow worked?
because whenever you use the setup wizard it still go through downloading the content again.

eko

I realize that the biggest change that probably is causing all this problems with the “extensions” because that it what you comment out, and also gives the installation issues is that compared to the April release, extensions can only be installed when having generated carte number for the website. I understand that there may be god reasons to start “locking” extensions to websites, but there is some privacy creep here as one now requires to expose the installation to the software developer who also thus link website with user. It would be useful to get some more insight from core developer why this change happened but more importantly to fix the installation process. I tried to update 2 old sites but because of carte messed completely up. So even though we can try to get a fresh install working, I have failed to get success with accessing the admin part. The front-end shows but that’s it.

sampoyigi

eko The carte is yet to be enforced and you can install/update extensions without a carte.

eko

Noticed, thank you, actually the carte number was not accepted 😆

sampoyigi

roydeanjr Ah yea, they were helpful 👍️

« Previous Page