Difference between revisions of "User:AsahiKaen/Sandbox3"

From A3! Wiki
m
Line 3: Line 3:
 
|fields=Blog_List.startdate = Date, CONCAT('[[File:',Blog_List.chara, ' SD Icon Round.png|33px|middle]] [[', Blog_List.chara,']]') = Author, CONCAT('[[Troupe Member Blog#Blog-',Blog_Content.number,'|',Blog_Content.title,']]') = Title, Blog_Content.translator = Translator
 
|fields=Blog_List.startdate = Date, CONCAT('[[File:',Blog_List.chara, ' SD Icon Round.png|33px|middle]] [[', Blog_List.chara,']]') = Author, CONCAT('[[Troupe Member Blog#Blog-',Blog_Content.number,'|',Blog_Content.title,']]') = Title, Blog_Content.translator = Translator
 
|where=(Blog_Content.type = 'Blog' AND Blog_Content.number > 155)
 
|where=(Blog_Content.type = 'Blog' AND Blog_Content.number > 155)
|group by=Blog_List.startdate desc
+
|group by=Blog_List.startdate
 +
|order by=Blog_List.number dsc
 
|format=dynamic table
 
|format=dynamic table
 
|limit=500
 
|limit=500
 
}}
 
}}

Revision as of 08:18, 26 May 2020

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `mw_cargo__Blog_List`.`startdate` AS `Date`,CONCAT('33px ', `mw_cargo__Blog_List`.`chara`,'') AS `Author`,CONCAT('',`mw_cargo__Blog_Content`.`title`,'') AS `Title`,`mw_cargo__Blog_Content`.`translator` AS `Translator` FROM `mw_cargo__Blog_List` LEFT OUTER JOIN `mw_cargo__Blog_Content` ON ((`mw_cargo__Blog_List`.number=`mw_cargo__Blog_Content`.number)) WHERE (`mw_cargo__Blog_Content`.`type` = 'Blog' AND `mw_cargo__Blog_Content`.`number` > 155) GROUP BY `mw_cargo__Blog_List`.`startdate` ORDER BY `mw_cargo__Blog_List`.`number` dsc LIMIT 500 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'dsc LIMIT 500' at line 1 (localhost)