Closed ralfq closed 4 years ago
welcome[bot]
commented
4 years ago 👋 Thanks for opening your first issue here! If you're reporting a 🐞 bug, please make sure you include steps to reproduce it. We get a lot of issues on this repo, so please be patient and we will get back to you as soon as we can.
netking80
commented
4 years ago IMHO the problem is only at showing the logo. I can see that the tag has wrong relative src, that includes the hostname
netking80
commented
4 years ago IMHO the problem is only at showing the logo. I can see that the tag has wrong relative src, that includes the hostname
I found, on my .env, a typo: APP_URL has to be specified with leading protocol (e.g. APP_URL='http://assets.example.com'), it resolved my problem
WELLBOREIS
commented
4 years ago @netking80 That worked for me!
ralfq
commented
4 years ago I can not confirm that it works. Uploading images in other sections works well (e. g. upload image for a user). But uploading an image in the manufacturer section still does not work.
It is reproducable even on the demo site (https://demo.snipeitapp.com/). I deleted the manufacturer image for Microsoft and tried to upload the same image again. It´s not possible to upload an image. (see https://demo.snipeitapp.com/manufacturers ) Have I missed something?
jovibroz
commented
4 years ago I can also confirm that uploading pictures for manufacturers doesn't work, not on the demo nor on my own installation. One difference with my own server though is the second time I try to upload the same picture for the same manufacturer I get "500 | Server error" :)
jovibroz
commented
4 years ago Running in debug mode this is the headlines when trying to upload an image for a manufacturer.
SQLSTATE[HY000]: General error: 1525 Incorrect TIMESTAMP value: '76' (SQL: select count(*) as aggregate from manufacturers where name = harman/kardon and deleted_at <> 76)
/var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Database/Connection.php#669
Illuminate\Database\QueryException
// message to include the bindings with SQL, which will make this exception a
// lot more helpful to the developer instead of just the database's errors.
catch (Exception $e) {
throw new QueryException(
$query, $this->prepareBindings($bindings), $e
);
}
SQLSTATE[HY000]: General error: 1525 Incorrect TIMESTAMP value: '76' /var/www/html/snipeit/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#129 Doctrine\DBAL\Driver\PDOException SQLSTATE[HY000]: General error: 1525 Incorrect TIMESTAMP value: '76' /var/www/html/snipeit/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#127
snipe
commented
4 years ago SQLSTATE[HY000]: General error: 1525 Incorrect TIMESTAMP value: '76' (SQL: select count(*) as aggregate from manufacturers where name = harman/kardon and deleted_at <> 76)
Uhhh.... well that's new lol
This one might take me a moment.
@uberbrady - can you take a look? I have my hands full with a different issue right now.
snipe
commented
4 years ago (It seems it might be confusing mfg ID and timestamp? wtf?)
uberbrady
commented
4 years ago I can replicate this on my local install, debugging.
snipe
commented
4 years ago I just pushed out a fix to develop - can you let me know if this resolves your issue?
jovibroz
commented
4 years ago Awesome work! New manufacturer and upload image works!
One note though, In my case with the manufacturer name "harman/kardon" (even tried to create a new manufacturer "harmankardon/" and that slash doesn't play well with the db at all, it gives me "500 | server error" and...this again!
"harmankardon" worked just fine though :)
SQLSTATE[HY000]: General error: 1525 Incorrect TIMESTAMP value: '79' (SQL: select count(*) as aggregate from manufacturers where name = harmankardon/ and deleted_at <> 79)
/var/www/html/snipeit/vendor/laravel/framework/src/Illuminate/Database/Connection.php#669
Illuminate\Database\QueryException
// message to include the bindings with SQL, which will make this exception a
// lot more helpful to the developer instead of just the database's errors.
catch (Exception $e) {
throw new QueryException(
$query, $this->prepareBindings($bindings), $e
);
}
SQLSTATE[HY000]: General error: 1525 Incorrect TIMESTAMP value: '79' /var/www/html/snipeit/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#129 Doctrine\DBAL\Driver\PDOException try { return parent::execute($params); } catch (\PDOException $exception) { throw new PDOException($exception); } }
SQLSTATE[HY000]: General error: 1525 Incorrect TIMESTAMP value: '79' /var/www/html/snipeit/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#127 PDOException public function execute($params = null) { try { return parent::execute($params); } catch (\PDOException $exception) { throw new PDOException($exception); }
snipe
commented
4 years ago That's SUPER weird and I can't reproduce that locally at all. :( It lets me create (and edit) a manufacturer called harman/kardon with no issues. Works on the demo as well... https://demo.snipeitapp.com/manufacturers/18
Is harman/kardon's ID 79 by any chance?
jovibroz
commented
4 years ago Oh yes, its manufacturer ID number 76 "harman/kardon" in the first log and 79 "harmankardon/" in the last debug log. Created "test" and something else I don't remember the name of in-between.. with IDs 77, 78..
Hm. Which I understood a little more about this..
My ubuntu server is super updated. php 7.4 etc. I'm just hitting sudo apt update / upgrade as soon as I have nothing better to do :)
20.04.1 that is..
jovibroz
commented
3 years ago Just crashing in here with a slightly different question, I've learned to live with composer complaining ever so slightly with every upgrade. Shortest possible answer to this: And does it matter? (https://snipe.net/2017/11/15/so-you-ran-composer-as-root/)
-- Local composer.phar detected, so we'll use that.
-- Updating local composer.phar
Cannot create cache directory /var/www/.composer/cache/repo/https---repo.packagist.org/, or directory is not writable. Proceeding without cache Cannot create cache directory /var/www/.composer/cache/files/, or directory is not writable. Proceeding without cache
[ErrorException]
fileowner(): stat failed for /var/www/.composer
self-update [-r|--rollback] [--clean-backups] [--no-progress] [--update-keys] [--stable] [--preview] [--snapshot] [--1] [--2] [--set-channel-only] [--] [
Cannot create cache directory /var/www/.composer/cache/repo/https---repo.packagist.org/, or directory is not writable. Proceeding without cache Cannot create cache directory /var/www/.composer/cache/files/, or directory is not writable. Proceeding without cache Deprecation Notice: Class ParsedownTest located in ./vendor/erusev/parsedown/test/ParsedownTest.php does not comply with psr-0 autoloading standard. It will not autoload anymore in Composer v2.0. in phar:///var/www/html/snipeit/composer.phar/src/Composer/Autoload/ClassMapGenerator.php:201
Illuminate\Foundation\ComposerScripts::postAutoloadDump Cannot create cache directory /var/www/.composer/cache/repo/https---repo.packagist.org/, or directory is not writable. Proceeding without cache Cannot create cache directory /var/www/.composer/cache/files/, or directory is not writable. Proceeding without cache Loading composer repositories with package information Installing dependencies from lock file Nothing to install or update
Snipe.NetComposer is a PHP dependency manager that’s used in just about any modern PHP application, and it works similarly to how Bundler works for Ruby. Even though Composer itself gives you a warning about not running it as root, lots of people disregard this warning and run it as root anyway. We run into this […]
backaf
commented
3 years ago I'm hitting the same TIMESTAMP error in the Docker installation, when updating a manufacturer:
2020-12-04 13:39:01] production.ERROR: PDOException: SQLSTATE[HY000]: General error: 1525 Incorrect TIMESTAMP value: '36' in /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:127
Stack trace:
#0 /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(127): PDOStatement->execute(NULL)
#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(335): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(662): Illuminate\Database\Connection->Illuminate\Database\{closure}('select count(*)...', Array)
#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(629): Illuminate\Database\Connection->runQueryCallback('select count(*)...', Array, Object(Closure))
#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): Illuminate\Database\Connection->run('select count(*)...', Array, Object(Closure))
#5 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2149): Illuminate\Database\Connection->select('select count(*)...', Array, false)Creating new manufacturers works without issues, only updating fails. I run the latest stable 5.0.10. Everything else works fine (asset models, assets etc).
Any idea what might be causing the TIMESTAMP error?
Fresh install of 5.0.0 Build 4484 on Debian 10. PHP 7.3.19
Adding new manufacturers is possible, but upload a logo does not work. Preview of the logo is shown, but after pressing the "Save" button it is not stored in the database. Tested with Firefox and Opera browser and jpg and png files.
/Ralf