SQLSTATE[21S01]: Insert value list does not match column list

xamax

Hello,
Fresh installation on my webserver, php7.2. No sample data, multirestaurant and theme+extentsions.
At last stage of finishing setup I get this error
SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 2 (SQL: insert intoti_pages(content,date_added,date_updated,language_id,meta_description,meta_keywords,permalink_slug,status,title) values (Lorem ipsum dolor sit amet, consectetur adipiscing elit., 2020-04-09 12:45:23, 2020-04-09 12:45:23, 1, , , about-us, 1, About Us), (Lorem ipsum dolor sit amet, consectetur adipiscing elit., 2020-04-09 12:45:23, 2020-04-09 12:45:23, 1, , , {"navigation_hidden":"1"}, policy, 1, Policy), (Lorem ipsum dolor sit amet, consectetur adipiscing elit., 2020-04-09 12:45:23, 2020-04-09 12:45:23, 1, , , terms-and-conditions, 1, Terms and Conditions))

I tried a fresh install as I was getting many errors in the admin dashboard such as exception:

Igniter \ Flame \ Exception \ SystemException The partial 'form/field_currency.php' is not found

Symfony \ Component \ Debug \ Exception \ FatalErrorException (E_UNKNOWN) Trait 'Main\Traits\UsesPage' not found

when trying to edit any payment solution or the theme.

I tried to upload a theme from GIT. Theme uploads, install but it's empty.
Any help welcomed, thank you

sampoyigi

xamax Tagged v1.3.3 on Pages Extension to fix the issue, let me know if you run into any issues.

wwjr

I am receiveing the same error when attempting to install the static-pages extension. I cant get the basic front end working.

SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 2 (SQL: insert intoti_pages(content,date_added,date_updated,language_id,meta_description,meta_keywords,permalink_slug,status,title) values (Lorem ipsum dolor sit amet, consectetur adipiscing elit., 2020-04-09 20:46:14, 2020-04-09 20:46:14, 1, , , about-us, 1, About Us), (Lorem ipsum dolor sit amet, consectetur adipiscing elit., 2020-04-09 20:46:14, 2020-04-09 20:46:14, 1, , , {"navigation_hidden":"1"}, policy, 1, Policy), (Lorem ipsum dolor sit amet, consectetur adipiscing elit., 2020-04-09 20:46:14, 2020-04-09 20:46:14, 1, , , terms-and-conditions, 1, Terms and Conditions))" on line 664 of /srv/www/.../vendor/laravel/framework/src/Illuminate/Database/Connection.php

Varulv1997-deleted

It's a new issue with the latest beta version 20, I suggest you to use an earlier version 18 works pretty fine for development/testing.

xamax

Varulv1997-deleted Thanks! Is it still possible to install v2 for production? Or do you know when v3 will be stable? thank you

Varulv1997-deleted

xamax Here you go: https://github.com/tastyigniter/TastyIgniter/releases/tag/2.0.0
You will have to configurate it yourself though as the installer only supports the latest version (beta 20 currently), I suppose.

demolinton4comin

The problem is actually from the static page Extension.
To resolve this simple go to this file
\extensions\igniter\pages\database\migrations\2018_06_28_000300_create_pages_table.php
then replace line 50-91 with below

[
                'language_id' => $language->language_id,
                'name' => 'About Us',
                'title' => 'About Us',
                'heading' => 'About Us',
                'permalink_slug' => 'about-us',
                'content' => 'Lorem ipsum dolor sit amet, consectetur adipiscing elit.',
                'meta_description' => '',
                'meta_keywords' => '',
                'navigation' => 'a:2:{i:0;s:8:\'side_bar\';i:1;s:6:\'footer\';}',
                'date_added' => '2014-04-19 16:57:21',
                'date_updated' => '2015-05-07 12:39:52',
                'status' => 1,
            ],
            [
                'language_id' => $language->language_id,
                'name' => 'Policy',
                'title' => 'Policy',
                'heading' => 'Policy',
                'permalink_slug' => 'policy',
                'content' => 'Lorem ipsum dolor sit amet, consectetur adipiscing elit.',
                'meta_description' => '',
                'meta_keywords' => '',
                'navigation' => 'a:2:{i:0;s:8:\'side_bar\';i:1;s:6:\'footer\';}',
                'date_added' => '2014-04-19 17:21:23',
                'date_updated' => '2015-05-16 09:18:39',
                'status' => 1,
            ],
            [
                'language_id' => $language->language_id,
                'name' => 'Terms and Conditions',
                'title' => 'Terms and Conditions',
                'heading' => 'Terms and Conditions',
                'permalink_slug' => 'terms-and-conditions',
                'content' => 'Lorem ipsum dolor sit amet, consectetur adipiscing elit.',
                'meta_description' => '',
                'meta_keywords' => '',
                'navigation' => 'a:2:{i:0;s:8:\'side_bar\';i:1;s:6:\'footer\';}',
                'date_added' => '2014-04-19 17:21:23',
                'date_updated' => '2015-05-16 09:18:39',
                'status' => 1,
            ],

Note that this works for me

xamax

demolinton4comin Yes it works. Thank you!

matheus

sampoyigi I have the same problem, could you help me my friend? thanks !!

xamax

matheus What I have done it to download the setup again (for latest version) then run the setup. Got the error so went to edit \extensions\igniter\pages\database\migrations\2018_06_28_000300_create_pages_table.php as per the reply above and then you can visit the admin area http://your-domain/admin.
If you run the app in a subdirectory you need to uncomment line 18 in the .htaccess or you'll get a 404 error (file not found).
So far no errors on my side just some quirks which I'll try to solve or ask in a discussion.
Hope this helps

sampoyigi

matheus Error has been fixed in v1.3.3

matheus

sampoyigi @xamax
How do I download the latest version? thanks for the help friend

Varulv1997-deleted

matheus https://github.com/tastyigniter/TastyIgniter/releases

matheus

Varulv1997-deleted Thank you friend! but this does not come with the Setup, to install what should I do? thanks for listening

Varulv1997-deleted

matheus I think the setup wizard on tastyigniter.com downloads the latest version, in anyway if you still want to do it manually, change the config files in /config, basically app.php and database.php, link your database in database.php create an user table login to your admin panel and you can change the options that the setup wizard sets in the installation.

matheus

Varulv1997-deleted Thanks