Difference between revisions of "Issues with the Wiki"

From ThinkWiki
Jump to: navigation, search
(Mysql problems after the mysql update)
(Reproduced the edit problem, added error message to entry)
Line 48: Line 48:
 
[[User:Wyrfel|Wyrfel]] 12:13, 24 January 2006 (CET)
 
[[User:Wyrfel|Wyrfel]] 12:13, 24 January 2006 (CET)
 
----
 
----
I have just got a MySQL problem when I edited a page, a query was not to its liking. Unfortunately, I didn't save the error message (sorry about that).
+
I have just got a MySQL problem when I edited a page, a query was not to its liking. It is quite easy to reproduce, just edit any page ;-)
  
 
History did get updated, and the page was also updated, so I have no idea what broke when that query failed.
 
History did get updated, and the page was also updated, so I have no idea what broke when that query failed.
This happened a few minutes after the MySQL update, and it looked like MySQL was taking exception for a duplicated key in a table.  I also recall something about multiple instances of "localhost" or somesuch.
 
  
Well, if it is there, someone else will hit it soon. This is just a head's up.
+
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
 +
(SQL query hidden)
 +
from within function "SearchMySQL4::update". MySQL returned error "1062: Duplicate entry ' ' for key 3 (localhost)".
  
[[User:Hmh|hmh]] 20:10, 2006-02-17 UTC
+
[[User:Hmh|hmh]] 20:12, 2006-02-17 UTC
  
 
== Troubles confirmed ==
 
== Troubles confirmed ==

Revision as of 22:28, 17 February 2006

This page is a provisorium. It's a list of things that are going wrong after the update to help Akw track and fix them.

Troubles encountered

You can't (easliy do a multiline cmdresult, can you? See:

foo bar baz

or

foo

 bar (after whitespace)
 baz (after whitespace)

This works (but is not so nice)

foo

bar (after empty line)

baz (after empty line)

Any suggestions?

Paul Bolle 10:27, 24 January 2006 (CET)


I think the best way is to use single cmdresult calls for each line and prefix them with a colon. Like so:

:{{cmdresult|foo}}
:{{cmdresult|bar}}
:{{cmdresult|baz}}

, which results in

foo
bar
baz

Alternatively, you can use <br /> at the ende of each line within one call, like this: {{cmdresult|foo<br /> bar<br /> baz}} , which will result in

foo
bar
baz

Wyrfel 12:13, 24 January 2006 (CET)


I have just got a MySQL problem when I edited a page, a query was not to its liking. It is quite easy to reproduce, just edit any page ;-)

History did get updated, and the page was also updated, so I have no idea what broke when that query failed.

A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
(SQL query hidden)
from within function "SearchMySQL4::update". MySQL returned error "1062: Duplicate entry ' ' for key 3 (localhost)".

hmh 20:12, 2006-02-17 UTC

Troubles confirmed

Fixed problems

  • http://thinkwiki.org/ reverted again to the default MediaWiki theme. Cannot reproduce this one (15.01.06, akw)
  • File upload is disabled - Argh. Fixed (15.01.06, akw)
  • URL contains index.php(/) before the actual page name - This has been fixed (28.05.05, akw)
  • The categories page doesn't link to Category:ThinkWiki - Fixed (29.05.05, akw)
  • http://thinkwiki.org/ is broken (no www prefix), this was working before - Fixed (29.05.05, akw)
  • On logging in a requester pops up asking to confirm a password change - seems like it's implicitly been fixed (29.05.2005, wyrfel)
  • In Navigation bar, "&lt;download&gt;" leads to [1] - fixed (30.06.2005)
  • direct link to Category:Models missing in Navigation Fixed (10.07.05, akw)
  • It seems the Wiki has trouble updating the edit history, i'm getting mysql query errors on saving pages. The pages get saved, however. Fixed (12.05.2005)