Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL Import Structure Issue #1363

Closed
FullDad opened this issue Sep 26, 2022 · 3 comments
Closed

SQL Import Structure Issue #1363

FullDad opened this issue Sep 26, 2022 · 3 comments
Labels

Comments

@FullDad
Copy link

FullDad commented Sep 26, 2022

I can't figure this out. I am a bit of a noob but i think this is the last piece to my puzzle.

I am importing per the instructions on the core documentation utf8mb4_unicode_520_ci and 17 tables import.

This is the query i am getting the error on. I feel like if i fix this....i'll have my first telebot working!

any help would be apprciated. I have tried to import this query with different tags and stuff but have had no luck. Would love some help!

MySQL said: Documentation

#1267 - Illegal mix of collations (utf8mb4_general_ci,COERCIBLE) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation '<>'

The Query:

( SELECT User, Host, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Grant_priv, Index_priv, Alter_priv, References_priv, Create_tmp_table_priv, Lock_tables_priv, Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv, Execute_priv, Event_priv, Trigger_priv, '*' AS Db, 'g' AS Type FROM mysql.user WHERE NOT (Select_priv = 'N' AND Insert_priv = 'N' AND Update_priv = 'N' AND Delete_priv = 'N' AND Create_priv = 'N' AND Drop_priv = 'N' AND Grant_priv = 'N' AND References_priv = 'N' AND Create_tmp_table_priv = 'N' AND Lock_tables_priv = 'N' AND Create_view_priv = 'N' AND Show_view_priv = 'N' AND Create_routine_priv = 'N' AND Alter_routine_priv = 'N' AND Execute_priv = 'N' AND Event_priv = 'N' AND Trigger_priv = 'N')) UNION ( SELECT User, Host, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Grant_priv, Index_priv, Alter_priv, References_priv, Create_tmp_table_priv, Lock_tables_priv, Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv, Execute_priv, Event_priv, Trigger_priv, Db, 'd' AS Type FROM mysql.db WHERE 'telebot4db' LIKE Db AND NOT (Select_priv = 'N' AND Insert_priv = 'N' AND Update_priv = 'N' AND Delete_priv = 'N' AND Create_priv = 'N' AND Drop_priv = 'N' AND Grant_priv = 'N' AND References_priv = 'N' AND Create_tmp_table_priv = 'N' AND Lock_tables_priv = 'N' AND Create_view_priv = 'N' AND Show_view_priv = 'N' AND Create_routine_priv = 'N' AND Alter_routine_priv = 'N' AND Execute_priv = 'N' AND Event_priv = 'N' AND Trigger_priv = 'N')) ORDER BY User ASC, Host ASC, Db ASC;

@FullDad
Copy link
Author

FullDad commented Sep 26, 2022

The error from trying to run getUpdatesCLI.php is below.

PHP Fatal error: Uncaught TypeError: Argument 2 passed to Longman\TelegramBot\DB::insertTelegramUpdate() must be of the type int or null, float given, called in /var/www/html/vendor/longman/telegram-bot/src/DB.php on line 620 and defined in /var/www/html/vendor/longman/telegram-bot/src/DB.php:338
Stack trace:
#0 /var/www/html/vendor/longman/telegram-bot/src/DB.php(620): Longman\TelegramBot\DB::insertTelegramUpdate()
#1 /var/www/html/vendor/longman/telegram-bot/src/Telegram.php(644): Longman\TelegramBot\DB::insertRequest()
#2 /var/www/html/vendor/longman/telegram-bot/src/Telegram.php(516): Longman\TelegramBot\Telegram->processUpdate()
#3 /var/www/html/getUpdatesCLI.php(27): Longman\TelegramBot\Telegram->handleGetUpdates()
#4 {main}

@FullDad
Copy link
Author

FullDad commented Sep 29, 2022

this is resolved. can't be on 32 bit raspberry OS.

@FullDad
Copy link
Author

FullDad commented Sep 29, 2022

i was on 32 bit os

@FullDad FullDad closed this as not planned Won't fix, can't repro, duplicate, stale Sep 29, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant