CORA™ CMS

[binbinH 0]

Help Please my servers are all running but it shows my servers aren't 

here's the link: http://avatar.ragnarok.onl/

and ive attached a SS also

 

Thanks for any help

[Takari 27]

Help Please my servers are all running but it shows my servers aren't 

 

here's the link: http://avatar.ragnarok.onl/

 

and ive attached a SS also

 

Thanks for any help

 

Hi! have you tried clicking on the "server status" button in your widget list (in the admin panel) ? .. If not, you may do so by accessing the admin page -> widgets -> click on server status (beside the arrow up/down button)

this will prompt widget options that you may customize. In this case, it will ask for your server's IP and ports.

[Mystery 594]

Looking good @@Roemy !

[Triedge 12]

A Database Error OccurredError Number: 1222The used SELECT statements have a different number of columnsSELECT * FROM ((SELECT * FROM (`tcp_shop`) JOIN `item_db2` ON `item_db2`.`id`=`tcp_shop`.`item_id`) UNION (SELECT * FROM (`tcp_shop`) JOIN `item_db_re` ON `item_db_re`.`id`=`tcp_shop`.`item_id`)) a ORDER BY `name_japanese` asc LIMIT 0, 10Filename: F:AppServwwwcorasystemdatabaseDB_driver.phpLine Number: 330

 

 

 

 

 

A Database Error OccurredError Number: 1222The used SELECT statements have a different number of columnsSELECT * FROM ((SELECT * FROM (`tcp_shop`) JOIN `item_db2` ON `item_db2`.`id`=`tcp_shop`.`item_id`) UNION (SELECT * FROM (`tcp_shop`) JOIN `item_db_re` ON `item_db_re`.`id`=`tcp_shop`.`item_id`)) a ORDER BY `name_japanese` asc LIMIT 0, 10Filename: F:AppServwwwcorasystemdatabaseDB_driver.phpLine Number: 330

 

 

 

Solved. Just adding Bindonequip to item_db2

 

In application/controller/shop.php

                if(isset($_GET['cat'])) {            switch($_GET['cat']) {                case 'consume':                    $cond = array('index'=>'item_db.type','val'=>array(0,2,11,18)); break;                case 'head':                    $cond = array('index'=>'equip_locations','val'=>array(1,256,257,512,513,768,769)); break;                case 'weapon':                    $cond = array('index'=>'item_db.type','val'=>array(5)); break;                case 'shield':                    $cond = array('index'=>'equip_locations','val'=>array(32)); break;                case 'armor':                    $cond = array('index'=>'equip_locations','val'=>array(16)); break;                case 'robe':                    $cond = array('index'=>'equip_locations','val'=>array(4)); break;                case 'shoes':                    $cond = array('index'=>'equip_locations','val'=>array(64)); break;                case 'accessories':                    $cond = array('index'=>'equip_locations','val'=>array(8,128,136)); break;                case 'pets':                    $cond = array('index'=>'item_db.type','val'=>array(7,8)); break;                case 'cards':                    $cond = array('index'=>'item_db.type','val'=>array(6)); break;                case 'costumes':                    $cond = array('index'=>'equip_locations','val'=>array(1024,2048,3072,4096,5120,6144,7168,8192));                case 'misc':                    $cond = array('index'=>'item_db.type','val'=>array(3,10)); break;            }        }

Change for:

        if(isset($_GET['cat'])) {            switch($_GET['cat']) {                case 'consume':                    $cond = array('index'=>'type','val'=>array(0,2,11,18)); break;                case 'head':                    $cond = array('index'=>'equip_locations','val'=>array(1,256,257,512,513,768,769)); break;                case 'weapon':                    $cond = array('index'=>'type','val'=>array(5)); break;                case 'shield':                    $cond = array('index'=>'equip_locations','val'=>array(32)); break;                case 'armor':                    $cond = array('index'=>'equip_locations','val'=>array(16)); break;                case 'robe':                    $cond = array('index'=>'equip_locations','val'=>array(4)); break;                case 'shoes':                    $cond = array('index'=>'equip_locations','val'=>array(64)); break;                case 'accessories':                    $cond = array('index'=>'equip_locations','val'=>array(8,128,136)); break;                case 'pets':                    $cond = array('index'=>'type','val'=>array(7,8)); break;                case 'cards':                    $cond = array('index'=>'type','val'=>array(6)); break;                case 'costumes':                    $cond = array('index'=>'equip_locations','val'=>array(1024,2048,3072,4096,5120,6144,7168,8192));                case 'misc':                    $cond = array('index'=>'type','val'=>array(3,10)); break;            }        }

[Takari 27]

 

A Database Error OccurredError Number: 1222The used SELECT statements have a different number of columnsSELECT * FROM ((SELECT * FROM (`tcp_shop`) JOIN `item_db2` ON `item_db2`.`id`=`tcp_shop`.`item_id`) UNION (SELECT * FROM (`tcp_shop`) JOIN `item_db_re` ON `item_db_re`.`id`=`tcp_shop`.`item_id`)) a ORDER BY `name_japanese` asc LIMIT 0, 10Filename: F:AppServwwwcorasystemdatabaseDB_driver.phpLine Number: 330

 

 

 

 

 

A Database Error OccurredError Number: 1222The used SELECT statements have a different number of columnsSELECT * FROM ((SELECT * FROM (`tcp_shop`) JOIN `item_db2` ON `item_db2`.`id`=`tcp_shop`.`item_id`) UNION (SELECT * FROM (`tcp_shop`) JOIN `item_db_re` ON `item_db_re`.`id`=`tcp_shop`.`item_id`)) a ORDER BY `name_japanese` asc LIMIT 0, 10Filename: F:AppServwwwcorasystemdatabaseDB_driver.phpLine Number: 330

 

 

 

Solved. Just adding Bindonequip to item_db2

 

In application/controller/shop.php

                if(isset($_GET['cat'])) {            switch($_GET['cat']) {                case 'consume':                    $cond = array('index'=>'item_db.type','val'=>array(0,2,11,18)); break;                case 'head':                    $cond = array('index'=>'equip_locations','val'=>array(1,256,257,512,513,768,769)); break;                case 'weapon':                    $cond = array('index'=>'item_db.type','val'=>array(5)); break;                case 'shield':                    $cond = array('index'=>'equip_locations','val'=>array(32)); break;                case 'armor':                    $cond = array('index'=>'equip_locations','val'=>array(16)); break;                case 'robe':                    $cond = array('index'=>'equip_locations','val'=>array(4)); break;                case 'shoes':                    $cond = array('index'=>'equip_locations','val'=>array(64)); break;                case 'accessories':                    $cond = array('index'=>'equip_locations','val'=>array(8,128,136)); break;                case 'pets':                    $cond = array('index'=>'item_db.type','val'=>array(7,8)); break;                case 'cards':                    $cond = array('index'=>'item_db.type','val'=>array(6)); break;                case 'costumes':                    $cond = array('index'=>'equip_locations','val'=>array(1024,2048,3072,4096,5120,6144,7168,8192));                case 'misc':                    $cond = array('index'=>'item_db.type','val'=>array(3,10)); break;            }        }

Change for:

        if(isset($_GET['cat'])) {            switch($_GET['cat']) {                case 'consume':                    $cond = array('index'=>'type','val'=>array(0,2,11,18)); break;                case 'head':                    $cond = array('index'=>'equip_locations','val'=>array(1,256,257,512,513,768,769)); break;                case 'weapon':                    $cond = array('index'=>'type','val'=>array(5)); break;                case 'shield':                    $cond = array('index'=>'equip_locations','val'=>array(32)); break;                case 'armor':                    $cond = array('index'=>'equip_locations','val'=>array(16)); break;                case 'robe':                    $cond = array('index'=>'equip_locations','val'=>array(4)); break;                case 'shoes':                    $cond = array('index'=>'equip_locations','val'=>array(64)); break;                case 'accessories':                    $cond = array('index'=>'equip_locations','val'=>array(8,128,136)); break;                case 'pets':                    $cond = array('index'=>'type','val'=>array(7,8)); break;                case 'cards':                    $cond = array('index'=>'type','val'=>array(6)); break;                case 'costumes':                    $cond = array('index'=>'equip_locations','val'=>array(1024,2048,3072,4096,5120,6144,7168,8192));                case 'misc':                    $cond = array('index'=>'type','val'=>array(3,10)); break;            }        }

Congratulations! I see you've already found an answer yourself. At first glance I thought it was a question similar to this.

But basing from the error message it might be a different matter after all. It seems that the tables in UNION does not have the same number of columns.

[anjasoleil0 0]

Site's still down? Any other link for the howto guide? 

[Mystery 594]

Site's still down? Any other link for the howto guide? 

Try HTTPS in the url.

[OverLord 4]

Have news about date release of new Cora CMS version (Multi-server support) ???

[Mystery 594]

Have news about date release of new Cora CMS version (Multi-server support) ???

We are in the progress of figuring out what is the best way to handle multi-server support. 

[Virtue 10]

Few Questions, can we run this on any OS? and it would be nice if we can access the install guide online, can't open this https://takaworks.net/cora/page/guide_installation


added @@takari_L on skype.


Always getting this on Admin log in tried using the default admin user/created one. solved removed md5 check on pw/admin.php ( notsure if its safe tho )

 

 

 

Edited June 24, 2015 by Virtue

[mrlongshen 22]

Need external link to download. someone please provide ?

[Virtue 10]

use github it works

[mrlongshen 22]

@@Virtue help me.

installation problem. 

dont have idea what to do.

have troubleshoot for 3 hours. zzz

http://herc.ws/board/topic/10153-cora-installation-problem/

[Hadeszeus 15]

I can't wait for the comeback of this next generation CP. Good luck everyone!

[mrlongshen 22]

@@Hadeszeus

 

help me ?

[mrlongshen 22]

how to create admin account ? 

I try to use my level 99 gm but i cant access the admin panel.

[OverLord 4]

Taka! Have news about the project? 5 months without updating Or Died Project?

[Virtue 10]

how to create admin account ? 

I try to use my level 99 gm but i cant access the admin panel.

try turning of the MD5 Hash not sure if that is safe though.

[mrlongshen 22]

@@Virtue i cant access the admin.

 

Someone have full guide or pdf ? please share with me ! the website down.

[Virtue 10]

its in the settings i think. I forgot where I found it. but when I turned it off I was able to access the admin page.

[Takari 27]

Planning to restart development of this project this holiday. I was wondering if anyone was still interested?

[mrlongshen 22]

@@takari_L I want ! Currently lack of support. Your website down. I hope you restart back.

Where you go man ? HAHA ! I love this cp you know ! 

Please make full tutorial back. 

[Virtue 10]

still waiting for you to finish this pm'd you on skype like a few months ago

[Takari 27]

@@takari_L I want ! Currently lack of support. Your website down. I hope you restart back.

Where you go man ? HAHA ! I love this cp you know ! 

Please make full tutorial back. 

 

 

still waiting for you to finish this pm'd you on skype like a few months ago

 

I'm very sorry for the inconvenience, I've been really busy irl   

 

Okay, if this is the case then I'll restart development during the holidays .. And while development is going on I'll put the website and full tutorials back online so you guys can use the old version for the meantime. 

 

EDIT: I'll post the link to the new website probably next week.

Edited December 14, 2015 by takari_L

[OverLord 4]

If need host for new website i provide

 

 

 

@@takari_L I want ! Currently lack of support. Your website down. I hope you restart back.

Where you go man ? HAHA ! I love this cp you know !

Please make full tutorial back.

still waiting for you to finish this pm'd you on skype like a few months ago

I'm very sorry for the inconvenience, I've been really busy irl

 

Okay, if this is the case then I'll restart development during the holidays .. And while development is going on I'll put the website and full tutorials back online so you guys can use the old version for the meantime.

 

EDIT: I'll post the link to the new website probably next week.