Warning during Multisite Install: sequence _blog_id_seq not yet defined

PostgreSQL-For-Wordpress / postgresql-for-wordpress

A maintained fork of https://wordpress.org/plugins/postgresql-for-wordpress/

GNU General Public License v2.0

209 stars 68 forks source link

Warning during Multisite Install: sequence _blog_id_seq not yet defined #95

Open dilyanpalauzov opened 6 months ago

dilyanpalauzov commented 6 months ago

With PG4WP 3.2 I follow the instructions at https://wordpress.org/documentation/article/create-a-network/ to create a network. I add define( 'WP_ALLOW_MULTISITE', true ); in wp-config.php, then go to Administration → Tools → Network Setup. I select Subdomains → Install.

Now I see "Warning: pg_query(): Query failed: ERROR: currval of sequence "wp_blogs_blog_id_seq" is not yet defined in this session in /example/wp-content/pg4wp/driver_pgsql.php on line 1122".

mattbucci commented 6 months ago

This sequence is created in my test environment but I don't set this up via the web so maybe there is a bug there.

I'm also not using subdomains but I install my test environment by using the wp cli like the following

wp core multisite-install --title="Welcome to My Site" --admin_user="root" --admin_password="mypassword" --admin_email="me@example.com" --url="https://mydomain.com/site/" --base="/site/"