Topic on Extension talk:Patroller

Unknown column 'ptr_timestamp' in 'where clause'

5
103.88.223.137 (talkcontribs)

I installed the master version of this extension on my site running on 1.34, but it seems not working for me and giving the following error:

[YJYsQHRHzDNxDujfl4prMwAAQwY] /wiki/Special:Patroller Wikimedia\Rdbms\DBQueryError from line 1603 of /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: SELECT * FROM `page`,`recentchanges` WHERE (ptr_timestamp IS NULL) AND (rc_namespace = page_namespace) AND (rc_title = page_title) AND (rc_this_oldid = page_latest) AND (rc_user != 1) AND rc_bot = '0' AND rc_patrolled = '0' AND rc_type = '0' LIMIT 1

Function: SpecialPatroller::fetchChange

Error: 1054 Unknown column 'ptr_timestamp' in 'where clause'

I run the updater using SSH as well as web updater but nothing is working out. I also tried with different versions 1.31, 1.34 and master but all showing the same error. Can someone please point out if there is anything I'm not doing the right way or there is a bug?


Pigging the developers: @Developaws @Robchurch


Thank you in advance.

RobinHood70 (talkcontribs)

Something's gone wrong with your installation, then. It's looking for a "patrollers" table (which it's supposed to create during the install process) but not finding it. Did update.php give you any messages that might shed light on things?

103.88.223.137 (talkcontribs)

@RobinHood70 : Thank you for replying. I tired reinstalling the extension and this is what I see in the update.php

...patrollers table already exists.

No error message or anything like that. I'm also unable to locate it in Special:Version

Garuda3 (talkcontribs)

I have experienced the same problem when trying to install on Mediawiki 1.37

Vikasnd (talkcontribs)

I am getting the same issue and reverted changes since it does not work. Why not mark this extension unstable so people don't waste time on installing it.

Reply to "Unknown column 'ptr_timestamp' in 'where clause'"