Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Warning: pg_query(): Query failed: ERROR: value too long for type character varying(12) #746

Open
UweKrause opened this issue Dec 25, 2020 · 0 comments

Comments

@UweKrause
Copy link
Contributor

UweKrause commented Dec 25, 2020

After installation, the very first time (and only that first time!) entering the administration interface, there is an error.

It goes away forever after a reload of the page.

Debian 10, fresh install, nothing else on that machine
Serendipity git/master
psql (PostgreSQL) 11.9 (Debian 11.9-0+deb10u1)
PHP 7.3.19-1~deb10u1 (cli) (built: Jul 5 2020 06:46:45) ( NTS )
(everything installed from apt, official debian packet sources)

Might be related to #743

reported Code is this:

$serendipity['dbLastResult'] = pg_query($serendipity['dbConn'], $sql);

Error message is:

== ERROR-REPORT (BETA/ALPHA-BUILDS) ==

Warning: pg_query(): Query failed: ERROR: value too long for type character varying(12) in /var/www/html/include/db/postgres.inc.php on line 222.
For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.



Fatal error:  Uncaught ErrorException: Warning: pg_query(): Query failed: ERROR:  value too long for type character varying(12) in /var/www/html/include/db/postgres.inc.php:222
Stack trace:
#0 [internal function]: errorToExceptionHandler(2, 'pg_query(): Que...', '/var/www/html/i...', 222, Array)
#1 /var/www/html/include/db/postgres.inc.php(222): pg_query(Resource id #3, 'INSERT INTO ser...')
#2 /var/www/html/include/db/db.inc.php(88): serendipity_db_query('INSERT INTO ser...')
#3 /var/www/html/include/plugin_api.inc.php(849): serendipity_db_insert('pluginlist', Array)
#4 /var/www/html/plugins/serendipity_event_spartacus/serendipity_event_spartacus.php(867): serendipity_plugin_api::setPluginInfo(Array, 'serendipity_eve...', 47, 47, 'Spartacus')
#5 /var/www/html/plugins/serendipity_event_spartacus/serendipity_event_spartacus.php(1165): serendipity_event_spartacus->buildList(Array, 'event')
#6 /var/www/html/plugins/serendipity_event_spartacus/serendipity_event_spartacus.php(1335): serendipity_event_spartacus->count_plugin_upg in /var/www/html/include/db/postgres.inc.php on line 222

 == ERROR-REPORT (BETA/ALPHA-BUILDS) == 

Fatal Error: Uncaught ErrorException: Warning: pg_query(): Query failed: ERROR:  value too long for type character varying(12) in /var/www/html/include/db/postgres.inc.php:222
Stack trace:
#0 [internal function]: errorToExceptionHandler(2, 'pg_query(): Que...', '/var/www/html/i...', 222, Array)
#1 /var/www/html/include/db/postgres.inc.php(222): pg_query(Resource id #3, 'INSERT INTO ser...')
#2 /var/www/html/include/db/db.inc.php(88): serendipity_db_query('INSERT INTO ser...')
#3 /var/www/html/include/plugin_api.inc.php(849): serendipity_db_insert('pluginlist', Array)
#4 /var/www/html/plugins/serendipity_event_spartacus/serendipity_event_spartacus.php(867): serendipity_plugin_api::setPluginInfo(Array, 'serendipity_eve...', 47, 47, 'Spartacus')
#5 /var/www/html/plugins/serendipity_event_spartacus/serendipity_event_spartacus.php(1165): serendipity_event_spartacus->buildList(Array, 'event')
#6 /var/www/html/plugins/serendipity_event_spartacus/serendipity_event_spartacus.php(1335): serendipity_event_spartacus->count_plugin_upg in /var/www/html/include/db/postgres.inc.php on line 222.
For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.



Fatal error:  Uncaught ErrorException: Fatal Error: Uncaught ErrorException: Warning: pg_query(): Query failed: ERROR:  value too long for type character varying(12) in /var/www/html/include/db/postgres.inc.php:222
Stack trace:
#0 [internal function]: errorToExceptionHandler(2, 'pg_query(): Que...', '/var/www/html/i...', 222, Array)
#1 /var/www/html/include/db/postgres.inc.php(222): pg_query(Resource id #3, 'INSERT INTO ser...')
#2 /var/www/html/include/db/db.inc.php(88): serendipity_db_query('INSERT INTO ser...')
#3 /var/www/html/include/plugin_api.inc.php(849): serendipity_db_insert('pluginlist', Array)
#4 /var/www/html/plugins/serendipity_event_spartacus/serendipity_event_spartacus.php(867): serendipity_plugin_api::setPluginInfo(Array, 'serendipity_eve...', 47, 47, 'Spartacus')
#5 /var/www/html/plugins/serendipity_event_spartacus/serendipity_event_spartacus.php(1165): serendipity_event_spartacus->buildList(Array, 'event')
#6 /var/www/html/plugins/serendipity_event_spartacus/serendipity_event_spartacus.php(1335): serendi in /var/www/html/include/db/postgres.inc.php on line 222
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants