SQL Error and can´t install :(

wolftech

HI i have this error and i can´t setup my site

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.0.0'' COLLATE utf8mb4_unicode_ci' at line 1 (SQL: ALTER TABLE mn_extensions CHANGE version version VARCHAR(32) DEFAULT ''1.0.0'' COLLATE utf8mb4_unicode_ci)

tksintenn

wolftech I set my db to utf8mb4_general_ci and haven't had that problem yet, what encoding did you choose for mariadb? I think I its default is utf8_general, which if tasty is using 4 bytes per character that could be the problem. Mysql utf8 isn't true utf8, it's only 3 bytes per character.

wolftech

Any help?

path99

having the same issue as well with the latest tastyigniter

igorotto

i have same problem... could someone help us? i changed config from utf8mb4_general_ci the data base, but the problem persist.

"SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.0.0'' COLLATE utf8mb4_unicode_ci' at line 1 (SQL: ALTER TABLE tk_extensions CHANGE version version VARCHAR(32) DEFAULT ''1.0.0'' COLLATE utf8mb4_unicode_ci)"

igorotto

Hey Dude, today i removed all file's the server, and reinstal with very attention. I could saw that i was missing inserting durring install a "Key generated to access the TastyIgniter API". You will get this it, do register accont in site https://tastyigniter.com after that you will get and dont more have this error

yanky4real

Unable to complete installation it showing this Sql Error ....SQLSTATE[42S22]: Column not found: 1054 Unknown column 'iso_alpha2' in 'where clause' (SQL: select * from ti_countries where iso_alpha2 = AF limit 1)..help

sampoyigi

yanky4real Issue has been fixed in the new version v3.0.4-beta.12

yanky4real

sampoyigi thanks Man... i would want to contribute in the development of the Next version