Comments (19)
did you use install.php?
from spotweb.
Yes: all OK and when continuing, I get the same error
Op 4 apr. 2015, om 13:02 heeft Sweepr [email protected] het volgende geschreven:
did you use install.php?
—
Reply to this email directly or view it on GitHub #58 (comment).
from spotweb.
Duplicate entry '3-31-pushover' for key 'idx_grouppermissions_1'
Try to run php upgrade-db.php --reset-securitygroups
from spotweb.
With @Sweepr, but also.
You are only able to get this error if you eithre modified default groups (not possible with the UI, so a manual database modification), or if you upgraded Spotweb and then downgraded again.
Both options are not really advised, so please tell us what you did as you might be running into more troubles in the long run.
from spotweb.
Running php upgrade-db.php --reset-securitygroups did not solve this problem. I switched from master to media branch a while ago and was running without problems. When git gave retrieve errors, I switched back to master branch. I did not alter any database tables.
I have completely started from scratch: removed database, removed /var/www/spotweb. Ran through install.php, so far so good.
When running retrieve, I bump into the following issue:
Last retrieve at Thu 01 Jan 1970 01:00:00 AM CET
Retrieving new Spots from server reader.extremeusenet.nl...
Appr. Message count: 1533959
First message number: 1670671
Last message number: 3204630
Current article number: 1670671
Retrieving 1670671 till 1675672PHP Warning: PDO::quote() expects parameter 1 to be string, array given in /var/www/spotweb/lib/dbeng/dbeng_pdo.php on line 175
PHP Warning: PDO::quote() expects parameter 1 to be string, array given in /var/www/spotweb/lib/dbeng/dbeng_pdo.php on line 175
PHP Warning: PDO::quote() expects parameter 1 to be string, array given in /var/www/spotweb/lib/dbeng/dbeng_pdo.php on line 175
PHP Warning: PDO::quote() expects parameter 1 to be string, array given in /var/www/spotweb/lib/dbeng/dbeng_pdo.php on line 175
...
PHP Warning: PDO::quote() expects parameter 1 to be string, array given in /var/www/spotweb/lib/dbeng/dbeng_pdo.php on line 175
PHP Warning: PDO::quote() expects parameter 1 to be string, array given in /var/www/spotweb/lib/dbeng/dbeng_pdo.php on line 175
PHP Warning: PDO::quote() expects parameter 1 to be string, array given in /var/www/spotweb/lib/dbeng/dbeng_pdo.php on line 175
SpotWeb v0.68.29.32 on PHP v5.5.12-2ubuntu4.3 crashed
Fatal error occured retrieving reports:
42000: 1064: 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 ',,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,' at line 1 (SQLSTATE[42000]: Syntax error or access violation: 1064 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 ',,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,' at line 1)
#0 /var/www/spotweb/lib/dbeng/dbeng_pdo.php(146): dbeng_pdo->exec('SELECT messagei...', Array)
#1 /var/www/spotweb/lib/dao/Base/Dao_Base_Spot.php(606): dbeng_pdo->arrayQuery('SELECT messagei...')
#2 /var/www/spotweb/lib/services/Retriever/Services_Retriever_Spots.php(216): Dao_Base_Spot->matchSpotMessageIds(Array)
#3 /var/www/spotweb/lib/services/Retriever/Services_Retriever_Base.php(227): Services_Retriever_Spots->process(Array, '1670671', 1675672, 1428309381.8658)
#4 /var/www/spotweb/lib/services/Retriever/Services_Retriever_Base.php(319): Services_Retriever_Base->loopTillEnd('0', '5000')
#5 /var/www/spotweb/retrieve.php(155): Services_Retriever_Base->perform()
#6 {main}
from spotweb.
PHP Warning: PDO::quote() expects parameter 1 to be string, array given in
This has something to do with your PHP config
from spotweb.
I experience the same behaviour icw php 5.6.6-2 and MySQL Ver 14.14 Distrib 5.5.42.
Clean git pull, install.php succeeds configuring new (truncated) DB, Spotweb is accessible and functioning properly. First retrieve though throws the same error as above. This behaviour happens only on Media Branch, no problem on Master.
Last retrieve at Thu Jan 1 01:00:00 1970
Retrieving new Spots from server reader.haregruwelijkhe.id...
Appr. Message count: 1812957
First message number: 5698531
Last message number: 7511488
Current article number: 5698531
Retrieving 5698531 till 5703532PHP Warning: PDO::quote() expects parameter 1 to be string, array given in /var/www/spotweb/spotweb/lib/dbeng/dbeng_pdo.php on line 175
PHP Warning: PDO::quote() expects parameter 1 to be string, array given in /var/www/spotweb/spotweb/lib/dbeng/dbeng_pdo.php on line 175
........................
PHP Warning: PDO::quote() expects parameter 1 to be string, array given in /var/www/spotweb/spotweb/lib/dbeng/dbeng_pdo.php on line 175
PHP Warning: PDO::quote() expects parameter 1 to be string, array given in /var/www/spotweb/spotweb/lib/dbeng/dbeng_pdo.php on line 175
SpotWeb v0.68.29.32 on PHP v5.6.6-2 crashed
Fatal error occured retrieving reports:
42000: 1064: 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 ',,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,' at line 1 (SQLSTATE[42000]: Syntax error or access violation: 1064 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 ',,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,' at line 1)
#0 /var/www/spotweb/spotweb/lib/dbeng/dbeng_pdo.php(146): dbeng_pdo->exec('SELECT messagei...', Array)
#1 /var/www/spotweb/spotweb/lib/dao/Base/Dao_Base_Spot.php(606): dbeng_pdo->arrayQuery('SELECT messagei...')
#2 /var/www/spotweb/spotweb/lib/services/Retriever/Services_Retriever_Spots.php(216): Dao_Base_Spot->matchSpotMessageIds(Array)
#3 /var/www/spotweb/spotweb/lib/services/Retriever/Services_Retriever_Base.php(227): Services_Retriever_Spots->process(Array, '5698531', 5703532, 1428399866.7311)
#4 /var/www/spotweb/spotweb/lib/services/Retriever/Services_Retriever_Base.php(319): Services_Retriever_Base->loopTillEnd('0', '5000')
#5 /var/www/spotweb/spotweb/retrieve.php(155): Services_Retriever_Base->perform()
#6 {main}
from spotweb.
What does your dbsettings.inc.php file state at:
$dbsettings['engine'] =
from spotweb.
cat dbsettings.inc.php | grep engine
$dbsettings['engine'] = 'pdo_mysql';
from spotweb.
That's seems ok,
I'm also running the media branch and i have not yet ran into any of the above problems.
What's the output if you run retrieve --debug
from spotweb.
What version of PHP and MySQL are you running on? But then again, the master branch should also be affected, and that is not the case here. I got a master branch up-to-date and running without an issue, strange...
php retrieve.php --reallyforce --debug &> error.msg
cat error.msg
Last retrieve at Thu Jan 1 01:00:00 1970
Retrieving new Spots from server reader.haregruwelijkhe.id...
Appr. Message count: 1813388
First message number: 5698531
Last message number: 7511919
Current article number: 5698531
Retrieving 5698531 till 5703532PHP Warning: PDO::quote() expects parameter 1 to be string, array given in /var/www/spotweb/spotweb/lib/dbeng/dbeng_pdo.php on line 175
PHP Warning: PDO::quote() expects parameter 1 to be string, array given in /var/www/spotweb/spotweb/lib/dbeng/dbeng_pdo.php on line 175
....
PHP Warning: PDO::quote() expects parameter 1 to be string, array given in /var/www/spotweb/spotweb/lib/dbeng/dbeng_pdo.php on line 175
PHP Warning: PDO::quote() expects parameter 1 to be string, array given in /var/www/spotweb/spotweb/lib/dbeng/dbeng_pdo.php on line 175
SpotWeb v0.68.29.32 on PHP v5.6.6-2 crashed
Fatal error occured retrieving reports:
42000: 1064: 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 ',,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,' at line 1 (SQLSTATE[42000]: Syntax error or access violation: 1064 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 ',,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,' at line 1)
#0 /var/www/spotweb/spotweb/lib/dbeng/dbeng_pdo.php(146): dbeng_pdo->exec('SELECT messagei...', Array)
#1 /var/www/spotweb/spotweb/lib/dao/Base/Dao_Base_Spot.php(606): dbeng_pdo->arrayQuery('SELECT messagei...')
#2 /var/www/spotweb/spotweb/lib/services/Retriever/Services_Retriever_Spots.php(216): Dao_Base_Spot->matchSpotMessageIds(Array)
#3 /var/www/spotweb/spotweb/lib/services/Retriever/Services_Retriever_Base.php(227): Services_Retriever_Spots->process(Array, '5698531', 5703532, 1428441739.3529)
#4 /var/www/spotweb/spotweb/lib/services/Retriever/Services_Retriever_Base.php(319): Services_Retriever_Base->loopTillEnd('0', '5000')
#5 /var/www/spotweb/spotweb/retrieve.php(155): Services_Retriever_Base->perform()
#6 {main}
from spotweb.
@WzL, i'm running Percona Server 5.5.41-37.0 Release 37.0, Rev 727 , Spotweb is running on PHP Version 5.3.28
from spotweb.
Ok if i diff between the two branches, these are the changes:
diff /var/www/spotweb/master/lib/dbeng/dbeng_pdo.php /var/www/spotweb/media/lib/dbeng/dbeng_pdo.php
59c59
< throw new SqlErrorException(implode(': ', $x->errorInfo), -1);
---
> throw new SqlErrorException(implode(': ', $x->errorInfo) . ' (' . $x->getMessage() . ')', -1);
73c73
<
---
>
124c124
< $row = $stmt->fetch();
---
> $row = $stmt->fetch(PDO::FETCH_NUM);
147c147
< $tmpArray = $stmt->fetchAll();
---
> $tmpArray = $stmt->fetchAll(PDO::FETCH_ASSOC);
159a160
> * @param $forceType
160a162
> * @throws NotImplementedException
162,164c164,170
< function safe($s) {
< if (is_integer($s) || is_double($s)) {
< return $s;
---
> function safe($s, $forceType = null) {
> if ($forceType === null) {
> if (is_integer($s) || is_double($s)) {
> return $s;
> } else {
> return $this->_conn->quote($s);
> } # else
166,167c172,179
< return $this->_conn->quote($s);
< } # else
---
> if ($forceType == PDO::PARAM_INT) {
> return (float) $s;
> } elseif ($forceType == PDO::PARAM_STR) {
> return $this->_conn->quote($s);
> } else {
> throw new NotImplementedException("Unknown forcetype passed to safe()");
> } // else
> } // else
from spotweb.
Can you find this:
When you add phpinfo.php to your webroot and browse to spotweb/phpinfo.php
Do you see anything that looks like this?
PDO
PDO support enabled
PDO drivers mysql, sqlite
from spotweb.
i got:
PDO
PDO support enabled
PDO drivers mysql
pdo_mysql
PDO Driver for MySQL enabled
Client API version 5.5.42
from spotweb.
Running out of idea's at this time..
Few things i'd like to see, what happens when you change :
$dbsettings['engine'] = 'pdo_mysql';
Into
$dbsettings['engine'] = 'mysql';
If this does not change anything,
Open your php.ini file and look for these extensions below.
Comment them out and see what happens.
extension=pdo.so
extension=pdo_mysql.so
from spotweb.
I had the same issue. With phpmyadmin deleted the entry and run upgrade-db.php again. Problem solved.
Sorry, did not solve the retrieve error.
I switched back to the master branch and everything is working fine again. Except the media info of course.
from spotweb.
Try now:
from spotweb.
See: #60
from spotweb.
Related Issues (20)
- PHP8.2 Deprecated Functions HOT 2
- [New issue] HOT 24
- can get sonarr to work with nzbserver spotweb HOT 1
- Question about Spotweb usenet connections HOT 3
- Update from Debian 11 to Debian 12 (seeing index.php content) (solved) HOT 1
- NZB button makes file with name download with error message after update dsm Version: 7.1.1-42962 Update 5 HOT 3
- Spots aren't being retrieved HOT 6
- [New issue] Spotweb search “Law & Order” gives error HOT 3
- (502) Authentication rejected [response: "Too many connections"] [response: ""] HOT 2
- [New issue] HOT 1
- Undefined array key "enc"Undefined array key "port" HOT 3
- Default blacklist/whitelist URLs are offline HOT 6
- unable to run retrieve.php HOT 9
- Where do I issue command to reset database? HOT 1
- [New issue] Black- and whitelists are not working anymore, seem to be garbled? HOT 22
- Local Blacklist HOT 2
- SpotWeb webui not loading in Organizr HOT 2
- add support for docker secrets as env-variabls HOT 1
- Latest SC Synology package won’t run after install. HOT 4
- problem sending to sabnzbd when using reverse proxy HOT 11
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from spotweb.