search

pierobot / mangapie

This is a self-hosted server for archived manga.
BSD 3-Clause "New" or "Revised" License
64 stars 9 forks source link

Unable to scrape mangaupdates for information. #160

Closed kurim closed 4 years ago

kurim commented 4 years ago

On pressing Update on "Mangaupdates" end in this message:

image

But checking the page it the ID is correct and works fine https://www.mangaupdates.com/series.html?id=153684

pierobot commented 4 years ago

The scraper scrapes the series id fine. I think it may be something in the database causing issues. Do you have a log of the errors? Should be in storage/logs/laravel-the-date.log

kurim commented 4 years ago

Hi,

it does not show up in error log

pierobot commented 4 years ago

See if https://github.com/pierobot/mangapie/commit/af13e86014eb3ba4e2d70bfe70643da75bb9cf15 makes a difference. It should show up now.

kurim commented 4 years ago

It ends in error 500 but shows now the error.

[2020-04-30 07:19:10] local.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column '50' in 'field list' (SQL: select 50 from manga limit 1) {"userId":3,"exception":"[object] (Illuminate\Database\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column '50' in 'field list' (SQL: select 50 from manga limit 1) at /vendor/laravel/framework/src/Illuminate/Database/Connection.php:664, Doctrine\DBAL\Driver\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column '50' in 'field list' at /vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:63, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column '50' in 'field list' at /vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:61)

pierobot commented 4 years ago

https://github.com/pierobot/mangapie/commit/d17fc91368bef7a6892e08e92178a085d5141482 I believe this should fix your error.

kurim commented 4 years ago

image yes it works now :)