[Bug 27765] Postgresql: invalid input syntax for type timestamp (Semantic MW)
https://bugzilla.wikimedia.org/show_bug.cgi?id=27765 Jeroen De Dauw changed: What|Removed |Added Status|ASSIGNED|RESOLVED Resolution||FIXED -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 27765] Postgresql: invalid input syntax for type timestamp (Semantic MW)
https://bugzilla.wikimedia.org/show_bug.cgi?id=27765 Jeroen De Dauw changed: What|Removed |Added Status|REOPENED|ASSIGNED --- Comment #15 from Jeroen De Dauw 2011-07-29 15:34:06 UTC --- The patch might have been reverted due to side effects. I don't really remember, so will have to look into this further. I really can't make this change and risk introducing this side effect at this point, as SMW 1.6 is planned to be released tomorrow. I'll look at it after the release. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 27765] Postgresql: invalid input syntax for type timestamp (Semantic MW)
https://bugzilla.wikimedia.org/show_bug.cgi?id=27765 --- Comment #14 from Brandon Plewe 2011-07-29 03:34:33 UTC --- I mean that I started seeing this bug when I upgraded SMW to 1.5.6. I was not seeing it in 1.5.4. I assume in April you committed Pieter's patch into what became 1.5.4, but somehow 1.5.6 had the older code. I was able to put the patch back in, and it worked. I just was hoping someone could check the code for SMW 1.6 to make sure the patched code is there. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 27765] Postgresql: invalid input syntax for type timestamp (Semantic MW)
https://bugzilla.wikimedia.org/show_bug.cgi?id=27765 --- Comment #13 from Jeroen De Dauw 2011-07-27 22:15:59 UTC --- (In reply to comment #12) > This wasn't an issue in SMW 1.5.4, but seems to have reappeared in 1.5.6; when > I put Pieter Kersten's patch back into SMW_Store.php, it works fine. Please > check this for 1.6. I'm not sure what you are referring to. Please elaborate or open a new bug report. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 27765] Postgresql: invalid input syntax for type timestamp (Semantic MW)
https://bugzilla.wikimedia.org/show_bug.cgi?id=27765 Brandon Plewe changed: What|Removed |Added Status|RESOLVED|REOPENED CC||pl...@byu.edu Resolution|FIXED | --- Comment #12 from Brandon Plewe 2011-07-27 20:33:00 UTC --- This wasn't an issue in SMW 1.5.4, but seems to have reappeared in 1.5.6; when I put Pieter Kersten's patch back into SMW_Store.php, it works fine. Please check this for 1.6. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 27765] Postgresql: invalid input syntax for type timestamp (Semantic MW)
https://bugzilla.wikimedia.org/show_bug.cgi?id=27765 --- Comment #11 from Jeroen De Dauw 2011-04-09 20:12:23 UTC --- Ah, nice, thanks :) Just committed that -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 27765] Postgresql: invalid input syntax for type timestamp (Semantic MW)
https://bugzilla.wikimedia.org/show_bug.cgi?id=27765 --- Comment #10 from Pieter J. Kersten 2011-04-09 19:59:39 UTC --- A better fix: SMW_Store.php +233 $dbw->update( 'page', array( 'page_touched' => $dbw->timestamp(time() +9001) ), $title->pageCond(), __METHOD__ ); Seems to work as well and should fix the cache problem. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 27765] Postgresql: invalid input syntax for type timestamp (Semantic MW)
https://bugzilla.wikimedia.org/show_bug.cgi?id=27765 Pieter J. Kersten changed: What|Removed |Added Status|ASSIGNED|RESOLVED Resolution||FIXED --- Comment #9 from Pieter J. Kersten 2011-04-08 12:55:45 UTC --- Your modification is the same as I did. It's working for me, without further verifying cache behavior. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 27765] Postgresql: invalid input syntax for type timestamp (Semantic MW)
https://bugzilla.wikimedia.org/show_bug.cgi?id=27765 --- Comment #8 from Jeroen De Dauw 2011-04-07 21:38:39 UTC --- I just changed the addition to only happen for mysql, should find a more decent fix later on though, because now the automatic refresh won't happen for postgres. Can you confirm the issue is 'fixed'? -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 27765] Postgresql: invalid input syntax for type timestamp (Semantic MW)
https://bugzilla.wikimedia.org/show_bug.cgi?id=27765 p858snake changed: What|Removed |Added Keywords||postgresql CC||p858sn...@gmail.com -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 27765] Postgresql: invalid input syntax for type timestamp (Semantic MW)
https://bugzilla.wikimedia.org/show_bug.cgi?id=27765 Pieter J. Kersten changed: What|Removed |Added CC||p.j.kers...@edusense.nl --- Comment #7 from Pieter J. Kersten 2011-04-06 13:54:21 UTC --- FWIW, removing the extra addition on the timestamp in SMW_Store.php:238 makes it work again. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 27765] Postgresql: invalid input syntax for type timestamp (Semantic MW)
https://bugzilla.wikimedia.org/show_bug.cgi?id=27765 Greg Sabino Mullane changed: What|Removed |Added CC||g...@turnstep.com Summary|Postgresql: invalid input |Postgresql: invalid input |syntax for type timestamp |syntax for type timestamp ||(Semantic MW) -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 27765] Postgresql: invalid input syntax for type timestamp
https://bugzilla.wikimedia.org/show_bug.cgi?id=27765 --- Comment #6 from Jeroen De Dauw 2011-02-28 14:46:13 UTC --- Indeed, now I see. It's an update to indicate the page cache is invalid (not an insert), and it's doing pretty much the same as the invalidation function in MW core, with the difference that the code in SMW is adding some number to the timestamp, to ensure it's bigger then the one at which the page is actually saved. In any case, I'll have another go at the whole MW+SMW PostGres story tomorrow. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 27765] Postgresql: invalid input syntax for type timestamp
https://bugzilla.wikimedia.org/show_bug.cgi?id=27765 --- Comment #5 from Markus Krötzsch 2011-02-28 08:31:48 UTC --- Its in the bug report: it gives the lines where the SQL error came from. Moreover, SMW does usually not touch any MW tables, and the bug is about an insert in the "page" table. Is this really necessary? -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 27765] Postgresql: invalid input syntax for type timestamp
https://bugzilla.wikimedia.org/show_bug.cgi?id=27765 --- Comment #4 from Jeroen De Dauw 2011-02-27 21:07:17 UTC --- How do you figure it's related to the AutoRefreshSubject stuff? -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 27765] Postgresql: invalid input syntax for type timestamp
https://bugzilla.wikimedia.org/show_bug.cgi?id=27765 Markus Krötzsch changed: What|Removed |Added CC||markus@semantic-mediawiki.o ||rg --- Comment #3 from Markus Krötzsch 2011-02-27 20:18:36 UTC --- I note that this error relates to the recent AutoRefreshSubject extension in SMW. It might be that it is not specific to Postgres. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 27765] Postgresql: invalid input syntax for type timestamp
https://bugzilla.wikimedia.org/show_bug.cgi?id=27765 Jeroen De Dauw changed: What|Removed |Added AssignedTo|markus@semantic-mediawiki.o |jeroen_ded...@yahoo.com |rg | -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 27765] Postgresql: invalid input syntax for type timestamp
https://bugzilla.wikimedia.org/show_bug.cgi?id=27765 Jeroen De Dauw changed: What|Removed |Added Status|NEW |ASSIGNED --- Comment #2 from Jeroen De Dauw 2011-02-27 18:34:59 UTC --- Thanks for reporting this. There are multiple known issues with the recent versions of SMW and PostGres. I will have a look at this as soon as the PostGres support of the MW 1.17 installer gets fixed. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 27765] Postgresql: invalid input syntax for type timestamp
https://bugzilla.wikimedia.org/show_bug.cgi?id=27765 --- Comment #1 from Anton Kochkov 2011-02-27 18:28:40 UTC --- Also similar error was in this bug: https://bugzilla.wikimedia.org/show_bug.cgi?id=26295 -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
