[CARGO] "Create data table" results in error

classic Classic list List threaded Threaded
11 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[CARGO] "Create data table" results in error

Markus Heckmann
Hello,

I have installed Mediawiki 1.28.0 and Cargo 1.3 on an Ubuntu/nginx/postgres system

After creating my first initial template, I selected "Create Data Table" and then when trying to "View Table" the following error is returned:

[68e64bfa8ea418d3a3b30453] /index.php?title=Special:CargoTables/pages MWException from line 1177 of /var/www/html/wiki/extensions/Cargo/CargoSQLQuery.php: Error: No database table exists named "pages".
Backtrace:
#0 /var/www/html/wiki/extensions/Cargo/specials/CargoTables.php(120): CargoSQLQuery->run()
#1 /var/www/html/wiki/includes/specialpage/SpecialPage.php(522): CargoTables->execute(string)
#2 /var/www/html/wiki/includes/specialpage/SpecialPageFactory.php(576): SpecialPage->run(string)
#3 /var/www/html/wiki/includes/MediaWiki.php(283): SpecialPageFactory::executePath(Title, RequestContext)
#4 /var/www/html/wiki/includes/MediaWiki.php(851): MediaWiki->performRequest()
#5 /var/www/html/wiki/includes/MediaWiki.php(512): MediaWiki->main()
#6 /var/www/html/wiki/index.php(43): MediaWiki->run()
#7 {main}

I can see in the wiki database that a table "cargo__pages" was created and I can browse the data via postgres command prompt yet in Special:CargoTables it returns:

The following table is defined:
. pages - Table is registered, but does not exist!


Any hints to what I might be missing?
Thank you very much
Markus



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Semediawiki-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/semediawiki-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [CARGO] "Create data table" results in error

Yaron Koren-2
Hi Markus,

I don't know what exactly happened, but if you call "php
cargoRecreateData.php" in the /maintenance directory, it may fix the
problem - or at least, it will hopefully give a useful error message.

-Yaron

On Mon, Mar 27, 2017 at 3:30 PM, Markus Heckmann <[hidden email]>
wrote:

> Hello,
>
> I have installed Mediawiki 1.28.0 and Cargo 1.3 on an
> Ubuntu/nginx/postgres system
>
> After creating my first initial template, I selected "Create Data Table"
> and then when trying to "View Table" the following error is returned:
>
> [68e64bfa8ea418d3a3b30453] /index.php?title=Special:CargoTables/pages
> MWException from line 1177 of /var/www/html/wiki/extensions/Cargo/CargoSQLQuery.php:
> Error: No database table exists named "pages".
> Backtrace:
> #0 /var/www/html/wiki/extensions/Cargo/specials/CargoTables.php(120):
> CargoSQLQuery->run()
> #1 /var/www/html/wiki/includes/specialpage/SpecialPage.php(522):
> CargoTables->execute(string)
> #2 /var/www/html/wiki/includes/specialpage/SpecialPageFactory.php(576):
> SpecialPage->run(string)
> #3 /var/www/html/wiki/includes/MediaWiki.php(283): SpecialPageFactory::executePath(Title,
> RequestContext)
> #4 /var/www/html/wiki/includes/MediaWiki.php(851):
> MediaWiki->performRequest()
> #5 /var/www/html/wiki/includes/MediaWiki.php(512): MediaWiki->main()
> #6 /var/www/html/wiki/index.php(43): MediaWiki->run()
> #7 {main}
>
> I can see in the wiki database that a table "cargo__pages" was created and
> I can browse the data via postgres command prompt yet in
> Special:CargoTables it returns:
>
> The following table is defined:
> . pages - Table is registered, but does not exist!
>
>
> Any hints to what I might be missing?
> Thank you very much
> Markus
>
>
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Semediawiki-user mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/semediawiki-user
>



--
WikiWorks · MediaWiki Consulting · http://wikiworks.com
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Semediawiki-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/semediawiki-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [CARGO] "Create data table" results in error

Markus Heckmann
Hi Yaron,

Running cargoRecreateData.php  with also setting $wgShowDBErrorBacktrace = true; returns:

Recreating data for Cargo table pages in 5 seconds... hit [Ctrl]-C to escape.
Deleting and recreating table...
[c850ba183ebb6ad025161b13] [no req]   DBQueryError from line 1054 of /var/www/html/wiki/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: CREATE TABLE "cargo__pages" ( "_ID" Int NOT NULL UNIQUE, "_pageName" Varchar(300) NOT NULL, "_pageTitle" Varchar(300) NOT NULL, "_pageNamespace" Int NOT NULL, "_pageID" Int NOT NULL, "OPFamily" Varchar(300), "OPType" Varchar(300), "PageName" Varchar(300), "PageOrder" Int, "Common" Boolean )
Function: Database::query
Error: 42P07 ERROR:  relation "cargo__pages" already exists


Backtrace:
#0 /var/www/html/wiki/includes/libs/rdbms/database/DatabasePostgres.php(249): Database->reportQueryError(string, string, string, string, boolean)
#1 /var/www/html/wiki/includes/libs/rdbms/database/Database.php(912): DatabasePostgres->reportQueryError(string, string, string, string, boolean)
#2 /var/www/html/wiki/extensions/Cargo/CargoUtils.php(666): Database->query(string)
#3 /var/www/html/wiki/extensions/Cargo/CargoUtils.php(483): CargoUtils::createCargoTableOrTables(DatabasePostgres, DatabasePostgres, string, CargoTableSchema, string, string)
#4 /var/www/html/wiki/extensions/Cargo/maintenance/cargoRecreateData.php(90): CargoUtils::recreateDBTablesForTemplate(string, string)
#5 /var/www/html/wiki/extensions/Cargo/maintenance/cargoRecreateData.php(62): CargoRecreateData->recreateAllDataForTable(string)
#6 /var/www/html/wiki/maintenance/doMaintenance.php(111): CargoRecreateData->execute()
#7 /var/www/html/wiki/extensions/Cargo/maintenance/cargoRecreateData.php(141): require_once(string)
#8 {main}

Thanks
Markus

From: [hidden email] [mailto:[hidden email]] On Behalf Of Yaron Koren
Sent: March 27, 2017 4:59 PM
To: Markus Heckmann <[hidden email]>
Cc: [hidden email]
Subject: Re: [Semediawiki-user] [CARGO] "Create data table" results in error

Hi Markus,

I don't know what exactly happened, but if you call "php cargoRecreateData.php" in the /maintenance directory, it may fix the problem - or at least, it will hopefully give a useful error message.

-Yaron

On Mon, Mar 27, 2017 at 3:30 PM, Markus Heckmann <[hidden email]<mailto:[hidden email]>> wrote:
Hello,

I have installed Mediawiki 1.28.0 and Cargo 1.3 on an Ubuntu/nginx/postgres system

After creating my first initial template, I selected "Create Data Table" and then when trying to "View Table" the following error is returned:

[68e64bfa8ea418d3a3b30453] /index.php?title=Special:CargoTables/pages MWException from line 1177 of /var/www/html/wiki/extensions/Cargo/CargoSQLQuery.php: Error: No database table exists named "pages".
Backtrace:
#0 /var/www/html/wiki/extensions/Cargo/specials/CargoTables.php(120): CargoSQLQuery->run()
#1 /var/www/html/wiki/includes/specialpage/SpecialPage.php(522): CargoTables->execute(string)
#2 /var/www/html/wiki/includes/specialpage/SpecialPageFactory.php(576): SpecialPage->run(string)
#3 /var/www/html/wiki/includes/MediaWiki.php(283): SpecialPageFactory::executePath(Title, RequestContext)
#4 /var/www/html/wiki/includes/MediaWiki.php(851): MediaWiki->performRequest()
#5 /var/www/html/wiki/includes/MediaWiki.php(512): MediaWiki->main()
#6 /var/www/html/wiki/index.php(43): MediaWiki->run()
#7 {main}

I can see in the wiki database that a table "cargo__pages" was created and I can browse the data via postgres command prompt yet in Special:CargoTables it returns:

The following table is defined:
. pages - Table is registered, but does not exist!


Any hints to what I might be missing?
Thank you very much
Markus



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Semediawiki-user mailing list
[hidden email]<mailto:[hidden email]>
https://lists.sourceforge.net/lists/listinfo/semediawiki-user



--
WikiWorks · MediaWiki Consulting · http://wikiworks.com
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Semediawiki-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/semediawiki-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [CARGO] "Create data table" results in error

Yaron Koren-2
Okay - my guess is that there's a conflict with the built-in database table
called "cargo_pages". In theory there shouldn't be a problem, since your
tables is called "cargo__pages" (with two underscores), but I'm guessing
that somehow the database is treating them as the same thing. So I would
recommend to rename your defined table to be something other than "pages".

On Mon, Mar 27, 2017 at 5:24 PM, Markus Heckmann <[hidden email]>
wrote:

> Hi Yaron,
>
> Running cargoRecreateData.php  with also setting $wgShowDBErrorBacktrace =
> true; returns:
>
> Recreating data for Cargo table pages in 5 seconds... hit [Ctrl]-C to
> escape.
> Deleting and recreating table...
> [c850ba183ebb6ad025161b13] [no req]   DBQueryError from line 1054 of
> /var/www/html/wiki/includes/libs/rdbms/database/Database.php: A database
> query error has occurred. Did you forget to run your application's database
> schema updater after upgrading?
> Query: CREATE TABLE "cargo__pages" ( "_ID" Int NOT NULL UNIQUE,
> "_pageName" Varchar(300) NOT NULL, "_pageTitle" Varchar(300) NOT NULL,
> "_pageNamespace" Int NOT NULL, "_pageID" Int NOT NULL, "OPFamily"
> Varchar(300), "OPType" Varchar(300), "PageName" Varchar(300), "PageOrder"
> Int, "Common" Boolean )
> Function: Database::query
> Error: 42P07 ERROR:  relation "cargo__pages" already exists
>
>
> Backtrace:
> #0 /var/www/html/wiki/includes/libs/rdbms/database/DatabasePostgres.php(249):
> Database->reportQueryError(string, string, string, string, boolean)
> #1 /var/www/html/wiki/includes/libs/rdbms/database/Database.php(912):
> DatabasePostgres->reportQueryError(string, string, string, string,
> boolean)
> #2 /var/www/html/wiki/extensions/Cargo/CargoUtils.php(666):
> Database->query(string)
> #3 /var/www/html/wiki/extensions/Cargo/CargoUtils.php(483): CargoUtils::
> createCargoTableOrTables(DatabasePostgres, DatabasePostgres, string,
> CargoTableSchema, string, string)
> #4 /var/www/html/wiki/extensions/Cargo/maintenance/cargoRecreateData.php(90):
> CargoUtils::recreateDBTablesForTemplate(string, string)
> #5 /var/www/html/wiki/extensions/Cargo/maintenance/cargoRecreateData.php(62):
> CargoRecreateData->recreateAllDataForTable(string)
> #6 /var/www/html/wiki/maintenance/doMaintenance.php(111):
> CargoRecreateData->execute()
> #7 /var/www/html/wiki/extensions/Cargo/maintenance/cargoRecreateData.php(141):
> require_once(string)
> #8 {main}
>
> Thanks
> Markus
>
> From: [hidden email] [mailto:[hidden email]] On Behalf Of Yaron
> Koren
> Sent: March 27, 2017 4:59 PM
> To: Markus Heckmann <[hidden email]>
> Cc: [hidden email]
> Subject: Re: [Semediawiki-user] [CARGO] "Create data table" results in
> error
>
> Hi Markus,
>
> I don't know what exactly happened, but if you call "php
> cargoRecreateData.php" in the /maintenance directory, it may fix the
> problem - or at least, it will hopefully give a useful error message.
>
> -Yaron
>
> On Mon, Mar 27, 2017 at 3:30 PM, Markus Heckmann <[hidden email]
> <mailto:[hidden email]>> wrote:
> Hello,
>
> I have installed Mediawiki 1.28.0 and Cargo 1.3 on an
> Ubuntu/nginx/postgres system
>
> After creating my first initial template, I selected "Create Data Table"
> and then when trying to "View Table" the following error is returned:
>
> [68e64bfa8ea418d3a3b30453] /index.php?title=Special:CargoTables/pages
> MWException from line 1177 of /var/www/html/wiki/extensions/Cargo/CargoSQLQuery.php:
> Error: No database table exists named "pages".
> Backtrace:
> #0 /var/www/html/wiki/extensions/Cargo/specials/CargoTables.php(120):
> CargoSQLQuery->run()
> #1 /var/www/html/wiki/includes/specialpage/SpecialPage.php(522):
> CargoTables->execute(string)
> #2 /var/www/html/wiki/includes/specialpage/SpecialPageFactory.php(576):
> SpecialPage->run(string)
> #3 /var/www/html/wiki/includes/MediaWiki.php(283): SpecialPageFactory::executePath(Title,
> RequestContext)
> #4 /var/www/html/wiki/includes/MediaWiki.php(851):
> MediaWiki->performRequest()
> #5 /var/www/html/wiki/includes/MediaWiki.php(512): MediaWiki->main()
> #6 /var/www/html/wiki/index.php(43): MediaWiki->run()
> #7 {main}
>
> I can see in the wiki database that a table "cargo__pages" was created and
> I can browse the data via postgres command prompt yet in
> Special:CargoTables it returns:
>
> The following table is defined:
> . pages - Table is registered, but does not exist!
>
>
> Any hints to what I might be missing?
> Thank you very much
> Markus
>
>
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Semediawiki-user mailing list
> [hidden email]<mailto:Semedia
> [hidden email]>
> https://lists.sourceforge.net/lists/listinfo/semediawiki-user
>
>
>
> --
> WikiWorks · MediaWiki Consulting · http://wikiworks.com
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Semediawiki-user mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/semediawiki-user
>



--
WikiWorks · MediaWiki Consulting · http://wikiworks.com
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Semediawiki-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/semediawiki-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [CARGO] "Create data table" results in error

Markus Heckmann
Hi Yaron,

Same happens when I try to create a table called “abdf”
I might just reinstall mediawiki and start fresh. I ran into a login issue yesterday where I had to change some cache settings to be able to log in again…

But in general a nginx / mediawiki / postgres setup shouldn’t be a problem?

Cheers
Markus

From: [hidden email] [mailto:[hidden email]] On Behalf Of Yaron Koren
Sent: March 27, 2017 5:36 PM
To: Markus Heckmann <[hidden email]>
Cc: [hidden email]
Subject: Re: [Semediawiki-user] [CARGO] "Create data table" results in error

Okay - my guess is that there's a conflict with the built-in database table called "cargo_pages". In theory there shouldn't be a problem, since your tables is called "cargo__pages" (with two underscores), but I'm guessing that somehow the database is treating them as the same thing. So I would recommend to rename your defined table to be something other than "pages".

On Mon, Mar 27, 2017 at 5:24 PM, Markus Heckmann <[hidden email]<mailto:[hidden email]>> wrote:
Hi Yaron,

Running cargoRecreateData.php  with also setting $wgShowDBErrorBacktrace = true; returns:

Recreating data for Cargo table pages in 5 seconds... hit [Ctrl]-C to escape.
Deleting and recreating table...
[c850ba183ebb6ad025161b13] [no req]   DBQueryError from line 1054 of /var/www/html/wiki/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: CREATE TABLE "cargo__pages" ( "_ID" Int NOT NULL UNIQUE, "_pageName" Varchar(300) NOT NULL, "_pageTitle" Varchar(300) NOT NULL, "_pageNamespace" Int NOT NULL, "_pageID" Int NOT NULL, "OPFamily" Varchar(300), "OPType" Varchar(300), "PageName" Varchar(300), "PageOrder" Int, "Common" Boolean )
Function: Database::query
Error: 42P07 ERROR:  relation "cargo__pages" already exists


Backtrace:
#0 /var/www/html/wiki/includes/libs/rdbms/database/DatabasePostgres.php(249): Database->reportQueryError(string, string, string, string, boolean)
#1 /var/www/html/wiki/includes/libs/rdbms/database/Database.php(912): DatabasePostgres->reportQueryError(string, string, string, string, boolean)
#2 /var/www/html/wiki/extensions/Cargo/CargoUtils.php(666): Database->query(string)
#3 /var/www/html/wiki/extensions/Cargo/CargoUtils.php(483): CargoUtils::createCargoTableOrTables(DatabasePostgres, DatabasePostgres, string, CargoTableSchema, string, string)
#4 /var/www/html/wiki/extensions/Cargo/maintenance/cargoRecreateData.php(90): CargoUtils::recreateDBTablesForTemplate(string, string)
#5 /var/www/html/wiki/extensions/Cargo/maintenance/cargoRecreateData.php(62): CargoRecreateData->recreateAllDataForTable(string)
#6 /var/www/html/wiki/maintenance/doMaintenance.php(111): CargoRecreateData->execute()
#7 /var/www/html/wiki/extensions/Cargo/maintenance/cargoRecreateData.php(141): require_once(string)
#8 {main}

Thanks
Markus

From: [hidden email]<mailto:[hidden email]> [mailto:[hidden email]<mailto:[hidden email]>] On Behalf Of Yaron Koren
Sent: March 27, 2017 4:59 PM
To: Markus Heckmann <[hidden email]<mailto:[hidden email]>>
Cc: [hidden email]<mailto:[hidden email]>
Subject: Re: [Semediawiki-user] [CARGO] "Create data table" results in error

Hi Markus,

I don't know what exactly happened, but if you call "php cargoRecreateData.php" in the /maintenance directory, it may fix the problem - or at least, it will hopefully give a useful error message.

-Yaron
On Mon, Mar 27, 2017 at 3:30 PM, Markus Heckmann <[hidden email]<mailto:[hidden email]><mailto:[hidden email]<mailto:[hidden email]>>> wrote:
Hello,

I have installed Mediawiki 1.28.0 and Cargo 1.3 on an Ubuntu/nginx/postgres system

After creating my first initial template, I selected "Create Data Table" and then when trying to "View Table" the following error is returned:

[68e64bfa8ea418d3a3b30453] /index.php?title=Special:CargoTables/pages MWException from line 1177 of /var/www/html/wiki/extensions/Cargo/CargoSQLQuery.php: Error: No database table exists named "pages".
Backtrace:
#0 /var/www/html/wiki/extensions/Cargo/specials/CargoTables.php(120): CargoSQLQuery->run()
#1 /var/www/html/wiki/includes/specialpage/SpecialPage.php(522): CargoTables->execute(string)
#2 /var/www/html/wiki/includes/specialpage/SpecialPageFactory.php(576): SpecialPage->run(string)
#3 /var/www/html/wiki/includes/MediaWiki.php(283): SpecialPageFactory::executePath(Title, RequestContext)
#4 /var/www/html/wiki/includes/MediaWiki.php(851): MediaWiki->performRequest()
#5 /var/www/html/wiki/includes/MediaWiki.php(512): MediaWiki->main()
#6 /var/www/html/wiki/index.php(43): MediaWiki->run()
#7 {main}

I can see in the wiki database that a table "cargo__pages" was created and I can browse the data via postgres command prompt yet in Special:CargoTables it returns:

The following table is defined:
. pages - Table is registered, but does not exist!


Any hints to what I might be missing?
Thank you very much
Markus



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Semediawiki-user mailing list
[hidden email]<mailto:[hidden email]><mailto:[hidden email]<mailto:[hidden email]>>
https://lists.sourceforge.net/lists/listinfo/semediawiki-user



--
WikiWorks · MediaWiki Consulting · http://wikiworks.com
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Semediawiki-user mailing list
[hidden email]<mailto:[hidden email]>
https://lists.sourceforge.net/lists/listinfo/semediawiki-user



--
WikiWorks · MediaWiki Consulting · http://wikiworks.com
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Semediawiki-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/semediawiki-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [CARGO] "Create data table" results in error

Markus Heckmann
Hm, unfortunately after a clean reinstall this issue is still the same.
Can I provide some more information that might resolve this issue?

Thanks
Markus

-----Original Message-----
From: Markus Heckmann [mailto:[hidden email]]
Sent: March 27, 2017 5:50 PM
To: Yaron Koren <[hidden email]>
Cc: [hidden email]
Subject: Re: [Semediawiki-user] [CARGO] "Create data table" results in error

Hi Yaron,

Same happens when I try to create a table called “abdf”
I might just reinstall mediawiki and start fresh. I ran into a login issue yesterday where I had to change some cache settings to be able to log in again…

But in general a nginx / mediawiki / postgres setup shouldn’t be a problem?

Cheers
Markus

From: [hidden email] [mailto:[hidden email]] On Behalf Of Yaron Koren
Sent: March 27, 2017 5:36 PM
To: Markus Heckmann <[hidden email]>
Cc: [hidden email]
Subject: Re: [Semediawiki-user] [CARGO] "Create data table" results in error

Okay - my guess is that there's a conflict with the built-in database table called "cargo_pages". In theory there shouldn't be a problem, since your tables is called "cargo__pages" (with two underscores), but I'm guessing that somehow the database is treating them as the same thing. So I would recommend to rename your defined table to be something other than "pages".

On Mon, Mar 27, 2017 at 5:24 PM, Markus Heckmann <[hidden email]<mailto:[hidden email]>> wrote:
Hi Yaron,

Running cargoRecreateData.php  with also setting $wgShowDBErrorBacktrace = true; returns:

Recreating data for Cargo table pages in 5 seconds... hit [Ctrl]-C to escape.
Deleting and recreating table...
[c850ba183ebb6ad025161b13] [no req]   DBQueryError from line 1054 of /var/www/html/wiki/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: CREATE TABLE "cargo__pages" ( "_ID" Int NOT NULL UNIQUE, "_pageName" Varchar(300) NOT NULL, "_pageTitle" Varchar(300) NOT NULL, "_pageNamespace" Int NOT NULL, "_pageID" Int NOT NULL, "OPFamily" Varchar(300), "OPType" Varchar(300), "PageName" Varchar(300), "PageOrder" Int, "Common" Boolean )
Function: Database::query
Error: 42P07 ERROR:  relation "cargo__pages" already exists


Backtrace:
#0 /var/www/html/wiki/includes/libs/rdbms/database/DatabasePostgres.php(249): Database->reportQueryError(string, string, string, string, boolean)
#1 /var/www/html/wiki/includes/libs/rdbms/database/Database.php(912): DatabasePostgres->reportQueryError(string, string, string, string, boolean)
#2 /var/www/html/wiki/extensions/Cargo/CargoUtils.php(666): Database->query(string)
#3 /var/www/html/wiki/extensions/Cargo/CargoUtils.php(483): CargoUtils::createCargoTableOrTables(DatabasePostgres, DatabasePostgres, string, CargoTableSchema, string, string)
#4 /var/www/html/wiki/extensions/Cargo/maintenance/cargoRecreateData.php(90): CargoUtils::recreateDBTablesForTemplate(string, string)
#5 /var/www/html/wiki/extensions/Cargo/maintenance/cargoRecreateData.php(62): CargoRecreateData->recreateAllDataForTable(string)
#6 /var/www/html/wiki/maintenance/doMaintenance.php(111): CargoRecreateData->execute()
#7 /var/www/html/wiki/extensions/Cargo/maintenance/cargoRecreateData.php(141): require_once(string)
#8 {main}

Thanks
Markus

From: [hidden email]<mailto:[hidden email]> [mailto:[hidden email]<mailto:[hidden email]>] On Behalf Of Yaron Koren
Sent: March 27, 2017 4:59 PM
To: Markus Heckmann <[hidden email]<mailto:[hidden email]>>
Cc: [hidden email]<mailto:[hidden email]>
Subject: Re: [Semediawiki-user] [CARGO] "Create data table" results in error

Hi Markus,

I don't know what exactly happened, but if you call "php cargoRecreateData.php" in the /maintenance directory, it may fix the problem - or at least, it will hopefully give a useful error message.

-Yaron
On Mon, Mar 27, 2017 at 3:30 PM, Markus Heckmann <[hidden email]<mailto:[hidden email]><mailto:[hidden email]<mailto:[hidden email]>>> wrote:
Hello,

I have installed Mediawiki 1.28.0 and Cargo 1.3 on an Ubuntu/nginx/postgres system

After creating my first initial template, I selected "Create Data Table" and then when trying to "View Table" the following error is returned:

[68e64bfa8ea418d3a3b30453] /index.php?title=Special:CargoTables/pages MWException from line 1177 of /var/www/html/wiki/extensions/Cargo/CargoSQLQuery.php: Error: No database table exists named "pages".
Backtrace:
#0 /var/www/html/wiki/extensions/Cargo/specials/CargoTables.php(120): CargoSQLQuery->run()
#1 /var/www/html/wiki/includes/specialpage/SpecialPage.php(522): CargoTables->execute(string)
#2 /var/www/html/wiki/includes/specialpage/SpecialPageFactory.php(576): SpecialPage->run(string)
#3 /var/www/html/wiki/includes/MediaWiki.php(283): SpecialPageFactory::executePath(Title, RequestContext)
#4 /var/www/html/wiki/includes/MediaWiki.php(851): MediaWiki->performRequest()
#5 /var/www/html/wiki/includes/MediaWiki.php(512): MediaWiki->main()
#6 /var/www/html/wiki/index.php(43): MediaWiki->run()
#7 {main}

I can see in the wiki database that a table "cargo__pages" was created and I can browse the data via postgres command prompt yet in Special:CargoTables it returns:

The following table is defined:
. pages - Table is registered, but does not exist!


Any hints to what I might be missing?
Thank you very much
Markus



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________
Semediawiki-user mailing list
[hidden email]<mailto:[hidden email]><mailto:[hidden email]<mailto:[hidden email]>>
https://lists.sourceforge.net/lists/listinfo/semediawiki-user

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Semediawiki-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/semediawiki-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [CARGO] "Create data table" results in error

Yaron Koren-2
Hi,

I'm not surprised that a MediaWiki re-install didn't have an impact. But
I'm surprised that renaming the table didn't work. What was the error
message?

Cargo has been much more heavily tested with MySQL than with PostgreSQL,
though as far as I know it works fine with Postgres also.

-Yaron

On Mon, Mar 27, 2017 at 7:18 PM, Markus Heckmann <[hidden email]>
wrote:

> Hm, unfortunately after a clean reinstall this issue is still the same.
> Can I provide some more information that might resolve this issue?
>
> Thanks
> Markus
>
> -----Original Message-----
> From: Markus Heckmann [mailto:[hidden email]]
> Sent: March 27, 2017 5:50 PM
> To: Yaron Koren <[hidden email]>
> Cc: [hidden email]
> Subject: Re: [Semediawiki-user] [CARGO] "Create data table" results in
> error
>
> Hi Yaron,
>
> Same happens when I try to create a table called “abdf”
> I might just reinstall mediawiki and start fresh. I ran into a login issue
> yesterday where I had to change some cache settings to be able to log in
> again…
>
> But in general a nginx / mediawiki / postgres setup shouldn’t be a problem?
>
> Cheers
> Markus
>
>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Semediawiki-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/semediawiki-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [CARGO] "Create data table" results in error

Markus Heckmann
Hi Yaron,

The error message I get when creating the table “ParPage” is this:


[208db1a3c39a08ce982f28f1] /index.php?title=Special:CargoTables/ParPage MWException from line 1177 of /var/www/html/wiki/extensions/Cargo/CargoSQLQuery.php: Error: No database table exists named "ParPage".

Backtrace:

#0 /var/www/html/wiki/extensions/Cargo/specials/CargoTables.php(120): CargoSQLQuery->run()
#1 /var/www/html/wiki/includes/specialpage/SpecialPage.php(522): CargoTables->execute(string)
#2 /var/www/html/wiki/includes/specialpage/SpecialPageFactory.php(576): SpecialPage->run(string)
#3 /var/www/html/wiki/includes/MediaWiki.php(283): SpecialPageFactory::executePath(Title, RequestContext)
#4 /var/www/html/wiki/includes/MediaWiki.php(851): MediaWiki->performRequest()
#5 /var/www/html/wiki/includes/MediaWiki.php(512): MediaWiki->main()
#6 /var/www/html/wiki/index.php(43): MediaWiki->run()
#7 {main}

The table internally is called cargo__ParPage – could that be a problem?

When running cargoRecreateData.php, the error thrown is following:

Deleting and recreating table...
[fa26c7e43ca04390311cbe48] [no req]   DBQueryError from line 1054 of /var/www/html/wiki/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: CREATE TABLE "cargo__ParPage" ( "_ID" Int NOT NULL UNIQUE, "_pageName" Varchar(300) NOT NULL, "_pageTitle" Varchar(300) NOT NULL, "_pageNamespace" Int NOT NULL, "_pageID" Int NOT NULL, "OPFamily" Varchar(300), "OPType" Varchar(300), "Pagename" Varchar(300), "Pageorder" Int, "Common" Boolean )
Function: Database::query
Error: 42P07 ERROR:  relation "cargo__ParPage" already exists


Backtrace:
#0 /var/www/html/wiki/includes/libs/rdbms/database/DatabasePostgres.php(249): Database->reportQueryError(string, string, string, string, boolean)
#1 /var/www/html/wiki/includes/libs/rdbms/database/Database.php(912): DatabasePostgres->reportQueryError(string, string, string, string, boolean)
#2 /var/www/html/wiki/extensions/Cargo/CargoUtils.php(666): Database->query(string)
#3 /var/www/html/wiki/extensions/Cargo/CargoUtils.php(483): CargoUtils::createCargoTableOrTables(DatabasePostgres, DatabasePostgres, string, CargoTableSchema, string, string)
#4 /var/www/html/wiki/extensions/Cargo/maintenance/cargoRecreateData.php(90): CargoUtils::recreateDBTablesForTemplate(string, string)
#5 /var/www/html/wiki/extensions/Cargo/maintenance/cargoRecreateData.php(62): CargoRecreateData->recreateAllDataForTable(string)
#6 /var/www/html/wiki/maintenance/doMaintenance.php(111): CargoRecreateData->execute()
#7 /var/www/html/wiki/extensions/Cargo/maintenance/cargoRecreateData.php(141): require_once(string)
#8 {main}

Cheers
Markus

From: [hidden email] [mailto:[hidden email]] On Behalf Of Yaron Koren
Sent: March 27, 2017 9:42 PM
To: Markus Heckmann <[hidden email]>
Cc: [hidden email]
Subject: Re: [Semediawiki-user] [CARGO] "Create data table" results in error

Hi,

I'm not surprised that a MediaWiki re-install didn't have an impact. But I'm surprised that renaming the table didn't work. What was the error message?

Cargo has been much more heavily tested with MySQL than with PostgreSQL, though as far as I know it works fine with Postgres also.

-Yaron

On Mon, Mar 27, 2017 at 7:18 PM, Markus Heckmann <[hidden email]<mailto:[hidden email]>> wrote:
Hm, unfortunately after a clean reinstall this issue is still the same.
Can I provide some more information that might resolve this issue?

Thanks
Markus

-----Original Message-----
From: Markus Heckmann [mailto:[hidden email]<mailto:[hidden email]>]
Sent: March 27, 2017 5:50 PM
To: Yaron Koren <[hidden email]<mailto:[hidden email]>>
Cc: [hidden email]<mailto:[hidden email]>
Subject: Re: [Semediawiki-user] [CARGO] "Create data table" results in error

Hi Yaron,

Same happens when I try to create a table called “abdf”
I might just reinstall mediawiki and start fresh. I ran into a login issue yesterday where I had to change some cache settings to be able to log in again…

But in general a nginx / mediawiki / postgres setup shouldn’t be a problem?

Cheers
Markus
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Semediawiki-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/semediawiki-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [CARGO] "Create data table" results in error

Yaron Koren-2
Okay, this is helpful. So the issue probably wasn't calling your table
"pages".

Does the table "cargo__ParPage" still exist in your database? If so, my new
guess is that your database user lacks the permission to drop tables. You
will need to add that to be able to use Cargo.



> When running cargoRecreateData.php, the error thrown is following:
>
> Deleting and recreating table...
> [fa26c7e43ca04390311cbe48] [no req]   DBQueryError from line 1054 of
> /var/www/html/wiki/includes/libs/rdbms/database/Database.php: A database
> query error has occurred. Did you forget to run your application's database
> schema updater after upgrading?
> Query: CREATE TABLE "cargo__ParPage" ( "_ID" Int NOT NULL UNIQUE,
> "_pageName" Varchar(300) NOT NULL, "_pageTitle" Varchar(300) NOT NULL,
> "_pageNamespace" Int NOT NULL, "_pageID" Int NOT NULL, "OPFamily"
> Varchar(300), "OPType" Varchar(300), "Pagename" Varchar(300), "Pageorder"
> Int, "Common" Boolean )
> Function: Database::query
> Error: 42P07 ERROR:  relation "cargo__ParPage" already exists
>
>
--
WikiWorks · MediaWiki Consulting · http://wikiworks.com
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Semediawiki-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/semediawiki-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [CARGO] "Create data table" results in error

Markus Heckmann
Hi Yaron,

Back in the correct thread…
Thanks for checking – I’ll try MySQL now..
Should I file this as a bug in phabricator?

Cheers
Markus

From: [hidden email] [mailto:[hidden email]] On Behalf Of Yaron Koren
Sent: March 28, 2017 11:40 AM
To: Markus Heckmann <[hidden email]>
Cc: [hidden email]
Subject: Re: [Semediawiki-user] [CARGO] "Create data table" results in error

Okay, this is helpful. So the issue probably wasn't calling your table "pages".

Does the table "cargo__ParPage" still exist in your database? If so, my new guess is that your database user lacks the permission to drop tables. You will need to add that to be able to use Cargo.


When running cargoRecreateData.php, the error thrown is following:

Deleting and recreating table...
[fa26c7e43ca04390311cbe48] [no req]   DBQueryError from line 1054 of /var/www/html/wiki/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: CREATE TABLE "cargo__ParPage" ( "_ID" Int NOT NULL UNIQUE, "_pageName" Varchar(300) NOT NULL, "_pageTitle" Varchar(300) NOT NULL, "_pageNamespace" Int NOT NULL, "_pageID" Int NOT NULL, "OPFamily" Varchar(300), "OPType" Varchar(300), "Pagename" Varchar(300), "Pageorder" Int, "Common" Boolean )
Function: Database::query
Error: 42P07 ERROR:  relation "cargo__ParPage" already exists

--
WikiWorks · MediaWiki Consulting · http://wikiworks.com
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Semediawiki-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/semediawiki-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [CARGO] "Create data table" results in error

Yaron Koren-2
Sure, feel free.

On Tue, Mar 28, 2017 at 12:38 PM, Markus Heckmann <[hidden email]>
wrote:

> Hi Yaron,
>
> Back in the correct thread…
> Thanks for checking – I’ll try MySQL now..
> Should I file this as a bug in phabricator?
>
> Cheers
> Markus
>
> From: [hidden email] [mailto:[hidden email]] On Behalf Of Yaron
> Koren
> Sent: March 28, 2017 11:40 AM
> To: Markus Heckmann <[hidden email]>
> Cc: [hidden email]
> Subject: Re: [Semediawiki-user] [CARGO] "Create data table" results in
> error
>
> Okay, this is helpful. So the issue probably wasn't calling your table
> "pages".
>
> Does the table "cargo__ParPage" still exist in your database? If so, my
> new guess is that your database user lacks the permission to drop tables.
> You will need to add that to be able to use Cargo.
>
>
> When running cargoRecreateData.php, the error thrown is following:
>
> Deleting and recreating table...
> [fa26c7e43ca04390311cbe48] [no req]   DBQueryError from line 1054 of
> /var/www/html/wiki/includes/libs/rdbms/database/Database.php: A database
> query error has occurred. Did you forget to run your application's database
> schema updater after upgrading?
> Query: CREATE TABLE "cargo__ParPage" ( "_ID" Int NOT NULL UNIQUE,
> "_pageName" Varchar(300) NOT NULL, "_pageTitle" Varchar(300) NOT NULL,
> "_pageNamespace" Int NOT NULL, "_pageID" Int NOT NULL, "OPFamily"
> Varchar(300), "OPType" Varchar(300), "Pagename" Varchar(300), "Pageorder"
> Int, "Common" Boolean )
> Function: Database::query
> Error: 42P07 ERROR:  relation "cargo__ParPage" already exists
>
> --
> WikiWorks · MediaWiki Consulting · http://wikiworks.com
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Semediawiki-user mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/semediawiki-user
>



--
WikiWorks · MediaWiki Consulting · http://wikiworks.com
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Semediawiki-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/semediawiki-user
Loading...