Pages: 1 [2] 3 4 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Snitch Ashor
Black Rise Guerilla Forces The Bloc
9
|
Posted - 2017.03.25 15:45:45 -
[31] - Quote
Pohwaran wrote:Hey,
I installed everything like said, had a few problems with the callback url but got that sorted. Now I'm stuck at "Error: Invalid auth state." The DB is set to evesso, I made sure of that. Any help would be appreciated. Thanks.
Edit - I fixed it turns out it was something to do with the way the database was set up. I was using MySQL with the extension, when my web host didn't use the extenion, change the database type, reinstalled the forum + the EVE SSO and it works like a charm
Glad it works now. Could you tell me what you changed to get around the database issue? |
Pohwaran
SMTOWN. The Jove Empire
0
|
Posted - 2017.03.25 19:09:17 -
[32] - Quote
Snitch Ashor wrote:Pohwaran wrote:Hey,
I installed everything like said, had a few problems with the callback url but got that sorted. Now I'm stuck at "Error: Invalid auth state." The DB is set to evesso, I made sure of that. Any help would be appreciated. Thanks.
Edit - I fixed it turns out it was something to do with the way the database was set up. I was using MySQL with the extension, when my web host didn't use the extenion, change the database type, reinstalled the forum + the EVE SSO and it works like a charm Glad it works now. Could you tell me what you changed to get around the database issue?
It goes back all the way back to the core installation of the forum itself, on the second page after setting up an admin user it asks for the database, I was installing the forum with MySQL with MySQLi Extension as the database type, using this type of database the Evesso would spit the error of invalid auth state. I then went and reinstalled the whole forum under the normal MySQL database, installed the plugin again and it worked like it should, and has been working fine since I fixed the database type.
Overall it's a great plugin, can't wait to see what else you add to it. |
Snitch Ashor
Black Rise Guerilla Forces The Bloc
9
|
Posted - 2017.03.26 20:43:00 -
[33] - Quote
Pohwaran wrote: It goes back all the way back to the core installation of the forum itself, on the second page after setting up an admin user it asks for the database, I was installing the forum with MySQL with MySQLi Extension as the database type, using this type of database the Evesso would spit the error of invalid auth state. I then went and reinstalled the whole forum under the normal MySQL database, installed the plugin again and it worked like it should, and has been working fine since I fixed the database type.
Overall it's a great plugin, can't wait to see what else you add to it.
I have to admit this should not be the case and Mysqli should be used. I will try to reproduce that error. As for features, somebody already requested to see corp and alliance next to peoples names, I think thats a nice gimmick.
|
Snitch Ashor
Black Rise Guerilla Forces The Bloc
9
|
Posted - 2017.03.30 10:07:48 -
[34] - Quote
Updated version (1.0.6a). Lots of changes and a russian translation (thanks to Jintaro Keo). Disable the mod during the update and purge cache afterwards. I also added the general update procedure to the opening post. |
Milo Caman
Anshar Incorporated Monyusaiya Industry Trade Group
154
|
Posted - 2017.03.31 10:04:19 -
[35] - Quote
When attempting to update, I'm getting the following message when trying to re-enable the extension:
General Error SQL ERROR [ mysqli ]
Duplicate column name 'user_refreshToken' [1060]
SQL
ALTER TABLE `phpbb_users` ADD COLUMN `user_refreshToken` varchar(255) NULL
BACKTRACE
FILE: (not given by php) LINE: (not given by php) CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php LINE: 999 CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/mysqli.php LINE: 193 CALL: phpbb\db\driver\driver->sql_error()
FILE: [ROOT]/phpbb/db/tools/tools.php LINE: 1061 CALL: phpbb\db\driver\mysqli->sql_query()
FILE: [ROOT]/phpbb/db/tools/tools.php LINE: 1269 CALL: phpbb\db\tools\tools->_sql_run_sql()
FILE: [ROOT]/phpbb/db/tools/tools.php LINE: 549 CALL: phpbb\db\tools\tools->sql_column_add()
FILE: (not given by php) LINE: (not given by php) CALL: phpbb\db\tools\tools->perform_schema_changes()
FILE: [ROOT]/phpbb/db/migrator.php LINE: 711 CALL: call_user_func_array()
FILE: [ROOT]/phpbb/db/migrator.php LINE: 658 CALL: phpbb\db\migrator->run_step()
FILE: [ROOT]/phpbb/db/migrator.php LINE: 400 CALL: phpbb\db\migrator->process_data_step()
FILE: [ROOT]/phpbb/db/migrator.php LINE: 288 CALL: phpbb\db\migrator->try_apply()
FILE: [ROOT]/phpbb/db/migrator.php LINE: 241 CALL: phpbb\db\migrator->update_do()
FILE: [ROOT]/phpbb/extension/base.php LINE: 78 CALL: phpbb\db\migrator->update()
FILE: [ROOT]/phpbb/extension/manager.php LINE: 185 CALL: phpbb\extension\base->enable_step()
FILE: [ROOT]/includes/acp/acp_extensions.php LINE: 197 CALL: phpbb\extension\manager->enable_step()
FILE: [ROOT]/includes/functions_module.php LINE: 676 CALL: acp_extensions->main()
FILE: [ROOT]/adm/index.php LINE: 82 CALL: p_master->load_active()
Any ideas? |
Snitch Ashor
Black Rise Guerilla Forces The Bloc
10
|
Posted - 2017.03.31 19:24:01 -
[36] - Quote
Milo Caman wrote:When attempting to update, I'm getting the following message when trying to re-enable the extension: General Error SQL ERROR [ mysqli ]
Duplicate column name 'user_refreshToken' [1060]
SQL
ALTER TABLE `phpbb_users` ADD COLUMN `user_refreshToken` varchar(255) NULL
BACKTRACE
FILE: (not given by php) LINE: (not given by php) CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php LINE: 999 CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/mysqli.php LINE: 193 CALL: phpbb\db\driver\driver->sql_error()
FILE: [ROOT]/phpbb/db/tools/tools.php LINE: 1061 CALL: phpbb\db\driver\mysqli->sql_query()
FILE: [ROOT]/phpbb/db/tools/tools.php LINE: 1269 CALL: phpbb\db\tools\tools->_sql_run_sql()
FILE: [ROOT]/phpbb/db/tools/tools.php LINE: 549 CALL: phpbb\db\tools\tools->sql_column_add()
FILE: (not given by php) LINE: (not given by php) CALL: phpbb\db\tools\tools->perform_schema_changes()
FILE: [ROOT]/phpbb/db/migrator.php LINE: 711 CALL: call_user_func_array()
FILE: [ROOT]/phpbb/db/migrator.php LINE: 658 CALL: phpbb\db\migrator->run_step()
FILE: [ROOT]/phpbb/db/migrator.php LINE: 400 CALL: phpbb\db\migrator->process_data_step()
FILE: [ROOT]/phpbb/db/migrator.php LINE: 288 CALL: phpbb\db\migrator->try_apply()
FILE: [ROOT]/phpbb/db/migrator.php LINE: 241 CALL: phpbb\db\migrator->update_do()
FILE: [ROOT]/phpbb/extension/base.php LINE: 78 CALL: phpbb\db\migrator->update()
FILE: [ROOT]/phpbb/extension/manager.php LINE: 185 CALL: phpbb\extension\base->enable_step()
FILE: [ROOT]/includes/acp/acp_extensions.php LINE: 197 CALL: phpbb\extension\manager->enable_step()
FILE: [ROOT]/includes/functions_module.php LINE: 676 CALL: acp_extensions->main()
FILE: [ROOT]/adm/index.php LINE: 82 CALL: p_master->load_active()
Any ideas? EDIT: Attempts to install the latest version on a completely fresh install of phpbb yields the following when trying to enable the extension: General Error SQL ERROR [ mysqli ]
All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead [1171]
SQL
CREATE TABLE phpbb_authevesso_membership ( characterID bigint(20) NULL, corporationID bigint(20) NULL, corporationName varchar(100) NULL, allianceID bigint(20) NULL, allianceName varchar(100) NULL, PRIMARY KEY (characterID) ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
BACKTRACE
FILE: (not given by php) LINE: (not given by php) CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php LINE: 999 CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/mysqli.php LINE: 193 CALL: phpbb\db\driver\driver->sql_error()
FILE: [ROOT]/phpbb/db/tools/tools.php LINE: 1061 CALL: phpbb\db\driver\mysqli->sql_query()
FILE: [ROOT]/phpbb/db/tools/tools.php LINE: 444 CALL: phpbb\db\tools\tools->_sql_run_sql()
FILE: [ROOT]/phpbb/db/tools/tools.php LINE: 489 CALL: phpbb\db\tools\tools->sql_create_table()
FILE: (not given by php) LINE: (not given by php) CALL: phpbb\db\tools\tools->perform_schema_changes()
FILE: [ROOT]/phpbb/db/migrator.php LINE: 711 CALL: call_user_func_array()
FILE: [ROOT]/phpbb/db/migrator.php LINE: 658 CALL: phpbb\db\migrator->run_step()
FILE: [ROOT]/phpbb/db/migrator.php LINE: 400 CALL: phpbb\db\migrator->process_data_step()
FILE: [ROOT]/phpbb/db/migrator.php LINE: 288 CALL: phpbb\db\migrator->try_apply()
FILE: [ROOT]/phpbb/db/migrator.php LINE: 241 CALL: phpbb\db\migrator->update_do()
FILE: [ROOT]/phpbb/extension/base.php LINE: 78 CALL: phpbb\db\migrator->update()
FILE: [ROOT]/phpbb/extension/manager.php LINE: 185 CALL: phpbb\extension\base->enable_step()
FILE: [ROOT]/includes/acp/acp_extensions.php LINE: 197 CALL: phpbb\extension\manager->enable_step()
FILE: [ROOT]/includes/functions_module.php LINE: 676 CALL: acp_extensions->main()
FILE: [ROOT]/adm/index.php LINE: 82 CALL: p_master->load_active()
Should be fixed in this one: https://bitbucket.org/snitchashor/php-ext-authevesso/get/42c27894557b.zip
Any chance you can tell me your mysql version?
|
Milo Caman
Anshar Incorporated Monyusaiya Industry Trade Group
154
|
Posted - 2017.03.31 19:48:12 -
[37] - Quote
It's now throwing the error about the duplicate column again.
I'm running on mysql Ver 14.14 Distrib 5.7.17, for Linux (x86_64). Hope this helps? |
Snitch Ashor
Black Rise Guerilla Forces The Bloc
10
|
Posted - 2017.03.31 20:02:29 -
[38] - Quote
Milo Caman wrote:It's now throwing the error about the duplicate column again.
I'm running on mysql Ver 14.14 Distrib 5.7.17, for Linux (x86_64). Hope this helps?
Can you delete the columns? I think i got the migrations right now, but with previous versions this might be an issue. Also clearing the extensions data should remove the columns |
Milo Caman
Anshar Incorporated Monyusaiya Industry Trade Group
154
|
Posted - 2017.03.31 20:08:12 -
[39] - Quote
Attempting to delete the data (which resulted in a timeout) got me back to the 'duplicate column name' error. Going to try restoring a backup and going from there. |
Snitch Ashor
Black Rise Guerilla Forces The Bloc
10
|
Posted - 2017.03.31 20:14:03 -
[40] - Quote
https://bitbucket.org/snitchashor/php-ext-authevesso/get/44c15b1fc830.zip should fix it...
This fix should only be required for mysql >= 5.6 for all others v1.0.6a should be fine |
|
Milo Caman
Anshar Incorporated Monyusaiya Industry Trade Group
154
|
Posted - 2017.03.31 20:31:20 -
[41] - Quote
The extension now enables fine, but when attempting to log in, I now get
{"error":"invalid_request","error_description":"The callback URI doesn't match the value stored for this client"}
Resetting the auth method to db via mysql doesn't appear to circumvent this, so I'm a bit stuck. |
Snitch Ashor
Black Rise Guerilla Forces The Bloc
10
|
Posted - 2017.03.31 20:40:38 -
[42] - Quote
This is due to a fix I added for people without mod rewrite. The mod nowbtells in the authentication settings what the callback should be. In your case, since you obviously have mod rewrite, go to acp -> general -> server config -> server and domain and enable url rewriting, clear the cache and it should be working. |
Milo Caman
Anshar Incorporated Monyusaiya Industry Trade Group
154
|
Posted - 2017.03.31 20:43:09 -
[43] - Quote
Snitch Ashor wrote:This is due to a fix I added for people without mod rewrite. The mod nowbtells in the authentication settings what the callback should be. In your case, since you obviously have mod rewrite, go to acp -> general -> server config -> server and domain and enable url rewriting, clear the cache and it should be working.
Is there any way to do this via mysql (specifically mod_rewrite), as I'm currently locked out of my own forum |
Syenna Celeste
Anshar Incorporated Monyusaiya Industry Trade Group
52
|
Posted - 2017.03.31 23:05:27 -
[44] - Quote
Milo Caman wrote:[ EDIT 3: Changing the URL by removing '%2Fapp.php' manually allows me to login with SSO enabled. This suggests that mod_rewrite might not be working properly? Also the 'Extensions' tab seems to be missing once I get back into ACP with everything enabled.
Fixed (we think).
Line 115 login.php.
Old: $url = $authurl."?response_type=code&redirect_uri=".rawurlencode(append_sid(generate_board_url().'/app.php/authevesso/login'))."&client_id=".$this->settings['clientid']."&scope=".im plode(' ',$scopes)."&state=".$state;
New: $url = $authurl."?response_type=code&redirect_uri=".rawurlencode(append_sid(generate_board_url().'/authevesso/login'))."&client_id=".$this->settings['clientid']."&scope=".im plode(' ',$scopes)."&state=".$state;
Put your hands around my heart and squeeze me until I'm dry.
|
Snitch Ashor
Black Rise Guerilla Forces The Bloc
10
|
Posted - 2017.04.01 05:47:18 -
[45] - Quote
Syenna Celeste wrote:Milo Caman wrote:[ EDIT 3: Changing the URL by removing '%2Fapp.php' manually allows me to login with SSO enabled. This suggests that mod_rewrite might not be working properly? Also the 'Extensions' tab seems to be missing once I get back into ACP with everything enabled. Fixed (we think). Line 115 login.php. Old: $url = $authurl."?response_type=code&redirect_uri=".rawurlencode(append_sid(generate_board_url().' /app.php/authevesso/login'))."&client_id=".$this->settings['clientid']."&scope=".im plode(' ',$scopes)."&state=".$state; New: $url = $authurl."?response_type=code&redirect_uri=".rawurlencode(append_sid(generate_board_url().'/authevesso/login'))."&client_id=".$this->settings['clientid']."&scope=".im plode(' ',$scopes)."&state=".$state;
Thanks, did overlook that. So you can use that change for now, or change the callback at the eve dev page. |
Milo Caman
Anshar Incorporated Monyusaiya Industry Trade Group
154
|
Posted - 2017.04.01 09:23:59 -
[46] - Quote
Installed 1.0.7a just fine and logins seem to be working perfectly again, thanks
Still not seeing the extensions tab though. Were some functions moved elsewhere? |
Snitch Ashor
Black Rise Guerilla Forces The Bloc
11
|
Posted - 2017.04.03 21:54:11 -
[47] - Quote
Milo Caman wrote:Installed 1.0.7a just fine and logins seem to be working perfectly again, thanks Still not seeing the extensions tab though. Were some functions moved elsewhere?
I'm afraid no. This means the migrations again didnt install properly for you. Will have a look but unfortunately its something I cannot reproduce. |
Milo Caman
Anshar Incorporated Monyusaiya Industry Trade Group
157
|
Posted - 2017.04.04 12:58:41 -
[48] - Quote
Snitch Ashor wrote:Milo Caman wrote:Installed 1.0.7a just fine and logins seem to be working perfectly again, thanks Still not seeing the extensions tab though. Were some functions moved elsewhere? I'm afraid no. This means the migrations again didnt install properly for you. Will have a look but unfortunately its something I cannot reproduce.
Hrm.
Would running the query from before fix this? Is it even possible to do the migrations manually via the cli or mysql? |
Snitch Ashor
Black Rise Guerilla Forces The Bloc
11
|
Posted - 2017.04.04 19:34:10 -
[49] - Quote
Milo Caman wrote:Snitch Ashor wrote:Milo Caman wrote:Installed 1.0.7a just fine and logins seem to be working perfectly again, thanks Still not seeing the extensions tab though. Were some functions moved elsewhere? I'm afraid no. This means the migrations again didnt install properly for you. Will have a look but unfortunately its something I cannot reproduce. Hrm. Would running the query from before fix this? Is it even possible to do the migrations manually via the cli or mysql?
Sorry no. There are three migrations, one does database stuff, one installs the acp module and one inserts the teamspeak profile field. Can you check if the last one is there? |
Milo Caman
Anshar Incorporated Monyusaiya Industry Trade Group
158
|
Posted - 2017.04.05 12:42:49 -
[50] - Quote
Installed migrations listed as per CLI output are:
* \snitch\authevesso\migrations\add_table_100 * \snitch\authevesso\migrations\version_104 * \snitch\authevesso\migrations\version_101 * \snitch\authevesso\migrations\profilefield_tsid_100 * \snitch\authevesso\migrations\add_module_100
The output from the query is as follows:
Database changed mysql> SELECT * FROM `phpbb_migrations` WHERE `migration_name` LIKE '%snitch%'; +-----------------------------------------------------+----------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------+-- ---------------------+---------------------+----------------------+----------------------+--------------------+ | migration_name | migration_depends_on | m igration_schema_done | migration_data_done | migration_data_state | migration_start_time | migration_end_time | +-----------------------------------------------------+----------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------+-- ---------------------+---------------------+----------------------+----------------------+--------------------+ | \snitch\authevesso\migrations\add_module_100 | a:1:{i:0;s:34:"\phpbb\db\migration\data\v31x\v314";} | 1 | 1 | | 1490953922 | 1490953923 | | \snitch\authevesso\migrations\add_table | a:1:{i:0;s:34:"\phpbb\db\migration\data\v31x\v314";} | 1 | 1 | | 0 | 0 | | \snitch\authevesso\migrations\add_table_100 | a:1:{i:0;s:44:"\snitch\authevesso\migrations\add_module_100";} | 1 | 1 | | 1490953923 | 1490966569 | | \snitch\authevesso\migrations\profilefield_tsid | a:1:{i:0;s:48:"\phpbb\db\migration\data\v310\profilefield_types" ;} | 1 | 1 | | 1489791031 | 1489791031 | | \snitch\authevesso\migrations\profilefield_tsid_100 | a:1:{i:0;s:48:"\phpbb\db\migration\data\v310\profilefield_types" ;} | 1 | 1 | | 0 | 0 | | \snitch\authevesso\migrations\version_101 | a:3:{i:0;s:44:"\snitch\authevesso\migrations\add_module_100";i:1 ;s:43:"\snitch\authevesso\migrations\add_table_100";i:2;s:51:"\snitch\authevesso\migrations\profilefield_tsid_100";} | 1 | 1 | &n...
|
|
Snitch Ashor
Black Rise Guerilla Forces The Bloc
11
|
Posted - 2017.04.05 22:06:43 -
[51] - Quote
Milo Caman wrote:Installed migrations listed as per CLI output are: * \snitch\authevesso\migrations\add_table_100 * \snitch\authevesso\migrations\version_104 * \snitch\authevesso\migrations\version_101 * \snitch\authevesso\migrations\profilefield_tsid_100 * \snitch\authevesso\migrations\add_module_100
The output from the query is as follows: Database changed mysql> SELECT * FROM `phpbb_migrations` WHERE `migration_name` LIKE '%snitch%'; +-----------------------------------------------------+----------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------+-- ---------------------+---------------------+----------------------+----------------------+--------------------+ | migration_name | migration_depends_on | m igration_schema_done | migration_data_done | migration_data_state | migration_start_time | migration_end_time | +-----------------------------------------------------+----------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------+-- ---------------------+---------------------+----------------------+----------------------+--------------------+ | \snitch\authevesso\migrations\add_module_100 | a:1:{i:0;s:34:"\phpbb\db\migration\data\v31x\v314";} | 1 | 1 | | 1490953922 | 1490953923 | | \snitch\authevesso\migrations\add_table | a:1:{i:0;s:34:"\phpbb\db\migration\data\v31x\v314";} | 1 | 1 | | 0 | 0 | | \snitch\authevesso\migrations\add_table_100 | a:1:{i:0;s:44:"\snitch\authevesso\migrations\add_module_100";} | 1 | 1 | | 1490953923 | 1490966569 | | \snitch\authevesso\migrations\profilefield_tsid | a:1:{i:0;s:48:"\phpbb\db\migration\data\v310\profilefield_types" ;} | 1 | 1 | | 1489791031 | 1489791031 | | \snitch\authevesso\migrations\profilefield_tsid_100 | a:1:{i:0;s:48:"\phpbb\db\migration\data\v310\profilefield_types" ;} | 1 | 1 | | 0 | 0 | | \snitch\authevesso\migrations\version_101 | a:3:{i:0;s:44:"\snitch\authevesso\migrations\add_module_100";i:1 ;s:43:"\snitch\authevesso\migrations\add_table_100";i:2;s:51:"\snitch\authevesso\migrations\profilefield_tsid_100";} | 1 | ...
|
Milo Caman
Anshar Incorporated Monyusaiya Industry Trade Group
158
|
Posted - 2017.04.05 23:04:32 -
[52] - Quote
Doesn't look like it's a permissions issue, a regular admin doesn't see the extensions tab either.
How would I go about removing the add_module_100 migrations row? With the mod disabled db:list no longer shows the migrations as installed or available. Would it be worth deleting the extension's data again or might this just cause further problems? |
Snitch Ashor
Black Rise Guerilla Forces The Bloc
11
|
Posted - 2017.04.05 23:14:13 -
[53] - Quote
Milo Caman wrote:Doesn't look like it's a permissions issue, a regular admin doesn't see the extensions tab either.
How would I go about removing the add_module_100 migrations row? With the mod disabled db:list no longer shows the migrations as installed or available. Would it be worth deleting the extension's data again or might this just cause further problems?
That might work as well but i would just delete the table row first, e.g. using phpmyadmin if you have, if not, its
DELETE FROM `phpbb_migrations` WHERE `phpbb_migrations`.`migration_name` = \'\\\\snitch\\\\authevesso\\\\migrations\\\\add_module_100\' |
Milo Caman
Anshar Incorporated Monyusaiya Industry Trade Group
158
|
Posted - 2017.04.05 23:21:26 -
[54] - Quote
mysql does not like this query at all and makes a big fuss about the backslash characters, should it just be something like:
DELETE FROM `phpbb_migrations` WHERE `phpbb_migrations`.`migration_name` = '\snitch\authevesso\migrations\add_module_100';
instead?
EDIT: The exact output is:
mysql> DELETE FROM `phpbb_migrations` WHERE `phpbb_migrations`.`migration_name` = \'\\\\snitch\\\\authevesso\\\\migrations\\\\add_module_100\' ERROR: Unknown command '\''. ERROR: Unknown command '\\'. ERROR: Unknown command '\\'. ERROR: Unknown command '\\'. ERROR: Unknown command '\\'. ERROR: Unknown command '\\'. ERROR: Unknown command '\\'. ERROR: Unknown command '\\'. ERROR: Unknown command '\\'. ERROR: Unknown command '\''. -> ; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'\\\\snitch\\\\authevesso\\\\migrations\\\\add_module_100\'' at line 1 |
Snitch Ashor
Black Rise Guerilla Forces The Bloc
11
|
Posted - 2017.04.05 23:47:01 -
[55] - Quote
Milo Caman wrote:mysql does not like this query at all and makes a big fuss about the backslash characters, should it just be something like: DELETE FROM `phpbb_migrations` WHERE `phpbb_migrations`.`migration_name` = '\snitch\authevesso\migrations\add_module_100'; instead? EDIT: The exact output is: mysql> DELETE FROM `phpbb_migrations` WHERE `phpbb_migrations`.`migration_name` = \'\\\\snitch\\\\authevesso\\\\migrations\\\\add_module_100\' ERROR: Unknown command '\''. ERROR: Unknown command '\\'. ERROR: Unknown command '\\'. ERROR: Unknown command '\\'. ERROR: Unknown command '\\'. ERROR: Unknown command '\\'. ERROR: Unknown command '\\'. ERROR: Unknown command '\\'. ERROR: Unknown command '\\'. ERROR: Unknown command '\''. -> ; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'\\\\snitch\\\\authevesso\\\\migrations\\\\add_module_100\'' at line 1
DELETE FROM phpbb_migrations WHERE migration_name = '\snitch\authevesso\migrations\add_module_100'; should do.
|
Milo Caman
Anshar Incorporated Monyusaiya Industry Trade Group
158
|
Posted - 2017.04.06 08:35:17 -
[56] - Quote
Snitch Ashor wrote: Edit: If you havent done this yet can you check in the acp-system-module management-acp, in the very bottom there should be a dropdown and one of the entries should be something like snitch/authevesso/main module.
Enabling the snitch/authevesso/main settings module fixed everything! Seems like new users can create accounts now, and I have full access to the settings module.
Thanks so much for all your help with this! |
Milo Caman
Anshar Incorporated Monyusaiya Industry Trade Group
158
|
Posted - 2017.04.07 14:21:38 -
[57] - Quote
New day, new problem!
Looks like the groups_check.php cronjob isn't being run by the system. I don't seem to be able to run it manually either as it returns the below:
Class 'phpbb\cron\task\base' not found in /var/www/html/forum/ext/snitch/authevesso/cron/groups_check.php on line 20
I'm going to go out on a limb and assume that this is migration-related, but I'm not really sure how phpbb handles it's internal crons. I had a poke around, but I'm feeling a bit lost in it all. Any ideas? |
Snitch Ashor
Black Rise Guerilla Forces The Bloc
17
|
Posted - 2017.04.08 19:45:24 -
[58] - Quote
Milo Caman wrote:New day, new problem! Looks like the groups_check.php cronjob isn't being run by the system. I don't seem to be able to run it manually either as it returns the below: Class 'phpbb\cron\task\base' not found in /var/www/html/forum/ext/snitch/authevesso/cron/groups_check.php on line 20 I'm going to go out on a limb and assume that this is migration-related, but I'm not really sure how phpbb handles it's internal crons. I had a poke around, but I'm feeling a bit lost in it all. Any ideas?
No for once this has nothing to do with the migrations. Looks like its unable to find the cron base class which is part of phpbb. How did you try to run the cron job manually? It requires the phpbb enviroment so if you want to run it manually, try php path_to_forum/bin/phpbbcli.php cron:run task.groups_check and let me know if that works. |
Milo Caman
Anshar Incorporated Monyusaiya Industry Trade Group
158
|
Posted - 2017.04.09 10:03:51 -
[59] - Quote
When I tried to run it manually, I just navigated to /ext/snitch/authevesso/cron and ran the script with php.
Trying to run the task from cli gives me the following:
php bin/phpbbcli.php cron:run cron.task.groups_check
[RuntimeException] Could not find cron task GÇ£cron.task.groups_checkGÇ¥.
|
Snitch Ashor
Black Rise Guerilla Forces The Bloc
17
|
Posted - 2017.04.09 13:27:53 -
[60] - Quote
Milo Caman wrote:When I tried to run it manually, I just navigated to /ext/snitch/authevesso/cron and ran the script with php. Trying to run the task from cli gives me the following: php bin/phpbbcli.php cron:run cron.task.groups_check
[RuntimeException] Could not find cron task GÇ£cron.task.groups_checkGÇ¥.
Can you please post the output of php bin/phpbbcli.php cron:list
If groups_check shows up as ready to be run please run
php bin/phpbbcli.php cron:run
Which runs all crons and then list again to check if groups moved to the not ready Section. |
|
|
|
|
Pages: 1 [2] 3 4 :: one page |
First page | Previous page | Next page | Last page |