[racktables-users] Re: Error link ports after upgrade to 0.19.5

My colleague found the issues, an typo in the upgrade script:

 

Seems to be a code error in the file popup.php

 

Changing the tablename from Object to RackObject seems to fix it..... diff of 
old and new file below

 

# diff popup.php.old popup.php

48c48

< INNER JOIN Object o ON o.id = p.object_id

---

> INNER JOIN RackObject o ON o.id = p.object_id

 

 

Ray

 

From: racktables-users-bounce@xxxxxxxxxxxxx 
[mailto:racktables-users-bounce@xxxxxxxxxxxxx] On Behalf Of Lokkerbol, Cliff
Sent: 01 July 2011 09:57
To: racktables-users@xxxxxxxxxxxxx
Subject: [racktables-users] Re: Error link ports after upgrade to 0.19.5

 

Hi,

 

I can confirm we have the same issue. Also running Centos.

 

Thanks

This message was created by: 
Cliff Lokkerbol – System Support Specialist - Innovation I.T Services

"Simply put, it is possible to have convenience if you want to tolerate 
insecurity; but if you want security, you must be prepared for inconvenience."

 

From: racktables-users-bounce@xxxxxxxxxxxxx 
[mailto:racktables-users-bounce@xxxxxxxxxxxxx] On Behalf Of Ray Robertson
Sent: 01 July 2011 09:50
To: racktables-users@xxxxxxxxxxxxx
Subject: [racktables-users] Error link ports after upgrade to 0.19.5

 

Hi,

 

I’m unable to link any ports after upgrading (0.19.1-0.19.5). Any ideas?

Running on Centos 5.6.

 

Cheers,

Ray

Pdo exception: PDOException

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'racktable.Object' 
doesn't exist (42S02)

at file /opt/racktables-0.19.5/inc/database.php, line 2731

/opt/racktables-0.19.5/inc/database.php:2731 prepare('

SELECT

        p.id,

        p.name,

        p.reservation_comment,

        p.iif_id,

        p.type as oif_id,

        pii.iif_name,

        d.dict_value as oif_name,

        p.object_id,

        o.name as object_name

FROM Port p

INNER JOIN Object o ON o.id = p.object_id

INNER JOIN PortInnerInterface pii ON p.iif_id = pii.id

INNER JOIN Dictionary d ON d.dict_key = p.type

 

INNER JOIN (

        SELECT Port.id FROM Port

        INNER JOIN

        (

               SELECT DISTINCT pic2.iif_id

               FROM PortInterfaceCompat pic2

               INNER JOIN PortCompat pc ON pc.type2 = pic2.oif_id

WHERE pc.type1 = ? AND 

                       pic2.iif_id <> 1

        ) AS sub1 USING (iif_id)

        UNION

        SELECT Port.id

        FROM Port

        INNER JOIN PortCompat ON type1 = type

        WHERE

               iif_id = 1 and type2 = ?

) AS sub2 ON sub2.id = p.id

WHERE p.id <> ? AND p.id NOT IN (SELECT porta FROM Link) AND p.id NOT IN 
(SELECT portb FROM Link) AND o.name like ?  ORDER BY o.name')

/opt/racktables-0.19.5/inc/popup.php:113 usePreparedSelectBlade('

SELECT

        p.id,

        p.name,

        p.reservation_comment,

        p.iif_id,

        p.type as oif_id,

        pii.iif_name,

        d.dict_value as oif_name,

        p.object_id,

        o.name as object_name

FROM Port p

INNER JOIN Object o ON o.id = p.object_id

INNER JOIN PortInnerInterface pii ON p.iif_id = pii.id

INNER JOIN Dictionary d ON d.dict_key = p.type

 

INNER JOIN (

        SELECT Port.id FROM Port

        INNER JOIN

        (

               SELECT DISTINCT pic2.iif_id

               FROM PortInterfaceCompat pic2

               INNER JOIN PortCompat pc ON pc.type2 = pic2.oif_id

WHERE pc.type1 = ? AND 

                       pic2.iif_id <> 1

        ) AS sub1 USING (iif_id)

        UNION

        SELECT Port.id

        FROM Port

        INNER JOIN PortCompat ON type1 = type

        WHERE

               iif_id = 1 and type2 = ?

) AS sub2 ON sub2.id = p.id

WHERE p.id <> ? AND p.id NOT IN (SELECT porta FROM Link) AND p.id NOT IN 
(SELECT portb FROM Link) AND o.name like ?  ORDER BY o.name', Array

(

    [0] => 1322

    [1] => 1322

    [2] => 4879

    [3] => %ecdc04%

)

)

/opt/racktables-0.19.5/inc/popup.php:378 findSparePorts(Array

(

    [id] => 4879

    [object_id] => 583

    [name] => Port7

    [iif_id] => 1

    [oif_id] => 1322

    [l2address] => 

    [reservation_comment] => 

    [object_name] => SA-APC-BE08-3

    [oif_name] => AC-out

    [linked] => 0

    [iif_name] => hardwired

)

, Array

(

    [racks] => Array

        (

        )

 

    [objects] => ecdc04

    [ports] => 

)

)

: renderPopupPortSelector()

/opt/racktables-0.19.5/inc/functions.php:4618 
call_user_func_array('renderPopupPortSelector', Array

(

)

)

/opt/racktables-0.19.5/inc/popup.php:456 getOutputOf('renderPopupPortSelector')

/opt/racktables-0.19.5/index.php:193 renderPopupHTML()

Error info:

Array

(

    [0] => 42S02

    [1] => 1146

    [2] => Table 'racktable.Object' doesn't exist

)

Parameters:

GET

module

popup

helper

portlist

port

4879

filter-obj

ecdc04

filter-port

        

POST

        

COOKIE

__utma

94184329.1334049178.1307359800.1308147729.1309448051.5

__utmz

94184329.1307359800.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)

PHPSESSID

kl85u4c8bomni6onitn8ru4ql2

 

 

-- 

   

Ray Robertson 

Technical Architect 

 

T 01442 458375 
F 01442 458443
M 07718 358658
W  www.eckoh.com <http://www.eckoh.com/>  

 

Eckoh is a PCI DSS compliant Level One Service Provider.

 

Latest news:  

Eckoh appointed by NIE Energy to develop smartphone application
>> read full release 
>> <http://www.eckoh.com/news/latest-news/eckoh-appointed-by-nie-energy-to-develop-smartphone-application-/>
>>  

 

This communication contains information, which is confidential and may also be 
privileged. It is for the exclusive use of the intended recipient(s) only. If 
you are not the intended recipient(s) please note that any form of 
distribution, copying or use of this communication or the information in it is 
strictly prohibited and may be unlawful. If you have received this 
communication in error please return it to the sender and then delete it. 
Opinions expressed in this message are those of the author, and are not binding 
on the company. 

  

Registered in England and Wales, No. 2796531
Registered office: Telford House, Corner Hall, Hemel Hempstead, Hertfordshire 
HP3 9HN 

  

A member of the Eckoh Plc group of companies. 

 


________________________________________________________________________
Any opinions expressed in this email are those of the individual and not 
necessarily the company. The contents of this email and any attachments are 
confidential to The Innovation Group PLC and are solely for use by the intended 
recipient at the email address to which it has been addressed.

This email and any attachments may not be disclosed to or used by anyone other 
than the intended recipient, nor may it be copied in any way. If you have 
received this email in error, please forward a copy of this email to 
itsupport@xxxxxxxxxxxxxxxxxxxxxxx and then delete it from your system.

The Innovation Group PLC: Registered in England 3256771
Registered Office: Yarmouth House 1300 Parkway Solent Business Park Whiteley 
Hampshire PO15 7AE UK
http://www.innovation-group.com

This email and any attachments has been swept for computer viruses. Neither The 
Innovation Group PLC nor the sender accept any responsibility for computer 
viruses once this email has been transmitted.

JPEG image

Other related posts: