Viewing topic [FIXED] Article Manager in Admin CP doesn't work

Title: [FIXED] Article Manager in Admin CP doesn't work

muntdefems 23 Jul 2013

Link

When trying to manage the articles, once I choose a category or the inactive articles list all I get is a bogus paginator and the following message:

Warning: PDOStatement::execute(): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.category_id' in 'where clause' in /home/gamingonlinux/public_html/includes/class_mysql.php on line 77

0 Likes

Liam Dawe 24 Jul 2013

Link

Admin

View PC info

Fixed, the page has also been upgraded to show the new tags system and it even has an edit button (why did i only put a delete button in i've no idea). The page is a little less useless now.

0 Likes

muntdefems 24 Jul 2013

Link

Thanks, but there's still an error if selecting the "View inactive articles" option. The message is slightly different:

Warning: PDOStatement::execute(): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM `articles` a JOIN `users` u on a.author_id = u.user_id WHERE a.`active` = ' at line 1 in /home/gamingonlinux/public_html/includes/class_mysql.php on line 77

0 Likes

Liam Dawe 24 Jul 2013

Link

Admin

View PC info

There fixed it for you, now go break all the things.

0 Likes

muntdefems 24 Jul 2013

Link

Thank you, sir. :)

I only wanted to delete the first version I published of the latest Funding Crowd. I disabled it an removed it from the Home module, and then I couldn't access it any other way... :|

0 Likes

While you're here, please consider supporting GamingOnLinux on:

Reward Tiers: Patreon. Plain Donations:

PayPal.

This ensures all of our main content remains totally free for everyone! Patreon supporters can also remove all adverts and sponsors! Supporting us helps bring good, fresh content. Without your continued support, we simply could not continue!

You can find even more ways to support us on this dedicated page any time. If you already are, thank you!