search

catalyst / moodle-tool_crawler

A moodle link crawling robot, find broken, slow and oversized links
https://moodle.org/plugins/tool_crawler
10 stars 18 forks source link

Database error #27

Closed kenmonroe closed 7 years ago

kenmonroe commented 7 years ago

Hi Trying to install on a 2.7 version. Basic authentication and Crawler are install and activated, but I get nothing but a database error. Never had the opportunity to complete Step 2 of the instructions. The Auto-create button, never appeared, or I missed it. Will the bot appear as a User? Guidance would be appreciated.

brendanheywood commented 7 years ago

hi @kenmonroe,

I'll need much more information like the db error or a stacktrace etc, and when you get this, ie at install time, or at config time. Have you tried to uninstall it and do it again?

fyi Moodle 2.7 is no longer supported itself:

https://docs.moodle.org/dev/Releases#Version_support

kenmonroe commented 7 years ago

Brendan, just tried to reinstall. No success. The installation appears to be successful as I'm taken directly to the configuration page. As I mentioned earlier, step 2 of the installation instruction where I'm supposed to click an Auto-create button seems to be missing, so its likely that the bot has not been created.... and therefore no report??? How does this step go missing from my installation/configuration process? What other information would you like?

brendanheywood commented 7 years ago

Have you installed and enabled moodle-auth_basic?

Send me a screen shot of your admin auth manage page

kenmonroe commented 7 years ago

Brendan, Here are some screenshots authentication_manager robot_settings robot_status

Thanks for your help.

brendanheywood commented 7 years ago

Can you please turn on debugging to developer level and redo that last screen shot with 'error reading from database'

https://docs.moodle.org/33/en/Debugging

It looks like the db might not have installed properly, you can check and see if these 3 tables exist:

mdl_tool_crawler_edge mdl_tool_crawler_history mdl_tool_crawler_url

If not I'd get you to uninstall the admin tool, then let it install again (ideally from the command line) and then dump any errors it produced.

kenmonroe commented 7 years ago

Brendan, See below debug_crawler

kenmonroe commented 7 years ago

Brendan,

I posted the screenshot in the discussion. With regards to the tables ... not sure where to look for those and how to uninstall the Admin tool itself. Uninstalling tools with the Admin tool seems straight forward but not the Admin tool itself, at least to me.

Thanks, Ken On 10/31/2017 4:12 PM, Brendan Heywood wrote:

Can you please turn on debugging to developer level and redo that last screen shot with 'error reading from database'

https://docs.moodle.org/33/en/Debugging

It looks like the db might not have installed properly, you can check and see if these 3 tables exist:

mdl_tool_crawler_edge mdl_tool_crawler_history mdl_tool_crawler_url

If not I'd get you to uninstall the admin tool, then let it install again (ideally from the command line) and then dump any errors it produced.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/central-queensland-uni/moodle-tool_crawler/issues/27#issuecomment-340934178, or mute the thread https://github.com/notifications/unsubscribe-auth/AaUxzf50vAMUcZQm4Do2POWV3iy0tJbcks5sx6lWgaJpZM4QIFdy.

-- Ken Monroe

Learning Designer

t. 250.571.2438

brendanheywood commented 7 years ago

Yeah this just looks like the plugin was never installed properly. Go to here:

/admin/tools.php

click uninstall, then yes, then go straight back to the admin top level page and it should prompt you to re-install the plugin again and create the db tables it needs.

kenmonroe commented 7 years ago

No change for me unfortunately. Any chance of Skyping on this? I'm in Canada and happy to be available at your convenience. I'd really like to see this installed. Thanks.

brendanheywood commented 7 years ago

If you want commercial support please fill out this:

https://www.catalyst.net.nz/content/contact-us-catalyst-australia

kenmonroe commented 7 years ago

Hi, In looking further through the issues on this site #21 appeared almost exactly like the issue I had. I downloaded the master.zip file that you provided him and now the link crawler is installed and working. I also updated my installation to 3.1. Not sure why the master.zip file performs better than the file downloaded from the Moodle site. Please comment. Thanks.

brendanheywood commented 7 years ago

The moodle org site is just out of date, we are constantly pushing tiny fixes to the github repo but not always publishing to the plugins database. It's a little onerous and we are pushing Moodle hq to make this easier to automate the publising step, my ideal workflow is once pull requests have passed CI and been merged then they get auto published with zero human effort. There is a lot of work on their side to enable this.