Jump to content

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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;            }        }

Share this post


Link to post
Share on other sites

 

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.

Share this post


Link to post
Share on other sites

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.  ^_^

Share this post


Link to post
Share on other sites

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 )

 


2ekja6h.png

 

 

Edited by Virtue

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

@@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 !  :mellow:

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  :swt3: 

 

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.  :no1:

 

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

Edited by takari_L

Share this post


Link to post
Share on other sites

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 ! :mellow:

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 :swt3:

 

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. :no1:

 

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.