CodeIgniter Forums
PyroCMS 0.9.8 RC1 | Comments SQL error - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=22)
+--- Thread: PyroCMS 0.9.8 RC1 | Comments SQL error (/showthread.php?tid=29097)

PyroCMS 0.9.8 RC1 | Comments SQL error - El Forum - 03-30-2010

[eluser]Stanfield[/eluser]
I recently installed PyroCMS and I have a problem when I click on "comments" in the backend. The link is :

Code:
HOST.COM/index.php/admin/comments

The error I get is :
Code:
Error Number: 1054

Unknown column 'TRUE' in 'where clause'

SELECT c.*, IF(c.user_id > 0, IF(u.last_name = "", u.first_name, CONCAT(u.first_name, " ", u.last_name)), c.name) as name, IF(c.user_id > 0, u.email, c.email) as email FROM (comments c) LEFT JOIN users u ON c.user_id = u.id WHERE IF(c.user_id > 0, c.user_id = u.id, TRUE) AND `c`.`is_active` = 0 ORDER BY c.created_on DESC LIMIT 10

Any idea ? thanks in advance

PyroCMS 0.9.8 RC1 | Comments SQL error - El Forum - 05-04-2010

[eluser]Nurdin Bekkeldiev[/eluser]
Hi all,

I have very important problem. I cant go forward to 1 step when installing PyroCMS.

IIS6, without rewrite support. PyroCMS 0.9.8 version, the latest version.

Have any idea?

PyroCMS 0.9.8 RC1 | Comments SQL error - El Forum - 05-04-2010

[eluser]Phil Sturgeon[/eluser]
We are discontinuing support of PyroCMS on these forums, come on over to http://pyrocms.com if you need help in the future, but one last post:

[quote author="Nurdin Bekkeldiev" date="1272987621"]Hi all,

I have very important problem. I cant go forward to 1 step when installing PyroCMS.

IIS6, without rewrite support. PyroCMS 0.9.8 version, the latest version.

Have any idea?[/quote]

Go to http://example.com/installer then when you click Step 1 you will go to http://example.com/installer/index.php/installer/step_1. This should work without any rewrite support. If it doesn't work, tough luck we don't support IIS.


[quote author="Stanfield" date="1269955795"]I recently installed PyroCMS and I have a problem when I click on "comments" in the backend. The link is :

Code:
HOST.COM/index.php/admin/comments

The error I get is :
Code:
Error Number: 1054

Unknown column 'TRUE' in 'where clause'

SELECT c.*, IF(c.user_id > 0, IF(u.last_name = "", u.first_name, CONCAT(u.first_name, " ", u.last_name)), c.name) as name, IF(c.user_id > 0, u.email, c.email) as email FROM (comments c) LEFT JOIN users u ON c.user_id = u.id WHERE IF(c.user_id > 0, c.user_id = u.id, TRUE) AND `c`.`is_active` = 0 ORDER BY c.created_on DESC LIMIT 10

Any idea ? thanks in advance[/quote]

Weird error, anything you can explain about your setup? I will change TRUE to 1 to make sure it works.