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

prasun

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

sampoyigi

prasun Update your cart extension

roydeanjr

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.

prasun

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

eshetudesalegn

prasun
can you please share how you resolved the issue?

roydeanjr

I have tried installing several times and still get the same error.
My most recent attempt was to install using the command line steps and still get this error. Here is some more information…..
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 ‘rdqti_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

sampoyigi

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

sampoyigi

roydeanjr Ah yea, they were helpful 👍️

roydeanjr

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

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?

roydeanjr

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.

roydeanjr

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.

roydeanjr

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.

mlattke

roydeanjr What kind of error are you getting with the orange theme?

roydeanjr

mlattke No error at all. The command line install option does not install any extensions nor any themes. I was able to get the site working after copying the example.htaccess to .htaccess. Then able to open the admin pages and saw that there were no extensions so I installed the ones I needed. Then went to design and there was only a demo theme, no Orange theme. I then installed the Orange theme and activated it. All works we right now.

ruchir

After replacing filename to .htaccess i am not able to install theme

roydeanjr

eshetudesalegn Which of the steps I detailed have you attempted? I just ran the command line installer and the error on the _extensions table still occurred. The fix is to comment out or delete line 252 “$table->unique([‘type’, ‘name’], ‘type’);” in 2015_03_25_000001_create_tables.php; that line creates the secondary index on the _extensions table which is causing the delete column command to fail because the type column is part of an index that exists on the table.

eko

I have same error with fresh install and unable to test. A moment ago I downloaded from github the latest quick setup file (earlier had already same problem with the one from tasty igniter website). I use Cpanel. I uploaded with filemanager the zip file, extracted it, ensured directory and file permissions as expected. The setup.php file went correctly through all phases of setup, except the last one where it informed setup has failed with the error message described here. When trying the April version in similar manner no such error occurs. Sam informs us here that he can not replicate this problem and error but I would encourage him to do a complete fresh setup with new MySQL database using the quicksetup method as that is the way to replicate this.

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

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

Thank you, I will try to figure it out although I can only do the quick setup, will look where to find the …create_tables.php file and comment out. Issue is that I stopped using the April version as too much tinkering and hope to find a more improved version. Somehow, with a so called quick installer giving install errors like this and requiring commenting lines out does not give much confidence that it will be more robust than before. The functionality and work done has been great and the look and feel is also very good, but if one needs to tinker so much with the code, that some love the people I work with can not and they should be able to run reliable system focusing on receiving orders, preparing them and ensuring that customers pay for them and receive them. So, I will wait until a stable version is released but may here and there try to help and comment, but is not yet stable enough for our situation to go live (in any case rightly called a beta version, so no complaints).

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.